Solve the following problem using Excel Solver

a) Formulate the problem as an Mixed Integer LP problem

b) Look for employment by presuming:

- Cost minimization

- Chase strategy

- Leveling strategy

c) Report the following metrics for each of the strategies in the previous point: Total number of employees hired, total number of employees fired, total inventory, and total cost.

35. The Mr. Meadows Cookie Company can obtain accurate forecasts for 12 months based on firm orders. These forecasts and the number of workdays per month are as follows: During a 46-day period when there were 120 workers, the firm produced 1,700,000 cookies. Assume that there are 100 workers employed at the beginning of month 1 and zero starting inventory