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.

Transcribed Image Text:

TABLE P-15 Quarterly Revenues for Consolidated Edison S millions), 1985-June 2002 Mar. 31 Jun. 30 Sept. 30 Dec. 31 Year 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 1,441 1414 1,284 1,327 1,387 1,494 1,479 1.456 1,586 1,697 1,669 1,867 1,886 1,853 1,777 2.318 2,886 2,099 1,209 1,187 1,125 1,102 1.218 1.263 1.330 1.280 1.396 1,392 1.460 1,540 1,504 1,561 1,479 2,042 2,112 1,900 1.526 1411 1493 1.469 1,575 1,613 1,720 1,717 1,800 1.822 1,880 1,920 2,011 2,062 2346 2.821 2,693 1321 1.185 1.192 1,213 1.371 1369 1344 1,480 1,483 1.461 1,528 1.632 1,720 1,617 1.889 2,250 1,943