[solved]-Prepare Master Schedule Given Information End Week 1 Customer Orders 25 Week 2 16 Week 3 1 Q39700561

Prepare a masterschedule 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, 8for week 5, and 3 for week 6. Use the MPS rule of orderingproduction when projected on-hand inventory would be negativewithout production. Suppose that there are currently 64 pumps ininventory and a production lot size of 70 pumps is used.(Leave no cells blank – be certain to enter “0” whereverrequired.)

JuneJuly12345678Forecast3030303040404040Customer orders(committed)3325161183Projectedon-hand inventoryMPSATP

Expert Answer

---

Answer to Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for… . . .