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

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Forecasting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
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)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
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-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education