Try it on paper first. A hint, the key idea and the worked solution are here when you need them.
Use the bicycle sales of problems 5 and 6. The centred moving averages are 172.5, 177.5, 182.5 and 187.5 at quarters 3 to 6, and the trend line is . Find the seasonal variation at each of quarters 3 to 6. With only one value for each season, use these as the seasonal components. Forecast the sales in quarter 1 and in quarter 3 of year 3. State two assumptions behind your forecasts.
Seasonal variation actual trend. Seasonal component the mean of the variations of one season. Then
Check an answer or open a hint to unlock the worked solution.
Have you tried it?
Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.
Step 1. The variations. Quarter 3: . Quarter 4: . Quarter 5: . Quarter 6: .
Step 2. Quarter 1 of year 3. Trend . Forecast .
Step 3. Quarter 3 of year 3. Trend . Forecast .
Step 4. Assumptions. The trend keeps rising by 5 a quarter, and each season stays as far above or below the trend as before.
Answer: variations , , and ; forecasts and bicycles.
Watch out. Each component rests on one value only, so these forecasts are rough. More years of data would give better components.
Log in to join the discussion.
Loading…