Question: 1. The Bonavista patient transfer company is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be

1. The Bonavista patient transfer company is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The kilometers driven during the past 5 years are as follows:-

Year

Distance (KM)

1

3,000

2

4,000

3

3,400

4

3,800

5

3,700

a) Forecast the numbers of Kilometers for next year (6th year) using a 2-year moving average?

b) Find the MAD based on the 2-year moving average forecast in part a [Hint: You will have only 3 years of matched data.]

c) Use a weighted 2-year moving average with weights of .4and .6 to forecast next years mileage. The weight of .6 is for the most recent year). What MAD results from using this approach to forecasting? [Hint: You will have only 3 years of matched data.]

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

Q2) Prepare a graph of the monthly forecasts and average forecast demand for Industrial Air Corp., a manufacturer of variety of large air conditioners for commercial applications

MONTH

PRODUCTION DAYS

DEMAND FORECAST

January

22

1,000

February

18

1,100

March

22

1,200

April

21

1,300

May

22

1,350

June

21

1,350

July

21

1,300

August

22

1,200

September

21

1,100

October

22

1,100

November

20

1,050

December

20

900

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!