Compute seasonal relatives for this data using the simple averaging (SA) method: (Round all your answers to three decimal points.) Obtain estimates of daily relatives for the number of customers at a restaurant for the evening meal, given the following data. Click here for the Excel Data File a. Use the centered moving average method. (Hint: Use a seven-day moving average.) (Round your intermediate calculations and final answers to 4 decimal places.) b. Use the SA method. (Round your intermediate calculations and final answers to 4 decimal places.) The table below shows actual and forecasted nubmers of accounts serviced by a company. Compute MAD, MSE, and MAPE for the following data, showing actual and forecasted numbers of accounts serviced. (Enter whole number values in the table below for Error, IErrorl, and Error^2. Round the IErrorl/Actual to three decimals. Enter 0 where necessary, do not leave any cells blank. Negative values should be indicated with a minus sign, i.e. -2. Round MAD, MSE and MAPE to 3 decimal places.) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows: a. Compute a tracking signal for the 10th month for each forecast using the cumulative error for months 1 to 10 . Use action limits of 4. Is there bias present? (Do not round your intermediate calculations. Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign.) b. Compute 2s control limits for each forecast. (Do not round your intermediate calculations. Round your answers to 2 decimal places.) Actual demand for the past 16 periods is shown below. Prepare a trend adjusted exponential smoothing forecast using the following parameters: =.3,=.1,TAF5=710.67, and T5=3.15. (Round all your answers to two decimal points.)