Forecast mileage for next year using year moving average

Assignment Help Accounting Basics

Reference no: EM13258718

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

Year Mileage

1 2,900
2 4,000
3 3,200
4 4,400
5 3,700

(a) Forecast the mileage for next year using a2-year moving average.

(b) Find the MAD for your forecast in part(a).

(c) Use a weighted 2-year moving average withweights of .4 and .6 to forecast next year's mileage. (Theweight of .6 is for the most recent year.)

What is the MAD of this forecast?

(d) Compute the forecast for year 6 usingexponential smoothing, an initial forecast for year 1 of 2,900miles.

Reference no: EM13258718

Questions Cloud

What is the change of entropy of the universe : One kilomole of an ideal gas undergoes a free expansion, tripling it's volume. What is the change of entropy of the universe

What is the role of professional organizations in shaping : The nursing profession has been shaped by many great nurses throughout history. How will you help to shape the future of nursing?

Determine what is the potential of the body now : A body attached to earth ground by an electrical conductor is at zero electrical potential. A charge of 25 C is added to the body. What is the potential of the body now. Explain.

A system for globally styling web pages written ian html : Algorithms that have been specialized to a specific set of conditions and assumptions, and written in a specific programming language.

Forecast mileage for next year using year moving average : Forecast the mileage for next year using a2-year moving average. Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 2,900miles.

What is the portfolios new beta : Your retirement fund consists of a $5,000 investment in each of 15 different common stocks. The portfolio beta is 1.20. Suppose you sell one of the stocks with a beta of .08 for $5,000 and use the proceeds to buy another stock whose beta is 1.6. W..

How far apart must the penny and the group of electrons be : Lets assume that one electron is removed from each atom and these electrons are all removed from the penny to a distance such that the force of attraction between the positively charged penny and the removed group of electrons is 2.3 N.

The root word for professional comes from the latin word : Professionalism The root word for professional comes from the Latin word 'profere', which means "to promise." In ancient Rome, a person became a professional by standing in public and stating out loud what promises would be kept.

Operations management for that organization : History and background of the organization, also including the types of goods sold and industry in which the organization operates and the organization's supply chain characteristics - type of supply chain, negotiations strategies, performance of ..

User Account

All Pages