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 3,950 3 3,400 4 3,800 5 3,700 a) Using a 2-year moving average, the forecast for year 6 = 3750 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.) 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.60 is for the most recent period)= 3740 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60= 50 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)

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 3,950 3 3,400 4 3,800 5 3,700 a) Using a 2-year moving average, the forecast for year 6 = 3750 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.) 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.60 is for the most recent period)= 3740 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60= 50 miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

ABS company used to consult a consulting agency to evaluate the processing system. To which extra cost can we add consultation cost? Select one: A. Appraisal costs B. External costs C. Internal costs D. Prevention cost
those they 6. A business hands out promotional fliers to 15,000 people. It is estimated that of handed out fliers to, 34% of them will come to the store for the sale mentioned on the flier. How many customers on average should the business expect?
what is good posit1oning strategy for bakery shop
1. Description of marketing training in burger king. 2. Description of sales courses training in burger king.
Please do not give solution in image format thanku
Make a recommendation to the following : 1. Teachers in school 2. College students in school 3. School department heads and Dean's
What is the procedure for information collection on literature review for research study on solid waste management at a recycling company?
How can we find the Leaving Basic Variable?
difference between order statistics and quantile?
how can ticketmaster solve the problem of lack of human touch and personalization to eliminate such painpoint at the convert stage of the customer journey , give a recommendation