Question

North Dakota Electric Company estimates its demand trend line​ (in millions of kilowatt​ hours) to​ be:

D​ =

80.0

​+

0.50Q,

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:

                                                                       

Quarter	Factor​ (Index)
Winter	0.75
Spring	1.25
Summer	1.45
Fall	0.55

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):

Quarter	Energy Use
Winter	nothing

Answer 1

А 1 Quarter Quarter sequence number Factor (Index) Demand Energy usage Winter 101 0.75 130.5 Spring 102 1.25 131 Summer 103 1.45 131.5 Fall 104 0.55 132 97.9 163.8 190.7 72.6

Formula

1 Quarter Winter Spring Summer Fall Quarter sequence number 101 102 Factor (Index) 0.75 1.25 1.45 0.55 Demand =80+0.5*B2 =80+0.5*B3 =80+0.5*B4 =80+0.5*B5 Energy usage =ROUND(D2*C2,1) =ROUND(D3*C3,1) =ROUND(D4*C4,1) =ROUND(D5*C5,1)