6. Tutoring Center needs to allocate tutors this week for office appointments, so it needsto forecast the number of students who will seek appointments. The director hasgathered the following time series data recently:Time PeriodCodeStudent AppointmentsJan 6 - 10195Jan 13 - 17280Jan 20 - 24365Jan 27 - 31450a) What is the naïve forecast for the number of student appointments for TimePeriod 5 (Feb 3 – 7)?b) What is the 2 week moving average for Time Period 5?c) What is the 3 week moving average for Time Period 5?d) What is the forecast for Time Period 5 using exponential smoothing with alpha =0.2 and a forecast 90 for Time Period 3?e) Is demand for appointments increasing or decreasing?

Note: - Since we can answer only up to three subparts we will answer the first three(a, b, and c)…

Answered: 6. Tutoring Center 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

Please solve this
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.
A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 45 percent of capacity, actual usage was 52 percent of capacity. A smoothing constant of .05 is used. a. Prepare a forecast for September. (Round your final answer to 2 decimal places.) Forecast for September percent of capacity b. Assuming actual September usage of 52 percent, prepare a forecast for October usage. (Round your answer to 2 decimal places.) Forecast for October percent of capacity
Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
Naïve method versus three period Moving Average The number of major plumbing repair jobs performed by Augur’s Plumbing Service in each of the last six months is listed below. Month Jobs October 92 November 94 December 98 January 95 February 99 March 104 Use the ‘textbook’ naïve method to forecast April jobs (Ft+1 = Xt + (Xt – Xt-1). Use the three- period moving average to forecast jobs in April Based upon the MAD (mean absolute deviation), determine whether the three-period moving average or textbook naïve method is more accurate, based upon forecasts for January through March.
b5 need urgent in 15 minutes
Time period Actual sales 1 18 2 22 If the forecasting value of period 3 is 19.6 using exponential smoothing, the smoothing constant is what?
4 Trinity General Hospital had the following number of patient admissions during the past 8 weeksWeek Patient Admissions1 1202 1453 954 1125 1306 1107 1008 140 a. Develop a 3-week weighted average forecast forWeek 4 through 9 with weightsW1 = 0.2W2 = 0.3W3 = 0.5 b. Forecast patient admissions for week 9 using simpleexponential smoothing with α = 0.2. Assume that the forecast for Week 2 (F2) is the naïve forecast.
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 Week 1 Actual Passenger Miles (in thousands) 17 Week Forecasted Passenger Miles (in thousands) a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responses to two decimal places). 10 11 4 5 6 7 8 9 23 18 16 20 18 22 20 15 2 1 3 4 6 7 17.00 17.00 17.80 18.04 19.03 18.83 18.26 5 8 18.61 9 18.49 19.19 10 12 22 11 12
1 The demand for automobiles at Crescent Auto Dealers for the past 8 weeks is as follows. Week Auto Demand Weights1 9 0.12 11 0.33 8 0.64 125 106 137 78 12a Develop a 3-week moving average forecast for Weeks 4 through 9b Develop a 3-week weighted average forecast…

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