Question

The “Economic Report to the President of the United States” included data on the amounts of...

The “Economic Report to the President of the United States” included data on the amounts of manufacturers′ new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 8-year period:

Year Order
1 54,097
2 54,259
3 55,022
4 55,921
5 62,941
6 64,182
7 72,553
8 76,003

What would be the forecast for years 2, 3, 4, 5, 6, 7, 8 and 9 using simple exponential smoothing model, given α = 0.3.

Homework Answers

Answer #1

For second year by using formula

54097+0.3⋅(54097−54097)=54097

For third year

54097+0.3⋅(54259−54097)=54145.6

For fourth year

54145.6+0.3⋅(55022−54145.6)=54408.52

For fifth year

54408.52+0.3⋅(55921−54408.52)=54862.264

For sixth year

54862.264+0.3⋅(62941−54862.264)=57285.8848

For seventh year

57285.8848+0.3⋅(64182−57285.8848)=59354.7194

For Eigth year

59354.71936+0.3⋅(72553−59354.71936)=63314.2036

For ninth year

63314.203552+0.3⋅(76003−63314.203552)=67120.8425

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 “Economic Report to the President of the United States” included data on the amounts of...
The “Economic Report to the President of the United States” included data on the amounts of manufacturers’ new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 21-year period. GB513: Business Analytics 3 of 6 Use the charting tool in Excel to develop a regression model to fit the trend effects for the data. Use a linear model and then try a polynomial (order 2) model. Make sure the charts show the...
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 α...
Suppose ten weeks of data on the Commodity Futures Index are 7.34, 7.39, 7.54, 7.56, 7.61,...
Suppose ten weeks of data on the Commodity Futures Index are 7.34, 7.39, 7.54, 7.56, 7.61, 7.52, 7.51, 7.71, 7.63, and 7.55. (a) What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern.      The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. (b)Compute the exponential smoothing forecasts for α = 0.2. (Round your answers to two decimal places.) Week...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are...
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following​ table: Year 1 2 3 4 5 6 7 8 9 10 11 Registrations (000) 5.00 7.00 5.00 5.00 9.00 9.00 8.00 11.00 13.00 14.00 15.00 ​a) Calculate the forecasted registrations for years 2 through 12 using exponential​ smoothing, with a smoothing constant (α​) of 0.30 and a starting forecast of 6.00 for year 1 Year 1 2 3 4...
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...
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following methods and suggest the best forecasting model 1. Simple Moving Average (Three Period) 2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3) 3. Exponential Smoothing (α=.1), F1= y intercept from regression) 4. Exponential Smoothing (α=.3), F1= y intercept from regression) 5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y intercept from regression)** 5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y intercept from regression)** 6....
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...
Use a simple exponential smoothing model (SES) with alpha of .4. The forecast for period 8...
Use a simple exponential smoothing model (SES) with alpha of .4. The forecast for period 8 is? period Y 1 50 2 85 3 65 4 90 5 88 6 90 7 110 8 Forecast period 8 =
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT