Home / Questions / Reconsider Prob 20 5 3 Ralph Billett realizes that the last-value method is considered to ...
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.
(c) Apply the averaging 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?
Aug 06 2020 View more View Less
Surved Use the information below to answer the following questions. Polish Zloty Euro Mexican Peso Swiss Franc Chilean Peso New Zealand Dollar Singapore Dollar U.S. SEQU...
Aug 15 2020Determine whether the function is continuous at the given points. f(x)= X+ 12 if x 24 x² if x 54 4,0 Is f(x) continuous at x = 4? Yes No
Apr 19 2021Assume that at retirement you have accumulated $500,000 in a variable annuity contract. The assumed investment return is 6% and your life expectancy is 15 years. What is ...
Aug 30 2020Asset inc plans to issue 5 million of bonds with a coupon rate of 7 percent, a par value of $ 1000, semiannual coupons, and 30 years to maturity. The current market inter...
Nov 23 2019Clifford Clark is a recent retiree who is interested in investing some of his savings in corporate bonds. His financial planner has suggested the following bonds: • Bond ...
Apr 29 2020Let’s think about the demand for LED TVs.a. If the price for a 60-inch LED TV is $800, and Newhart would be willing to pay $3,000, what is Newhart’s consumer surplus?b. C...
Apr 21 2020GM must remain competitive with global competitors who have much lower labor costs (in some instances because wages are lower, such as in Korea, and in some instances bec...
May 04 2020Which of the following would LEAST likely receive a probable cause drug test?A) A delivery driver involved in a traffic accidentB) A college recruit applying for a progra...
Dec 12 2019Determine where the function f is continuous. First determine the domain of the function. Then support your decision using properties of continuity. (Enter your answer us...
Apr 21 2021The roof of the office building considered in Problem 2.4 is subjected to a live load of 1 kN/m2. Determine the live loads acting on the beam EF, the girder AG, and the c...
Jul 08 2020