The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past years. The hospital's administration is seeking the best method to forecast the demand for such surgeries in 1998. The data for the past five years are shown. Six years ago, the forecast for 1993 was 41 surgeries, and the estimated trend was an increase of 2 per year. Year Demand 1993 45 1994 50 1995 52 1996 56 1997 58 The hospital's administration is considering the following forecasting methods. i. Trend-adjusted exponential smoothing with a= 0.6 and ß = 0.1 ii. Regression Model, y = 42.6 + 3.2x where y is the number of surgeries and x is the index for the year. 1. Find the MAD for trend-adjusted exponential smoothing for a and ß. Present the data in a table. 2. Find the standard error of estimate. 3. Coefficient of determination 4. Confidence interval at 95% from 1993 to 1997 and give your interpretation. 5. Prediction interval at 95% from 1993 to 1997 and give your interpretation. 6. Which method is best to use by the hospital administration, exponential smoothing or regression model? 引
The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past years. The hospital's administration is seeking the best method to forecast the demand for such surgeries in 1998. The data for the past five years are shown. Six years ago, the forecast for 1993 was 41 surgeries, and the estimated trend was an increase of 2 per year. Year Demand 1993 45 1994 50 1995 52 1996 56 1997 58 The hospital's administration is considering the following forecasting methods. i. Trend-adjusted exponential smoothing with a= 0.6 and ß = 0.1 ii. Regression Model, y = 42.6 + 3.2x where y is the number of surgeries and x is the index for the year. 1. Find the MAD for trend-adjusted exponential smoothing for a and ß. Present the data in a table. 2. Find the standard error of estimate. 3. Coefficient of determination 4. Confidence interval at 95% from 1993 to 1997 and give your interpretation. 5. Prediction interval at 95% from 1993 to 1997 and give your interpretation. 6. Which method is best to use by the hospital administration, exponential smoothing or regression model? 引
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
Related questions
Question
Lesson about Forecasting : Linear Regression and Measures of Variations, view the photo for details. Help me pls.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 8 images
Recommended textbooks for you
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
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
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
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing