Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer only Part B and C with complete steps to get 100% feedback!! a) The last seven weeks of demand at a new car dealer
Answer only Part B and C with complete steps to get 100% feedback!! a) The last seven weeks of demand at a new car dealer are shown below. Use three-period moving average to determine a forecast for the week 4, week 5, week 6, and week 7. Calculate the MAD. (4 points) Week SalesForecasting 118 230 3 24 | 435 5 30 632 | 736 b) With the same sales data in part (a), use exponential smoothing with an alpha of 0.5 to determine a forecast from week 2 to week 7 with an initial forecast of 18 for Week 1. Calculate the MAD. (5 points) Week Sales Forecasting (alpha=0.5) 11818 2 30 435 5 30 6 32 | 736 c) Which method will you use? Give your explanation. (2 points)
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