NOTE: Show and use excel formulas for each and all calculations and round to two decimals
Q 1	Use the Historical demand data below to calculate THREE forecasts. (3 marks)
a)	2 Period Simple moving average
b)	3 Period Weighted moving average using weights of .5, .35, .15
c)	Exponential Smoothing forecast using an Alpha of .4. and a Week 3 forecast of 579 units.
Week	Demand	2 Period SMA	WMA .5,.35,.15	EXP SM a = .4
1	453
2	417
3	613			579
4	605
5	542
6	480
7	545
8	495
9	590