NSG Ex. 1.1
Page 2 of 4
North Shore Gas Company
Volume Balancing Adjustment
Under Rider VBA
Schedule of Rates, ILL C.C. No. 17
Determination of Reconciliation Adjustment for 2010
Annual Reconciliation Adjustment Effective April 1, 2011 - December 31, 2011
Line No.
Total
[A]
[B]
[C]
[D]
[E]
Reconciliation Adjustment 2010
[A] + [B] + [C] + [D]
Sales and Transportation
Sales and Transportation
1
Rate Case Margin (RCM) (1)
26,258,795.56$
6,713,764.82$
32,972,560.38$
2
Actual Margin (AM) (2)
25,632,615.39$
7,603,288.70$
33,235,904.09$
3
Actual Customers (AC) (3)
146,348
13,319
4
Rate Case Customers (RCC) (4)
149,538
13,508
5
AM / AC X RCC (line 2 / line 3 x line 4)
26,191,338.73$
7,711,181.30$
33,902,520.03$
6
Percentage of Fixed Costs (PFC) (5)
99%
99%
7
(Line 1 - Line 5) x Line 6
66,782.26$
(987,442.32)$
(920,660.06)$
8
VBAR - Rider VBA revenues (6)
139,293.44$
(866,179.86)$
(726,886.42)$
9
RA1 - Amount due Company or (Customer) (line 7 - line 8)
(72,511.18)$
(121,262.46)$
(193,773.64)$
RA2
Sales
Transportation
Sales
Transportation
10
RA revenues to be recovered (7)
236,508.23$
(7,185.79)$
18,106.62$
76,926.72$
324,355.78$
11
RAR Actual Revenues arising through Application of RA (8)
229,215.69$
(8,413.95)$
16,726.72$
71,530.78$
309,059.24$
12
Amount to be Recovered (Refunded) through RA2 (line 10 - line 11)
7,292.54$
1,228.16$
1,379.90$
5,395.94$
15,296.54$
13
Factor O (9)
-$
-$
-$
-$
-$
Sales and Transportation
Sales and Transportation
14
Total RA1 + RA2 + Factor O to be recovered/(refunded) (lines 9 + line 12 + line 13) (10)
(63,990.48)$
(114,486.62)$
(178,477.10)$
15
Interest Rate (11)
0.50%
0.50%
16
Interest Amount (line 14 x line 15)
(319.95)$
(572.43)$
(892.38)$
17
Total to be recovered including Interest (line 14 + line 16)
(64,310.43)$
(115,059.05)$
(179,369.48)$
18
Factor T - estimated therms April through December 2011
96,841,447
51,327,651
19
RA = (Line 17/Line 18) x 100
(0.07)
¢
(0.22)
¢
(2) See page 4, Determination of Actual Margin (AM), line 13, columns A and C.
(3) See page 4, Determination of Actual Margin (AM), line 13, columns B and D.
(4) See page 3, Determination of Rate Case Margin (RCM), line 13, columns B and D.
(5) Pursuant to the order of the Illinois Commerce Commission entered January 21, 2010 in Docket Nos. 09-0166/09-0167 (cons.).
(6) Rider VBA revenues arising from the effective component billed March 2010 through February 2011.
(7) Per 2009 Rider VBA Reconciliation Statement, filed March 29, 2010, NSG Ex. 1.1, page 2, line 17 (Docket Nos. 10-0237/10-0238 (cons.)).
(8) Rider VBA revenues arising from the RA component billed.
(9) Not applicable based on Order entered March 9, 2011, in Docket Nos. 10-0237/10-0238 (cons.).
(10) RA2 for Sales and Transportation combined since there are no longer separate adjustments for Sales and Transportation customers.
(11) Interest Rate established pursuant to order in Docket No. 10-0719 entered December 15, 2010.
(1) Per final order of the Illinois Commerce Commission entered January 21, 2010 in Docket Nos. 09-0166/09-0167 (cons.). See page 3, Determination of Rate Case Margin (RCM), line 13, columns A and C.
Service Classification No. 1
Service Classification No. 2
Dockets 11-0301/11-0302 (cons.)
Appendix A
