Last Value with Seasonality

Last Value with Seasonality - A 1 2 3 4 5 6 7 8 9 10 11 12...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Template for Last-Value Forecasting Method with Seasonality Seasonally Seasonally Range Name Cells True Adjusted Adjusted Actual Forecasting ActualForecast G6:G75 Year Quarter Value Value Forecast Forecast Error Type of Seasonality ForecastingError H6:H75 1 1 6,809 7,322 Quarterly MAD K23 1 2 6,465 7,183 7,322 6,589 124 MSE K26 1 3 6,569 6,635 7,183 7,112 543 Quarter Seasonal Factor SeasonalFactor K9:K20 1 4 8,266 7,005 6,635 7,830 436 1 0.930 SeasonallyAdjustedForecast F6:F75 2 1 7,257 7,803 7,005 6,515 742 2 0.900 SeasonallyAdjustedValue E6:E75 2 2 7,064 7,849 7,803 7,023 41 3 0.990 TrueValue D6:D75 2 3 7,784 7,863 7,849 7,770 14 4 1.180 TypeOfSeasonality K6 2 4 8,724 7,393 7,863 9,278 554 1.000 3 1 6,992 7,518 7,393 6,876 116 1.000 3 2 6,822 7,580 7,518 6,766 56 1.000 3 3 7,949 8,029 7,580 7,504 445 1.000 3 4 9,650 8,178 8,029 9,475 175 1.000 4 1 #N/A 8,178 7,606 1.000 4 2 #N/A #N/A 1.000 4 3 #N/A #N/A 1.000 4 4 #N/A #N/A 5 1 #N/A #N/A Mean Absolute Deviation 5 2 #N/A #N/A MAD = 295.1
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/17/2008 for the course MGMT 3100 taught by Professor Camateros during the Winter '08 term at CSU East Bay.

Ask a homework question - tutors are online