Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-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 2012 800 2-Nov 2012 1000 2-Dec 2012 950 2-Jan 2013 1100 2-Feb 2013 930 2-Mar 2013 1020 2-Apr 2013 870
Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-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 2012 800 2-Nov 2012 1000 2-Dec 2012 950 2-Jan 2013 1100 2-Feb 2013 930 2-Mar 2013 1020 2-Apr 2013 870
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 2012 |
800 |
|
|
|
|
|
2-Nov 2012 |
1000 |
|
|
|
|
|
2-Dec 2012 |
950 |
|
|
|
|
|
2-Jan 2013 |
1100 |
|||||
2-Feb 2013 |
930 |
|||||
2-Mar 2013 |
1020 |
|||||
2-Apr 2013 |
870 |
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