Question: Important: This is an individual assignment, you are NOT allowed to receive or give assistance of any kind This assignment has TWO spreadsheets. Show your
Important: This is an individual assignment, you are NOT allowed to receive or give assistance of any kind This assignment has TWO spreadsheets. Show your work. Forecast demand for quarters 1 to 13, using Adjusted Exponential Smoothing (alpha = .3, beta = .4) Please enter your results in the yellow boxes Adj Exp Sm Year Quarter Demand Forecast 1 1 23 2 35 3 40 4 33 2 5 25 6 33 7 37 8 30 3 9 22 10 37 11 39 12 32 4 13 Calculate the MAD and enter value in yellow box below: MAD = Important: This is an individual assignment, you are NOT allowed to receive or give assistance of any kind This assignment has TWO spreadsheets. Show your work. Forecast demand for quarters 1 to 16, using Seasonal Factors / Linear Regression Please enter your results in the yellow boxes Seasonal Factors/Linear Regression Year Quarter Demand Forecast 1 1 23 2 35 3 40 4 33 2 5 25 6 33 7 37 8 30 3 9 22 10 37 11 39 12 32 4 13 14 15 16 Calculate the MAD and enter value in yellow box below: MAD =
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
