The following table shows retail sales within the Tri-Cities area in of millions of dollars from the
Question:
The following table shows retail sales within the Tri-Cities area in of millions of dollars from the years 2012 (Year 1) through 2016 (Year 2).
Tri-Cities’ Retail Sales (2012 – 2016) | |||||
Year | Q1 | Q2 | Q3 | Q4 | Total |
1 | 1721.5 | 1774.1 | 1751.5 | 1844 | 7091.1 |
2 | 1666.4 | 1799.7 | 1747.1 | 1846.1 | 7059.3 |
3 | 1675.8 | 1826.9 | 1835 | 1941.9 | 7279.6 |
4 | 1719.7 | 1952.5 | 1945 | 2032.3 | 7649.5 |
5 | 1812.2 | 1991.6 | 2003.7 | 2097.4 | 7904.9 |
1.) Calculate the Quarter 1 seasonal adjustment factors for Tri - Cities’ retail sales. (Round your answer to 2 decimal places).
2.)Calculate the Quarter 2 seasonal adjustment factor for Tri - Cities’ retail sales. (Round your answer to 2 decimal places)
3.) Calculate the Quarter 3 seasonal adjustment factor for Tri - Cities’ retail sales. (Round your answer two 2 decimal places).
4.) Calculate the Quarter 4 seasonal adjustment factor for Tri - Cities’ retail sales. (Round your answer to 2 decimal places).
5.) Predict annual sales for 2017 (Year 6) based on the linear trend. (Round your answer to 2 decimal places).
6.) Predict sales for Quarter 1 in 2017. (Round your answer to 2 decimal places).
7.) Predict sales for Quarter 2 in 2017. (Round your answer to 2 decimal places).
8.) Predict sales for Quarter 3 in 2017. (Round your answer to 2 decimal places).
9.) Predict sales for Quarter 4 in 2017. (Round your answer to 2 decimal places).
Expert Answer:
Step 1 Calculate the average sales for each quarter across all years Average Q1 sales Q1 Year 1 Q1 Year 2 Q1 Year 3 Q1 Year 4 Q1 Year 5 5 Average Q2 sales Q2 Year 1 Q2 Year 2 Q2 Year 3 Q2 Year 4 Q2 Ye... View the full answer
