Question

The manager of a travel agency has been using a seasonally adjusted forecast to predict demand...

The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows:

Period Demand Predicted
1 135 113
2 195 200
3 155 150
4 90 102
5 85 80
6 130 135
7 125 128
8 130 124
9 95 109
10 150 150
11 105 94
12 90 80
13 125 140
14 135 128

     

a. Compute MAD for the fifth period, then update it period by period using exponential smoothing with ? = .05. (Round your intermediate calculations and final answers to 3 decimal places.)

t
Period
A
Demand
MADt
1 135
2 195
3 155
4 90
5 85
6 130
7 125
8 130
9 95
10 150
11 105
12 90
13 125
14 135

b. Compute a tracking signal for periods 5 through 14 using the initial and updated MADs. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.)

t
Period
A
Demand
Tracking
Signal
1 135
2 195
3 155
4 90
5 85
6 130
7 125
8 130
9 95
10 150
11 105
12 90
13 125
14 135

Homework Answers

Answer #1

(a) MADs and (b) Tracking Signals are calculated as below

Formula:

D7 =D6+(B6-D6)*0.05 copy to D7:D15

E6 =ABS(B6-C6) copy to E7:E15

F6 =B6-C6 copy to F7:F15

G6 =F6+G5 copy to G6:G15

H6 =G6/AVERAGE($E$6:E6) copy to H6:H15

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand...
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: Period Demand Predicted 1 135 113 2 195 200 3 155 150 4 90 102 5 85 80 6 130 135 7 125 128 8 130 124 9 95 109 10 150 150 11 105 94 12 90 80 13 125 140 14 135 128       a. Compute MAD for the fifth period,...
Use the following bank statement and T-account to prepare the May 31 bank reconciliation. BANK STATEMENT...
Use the following bank statement and T-account to prepare the May 31 bank reconciliation. BANK STATEMENT   Date Checks Deposits Other Balance   May 1       $ 520            4       #2 $ 90 $ 130 560           12       #4 180 NSF Check $130 250           28       #5 100 150           30       #6 95 520 575   May 31       #8 135 Service charge 85 355 Cash (A)   May 1 520     May 3 130      90 May 3 #2            90   May 4 #3     ...
Times for a Table Dominick Aldo owns and operates Carolina’s which is an Italian restaurant in...
Times for a Table Dominick Aldo owns and operates Carolina’s which is an Italian restaurant in New York. The Excel file Single Population.xlsx is shown below and contains the amount of time that table times varied from table to table. Test the hypothesis that the average table time exceeds 98 minutes using α = 0.05. What is the p-value? Interpret the results. Time 50 50 50 60 60 60 60 60 60 70 70 70 70 70 70 70 75...
HEALTH CARE QUALITY MANAGEMENT Create a graph for each set of data below. Explain why you...
HEALTH CARE QUALITY MANAGEMENT Create a graph for each set of data below. Explain why you selected the graph to represent each. Be sure to properly title and label x and y axis. Graph 1: Major Causes of Incomplete Records Cause Frequency over six months Incomplete or missing Jan Feb March April May June Total 1. Histories & Physicals 70 85 65 75 80 90 465 2. Attestations* 140 150 135 145 160 170 900 3. Discharge Summaries 125 130...
Let’s consinder a mortgage application using HMDA (The Home Mortgage Disclosure Act). Here is a sample...
Let’s consinder a mortgage application using HMDA (The Home Mortgage Disclosure Act). Here is a sample from 30 mortgage applications: ID loanamt income hprice 1 109 63 155 2 185 137 264 3 121 53 128 4 125 78 125 5 119 37 149 6 153 65 171 7 380 188 484 8 100 58 125 9 110 78 158 10 41 31 116.5 11 115 54 128 12 248 117 280 13 126 60 157.5 14 260 192 325...
The table below shows the monthly sales of a motorcycle store during the last two years....
The table below shows the monthly sales of a motorcycle store during the last two years. The commission for each motorcycle sale is $1,000. The manager wants to estimate how much money he will need for month 25. Month Sales Month Sales 1 195 13 155 2 210 14 120 3 190 15 135 4 170 16 110 5 180 17 122 6 156 18 97 7 134 19 85 8 155 20 110 9 145 21 85 10 165...
BANK STATEMENT   Date Checks Deposits Other Balance   May 1       $ 520            4       #2
BANK STATEMENT   Date Checks Deposits Other Balance   May 1       $ 520            4       #2 $ 90 $ 130 560           12       #4 180 NSF Check $130 250           28       #5 100 150           30       #6 95 520 575   May 31       #8 135 Service charge 85 355 Cash (A)   May 1 520     May 3 130      90 May 3 #2            90   May 4 #3            180 May 8 #4          100 May 11 #5     ...
The following information is available on company ABC.                                 CALLS &
The following information is available on company ABC.                                 CALLS    PUTS ABC   X         MAR   APR   MAY     MAR   APR   MAY 119  120          6        8        11          1         3        4 119  125          2        5          8           2          4       6 119  130          1        3          6           5          7       9 You create a (long) straddle using the May maturity and the strike price of $120. What are the breakeven stock prices at expiration for this straddle? None of these answers are correct $100 and $125 $105 and $135 $110 and $130 $95 and $115
Indices   DUR   DUR (OLD) 1   6   11 2   13   14 3   11   14 4   7   10...
Indices   DUR   DUR (OLD) 1   6   11 2   13   14 3   11   14 4   7   10 5   9   9 6   7   10 7   8   11 8   5   8 9   7   6 10   7   10 11   7   13 12   3   5 13   10   13 14   3   15 15   4   12 16   9   7 17   9   8 18   10   13 19   6   10 20   8   14 21   10   14 22   8   18 23   2   10 24   4   11 25   7   16 26  ...
Consider the accompanying time series. a. Forecast the demand for each quarter in Year 4 using...
Consider the accompanying time series. a. Forecast the demand for each quarter in Year 4 using multiplicative decomposition. b. Interpret the meaning of the seasonal components. c. Calculate the MAD for this forecast. Year_1_Quarter   Year_ 1_Demand   Year_2_Quarter   Year_2_Demand   Year_3_Quarter   Year_3_Demand 1 4 1 5 1 8 2 10 2 13 2 16 3 11    3 11 3 14 4 5 4 9 4    8 .