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

ple use exel to do this lab question ple use exel to do this lab question The table below shows

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!