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

100% sure experts solve it correct complete solutions okk don't use chat gpt okk Only Qno1 solve complete solutions if u know problem 2 solve both thanks
Need a blurb for: Black Bean Salad Yields 17 servings, each one equal to ½ cup 2 tablespoons olive oil 2 tablespoons lime juice ½ teaspoon ground cumin or ¼ teaspoon cumin seeds 8 green onions, chopped 1 red bell pepper, seeded and chopped ¼ cup chopped fresh cilantro 1 cup frozen corn kernels, thawed 2 (15 ounce) cans black beans, drained and rinsed
4 .Substitute for Problem # 4 on in attachment)-Calculate the MAD,revised MAD and the Revised Forecast for months 1-6 for the following three groups,where the Forecast stands for Forecast Demand.Has your forecast improved ? Tell me how would you go about improving the revised forecast( for each of the three groups)without actually doing so? Estate Planning Group Auditing and Accounting Group Business Consulting Group Month Actual Demand Forecast Actual Demand Forecast Actual Demand Forecast 1 100 125 270 230 140 135 2 90 125 240 230 130 135 3 110 125 280 230 160 135 4 115 125 260 230 180 135 5 130 125 300 230 200 135 6 115 125 220 230 190 135
I need typing clear urjent no chatgpt used i will give upvotes full explanation plss
Q1/ Talk in details about functions of MIS of Attendance management in school
Divvy Bikes 2021 summer ridership has increased 30% from the ridership levels in 2020. Divvy's management attributes this to 2020 having fewer work places and recreation venues were open than in 2021. This is an example of which type of data analytics? Question 6 options: a) Descriptive b) Diagnostic c) Predictive d) Prescriptive
Define Problem Solving & list the theories involved in problem solving (Understanding)
Reflective Paper 1 Mulling over M & M In the 1930s Spanish Civil War, Forrest Mars saw soldiers eating chocolate pelletswith a hard shell to carry these chocolates easily without the risk of melting. This gavehim an idea, and the M&M’s Plain Chocolate Candies were introduced in the USAmarket in 1941.The product was a hit with the American soldiers and U.S. Army became its first bigcustomer as it gave the soldiers an option to carry chocolate in tropical climates withoutmelting. In 1949, the brand introduced the tagline “Melt in your mouth, not in yourhand,” and this led to a considerable increase in its sales because it delivered on asolid insight, especially from parents who did not like to see their children making amess when eating chocolate. M&M’s are button-shaped chocolate-filled candies withhard shells surrounding a filling which varies depending upon the type of M&M’s. Theproduct is available in various colors – red, yellow, orange, brown, green, and…
Please provide me with pestel analysis of NEROAMORE coffee company
I need typing clear urjent no chatgpt use i will give 5 upvotes full explanation pls
What company relies heavily on Key Resources (KR) in their business modeling "
Sales Forecast 1. what is a sales forecast? a. In a manufacturing and distribution company how often shoud the sales forecast be completed?