Please forecast the mileage for 2013 (in 10) using a weighted average method with a 0.6 as a weight for the most recent period and 0.4 for the next. Keep one decimal place **Question 10**The Charbondale 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 (in 10) ||------|----------------|| 2008 | 300 || 2009 | 400 || 2010 | 340 || 2011 | 332 || 2012 | 370 |Please forecast the mileage for 2013 (in 10) using a weighted average method with 0.6 as the weight for the most recent period and 0.4 for the next.Keep one decimal place.

Forecast of 2013 = 0.6*demand of 2012 + 0.4* Demand of 2011

The Charbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be drive next year. The miles driven during the past 5 years are as follows: Year Mileage (in 10) 2008 300 2009 400 2010 340 332 2011 2012 370 Please forecast the mileage for 2013 (in 10) using a weighted average method with 0.6 as the weight for the most recent period and 0.4 for the ne

The Charbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be drive next year. The miles driven during the past 5 years are as follows: Year Mileage (in 10) 2008 300 2009 400 2010 340 332 2011 2012 370 Please forecast the mileage for 2013 (in 10) using a weighted average method with 0.6 as the weight for the most recent period and 0.4 for the ne

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

Hi, need help solving for part B. Thank you.
The director of the Riley County, Kansas, library systemwould like to forecast evening patron usage for next week.Below are the data for the past 4 weeks: a) Calculate a seasonal index for each day of the week.b) If the trend equation for this problem is y = 201. 74 + .18x,what is the forecast for each day of week 5? Round your forecastto the nearest whole number.
Use the sales data in the table ( attached Image) and apply the same forecast method when α = 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, and 1. What is the best value for α? What does the best value of α indicate or show in regards to the forecast model? (Hint: Use Microsoft Excel to solve the question)
Tom’s Towing LLC operates a fleet of tow trucks that it sends to help drivers in needon the nearby highway. The numbers of calls requesting a tow truck for Monday, Tuesday, Wednesday, and Thursday were 27, 18, 21, and 15, respectively. What would be itsforecast for Friday using a naïve forecasting approach?
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: 1 3,000 2 3,950 3 3,400 Year Mileage a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number). 4 3,750 5 3,750
Can you tell the difference between "correct" and "true" when it comes to forecasting?
How is exponential smoothing superior to moving averages as a forecasting tool?
Please forecast the mileage (in 100) for 2013 using a 4 period moving average method. Please keep 1 decimal place.
The sales of Bluetooth Headphones at the Dubai Electronics Enterprises in Jebel Ali, UAE, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using the following techniques: 5B. If next month's sales turn out to be 140 units, forecast the following month's sales (months) using a 4-month moving average.
Is forecasting technique more accurate than TSA? Justify your answer.
Sales of Bluetooth Headphones at the Abdulla Electronics Enterprises in Model Town, India, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using following techniques: a) 3-month moving average. b) 4-month moving average. c) Weighted 4-month moving average with the most recent month weighted 4, the preceding month 3, then 2, and the oldest month weighted 1. d) If next month’s sales turn out to be 140 units, forecast the following month’s sales (months) using a 4-month moving average.
Using least-squares regression, the forecast for the number of accidents that will occur in the month of May = ? accidents (enter your response as a whole number).