Answer the following questions using the data from the Excel file daily customers.xlsx described in Problem 16.38:

a. Forecast the number of customers who will visit Dave’s store on Day 9 using a two-period weighted moving average with the weights 5 and 2.

b. Calculate the MAD for the forecast in part a.

c. Forecast the number of customers who will visit Dave’s store on Day 9 using exponential smoothing with trend adjustment and setting a = 0.1 and b = 0.3.

d. Calculate the MAD for the forecast in part c.

e. In which forecast do you have the most confidence?

AppendixLO1