Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

COMMONWEALTH OF KENTUCKY, Lecture notes of Accounting

Oracle iProcurement Lic-LGE17. AGENT-LGE17 ... Manchester South L TC ... t 717.763.7211 x2283 If 717.763.45901 Cl"uttci-@ofnct.cmn.

Typology: Lecture notes

2021/2022

Uploaded on 09/27/2022

astur
astur 🇬🇧

4.3

(7)

227 documents

1 / 527

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Case No. 2018-00295
Attachment 1 to Response to US DOD-1 Question No. 7
Page 419 of 1455
Garrett
LOUISVILLE
GAS
&
ELECTRIC
COMPANY
CWIP
SPEND
-
YTD
-
REGULATORY
ACCOUNTING
DECEMBER
201
7
Project
Number
Project
Description
155990
MC
Trucks
2017
155991
MC
Breen
Probe
155992
··
--·-•·--••------·---•---
MC
PPTR
Optimization
System
155993
MC
Alignment
Machine
201
7
155994
···-----··------------
MC
Airflow
Testing
Device
156010
MC
LD2
Limestone
Belt
2017
156014LGE
TC2
SDRS
SUMP
PUMP-
156024
Press
Kit
Tool-LGE
156025
SPIR
Middletown-Buckner
156026
Brown
Hotel
Vault
156027
ST
L-O
BLADES
LGE
--~-~-;-~-!-~------
~g1
Ei~~eF~~~i>
Bi~l~i;~
~~~~ACE
-----
-
_,._.,_,_~~'-'-~-
_1_;;5_6_0.c_52_L_G.:__E
____
LGE
CENTER
FURNITURE
LGE
156055
MC
LA
Conveyor
Belt
2017
156056
Wire
Turret
Trailer
---=--=--=-...:....=.------·-
--·-
----·----
156060
GS
GenEng
Electrical
Test
Set
156077
ESC
QUIET
ROOM
-
2017
156078
MC
1 B
HSWP
Motor
2017
156098--
__
-_-
__________
Trans
Subs
Test
Equip
LG&E
156108
CCCW
Motor
Rewind
156119
·
Center
Property
Purchase
156120LGE
TC
TURBINE
OIL
CONDITION
UNIT-
156130
- ·
Sullair
Air
Compressor
156131
------····----··-····-··------Blue
Lick
Control
House
Roof
156134
MC
1 & 2
Inst.
Air
Tank
2017
·:f56136
·
SO
Exit
Circuit
Duct
156140
--
-------------------·
TC
VEHICLES
2017
156143
TC1MDBFPVOITHOH
156146LGE
TC
AMMONIA
LINE
BARRICADE-
156148LGE.
--~------TC2
COAL
FLOW
ANALYZE
PHll-
156150LGE
TC
OIL
STORAGE
BUILDING-
156170
.
--·
PCA
Stewart
69kV
C&P
lnsul
156172
-·-----------
--Overhead
Doors
-AOC
.
---·----~-····-~-"
~
156174
SECURITY
ID
PRINTER
-
LGE
•~~-••
•~•w-'~~
156181
____________
PR13
H2
Purity
Meter
156187
MC
Vibration
Analyzer
201
7
156189
UTILITY
VEHICLE
-
SSC
2017
--.-~-
··-,·-···-~------
156195
POR-Mud
Lane
(2)
69kV
PT
---------------------
156200
Burden/Ratio
Test
Set
Aub
2017
156205
156259
156261
156305
156307
156329
158LGE15
158LGE16
159LGE16
160001
-
BOC
BO
Breakroom
Reno
GS
COM
CIPV6
CR11
Windstream
OPGW
Repl
3851
MC
Shop
Hoist
2017
•w••·
···-
..
····~-.,-~
.
MC
Vehicle
Maint
Truck
2017
MC
Passenger
Van
2017
-
FIM
Replacement-LGE15
Tech
Training
Dashboards-LGE16
--------------·--·-
___
-_
Cascade
lmpl
Gen
Relays-LGE16
TC1
TURBINE
PPR
ON
IP
DIAPH
l:\Depreciation
Study\2017
Study\Files
Sent
to
Spanos\Files
sent
03152018\
LGE_
Plant
report_December
2017.xlsx
CWIP
Spend
by
Project
P3B
(Reg)
CWIPSpend
39525.92
48264
48865.6
30282.31
41381.73
12395.04
14666.45
22330
20416.08
229
631341.97
14838.85
329956.85
29952.12
10402.53
67009.82
22077.56
20988.69
52069.57
17709.25
18778.38
212044.67
44033.18
27008.44
15875.09
7951.67
98891.19
175362.8
101011.95
24288.52
53990.68
5823.15
755.89
5687.96
5458.65
12123.79
28342.61
8649.6
488.75
8593.61
1928.1
23449.8
27005.59
28000
18426.54
27639
47488.89
73704.48
111679.72
76906.8
3B.17
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49
pf4a
pf4b
pf4c
pf4d
pf4e
pf4f
pf50
pf51
pf52
pf53
pf54
pf55
pf56
pf57
pf58
pf59
pf5a
pf5b
pf5c
pf5d
pf5e
pf5f
pf60
pf61
pf62
pf63
pf64

