Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Respond to each of the Items using the following time series data. Period Demand 1 46 13 17 19 8 34 9 39 11 30
Respond to each of the Items using the following time series data. Period Demand 1 46 13 17 19 8 34 9 39 11 30 12 23 13 14 27 Click here for the Excel Data File b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (a) of 0.3. (Negative amounts should be Indicated by a minus sign. Round your answers to 3 decimal places.) Period Demand Exponential Error Smooth Absolute Error 1 20 46 20.000 26.000 26.000 W N 20 27.800 7.800 7.800 13 25.460 17 19 34 30 4 11 30 12 23 13 10 14 27 15c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (a) of 0.7. (Negative amounts should be Indicated by a minus sign. Round your answers to 3 decimal places.) Exponential Period Demand Absolute Error Smooth Error 1 20 46 20 4 13 17 A 19 34 30 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started