A hospital is considering the purchase of a new ambulance. The decision will rest partlyon the anticipated distance to be driven next year. The kilometers are driven during the past five years are as follows:yearDistance(КМ)300040003340038003700A) Forecast the number of kilometers for years 3-6 using an exponential smoothing method (a = 0.1).B) Find the MAD and MSE based on the forecast in part (a).4.

Answered: A) Forecast the number of kilometers…

A) Forecast the number of kilometers for years 3-6 using an exponential smoothing method (a = 0.1). B) Find the MAD and MSE based on the forecast in part (a).

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

(4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.) Yt thousands
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,100 2 4,000 3 3,450 4 3,850 5 3,750 a) Using a 2-year moving average, the forecast for year 6 = 3800 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 = 108.3 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) = miles (round your response to the nearest whole number)
Period 1 2 3 4 5 New Accounts Period 201 215 212 229 236 6 7 8 9 10 New Accounts Period 233 249 253 254 268 11 12 13 14 15 New Accounts 282 276 281 289 311
Following table shows the monthly sales of X-box consoles at a retail store in Kuwait: Answer the following questions based on the data given above. Show your calculations. a. What is the expected sales for the 8th month based on 3 period moving average? b. What is the expected sales for the 8th month based on exponential smoothing with α =0.2? c. Which of the above two forecasting method is better based on MSE?
The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts for the period indicated and error calculations. 155, 145, 155, 162, 180, 165, 172, 149, 170, 172 Exponential smoothing. Use Excel Solver to determine the optimum alpha value to minimize MSE and answer: What is the Mean Absolute Percentage Error (MAPE)?
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) compute the forecast for the week of Oct 12 using exponential smoothing with a forecast for august 31 of 360 and alpha 0.2
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
9. For a specific model of a shoe brand, Carrefour (NIZWA) experienced a sales of 1000 units, 1100 units, 1250 units and 1500 units in the months of January, February, March and April. Furthermore, considering these sales figures related to some established trends, the Lulu managers assigned weights of 0.45, 0.25, 0.20 and 0.10 for these months respectively. a) Using the four-point moving average method, forecast the sales for the month of May. Also, compare it with the forecasted figures obtained using the weighted average method. b) Forecast the sale for the month of May if the weights are changed to 0.40, 0.30, 0.20 and 0.10 for the months of January, February, March and April. If the actual figures for the month of May comes out to be 1100, forecast the sales for the month of June using the exponential smoothing technique. The exponential smoothing constant is given as 0.20.
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 Week 1 Actual Passenger Miles (in thousands) 17 Week Forecasted Passenger Miles (in thousands) a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responses to two decimal places). 10 11 4 5 6 7 8 9 23 18 16 20 18 22 20 15 2 1 3 4 6 7 17.00 17.00 17.80 18.04 19.03 18.83 18.26 5 8 18.61 9 18.49 19.19 10 12 22 11 12
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 5 3,750 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 = 116.7 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.35 and 0.65 (the weight of 0.65 is for the most recent period) = 3750 miles (round your response to the nearest whole number). 1 3,050 2 3,950 The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.35 and 0.65 = data.) 3 3,400 3,750 miles (round your response to one decimal place) (Hint You will have only 3 years of matched