3. The Bank of Humber is interested in finding a good technique of forecasting short term changes in branch demands to better plan their staffing allocation. To accomplish this objective, the bank has been reviewing information on the number of customers doing business at the Rexdale branch on daily basis. The following table shows the number of customers that visited the bank each weekday over the last four weeks (1=Monday, 2 = Tuesday, 3 = Wednesday, 4 = Thursday, 5=Friday): Week Day Customers Week Day Customers 1 1 184 3 1 180 2 140 2 146 3 171 3 174 191 4 192 5 208 5 211 2 176 4 1 190 NO 142 2 146 3 170 3 165 4 184 4 188 5 214 5 207 Use Excel to answer the following questions. Do not round intermediate results. Round MADs to 4 decimal places. a. Using 5-period moving averages, calculate the forecasts and compute MAD. [1 point] b. Using 5-period weighted moving averages, with weights 0.1, 0.1, 0.25, 0.25, and 0.3 respectively, calculate the forecasts and compute MAD. [1 point] c. Use exponential smoothing with a = 0.4 to calculate forecasts and compute MAD. [1 point] d. Which method is the best, comparing a), b), and c)? [1 point]