Question

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28...

The following table contains the demand from the last 10 months:


MONTH ACTUAL DEMAND
1 28
2 30
3 29
4 40
5 43
6 42
7 43
8 45
9 44
10 47

a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 28. (Round your intermediate calculations and answers to 2 decimal places.)

Month Exponential Smoothing
1
2
3
4
5
6
7
8
9
10

b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.20, a δ of 0.30, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 27. (Round your intermediate calculations and answers to 2 decimal places.)

Month FITt
1
2
3
4
5
6
7
8
9
10

c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your intermediate calculations and answers to 2 decimal places.)

MAD
Single exponential smoothing forecast
Exponential smoothing with trend forecast

c-2. Which is best?

Single exponential smoothing forecast
Exponential smoothing with trend forecast

Homework Answers

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 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...
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 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Create a time series plot. What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) 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....
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 15 21 12 19 21 16 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month...
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular product over the past 10 months. Month Value 1 324 2 311 3 303 4 314 5 323 6 313 7 302 8 315 9 312 10 326 a. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE, MAPE and a forecast for month 11. b. Calculate MSE and MAPE for three month moving average ? c. Compare the three-month moving average forecast...
Given is a historical time series for job services demand in the prior 6 months. Month...
Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 20 2 16 3 17 4 19 5 19 6 19 a) The MAD based on the Exponential smoothing α = 0.3 method =  (4 decimal places). b) The MAD based on the 3 months moving average method =  (in 4 decimal places). c) The MSE based on the 3 months moving average method = . d) Use MAD as an criterion to evaluate...
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...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 b) 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...
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...
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.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT