4.5 The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the antici- pated mileage to be driven next year. The miles driven during the past 5 years are as follows: YEAR MILEAGE 3,000 4,000 3. 3,400 4 3,800 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 of matched data.) c) Use a weighted 2-year moving average with weights of 4 and 6 to forecast next year's mileage. (The weight of .6 is for the most recent year.) What MAD results from using this approach to forecasting? (IHint: You will have only 3 years of matched data.) d) Compute the forecast for year 6 using exponential smoothing. an initial forecast for year1 of 3,000 miles, and a 5. Px

Need help with the forecast for year 10. Linear trend line

The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 2016 1600 2017 2200 2018 2600 2019 2800 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and α = .3

The number of internal disk drives (in millions) made at a plant in Taiwan during the past 5 years follows: F Year 4 Disk Drives 142 164 196 204 216 B a) Using simple linear regression, the forecast for the number of disk drives to be made next year-isk drives (round your response to one decimal place)

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table:  YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15   a) Develop a 3-year moving average to forecast demand?

Please forecast the mileage (in 100) for 2013 using a 4 period moving average method. Please keep 1 decimal place.

Show your complete solution

Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below) Year Sales 1 455 2 495 516 4 563 584 a) Forecasted sales for year 6 using a 3-year moving average is sales (round your response to one decimal place). b) The MAD for a 3-year moving average based forecast is sales (round your response to one decimal place). c) The MSE for a 3-year moving average based forecast is sales (round your response to the nearest whole number).

How can we monitor and control forecast in our interior designing business. Please provide with a relative example

(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