Question

Use the first 9 months to forecast for October 2019 using the following than calculate  Exponential smoothing...

Use the first 9 months to forecast for October 2019 using the following than calculate  Exponential smoothing with αlpha=0.2
2019 Monthly Demand = [1,058,895] [1,098,476] [1,714,796] [1,469,545] [2,141,204] [940,652] [1,471,479] [1,557,795] [1,873,287]

Homework Answers

Answer #1

Forecast for next month = Alpha * Actual of previous month +(1-Alpha) *Forecast of the previous month.

Since we don't have forecast for Month 1, we take it as actual

Month Actual Sales Exponential forecast, Alpha= 0.2
1 1058895 10,58,895
2 1098476 1058895.00
3 1714796 1066811.20
4 1469545 1196408.16
5 2141204 1251035.53
6 940652 1429069.22
7 1471479 1331385.78
8 1557795 1359404.42
9 1873287 1399082.54
OCT 0.2*1873287+0.8*1399082.54=1493923.43
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
Use exponential smoothing, with alpha=0.2, to calculate the forecasts for percent utilization below. June's forecast was...
Use exponential smoothing, with alpha=0.2, to calculate the forecasts for percent utilization below. June's forecast was 90% utilization and actual usage was 94% utilization.     a. Calculate the forecast of percent utilization for July. (Round your final answer to 2 decimal places.)       Forecast for July ______percent of utilization       b. If usage in July was 98 percent, calculate the forecast of percent utilization for August. (Round your answer to 2 decimal places.)       Forecast for August _____percent of capacity  
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97
Use exponential smoothing with ? = 0.4 to forecast donut sales for May. Assume that the...
Use exponential smoothing with ? = 0.4 to forecast donut sales for May. Assume that the forecast for January was for 28 donuts. Month Donut Sales January 32 February 33 March 28 April 39 Use Excel Quiz 5, Exponential Smoothing, round to two decimal places
A) Forecast the demand for the next 4 periods using Exponential Constant Smoothing. Demand for 6...
A) Forecast the demand for the next 4 periods using Exponential Constant Smoothing. Demand for 6 periods is as follows: Period 1 2 3 4 5 6                                                                   Demand 20 22 21 18 19 28 B) Determine the bias
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.1. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97 Group of answer choices A) MAD=296.6, MSE=1266.5 B) MAD=296.6 , MSE=11398.5 C)...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for periods 3 through 10. Use the value for the first period as the forecast for the second period. Compute forecasts using α = 0.8. Compute the MAD and MSE. Time period Value 1 27 2 31 3 58 4 63 5 59 6 66 7 71 8 86 9 101 10 97 Group of answer choices a) MAD=9.7, MSE=1585.6 b) MAD=9.7, MSE=176.2 c) MAD=10.2,...
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...
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....
Rite Aid pharmacy in Big Rapids, Michigan is using simple exponential smoothing to predict monthly birthday...
Rite Aid pharmacy in Big Rapids, Michigan is using simple exponential smoothing to predict monthly birthday card sales. At the end of October 2004, the pharmacy’s forecast for November 2004 sales was 400. In November, 420 cards were sold, and during December, 425 cards were sold. At the end of December 2004, what is the pharmacy’s forecast for the total number of cards that will be sold during March and April of 2005? Use .
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 =
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT