Plese Use Excel and provided Your formulas.

The available planning information is as follows

Sales Plan

Additional assumptions

Part$-$time employees may not work overtime.

Assume $100$ percent utilization of employees on regular time $($i$.$e$.,$ all employees on the

payroll during a period produce at least $500$ units$).$ If overtime is used, up to another

$200$ units can be produced per employee.

a$.$ Develop an operations plan that utilizes a level, or constant, rate of output each quarter using fall$-$time regular employees only. Ending inventory and back orders for quarter $4$ must be equal to zero. Summarize the plan, its costs, and its consequences

b$.$ Prepare a cumulative chart for your plan in part a of this problem.

c$.$ If each shipping container for completed jet skis and snowmobiles requires $20$ cu ft$.$ of space, what is the maximum finished$-$goods warehouse space you will need next year if the plan in part b of this problem is adopted?

d$.$ If the cost of each completed end item is $$600,$ what is the maximum amount of capital that will be tied up in finished$-$goods inventory during the year?