Case #2 MGT2315
There are two (2) Parts to this case.
The First part (Part 1) requires you to use the information to:
1. Build a Bill of Material (BOM) form the given information
2. Determine the Master Production Schedule (MPS) and
3. Complete the MRP for all parts including the product.
The Second Part (Part 2) will require you to use an indexed BOM to
1. Create the correct MPS from the provided information
2. create the MRP for the unit and all of its assemblies/components
The marks will be awarded as indicated below’
Part 1:
Item | Marks available | Marks Awarded |
Part 1 | ||
Correct BOM | 5 | |
Correct MPS for Product | 2 | |
Correct Gross requirement for each part | 9 | |
Correct Planned Order release for each part | 9 | |
Total Part 1 | 25 | |
Part 2 | ||
Correct Gross requirement for each part | 12 | |
Correct Planned Order release for each part | 13 | |
Total Part 2 | 25 | |
Total for Case | 50 | |
Product XYZ is described as follows: Quantity of each assembly/component is in (brackets)
XYZ are made up of assemblies A(3), B, & C(2)
Assembly A contains D(2), E(2), & F(3)
Assembly B contains part H(2)
Assembly C contains parts G(2) & E(2)
Inventory Lead- time and Lot Size Information:
XYZ | A | B | C | D | E | F | G | H | |
Lead Time | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 2 | 2 |
Projected On Hand | 93 | 125 | 32 | 92 | 520 | 391 | 600 | 125 | 68 |
Lot Size | LFL | LFL | 20 | 10 | LFL | 100 | 200 | 100 | 50 |
Scheduled Receipts | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 0 |
Safety Stock | 10 | 50 | 25 |
**Note** all scheduled receipts are in week 1
Create a product structure tree (Multilevel BOM): (5 marks)
Using Blank MRP sheets,
Create a level loaded (discreet, with no remnants) plan for XYZ’s based on a MPS of 40 per week (plan must be a minimum of 8 weeks).level 0 MPS (2 marks)
Create and complete an MRP plan for each item in the product tree. (18 marks)
Bruce’s Fans has just released an order for 500 50-cm fans due week 5 and 800 50-cm fans due week 7. Each fan consists of a housing assembly, 2 grills, a fan assembly, and an electrical unit. The breakdown of the assemblies and components is shown below. Quantities are numbers within (x). Using the information from the following table and the blank MRP sheets, construct the MRP Plan for the 50-cm Fan
Component | Lead Time | On hand Inventory | Lot Size | Safety Stock | Scheduled Receipts |
50-cm Fan | 1 | 100 | LFL | ||
Housing | 1 | 100 | LFL | ||
Frame | 2 | 0 | LFL | ||
Supports (2) | 1 | 50 | 100 | ||
Handle | 1 | 400 | 500 | ||
Grills (2) | 2 | 200 | 500 | ||
Fan Assembly | 3 | 150 | LFL | ||
Hub | 1 | 300 | LFL | ||
Blades (5) | 2 | 1400 | 100 | ||
Electrical Unit | 1 | 0 | LFL | ||
Motor | 1 | 0 | LFL | ||
Switch | 1 | 20 | 12 | ||
Knob | 1 | 0 | 15 | 200 Week 2 |
for MRP: excel sheet
for BOM:
11 have requested this problem solution
The more requests, the faster the answer.
Product XYZ is described as follows: Quantity of each assembly/component is in (brackets) XYZ are made up of assemblies A(3), B, & C(2) Assembly A contains D(2), E(2), & F(3) Assembly B contains part H(2) Assembly C contains parts G(2) & E(2) Inventory Lead- time and Lot Size Information: XYZABCDEFGHLead Time121112222Projected On Hand93125329252039160012568Lot SizeLFLLFL2010LFL10020010050Scheduled Receipts500000001000Safety Stock 105025 **Note** all scheduled receipts are in week 1 Create a product structure tree (Multilevel BOM): (5 marks) Using Blank MRP sheets, Create a level loaded (discreet, with no remnants) plan ...
There are two (2) Parts to this case. The First part (Part 1) requires you to use the information to:1. Build a Bill of Material (BOM) form the given information2. Determine the Master Production Schedule (MPS) and3. Complete the MRP for all parts including the product. The Second Part (Part 2) will require you to use an indexed BOM to 1. Create the correct MPS from the provided information2. create the MRP for the unit and all of its assemblies/components Part 1:...
Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty one units of Product Z are required in Period 10. (Assume that...
Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and four of D. D is made of two units of E. Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty units of Product Z are required in Period 10. (Assume that there...
Assume that Product Z is made of two units of A and four units of B. A is made of three units of C and three of D. D is made of three units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty seven units of Product Z are required in Period 10. (Assume that...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for item D. A 400 unit-delivery of product P is due at the beginning of week 7. Use the worksheet Product Structure Tree Inventory Information P Order Currently Scheduled Lead Item On-Hand Recpt (wk) Time Qty LAL P 100 L4L A A FIxed Q 450 Fixed Q = 600 L4L 0 C 90 100 (wk 2) 80 (wk 2) 2 50 2 C D(2 Beg...
One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time...
One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of...