Develop a simple production plan for year 5 -- a level production plan, a chase-demand production plan, or a mixed production plan -- that will meet the estimated demand and avoid stock-outs.

a) Pick one of the strategies suggested above. Make sure you meet demand every month and that you have some amount of leftover inventory at the end of each month in order to accommodate deviations between estimated demand and actual sales in year 5. Inventory at the end of year 4 is zero (0).

b) Information about inventory holding costs or opportunity costs for lost sales is not provided. There are many acceptable production plans.n

use chase demand strategy and fill out table with info provided above table ans the forecast already listed in the table . please use excel

and show all work and formulas used so i can finish the tabel on my excel spreadsheet. also find the total cost . all info is provided . I incuded four pictures incase somes are unclear but i need to fill out that table for the 12 listed forcast (2019) and fill out the other colums for production , inventory , # of workers needed , # of new hires, and # of layoffs . please and thank you so much . use the chase demand strategy please .

M N Production cost $75 unit Inventory cost-$5 unlt/month productivity - 1,000 units/workers Intial workforce negative Inventory(backlog) cost 10/unit/month hiriring cost-firing cost-$2,000/worker Intial workforce Use Chase demand strategy to devlop plan Inventory of workers needed Wof new hires of Layoffs 18 09 10 01 42 43 44 45 46 47 48 49 Forecast2019 50 51 52 53 54 55 56 57 58 59 60 61 62 Total 63 64 65 66 67 Total Cost Production 56188 64115 22487 27861 26193 15996 17342 18880 20107 59381 88542 79567 Production cost $75 unit Inventory cost = $5 unit/month productivity = 1,000 units/workers Intial workforce=0 negative inventory(backlog) cost=10/unit/month hiriring cost-firing cost - $2,000/worker Intial workforce=0 Use Chase demand strategy to devlop plan Inventory # of workers needed Wof new hires of layoffs Forecast2019 0 1 -2 53 54 55 56 57 58 59 60 61 62 Total 63 64 65 G 67 Total Cost Production 56188 64115 22487 27861 26193 15996 17342 18.880 20107 59381 BAS42 79562 39 fx Production cost $75 unit R a o P N M B 19 10 Production cost $75 unit Inventory cost - $5 unit/month productivity = 1,000 units/workers Intial workforce=0 negative inventory(backlog) cost-10/unit/month hiriring cost-firing cost = $2,000/worker Intial workforce Use Chase demand strategy to devlop plan Inventory # of workers needed Wof new hires #of Layoffs 41 42 43 44 45 46 47 48 49 Forecast2019 50 51 52 53 54 55 56 57 58 59 60 61 62 Total 63 64 65 66 67 Total Cost 68 Production 56188 64115 22487 27861 26193 15996 17342 18880 20107 59381 88542 79567 riventory # of workers needed #of new hires #of Layoffs 8 9 Production cost $75 unit 0 1 Inventory cost - $5 unlt/month 32 productivity = 1,000 units/workers 13 Intial workforce=0 14 negative inventory(backlog) cost-10/unit/month 35 hiriring cost-firing cost = $2,000/worker 16 Intial workforce=0 47 Use Chase demand strategy to devlop plan 48 49 Forecast2019 Production 50 56188 51 64115 52 22487 53 27861 54 26193 55 15996 56 17342 57 18880 58 20107 59 59381 60 88542 61 79567 62 Total 63 64 65 66 67 Total Cost 68