Partial preview of the text

Download COMMONWEALTH OF KENTUCKY and more Lecture notes Accounting in PDF only on Docsity!

Attachment 1 to Response to US DOD-1 Question No. 7

Page 419 of 1455

Garrett

LOUISVILLE GAS & ELECTRIC COMPANY

CWIP SPEND - YTD - REGULATORY ACCOUNTING

DECEMBER 201 7

Project Number Project Description 155990 MC Trucks 2017 155991 MC Breen Probe 155992 ·· --·-•·--••------·---•--- MC PPTR Optimization System 155993 MC Alignment Machine 201 7 155994 ···-----··------------ MC Airflow Testing Device 156010 MC LD2 Limestone Belt 2017 156014LGE TC2 SDRS SUMP PUMP- 156024 Press Kit Tool-LGE 156025 SPIR Middletown-Buckner 156026 Brown Hotel Vault 156027 ST L-O BLADES LGE

--~-~-;-~-!-~------ ~g1 Ei~~eF~~~i> Bi~l~i;~ ~~~~ACE

------ ,..,,~~'-'-~-

1;;5_6_0.c_52_L_G.:__E____ LGE CENTER FURNITURE LGE 156055 MC LA Conveyor Belt 2017

---=--=--=-...:....=.------·-^156056 --·- ----·----Wire^ Turret^ Trailer

156060 GS GenEng Electrical Test Set 156077 ESC QUIET ROOM - 2017 156078 MC 1 B HSWP Motor 2017

156098--_--__________ Trans Subs Test Equip LG&E

156108 CCCW Motor Rewind 156119 · Center Property Purchase 156120LGE TC TURBINE OIL CONDITION UNIT- 156130 - · Sullair Air Compressor 156131 ------····----··-····-··------Blue Lick Control House Roof 156134 MC 1 & 2 Inst. Air Tank 2017 ·:f56136 · SO Exit Circuit Duct 156140 -- -------------------· TC VEHICLES 2017 156143 TC1MDBFPVOITHOH 156146LGE TC AMMONIA LINE BARRICADE- 156148LGE. --~------TC2 COAL FLOW ANALYZE PHll- 156150LGE TC OIL STORAGE BUILDING- 156170. --· PCA Stewart 69kV C&P lnsul 156172 -·----------- --Overhead Doors -AOC

. ---·----~-····-~-" ~ (^156174) • • •-•• •~•w-' SECURITY ID PRINTER - LGE 156181 ____________ PR13 H2 Purity Meter 156187 MC Vibration Analyzer 201 7

156189 --.-~- ··-,·-···-~------UTILITY VEHICLE - SSC 2017

---------------------^156195 POR-Mud^ Lane^ (2)^ 69kV^ PT

156200 Burden/Ratio Test Set Aub 2017 156205 156259 156261 156305 156307 156329 158LGE 158LGE 159LGE 160001 -

BOC BO Breakroom Reno GS COM CIPV6 CR Windstream OPGW Repl 3851 MC Shop Hoist 2017 •w••· ···- .. ····~-.,-~. MC Vehicle Maint Truck 2017 MC Passenger Van 2017

  • FIM Replacement-LGE Tech Training Dashboards-LGE --------------·--·-__- Cascade lmpl Gen Relays-LGE TC1 TURBINE PPR ON IP DIAPH

l:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx CWIP Spend by Project P3B (Reg)

CWIPSpend

48264

22330

229

28000

27639

3B.

Attachment 1 to Response to US DOD-1 Question No. 7

Page 420 of 1455

Garrett

Project Number 16_0,0()_ 160003 ·151001CGE. 164LGE 165LGE 166LGE 178LGE 202_L_GE1~ 203LGE 2041.GE 262LGEi4. - 400LGE 406000019 - 406000020 419000003 447000004 448000002 448000003 448000006 448000009 448000010 risiGEis 719LGE 720LGE 721LGE 724LGE 7251,<3_E 726LGE 729LGE i:ioiGEiii 734L<iE 7_3~_LGE 737LGE 740LGE 741LGE 742LGE 743LGE 744LGE- 74IL_Gl: 750LGE 753LGE AMR. CCAPAC CCAPR CCAPR CCGUPG45i ccocf.if ccr1fllip44- CCS ttso42i

LOUISVILLE GAS & ELECTRIC COMPANY CWIP SPEND - YTD - REGULATORY ACCOUNTING DECEMBER 2017 Project Description TC1 TURBINE REPL HP INLET SR TC1 TURBINE RESEAL HP-IP & LPS

