Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: BClick the icon to view the demand forecast. E: Click the icon to view the cost data. John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. Plan B: a level strategy Plan C: a level strategy that produces 1,000 cases per quarter and meets the forecast demand with inventory and subcontracting. The total cost, including normal time labor costs, for this hiring and layoffs plan is $ 277,500 (enter your response as a whole number) Construct a plan that holds employment steady (level strategy) by producing the average forecast for all four quarters (enter your responses as whole numbers). Hire Layoff (Units) Quarter Level Plan Ending Production Inventory Shortage 1,300 1350 0 350 Forecast (Units) 1 1,700 50 'o o 2 1,100 1350 100 Forecast Quarter 1 2 3 4 1,700 1,100 1,600 1,000 Costs/Other Data Previous quarter's output = 1,300 cases Beginning inventory = 0 cases Stockout cost of backorders = $160 per case Inventory holding cost = $40 per case at end of quarter Hiring employees = $35 per case Terminating employees = $70 per case Subcontracting cost = $65 per case Unit cost on regular time = $30 per case Overtime cost = $20 extra per case Capacity on regular time = 1,700 cases per quarter Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: BClick the icon to view the demand forecast. E: Click the icon to view the cost data. John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. Plan B: a level strategy Plan C: a level strategy that produces 1,000 cases per quarter and meets the forecast demand with inventory and subcontracting. The total cost, including normal time labor costs, for this hiring and layoffs plan is $ 277,500 (enter your response as a whole number) Construct a plan that holds employment steady (level strategy) by producing the average forecast for all four quarters (enter your responses as whole numbers). Hire Layoff (Units) Quarter Level Plan Ending Production Inventory Shortage 1,300 1350 0 350 Forecast (Units) 1 1,700 50 'o o 2 1,100 1350 100 Forecast Quarter 1 2 3 4 1,700 1,100 1,600 1,000 Costs/Other Data Previous quarter's output = 1,300 cases Beginning inventory = 0 cases Stockout cost of backorders = $160 per case Inventory holding cost = $40 per case at end of quarter Hiring employees = $35 per case Terminating employees = $70 per case Subcontracting cost = $65 per case Unit cost on regular time = $30 per case Overtime cost = $20 extra per case Capacity on regular time = 1,700 cases per quarter