Chapter 12.pdf - Assignment Print View Score 50\/50 Points 100 http\/ezto.mheducation.com\/hm.tpx?todo=printview 1\/13 1 Assignment Print View Award 10 out

# Chapter 12.pdf - Assignment Print View Score 50/50 Points...

This preview shows page 1 - 4 out of 13 pages.

9/9/2017 Assignment Print View 1/13 Score: 50/50 Points 100 %
9/9/2017 Assignment Print View 2/13 1. Award: 10 out of 10.00 points Problem 12-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. (Leave no cells blank - be certain to enter "0" wherever required.) Part D Beg. Inv. 1 2 3 4 5 6 7 Gross requirements 0 0 0 260 0 240 120 Scheduled receipts 0 50 0 50 0 50 0 On hand 20 70 70 120 10 60 20 Net requirements 0 0 0 140 0 180 100 Planned-order receipt 0 0 0 150 0 200 100 Planned-order release 0 150 0 200 0 100 50 References Worksheet Learning Objective: 12-02 Describe the inputs, outputs, and nature of MRP processing. Problem 12-7 Learning Objective: 12-03 Explain how requirements in a master production schedule are translated into material requirements for lower-level items. Problem 12-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. (Leave no cells blank - be certain to enter "0" wherever required.) Part D Beg. Inv. 1 2 3 4 5 6 7 Gross requirements 0 0 0 260 0 240 120 Scheduled receipts 0 50 0 50 0 50 0 On hand 20 70 70 120 10 60 20 Net requirements 0 0 0 140 0 180 100 Planned-order receipt 0 0 0 150 0 200 100 Planned-order release 0 150 0 200 0 100 50
9/9/2017 Assignment Print View 3/13 Explanation: Master Schedule for X: Week Beg. Inv. 1 2 3 4 5 6 7 8 Quantity 80 30 Week Part X Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements 80 30 Scheduled receipts On hand Net requirements 80 30 Planned order receipt 80 30 Planned order release 80 30 Week Part B Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements 160 60 Scheduled receipts On hand 30 30 30 30 30 30 0 0 0 Net requirements 130 60 Planned order receipt 130 60 Planned order release 130 60 *Note that the lead time is a function of the lot size. Lead-time = 1 week for 1 –100 units, 2 weeks for 101 – 200 units, 3 weeks for 201 – 300 units, 4 weeks for 301 or more units.

#### You've reached the end of your free preview.

Want to read all 13 pages?

• Spring '13
• Cronce,Gregory