Please and A, B, and C with this format below

Consiter the follnwing information and use an Excel worksheet for all calculations - Regular Time: $20 per unit (150 units per period maximum) - Part Time: $25 per unit (no limit) - Overtime: $30 per unit (20 units per period maximum) - Subcontract: $40 per unit (no limit) - Hire/Layoff Cost: - Each employee can produce 10 units per month using regular time. - Currently, 15 employees are hired. - Cost of Hire =$100 Number of new hired regular employees - Cost of Layoff =$100 Number of laid-off regular employees - Beginning Inventory: None - Inventory carrying cost: $5 per unit per period (measured by ending inventory) - Backorder Cost: $20 per unit per period a) Using the level strategy with maximum regular capacity and part time/overtime, what is the total cost? Show the details of production and related costs. b) Using the chase strategy with regular capacities, what is the total cost? Show the details of production and related costs. c) Propose an optimal solution to minimize total costs. \begin{tabular}{|l|c|c|c|c|c|c|} \cline { 2 - 7 } & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline Cumulative Forecast & 200 & 400 & 700 & 1,300 & 1,800 & 2,100 \\ \hline Cumulative Production & 300 & 600 & 900 & 1,200 & 1,500 & 1,800 \\ \hline Ending Inventory & 100 & 200 & 200 & & & \\ \hline Backlog & & & & 100 & 300 & 300 \\ \hline \end{tabular} Consiter the follnwing information and use an Excel worksheet for all calculations - Regular Time: $20 per unit (150 units per period maximum) - Part Time: $25 per unit (no limit) - Overtime: $30 per unit (20 units per period maximum) - Subcontract: $40 per unit (no limit) - Hire/Layoff Cost: - Each employee can produce 10 units per month using regular time. - Currently, 15 employees are hired. - Cost of Hire =$100 Number of new hired regular employees - Cost of Layoff =$100 Number of laid-off regular employees - Beginning Inventory: None - Inventory carrying cost: $5 per unit per period (measured by ending inventory) - Backorder Cost: $20 per unit per period a) Using the level strategy with maximum regular capacity and part time/overtime, what is the total cost? Show the details of production and related costs. b) Using the chase strategy with regular capacities, what is the total cost? Show the details of production and related costs. c) Propose an optimal solution to minimize total costs. \begin{tabular}{|l|c|c|c|c|c|c|} \cline { 2 - 7 } & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline Cumulative Forecast & 200 & 400 & 700 & 1,300 & 1,800 & 2,100 \\ \hline Cumulative Production & 300 & 600 & 900 & 1,200 & 1,500 & 1,800 \\ \hline Ending Inventory & 100 & 200 & 200 & & & \\ \hline Backlog & & & & 100 & 300 & 300 \\ \hline \end{tabular}