Do not use Excel. Use Microsoft word. Please show work with calculations and how you used the calculations step by step so I can learn and begin doing it myself. Use the data in the tables (Cost data, Production data, Month/Demand/Days data) to find answers. Explain with detail and show steps. Do not use excel. Microsoft word with steps and formulas of calculations on how to find answers. Thank you.

The Kebab House is a major producer of kebabs. The following are the estimates of demand, cost, and production data for the next six months. + Cost Data Hiring cost/worker N/A Layoff cost/worker N/A Straight time cost/hour $12 Holding cost/unit/month $4 Backorder cost/unit/month $91 Subcontracting cost/unit $25 Overtime cost/hour $20 8 4. Production Data Working hours/day Labout requirement (hours/unit) Safety stock Beginning inventory (units) Planning horizon (months) 0 300 6 Demand Working Month Forecast Days March 1000 19 April 1300 20 May 800 21 June 600 20 July 800 21 August 1000 19 a. Constant Workforce Plan; Varying Inventory and Stockouts. Use a constant workforce large enough to produce enough units over the six months to meet total forecast demand. All workers must be full-time workers. Assume stockouts result in backorders which must be satisfied from production in following periods. b. Constant Workforce Plan; Overtime. Use a constant workforce of 20 workers and use overtime to meet any additional output requirements