Wick\'s Ski Shop is looking to forecast ski sales on a quarterly basis based on
ID: 2390760 • Letter: W
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