Question: A forecasting method you have been using to predict the number of daily calls into a call center is shown in the following table along





A forecasting method you have been using to predict the number of daily calls into a call center is shown in the following table along with the actual demand that occurred. a. Compute the tracking signal using the mean absolute deviation (MAD) and running sum of forecast errors (RSFE). b. Do you believe the forecasting method is giving good predictions? Terry Tierney has created a website that offers discounted travel packages for senior citizens and has collected the following data on the number of travel packages she has sold per month over the past nine months. She wants to test two different forecasting methods to determine which was better over this nine month period. a. Forecast the number of travel packages sold monthly from April through September using a three-month simple moving average. b. Using simple exponential smoothing to estimate. April through September (Use a= 0.3 and assume that the forecast for March was 1,300). c. Use MAD to determine which forecasting method produced the better forecast over the six-moth period. To determine the future capacity requirements for your call center, prepare a forecast using simple linear regression for each quarter of the coming year from the past two years' historical data. From past history, the number of customers who have eaten lunch at Papaye's restaurant for the past six Monday's is: Required: a. With the following weights, use a weighted moving average to forecast the number of customers for next Monday's lunch. b. Using a simple three-period moving average, find the forecast for next Monday's lunch. c. Using single exponential smoothing with =0.2 and a forecast for last Monday's lunch of 130 customers, calculate the forecast for next Monday's lunch. Make whatever assumptions you wish. List these assumptions. d. Using simple linear regression, calculate the regression equation for the data presented above. e. Using the regression equation in part d, calculate the forecast for next Monday's lunch. A year ago, Deborah Yeboah started a home delivery service for the elderly. Customers place their orders with a local supermarket, drugstore, or other retail establishment that has agreed to participate in this service. Each retail operation then fills its order and Deborah's firm picks up and delivers the merchandise. In addition to a fixed fee she receives per order from her customers, Deborah also receives a small percentage or commission from the retailers. Because she has been able to promise deliveries within three hours, her company has experienced significant growth, as shown in the table below: Because she leases her delivery vans on an annual basis, she wants an estimate of the number of deliveries for each month in the coming year. Using least squares regression analysis, forecast the number of deliveries for each of the next 12 months
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
