1 . Use the decomposition spreadsheet above to calculate the deseasonalized data for Winter in year 20XX:

Your Answer:

Period 258.7 Year Quarter 20XX-2 Spring Summer Fall Winter 20XX-1 Spring Summer Fall Winter 20XX Spring Summer Fall Winter 20XX+1 Spring Summer Fall Winter DONO Sales 363 336 288 261 325 293 253 223 290 245 235 195 Quarter Seasonal Deseas. Deseas. Ave. Factor Data Forecast Forecast 326.0 307.6 319.3 376.8 291.3 1.06 317.0 311.3 330.0 0.94 306.4 303.3 285.1 226.3 0.82 318.3 295.3 242.1 1.18 275.4 287.3 339.0 1.06 276.4 279.3 296.1 0.94 269.1 271.3 255.0 0.82 272.0 263.3 215.9 1.18 245.8 255.3 301.3 1.06 231.1 247.3 262.1 0.94 250.0 239.3 224.9 0.82 231.3 189.7 1.18 223.3 263.5 1.06 215.3 228.2 0.94 207.3 194.9 0.82 199.3 163.4 13 14 275.6 -8.0 327.3