ASSIGNMENT UNIT 6

Question One

For the data below:

Month	Automobile Battery Sales
January	20
February	21
March	15
April	14
May	13
June	16
July	17
August	18
September	20
October	20
November	21
December	23

1. Compute the 3-monyhs moving total and moving average forecast.
2. Compute the cantered moving averages
3. Compute the MAD and MSE

Part B The table below shows the monthly sales figures and seasonal indices (January to November) for a product produced by the U-beaut company.

1. Complete the table by calculating the missing seasonal index.

Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Seasonal index	1.2	1.3	1.1	1.0	1.0	0.9	0.8	0.7	0.9	1.0	1.1

Interpret the seasonal index for

1. February
2. August

Part C

The table below shows the quarterly newspapers paper sales for a corner store for year 1. Also shown are the seasonal indices for the newspaper sales for the first, second and third quarters.

Complete the table.

	Quarter 1	Quarter 2
Year 1	1256	1060	1868	1642
Year 1 Descasonalized
Seasonal Index	0.8	0.7	1.3