Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Week Demand Moving Average abs err % err 1 2750 2 3100 3 3250 4 3300 5 2900 6 3050 7 3300 8 3100 9
Week | Demand | Moving Average | abs err | % err |
1 | 2750 | |||
2 | 3100 | |||
3 | 3250 | |||
4 | 3300 | |||
5 | 2900 | |||
6 | 3050 | |||
7 | 3300 | |||
8 | 3100 | |||
9 | 2950 | |||
10 | 3000 | |||
11 | 3200 | |||
12 | 3220 | |||
13 | ||||
Week | Demand | Exponential | abs | % err |
1 | 2750 | |||
2 | 3100 | |||
3 | 3250 | |||
4 | 3300 | |||
5 | 2900 | |||
6 | 3050 | |||
7 | 3300 | |||
8 | 3100 | |||
9 | 2950 | |||
10 | 3000 | |||
11 | 3200 | |||
12 | 3220 |
a) | Compute a moving average that uses the past two actual demand values to predict the next week |
b) | Show the Demand and the Forecast on the same graph |
c) | Compute the MAPE for this forecast |
I | |
d) | Comlute an Exponentially Smoothed forecast in the second part, using that alpha value in G5 |
e) | Show the Demand and the Forecast on the same graph |
f) | Compute the MAPE for this forecast |
g) | Which forecast technique is better if Alpha = 0.1? |
I want to know BLANKS' answers
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started