Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Operation Management Expert

A. Exponential Smoothing, Trend-Adjusted Exponential Smoothing, Moving Average, Weighted Moving Average, Regression Model, Forecast Error. Note: You may wish to use Excel. A ‘starter’ spreadsheet will be placed on Blackboard for you to use.

The number of heart surgeries performed at Heartville General Hospital has increased steadily over the past several years. The hospital’s administration is seeking the best method to forecast the demand for such surgeries in year 6. The data for the past 5 years are shown. Six years ago, the forecast for year 1 was 41 surgeries, and the estimated trend was an increase of 2 per year.

Year Demand

1 45

2 50

3 52

4 56

5 58

The hospital’s administration is considering the following forecasting methods.

i. Exponential smoothing, α = 06.

ii. Exponential smoothing, α = 0.9

iii. Trend-adjusted exponential smoothing (α = 06 01 ., . β = )

iv. Three-year moving average

v. Three-year weighted moving average (using weights 3/6,2/6,1/6), with more recent data given more weight

vi. Regression model, Y=42.6+3.2X, where Y is the number of surgeries and X is the index for the year (e.g., X=1 for year 1, X=2 for year 2, etc.)

a. If MAD is the performance criterion chosen by the administration, which forecasting method should it choose?

b. If MSE is the performance criterion chosen by the administration, which forecasting method should it choose?

c. If MAPE is the performance criterion chosen by the administration, which forecasting method should it choose?

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91767167

Have any Question? 


Related Questions in Operation Management

What are the components of and steps in the collective

What are the components of and steps in the collective bargaining process? Evaluate them.

Consumer purchases are influenced strongly by cultural

Consumer purchases are influenced strongly by cultural, social, personal, and psychological characteristics. What are the various types of cultural factors that influence consumer behavior and how do they interact with o ...

Select three metrics that you will use in your assignment 3

Select three metrics that you will use in your assignment 3 to measure the effectiveness of the HR programs at the end of the transformation you will design.

Hey my name is marion and i need help with chapter 4 end of

Hey my name is Marion and I need help with chapter 4 end of chapter question # 8. a. When, if ever, may an employer ask a candidate or employee for a photograph as part of recruitment, selection or employment procedures? ...

As part of your doctoral seminar for this set of weeks you

As part of your Doctoral Seminar for this set of weeks, you are participating in a seminar-style discussion about the weekly topics. Please select 4 resources from the required reading and select 3 resources from the Wal ...

Looking for assistance writing this paper thank you in

Looking for assistance writing this paper, thank you in advance. Final Project Part 1: Culture Analysis Paper You will be asked to analyze an organizational culture. This could be the organization you work with, or it co ...

Option operations management forecasting for retail and

Option : Operations Management Forecasting for Retail and Real Estate Industries Solve the following forecasting problems at the end of Chapter 4 in the Heizer & Render (2014) textbook: 4.23 a, b, and c. 4.35 a, b, c, an ...

Answer the questiontraining and development1 discuss the

Answer the question: TRAINING AND DEVELOPMENT 1. Discuss the advantages and disadvantages of training selection programme 2. Explain the effective selection process for the training programme 3. Detail the issues as to w ...

The beaver furniture company manufactures and assembles

The Beaver Furniture Company manufactures and assembles chairs, tables, and bookshelves. The plant produces semifinished products that are assembled in the company's assembling facility. The (unassembled) monthly product ...

1 what is the purpose of controls describe any three types

1. What is the purpose of controls? Describe any three types of control systems. 2. What are the characteristics of effective project teams? 3. Describe the four things that are necessary to promote the partnership idea ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen