Question: b.Compute all possible forecasts using exponential smoothing with a smoothing coefficient () of 0.3.(Negative amounts should be indicated by a minus sign. Round your answers

| b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) | |||||
| Period | Demand | Exponential Smooth | Error | Absolute Error | |
| 1 | 20 | ||||
| 2 | 46 | ||||
| 3 | 20 | ||||
| 4 | 9 | ||||
| 5 | 19 | ||||
| 6 | 8 | ||||
| 7 | 19 | ||||
| 8 | 34 | ||||
| 9 | 39 | ||||
| 10 | 4 | ||||
| 11 | 30 | ||||
| 12 | 23 | ||||
| 13 | 10 | ||||
| 14 | 27 | ||||
| c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (α) of 0.7. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) | |||||
| Period | Demand | Exponential Smooth | Error | Absolute Error | |
| 1 | 20 | ||||
| 2 | 46 | ||||
| 3 | 20 | ||||
| 4 | 9 | ||||
| 5 | 19 | ||||
| 6 | 8 | ||||
| 7 | 19 | ||||
| 8 | 34 | ||||
| 9 | 39 | ||||
| 10 | 4 | ||||
| 11 | 30 | ||||
| 12 | 23 | ||||
| 13 | 10 | ||||
| 14 | 27 | ||||
| 15 | |||||
| d. Compute the MADs for each forecast model. (Round your answers to 3 decimal places.) | |||||
| Average Forecast | |||||
| For an alpha of 0.3, the MAD | |||||
| For an alpha of 0.7, the MAD | |||||
Unit 8 Assignment 4 5 points eBook Print References Period 1 2 3 Respond to each of the items using the following time series data. 8 9 10 11 12 13 14 Demand 20 NOWO AGA 6 0 66 90 46 20 19 8 19 34 39 4 30 23 Soved 10 27 Help Save & Exit Submit Check my work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
655b1b3f9f23e_543094.xlsx
300 KBs Excel File
