Question
The following table gives the actual sales data and the 3-month moving average forecast. Calculate MAD,...
The following table gives the actual sales data and the 3-month moving average forecast. Calculate MAD, MSE, and MAPE for the forecast. Week Sales (cases) 3 week Moving average
1 22
2 24
3 29
4 31
5 19
6 30
Homework Answers
Answer #1
Mean absolute error = Mean of absolute errors = 6.222
MSE = Mean of squared errors = 43.481
MAPE = Mean of absolute percentage error = 26.315
Not the answer you're looking for?
Similar Questions
Refer again to the gasoline sales time series data in the following table. Week Sales (1000s...
Refer again to the gasoline sales time series data in the
following table.
Week
Sales (1000s of gallons)
1
18
2
22
3
20
4
26
5
18
6
17
7
21
8
19
9
23
10
23
11
16
12
24
Using a weight of 1/2 for the most recent observation, 1/3 for
the second most recent, and 1/6 for third most recent, compute a
three-week weighted moving average for the time series. Use rounded
for two decimal places...
Consider the actual and forecast values contained in the table. What is the MAD of the...
Consider the actual and forecast values contained in the table.
What is the MAD of the forecast?
Actual
Forecast
Actual
Forecast
10
10.8
26
24.5
13
13.6
28
27.2
17
16.3
29
29.9
19
19
32
32.6
22
21.7
35
35.3
Please do the calculation for the missing data of the Forecast Evolution Table below: Month t...
Please do the calculation for the missing data of the
Forecast Evolution Table below:
Month
t
Actual Demand
At
Forecast
Ft
Error
et
Absolute error
|et|
Error squared
et 2
Absolute percent error
[|et|/At] *100
1
200
225
2
240
220
3
300
285
4
270
290
5
230
250
6
260
240
7
210
250
8
275
240
TOTAL
MAD=
MSE=
MAPE=
Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week...
Problem 15-07 (Algorithmic)
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1000s of gallons)
1
17
2
21
3
19
4
24
5
18
6
15
7
21
8
19
9
22
10
21
11
16
12
22
Compute four-week and five-week moving averages for the time
series. Round your answers to two decimal places.
Week
Sales
4-Week
Moving Average
5-Week
Moving Average
1
17
2
21
3
19
4
24
5
18
6...
Refer to the gasoline sales time series data in Table 8.1. Compute four-week and five-week moving...
Refer to the gasoline sales time series data in Table 8.1.
Compute four-week and five-week moving averages for the time
series. Compute the MSE for the four-week and five-week moving
average forecasts. What appears to be the best number of weeks of
past data (three, four, or five) to use in the moving average
computation? Recall that the MSE for the three-week moving average
is 10.22.
Week
Sales (1000s of gallons)
1
17
2
21
3
19
4
23
5...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below:
Observation
Month
Actual Sales (A)
Forecasted Sales (F)
1
January
18
2
February
23
3
March
20
4
April
16
5
May
a. Use exponential smoothing with α = 0.2 to calculate
smoothed averages and forecast sales for May from the above data.
Assume the forecast for the initial period (January) is 18.
b. Calculate MSE, and MAPE.
The CEO requested forecasts based on the given historical data. Put your final answers in the table....
The CEO requested forecasts based on the given historical
data. Put your final answers in the table.
Round answers to 3 decimals for each method. Show work for full
credit.
Period
Actual Demand
3 Month Moving Average
Moving Average Tracking Signal
3 Month Weighted Average
Weighted Average Tracking Signal
1
62
X
X
X
X
2
59
X
X
X
X
3
48
X
X
X
X
4
57
56.33
59.4
5
60
54.66
54.4
6
56
55
52.83
MAD
X...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1,000s of gallons)
1
16
2
22
3
17
4
23
5
15
6
17
7
21
8
19
9
20
10
18
11
15
12
23
(a)
Compute four-week and five-week moving averages for the time
series.
If required, round your answers to two decimal places.
Week
Sales
4 Period
Moving Average
5 period
Moving Average
1
16
2
22
3
17
4
23
5...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given
table.
Week
Sales (1000s of gallons)
1
18
2
21
3
18
4
22
5
17
6
15
7
20
8
18
9
21
10
20
11
14
12
22
Compute four-week and five-week moving averages for the time
series. Round your answers to two decimal places.
Week
Sales
4-Week
Moving Average
5-Week
Moving Average
1
18
2
21
3
18
4
22
5
17
6
15
7
20...
Consider the following gasoline sales time series data. Week Sales (1000s of gallons) 1 18 ...
Consider the following gasoline sales time series data.
Week
Sales (1000s of gallons)
1
18
2
22
3
20
4
24
5
17
6
15
7
19
8
17
9
23
10
19
11
14
12
23
a. Using a weight of 1/2 for the most recent
observation, 1/3 for the second most recent observation, and 1/6
third the most recent observation, compute a three-week weighted
moving average...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 2 minutes ago
asked 11 minutes ago
asked 39 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago