Attached please find my question. I need the answer for (b) only.

How can I make thespreadsheet of chase strategy by using Excel?

Thank you,

5. Management at the Kerby Corporation has determined the following aggregated demand schedule (in units): An employee can produce an average of 10 units per month. Each worker on the payroll costs $2,000 in regular-time wages per month. Undertime is paid at the same rate as regular time. In accordance with the labor contract in force, Kerby Corporation does not work overtime or use subcontracting. Kerby can hire and train a new employee for $2,000 and lay off one for $500 . inventory costs $32 per unit on hand at the end of each month. At present, 140 employees are on the payroll and anticipation inventory is zero. a. Prepare a production plan that only uses a level workforce and anticipation inventory as its supply options. Minimize the inventory left over at the end of the year. Layoffs, undertime, vacations, subcontracting, backorders, and stockouts are not options. The plan may call for a onetime adjustment of the workforce before month 1 begins. b. Prepare a production plan using a chase strategy, relying only on hiring and layoffs