. TC2 TURBINE PREP COUPLINGS Plant Mobile-Trimble-LGE . Non-SCADA Load Data-LGE Tower Replace-LGE

  • Upgrade Quest Server-LGE Trans OATT Billing Tool-LGE PS 9.2 Upgrade-LGE SAP CRM/ECC Upgr-LGE Redact-It lmplement-LGE OTN Core Rings Y2/2 LOU-LGE NB AIKEN RD GAS MAIN NB GRADE LN GAS EXTENSION GAS REGULATOR EXCHANGES Muldraugh Station Piping Repl Hodgenville Distribution Upg Center Distribution Upgrade Mag Replace Orig CAT Generator Canmer Distribution Upgrade Buffalo Hodgenville Distr Upg CTS Upload Automation-LGE Pl Alarm Mgmt-LGE Mobile Dispatch Map-LGE Superna Eyeglass Lic-LGE Pl Lie for Access Perm-LGE Veg Mgmt ROW Layer Dev-LGE DACS Software Upgrade-LGE Solar Share Program-LGE ABB Post lmpl Enhance-LGE Gust Serv Training Tools-LGE Brown/Dix Campus Sonet-LGE Bl SQL Upgrade-LGE Field Smart View Enhance-LGE Bluecoat Proxy Security-LGE Insight CM Expansion-LGE PMO Plotters-LGE Reader Boards-LGE TRAC Enhancements-LGE AMS SAP Hardware-LGE GPS Gate Licenses-LGE ALDYL-A MAIN REPLACEMENT GAS REG CAPACITY PRO Capital CAP/REG/RECL - 003400 Gas Regulators Blanket UPGR FACIL CG STATION 2017 RET/REPL CONTR CG STA 2017 CP IMPRESSED CUR SYS IMPROVE REPL EXIST GUST SRV W RISER REPL EXIST CS WITH RISER-MUL

!:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx CWIP Spend by Project P3B (Reg)

CWIP Spend

-405.

-1859.

-0.

-434.

0

-1065,

-2114.

-12033.

48400 -7168.

-3866.

3B.

Attachment 1 to Response to US DOD-1 Question No. 7

Page 422 of 1455

Garrett

