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.

3. The Paris Paint Company is in the process of planning labor force requirements and production levels for the next four quarters. The marketing department has provided production with the following forecasts of demand for Paris Paint over the next year: Assume that there are currently 280 employees with the company. Employees are hired for at least one full quarter. Hiring costs amount to $1,200 per employee and firing costs are $2,500 per employee. Inventory costs are $1 per gallon per quarter. It is estimated that one worker produces 1,000 gallons of paint each quarter. Assume that Paris currently has 80,000 gallons of paint in inventory and would like to end the year with an inventory of at least 20,000 gallons