Question: 4. An existing customer in the North Eastern U.S. has provided the following sales data. Awesome would like to use it to plan. Create the

4. An existing customer in the North Eastern U.S.
4. An existing customer in the North Eastern U.S. has provided the following sales data. Awesome would like to use it to plan. Create the following: 1. A moving average forecast. 2. An exponential smoothing forecast using alpha=0.30. 3. An exponential smoothing forecast using alpha=0.60. Demand Month January February March April May June July August September October November December January February 650 550 450 800 750 1050 1200 1500 2175 2400 2775 1800 1200 750 Which provides the best forecast given the actual demand. Provide reasons for your answer. Is there seasonality in the data? Calculate the quarterly seasonal relatives and apply them to your forecast where you used alpha=0.30. Remember, first you create the forecast and then you apply the seasonal relative. Is the forecast improved through the application of the seasonal relatives

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 General Management Questions!