Problem 11-20 (Static) 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 were 64 pumps in inventory at the beginning of week 1. A production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "O" wherever required.) June July 1 2 3 4 5 6 7 8 30 40 40 40 30 33 30 25 30 16 40 3 11 8 Forecast Customer orders (committed) Projected on-hand inventory MPS ATP b. Would the total cost be less with full regular production each period with no overtime, but using a subcontractor to handle the excess above regular capacity at a cost of $53 per hundred bolts? Backlogs are not allowed. The inventory carrying cost is $2 per hundred bolts. (Round your Average inventory values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 2 4 5 6 7 Total Forecast 275 350 225 300 280 275 270 1,975 Output Regular Subcontracting Inventory Beginning Ending Average Cost Regular Subcontracting Inventory Total