Unformatted text preview: Totals 10986.20 36.00 10710.02 Actual Sales (A) Jan-07 - Dec-09 = Y Regression Forecast (F) y = a + bx Seasonal Ratio (A)/(F) Seasonal Forecast of Sales The seasonal forecast for the periods WITH actual data will be the SAME as the actual data. Note though that in Year 3 a seasonal forecast of sales can be created without actual sales data, using the regression forecast that is adjusted for seasonality. This company chose to forecast its Year 3 seasonality factor by averaging the seasonality factor used in years 1 & 2. Jan year 3 = (Jan year 1 + Jan year 2) / 2. Feb year 3 = (Feb year 1 + Feb year 2)/2, and so forth....
View Full Document
- Spring '11
- Month, Oct Nov Dec, FEB MAR APR, Jul Aug Sep, Jan Feb Mar