Question two

Each of the following data sets records monthly sales ($000). Use the data to determine the seasonal indices for the 12 months. Give your result correct to 2 decimal places.

i.

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	SepOct	Nov Dec
12	13	14	17	18	15	9	10	8 11	20

ii.

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep Oct	Nov Dec
22	19	25	23	20	18	20	15	14 11	23 30

Section B

The following numbers show the monthly sales figure and seasonal indices (for January to December) for a product produced by the VMAX company.

1. Complete the table by:

1. Calculating the missing seasonal index.
2. Evaluating the deseasonalised sales figures.

2. The seasonal index for June is 0.90. Explain what this means in terms of the average monthly sales.

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep Oct Nov Dec
Sales($000)	166	215	203	209	178	165	156	256	243 207 165 106
Sales (deseasonlised)
Seasonal Index	1.0		1.1	1.0	1.0	1.0	0.9	1.2	1.2 1.1 1.0 0.7