Please answer in excel format with the formulas showing. Screenshots work perfectly!

Answer the following question as completely as possible. Please do not wrote in column A. Excelsior Clay works, a fictional manufacturer of a variety of high-quality glazed clay roof tiles in Kerala, India, has the following composite demand forecasts (in hundreds of units): $ $ Additional Planning Data Hiring costs Firing costs Regular Time costs Overtime Costs idle time cost inventory carrying costs backorder costs Productivity Workforce size at the beginning of January Beginning Inventory at the beginning of January $ $ $ $ $ 400 per worker hired 200 per worker fired 100 per worker per day 150 per worker per day 60 per worker per day 10 per hundred units per month 20 per hundred unites (based on shortages at the end of the month) 100 units per worker per day 20 workers 0 units Develop a sales and operations plan using the following strategies a. A level strategy of constant workforce and inventories and backorders to meet demand variations. b. A chase strategy with the options of hiring and firing workers