Data Represent Relative Shares Quarter Call Volumes 16 Quarters Call Center Major Financia Q34211519

The data below represent the relative shares (by quarter) ofcall volumes over 16 quarters from a call center at a majorfinancial institution.

2010201120122013Average Qtr Percent ShareQ123.2%23.0%23.3%21.9%22.8%Q225.1%24.6%26.2%25.3%25.3%Q328.5%28.8%28.6%29.8%28.9%Q423.2%23.6%21.9%23.1%22.9%Total100%100%100%100%100%

(b) Using the percentage table above, what are the indices foreach of the four quarters?

*********I am unsure of the formula to use in excel fromthe table above.

(c) Assume that the projected number of calls for the year 2014is 50,000,000, what are the seasonally adjusted forecasts for thenumber of calls for Q1, Q2, Q3, and Q4?

Expert Answer

b. Last column in the below photo shows the seasonal indices foreach of the 4 quarters.

c.