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

A D E F G H J K - L M N Q 1 B Problem 41 worth 10 points total. Answer the following question as completely as possible. Please do not wrote in column A. 2 3 Jan Jul Oct Month Work Days Forecast 4 Feb 22 200 Mar 20 300 Apr 23 350 May 22 600 Jun 24 22 150 Aug 23 190 Sep 17 260 21 360 Nov 22 490 Dec 20 340 20 160 5 450 6 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): 7 8 9 10 $ 11 $ $ $ 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 o units 12 13 14 15 16 17 18 19 20 21 S $ Develop a sales and operations plan using the following strategies 22 23 a. A level strategy of constant workforce and inventories and backorders to meet demand variations. 24 b. A chase strategy with the options of hiring and firing workers. 25 26 27 28 29