Year Mileage 3,050 ing average, the forecast for year 6 3775 miles (round your response to the average is used to make the forecast, the MAD based on this 100 miles (rou 4,000 3,4 ar 6 using a weighted 2-year moving average with weights of 0.40 and 0.00 (the

Intermediate Algebra
19th Edition
ISBN:9780998625720
Author:Lynn Marecek
Publisher:Lynn Marecek
Chapter12: Sequences, Series And Binomial Theorem
Section12.3: Geometric Sequences And Series
Problem 12.58TI: What is the total effect on the economy of a government tax rebate of $500 to each household in...
icon
Related questions
Question

please solve all parts within 30 minutes.

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,050
2
4,000
3
3,450
4
3,750
5
3,800
a) Using a 2-year moving average, the forecast for year 6= 3775 miles (round your response to the nearest whole number)
b) if a 2-year moving average is used to make the forecast, the MAD based on this 100 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched
data)
M
c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.50 is for the most recent period)
nearest whole number)
miles (round your response to the
Om
miles (round your response to one decimal place) (Hint: You will have
The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60
only 3 years of matched data)
d) Using exponential smoothing with a=0.30 and the forecast for year 1 being 3,050, the forecast for year 6 miles (round your response to the nearest whole number)
Transcribed Image Text: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,050 2 4,000 3 3,450 4 3,750 5 3,800 a) Using a 2-year moving average, the forecast for year 6= 3775 miles (round your response to the nearest whole number) b) if a 2-year moving average is used to make the forecast, the MAD based on this 100 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data) M c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.50 is for the most recent period) nearest whole number) miles (round your response to the Om miles (round your response to one decimal place) (Hint: You will have The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60 only 3 years of matched data) d) Using exponential smoothing with a=0.30 and the forecast for year 1 being 3,050, the forecast for year 6 miles (round your response to the nearest whole number)
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College