Question

The data below represent the relative shares (by quarter) of call volumes over 16 quarters from a call center at a major financial institution Average Qtr Percent Share 2011 2012 2010 23.2% 23.0% 23.3% | 21.9% 25.1% | 24.6% | 26.2% | 25.3% 28.5% 28.8% | 28.6% | 29.8% 23.2% 23.6% 21.9% 100% 100% 2013 Q1 Q2 Q3 Q4 22.8% 25.3% 28.9% 22.9% 100% | 23.1% 100% Total 100% (a) Using the average quarter percent share column (Column G) generate a pie chart and a bar chart to show the quarterly percent shares of call volumes to the call center (b) Using the percentaetable above, what are the indices for each of the four quarters? (c) Assume that the projected number of calls for the year 2014 is 50,000,000, what are the seasonally adjusted forecasts for the number of calls for Q1, Q2, Q3, and Q4?

Answer 1

(a)

(b)

	Indices
Q1	91.40%
Q2	101.20%
Q3	115.70%
Q4	91.80%

(c)

	Seasonally adjusted forecasts
Q1	11413027.00
Q2	12651833.00
Q3	14465680.00
Q4	11469460.00