BSOP 334 Week 5 Lab MRP Complicating Factors and MRP-II, ERP, & Supply Chain Management

This file of BSOP 334 Week 5 Lab MRP Complicating Factors and MRP-II, ERP, & Supply Chain Management comprehends:

Chapter 12: Problems 5, 6, 7 (pp. 544-545)

5. End item P is composed of three subassemblies: K, L, and W. K is assembled using 3 Gs and 4 Hs, L is made of 2 Ms and 2 Ns, and W is made of 3 Zs. On-hand inventories are 20 Ls, 40 Gs, and 200 Hs. Scheduled receipts are 10 Ks at the start of week 3, 30 Ks at the start of week 6, and 200 Ws at the start of week 3.

6. A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units at the beginning of day 5, and 200 units at the beginning of day 7. Receipts of 100 wood sections are scheduled at the beginning of day 2. There are 120 legs on hand. An additional 10 percent of the order size on legs is added for safety stock. There are 60 braces on hand with no safety stock requirement for braces. Lead times (in days) for all items are shown in the following table. Prepare a material requirements plan using lot-for-lot ordering.

7. Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8. Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units.