Question
1.
a.) Find the 2-year moving average, the forecast for year 6 = ?

b.) Find the MAD based on the 2-year moving average forecast in part a

c.)

Homework: Homework #4 Score: 0 of 10 pts Problem 4.5 • 2 of 12 ( complete) The Carbondale Hospital is considering the purchas
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Using the 2 year moving average method,

F(6) = {Actual(4) + Actual(5)}/2

= (3850+3800)/2

= 3825

b) F(3) = (3000+4000)/2

= 3500

F(4) = (4000+3450)/2

= 3725

F(5) = (3450+3850)/2

= 3650

MAD(Mean Absolute Deviation) = Sum of absolute deviation/Number of periods

= {|3450-3500| + |3850-3725| + |3800-3625|}/3

= (50+125+175)/3

= 116.67

Add a comment
Know the answer?
Add Answer to:
1. a.) Find the 2-year moving average, the forecast for year 6 = ? b.) Find...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45...

    "The MAD for the forecast developed using a weighted​ 2-year moving average with weights of 0.45 and 0.55 = __ miles ​(round your response to one decimal​ place).  ​(Hint: You will have only 3 years of matched​ data.)" Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...

  • Score: 0.2 of 1 pt 3 of 10 (10 complete) HW Score: 84.33%, 8.43 of 10...

    Score: 0.2 of 1 pt 3 of 10 (10 complete) HW Score: 84.33%, 8.43 of 10 pts Problem 4.5 s Question Help O 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 2 4.000 4 3.800 5 3,700 Mileage 3.050 3.500 a) Using a 2-year moving average, the forecast for...

  • Need some help, show steps please 3 of 7 (5 complete) HW Score: 38%, 38 of...

    Need some help, show steps please 3 of 7 (5 complete) HW Score: 38%, 38 of 100 p Score: 5 of 25 pts Problem 4.5 Question Help 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 4,050 3,400 3,750 3.000 a) Using a 2-year moving average, the forecast for year 6...

  • The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly...

    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: 3000 2: 4050 3: 3500 4: 3850 5: 3800 a) Using a​ 2-year moving​ average, the forecast for year 6​ = 3825 miles ​(round your response to the nearest whole​ number). ​ b) If a​ 2-year moving average is used to make...

  • The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly...

    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 a) Forecast the mileage for next year (6th year) using a 2-year moving average. b) Find the MAD based on the 2-year moving average. ( Hint: You will have only 3 years...

  • The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly...

    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: Year12345Mileage3.0504,0003,5003.7503.700a) Using a 2-year moving average, the forecast for year 6 = 3,725 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 = 33.3 miles (round your response to...

  • i need last one The Carbondale Hospital is considering the purchase of a new ambulance. The...

    i need last one 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 4 3,400 Mileage a) using a 2-year moving average, the forecast for year 6-3775 miles (round your response to the nearest whole number. b lf a 2-year m oving average is used to make the forecast, the MAD based...

  • Can someone help me figure out part C? The Carbondale Hospital is considering the purchase of...

    Can someone help me figure out part C? 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 2 4,000 4 5 3,050 3,500 3,800 3,750 a) Using a 2-year moving average, the forecast for year 63,775 miles (round your response to the nearest whole number) b) If a 2-year moving average...

  • The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly...

    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,000   3,950   3,500   3,750   3,750 a) Using a​ 2-year moving​ average, the forecast for year 6​ =     miles ​(round your response to the nearest whole​ number). ​b) If a​ 2-year moving average is used to make...

  • The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly...

    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 comma 0003,000 3 comma 9503,950 3 comma 4503,450 3 comma 7503,750 3 comma 7503,750 ​a) Using a​ 2-year moving​ average, the forecast for year 6​ = 3750 miles ​(round your response to the nearest whole​...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT