solution

The Consolidated Edison Company sells electricity (82% of revenues), gas (13%), and steam (5%) in New York City and Westchester County. Bart Thomas, company forecaster, is assigned the task of forecasting the company’s quarterly revenues for the rest of 2002 and all of 2003. He collects the data shown in Table P-15. Determine the best forecasting technique and forecast quarterly revenue for the rest of 2002 and all of 2003.

a. Plot the sales data as a time series. Are the data seasonal? Hint: For monthly data, the seasonal period is. Is there a pattern (e.g., summer sales relatively low, fall sales relatively high) that tends to repeat itself every 12 months?

b. Use a naive model to generate monthly sales forecasts (e.g., the February 2005 forecast is given by the January 2005 value, and so forth). Compute the MAPE.

c. Use simple exponential smoothing with a smoothing constant of .5 and an initial smoothed value of 430 to generate sales forecasts for each month. Compute the MAPE.

d. Do you think either of the models in parts b and c is likely to generate accurate forecasts for future monthly sales? Explain.

e. Use Minitab and Winters’ multiplicative smoothing method with smoothing constants to generate a forecast for January 2007. Save the residuals.

 f. Refer to part e. Compare the MAPE for Winters’ method from the computer printout with the MAPEs in parts b and which of the three forecasting procedures do you prefer?

g. Refer to part e. Compute the autocorrelations (for six lags) for the residuals from Winters’ multiplicative procedure. Do the residual autocorrelations suggest that Winters’ procedure works well for these data? Explain.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

This question refers to Problem 9. Use exponential smoothing with a smoothing constant of .2 and an initial value of 9.29 to forecast the yield for January 2007. Is this forecast better than the forecast made using the better moving average model? Explain. The Hughes Supply Company uses an inventory management method to determine the monthly demands for various products. The demand values for the last 12 months of each product have been recorded and are available for future forecasting. The demand values for the 12 months of 2006 for one electrical fixture are presen-ted in Table P-11.

Use exponential smoothing with a smoothing constant of .5 and an initial value of 205 to forecast the demand for January 2007.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Table P-18 contains the number of severe earthquakes (those with a Richter scale magnitude of 7 and above) per year for the years 1900–1999.

a. Use Minitab to smooth the earthquake data with moving averages of orders, 10, and 15. Describe the nature of the smoothing as the order of the moving average increases. Do you think there might be a cycle in these data? If so, provide an estimate of the length (in years) of the cycle.

b. Use Minitab to smooth the earthquake data using simple exponential smoothing. Store the residuals and generate a forecast for the number of severe earthquakes in the year 2000. Compute the residual autocorrelations. Does simple exponential smoothing provide a reasonable fit to these data? Explain.

c. Is there a seasonal component in the earthquake data? Why or why not?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Do any of the forecasting models studied in this chapter work with the national sales data?  Do any of the forecasting models studied in this chapter work with the actual Murphy Brothers’ sales data? Which data set and forecasting model should Julie use to forecast sales for 1996? Downtown Radiology’s accountant projected that revenue would be considerably higher than that provided by Professional Marketing Associates. Since ownership interest will be made available in some type of public offering, Downtown Radiology’s management must make a decision concerning the accuracy of Professional Marketing Associates’ projections. You are asked to analyze the report. What recommendations would you make?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"