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










Unit 8 Assignment 4 5 points eBook Print References Period 1 2 3 Respond to each of the items using the


 
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.)






PeriodDemandExponential SmoothErrorAbsolute Error
120
246
320
49
519
68
719
834
939
104
1130
1223
1310
1427












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.)






PeriodDemandExponential SmoothErrorAbsolute Error
120
246
320
49
519
68
719
834
939
104
1130
1223
1310
1427
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

655b1b3f9f23e_543094.xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!