Can you do Quarter 1-4 and total cost for Plan B and Plan C

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: Click the icon to view the demand forecast. 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,100 cases per quarter and meets the forecast demand with inventory and subcontracting. a) Which strategy is the lowest-cost plan? Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). The total cost, including normal time labor costs, for this hiring and layolts plan is $252.500 (enter your response as a whole number). More Info \begin{tabular}{l} Costs/Other Data \\ \hline Previous quarter's output =1,300 cases \\ Beginning inventory =0 cases \\ Stockout cost of backorders =$140 per case \\ Inventory holding cost =$40 per case at end of quarter \\ Hiring employees =$40 per case \\ Terminating employees =$80 per case \\ Subcontracting cost =$65 per case \\ Unit cost on regular time =$25 per case \\ Overtime cost =$10 extra per case \\ Capacity on regular time =1,700 cases per quarter \end{tabular} The total cost, including normal time labor costs, for this hiring and layoffs plan is $252,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)