Project Number CTPD CVLT CXFRM CXFRM34o DLSMR FACOOOOOL GASRSR IT0001L - IT0002L ifo-oo4i IT0006L IT0007L ITOOOSL ITOOOSLGE rrolio§L-- IToo10L TfDD12L-- IT0013L 1to01sL Itooi1i ffoofai -ITD019L Itoo20[ - itoo21i: IT002si. IT0027L ITQ030l_ IT0033L Ifoo:isi:. 1foo41iCG IT0042L ifoo«L itoo4si itoo<iaL IT005fL IT005:ZL IT0054L IT0055L IT0057L itoosiL 1toos2i iioos4L Ifoossi IT0066L IT0067L IT0067LGE Iflilissi_ IT0069L itoo7ilL iT0071L

LOUISVILLE GAS & ELECTRIC COMPANY CWIP SPEND - YTD - REGULATORY ACCOUNTING DECEMBER 2017 Project Description Capital Thrd Party - 004190 Capital Network Vlts - 003430 LGE Line Transformers NB Transformers - 003400 DWNTWN LRG SCALE MAIN SIMP NEW PARKING LGE GAS SERVICE RISER REPL & CSO

    • ABB Upgrade-LGE -- Access Switch Rotation-LGE Analog Sunset-LGE Aspect Workfor Sched App-LGE Backup Cap Exp-LGE --- Bulk Power & Env Sys-LGE Bulk Power Env Sys-LGE Direct Cabling for Server Conn-LGE
  • Call Recording Minor Upg-LGE
      • Centrify Licensing-LGE
  • CERUS IV-LGE CIP Compliance Tools Yr7-LGE Commun Solar lmplem-LGE17- CIP Compliance lnfr Yr7-LGE Computer HW for LOB's-LGE Core Network lnfrast-LGE Corp Web Redesign Upgr-LGE Data Protection-LGE17- Domain Cntrls ICCP-LGE EMS CIP-LGE Enterprise Strg Sys Refr-LGE FieldNet SoftwareUpgr-LGE Gas Survey Map Website-LGE GIS Bl Reporting-LGE Impedance App-LGE Intrusion Prevention-LGE17- IT Security CIP Lab Enhn-LGE Louisville Elect Upgrds-LGE Louisville Racks/Furn-LGE Microsoft EA-LGE Microsoft Lie True-up-LGE Mob 5500 Netscale HW Ref-LGE Mobile Radio-LGE Monitor Replacement-LGE Multi-Fune Devices Refr-LGE NAS Capacity Expansion-LGE NEC MW Rad Encrypt Card-LGE Network Access Dev-LGE Network Access DevLGE17 Direc Network Ace Gatwy-LGE Network Management-LGE Network Mgmt Tech Ref-LGE Network Test Equip-LGE l:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
    LGE_ Plant report_December 2017.xlsx CWIP Spend by Project P3B (Reg)

CWIP Spend

8022

-1.09139E-

3B.

Garrett

LOUISVILLE GAS & ELECTRIC COMPANY

!:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx CWIP Spend by Project P3B (Reg)

Attachment 1 to Response to US DOD-1 Question No. 7

Page 425 of 1455

Garrett

Project Number LINS- LINS- LOTFAIL LOTFAIL LOTH- LOTH- L-OTHER L-OTHER LOTPR LRELAY- LRELAY- LREL-FL LREL-FL LREL-FL LRTU- LSMR LTFFAIL PMR RRCS419G RRCS SU- SU- SU- SU- SU- SU- SU- SU- SU- SU- TLR TMPPENBLN TMPPENPRS TMPPROP TMPPRSPIC

LOUISVILLE GAS & ELECTRIC COMPANY CWIP SPEND - YTD - REGULATORY ACCOUNTING DECEMBER 2017 Project Description Priority Repl lnsltrs LGE 2016 Priority Repl lnsltrs LGE 2017 LGE-OtherFail- LGE-OtherFail- Priority Repl Other LGE 2016 Priority Repl Other LGE 2017 LGE-Other- LGE-Other- LG&E Other Prat Blanket 2017 Relay Replacements-LG&E- Relay Replacements-LG&E- LG&E Relay Failures- LG&E Relay Failures- LG&E Relay Failures- LGE RTU Replacements- Large Scale Main Replacements LGE-Xfrmr Fail- Priority Main Replacement REP CO GAS SERV 419 Serv Line Repl-Muldraugh PBR-Hurstbrn 1 138kV BKR Rpl PBR-Watterson (3) 138kV BKRRpl PBR-Aiken(1) 69kV BKR Rpl PBR-Kenwood(3) 69kV BKR PRL Y-Algonquin-Magzn (6646) PRTU CENTERFIELD PBR-Ashbottom (4) 138kV BKR PIN-Breckenridge 69KV+ PIN-Ethel 69kV+ TEP-Skylight 69kV Capacitor TRANSMISSION LINE REPLACE TMP PENILE-BLANTON LN TMP PENILE-PRESTON TMP PROPERTY PENILE-BLANTON TMP PRESTON-PICCADILLY

!:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx CWIP Spend by Project P3B (Reg)

CWIP Spend -1062.

-1531. -20463.

-465399.

-4.84306E-

470,334,680.

Attachment 1 to Response to US DOD-1 Question No. 7

Page 426 of 1455

Garrett

A YID I, A< YT 0 D A IS Nout,,ilt,'- Loc"'."o'"""'- A<"'.''""'- OO Go• - ~lpolmo T<>=~o,t.,<,oa- AoolV>"O'>'- RV fo,u., - U.,Oi,tD, '"' B•l•aco

=

:::::lli..fu:ll ====== ==::::m::filE ====== ==== : 33''7438 .:..._ ====

Attachment 1 to Response to US DOD-1 Question No. 7

Page 428 of 1455

Garrett

PlantinS,r,io• Coraa,ona,naral C381il.10-L,nd C381i120-L,nd R1i;ihtt C31i10.10-Struot,nd C31i10.20-Struo,nd (^) lmp-Tr,naportllt10lmp-0,nOfloH CJlilOJD-3truct,ndlmp-StorH CJ1i10.'I0-3truct,nd lmp-6hopa g~:~·:6~:c~ ;:~nli.- M,cro,m• C31i1120-0 C31i11JO-Comput,rEquipment • o,Equipm,nt C39131-P,raon,IComput•r• C391 J3Comput,rEquipECR200e C31i11 CJ1i12 '1D-8,cuntyEqu1pm,nloo-c,r, ,nd L,ghtTrucka C31i1210-H C39220-Tr,naEquip-Trailer,..,..yTruoka,nd0th•r CJlilJ.00-8tor C31il<IOO-Toolt,Shop,G,.--.i;i,Equip.. Equ1pm,nt

ICJlile10-Power0pEquip-LgM,ohin•ry^ C31i11500-L,bor,toryEqu1pm,nt CJlill5.20-Pow,r0pEqu,p-Olh•r C31i1700-M,crow•~•. Fib•r.Oth•r CJ97.10-CommEqR,dioa,T•l•phone CJlill500-~i•c•ll•n•ouaEqu1pm,nt CJlillil.115-ARO Coat Common (LIB)

6i~~ :~;::;:1I:~nd Con ..nta

6:~~~ ~:~.~~•nl-6ohar• C303.20-L,wl1br•ry

LOUISVILLE GAS & ELECTRIC COMPANY rOT,\J, PLANT IN SlcRVICE (^) DECEMBER2017-COMMON- REGUtATORY ACCOUNTING

1515,"1M3230 '112,1150. lil,lilJ!l,OJ1.Je 707,'1152.0' 1.101,e215.'llil 15,lilM,M10' 115,919,012.1515^ lilM,M151ile 15,0153,0J'l. lil115,122.<1e 20,7157. 211,1571532 <11,e<12.151il 1,'171.0715.02 3,lillil3,1i13271il J215,'1Jlil.1J 1'1,1" 115,308,15MOe 1J,152J,2115.

46,321,727.9745,350,

M1,72200 331,110. 'l,1571il,'1152Jl5 1,M7,15'

3,159,299.80737,

9,409,045.

(870,80571) (69,40329) (248,851.16)(1,91702) (4,080,31930)(1,005,087.57)

(20,75736) (13,783.47)

(2,103,72553)(6,626.40)

(8,008,540,69) (16,429,817.50)

AdjustmentsTransfers/

I·\Deprec,ationStudy\2017Study\FilesSenttoSpanos\F,lessent03152018\ LGE_ Plant report_December 2017,xlsx Tot Com PIS_COST SPLIT-P6 (Reg)

(69,40329) 1512,157015'1^ (1,lil17.02) 151illil,1eJOl5 e152,<115<1eo

(20,75736)

1,055,574.27731,

157,1530,lil<llil.eO '112, lil,8M,e2t07 707,'182.0'I 1,0lillil,7015.'17 7,151i1J,'101M 11il,151!5,17159J^ 1,J17,71ill

211,157!5J2 ee,e2Je 1,'171,071502 '1,1315,7151! 1521.15elil.11il 1'1,1'17.

i!:~~::~:~ ~~

47,722,233.0045,350,035,

Attachment 1 to Response to US DOD-1 Question No. 7

Page 429 of 1455

Garrett

Co.,r.onCllener CJeQ.10-L • nd • I C3eQ.20-L • ndR1ght C3Q0.10-8truct C3Q020-8tmc1ndlmp-Tren1port1bo • ndlrnp-Gen01'Pk•• C3i030-8truct,ndlmp-Storu C3Q040-8tructendlmp-Shop g~~~:~6:~~~~ ~:~nl 1 ~~ 1 - M1orow.•~• C3Q1.20-0mce C3Q1.30-Comput Equ1prn• rEqu1pment • nt C3Q1 C3Q1 31-P1r1on1ICornput40-8eountyEqu1pment• r C3Q2.10-Tr C3Q2.20-Tr•• n1n1Equ1p-Tr Equ1p-C • (^) • (^111) 1l1r1 • nd Truo~• C3Q300-8tor11Equ,pm C3Q400-Tool1,Shop,G1r1g • nt• Equ1p

lcJ.ie.10-PowerOpEqu1p-LgM^ CJQO.OO-L^ •^ bor^ •^ toryEquipm1nt• ch1nery c3.ie20-Pow1rOpEquip-Oth C3Q7.00-M1crow. • ~•.Fib1r.Oth1r • r C3Q7.10-CommEqR1d101,T1l1phone C3.ie.OO-M11cell • n1ou1Equ1pm1nt CJgg 115-.-.RO Coit Common (L/8) g~~~-~6:~;~:~~~=:nd Con11nt 6~6~·~6:~~~ ~~~~-•nt-Boh• rl C30320-L• wl1br1ry

TOTAL Pl.ANT^ LOlJISVIU.E IN SERVICE-^ GAS COMMON^ &^ EUCCTRIC - REGULATORY^ COMPANY ACCOUNTING DECEMBER

2rio, 1 •2.eJ1.eo•e•. M40,1ee.10 24,778. 2e.i,a.io.ee

259,604,

(507,184.67} 16, (1e4,e10.eeJ (134,1.ie.2!5} (3,03Q,Q1024) {17,4M.43} (20Q,OQO.M}

(8,302.64)

(2,163,542.51}(398,51415)

11.352,680051,536,157.

29,424,971.

Adjustments

(16,429,817.50) ========

I.\Deprec1at1onStudy\2017Study\FilesSenttoSpanos\F11essent03152018\ LGE_ Plant report_December 2017 xlsx Tot Com PIS_COST SPLIT-P6 (Reg)

(507,18467} 16,390. (1t14,010M) (134,1Q0.2(1) {3,03Q,Q10.24) {17,4e8.•3} (20Q,8QO.M}

(8,30264}

{2,163,542.51}(398,514.15)

11.352,680051,536,157.

12,995,

16, Q(l,073.Q1 e, 200,24g4e 1,2e.i.ee

441,4552732,099.

272,599.441.

Garrett

101 Plant in Service Total 101 Plant in Service - Common - KY LOUISVILLE GAS & ELECTRIC COMPANY Beginning Retirements (870,805.71) (69,403.29) (1,917.02) (248,851.16) (4,080,319.30) (1,005,087.57) (20,757.36) (13,783.47) (2,103,725.53) (6,626.40) (8,008,540.69) (16,429,817.50) (16,429,817.50) Transfers/ Adjustments l:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx KY_Cost Plant Acct-Comm-P8(Reg) (69,403.29) Ending

 - Attachment 1 to Response to US DOD-1 Question No. - Page 421 of - DECEMBER CWIP SPEND-YTD - REGULATORY ACCOUNTING - CCSO4485 REPL EXIST CS & RISER- Project Number Project Description - _C_E_M_T_R_1_3_4____ LGE Electric Meters - CEBREG451 PURCHASE REGULATORS EXIST GUST - CGME406 NB Gas Main Ext - --------- CFTCUS450 FT CUSTOMER CONVERSIONS - --------- CGMTR134 LGE Gas Meters - - CHPSRV451 COMM HIGH PRES GAS SRV UPGR ---------- - ---,Cc-cL---,M,.,,....,.0..,..3..,..0..,..1..,..17----LGE MAJOR STORM CAPITAL - CLM042817 LGE MAJOR STORM CAPITAL 
  • -C,...,N...,..B~C..,,,D-,3,-4-0---,0,----- NB Comm OH - - CNBCD340U NB Comm UG - - CNBGS419 NB Gas Services - _C_N_B_C~S-4_4_8_5_____ INST GUST SRV - MAGNOLIA - CNBGS421 NB Gas Services - - CNBRD3400.. NB Res id OH -
  • --------- CNBRD340 U NB Resid UG - - CNBRD341 U NB Res id UG - - CNBREG451 PURCH REGULATORS - - CNBSV340O NB Elect Serv OH - - CNBSV340U NB Elect Serv UG - - CNBVL T343 NB Network Vaults - - CPBWK340 El Public Works - - CPBWK406G Gas Public Works -
  • _C_R_C_S_T_3_4_0______ Cust Requested - CPLUG4475 PLUG GAS STOR WELLS COR CASE - CRCST406G Gust Requested -
  • ·c-RDCBL340 Repl Defective Cable - - CRDD340O Capital Rep Def OH - - CRDD340U Capital Rep Def UG - - CREGFC451'. ·------~---•----GAS REG FAC UPGRADE BLKT - CRE LD340 Capital Reliability - - CRPOLE340 Pole Repair/Replace - CROTAR451··-··········· UPRG OBSOL ROTARY METERS - CRSTL T332 Repair Street Lights - - CSTL T332 NB Street Lights - CSTATN448 MAGNOLIA STATION BLKT
    • CSTRM323 Cap Minor Storms - CSTOR448 MAG STOR FIELD/TRANS BLKT
    • CSYSEN34o··-- Sys Enh -
    • CSYSEN406 ····-···-··-..·· Sys Enh -
    • CTBRD340O- Cap Trouble Orders OH -
    • CTBRD340U Cap Trouble Orders UG -
    • CTBRD419 Cap Trbl Orders Gas -
    • CTPD340 Capital Thrd Party - - 80055. CWIPSpend - 206484. - 280531. - 25775. - 432957. - 20432. - 2053782. - 5169640. - 247047. - 178738. - 66877. - 2380065. - 5949178. - 4664427. - 64598. - 8697. - 1843896. - 28291. - 1254850. - 25360. - 5963652. - 138937. - 621400. - 1665280. - 366563. - 524417. - 917189. - -11179. - 107766. - 1438665. - 3238996. - 621328. - 1041227. - 319738. - 60682. - 4247405. - 2293722. - 605356. - 432718. - 1541765. - 953960. - 630613. - 796270. - 2089200. - 795630. - 3483151. - 1125709. - 48798. - 987469. - 3B. - Attachment 1 to Response to US DOD-1 Question No. - Page 423 of - DECEMBER CWIP SPEND - YTD - REGULATORY ACCOUNTING - IT0075L Open Text Transmission-LGE17- Project Number Project Description - IT0077L _ _______ Oracle NMS Upgrade-LGE - IT0078L OTN DWDM Repl (Encrypt)-LGE - IT0079L ~-• ~c•~~•---•--•---~•.,~•~-Outside Cable Plant-LGE - ITOOB3L Primavera to PowerPlan-LGE
      • -IT0086L --.-~--,--..---,-~--· Repl Oper Workstations-LGE - IT0087L Repl RD Us at BOC-LGE - IT0089L Rev Collections lmpl-LGE1 - IT0090L Rplce EMS Workstations-LGE - IT0092L Sec Infra Enhance-LGE - IT0093L Server Capacity Exp-LGE
      • -c=,,,....,--,---,-,----- IT0094L --------- - Server Hardware Refr-LGE - IT0096L _______ LogRhythm (CIP)-LGE - IT0097L Log Rhythm (Corp )-LGE
        • IT009BL Simpsonville Elect Upgr-LGE
        • IT0099L ____________ Simpsonville Furn/Racks-LGE
        • IT0100L ____________ Site Security lmprove-LGE
        • IT0101L Smallworld GIS Upgr-LGE17-
        • IT0103L Sys Lab software replace-LGE
        • IT0104L Sys Mgmt-SCOM-LGE
        • IT0105L Tech Refesh desk/lap-LGE
        • IT010BL ·----------·TOA Phase 4-LGE
        • IT011 OL Trans Cascade-Oracle-LGE
    • n-0111(·· ··::.~::·.~-~~:Trans Vegetation Mgt-LGE17- - IT0112L Trans Map Land Use-LGE1
      • IT0114L TRMS Upgrade-LGE
      • IT0115L TRODS-LGE
      • IT011BL. UC&C/CUCM Upgrades-LGE
      • IT0119L Upgrade Vmware lnfra-LGE
      • IT0120L. Upgrade EMS HW-LGE
      • IT0121 L Phone Expansion-LGE
      • IT0122L ________________ Windows 10 Upgrade-LGE
      • IT0123L -------~ .,,·-------,,-~-~ - Wireless Buildout-LGE
      • IT0128L App Security Enhance-LGE
      • IT0131L SAP Regression Test Auto-LGE
      • IT0132L EMS Channel Cap Expan-LGE
      • IT0133L CA API Mgmt Gateways-LGE
      • IT0134L CTS 5 Min Enhance Proj-LGE
      • IT0135L ..-----·--- Strategic Sourcing-LGE
      • IT0136L --------------~ Electric Modeling Softw-LGE
      • IT0137L nMkt MISO Glob Prm UPgd-LGE
      • IT013BL ____ ,.___. _______ HP Apl Lifcyc Mgmt Upgrd-LGE
      • IT0139L Main Schedulin Tool-LGE
      • IT0142L - -------------·-Oracle NMS Enhance-LGE
    • IT0143L Aspect Perf Mgmt Module-LGE
      • IT0144L- Avaya Call Back Lic-LGE
      • IT0145L ---------~ Monitor Proj Mgmt Packs-LGE
      • IT0146L ---•~ , __ ,, -- -•--<--•-·RecoverPoint Refresh-LGE
    • IT0147L __________ CoreLogic Parcel GIS-LGE
  • !TO~~~l: __________ Antivirus Replacement-LGE - 30056. CWIP Spend - 529462. - 164543. - 31316. - 37529. - 66572. - 85132. - 9670. - 66693. - 55004. - 19173. - 203578. - 50199. - 32980. - 7142. - 11568. - 14173. - 154864. - 24925. - 1195595. - 62496. - 80825. - 26423. - 112371. - 79307. - 162507. - 44629. - 219274. - 201134. - 106860. - 103661. - 104783. - 12612. - 37415. - 144420. - 126823. - 60995. - 392540. - 17213. - 54902. - 42070. - 377891. - 61287. - 9112. - 20822. - 61082. - 62243. - 3B. - Attachment 1 to Response to US DOD-1 Question No. - Page 431 of
    • C389.10-Land - Common General
      • C389.20-Land Rights -
      • C390.10-Struct and Imp-Gen Offices -
      • C390.20-Struc and lmp-Transportatio -
      • C390.30-Struct and Imp - Stores -
      • C390.40-Struct and Imp - Shops -
      • C390.60-Struct and Imp - Microwave -
      • C391.10-Office Furniture -
      • C391.20-Office Equipment -
      • C391.30-Computer Equipment -
      • C391.31-Personal Computers -
      • C391.33-Computer Equip ECR 2006 -
      • C391 .40-Security Equipment -
      • C392.00-Cars and Light Trucks -
      • C392.10-Heavy Trucks and Other -
      • C392.20-Trans Equip-Trailers -
      • C393.00-Stores Equipment -
      • C394.00-Tools. Shop, Garage Equip -
      • C395.00-Laboratory Equipment -
  • IC396.10-PowerOp Equip-Lg Machinery- - C396.20-Power Op Equip - Other - - C397.00- Microwave, Fiber, Other - - C397.10-Comm Eq Radios, Telephone - - C398.00-Miscellaneous Equipment - - C399.15-ARO Cost Common (LIB) - - C301.00-Organization - - C302.00-Franchises and Consents - - C303.00-Misc lntang Plant-Software - - C303.10-CCS Software - - C303.20-Law Library - - DECEMBER KENTUCKY - PLANT IN SERVICE - COMMON -REGULATORY ACCOUNTING - 1,564,394. Balance - 65,813,532. - 412,150. - 9,935,031. - 707,482. - 1,101,625. - 6,980,531. - 986,685. - 18,919,012. - 5,053,034. - 915,122. - 20,757. - 211,576. - 41,842. - 1,471,075. - 3,993,932. - 328,439. - 14,147. - 18,234,471. - 13,523,215. - 83,782. - 46,321,727. - 45,350,035. - 241,983,605. - 241,983,605. - 2,588,223. Additions - 861,722. - 331,110. - 4,679,482. - 1,687,542. - 38,564. - 141,819. - 199,130. - 3,159,299. - 737,657. - 9,409,045. - 23,833,596. - 23,833,596. - 1,717,417. Net Additions - 612,870. (1,917.02) - 331,110. - 599,163. - 682,454. - 24,780. (20,757.36) - 141,819. - 199,130. - 1,055,574. - 731,030. - 1,400,505. - 7,403,778. - 7,403,778. - 1,564,394. Balance - 67,530,949. - 412,150. - 9,865,628. - 707,482. - 1,099,708. - 7,593,401. - 1,317,796. - 19,518,175. - 5,735,489. - 915,122. - 211,576. - 66,623. - 1,471,075. - 4,135,751. - 527,569. - 14,147. - 19,290,045. - 14,254,245. - 83,782. - 47,722,233. - 45,350,035. - 249,387,384. - 249,387,384. - 8.

Attachment 1 to Response to US DOD-1 Question No. 7

Page 432 of 1455

Garrett

~~'n,c;;~~~~:~;l Completed Not Cl1H1fled c3go.10-Struct1ndlmp-OenOl'lloH-101'1 C3g0.20-Struc1ndlmp-Tr1n1port1tio-101' c3go_JO-Struot1ndlmp-8tore1-101' IC3EI0.•0-8trucl•nd lmp-8hop1-

g;:~:~~:~t~u 0 ~ ~:~nl 1 e- -~io••v• - 108

c3g1.20-omceEquipment-101'1 c3g1.JO-ComputerEqu1pment- c3g1 c3g140-S•ourityEquipment-100 31-Per1on1IComputer1-10l'I lc3g220-Tr1n1Equip-Tr11iler1-10l'I c3gJOO-StorHEqu1pment-101' c3g400-Tool1,Shop,01r1geEquip-101'1 C311020-Pow1rOpEqu1p-O!h1r-101' C311700-Micro,w1v1.Fib1r.oth,r-101'1 c3g7 10-Comm Eq R1dio1, T•l•phon, - 101' lc3ge.OO-~i1c,111n1ou1Equipm1nt-101' g;::~;~ ~~~:.~~•-n~osti.m• - 100

LOlllSVJLLE GAS & ELECTRIC COMPANY KlsN nJCKY- PLANT IN Sr:RVICE- DECEMBER2017 COMMON -REGUI,ATORY ACCOUNTING

2!10,-41'14.77 1<12,rm.eo 3,1'140,11'11'1.10 24,771'1. 2ag,ego.11e

2,604,99778430,614.

17,546, 259,529,886.

(507,184.67) 16,390. (11'14,1'110.80) (134,1"1'1.21'1) (3,1'131il,lil11'1.24} (17,40l'l.43) (2eg,ego.11e (8,30264) (2,163,542.51)(398,514.15)

11.3152,01'1001'1^ 1.1'13l'l,11'17. l'l.1'1"1,301. 5.591,381. 29,424,977.

AdjustmentsTransfers/

(16,429,817.50)----

I.\Deprec1ationStudy\2017Study\FrlesSenttoSpanos\F11essent03152018\ LGE_ Plant report_December 2017.xlsx KY_ Cost Plant Acct-Comm-PB(Reg)

(507,184.67)

(11'1-4,-'10l'IO) (134,11i1021'1) (3.03"·"11'12-4) (11, • 0l'l.-43) (20".l'llilO.l'll'I) (8.30264) (2,163.542.51)(398.514.15)

11,352,680.051,536.157. 5,591,381. 5,591,381. 12,995,160.

g15,073g1 1'1,441.31' 200,24g-40 1,2eg_ee

441,455.27 32,099.

11,31'12,080.01'1^ g_201,n;gg 23,137,002.1' 23,137,662. 272,525,046.

Attachment 1 to Response to US DOD-1 Question No. 7

Page 434 of 1455

Garrett

~:~:::;~~~~:~;, Completed Not Classified C39700-M1crowave,F1ber,Other-

LOUISVILLE GAS & ELECTRIC COMPANY INDIANA - PLANT IN Sl:llVICE- DECEMBER COMMON 2017 - Kl:GlJI.ATORY ACCOUNTING

AdjustmentsTransfers/

I\Deprec1at1onStudy\2017Study\F1lesSenttoSpanos\F1lessent03152018\ LGE_ Plant report_December 2017.xlsx IN_Cost Plant Acct-Com-P10(Reg)

Attachment 1 to Response to US DOD-1 Question No. 7

Page 435 of 1455

Garrett

~Beginning^ ~ ~ AdjustmentsTransfers/^ ~Total^ ~Endmg ~ No\BookValue

Attachment 1 to Response to US DOD-1 Question No. 7

Page 437 of 1455

Garrett

fOTAL Pl.A:"llLOUSVILl,E l:"l SERVICE·^ GAS £LECTRIC^ &^ ELECTRIC - REGULATORY^ COMPANY ACCOUJ'iTl~G DECEMBER

I\Deprec1at1onStudy\2017Study\F1lesSenttoSpanos\F1Iessent031520181 LGE_Planlreport_December2017.xlsx

Retirements ~Transfers/^ Net AdditionsTotal^ ~Ending

TotElecPISCostSpl1l-P12(Reg

Attachment 1 to Response to US DOD-1 Question No. 7

Page 438 of 1455

Garrett

LOUISVILLE GAS & ELECTRIC COMPANY TOTAL PLANT IN SERVICE - ELECTRIC - REGULATORY ACCOUNTING DECEMBER 2017

KENTUCKY & INDIANA

Beginning Balance 62,593,968.

!:\Depreciation Study\2017 Study\Files Sent to Spanos\Files sent 03152018
LGE_ Plant report_December 2017.xlsx

Additions Retirements (213,911.37)

Tot Elec PIS Cost Split-P12(Reg

Transfers/ Adiustments

Total Net Additions (213,911.37)

Ending Balance 62,380,057.