50.1K

Verified Solution

Link Copied!

based on the 12 month forcast given can you please finish the table using the chase demand strategy. forecast already given and total of forecast . please fill out the missing columns. all info is above the table . please use excel to show work and show all formulas used so i can finish it on my excel

please and thank you so mych i hope that its possible to answer this . i need to finish this chase demand strategy table.

Inventory of workers needed #of new hires Wof Layoffs 38 39 Production cost $75 unit 40 41 inventory cost = $5 unit/month 42 productivity = 1,000 units/workers 43 Intial workforce 44 negative inventory(backlog) cost = 10/unit/month 45 hiriring cost-firing cost-$2,000/ worker 46 Intial workforce 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 79562 62 496659 63 Total A 64 65 66 67 Total Costs 68 KO Production cost $75 unit Inventory # of workers needed #of new hires #of Layoffs 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 workforcer o Use Chase demand strategy to devlop plan Forecast2019 Production 56188 64115 22487 27861 26193 15996 17342 18880 20107 59381 88542 79567 496659 Total 6 ? Total Cost Inventory of workers needed #of new hires Wof Layoffs 38 39 Production cost $75 unit 40 41 inventory cost = $5 unit/month 42 productivity = 1,000 units/workers 43 Intial workforce 44 negative inventory(backlog) cost = 10/unit/month 45 hiriring cost-firing cost-$2,000/ worker 46 Intial workforce 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 79562 62 496659 63 Total A 64 65 66 67 Total Costs 68 KO Production cost $75 unit Inventory # of workers needed #of new hires #of Layoffs 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 workforcer o Use Chase demand strategy to devlop plan Forecast2019 Production 56188 64115 22487 27861 26193 15996 17342 18880 20107 59381 88542 79567 496659 Total 6 ? Total Cost

Answer & Explanation Solved by verified expert

See Answer