A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR, = 0.9, SR2 = 0.95, SR3 = 1.05, and SRA = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: Demand: 2 6 34 36 39 1 7 8 9 15 17 20 23 25 29 Click here for the Excel Data File Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t Demand MAD Tracking signal 1 15 2 17 3 20 4 23 5 25 6 29 7 34 8 36 39
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR, = 0.9, SR2 = 0.95, SR3 = 1.05, and SRA = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: Demand: 2 6 34 36 39 1 7 8 9 15 17 20 23 25 29 Click here for the Excel Data File Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t Demand MAD Tracking signal 1 15 2 17 3 20 4 23 5 25 6 29 7 34 8 36 39
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section: Chapter Questions
Problem 33P: Management of a home appliance store would like to understand the growth pattern of the monthly...
Related questions
Question
100%
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 2 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