Professor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gatherethe following data:Week6 weeks ago5 weeks ago4 weeks ago3 weeks ago2 weeks ago# Students8311095806550Last weekWhat is this week's forecast using trend adjusted (double) smoothing with alpha=0.5 and beta = 0.1, if the smoothed forecast for last week was 60, and the smoothed trendestimate for last week's forecast was -5?49.3O 50.647.365.442.7

The Adjusted for Trend When there is a trend component in the time series, the more advanced…

Answered: Professor Very Busy needs to allocate…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Demand for oil changes at Garcia's Garage has been as follows: Number of Oil Changes January 44 February 49 March 66 IT April 59 May 53 June 58 59 63 Month July August a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For Janu The forecasting model is given by the equation Y=+x. (Enter your responses rounded to two decimal places) J Show Transcribed Text >. Use the model to forecast demand for September, October, and November. Here, X=9, 10, and 11, respectively. (Enter your responses rounded to two decimal places.) Forecast for the number of Oil Changes Show Transcribed Text Month September October November can you do all the parts please corrrect
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 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38
Demand for oil changes at Garcia's Garage has been as follows: Month January February March April May June July August Number of Oil Changes 38 55 56 60 58 01 70 52 a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For January, let X=1; for February, let X 2; and so on. The forecasting model is given by the equation Y=X (Enter your responses rounded to two decimal places)
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)
A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The t below shows the number of emergencies each evening. Weekday Number of calls each day Monday 10 Tuesday 2 Wednesday 12 Thursday 12 (Round your answer to 1 decimal place.) What would be their forecast for the emergencies on Friday using a two-day moving average approach? Forecast for Friday calls
Professor Very Busy needs to allocate time next week to include time for office hours. He needs to forecast the number of students who will seek appointments. He has gathered the following data: Week 6 weeks ago 5 weeks ago 4 weeks ago 3 weeks ago 2 weeks ago Last week # Students 83 110 95 80 65 50 What is this week's forecast using trend-adjusted (double) smoothing with alpha = .5 and beta = .1, if the forecast for last week was 65, the forecast for two weeks ago was 75, and the trend estimate for last week's forecast was -5? 49.3 78.7 51.3 50.6 65.4
One forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01
A security company had to deploy guards for emergencies multiple times in the last four evenings. The numbers of emergencies for Monday, Tuesday, Wednesday, and Thursday were 7, 4, 8, and 11, respectively. What would be the security company's forecast for the number of emergencies on Friday using an exponential smoothing forecasting approach? (Use \alpha= 0.2 and a forecast for Monday of 10 emergencies)
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146 a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.20 to estimate April through September, using the average of January through March as the initial forecast for April. c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS