A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft= 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 4 6 8 Demand: 15 17 20 23 25 29 34 36 39 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 25
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft= 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 4 6 8 Demand: 15 17 20 23 25 29 34 36 39 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 25
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
![A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05,
and SR4 = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows:
%3D
Period, t:
1
4
7
8
9.
Demand:
15
17
20
23
25
29
34
36
39
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
25
6.
29
7
34
36
39
LO](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4ced2b69-7195-4860-954c-1930b6dde0c1%2F24391fe7-25dd-4ccd-b064-15ef9a0b4155%2F6ytspz_processed.png&w=3840&q=75)
Transcribed Image Text:A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05,
and SR4 = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows:
%3D
Period, t:
1
4
7
8
9.
Demand:
15
17
20
23
25
29
34
36
39
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
25
6.
29
7
34
36
39
LO
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education