# Question

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

(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

## Answer to relevant Questions

The J.J. Bone Company uses exponential smoothing to forecast the average daily call volume at its call center. The forecast for last month was 782, and then the actual value turned out to be 792. Obtain the forecast for next ...Consider the airline overbooking problem discussed in Sec. 28.5. The spreadsheet model is available on this website. The parameter analysis report generated in Sec. 28.7 (see Fig. 28.32) for this problem suggests that 185 is ...Consider the Reliable Construction Co. bidding problem discussed in Sec. 28.1. The spreadsheet model is available on this website. The parameter analysis report generated in Sec. 28.7 (see Fig. 28.31) for this problem ...In the last subsection of Sec. 29.5, the (long-run) expected average cost per week (based on just ordering costs and unsatisfied demand costs) is calculated for the inventory example of Sec. 29.1. Suppose now that the ...Consider the following gambler’s ruin problem. A gambler bets $1 on each play of a game. Each time, he has a probability p of winning and probability q = 1 p of losing the dollar bet. He will continue to play until he ...Post your question

0