Docket No. 11-0721 on Rehearing
Appendix
Page 11
CWC
Line
Description
Amount
Lag (Lead)
CWC Factor
Requirement
Source
(a)
(b)
(c)
(d)
(e)
(f)
(c/365)
(b*d)
1
Revenues
937,623$
51.25
0.14041
131,652$
Appendix, Page 12, column b, line 9
Collections of Pass-through Taxes:
2
Energy Assistance/Renewable Energy
46,376
0.00
0.00000
-
Company Schedule C-18, Page 1, Column B, Lines 3 + 4
3
Gross Receipts/Municipal Utility Tax
238,383
0.00
0.00000
-
Company Schedule C-18, Page 1, Column B, Line 19
4
Illinois Excise Tax
247,941
36.04
0.09874
24,482
Company Schedule C-18, Page 1, Column B, Line 20
5
City of Chicago Infrastructure Maintenance Fee
91,819
36.04
0.09874
9,066
Company Schedule C-18, Page 1, Column B, Line 2
6
Total Receipts
1,562,142$
165,200
Lines 1 through 5
7
Base Payroll and Withholdings
233,560
(15.05)
(0.04123)
(9,630)
Appendix, Page 13, column b, line 6
8
Incentive Pay Expense
20,930
(228.50)
(0.62603)
(13,103)
ComEd Ex. 16.6, Line 10
9
Employee Benefits - Pension and OPEB
112,785
0.00
0.00000
-
Company Schedule B-8 TB, Page 1, Column B, Line 9
10
Employee Benefits - Other
49,880
(4.95)
(0.01356)
(676)
ComEd Ex. 25.1 Line 12
11
Inter-Company billings - Less Pass-throughs
91,985
(45.55)
(0.12479)
(11,479)
Appendix, Page 12, column b, line 14
12
Inter-Company billings - Pass-throughs
32,391
(45.55)
(0.12479)
(4,042)
Appendix, Page 12, column b, line 15
13
Property Leases
29,778
(6.33)
(0.01734)
(516)
Company Schedule B-8 TB, Page 1, Column B, Line 13
14
Other Operations and Maintenance Expenses
300,264
(66.82)
(0.18307)
(54,969)
Appendix, Page 12, column b, line 25
15
Property/Real Estate Tax
15,153
(339.12)
(0.92910)
(14,079)
Company Schedule C-18, Page 1, Column C, Line 5
16
FICA Tax
22,891
(15.05)
(0.04123)
(944)
Company Schedule C-18, Page 2, Column D, Line 9
17
Federal Unemployment Tax
200
(75.63)
(0.20721)
(41)
Company Schedule C-18, Page 2, Column D, Line 8
18
State Unemployment Tax
418
(75.63)
(0.20721)
(87)
Company Schedule C-18, Page 2, Column D, Line 10
19
Electricity Distribution Tax
66,890
(30.13)
(0.08255)
(5,522)
Company Schedule C-18, Page 2, Column D, Line 5
20
State Franchise Tax
1,582
(190.67)
(0.52238)
(826)
Company Schedule C-18, Page 1, Column C, Line 11
21
401K Match
2,654
(241.50)
(0.66164)
(1,756)
ComEd Ex. 25.1 Line 13
22
State Public Utility Fund Tax
3,869
(37.67)
(0.10321)
(399)
Company Schedule C-18, Page 1, Column C, Line 7
23
Illinois Sales and Use Tax
561
(2.66)
(0.00729)
(4)
Company Schedule C-18, Page 1, Column C, Line 9
24
Chicago Sales and Use Tax
21
(37.46)
(0.10263)
(2)
Company Schedule C-18, Page 1, Column C, Line 10
25
Interest Expense
217,930
(91.13)
(0.24967)
(54,411)
Appendix, Page 9, column b, line 3
26
State Income Tax
(35,195)
(37.88)
(0.10378)
3,653
Appendix, Page 1, column i, line 19
27
Federal Income Tax
(221,979)
(37.88)
(0.10378)
23,037
Appendix, Page 1, column i, line 20
Payments of Pass-through Taxes
28
Energy Assistance/Renewable Energy
46,376
(40.69)
(0.11148)
(5,170)
Company Schedule C-18, Page 1, Column B, Lines 3 + 4
29
Gross Receipts/Municipal Utility Tax
238,383
(44.22)
(0.12115)
(28,880)
Company Schedule C-18, Page 1, Column B, Line 19
30
Illinois Excise Tax
247,941
(4.12)
(0.01129)
(2,799)
Company Schedule C-18, Page 1, Column B, Line 20
31
City of Chicago Infrastructure Maintenance Fee
91,819
(43.46)
(0.11907)
(10,933)
Company Schedule C-18, Page 1, Column B, Line 2
32
Total Outlays
1,571,087$
(193,578)$
Sum of Lines 7 through 31
33
Accounts Payable Related to CWIP
-
0.00
0.00000
-
Per Order
34
Cash Working Capital per Order
(28,378)$
Line 6 plus line 32 plus line 33
35
Cash Working Capital per Company
39,805
ComEd Ex. 16.6 Line 39, col. (F)
36
Difference -- Adjustment per Order
(68,183)$
Line 34 minus Line 35
Note:
Lag (Lead) is from ComEd Ex 16.6, Column C except as follows:
Lines 2 - 5: Per Order
Lines 11 and 12: Per Order
Commonwealth Edison Company
Cash Working Capital Adjustment
For the Year Ending December 31, 2010
(In Thousands)
