Figure 27.3 shows CCW€™s average daily call volume for each quarter of the past three years, and column F of Fig. 27.4 gives the seasonally adjusted call volumes. Management now wonders what these seasonally adjusted call volumes would have been if the company had started using seasonal factors two years ago rather than applying them retrospectively now. (Use hand calculations rather than an Excel template.)
(a) Use only the call volumes in Year 1 to determine the seasonal factors for Year 2 (so that the €œaverage€ calls volume for each quarter is just the actual call volume for that quarter in Year 1).
(b) Use these seasonal factors to determine the seasonally adjusted call volumes for Year 2.
(c) Use the call volumes in Year 1 and 2 to determine the seasonal factors for Year 3.
(d) Use the seasonal factors obtained in part (c) to determine the seasonally adjusted call volumes for Year 3.
Figure 27.3

Figure 27.4

Transcribed Image Text:

1 CCW's Average Daily Call Volume Year Quarter Call Volume 10,000 6,809 6,465 6,569 8,266 7,257 7,064 7,784 8,724 6,992 6,822 7,949 9,650 9,000 8,000 10 7,000 12 13 Quarter 1 23 412 3 41 2 3 4 Year 1 Year 2 Yeor 3 15 5 ES/DS 0