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

I a spokes person managerial role a ceo may persuade

In a spokes person managerial role, a CEO may persuade investment analyst that his or her company is persuing a good strategy. What is the likely outcome of this?

Which of your current beliefs choose one or two around

Which of your current beliefs (choose one or two) around Management do you wish could change (describe it) and why? Identify one or two beliefs your organization has (that may be different from your own) about Management ...

Problem suppose that a customer calls a call-center every

Problem: Suppose that a customer calls a call-center every minute on average and an agent can help a customer in 3 minutes on average. Both the time between customer calls and the time it takes an agent to help a custome ...

In this module we describe several tools for monitoring

In this module, we describe several tools for monitoring projects, including checklists, spreadsheets, percent complete, tracking Gantt Charts, and earned value. a. Create a three-column table with each of these in the l ...

Read ldquosiemens energy in 2010 how to engineer a green

Read “Siemens Energy (in 2010): How to Engineer a Green Future?” What are some potential entry barriers for developing new energy-related products, services, and technologies?

Assignment 2 analyze and briefnbspone occupational safety

Assignment #2 Analyze and brief one Occupational Safety and Health Review Commission decisions by Administrative Law Judges or Commissioners. You can access these decisions from the Occupational Safety & Health Review Co ...

In this assignment you will outline and briefly comment on

In this assignment, you will outline and briefly comment on your ideal comp and benefits program in a one-two page essay. Instructions: Read relevant information in the Unit's readings. In a Word document, write an essay ...

Which of the following is not a condition for reporting

Which of the following is not a condition for reporting revenues? The customer has already paid for the good or service. The goods or services have been delivered. The price is fixed or determinable. Collection is reason ...

Please explain how each department in a company could

Please explain how each department in a company could approach assessing customer expectations of a new product launch product. Describe how to use a TQM approach for fulfilling customer expectations associated with a ne ...

1 what are the characteristics of effective project teams2

1. What are the characteristics of effective project teams? 2. Describe the four things that are necessary to promote the partnership idea between the project manager and the team.

  • 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