Question 2. The Consolidated Edison Company sells electricity (82% of revenues), gas (13%), and...

Question

Question 2.				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 thetask of forecasting the company’s quarterly revenues for the rest of 2002 and all of 2003. He collects the data shown in Table 2. Determine the best forecasting technique and forecast quarterly revenue for the rest of 2002 and all of 2003.																													Table 2 Quarterly   Revenues for Consolidated Edision ($ million)																																																														Year																																																								Quarter																																																								Revenues																																																								Year																																																								Quarter																																																								Revenues																																																								Year																																																								Quarter																																																								Revenues																																																														1985																																																								Mar																																																	1441																																					1991																																																								Mar																																																	1479																																					1997																																																								Mar																																																	1886																																																																																																			Jun																																																	1209																																																																																													Jun																																																	1330																																																																																													Jun																																																	1504																																																																																																			Sept																																																	1526																																																																																													Sept																																																	1720																																																																																													Sept																																																	2011																																																																																																			Dec																																																	1321																																																																																													Dec																																																	1344																																																																																													Dec																																																	1720																																											1986																																																								Mar																																																	1414																																					1992																																																								Mar																																																	1456																																					1998																																																								Mar																																																	1853																																																																																																			Jun																																																	1187																																																																																													Jun																																																	1280																																																																																													Jun																																																	1561																																																																																																			Sept																																																	1411																																																																																													Sept																																																	1717																																																																																													Sept																																																	2062																																																																																																			Dec																																																	1185																																																																																													Dec																																																	1480																																																																																													Dec																																																	1617																																											1987																																																								Mar																																																	1284																																					1993																																																								Mar																																																	1586																																					1999																																																								Mar																																																	1777																																																																																																			Jun																																																	1125																																																																																													Jun																																																	1396																																																																																													Jun																																																	1479																																																																																																			Sept																																																	1493																																																																																													Sept																																																	1800																																																																																													Sept																																																	2346																																																																																																			Dec																																																	1192																																																																																													Dec																																																	1483																																																																																													Dec																																																	1889																																											1988																																																								Mar																																																	1327																																					1994																																																								Mar																																																	1697																																					2000																																																								Mar																																																	2318																																																																																																			Jun																																																	1102																																																																																													Jun																																																	1392																																																																																													Jun																																																	2042																																																																																																			Sept																																																	1469																																																																																													Sept																																																	1822																																																																																													Sept																																																	2821																																																																																																			Dec																																																	1213																																																																																													Dec																																																	1461																																																																																													Dec																																																	2250																																											1989																																																								Mar																																																	1387																																					1995																																																								Mar																																																	1669																																					2001																																																								Mar																																																	2886																																																																																																			Jun																																																	1218																																																																																													Jun																																																	1460																																																																																													Jun																																																	2112																																																																																																			Sept																																																	1575																																																																																													Sept																																																	1880																																																																																													Sept																																																	2693																																																																																																			Dec																																																	1371																																																																																													Dec																																																	1528																																																																																													Dec																																																	1943																																											1990																																																								Mar																																																	1494																																					1996																																																								Mar																																																	1867																																					2002																																																								Mar																																																	2099																																																																																																			Jun																																																	1263																																																																																													Jun																																																	1540																																																																																													Jun																																																	1900																																																																																																			Sept																																																	1613																																																																																													Sept																																																	1920																																																																																																																																																																																													Dec																																																	1369																																																																																													Dec																																																	1632																																																																																																																				s

Table 2 Quarterly Revenues for Consolidated Edision ($ million)
Year	Quarter	Revenues	Year	Quarter	Revenues	Year	Quarter	Revenues
1985	Mar	1441	1991	Mar	1479	1997	Mar	1886
	Jun	1209		Jun	1330		Jun	1504
	Sept	1526		Sept	1720		Sept	2011
	Dec	1321		Dec	1344		Dec	1720
1986	Mar	1414	1992	Mar	1456	1998	Mar	1853
	Jun	1187		Jun	1280		Jun	1561
	Sept	1411		Sept	1717		Sept	2062
	Dec	1185		Dec	1480		Dec	1617
1987	Mar	1284	1993	Mar	1586	1999	Mar	1777
	Jun	1125		Jun	1396		Jun	1479
	Sept	1493		Sept	1800		Sept	2346
	Dec	1192		Dec	1483		Dec	1889
1988	Mar	1327	1994	Mar	1697	2000	Mar	2318
	Jun	1102		Jun	1392		Jun	2042
	Sept	1469		Sept	1822		Sept	2821
	Dec	1213		Dec	1461		Dec	2250
1989	Mar	1387	1995	Mar	1669	2001	Mar	2886
	Jun	1218		Jun	1460		Jun	2112
	Sept	1575		Sept	1880		Sept	2693
	Dec	1371		Dec	1528		Dec	1943
1990	Mar	1494	1996	Mar	1867	2002	Mar	2099
	Jun	1263		Jun	1540		Jun	1900
	Sept	1613		Sept	1920
	Dec	1369		Dec	1632

Question 2. TheConsolidated Edison Company sells electricity (82% of revenues), gas (13%), andsteam (5%) in New York City and Westchester County. Bart Thomas, companyforecaster, is assigned thetask...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment