A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR₁ =0.9, SR₂ = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft= 7+ 5t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 Demand: 15 5 6 7 8 9 3 4 18 20 23 28 34 40 45 51 Click here for the Excel Data File A 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 1 2 3 4 5 6 7 8 9 Demand 15 18 20 23 28 34 40 45 51 MAD Tracking signal 1.000

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR₁ =0.9, SR₂ = 0.95, SR3 = 1.05,
and SR4 = 1.1. The trend equation is: Ft= 7+ 5t. Over the past nine quarters, demand has been as follows:
Period, t:
Demand:
4 5 6 7 8 9
3
18 20 23 28 34 40 45 51
1 2
15
Click here for the Excel Data File
Period, t
1
2
3
4
5
6
7
8
9
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.)
Demand
15
18
20
23
28
34
40
45
51
MAD
Tracking signal
1.000
Transcribed Image Text:A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR₁ =0.9, SR₂ = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft= 7+ 5t. Over the past nine quarters, demand has been as follows: Period, t: Demand: 4 5 6 7 8 9 3 18 20 23 28 34 40 45 51 1 2 15 Click here for the Excel Data File Period, t 1 2 3 4 5 6 7 8 9 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.) Demand 15 18 20 23 28 34 40 45 51 MAD Tracking signal 1.000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 12 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman