Question

In: Other

North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77.0 + 0.45Q,

North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77.0 + 0.45Q,

where Q refers to the sequential quarter number and Q=1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows:

QuarterFactor (Index)
Winter0.72
Spring1.25
Summer1.45
Fall0.58

In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place):

QuarterEnergy Use
Winter
Spring
Summer
Fall


Solutions

Expert Solution

The demand forecast will be as follows:

D = (77 + 0.45Q) x Multiplicative seasonal factor

Winter = (77+0.45 x 101) x 0.72 = 88.16 million KWH

Spring = (77+0.45 x 102) x 1.25 = 153.63 million KWH

Summer = (77+0.45 x 103) x 1.45 = 178.86 million KWH

Fall = (77+0.45 x 104) x 0.58 = 71.80 million KWH


Related Solutions

Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of...
Bradford Electric Illuminating Company is studying the relationship between kilowatt-hours (thousands) used and the number of rooms in a private single-family residence. A random sample of 10 homes yielded the following. Number of Rooms Kilowatt-Hours (thousands) Number of Rooms Kilowatt-Hours (thousands) 12 9 8 6 9 7 10 8 14 10 10 10 6 5 5 4 10 8 7 7 Determine the 0.95 confidence interval, in thousands of kilowatt-hours, for the mean of all six-room homes. (Do not round...
Tampa Electric Company (TECO) is planning a major upgrade in its computerized demand management system. In...
Tampa Electric Company (TECO) is planning a major upgrade in its computerized demand management system. In order to accommodate this upgrade, a building will be constructed on land already owned by the company. The building is estimated to cost $1.8M and will be opened in August of this year. The computer equipment for the building will cost $2.75M, and all office equipment will cost $225,000. Annual expenses for operating this facility (labor, materials, insurance, energy, etc.) are expected to be...
Chapter 5 Question 5.1 Sherwin-Williams Company aims to develop a demand model for its line of...
Chapter 5 Question 5.1 Sherwin-Williams Company aims to develop a demand model for its line of exterior house paints. The most important variables affecting paint sales (Y) (measured in gallons) are: Promotional expenditures (A): expenditures on advertising Selling price (P) The chief manager decides to collect data on the variables in a sample of 10 company sales regions that are roughly equal in population. Data on paint sales, promotional expenditures are shown in Table 5.1. The company is interested in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT