Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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).

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).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: LibbyShort

7th Edition

78111021, 978-0078111020

More Books

Students also viewed these Accounting questions