Question: ple use exel to do this lab question The table below shows the demand for a new aftershave in a shop for each of the
The table below shows the demand for a new aftershave in a shop for each of the last 7 months. Month Demand 1 23 2 29 3 33 4 40 5 41 6 43 7 49 a) Calculate a two-month moving average for months two to seven. What would be your forecast for the demand in month eight? b) Apply exponential smoothing a smoothing constant of 0.6 and then with 0.9 to derive a forecast for the demand in month eight. c) With MAD as the criterion, which of the four forecasting methods is best
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
