Question

Please do the calculation for the missing data of the Forecast Evolution Table below:

Month t	Actual Demand At	Forecast Ft	Error et	Absolute error |et|	Error squared et 2	Absolute percent error [|et|/At] *100
1	200	225
2	240	220
3	300	285
4	270	290
5	230	250
6	260	240
7	210	250
8	275	240
		TOTAL
				MAD=	MSE=	MAPE=

Answer 1

since et =Actual -forecast

therefore :

Month	Actual Demand	Forecast	Error	Absolute error	Error squared	Absolute percent error
t	At	Ft	et	|et|	et 2	[|et|/At] *100
1	200	225	-25	25	625	12.5000
2	240	220	20	20	400	8.3333
3	300	285	15	15	225	5.0000
4	270	290	-20	20	400	7.4074
5	230	250	-20	20	400	8.6957
6	260	240	20	20	400	7.6923
7	210	250	-40	40	1600	19.0476
8	275	240	35	35	1225	12.7273
		TOTAL		195	38025	81.404
		average value		MAD=24.375	MSE=659.375	MAPE =10.1754