The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 407 Weeks Ago, 6 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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 |
1 |
2 |
3 |
4 |
5 |
|
Mileage |
3,100 |
4,000 |
3,450 |
3,850 |
3,750 |
a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number) Answer = 3800
b) If a 2-year moving average is used to make the forecast, the MAD based on this =miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) Answer = 108.3
c) The forecast for year 6 using a weighted 2-year moving average with weights of .40 and .60 (the weight of .60is for the most recent period) =miles (round your response to the nearest whole number). Answer = 3790
The MAD for the forecast developed using a weighted 2-year moving average with weights of .40 and .60 =miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) Answer =143.3 HOW DO YOU WORK THIS PART????
d) Using exponential smoothing with alphaa = .20 and the forecast for year 1 being 3 comma 3,100 , the forecast for year 6 = nothing miles (round your response to the nearest whole number). HOW DO YOU WORK THIS????
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------