Solve in excell by using: 1) Chase strategy (zero inventory) 2) Level strategy (constant work force)

********** PLEASE PROVIDE ALL FORMULAS USED IN EXCELL ******************

Densepack is to plan workforce and production levels for the six-month period January to June. The firm produces a line of disk drives for mainframe computers that are plug compatible with several computers produced by major manufacturers. Forecast demands over the next six months for a particular line of drives produced in the Milpitas, California, plant are 1,280, 640, 900, 1,200, 2,000, and 1.400. There are currently end of December) 300 workers employed in the Milpitas plant. Ending inventory in December is expected to be 500 units, and the firm would like to have 600 units on hand at the end of June. Month Net Predicted Demand Net Cumulative Demand January 780 780 February 640 1,420 March 900 2,320 April 1,200 3,520 May 2,000 5,520 June 2,000 7,520 CH = Cost of hiring 1 worker is $500 CF = Cost of firing one worker is $1,000 CI = Cost of holding one unit of inventory for one month is $80 K= numberof aggregate units prouced by one worker in one day K = 0.14653 working days per month; 20, 24, 18, 26, 22 and 15 for January to June 7 5 Cumulative number of units thousands) Feasible production schedule Cumulative net demand 3 2 Inventory Month