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 SR, = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows:

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 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:
2
4
5
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
5
25
29
7
34
36
39
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: 2 4 5 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 5 25 29 7 34 36 39
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar 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