Question

Question 31 Suppose sales for the past 6 months have been 81, 115, 99, 80, 81, and 113 What is the 3-month moving average for the 4th period? (please round your answer to 1 decimal place)

Answer 1

MAPE = ∑( |A – F| / A ) % / n
	Week	Sales	Forecasts
			Simple avg.	Forecast Errors	Absolute deviation	MAPE
	1	81
	2	115
	3	99	80.5	-8.5	8.5	11.81
	4	80	73.5	9.5	9.5	11.45
	5	81	77.5	54.5	54.4	41.21
	6	113	107.5	-42.5	42.5	65.38
	7	110	98.5	11.5	11.5	10.45
	8	90	87.5	2.5	2.5	2.78
	9	67	100	-33	33	49.25
	10	92	78.5	13.5	13.5	14.67
	11	98	79.5	18.5	18.5	18.88
	12	73	95	-22	22	30.14
						256.02
				Mape %=		25.60