Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Prepare a master schedule given this information: It is now the end of week 1; c

ID: 419832 • Letter: P

Question

Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2,16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on- hand inventory would be negative without production. Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used (Leave no cells blank - be certain to enter "O" wherever required.) June Jul 3 4 30 30 30 30 40 40 40 40 Forecast Customer orders (committed) Projected on- hand inventory MPS ATP 25 16

Explanation / Answer

Week 1 2 3 4 5 6 7 8 Forecast 30 30 30 30 40 40 40 40 Orders 33 25 16 11 8 3 0 0 Inv. 64 34 4 44 4 34 64 24 MPS 0 0 0 70 0 70 70 0 ATP 23 0 0 51 0 67 70 0