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.

26. A local semiconductor firm, Superchip, is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production measure. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Inventory holding costs are based on a 25 percent annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December next year. It is estimated that each worker accounts for an average of $60,000 of production per year (assume that one year consists of 250 working days). The cost of hiring a new worker is $200, and the cost of laying off a worker is $400. 26. A local semiconductor firm, Superchip, is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production measure. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Inventory holding costs are based on a 25 percent annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December next year. It is estimated that each worker accounts for an average of $60,000 of production per year (assume that one year consists of 250 working days). The cost of hiring a new worker is $200, and the cost of laying off a worker is $400