Question: Exponential Smoothing. Use Excel Spreadsheet ( Copy the table below and Paste it into Excel ) . The following tabulations are actual sales of units

Exponential Smoothing. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). The following tabulations are actual sales of units for six months and a starting forecast in January. (F1: initial forecasting value, in this case, FJan=77)
Calculate forecasts for May using exponential smoothing with alpha =0.4. Round your answer to the nearest whole number.
Actual Forecast (ES with alpha =0.4)
January 9777
February 93
March 100
April 75
May 79?
June 108
Question 8 options:
93
77
86
83

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!