The following table contains the demand from the last 10 months:
| MONTH | ACTUAL DEMAND |
| 1 | 27 |
| 2 | 29 |
| 3 | 33 |
| 4 | 41 |
| 5 | 44 |
| 6 | 43 |
| 7 | 44 |
| 8 | 46 |
| 9 | 47 |
| 10 | 41 |
a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 27. (Round your intermediate calculations and answers to 2 decimal places.)
| Month | Exponential Smoothing |
| 1 | 27 |
| 2 | 27 |
| 3 | 27.6 |
| 4 | 29.22 |
| 5 | 32.75 |
| 6 | 36.13 |
| 7 | 38.19 |
| 8 | 39.93 |
| 9 | 41.75 |
| 10 | 43.33 |
b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.40, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 26. (Round your intermediate calculations and answers to 2 decimal places.)
| Month | FITt |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 |
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 |
Which is best?
| Single exponential smoothing forecast | |
| Exponential smoothing with trend forecast |
Part A is already complete and correct I just need help with the rest.
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 27...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...
The following table contains the demand from the last 10 months: answer to all the boxes plz MONTH ACTUAL DEMAND 1 31 2 34 3 35 4 39 5 40 6 45 7 45 8 47 9 43 10 44 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 31. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 32 3 31 4 38 5 42 6 38 7 42 8 42 9 43 10 43 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 33. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. ACTUAL June 154 July 194 August 225 a. Using a simple three-month moving average, what is the forecast for September? (Round your answer to 2 decimal places.) b. Using a weighted moving average, what is the forecast for September with weights...
excel spreadsheet information:
Month
Sales (in millions of boxes)
1
1306
2
1305
3
1311
4
1313
5
1324
6
1329
7
1346
8
1347
9
1378
10
1394
11
1441
12
1469
Problem 3 You have realized that the sales for Select-A-Size Paper Towel packs have been increasing over the past year. You have learned that the double exponential smoothing method can account for such a trend in the data. Use double (trend-adjusted) exponential smoothing method to forecast sales...
The following table shows the actual demand observed over the last 11 years Year 10 11 Demand 7 4 Using exponential smoothing with α = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 round your responses place) one decimal Year 2 4 10 12 Forecast 6.0
The following table shows the actual demand observed over the last 4 years: ...
2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 10. b. Suppose that exponential smoothing is used with a smoothing constant α-02. Find the exponential smoothing forecasts weeks 4 through 10. (To get the method started, use 120.00 as the forecast...