Wick\'s Ski Shop is looking to forecast ski sales on a quarterly basis based on

Question

Wick's Ski Shop is looking to forecast ski sales on a quarterly basis based on the historical data listed in the table below:

Year

1

2

3

4

Q1

500

520

550

595

Q2

160

140

170

180

Q3

80

85

90

95

Q4

220

250

260

290

What is the seasonal index for Q1?                            [ Select ]                       ["1.9116", "2.2748", "2.0693", "0.9749"]      

Use Excel Quiz 5, Seasonal Index 1, round to 4 decimal places.

Year

1

2

3

4

Q1

500

520

550

595

Q2

160

140

170

180

Q3

80

85

90

95

Q4

220

250

260

290

Explanation / Answer

Answer is 2.070396

Working:

Year 1 2 3 4 Q1 500 520 550 595 Q2 160 140 170 180 Q3 80 85 90 95 Q4 220 250 260 290 Average 240 248.8 267.5 290 Index numbers 1 2 3 4 Average Q1 2.083333 2.090452 2.056075 2.051724 2.070396 Q2 0.666667 0.562814 0.635514 0.62069 0.621421 Q3 0.333333 0.341709 0.336449 0.327586 0.334769 Q4 0.916667 1.005025 0.971963 1.00000 0.973414

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.