Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ng years 3 and respectively. What do you serve? Print 9. Use a spreadsheet program to compare a three-period moving average forecasting model with
ng years 3 and respectively. What do you serve? Print 9. Use a spreadsheet program to compare a three-period moving average forecasting model with a basic exponential smoothing model (ESF). Ten periods of past actual demand data are available (27, 26, 32, 41, 28, 35, 43, 47, 28, and 38). Use the first five periods data to seed the model (as described next) and the last 5 periods to test the model. a. Use the average of the first five periods to seed the ESF model (i.e., the "past forecast") and a smoothing model with a 0.3. Compare this ESF model with a 3-period moving = average model using the last 5 periods of data. Use MAD as the criterion for comparing the techniques. b. Does your comparison change if you use the past three periods data to seed the ESF model? What is the best alpha (smoothing) value to use for this model?
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