Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
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. A, p. 2
Adjustments
Present
(NS-PGL Ex. 39.1
Conversion
Adjustments
Proposed
Per Order
of Order
w Effect of
No.
Description
Col. d)
(App. A, p. 4)
(Cols. b+c)
N, 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
75,170$
-$
75,170$
8,214$
(9)$
83,375$
(6,407)$
76,968$
-$
76,968$
2
PGA Revenues
-
-
-
-
-
-
-
-
-
-
3
Coal Tar Revenues
-
-
-
-
-
-
-
-
-
-
4
Other Revenues
1,557
1
1,558
133
-
1,691
-
1,691
-
1,691
5
Total Operating Revenue
76,727
1
76,728
8,347
(9)$
85,066
(6,407)
78,659
-
78,659
6
Uncollectibles Expense
1,675
(421)
1,254
58
(9)
1,303
(38)
1,265
-
1,265
7
Cost of Gas
-
-
-
-
-
-
-
-
-
-
8
Other Production
273
-
273
-
-
273
-
273
-
273
9
Distribution
11,886
271
12,157
-
-
12,157
-
12,157
-
12,157
10
Customer Accounts
5,678
(4)
5,674
-
-
5,674
-
5,674
-
5,674
11
Customer Service and Informational Services
502
29
531
-
-
531
-
531
-
531
12
Sales
-
-
-
-
-
-
-
-
-
-
13
Administrative and General
26,535
(1,706)
24,829
-
-
24,829
-
24,829
-
24,829
14
Depreciation
10,246
(10)
10,236
-
-
10,236
-
10,236
-
10,236
15
Storage
-
46
46
-
-
46
-
46
-
46
16
Transmission
180
-
180
-
-
180
-
180
-
180
17
Taxes Other than Income
3,347
(153)
3,194
-
-
3,194
-
3,194
-
3,194
18
Total Operating Expense
19
Before Income Taxes
60,322
(1,948)
58,374
58
(9)
58,423
(38)
58,385
-
58,385
20
State Income Tax
322
147
469
787
-
1,256
(605)
651
-
651
21
Federal Income Tax
-
490
490
2,626
-
3,116
(2,017)
1,099
(1,099)
-
22
Deferred Taxes and ITCs Net
4,591
-
4,591
-
-
4,591
-
4,591
1,099
5,690
23
Total Current and Deferred Income Tax Exp
4,913
637
5,550
3,413
-
8,963
(2,622)
6,341
-
6,341
24
Total Operating Expenses
65,235
(1,311)
63,924
3,471
(9)
67,386
(2,660)
64,726
64,726
25
NET OPERATING INCOME
11,492$
1,312$
12,804$
4,876$
-$
17,680$
(3,747)$
13,933$
13,933$
26
Rate Base (Appendix A, p. 5, column (d), line 23)
187,530$
27
Overall Rate of Return Per Order
7.43%
28
Base Rate Revenues Change
2.39%
1,798$
29
Other Revenues Change
8.61%
134$
30
Total Operating Revenue Change
2.52%
1,932$
Statement of Operating Income with Adjustments
For the Test Year Ending December 31, 2012
(In Thousands)
North Shore Gas CompanyDocket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 2 of 16
Company
Rebuttal Case
Company
Pro Forma
Surrebuttal
Company
Present
Adjustments
Surrebuttal
Line
(NS-PGL Ex.
(NS-PGL Ex.
Present
No.
Description
22.1 N, Col. F)
39.1 N, Cols. D+E)
(Cols. b+c)
(a)
(b)
(c)
(d)
1
Base Rates Revenues
75,170$
-$
75,170$
2
PGA Revenues
-
-
-
3
ECR Revenues (Coal Tar)
-
-
-
4
Other Revenues
1,550
7
1,557
5
Total Operating Revenue
76,720
7
76,727
6
Uncollectibles Expense
1,675
-
1,675
7
Cost of Gas
-
-
-
8
Other Production
273
-
273
9
Distribution
11,886
-
11,886
10
Customer Accounts
5,678
-
5,678
11
Customer Service and Informational Services
502
-
502
12
Sales
-
-
-
13
Administrative and General
26,614
(79)
26,535
14
Depreciation
10,317
(71)
10,246
15
Storage
-
-
-
16
Transmission
180
-
180
17
Taxes Other than Income
3,348
(1)
3,347
18
Total Operating Expense
19
Before Income Taxes
60,473
(151)
60,322
20
State Income Tax
313
9
322
21
Federal Income Tax
-
-
-
22
Deferred Taxes and ITCs Net
4,537
54
4,591
23
Total Current and Deferred Income Tax Exp
4,850
63
4,913
24
Total Operating Expenses
65,323
(88)
65,235
25
NET OPERATING INCOME
11,397$
95$
11,492$
North Shore Gas 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 A
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. A, p. 9)
( App. A, p. 15)
( Per Order)
(Staff IB)
(Per Order)
(Sch 12.2N)
(Sch. 12.3 N)
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
-
(421)
-
-
-
-
-
(421)
7
Cost of Gas
-
-
-
-
-
-
-
-
8
Other Production
-
-
-
-
-
-
-
-
9
Distribution
-
-
-
-
-
(82)
353
271
10
Customer Accounts
-
-
-
-
-
(75)
71
(4)
11
Customer Service and Informational Services
-
-
-
-
-
(12)
41
29
12
Sales
-
-
-
-
-
-
-
-
13
Administrative and General
-
-
-
(21)
-
(986)
(527)
(1,534)
14
Depreciation
-
-
-
-
(5)
(5)
(10)
15
Storage
-
-
-
-
-
(6)
52
46
16
Transmission
-
-
-
-
-
-
-
-
17
Taxes Other than Income
-
-
(33)
-
-
(105)
(15)
(153)
18
Total Operating Expense
19
Before Income Taxes
-
(421)
(33)
(21)
-
(1,271)
(30)
(1,776)
20
State Income Tax
(38)
40
3
2
-
121
3
131
21
Federal Income Tax
(128)
133
10
7
-
403
10
435
22
Deferred Taxes and ITCs Net
-
-
-
-
-
-
-
-
24
Total Current and Deferred Income Tax Exp
(166)
173
13
9
-
524
13
566
25
Total Operating Expenses
(166)
(248)
(20)
(12)
-
(747)
(17)
(1,210)
26
NET OPERATING INCOME
166$
248$
20$
12$
-$
747$
17$
1,210$
North Shore Gas Company
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
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 N)
(Source)
(Source)
(Source)
Adjustments
(a)
(j)
(u)
(aa)
(ad)
(n)
(o)
(p)
(q)
1
Base Rate Revenues
-$
-$
-$
-$
-$
2
PGA Revenues
-
-
-
-
-
-
-
-
3
Coal Tar Revenues
-
-
-
-
-
-
-
-
4
Other Revenues
-
-
1
-
-
-
-
1
5
Total Operating Revenue
-
-
1
-
-
-
-
1
6
Uncollectibles Expense
(421)
-
-
-
-
-
(421)
7
Cost of Gas
-
-
-
-
-
-
-
-
8
Other Production
-
-
-
-
-
-
-
-
9
Distribution
271
-
-
-
-
-
-
271
10
Customer Accounts
(4)
-
-
-
-
-
-
(4)
11
Customer Service and Informational Services
29
-
-
-
-
-
-
29
12
Sales
-
-
-
-
-
-
-
-
13
Administrative and General
(1,534)
(116)
(56)
-
-
-
(1,706)
14
Depreciation
(10)
-
-
-
-
-
-
(10)
15
Storage
46
-
-
-
-
-
-
46
16
Transmission
-
-
-
-
-
-
-
-
17
Taxes Other than Income
(153)
-
-
-
-
-
-
(153)
18
Total Operating Expense
19
Before Income Taxes
(1,776)
(116)
-
(56)
-
-
-
(1,948)
20
State Income Tax
131
11
-
5
-
-
-
147
21
Federal Income Tax
435
37
-
18
-
-
-
490
22
Deferred Taxes and ITCs Net
-
-
-
-
-
-
-
-
23
Total Current and Deferred Income Tax Exp
566
48
-
23
-
-
-
637
24
Total Operating Expenses
(1,210)
(68)
-
(33)
-
-
-
(1,311)
25
NET OPERATING INCOME
1,210$
68$
1$
33$
-$
-$
-$
1,312$
North Shore Gas Company
Adjustments to Operating Income
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 5 of 16
Company
Pro Forma
Jurisdictional
Rate Base
Ordered
Ordered
Line
(App. A,
Adjustments
Rate Base
No.
Description
p. 6 Col. d)
(App. A, p. 7)
(Col. b+c)
(a)
(b)
(c)
(d)
1
Gross Utility Plant
431,439$
(392)$
431,047$
2
Accumulated Provision for Depr. and Amort.
(178,748)
28
(178,720)
3
-
-
-
4
Net Plant
252,691$
(364)$
252,327$
5
Additions to Rate Base:
6
Cash Working Capital
2,198
(1,737)
461
7
Materials and Supplies
1,785
-
1,785
8
Gas in Storage
6,629
-
6,629
9
Retirement Benefits, Net
(2,804)
(3,942)
(6,746)
10
Budget Plan Balances
2,085
-
2,085
11
-
-
-
-
12
Deductions From Rate Base:
-
13
Accumulated Deferred Income Taxes
(64,560)
1,011
(63,549)
14
Customer Deposits
(2,650)
-
(2,650)
15
Customer Advances for Construction
(631)
-
(631)
16
Reserve for Injuries and Damages
(2,181)
-
(2,181)
17
-
-
-
-
18
-
-
-
-
19
-
-
-
-
20
-
-
-
-
21
-
-
-
-
22
-
-
-
-
23
Rate Base
192,562$
(5,032)$
187,530$
North Shore Gas Company
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 6 of 16
Company
Rebuttal
Company
Pro Forma
Surrebuttal
Company
Rate Base
Adjustments
Surrebuttal
Line
(NS-PGL Ex.
(NS-PGL Ex.
Rate Base
No.
Description
23.1 N, Col. F)
40.1 N, Col. E)
(Cols. b+c)
(a)
(b)
(c)
(d)
1
Gross Utility Plant
433,550$
(2,111)$
431,439$
2
Accumulated Provision for Depr. and Amort.
(178,804)
56
(178,748)
3
-
-
-
-
4
Net Plant
254,746
(2,055)
252,691
5
Additions to Rate Base
6
Cash Working Capital
2,150
48
2,198
7
Materials and Supplies
1,785
-
1,785
8
Gas in Storage
6,629
-
6,629
9
Retirement Benefits, Net
(2,804)
-
(2,804)
10
Budget Plan Balances
2,085
-
2,085
11
-
-
-
-
12
Deductions From Rate Base:
-
13
Accumulated Deferred Income Taxes
(66,346)
1,786
(64,560)
14
Customer Deposits
(2,650)
-
(2,650)
15
Customer Advances for Construction
(631)
-
(631)
16
Reserve for Injuries and Damages
(2,181)
-
(2,181)
17
-
-
-
-
18
-
-
-
-
19
-
-
-
-
20
-
-
-
-
21
-
-
-
-
22
-
-
-
-
23
Rate Base
192,783$
(221)$
192,562$
North Shore Gas Company
Rate Base
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 7 of 16
Cash Working
Pension
Incentive
Non-Union
Materials
Gas in
NOL
Total
Line
Capital
Asset
Compensation
Wages
& Supplies
Storage
(App. A, p. 16
Rate Base
No.
Description
(Per Order)
(Sch. 12.1 N)
(Sch. 12.2 N)
(Sch. 12.3 N)
(Per Order)
(Per Order)
Per Order)
Adjustments
(a)
(b)
(c)
(d)
(e)
(f)
(k)
(h)
(i)
1
Gross Utility Plant
-$
(208)$
(184)$
-$
-$
-$
(392)$
2
Accumulated Provision for Depr. and Amort.
-
23
5
-
-
-
28
3
-
-
-
-
-
-
-
-
4
Net Plant
-$
-$
(185)$
(179)$
-
-
-
(364)$
5
Additions to Rate Base:
6
Cash Working Capital
(1,737)
-
-
-
-
-
-
(1,737)
(1,737)
7
Materials and Supplies
-
-
-
-
-
-
-
-
8
Gas in Storage
-
-
-
-
-
-
-
-
9
Retirement Benefits, Net
-
(3,942)
-
-
-
-
-
(3,942)
10
Budget Plan Balances
-
-
-
-
-
-
-
-
11
-
-
-
-
-
-
-
-
-
12
Deductions From Rate Base:
-
-
-
-
-
-
-
-
13
Accumulated Deferred Income Taxes
-
1,548
8
5
-
-
(550)
1,011
14
Customer Deposits
-
-
-
-
-
-
-
-
15
Customer Advances for Construction
-
-
-
-
-
-
-
-
16
Reserve for Injuries and Damages
-
-
-
-
-
-
-
-
17
-
-
-
-
-
-
-
-
-
18
-
-
-
-
-
-
-
-
-
19
-
-
-
-
-
-
-
-
-
20
-
-
-
-
-
-
-
-
-
21
-
-
-
-
-
-
-
-
-
22
-
-
-
-
-
-
-
-
-
23
Rate Base
(1,737)$
(2,394)$
(177)$
(174)$
-$
-$
(550)$
(5,032)$
(In Thousands)
Adjustments to Rate Base
North Shore Gas Company
For the Test Year Ending December 31, 2012Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 8 of 16
Line
North Shore's
Ordered
No.
Proposal
Adjustments
Order
(b)
(c)
(d)
1
2
Current Revenues
76,727$
76,727$
3
Ordered Increase
8,347
(6,415)
1,932
4
Proposed Revenue Requirement
85,074$
(6,415)$
78,659$
5
Percentage Increase
10.88%
(8.36)%
2.52%
6
7
Rate of Return
(3,524)$
8
Incentive Compensation (Sch. 12.2 N)
(1,296)
9
Uncollectibles Expense
(424)
10
Interest Synchronization ( App. A, p. 9)
(380)
11
Pension Asset (Sch. 12.1 N)
(259)
12
Solicitation Services (Staff IB)
(116)
13
Gas Transportation Admin. Costs (Sch. 12.9 N)
(56)
14
Non-Union Wages (Sch. 12.3 N)
(48)
15
Invested Capital Taxes ( Per Order)
(34)
16
Rate Case Expense Amortization (Per Order)
-
17
Rate Case Expense (Staff IB)
(21)
18
Gross Revenue Conversion Factor
(9)
19
Materials & Supplies (Per Order)
-
20
Repairs Revenue (Staff IB)
-
21
Cash Working Capital (Per Order)
(188)
22
NOL (App. A, p. 16 Per Order)
(59)
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
Rounding
(1)
38
Effect of Ordered Adjustments
(6,415)$
39
40
Column (c), line 5.
1
41
Column (f), line 5.
(9)
42
Column (h), line 5.
(6,407)
43
Total Effect of Ordered Adjustments
(6,415)$
Reconciliation to Page 1
Summary
Effect of Each Adjustment
North Shore Gas 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 A
Page 9 of 16
Line
No.
Amount
(b)
1
Rate Base
187,530$
(1)
2
Weighted Cost of Debt
2.70%
(2)
3
Synchronized Interest Per Order (Line 1 x Line 2)
5,063$
4
Company Interest Expense
4,660
(3)
5
Increase (Decrease) in Interest Expense
403$
6
Increase (Decrease) in State Income Tax Expense
7
at
9.500%
(38)$
8
Increase (Decrease) in Federal Income Tax Expense
9
at
35.000%
(128)$
10
Total Income Tax Expense
(166)$
(1) Source: Appendix A, p. 5, column (d), line 23
(2) Source: Per Order
(3) Source: Company NS-PGL Ex. 39.7 N
Description
(a)
North Shore Gas Company
Interest Synchronization Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
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
0.5936%
0.005936
3
State Taxable Income
0.994064
4
State Income Tax
9.5000%
0.094436
0.095000
5
Federal Taxable Income
0.899628
0.905000
6
Federal Income Tax
35.0000%
0.314870
0.316750
7
Operating Income
0.584758
0.588250
8
Gross Revenue Conversion Factor Per Order (Line 1 / Line 7)
1.710109
1.699958
North Shore Gas Company
Gross Revenue Conversion Factor
For the Test Year Ending December 31, 2012
(In Thousands)Docket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 11 of 16
CWC
Line
CWC Factor
Requirement
No.
Item
Amount
Lag (Lead)
(D) / 365
(C) x (E)
(A)
(B)
(C)
(D)
(E)
(D/365)
1
Revenues
207,157$
44.77
0.12266
25,409$
Appendix A, p. 12, Column C, Line 6
2
Pass Through Taxes
16,900
0.00
0.00000
-
3
Payroll and Withholdings
6,622
(14.14)
(0.03874)
(257)
Appendix A, p. 13, Column C, Line 4
4
Inter Company Billings
32,937
(38.23)
(0.10474)
(3,450)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 5
5
Natural Gas
148,869
(40.53)
(0.11104)
(16,531)
North Shore Schedule C-1, line 6, column C
6
Other Operations and Maintenance
4,820
(42.44)
(0.11627)
(560)
Appendix A, p. 12, Column C, Line 18
7
Federal Insurance Contributions (FICA)
586
(16.14)
(0.04422)
(26)
Appendix A, p. 13, Column C, Line 11
8
Federal Unemployment Tax
4
(76.38)
(0.20926)
(1)
North Shore Schedule C-18, line 3 column B
9
State Unemployment Tax
21
(79.70)
(0.21836)
(5)
North Shore Schedule C-18, line 10 column B
10
Property/Real Estate Taxes
236
(374.82)
(1.02690)
(242)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 12
11
Invested Capital Tax
1,612
(30.38)
(0.08323)
(134)
Appendix A, p. 13, Column C, Line 7
12
Corporation Franchise Tax
25
(184.82)
(0.50636)
(13)
North Shore Schedule C-18, line 9 column B
13
Sales and Use Tax
5
(38.74)
(0.10614)
(1)
North Shore Schedule C-18, line 11 column B
14
Federal Excise Tax
2
(75.12)
(0.20581)
-
North Shore Schedule C-18, line 4 column B
15
Unauthorized Insurance Tax
14
136.91
0.37510
5
North Shore Schedule C-18, line 14 column B
16
ICC Gas Revenue Tax
239
32.31
0.08852
21
North Shore Schedule B-8, Page 1 of 3, Column B, Line 19
17
Gross Receipts/Municipal Utility Tax
6,727
(74.81)
(0.20496)
(1,379)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 20
18
Energy Assistance Charges
1,787
(61.09)
(0.16737)
(299)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 21
19
IDOR Gas Revenue/Public Utility tax
8,147
(28.15)
(0.07712)
(628)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 22
20
Interest Expense
5,063
(91.25)
(0.25000)
(1,266)
Appendix A, p. 9, Column b, Line 3
21
Federal Income Tax
1,099
(37.88)
(0.10378)
(114)
Appendix A, p. 1, Column i, Line 21
22
State Income Tax
651
(37.88)
(0.10378)
(68)
Appendix A, p. 1, Column i, Line 20
23
Cash Working Capital per Order
461$
Sum of Lines 1 through 22
24
Cash Working Capital per Company
2,198
NS-PGL Ex. 40.4N
25
Difference --Ordered Adjustment
(1,737)$
Line 23 - Line 24
Note:
Lag (Lead) is from North Shore Schedule B-8, Page 1 of 2, Column B
(G)
North Shore Gas 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 A
Page 12 of 16
Line
No.
Description
Amount
(A)
(B)
(C)
1
Total Operating Revenues
78,659$
Appendix A, p. 1, Column i, Line 5
2
PGA Revenue
148,869
North Shore Schedule C-1, line 6, column C
3
Uncollectible Accounts
(1,265)
Appendix A, p. 1, Column i, Line 6
4
Depreciation & Amortization
(10,236)
Appendix A, p. 1, Column i, Line 14
5
Return on Equity
(8,870)
Line 9 below
6
Total Revenues for CWC calculation
207,157$
Sum of Lines 1 through 5
7
Total Rate Base
187,530$
Appendix A, p. 5, Column d, Line 23
8
Weighted Cost of Capital
4.73%
Per Order
9
Return on equity deduction from revenue
8,870$
Line 7 x Line 8
10
O & M Expenses
58,385$
Appendix A, p. 1, Column i, Line 19
11
Payroll and Withholdings
(6,622)
Appendix A, p. 13, Column C, Line 4
12
Inter Company Billings
(32,937)
North Shore Schedule B-8, Page 1 of 3, Column B, Line 5
13
FICA
(586)
Appendix A, p. 13, Column C, Line 11
14
Taxes Other Than Income excluding FICA
(1,919)
Appendix A, p. 11, Column C, Sum of Lines 8 through 15
15
Interest Expense
-
Per Order
16
Uncollectible Accounts
(1,265)
Appendix A, p. 1, Column i, Line 6
17
Depreciation & Amortization
(10,236)
Appendix A, p. 1, Column i, Line 14
18
Other Operations & Maintenance
4,820$
Sum of Lines 10 through 14
(D)
North Shore Gas Company
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 13 of 16
Line
No.
Description
Amount
(A)
(B)
(C)
1
Payroll and Withholdings per Company Filing
8,135$
North Shore Schedule B-8, Page 1 of 2, Column B, Line 4
2
Incentive Compensation Adjustment
(986)
Appendix A, p. 3, Column g, Line 13
3
Non-Union Wages Adjustment
(527)
Appendix A, p. 3, Column h, Line 13
4
Payroll and Withholdings per Order
6,622$
Sum of Lines 1 through 4
5
Invested Capital Tax per Company Filing
1,645$
North Shore Schedule C-18, line 8 column B
6
Invested Capital Tax Adjustment
(33)
Appendix A, p. 3, Column d, Line 17
7
Invested Capital Tax per Order
1,612$
Sum of Lines 17 through 19
8
FICA per Company
706
Peoples Gas Schedule B-8, Page 1 of 3, Column B, Line 9
9
Incentive Compensation Adjustment
(105)
Appendix A, p. 3, Column g, Line 17
10
Non-Union Wages Adjustment
(15)
Appendix A, p. 3, Column h, Line 17
11
FICA per Order
586$
Sum of Lines 8 through 10
(D)
North Shore Gas Company
Adjustment to Cash Working Capital
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 14 of 16
Line
Description
Amount
(A)
(B)
(C)
1
Rate Base
187,530$
Appendix A, p. 1, col. i, line 26
2
Rate of Return
7.43%
Appendix A, p. 1, col. i, line 27
3
Operating Income Required
13,933$
Line 1 x Line 2
4
Pro forma operating income at present rates adjusted before ICT adjustment
12,837
Appendix A, p. 1, col. d line 25 -
Appendix A, p. 3, col. d line 17
5
Operating Income Additional Allowed
1,096$
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
9$
Line 5 x line 6
8
Incremental Invested Capital Tax Impact per Company
42
NS-PGL Ex. WPC-2.14
9
Ordered Adjustment
(33)$
Line 7 - line 8
(D)
North Shore Gas
Invested Capital Tax Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 15 of 16
Line
Description
Amount
(A)
(B)
(C)
1
2010 Write-offs
1,850$
Data Request NS AG 1.31
2
2010 Recoveries
596
Data Request NS AG 1.31
3
2010 Net Write-offs
1,254$
Line 1 - Line 2
4
Companies Uncollectibles Expense
1,675
Schedule B-1
5
Ordered Adjustment
(421)$
Line 3 - line 4
(D)
North Shore Gas
Uncollectibles Expense Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)
SourceDocket Nos. 11-0280/11-0281
Consolidated
Appendix A
Page 16 of 16
Total
Line
Federal
No.
Description
Federal
State
& State
(a)
(b)
(c)
(d)
1
NOL Available at 12/31/11
70$
184$
254$
NS-PGL WP Ex. 39.5N and 40.5N
2
Co. Surrebuttal at Current
2,672
(184)
2,488
NS-PGL WP Ex. 39.5N and 40.5N
3
NOL Available after Company Surrebuttal at Current
2,742$
-$
2,742$
NS-PGL WP Ex. 39.5N and 40.5N
4
Effect of Order
(1,099)$
-$
(1,099)$
App. A, Page 1, Col. (j), line 21
5
NOL Adjustment to Rate Base
(550)$
-$
(550)$
Line 4/2
Source
(e)
North Shore Gas Company
NOL Adjustment
For the Test Year Ending December 31, 2012
(In Thousands)
