Determine the seasonal factors for the four quarters

Reference no: EM131104971

Reconsider Prob. 20.5-3. Ralph Billett realizes that the last-value method is considered to be the naive forecasting method, so he wonders whether he should be using another method. Therefore, he has decided to use the available Excel templates that consider seasonal effects to apply various statistical forecasting methods retrospectively to the past three years of data and compare their MAD values.

(a) Determine the seasonal factors for the four quarters.

(b) Apply the last-value method.

(d) Apply the moving-average method based on the four most recent quarters of data.

(e) Apply the exponential smoothing method with an initial estimate of 25 and a smoothing constant of α = 0.25.

(f) Apply exponential smoothing with trend with smoothing constants of α = 0.25 and ß = 0.25. Use initial estimates of 25 for the expected value and 0 for the trend.

(g) Compare the MAD values for these methods. Use the one with the smallest MAD to forecast sales in Quarter 1 of next year.

(h) Use the forecast in part (g) and the seasonal factors to make long-range forecasts now of the sales in the remaining quarters of next year

Prob. 20.5-3

Ralph Billett is the manager of a real estate agency. He now wishes to develop a forecast of the number of houses that will be sold by the agency over the next year. The agency's quarter-by-quarter sales figures over the last three years are shown below.

(a) Determine the seasonal factors for the four quarters.

(b) After considering seasonal effects, use the last-value method to forecast sales in Quarter 1 of next year.

(c) Assuming that each of the quarterly forecasts is correct, what would the last-value method forecast as the sales in each of the four quarters next year?

(d) Based on his assessment of the current state of the housing market, Ralph's best judgment is that the agency will sell 100 houses next year. Given this forecast for the year, what is the quarter-by-quarter forecast according to the seasonal factors?

Reference no: EM131104971

Questions Cloud

Describe the five levels of the biopsychosocial model : Suppose you are asked to do a project that requires you to work late in the library on campus. Or suppose you want to jog though the park at dusk. How does the worldview of the average female differ from the worldview of the typical male on matter..

Compute the output noise powers in each case : Compute the output noise powers in each case, and show that TSSB = 2TDSB, and that therefore FSSB = 2FDSB. Assume that the conversion gains for the signal and its image are identical.

Maintains a computerized forecasting system to forecas : Transcontinental Airlines maintains a computerized forecasting system to forecast the number of customers in each fare class who will fly on each flight in order to allocate the available reservations to fare classes properly.

Generate three approximate random paths : Use coin tossing to generate random errors that will approximate the term dWt, How can you make sure that the limiting mean and variance of the random process generated by coin tossing matches that of dWt, εs ? → 0? Generate three approximate random ..

Determine the seasonal factors for the four quarters : Reconsider Prob. 20.5-3. Ralph Billett realizes that the last-value method is considered to be the naive forecasting method, so he wonders whether he should be using another method.

Plot the overall noise figure for both amplifier : calculate and plot the overall noise figure for both amplifier-mixer configurations for FA = 0-10 dB.

Discuss constitutionality of rulings in the usa : We have different types of rulings based on either constitution, laws or acts as commonly mentionediin courts. Discuss constitutionality of rulings in the USA.

Determine the seasonal factors for the four seasons : (c) Assuming that each of the forecasts for the next three seasons is correct, what would the last-value method forecast as the water consumption in each of the four seasons next year?

Shares on foreign equity markets : How do you explain why firms often list their shares on foreign equity markets? Which equity markets are the primary hosts to foreign listing?

User Account

All Pages