Compute the forecast using exponential smoothing with a smoothing constant of 0.15 and a forecast for...
|
Compute the forecast using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD? |
|
| Week | Miles |
| 1 | 21,000 |
| 2 | 25,000 |
| 3 | 24,000 |
| 4 | 26,000 |
| 5 | 22,000 |
| 6 | 25,000 |
| 7 | 24,000 |
| 8 | 24,000 |
| 9 | 22,000 |
| 10 | 24,000 |
| 11 | 23,000 |
| 12 | 24,000 |
| 13 | 23,000 |
| 14 | 22,000 |
| 15 | 24,000 |
Homework Answers
Compute the forecasts using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD?
MAD measures the spread of the forecast error or in other words, the measurement of the size of the error in units. It is the absolute value of the difference between the real demand and the forecast, divided over the number of periods.
Add Answer to:
Compute the forecast using exponential smoothing with a
smoothing constant of 0.15 and a forecast for...
In Excel, create a forecast for periods 6-13 using the following method: Exponential smoothing (alpha =...
In Excel, create a forecast for periods 6-13 using the following method: Exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); With exponential smoothing, the forecast for period 13 will be: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 Thank you :)
i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the...
i. Find the forecast for week 13.
ii. Now obtain the exponential smoothing forecast for the
weeks.
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...
Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for...
Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62
An analyst is using exponential smoothing to forecast the daily demand for a key product. The...
An analyst is using exponential smoothing to forecast the daily demand for a key product. The analyst starts with a naive forecast for time period 2, then begins using exponential smoothing with a smoothing constant of 0.15. The table below shows some of the calculations. period actual forecast 1 125 2 136 125 3 144 126.65 4 157 129.25 5 181 ? What is the predicted demand for time period 5? Round your answer to two decimal places. Period Actual...
A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for...
A) for the following demand data, use exponential smoothing with alpha = .02 to calculate for perieod 7 assume forecast for period #1 was 7.0 B) Calculate the MAD error for periods 1-6 for your forecast period demand 1 10 2 8 3 7 4 10 5 12 6 9
Predict Inc., is using a simple exponential smoothing model to forecast their monthly sales but they...
Predict Inc., is using a simple exponential smoothing model to forecast their monthly sales but they are not sure of the best alpha value to use. They ran some computerized forecasts with different alpha values and reported the following. What alpha value should they use? alpha 0.15 0.20 0.25 0.30 0.35 0.40 0.45 0.50 MAD 18.4 14.7 13.2 16.2 15.3 11.7 10.2 12.5 Group of answer choices 0.45 0.15 0.2 0.35 0.5
(a) A firm uses simple exponential smoothing with a = 0.1 to forecast demand. The forecast...
(a) A firm uses simple exponential smoothing with a = 0.1 to forecast demand. The forecast for the week of January 1 was 500 units, whereas actual demand turned out to be 450 units. Determine the forecast demand for the week of January 8. (b) What is the difference between a causal model and a time-series model?
Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE...
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. What am i doing wrong in this problem?
Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha =...
Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha = 0.2 to calculate a forecast for period 7. Assume the forecast for period #1 was 7.0. b) Calculate the MAD error for periods 1-6 for your forecast Period Demand 1 10
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 124 113 2 184 200 3 144 150 4 79 102 5 74 80 6 119 135 7 114 128 8 141 124 9 106 109 10 161 150 11 116 94 12 101 80 13 136 140 14 146 128 a) Compute MAD for the fifth period, then...
i. Find the forecast for week 13.
ii. Now obtain the exponential smoothing forecast for the
weeks.
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...
(a) A firm uses simple exponential smoothing with a = 0.1 to forecast demand. The forecast for the week of January 1 was 500 units, whereas actual demand turned out to be 450 units. Determine the forecast demand for the week of January 8. (b) What is the difference between a causal model and a time-series model?
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. What am i doing wrong in this problem?
Question 11 (10 points) a) For the following demand data, use exponential smoothing with alpha = 0.2 to calculate a forecast for period 7. Assume the forecast for period #1 was 7.0. b) Calculate the MAD error for periods 1-6 for your forecast Period Demand 1 10
Most questions answered within 3 hours.
-
Calculate the moment
of inertia (in kg·m2) of a skater given the following
information.
(a)
The...
asked 36 seconds ago -
A small body of mass m performs small oscillations sliding (no
rolling) along the bottom of...
asked 4 minutes ago -
The electric field in the region between two oppositely charged,
parallel, conducting plates has a magnitude...
asked 3 minutes ago -
A simple random sample was taken to test the claim that the
population mean is no...
asked 1 hour ago -
A set of length measurements are obtained with the values 165.6
± 0.3, 165.1± 0.4,166.4± 1.0,...
asked 1 hour ago -
1. Which of the following is true about unconscionable
contracts?
a. A term is substantially unconscionable...
asked 17 minutes ago -
A company is interested in estimating the costs of lunch
in their cafeteria. After surveying employees,...
asked 50 minutes ago -
A 0.2m diameter ball with an initial velocity of 8m/s rolls up a
hill without slipping....
asked 32 minutes ago -
I want to redraft the solution, using other words , use your own
words don't copy...
asked 21 minutes ago -
Hyundai Motors is considering threesites—A, B,C —at which to
locate a factory to build its new-model...
asked 23 minutes ago -
Learning Outcomes:
Upon the successful completion of this module, you should
understand the following concepts:
Strategic...
asked 24 minutes ago -
Identify four of the five major types of organizations within
the federal bureaucracy, and give examples...
asked 33 minutes ago