Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05 ExponA using and alpha level of .75 ExponB will automatically be .25 when A is .75 Exponential Solver What is the best alpha level as determined by the Exponential Solver? Which is the best forecasting option for MAE? What is the MAE? Which is the best forecasting option for MAPE? What is the MAPE? Period Sales 1 115 2 118 3 128 4 122 5 135 6 128 7 135 8 132 9 132 10 135
Complete the forecasting worksheets for: Naïve Average Moving Average Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05 ExponA using and alpha level of .75 ExponB will automatically be .25 when A is .75 Exponential Solver What is the best alpha level as determined by the Exponential Solver? Which is the best forecasting option for MAE? What is the MAE? Which is the best forecasting option for MAPE? What is the MAPE? Period Sales 1 115 2 118 3 128 4 122 5 135 6 128 7 135 8 132 9 132 10 135
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...
Related questions
Question
100%
Complete the
Naïve
Average
Moving Average
Weighted Moving Average using the weights of .8, .15, and .05 with .8 being the most current, then .15, then .05
ExponA using and alpha level of .75
ExponB will automatically be .25 when A is .75
Exponential Solver
What is the best alpha level as determined by the Exponential Solver?
Which is the best forecasting option for MAE? What is the MAE?
Which is the best forecasting option for MAPE? What is the MAPE?
Period |
Sales |
1 |
115 |
2 |
118 |
3 |
128 |
4 |
122 |
5 |
135 |
6 |
128 |
7 |
135 |
8 |
132 |
9 |
132 |
10 |
135 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1 Given the following information in the question:
VIEWStep 2 Forecast using Naive method
VIEWStep 3 Forecast using Moving average
VIEWStep 4 Forecast using Weighted Moving Average
VIEWStep 5 Forecast using Exponential smoothing
VIEWStep 6 Forecast using Exponential smoothing Solver
VIEWStep 7 Final answer
VIEWStep by step
Solved in 7 steps with 13 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing