Using Excel complete the following question.

(pls give a detailed answer about how to do it in excel)

The ABC Company is making a production plan for the next year, given the sales forecast for the next year as:

Quarter	1	2	3	4	Total
Sales Forecast (units)	20,000	16,000	24,000	19,000	79,000

Currently, the rm has 16 employees, and each employee can produce up to 1,000 units per quarter. The rm pays each employee $2,000 per quarter. The rm estimates its inventory carrying cost to be $2 per unit of ending inventory per quarter, its hiring cost to be $1,500 per employee, and its layoff cost to be $3,000 per employee. The company currently has an inventory of 1,000 units and wishes to have an ending inventory of at least 2,000 units at the end of the next year (i.e., quarter 4 only). The company does not plan to incur inventory shortages.

a. Using a chase strategy, determine a workforce level in each quarter and the total cost of the next year (labor cost, hiring cost, layoff costs, and inventory carrying cost).

b. Using a level strategy, determine a constant workforce level and the total cost of the next year (labor cost, hiring cost, layoff costs, and inventory carrying cost).

c. Compare the production plans obtained in parts a) b). Which production plan would you recommend, and why?

d. Using Excel Solver, determine the optimal plan and the total cost of the next year. Use the SOP Example discussed in class as a reference.

thank you!