Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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 SRA = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: Demand: 2 6 34 36 39 1 7 8 9 15 17 20 23 25 29 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 6 29 7 34 8 36 39

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 SRA = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: Demand: 2 6 34 36 39 1 7 8 9 15 17 20 23 25 29 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 6 29 7 34 8 36 39

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 9P
See similar textbooks
icon
Related questions
Question
100%
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 = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 3 4 7 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 17 3 20 4 23 25 29 7 34 8 36 39 2.
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 = 11 + 3t. Over the past nine quarters, demand has been as follows: Period, t: 1 2 3 4 7 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 17 3 20 4 23 25 29 7 34 8 36 39 2.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer