Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 1 of 16
Company
Operating
Company
Proposed
Gross
Rates With
Adjustment
Operating
Tax
Statement
Present
Ordered
Pro Forma
Increase
Revenue
Ordered
To
Statement
Effect
Per Order
Line
(App. B,
Adjustments
Present
(NS-PGL Ex. 39.1
Conversion
Adjustments
Proposed
Per Order
of Order
w Effect of
No.
Description
p. 2 Col. d)
(App. B, p. 4)
(Cols. b+c)
P CORR, Col. G)
Factor
(Cols. d+e+f)
Increase
(Cols. g+h)
to ADIT
NOL
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
(j)
(k)
1
Base Rate Revenues
490,127$
-$
490,127$
110,928$
294$
601,349$
(55,097)$
546,252$
-$
546,252$
2
PGA Revenues
-
-
-
-
-
-
-
-
-
-
3
Coal Tar Revenues
-
-
-
-
-
-
-
-
-
-
4
Other Revenues
17,252
6
17,258
1,682
-
18,940
-
18,940
-
18,940
5
Total Operating Revenue
507,379
6
507,385
112,610
294
620,289
(55,097)
565,192
-
565,192
6
Uncollectibles Expense
29,414
510
29,924
2,860
293
33,077
(1,539)
31,538
-
31,538
7
Cost of Gas
-
-
-
-
-
-
-
-
-
-
8
Other Production
-
-
-
-
-
-
-
-
-
-
9
Distribution
108,657
(297)
108,360
-
-
108,360
-
108,360
-
108,360
10
Customer Accounts
31,239
379
31,618
-
-
31,618
-
31,618
-
31,618
11
Customer Service and Informational Services
2,214
142
2,356
-
-
2,356
-
2,356
-
2,356
12
Sales
-
-
-
-
-
-
-
-
-
-
13
Administrative and General
132,993
(8,420)
124,573
-
-
124,573
-
124,573
-
124,573
14
Depreciation and Amortization
88,443
(136)
88,307
-
-
88,307
-
88,307
-
88,307
15
Storage
11,542
3
11,545
-
-
11,545
-
11,545
-
11,545
16
Transmission
3,250
(651)
2,599
-
-
2,599
-
2,599
-
2,599
17
Taxes Other than Income
22,517
(1,319)
21,198
-
-
21,198
-
21,198
-
21,198
18
Total Operating Expense
19
Before Income Taxes
430,269
(9,789)
420,480
2,860
293
423,633
(1,539)
422,094
-
422,094
20
State Income Tax
-
789
789
10,426
-
11,215
(5,088)
6,127
(6,127)
-
21
Federal Income Tax
-
2,630
2,630
34,763
-
37,393
(16,964)
20,429
(20,429)
-
22
Deferred Taxes and ITCs Net
22,222
-
22,222
-
-
22,222
-
22,222
26,556
48,778
23
Total Current and Deferred Income Tax Exp
22,222
3,419
25,641
45,189
-
70,830
(22,052)
48,778
-
48,778
24
Total Operating Expenses
452,491
(6,370)
446,121
48,049
293
494,463
(23,591)
470,872
470,872
25
NET OPERATING INCOME
54,888$
6,376$
61,264$
64,561$
1$
125,826$
(31,506)$
94,320$
94,320$
26
Rate Base (Appendix B, p. 5, column (d), line 23)
1,359,084$
27
Overall Rate of Return Per Order
6.94%
28
Base Rate Revenues Change
11.45%
56,125$
29
Other Revenues Change
9.78%
1,688$
30
Total Operating Revenue Change
11.39%
57,813$
The Peoples Gas Light and Coke Company
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 2 of 16
Company
Company
Rebuttal
Surrebuttal
Company
Present
Adjustments
Surrebuttal
Line
(NS-PGL Ex.
(NS-PGL Ex. 39.1
Present
No.
Description
22.1 P, Col. F)
P CORR, Cols. D+E)
(Cols. b+c)
(a)
(b)
(c)
(d)
1
Base Rates Revenues
490,127$
-$
490,127$
2
PGA Revenues
-
-
-
3
ECR Revenues (Coal Tar)
-
-
-
4
Other Revenues
17,210
42
17,252
5
Total Operating Revenue
507,337
42
507,379
6
Uncollectibles Expense
29,414
-
29,414
7
Cost of Gas
-
-
-
8
Other Production
9
Distribution
108,657
-
108,657
10
Customer Accounts
31,239
-
31,239
11
Customer Service and Informational Services
2,214
-
2,214
12
Sales
-
-
-
13
Administrative and General
134,658
(1,665)
132,993
14
Depreciation and Amortization
88,558
(115)
88,443
15
Storage
11,542
-
11,542
16
Transmission
3,250
-
3,250
17
Taxes Other than Income
22,521
(4)
22,517
18
Total Operating Expense
19
Before Income Taxes
432,053
(1,784)
430,269
20
State Income Tax
-
-
-
21
Federal Income Tax
-
-
-
22
Deferred Taxes and ITCs Net
21,098
1,124
22,222
23
Total Current and Deferred Income Tax Exp
21,098
1,124
22,222
24
Total Operating Expenses
453,151
(660)
452,491
25
NET OPERATING INCOME
54,186$
702$
54,888$
The Peoples Gas Light and Coke Company
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 3 of 16
Rate Case
Subtotal
Interest
Uncollectibles
Invested
Rate Case
Expense
Incentive
Non-Union
Operating
Line
Synchronization
Expense
Capital Taxes
Expense
Amortization
Compensation
Wages
Statement
No.
Description
(App. B, p. 9)
( App. B, p. 15)
( Per Order)
(Staff IB)
(Per Order)
(Sch. 12.2P)
(Sch. 12.3 P)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(g)
(h)
(i)
1
Base Rate Revenues
-$
-$
-$
-$
-$
-$
-$
-$
2
PGA Revenues
-
-
-
-
-
-
-
-
3
Coal Tar Revenues
-
-
-
-
-
-
-
-
4
Other Revenues
-
-
-
-
-
-
-
-
5
Total Operating Revenue
-
-
-
-
-
-
-
-
6
Uncollectibles Expense
-
510
-
-
-
-
510
7
Cost of Gas
-
-
-
-
-
-
-
-
8
Other Production
-
-
-
-
-
-
-
-
9
Distribution
-
-
-
-
-
(558)
261
(297)
10
Customer Accounts
-
-
-
-
-
(400)
779
379
11
Customer Service and Informational Services
-
-
-
-
-
(57)
199
142
12
Sales
-
-
-
-
-
-
-
-
13
Administrative and General
-
-
-
(29)
-
(5,492)
(1,960)
(7,481)
14
Depreciation and Amortization
-
-
-
-
(37)
(99)
(136)
15
Storage
-
-
-
-
-
(90)
93
3
16
Transmission
-
-
-
-
-
(37)
(614)
(651)
17
Taxes Other than Income
-
-
(325)
-
-
(595)
(399)
(1,319)
18
Total Operating Expense
19
Before Income Taxes
-
510
(325)
(29)
-
(7,266)
(1,740)
(8,850)
20
State Income Tax
(142)
(48)
31
3
-
690
165
699
21
Federal Income Tax
(473)
(162)
103
9
-
2,302
551
2,330
22
Deferred Taxes and ITCs Net
-
-
-
-
-
-
-
-
23
Total Current and Deferred Income Tax Exp
(615)
(210)
134
12
-
2,992
716
3,029
24
Total Operating Expenses
(615)
300
(191)
(17)
-
(4,274)
(1,024)
(5,821)
25
NET OPERATING INCOME
615$
(300)$
191$
17$
-$
4,274$
1,024$
5,821$
The Peoples Gas Light and Coke Company
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 4 of 16
Subtotal
Gas
Total
Operating
Solicitation
Repairs
Transportation
Operating
Line
Statement
Services
Revenue
Admin. Costs
Statement
No.
Description
Adjustments
(Staff IB)
(Staff IB)
(Sch. 12.9 P)
(Source)
(Source)
(Source)
Adjustments
(a)
(j)
(u)
(aa)
(ad)
(n)
(m)
(n)
(q)
1
Base Rate Revenues
-$
-$
-$
-$
-$
-$
-$
2
PGA Revenues
-
-
-
-
-
-
-
-
3
Coal Tar Revenues
-
-
-
-
-
-
-
-
4
Other Revenues
-
-
6
-
-
-
-
6
5
Total Operating Revenue
-
-
6
-
-
-
-
6
6
Uncollectibles Expense
510
-
-
-
-
-
-
510
7
Cost of Gas
-
-
-
-
-
-
-
-
8
Other Production
-
-
-
-
-
-
-
-
9
Distribution
(297)
-
-
-
-
-
-
(297)
10
Customer Accounts
379
-
-
-
-
-
-
379
11
Customer Service and Informational Services
142
-
-
-
-
-
-
142
12
Sales
-
-
-
-
-
-
-
-
13
Administrative and General
(7,481)
(656)
(283)
(8,420)
14
Depreciation and Amortization
(136)
-
-
-
-
-
-
(136)
15
Storage
3
-
-
-
-
-
-
3
16
Transmission
(651)
-
-
-
-
-
-
(651)
17
Taxes Other than Income
(1,319)
-
-
-
-
-
-
(1,319)
18
Total Operating Expense
19
Before Income Taxes
(8,850)
(656)
-
(283)
-
-
-
(9,789)
20
State Income Tax
699
62
1
27
-
-
-
789
21
Federal Income Tax
2,330
208
2
90
-
-
-
2,630
22
Deferred Taxes and ITCs Net
-
-
-
-
-
-
-
-
23
Total Current and Deferred Income Tax Exp
3,029
270
3
117
-
-
-
3,419
24
Total Operating Expenses
(5,821)
(386)
3
(166)
-
-
-
(6,370)
25
NET OPERATING INCOME
5,821$
386$
3$
166$
-$
-$
-$
6,376$
The Peoples Gas Light and Coke Company
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 5 of 16
Company
Surrebuttal
Rate Base
Ordered
Ordered
Line
(App. B,
Adjustments
Rate Base
No.
Description
p. 6 Col. d)
(App. B, p. 7)
(Col. b+c)
(a)
(b)
(c)
(d)
1
Gross Utility Plant
2,849,863$
(5,111)$
2,844,752$
2
Accumulated Provision for Depr. and Amort.
(1,153,192)
249
(1,152,943)
3
-
-
-
4
Net Plant
1,696,671$
(4,862)$
1,691,809$
5
Additions to Rate Base:
6
Cash Working Capital
38,567
(24,490)
14,077
7
Materials and Supplies
8,743
-
8,743
8
Gas in Storage
61,932
-
61,932
9
Retirement Benefits, Net
68,887
(118,420)
(49,533)
10
Budget Plan Balances
19,020
-
19,020
11
-
-
-
12
Deductions From Rate Base:
13
Accumulated Deferred Income Taxes
(382,735)
34,003
(348,732)
14
Customer Deposits
(29,267)
-
(29,267)
15
Customer Advances for Construction
(549)
-
(549)
16
Reserve for Injuries and Damages
(8,416)
-
(8,416)
17
-
-
-
-
18
-
-
-
-
19
-
-
-
-
20
-
-
-
-
21
-
-
-
-
22
-
-
-
-
23
Rate Base
1,472,853$
(113,769)$
1,359,084$
The Peoples Gas Light and Coke Company
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 6 of 16
Company
Company
Rebuttal
Surrebuttal
Company
Rate Base
Adjustments
Surrebuttal
Line
(NS-PGL Ex.
(NS-PGL Ex. 40.1
Rate Base
No.
Description
23.1 P, Col. F)
P CORR, Col. E)
(Cols. b+c)
(a)
(b)
(c)
(d)
1
Gross Utility Plant
2,853,073$
(3,210)$
2,849,863$
2
Accumulated Provision for Depr. and Amort.
(1,153,285)
93
(1,153,192)
3
-
-
-
-
4
Net Plant
1,699,788
(3,117)
1,696,671
5
Additions to Rate Base
6
Cash Working Capital
36,474
2,093
38,567
7
Materials and Supplies
8,743
-
8,743
8
Gas in Storage
61,932
-
61,932
9
Retirement Benefits, Net
68,887
-
68,887
10
Budget Plan Balances
19,020
-
19,020
11
-
-
-
-
12
Deductions From Rate Base:
-
13
Accumulated Deferred Income Taxes
(403,698)
20,963
(382,735)
14
Customer Deposits
(29,267)
-
(29,267)
15
Customer Advances for Construction
(549)
-
(549)
16
Reserve for Injuries and Damages
(8,416)
-
(8,416)
17
-
-
-
-
18
-
-
-
-
19
-
-
-
-
20
-
-
-
-
21
-
-
-
-
22
-
-
-
-
23
Rate Base
1,452,914$
19,939$
1,472,853$
The Peoples Gas Light and Coke Company
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 7 of 16
Cash Working
Pension
Incentive
Non-Union
Materials
Gas in
NOL
Total
Line
Capital
Asset
Compensation
Wages
& Supplies
Storage
(App. B, p. 16
Rate Base
No.
Description
(Per Order)
(Sch. 12.1 P)
(Sch. 12.2 P)
(Sch. 12.3 P)
(Per Order)
(Per Order)
Per Order)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(k)
(h)
(i)
1
Gross Utility Plant
-$
(1,140)$
(3,971)$
-$
-$
-$
(5,111)$
2
Accumulated Provision for Depr. and Amort.
-
150
99
-
-
-
249
3
-
-
-
-
-
-
-
-
4
Net Plant
-$
-$
(990)$
(3,872)$
-$
-
-
(4,862)$
5
Additions to Rate Base:
6
Cash Working Capital
(24,490)
-
-
-
-
-
-
(24,490)
(24,490)
7
Materials and Supplies
-
-
-
-
-
-
-
-
8
Gas in Storage
-
-
-
-
-
-
-
-
9
Retirement Benefits, Net
-
(118,420)
-
-
-
-
-
(118,420)
10
Budget Plan Balances
-
-
-
-
-
-
-
-
11
-
-
-
-
-
-
-
-
-
12
Deductions From Rate Base:
-
-
-
-
-
-
-
-
13
Accumulated Deferred Income Taxes
-
47,234
42
5
-
-
(13,278)
34,003
14
Customer Deposits
-
-
-
-
-
-
-
-
15
Customer Advances for Construction
-
-
-
-
-
-
-
-
16
Reserve for Injuries and Damages
-
-
-
-
-
-
-
17
-
-
-
-
-
-
-
-
-
18
-
-
-
-
-
-
-
-
-
19
-
-
-
-
-
-
-
-
-
20
-
-
-
-
-
-
-
-
-
21
-
-
-
-
-
-
-
-
-
22
-
-
-
-
-
-
-
-
-
23
Rate Base
(24,490)$
(71,186)$
(948)$
(3,867)$
-$
-$
(13,278)$
(113,769)$
The Peoples Gas Light and Coke Company
Adjustments to Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 8 of 16
Line
Peoples Gas'
Ordered
Per
No.
Proposal
Adjustments
Order
(b)
(c)
(d)
1
2
Current Revenues
507,379$
507,379$
3
Proposed Increase
112,610
(54,797)
57,813
4
Proposed Revenue Requirement
619,989$
(54,797)$
565,192$
5
Percentage Increase
22.19%
(10.80)%
11.39%
6
7
Rate of Return
(30,136)$
8
Incentive Compensation (Sch. 12.2 P)
(7,573)
9
Pension Asset (Sch. 12.1 P)
(7,456)
10
Interest Synchronization (App. B, p. 9)
(2,968)
11
Non-Union Wages (Sch. 12.3 P)
(2,196)
12
Solicitation Services (Staff IB)
(675)
13
Invested Capital Taxes ( Per Order)
(334)
14
Gas Transportation Admin. Costs (Sch. 12.9 P)
(290)
15
Rate Case Expense Amortization (Per Order)
-
16
Rate Case Expense (Staff IB)
(30)
17
Materials & Supplies (Per Order)
-
18
Repairs Revenue (Staff IB)
-
19
Gross Revenue Conversion Factor
294
20
Uncollectibles Expense ( App. B, p. 15)
525
21
Cash Working Capital (Per Order)
(2,565)
22
NOL (App. B, p. 16 Per Order)
(1,391)
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Rounding
(2)
38
Effect of Ordered Adjustments
(54,797)$
39
40
Column (c), line 5.
6
41
Column (f), line 5.
294
42
Column (h), line 5.
(55,097)
43
Total Effect of Ordered Adjustments
(54,797)$
Summary
Effect of Each Ordered Adjustment
Reconciliation to Page 1
The Peoples Gas Light and Coke Company
Revenue Effect of Ordered Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
Description
(a)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 9 of 16
Line
No.
Amount
(b)
1
Rate Base
1,359,084$
(1)
2
Weighted Cost of Debt
2.31%
(2)
3
Synchronized Interest Per Order (Line 1 x Line 2)
31,395$
4
Company Interest Expense
29,901
(3)
5
Increase (Decrease) in Interest Expense
1,494$
6
Increase (Decrease) in State Income Tax Expense
7
at
9.500%
(142)$
8
Increase (Decrease) in Federal Income Tax Expense
9
at
35.000%
(473)$
10
Total Income Tax Expense
(615)$
(1) Source: Appendix B, p. 5, column (d), line 23
(2) Source: Per Order
(3) Source: Company NS-PGL Ex. 39.7 P
Description
(a)
The Peoples Gas Light and Coke Company
Interest Synchronization Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 10 of 16
Per Order
Per Order
Line
With
Without
No.
Description
Rate
Bad Debts
Bad Debts
(a)
(b)
(c)
(d)
1
Revenues
1.000000
1.000000
2
Uncollectibles expense percentage per Order
2.7927%
0.027927
3
State Taxable Income
0.972073
4
State Income Tax
9.5000%
0.092347
0.095000
5
Federal Taxable Income
0.879726
0.905000
6
Federal Income Tax
35.0000%
0.307904
0.316750
7
Operating Income
0.571822
0.588250
8
Gross Revenue Conversion Factor Per Order (Line 1 / Line 7)
1.748796
1.699958
The Peoples Gas Light and Coke Company
Gross Revenue Conversion Factor
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 11 of 16
CWC
Line
CWC Factor
Requirement
No.
Item
Amount
Lag (Lead)
(D) / 365
(C) x (E)
(A)
(B)
(C)
(D)
(E)
(F)
(D/365)
1
Revenues
1,022,306$
56.06
0.15359
157,015$
Appendix B, p. 12, Column C, Line 6
2
Pass Through Taxes
167,973
0.00
0.00000
-
Sum of Lines 17-21
3
Payroll and Withholdings
53,667
(14.26)
(0.03907)
(2,097)
Appendix B, p. 13, Column C, Line 4
4
Inter Company Billings
198,752
(35.80)
(0.09808)
(19,494)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 5
5
Natural Gas
639,885
(40.62)
(0.11129)
(71,211)
Peoples Gas Schedule C-1, line 6, column C
6
Other Operations and Maintenance
32,644
(46.62)
(0.12773)
(4,169)
Appendix B, p. 12, Column C, Line 18
7
Federal Insurance Contributions (FICA)
3,903
(16.20)
(0.04438)
(173)
Appendix B, p. 13, Column C, Line 11
8
Federal Unemployment Tax
24
(76.38)
(0.20926)
(5)
Peoples Gas Schedule C-18, line 3 column B
9
State Unemployment Tax
277
(80.17)
(0.21964)
(61)
Peoples Gas Schedule C-18, line 10 column B
10
Property/Real Estate Taxes
1,168
(361.00)
(0.98904)
(1,155)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 12
11
Invested Capital Tax
11,187
(35.40)
(0.09699)
(1,085)
Appendix B, p. 13, Column C, Line 7
12
Corporation Franchise Tax
220
(182.79)
(0.50079)
(110)
Peoples Gas Schedule C-18, line 9 column B
13
Sales, Use and Accelerated Tax
185
(6.48)
(0.01775)
(3)
Peoples Gas Schedule C-18, line 11 column B
14
Federal Excise Tax
41
(75.37)
(0.20649)
(8)
Peoples Gas Schedule C-18, line 4 column B
15
Chicago Employer's Expense Tax
54
(59.88)
(0.16405)
(9)
Peoples Gas Schedule C-18, line 19 column B
16
Unauthorized Insurance Tax
127
133.89
0.36682
47
Peoples Gas Schedule C-18, line 14 column B
17
ICC Gas Revenue Tax
1,138
31.84
0.08723
99
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 20
18
Gross Receipts/Municipal Utility Tax
90,983
(82.88)
(0.22707)
(20,659)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 21
19
Energy Assistance Charges
9,684
(67.39)
(0.18463)
(1,788)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 22
20
IDOR Gas Revenue/Public Utility tax
35,417
(35.75)
(0.09795)
(3,469)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 24
21
City of Chicago Gas Use tax
30,751
(82.88)
(0.22707)
(6,983)
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 25
22
Interest Expense
31,395
(91.25)
(0.25000)
(7,849)
Appendix B, p. 9, Column b, Line 3
23
Federal Income Tax
20,429
(37.88)
(0.10378)
(2,120)
Appendix B, p. 1, Column i, Line 21
24
State Income Tax
6,127
(37.88)
(0.10378)
(636)
Appendix B, p. 1, Column i, Line 20
25
Cash Working Capital per Order
14,077$
Sum of Lines 1 through 24
26
Cash Working Capital per Company
38,567
NS-PGL Ex. 40.4P CORRECTED
27
Difference -- Ordered Adjustment
(24,490)$
Line 25 - Line 26
Note:
Lag (Lead) is from Peoples Gas Schedule B-8, Page 1 of 2, Column B
(G)
The Peoples Gas Light and Coke Company
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
Column (C) SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 12 of 16
Line
No.
Description
Amount
(A)
(B)
(C)
1
Total Operating Revenues
565,192$
Appendix B, p. 1, Column i, Line 5
2
PGA Revenue
639,885
Peoples Schedule C-1, line 6, column C
3
Uncollectible Accounts
(31,538)
Appendix B, p. 1, Column i, Line 6
4
Depreciation & Amortization
(88,307)
Appendix B, p. 1, Column i, Line 14
5
Return on Equity
(62,926)
Line 9 below
6
Total Revenues for CWC calculation
1,022,306$
Sum of Lines 1 through 5
7
Total Rate Base
1,359,084$
Appendix B, p. 5, Column d, Line 23
8
Weighted Cost of Capital
4.63%
Per Order
9
Return on equity deduction from revenue
62,926$
Line 7 x Line 8
10
O & M Expenses
422,094$
Appendix B, p. 1, Column i, Line 19
11
Payroll and Withholdings
(53,667)
Appendix B, p. 13, Column C, Line 4
12
Inter Company Billings
(198,752)
Peoples Schedule B-8, Page 1 of 3, Column B, Line 5
13
FICA
(3,903)
Appendix B, p. 13, Column C, Line 11
14
Taxes Other Than Income excluding FICA
(13,283)
Appendix B, p. 11, Column C, Sum of Lines 8 through 16
15
Interest Expense
-
Per Order
16
Uncollectible Accounts
(31,538)
Appendix B, p. 1, Column i, Line 6
17
Depreciation & Amortization
(88,307)
Appendix B, p. 1, Column i, Line 14
18
Other Operations & Maintenance
32,644$
Sum of Lines 10 through 14
(D)
The Peoples Gas Light and Coke Company
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 13 of 16
Line
No.
Description
Amount
(A)
(B)
(C)
1
Payroll and Withholdings per Company Filing
61,119$
Peoples Schedule B-8, Page 1 of 2, Column B, Line 4
2
Incentive Compensation Adjustment
(5,492)
Appendix B, p. 3, Column g, Line 13
3
Non-Union Wages Adjustment
(1,960)
Appendix B, p. 3, Column h, Line 13
4
Payroll and Withholdings per Order
53,667$
Sum of Lines 1 through 4
5
Invested Capital Tax per Company Filing
11,512$
Peoples Schedule C-18, line 8 column B
6
Invested Capital Tax Adjustment
(325)
Appendix B, p. 3, Column d, Line 17
7
Invested Capital Tax per Order
11,187$
Sum of Lines 14 and 15
8
FICA per Company
4,897
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 9
9
Incentive Compensation Adjustment
(595)
Appendix B, p. 3, Column g, Line 17
10
Non-Union Wages Adjustment
(399)
Appendix B, p. 3, Column h, Line 17
11
FICA per Order
3,903$
Sum of Lines 8 through 10
(D)
The Peoples Gas Light and Coke Company
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 14 of 16
Line
Description
Amount
(A)
(B)
(C)
1
Rate Base
1,359,084$
Appendix B, p. 1, col. i, line 26
2
Rate of Return
6.94%
Appendix B, p. 1, col. i, line 27
3
Operating Income Required
94,320$
Line 1 x Line 2
4
Pro forma operating income at present rates adjusted before ICT adjustment
61,589
Appendix B, p. 1, col. d line 25 -
Appendix B, p. 3, col. d line 17
5
Operating Income Additional Allowed
32,731$
Line 3 - line 4
6
Invested Capital Tax Rate
0.80%
NS-PGL Ex. WPC-2.14
7
Incremental Invested Capital Tax Impact per Order
262$
Line 5 x line 6
8
Incremental Invested Capital Tax Impact per Company
587
NS-PGL Ex. WPC-2.14
9
Ordered Adjustment
(325)$
Line 7 - line 8
(D)
The Peoples Gas Light and Coke Company
Invested Capital Tax Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 15 of 16
Line
Description
Amount
(A)
(B)
(C)
1
2010 Write-offs
43,301$
Data Request PGL AG 1.43
2
2010 Recoveries
13,377
Data Request PGL AG 1.43
3
2010 Net Write-offs
29,924$
Line 1 - Line 2
4
Company's Uncollectibles Expense
29,414
Schedule B-1
5
Ordered Adjustment
510$
Line 3 - line 4
(D)
The Peoples Gas Light and Coke Company
Uncollectibles Expense Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix B
Page 16 of 16
Total
Line
Federal
No.
Description
Federal
State
& State
(a)
(b)
(c)
(d)
1
NOL Available at 12/31/11
30,869$
6,621$
37,490$
NS-PGL WP Ex. 39.5P CORR. and 40.5P CORR.
2
Co. Surrebuttal at Current
42,300
(414)
41,886
NS-PGL WP Ex. 39.5P CORR. and 40.5P CORR.
3
NOL Available Per Company Surrebuttal
73,169$
6,207$
79,376$
NS-PGL WP Ex. 39.5P CORR. and 40.5P CORR.
4
Effect of Order
(20,429)$
(6,127)$
(26,556)$
App. B, Page 1, Col. (j), lines 20-21
5
NOL Adjustment to Rate Base
(10,215)$
(3,064)$
(13,278)$
Line 4/2
Source
(e)
The Peoples Gas Light and Coke Company
NOL Adjustment
For the Test Year Ending December 31, 2012
