20110718PAC to IIPA 28f-3.pdf

Rocky Mountain Power
Utah General Rate Case - June 2012
Pro Forma Revenue
Historical Test Period 12 Months Ending June 2010
Forecast Test Period 12 Months Ending June 2012
Total
Actual
MWhs
Normalization
Adjustment
MWhs1
- Total
Adjusted
Actual
MWhs
Forecast
Adjustment
MWhs2
Total
Utah
Forecast
MWhs
Residential 6,567,267 (36,005) 6,531,262 325,557 6,856,819
Commercial 7,524,392 1,703 7,526,095 802,272 8,328,367
Industrial 5,341,187 (16,148) 5,325,039 357,143 5,682,182
Situs Contracts - i 431,086 7,967 439,053 126,979 566,032
Situs Contracts -2 744,942 (2,201) 742,741 164,150 906,891
Situs Contracts -3 742,888 (20,238) - 722,650 430,539 1,153,189
Situs Contracts -5 237,077 2,013 239,090 7,633 246,723
Irrigation 184,084 508 -184,593 2,867 187,460
PublicSt&Hwy 79,536 (240) - 79,296 (2,456) 76,840
Other Sales Pub Auth 423,037 (894) 422,143 15,167 437,310
Interdepartmental - - - - -
TotalUtah 22,275,497 (63,535) -22,211,962 2,229,851 24,441,813
Source / Formula A+B C+D
Includes weather normalization, out of period adjustments, the adjustment made to reconcile the booked with blocking MWh's,
normalization of MWh's and buy-through MWh's for special contracts.
2 Differences between normalized actual and forecast load.
Page 3. I .5
ID PAC-E-11-12
IIPA 28 Attachment IIPA 28f -3
Attach IIPA 28f -3.pdf Page 1 of 2
UTAH GENERAL RATE CASE - ,June 2012
Pro Forma Factors June 2012
ENERGY
FORECAST LOADS (MWH)
Non-FERC FERC
Year Month CA OR WA UT ID WY Tota
2011 Jul 90,120 1,264730 395,310 2,492,530 421,470 895,060 22,054 5,581,274
2011 Aug 85,150 1,261,600 395,730 2,443,810 353,390 895,500 21,367 5,456,547
2031 Sep 72,540 1,140,850 360,340 2,085,180 282,920 852,790 19,289 4,813,909
2011 Oct 70,540 1,174,690 375,130 2,070,960 281,990 910,540 16,603 4,900,453
2011 Nov 73,640 1,242,870 388,540 2,071,550 269,720 905,810 16,515 4,968,645
2011 Dec 84,190 1,418,300 440,640 2,194,460 294,660 944,010 19,351 5,395,611
2012 Jan 86,080 1,434,910 441,090 2,220,380 298,030 915,840 17,803 5,414,133
2012 Feb 76,590 1,284,910 386,160 2,061,200 271,440 880,950 15,271 4,976,521
2012 Mar 76,790 1,294,420 374,570 2,151,200 287,740 948,790 15,955 5,149,465
2012 Apr 74,520 1,183,460 340,190 2,067,350 275,880 877,510 15,048 4,833,958
2012 May 80,000 1,182,770 346,600 2,144,540 332,000 903,700 15,831 5,005,441
2012 Jun 83,360 1,161,300 341,910 2,251,610 371,250 867,600 15,554 5,092,584
953,520 15,044,810 4,586,210 26,254,770 3,740,490 10,798,100 210,640 1 61,588,540 + plus
Add: Monsanto Curtailment (ID) - Grossed up for Line Losses (No adjustment - Forecast Loads assumes no curtailment)
I Non-FERC FERC
Month Day CA OR WA UT ID WY Tota
2011 Jul 354 5,484 - 5,837
2011 Aug 435 5,519 - 5,954
2011 Sep 293 1,507 - 1,799
2011 Oct 469 1,685 - 2,154
2011 Nov 266 3,482 - 3,748
2011 Dec 365 2,782 - 3,148
2012 Jan 523 646 - 1,168
2012 Feb 487 515 - 1,002
2012 Mar 383 295 - 677
2012 Apr 371 385 - 756
2012 May 394 389 - 783
2012 Jun 500 1,567 - 2,067 - - 4,839 24,255 - - 29,095 - (less)
Subtract: DSM programs, MagCorp Buy-through (UT) - Grossed up for Line Losses
I Non-FERC FERC
Month Day CA OR WA UT ID WY Total
2011 Jul 5,815 - 5,815
2011 Aug 5,736 - 5,736
2011 Sep 4,511 4,511
2011 Oct - - -
2011 Nov - -
2011 Dec 6,135 - 6,135
2012 Jan 6,124 - 6,124
2012 Feb - -
2012 Mar - -
2012 Apr - -
2012 May -
2012 Jun 4,281 4,281 - - 32,601 - - - 32,601 = equals
Month Day
2011 Jul
2011 Aug
2011 Sep
2011 Oct
2011 Nov
2011 Dec
2012 Jan
2012 Feb
2012 Mar
2012 Apr
2012 May
2012 Jun
LOADS FOR JURISDICTIONAL _ALLOCATION _(MWH)
Non-FERC FERC
CA OR WA UT ID WY Total
90,120 1,264,730 395,310 2,487,069 426,954 895,060 22,054 5,581,297
85,150 1,261,600 395,730 2,438,510 358,909 895,500 21,367 5,456,765
72,540 1,140,850 360,340 2,080,962 284,427 852,790 19,289 4,811,197
70,540 1,174,690 375,130 2,071,429 283,675 910,540 16,603 4,902,608
73,640 1,242,870 388,540 2,071,816 273,202 905,810 16,515 4,972,393
84,190 1,418,300 440,640 2,188,691 297,442 944,010 19,351 5,392,624
86,080 1,434,910 441,090 2,214,779 298,676 915,840 17,803 5,409,177
76,590 1284,910 386,160 2,061,687 271,955 880,950 15,271 4,977,523
76,790 1,294,420 374,570 2,151,583 288,035 948,790 15,955 5,150,143
74,520 1,183,460 340,190 2,067,721 276,265 877,510 15,048 4,834,714
80,000 1,182,770 346,600 2,144,934 332,389 903,700 15,831 5,006,224
83,360 1,161,300 341,910 2,247,828 372,817 867,600 15,554 5,090,370
953,520 15,044,810 4,586,210 26,227,009 3,764,745 10,798,100 210,640 61,585,034
Page 1117
ID PAC-E-11-12
IIPA 28 Attachment IIPA 28f -3
Attach IIPA 28f -3.pdf Page 2 of 2