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 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
b. Calculate the exponential smoothing with
trend forecast for these data using an α of 0.30, a
δ of 0.30, an initial trend forecast
(T1) of 1.00, and an initial exponentially
smoothed forecast (F1) of 30. (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 | |
The following table contains the demand from the last 10 months: answer to all the boxes...
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...
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: 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
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...
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...
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
My App is a small but growing start-up that sees demand for several of its apps increasing quickly. The table below shows the last six months of downloads. Use a forecast for the first month of 215000, an initial trend forecast of 50000, and smoothing parameters of 0.05 for both demand smoothing and trend smoothing. Month (t) Monthly Application Downloads Forecast for Next Month Trend 215,000.00 50,000.00 1 200,000 2 250,020 3 320,000 4 410,000 5 445,000 6 496,000 (Round...
A large Portland manufacturer wants to forecast demand for a piece of pollution-control equipment. A review of past sales (At), as shown below, indicates that an increasing trend is present. Smoothing constants are assigned the values of a = 0.20 and ß = 0.4. The firm assumes the initial forecast for month 1 (F1) was 9.00 units and the trend over that period T1 was 2.00 units. Using trend-adjusted exponential smoothing, Forecasts (Ft), Trend (Tt), and Forecasts Including Trend (FIT+)...