with the 12 given forcast please complete the table using the chase demand strategy . show work using excel to complete the table for the missing columns of production , inventory , # of workers needed, # of new hires , and # of layoffs . show all formulas used please . also find the total cost . ( this is a chase demand production plan ) . all info to finish the table is listed above it . please and thank you so much

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 #of new hires #of Layoffs 39 40 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 Costa 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 o Use Chase demand strategy to devlop plan Production Inventory # of workers needed #of new hires # of Layoffs Forecast2019 56188 64115 22487 27861 26193 15996 1 17342 1 18880 2 20107 .9 59381 51 88542 33 79567 Total