1. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use x= 0.1. What is the forecast for the 25th week? 2. Reforecast each period using x = 0.6. 3. Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast? 4. Assuming an initial forecast for week 1 of 50 calls, prepare a 3-yr weighted moving average with the weights 0.50, 0.30, and 0.20. 5. In relation with #4, record actual calls during 25n week as 85, which between exponential smoothing with oc = 0,6 and 3-yr weighted moving gvergge?

1. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use x= 0.1. What is the forecast for the 25th week? 2. Reforecast each period using x = 0.6. 3. Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast? 4. Assuming an initial forecast for week 1 of 50 calls, prepare a 3-yr weighted moving average with the weights 0.50, 0.30, and 0.20. 5. In relation with #4, record actual calls during 25n week as 85, which between exponential smoothing with oc = 0,6 and 3-yr weighted moving gvergge?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
In the Atlanta area, the number of daily calls for the repair of Speedy copy machines has been recorded as follows: October Calls 1 92 2 127 3 106 4 165 5 125 6 111 7 178 8 97 Prepare a three-period moving-average forecast for periods 4-8. What is the error on each day? Prepare a three-period weighted moving average forecast for periods 4-8 using weights of w1=.5, w2=.3, w3=.2 Which of the two forecasts is better? (Use CFE to calculate the better method)
Emergency calls to Winter Park, Florida’s 911 system, for the past 24 weeks are as follows: Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use = 0.1. What is the forecast for the 25th week? Reforecast each period using = 0.6.
The director of the Riley County, Kansas, library system would like to forecast evening patron usage for next week. Below are the data for the past 4 weeks: Mon Tue Wed Thu Fri Sat Week 1 210 178 250 215 160 180 Week 2 215 180 250 213 165 185 Week 3 220 176 260 220 175 190 Week 4 225 178 260 225 176 190 a) Calculate a seasonal index for each day of the week (enter your responses rounded to three decimal places). Day of the week Mon Tue Wed Thu Fri Sat Seasonal index
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 450 410.00 2006 495 422.00 2007 518 443.90 2008 570 466.13 2009 585 497.29 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 75.73 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 410.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 410.00 434.00 470.60 499.04 541.62 567.65 The MAD for a forecast developed using exponential smoothing with a = 0.60 is sales (round your response to two decimal places).
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Forecasted Year Sales Sales 2005 450 410.00 2006 495 422.00 2007 518 443.90 2008 570 466.13 2009 585 497.29 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 75.73 sales (round your response to two decimal places). Forecasted sales for years 2006 through 2010 using exponential smoothing with a = 0.60 and a starting forecast of 410.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 410.00
Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Quarter Winter Year 1 Spring Year 1 Summer Year 11 Fall Year 1 Guests (in thousands) 68 99 149 75 65 84 Quarter Summer Year 2 Fall Year 2 Winter Winter Year 3 Spring Year 3 Summer Year 3 Fall Year 3 Guests (in thousands) 120 51 99 151 Winter Year 2 207 Spring Year 2 97 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places): Season Index
A particular forecasting model was used to forecast a six-month period. Here are the forecasts and actual demands that resulted: FORECAST ACTUAL April 256 206 May 328 252 June 403 330 July 353 305 August 378 324 September 452 395 a. Find the tracking signal for each month. (Negative values should be indicated by a minus sign. Round your answers to the nearest whole number.) A particular forecasting model was used to forecast a six-month period. Here are the forecasts and actual demands that resulted: FORECAST ACTUAL April 256 206 May 328 252 June 403 330 July 353 305 August 378 324 September 452 395 a. Find the tracking signal for each month. (Negative values should be indicated by a minus sign. Round your answers to the nearest whole number.)
The Holt method (exponential smoothing with trend andwithout seasonality) is being used to forecast weekly carsales at TOD Ford. Currently, the base is estimated to be 50cars per week, and the trend is estimated to be 6 cars perweek. During the current week, 30 cars are sold. Afterobserving the current week’s sales, forecast the number ofcars to be sold during the week that begins three weeks afterthe conclusion of the current week. Use a b 0.3.
State the impacts of covid -19 on forecasting of airline industry ?
Following data on the demand for sewing machines manufactured by Taylor and Son Co. have been compiled for the past 10 years. Year 1971 1972 1973 1974 1975 78 1976 1977 1978 1979 99 1980 106 Demand 58 65 73 76 87 88 93 in (1000 units) Please estimate the value of demand for next 3 years using trend analysis.