Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) . Period Demand Forecast Error MAD Bias TS 2-Oct 2020 850 2-Nov 2020 950 2-Dec 2020 900 2-Jan 2021 1000 2-Feb 2021 950 2-Mar 2021 1050 2-Apr 2021 850 2-May 2021 800 2-June 2021 900 2-July 2021 1000
Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) . Period Demand Forecast Error MAD Bias TS 2-Oct 2020 850 2-Nov 2020 950 2-Dec 2020 900 2-Jan 2021 1000 2-Feb 2021 950 2-Mar 2021 1050 2-Apr 2021 850 2-May 2021 800 2-June 2021 900 2-July 2021 1000
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 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
Related questions
Question
. Given the following data for demand at the XYZ Company, calculate the monthly
Period |
Demand |
Forecast |
Error |
MAD |
Bias |
TS |
2-Oct 2020 |
850 |
|
|
|
|
|
2-Nov 2020 |
950 |
|
|
|
|
|
2-Dec 2020 |
900 |
|
|
|
|
|
2-Jan 2021 |
1000 |
|
|
|
|
|
2-Feb 2021 |
950 |
|
|
|
|
|
2-Mar 2021 |
1050 |
|
|
|
|
|
2-Apr 2021 |
850 |
|||||
2-May 2021 |
800 |
|
|
|
|
|
2-June 2021 |
900 |
|
|
|
|
|
2-July 2021 |
1000 |
|
|
|
|
|
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 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