A manager has projected demand for the next six months (below). Given this information, prepare a LEVEL aggregate plan for production. Assume maximum regular time production is 350 units per month. Overtime is limited to 75 units per month. The limit for subcontracting is 400 per month. The company has a zero beginning inventory and cannot have ending inventory or a backlog at the end of the 6th period. Unit costs are as noted below. Regular Time Cost: $10/unit Overtime Cost: $15/unit Subcontracting Cost: $20/unit Inventory Holding Cost: $4/unit Backorder Cost: $25/unit Projected Demand: Month Forecast 500 440 300 370 550 450 5 6 TOTAL Period FORECAST 1 S00 2 40 6 450 4 300 370 550 OUTPUT Regular Overtime Subcontract Output - Forecast INVENTORY Beginning Ending 0 Average Backorder COSTS Output Regular Overtime Subcontract Inventory Backorders TOTAL Complete the above plan correctly. (12 points) If your budget for this plan is $50,000, is it acceptable? (1 pt) Will staff be happy with this plan? (1 pt) Yes or No Yes or No Why/Why Not? (Answer = LESS THAN 5 WORDS) Will customers be happy with this plan? (1 pt) Yes or No Why/Why Not? (Answer LESS THAN SWORDS) Recommend one long-term, strategic improvement for this plan (to increase employee and customer satisfaction). what would it be? State/defend your answer in one very brief sentence. Do not write more than one. (5 pts) What? Why