Based on the table below, calculate the forecast for July using exponential smoothing. Use an alpha factor (a) of 0.2 in the calculation.
Month Actual demand Forecast Alpha factor
January 148 157
February 148 157
March 167 157
April 167 157
May 225 170
June 245 181
July
If the forecast for July is 241 and the actual demand for July is 251 units, what would be the forecast error?
Based on the calculated forecast for July in problem 5, if the demand for July was 251 units and the forecast was 241 units, what would be the forecast for August if using exponential smoothing with an alpha factor of 0.32?
Month Actual demand Forecast Alpha factor
January 154 158
February 148 158
March 214 158
April 180 158
May 225 190
June 245 190
July 251 241
August