Forecast the mileage for next year

Assignment Help Operation Research

Reference no: EM13709446

Description about Forecasting Techniques: Moving Average and Exponential Smoothing

Problem- 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,000

2 4,000

3 3,400

4 3,800

5 3,700

Part 1) Forecast the mileage for next year (6th year) using a 2 year moving average.

Part 2) Find the MAD based on the 2 year moving average. (Hint; You will have only 3 years of matched data).

Part 3) Use a weighted 2 year moving average with weights of .4 and .6 forecast next year's mileage. (The weight of .6 is for most recent year.) What MAD results from using this approach to forecasting? (Hint; You will have only 3 years of matched data).

Part 4) Complete the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,000 miles and a = .5

I need help to describes depict the steps to forecast the mileage by moving average and exponential smoothing techniques.

Reference no: EM13709446

Questions Cloud

3-pentanone octane compounds is most soluble in water : Problem- Which of the following compounds is most soluble in water? 3-pentanone octane 1-butanol methyl propyl ether propane

Calculate delta g for the reaction at -20.3 c : Problem- For a particular reaction at 234.2 C, delta G = 143.16 kj and delta s = 965.06 j/k. Calculate delta G for this reaction at -20.3 C

Explain what is the boiling point of the compound : Problem- The delta H vap of a certain compound is 46.81 kj mol^-1 and its delta S vap is 81.38 J mol^-1 K^-1. What is the boiling point of this compound

What is the vapor pressure in mmhg of a solution : Problem- What is the vapor pressure in mmHg of a solution prepared by dissolving 35.0g of ethyl alcohol (C2H5OH) in 100.0 g of water at 25 oC. The vapor pressure of pure water is 23.8 mmHg, and the vapor pressure of ethyl alcohol is 61.2 mmHg at 25 ..

Forecast the mileage for next year : 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.

What is the freezing point in oc of a solution : Problem- What is the freezing point in oC of a solution prepared by dissolving 6.60g of MgCl2 in 110 g of water. The value of Kf for water is 1.86 (?C?kg)/mol, and the van't Hoff factor for MgCl2 is i = 2.7.

Explain how many grams are in 0.21mole of cyclopropane : Problem- Cyclopropane, C3H6, is an anesthetic given by inhalation. How many grams are in 0.21mole of cyclopropane

Calculate the partial pressure of each gas : Problem- A deep-sea diver uses a gas cylinder with a volume of 10.0 Land a content of 52.2g of O2 and 31.6g of He. Calculate the partial pressure of each gas and the total pressure if the temperature of the gas is 15 degrees Celsius.

Describe the impact of megatrends in supply : Based on your experience or readings, discuss how these mega trends affect the Purchasing and Supply Management professional in the exercise of his/her duties and responsibilities.

User Account

All Pages