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
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
Related questions
Question

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

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 3 steps with 12 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman