Question
Utility Taxes in Sunnytown, Florida Year Revenues ($) 1 842,387 2 1,665,430 3 1,863,296 4 2,063,103...
Utility Taxes in Sunnytown, Florida
|
Year |
Revenues ($) |
|
1 |
842,387 |
|
2 |
1,665,430 |
|
3 |
1,863,296 |
|
4 |
2,063,103 |
|
5 |
2,905,717 |
|
6 |
- Use Exponential Smoothing, with α=0.8, to forecast the revenue in Year 6. Use your calculator to forecast.
Homework Answers
Answer #1
| smoothing constant | year | Revenue | Forecast |
| 0.8 | 1 | 842384 | |
| 2 | 1665430 | 842384 | |
| 3 | 1863296 | 1500821 | |
| 4 | 2063103 | 1573316 | |
| 5 | 2905717 | 1671273 | |
| 6 | 1918162 |
Not the answer you're looking for?
Similar Questions
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data.
Week
1
2
3
4
5
6
Value
19
12
16
11
18
13
(b)
Develop the three-week moving average forecasts for this time
series. (Round your answers to two decimal places.)
Week
Time Series
Value
Forecast
1
19
2
12
3
16
4
11
5
18
6
13
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(c)
Use α = 0.2 to compute...
1. Suppose the following data represents total revenues (in $ millions) for a mining company. Year...
1. Suppose the following data
represents total revenues (in $ millions) for a mining
company.
Year
Revenue
4-Year Moving
Average
4 Weighted Moving Average
Weights 4,3,2,1
Exponential smoothing
α = 0.6
2010
75
2011
81
2012
74
2013
79
2014
69
2015
92
2016
73
2017
85
2018
90
2019
73
2020
Forecast
Use 2 decimal
places,
Compute the 4-year moving averages and forecast the revenue for
2020. ( 4 marks)
Compute the 4-year weighted moving averages...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data.
Week
1
2
3
4
5
6
Value
18
13
15
12
16
14
c)Use α = 0.2 to compute the exponential smoothing
forecasts for the time series.
Week
Time Series
Value
Forecast
1
18
2
13
18
3
15
4
12
5
16
6
14
Compute MSE. (Round your answer to two decimal places.)
MSE =____
What is the forecast for week 7? (Round your answer to two
decimal places.)
____
(e)Use a...
Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16...
Month
1
2
3
4
5
6
7
Value
25
14
21
13
20
24
16
(b)
Develop the three-month moving average forecasts for this time
series.
Month
Time Series
Value
Forecast
1
25
2
14
3
21
4
13
5
20
6
24
7
16
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for month 8?
(c)
Use α = 0.2 to compute the exponential smoothing
forecasts for the time series. (Round...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...
Consider the following time series data.
Month
1
2
3
4
5
6
7
Value
22
11
18
10
17
21
13
A) What type of pattern exists in the data?
The data appear to follow a seasonal pattern.
The data appear to follow a trend
pattern.
The data appear to follow a horizontal pattern.
The data appear to follow a cyclical pattern.
B) Develop the three-month moving average forecasts for this
time series.
Month
Time Series
Value
Forecast
1...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data.
Week
1
2
3
4
5
6
Value
18
13
16
11
17
14
A) What type of pattern exists in the data? (HORIZONTAL
OR TREND)
B) Develop a three-week moving average for this time series.
Compute MSE and a forecast for week 7. If required, round your
answers to two decimal places.
Week
Time Series
Value
Forecast
1
18
2
13
3
16
4
11
_______
5
17
_______
6
14
_______
MSE:...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data:
Month
1
2
3
4
5
6
7
Value
24
13
20
12
19
23
15
Develop a three-month moving average for this time series.
Compute MSE and a forecast for month 8.
If required, round your answers to two decimal places. Do not
round intermediate calculation.
MSE:
The forecast for month 8:
(c)
Use α = 0.2 to compute the exponential smoothing values
for the time series. Compute MSE and a forecast for...
Month 1 2 3 4 5 6 7 Value 24 15 21 13 19 21 16...
Month
1 2 3 4 5 6 7
Value
24 15 21 13 19 21 16
a) Develop a three-month moving average for this time series.
Compute MSE and a forecast for month 8. If required, round your
answers to two decimal places. Do not round intermediate
calculation. MSE:_______ The forecast for month 8________
b) Use α = 0.2 to compute the exponential smoothing values for
the time series. Compute MSE and a forecast for month 8. If
required, round...
The following time series shows the number of units of a particular product sold over the...
The following time series shows the number of units of a
particular product sold over the past six months.
Month
Units Sold
1
9
2
4
3
5
4
6
5
13
6
11
a. Compute the three-month moving average forecast for month
4.
b. Compute the three-month moving average forecast for month
5.
c. Compute the three-month moving average forecast for month
6.
d. Compute the mean squared error (MSE) for the three-month
moving average forecasts.
e. Use α...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data.
Week 1 2 3 4 5 6
Value 18 13 15 13 15 15
(b)
Develop a three-week moving average for this time series.
Compute MSE and a forecast for week 7.
If required, round your answers to two decimal places.
(c) Use α = 0.2 to compute the
exponential smoothing values for the time series. Compute MSE and a
forecast for week 7.
If required, round your answers to two decimal places.
(d)...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 14 minutes ago
asked 23 minutes ago
asked 29 minutes ago
asked 31 minutes ago
asked 45 minutes ago
asked 47 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