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

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

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 file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
1. The number of bushels of apples sold at a roadside fruit stand over a 12-day period were as follows: Day Numbar Sold Day Number Sold 25 35 31 8. 32 29 9. 10 38 33 34 37 40 37 32 11 12 If a two-period moving average has been used to forecast sales, what were the daily forecasts starting with the forecast for day 3? If a four-period moving average has been used, what were the forecasts for eacn uay starting with day 5? Plot the original data and each set of forecasts on the same graph. Which forecast has the greater tendency to smooth? Which forecast has the better ability to respond quickly to changes? What does use of the term sales instead of demand imply? a. b. C. 123 4 56
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places) 16
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 Tom is interested in implementing a forecasting system and is investigating the following forecasting methods as possibilities: calculate forecasts for Year 11 using the Regression method ( show formuals using excel)
Since the beginning of the year, the purchase manager at a department store has been recording sales data to be used to compute 4-period moving averages to forecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. Month January February March April May June July August September Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average forecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average forecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding. CHECK ANSWER
Professor Z needs to allocate time among several tasks next week to include time for students' appointments. Thus, he needs to forecast the number of students who will seek appointments. He has gathered the following data: Week Number of students6 Weeks ago 515 Weeks ago 794 Weeks ago 833 Weeks ago 892 Weeks ago 71Last Week 93 What is this week's forecast using exponential smoothing with alpha = 0.3 , if the forecast for two weeks ago was 77 ? a. 75.2 b. 78.8 c. 69.86 d. 80.54
1. The number of bushels of apples sold at a roadside fruit stand over a 12-day period were PROBLEMS as follows: Day Numbar Sold Day Number Sold 25 35 31 29 33 32 38 10 40 37 32 34 11 37 12 If a two-period moving average has been used to forecast sales, what were the daily forecasts starting with the forecast for day 3? If a four-period moving average has been used, what were the forecasts for eacn uay starting with day 5? Plot the original data and each set of forecasts on the same graph. Which forecast has the greater tendency to smooth? Which forecast has the better ability to respond quickly to changes? What does use of the term sales instead of demand imply? b. C. 2. If exponential smoothing with a = .4 had been used to forecast daily sales for apples in Problem 1, determine what the daily forecasts would have been. Then, plot the original data, the exponential forecasts, and a set of naive forecasts on the same graph. Based on a visual comparison, is the naive more accurate or…
The number of fishing rods selling each day is given below. Perform analyses of the time series to determine which model should be used for forecasting. 3 day moving average analysis 4 day moving average analysis 3 day weighted moving average analysis with weights W1=0.2, W2=0.3 and W3=0.5 with W1 on the oldest data. Exponential smoothing analysis with A=0.3 Which model provides a better fit of the data? Forecast day 13 sales of fishing rods using the model chosen in part (e) Day Rods Sold 1 60 2 70 3 110 4 80 5 70 6 85 7 115 8 105 9 65 10 75 11 95 12 85 Please read the relevant article, found in the VLE, before answering the question. Discuss the process and findings of the study of the article. Suggest a possible study that could be done at your current or past job that could use a similar methodology and analysis.
Explain different forecasting techniques like moving averages, exponential smoothing, regression etc.
The monthly sales (in units) for a refrigerator in April 2021 through September 2021 were as follows: 42, 56, 49, 41, 56, 59 What is the forecasted sales in August 2021 if you use exponential smoothing with a smoothing constant 0.31? Assume the forecast in April 2021 was 44 units. Use at least 4 decimals.
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).