Wicks Ski Shop is looking to forecast ski sales on a quarter

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

500

520

550

595

160

140

170

180

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

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

$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 Q$

Wicks Ski Shop is looking to forecast ski sales on a quarter

Solution

Get Help Now

Submit a Take Down Notice