The same company decided to improve the forecasting technique. Usually they use exponential smoothing using smoothing constant 0.3. However, they would like to try alternate options: 0.4, 0.6, 0.7. Based on the following data for actual demand in the year of 2022, which smoothing constant they should chose among 0.3, 0.4,0.5 and 0.6. You can use excel/other software to calculate and draw graph. Show your final result with a graph representing the actual demand and forecast for each smoothing constant. Also, calculate the MAPE (mean absolute percentage error) to justify your answer. Period 1 2 Actual demand (in thousands) 10 12 14

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Question-2:
The same company decided to improve the forecasting technique. Usually they use exponential
smoothing using smoothing constant 0.3. However, they would like to try alternate options: 0.4, 0.6, 0.7.
Based on the following data for actual demand in the year of 2022, which smoothing constant they should
chose among 0.3, 0.4,0.5 and 0.6. You can use excel/other software to calculate and draw graph. Show
your final result with a graph representing the actual demand and forecast for each smoothing constant.
Also, calculate the MAPE (mean absolute percentage error) to justify your answer.
Period
1
2
3
4
5
6
7
8
9
10
11
12
Actual demand (in thousands)
10
12
14
11
13
18
20
17
13
16
12
19
Transcribed Image Text:Question-2: The same company decided to improve the forecasting technique. Usually they use exponential smoothing using smoothing constant 0.3. However, they would like to try alternate options: 0.4, 0.6, 0.7. Based on the following data for actual demand in the year of 2022, which smoothing constant they should chose among 0.3, 0.4,0.5 and 0.6. You can use excel/other software to calculate and draw graph. Show your final result with a graph representing the actual demand and forecast for each smoothing constant. Also, calculate the MAPE (mean absolute percentage error) to justify your answer. Period 1 2 3 4 5 6 7 8 9 10 11 12 Actual demand (in thousands) 10 12 14 11 13 18 20 17 13 16 12 19
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman