Question: 3 Instructions - Forecast Planning The table below shows the demand for a printer in a department store in each of the last twelve months.
3 Instructions - Forecast Planning The table below shows the demand for a printer in a department store in each of the last twelve months. Answer the 4 questions below. EMA = Period 1 2 3 4 5 6 7 8 9 10 11 12 13 Month January February March April May June July August September October November December January Demand 12 15 19 23 27 30 32 33 37 41 49 58 ??? ANSWERS 1) Calculate the four month moving average for months 4 to 12. What would be your forecast for the demand in month 13? (4 marks) 2) Apply exponential smoothing with a smoothing constant of 0.2 to derive a forecast for the demand in month 13. (4 marks) 3) Which of the two forecasts for month 13 do you prefer and why? (4 marks) 4) What other factors, not considered in the above calculations, might influence demand for the printer in month 13
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
