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

1- how would a manager use the systematic thinking and the

1- How would a manager use the systematic thinking and the intuitive thinking in problem solving? Give examples. 2- You are under a lot of pressure because the problem situation involves social loafing and poor performan ...

Strategic safety programsafety programs may accomplish

Strategic Safety Program Safety programs may accomplish their purposes in two primary ways: one focusing on unsafe employee actions and the other on unsafe working conditions. Design  a basic safety program of your choic ...

Module review activity you will submit a microsoft excel

Module Review activity, you will submit a Microsoft Excel spreadsheet. Your instructor will use to this assignment to grade your work. You will create a Decision Support System (DSS) using Excel. This practical assignmen ...

The company is mac cosmeticsthis course focuses on the

The Company is MAC Cosmetics This course focuses on the management of processes and the value adding activities that are used to deliver the product (either a good or service) to the customer. The group term project requ ...

Of the items that dr dave ulrich mentioned in the you tube

Of the items that Dr. Dave Ulrich mentioned in the you tube video (in the reading assignments for the week) for preparing for HR transformations, select two that you think are most important for the transformation you wi ...

The concept of if we fight terrorists somewhere else they

The concept of "If we fight terrorists somewhere else, they will not come here" has been bantered about for years. Do preemptive actions work better than a defensive posture (attacking terrorists on home soil)? Explain y ...

Select a topic from the third part of the course--employee

Select a topic from the third part of the course--employee attitudes, satisfaction, benefits, diverse workforce, employee health and safety, work-life balance--that you think is important. Find a resource related to it. ...

Select anynbspfournbspof these six topics and address each

Select any  four  of these six topics and address each question comprehensively: (Please provide references and in-text citations APA Style)  1. It has been said that "a company that deserves a union gets one," suggestin ...

Questionreview material for ilo ansi-z-10 and csa standards

Question: Review material for ILO, ANSI-Z-10 and CSA standards (or from OSHA''s VPP related materials). This assignment is to get you thinking about the gap analysis that you will prepare in the next assignment. Based on ...

The three major sources of error in communication research

The three major sources of error in communication research are: 1- Measurement questions and survey instruments, 2- Interviewers, and 3- Participants. Explain how each source can contribute to error and what you might do ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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