Purchase Solution

Forecasting for Carbondale Hospital: purchase of new ambulance

Not what you're looking for?

Ask Custom Question

The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows

Year Mileage
1 3,100
2 4,000
3 3,500
4 4,000
5 3,700

Forecast the mileage for next year using a 2-year moving average__________
Round your answer to the nearest whole number; for example, 1234

Find the MAD for your forecast in part (a)____________
Round your answer to the nearest whole number; for example, 123 .

Use a weighted 2-year moving average with weights of .4 and .6 to forecast next year's mileage. (The weight of .6 is for the most recent year.) ____________

What is the MAD of this forecast? ____________
Round your answer to the nearest whole number; for example, 123 .

Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,100 miles, and a =.5
____________
Round your answer to the nearest whole number; for example, 1234 .

Attachments
Purchase this Solution
Solution Summary

The solution uses forecasting for Carbondale Hospital to determine when it is optimal to purchases a new ambulance.

Solution Preview

here is the solution to your problem. Excel file contains the calculations and word file contains the answers.

Question 3: (1 point)
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as ...

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Motivation

This tests some key elements of major motivation theories.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting Techniques: Moving Average and Exponential Smoothing

    601669 Forecasting Techniques: Moving Average and Exponential Smoothing The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year.

  • Accounting: Monthly Interest Rates

    Carondelet Hospital is evaluating a lease arrangement for its ambulance fleet. The total value of the lease is $420,000. The hospital will be making equal monthly payments starting today. Questions: a.

  • Financial Forecasting and Forecasting Income Statements

    At the same time, the lack of accessibility for common people to purchase medical insurance policy is also a trend of current healthcare system because of higher insurance premium.

  • Basic Marketing Plan for PMT Ambulance

    A complete series of medical transportation services is provided by this PMT Ambulance from fundamental patient transport services to the most progressed emergency pre-hospital care.

  • Verybest Hospital

    273947 Verybest Hospital: Identify sources of funding and explain role of grant writing Verybest Hospital is a sub-acute facility outside of Santa Rosa, New Mexico.

  • Transportation and Assignment Models

    162811 Transportation and Assignment Models Don Levine Corporation is considering adding an additional plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St.

  • Defibrillators : Capacitator Charge, Negative Exponential, Capacitance and Charge Time

    36163 Capacitator, Negative Exponential, Capacitance & Charge Time Background Information: The paddles of a defibrillator in an ambulance or the emergency room of a hospital are actually the two plates of an electronic device called a capacitor.

  • Inventory Management for Wheeled Coach

    I would implement these suggestions by tabulating a testing phase of the new technique.

  • Positivism versus contsuctitivism

    Others want to talk to doctors, nurses and ambulance crews, to find how they feel about working here and ask for their opinion where the problems lie. Which group would you join and why?

View More Related Solutions