Question: I need part D and E only to be solved The following data represents number of customers arriving at Quick Lube for an oil change

I need part D and E only to be solved The
I need part D and E only to be solved
The following data represents number of customers arriving at Quick Lube for an oil change between 9 and 11 AM over the past 6 days. Day 1 2. 3 4 5 6 Customers 34 33 35 36 36 37 Round all answers to 2 Decimal Places a) Using the Naive Method, how many customers would you forecast for Day 7? 37 b) Using 3 day Moving Average, how many customers would you forecast for Day 7? 36.33 c) Using Exponential Smoothing with alpha=.3, how many customers would you forecast for Day 7? (hint: use Actual Value for period 1 as period 2 forecast) 35.64 d) If the actual # of customers for period 7 was 38, compute the MAD statistic for each method (parts a, b and c) using periods 4, 5, 6 and 7 as data points. Compute MAD for all three Methods: Naive Method: 3-Day Moving Average: Exponential Smoothing: e) Which method produces the best forecasts for Quick Lube? Enter either (enter Exactly as displayed - copy and paste your answer): Naive, 3-Day or Exponential

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

Students Have Also Explored These Related General Management Questions!