Plot the table and give at least three observations from the plot according to the given data Weeks Calls 3 month Weighted Moving Average Error =Abs (Actual -Forecasted) (Sum of Absolute percent error) 1 50 2 35 3 25 4 40 31.42857143 8.571428571 21.42857143 5 45 35 10 22.22222222 6 35 40.71428571 5.714285714 16.32653061 7 20 38.57142857 18.57142857 92.85714286 8 30 27.85714286 2.142857143 7.142857143 9 35 27.85714286 7.142857143 20.40816327 10 20 31.42857143 11.42857143 57.14285714 11 15 25.71428571 10.71428571 71.42857143 12 40 19.28571429 20.71428571 51.78571429 13 55 30 25 45.45454545 14 35 45 10 28.57142857 15 25 41.42857143 16.42857143 65.71428571 16 55 32.14285714 22.85714286 41.55844156 17 55 43.57142857 11.42857143 20.77922078 18 40 50.71428571 10.71428571 26.78571429 19 35 46.42857143 11.42857143 32.65306122 20 60 39.28571429 20.71428571 34.52380952 21 75 50 25 33.33333333 22 50 65 15 30 23 40 58.57142857 18.57142857 46.42857143 24 65 47.85714286 17.14285714 26.37362637 TOTAL 980 827.8571429 299.2857143 792.9186686 Average Error 14.25170068 MAD= 14.25170068 Σ I actual – forecast I / n MAPE%= 37.75803184 (Σ 100* I actual – forecast I / actual ) /n

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 19P: The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a...

See similar textbooks

Related questions

Concept explainers

Question

Plot the table and give at least three observations from the plot according to the given data

Weeks	Calls	3 month Weighted Moving Average	Error =Abs (Actual -Forecasted)	(Sum of Absolute percent error)
1	50
2	35
3	25
4	40	31.42857143	8.571428571	21.42857143
5	45	35	10	22.22222222
6	35	40.71428571	5.714285714	16.32653061
7	20	38.57142857	18.57142857	92.85714286
8	30	27.85714286	2.142857143	7.142857143
9	35	27.85714286	7.142857143	20.40816327
10	20	31.42857143	11.42857143	57.14285714
11	15	25.71428571	10.71428571	71.42857143
12	40	19.28571429	20.71428571	51.78571429
13	55	30	25	45.45454545
14	35	45	10	28.57142857
15	25	41.42857143	16.42857143	65.71428571
16	55	32.14285714	22.85714286	41.55844156
17	55	43.57142857	11.42857143	20.77922078
18	40	50.71428571	10.71428571	26.78571429
19	35	46.42857143	11.42857143	32.65306122
20	60	39.28571429	20.71428571	34.52380952
21	75	50	25	33.33333333
22	50	65	15	30
23	40	58.57142857	18.57142857	46.42857143
24	65	47.85714286	17.14285714	26.37362637

TOTAL	980	827.8571429	299.2857143	792.9186686


	Average Error	14.25170068
	MAD=	14.25170068	Σ I actual – forecast I / n
	MAPE%=	37.75803184	(Σ 100* I actual – forecast I / actual ) /n

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.