Question

Ch 04 HW 3 Forecasting problem Method: Weighted Moving Average with n = 3 and weights 0.1, 0.3, and 0.6 The data for this problem is shown in the table below. Note: changes from the original problem data are highlighted in yellow. Time (t) Actual A(t) 1 950 2 930 3 915 4 920 5 901 6 898 7 884 8 913 9 924 10 937 11 don't have yet What is the value for MSE using this method?

Answer 1

period	demand	forcast	forecast error=demand value-forecast value	absolute forecast error	squared forcast error
t	Dt	Ft	et=Dt-Ft	| et |	(et)²
1	950
2	930
3	915
4	920	923.000	-3.00	3.00	9.00
5	901	919.500	-18.50	18.50	342.25
6	898	908.100	-10.10	10.10	102.01
7	884	901.100	-17.10	17.10	292.41
8	913	889.900	23.10	23.10	533.61
9	924	902.800	21.20	21.20	449.44
10	937	916.700	20.30	20.30	412.09
11		930.700

	forecast error=demand value-forecast value	absolute forecast error	squared forcast error
	et=Dt-Ft	| et |	(et)²
total sum=	15.90	113.30	2140.81
n=	7	7	7
average=	2.27	16.19	305.83

MSE=   Σ(et)²/n =    305.83

THANKS

revert back for doubt

please upvote