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

Marketing

20th Edition

ISBN:9780357033791

Author:Pride, William M

Publisher:Pride, William M

Chapter6: Target Markets: Segmentation And Evaluation

Section: Chapter Questions

Problem 17DRQ: Under what conditions might a firm use multiple forecasting methods?

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
Question 3: Jane is trying to forecast demand for her store, using moving average with n=2, Fill in the missing cells with correct values and find average error for first quarter and second quarter of year 2000 E Enroll- Year Quarter ment Forecast Error Abs Error 1997 313 3. 2 285 4 3 312 5. 4 339 6. 1998 1 359 7 320 356 385 6. 10 1999 396 367 11 397 12 423 13 14 2000 1 15 2000 3412M4
QUESTION 2:The manager of YTL Computers wants to develop next year’s quarterly forecasts of salesrevenue for its brand laptops. The sales are seasonal and the company believes that thefollowing most recent eight quarters of sales should be representative of next year’ssales: Year Quarter Sales (millions of dollars) 1 1 9.2 1 2 5.4 1 3 4.3 1 4 14.1 2 1 10.3 2 2 6.4 2 3 5.4 2 4 16.0 Determine the forecast of next year’s quarterly sales revenue for this line of laptops.Show all your workings.
Question 2 Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local community. Customers love the quality of meet that Mr. Ferdinand sells so they tend to recommend his product to other persons. Recently, Mr. Ferdinand has been rumning out of beef to sell to his customers. One customer suggests to him that he must use past sales records to forecast demand for his beef so that he can meet his customers demand. Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a four-week weighted moving average to forecast demand for his beef. I. II. Show how Mr. Ferdinand can test the accuracy of his forecast. III. Explain to Mr. Ferdinand two ways in which he can benefit from doing forecast for his beef. 日正

Question 2 Mr. Ferdinand is a well known entrepreneur who sells fresh organic beef to persons in the local community. Customers love the quality of meet that Mr. Ferdinand sells so they tend to recommend his product to other persons. Recently, Mr. Ferdinand has been running out of beef to sell to his customers. One customer suggests to him that he must use past sales records to forecast demand for his beef so that he can meet his customers demand. I Using a numerical example, demonstrate to Mr. Ferdinand how he can use a three- week and a four-week weighted moving average to forecast demand for his beef. II. Show how Mr. Ferdinand can test the accuracy of his forecast. II. Explain to Mr. Ferdinand two ways in which he can benefit from doing forecast for his beef.
FC.51 Madison Memorial Hopsital is considering purchasing a new ambulance. The decision will rest partly on the anticipated mileage to be driven this year (2023). The miles driven during the past eight years are as follows: Year Miles Driven 2015 2016 2017 2018 2019 2020 2021 2022 3,240 1,211 3,208 3,253 2,169 2,224 1,162 1,074 Using a 4-year moving average, what would be the forecast for the miles to be driven in 2023? (Display your answer to the nearest whole number.) Number Using a 4-year weighted moving average (with last year's weight as 0.5, two years previous as 0.2; three years previous as 0.2, and four years previous as 0.1) what is the forecast for 2023? (Display your answer to the nearest whole number.) Number
If the forecasted value of the time series variable for one period is 28.5 and the actual value observed for the same period is 32, what is the forecast error for that period? Question 19 options: 3.5 2 -3.5 4
Question DEMAND FOR FERTILIZER YEAR (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 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Develop a trend line for the demand for fertilizer using any computer software. For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer. Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer given. Assume that last period’s forecast for year 1 is 5,000 bags to begin the procedure. Would you prefer to use the exponential smoothing model or the weighted average model developed? Explain your answer.
Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
QUESTION 2 The number of patients coming to the Healthy Start Maternity clinic has been increasing steadilyover the past eight months. You are provided with some historical data as follows: Month Clinic attendance (in thousands)1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7 a. Identify and give a brief explanation of the:-i. Dependent variableii. Independent variable b. Use simple linear regression to forecast annual demand for months 9 and 10 by using thetabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation. iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.
(8 points) Infoworks is a large computer discount store that sells computers and ancillary equipment and software in the town where a State University is located. Infoworks has collected historical data on computer sales and printer sales for the past 10 years, as follows: Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11. Compare your result in a, b, c. Which model would you choose and why?
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)