o Charge Codes: Charge Codes:

(1)

- Overall project deployment support and administration-11031853

- Specific device (cell relays, take-out points) installation- use work order assigned to that job

- Development of AMS Integrated Services Monitoring Systems- IT Systems

Manager/Programmers designing software configuration and interfaces, coding and testing during application development stage, installing hardware, testing of AMS systems during initial implementation and modifications that include

functional enhancements (>$100,000). o Charge Codes:

Description Work Order

AIS - Tivoli Services 49809836

AIS - NOC 49809837

- Program Management Office- VP, Project Management, Directors, Admins,

Finance, Project Scheduling, Tracking, Reporting Manager/Analysts, Process Change and Benefits Realization Director/Analysts supporting the overall progress of the program.

o Charge Codes:

- Project Lead, Governance, Support AMS Only- 11032141 - Project Lead, Governance, Support IG Only - 11033012 - Process Change and Benefits Realization AMS- 50330198 - Regulatory Operations Finance (AMS only)- 11031851

- Project Lead, Governance, Support Non- Smart Grid Projects-Cost Center 101747

- Process Change and Benefits Realization IG- 11033101

- Process Change and Benefits Realization- Cost Center 101087 (note: if employee resides in this cost center time entry should be to "regular time" and not be applied to a code"

- Pre-sweep of meter routes for deployment readiness- FSRs, Meter Readers,

Meter Lead/Technicians, Exception Analysts/Techs, Primary Metering, . o Charge Codes:

- Pre-deployment inspection of meter routes- 52645480 - Meter can/loop repairs- 52645243

- Revenue diversion investigation- 52645247 - Meter testing- 552644837

(2)

PUC Docket No. 42084 GCCC02-05 SGIG Govt Accounting Policy-Revised for reorganization Page 27 of 31

- _{AMS Diagnostics Integrated Services- Business and Technical}

Manager/Analysts developing requirements for monitoring system o Charge Codes WO 50329601

- Project Management for IG Communications Deployment- Director,

Telecommunications Technical and Project Leads/Analysts, and Union Skilled Labor supporting the initial deployment of telecommunications infrastructure to support the communications functionality of the automated grid and ADMS initial deployment.

o Charge Codes:

- Specific device (cell relays, TOPs) installation- use work order assigned to that job

ADMS Systems Development and Implementation- Oversight, Project lead, electric distribution engineering, distribution operations, RTO, GIS, and IT

Programmer Manager/Analysts designing software configuration and interfaces, coding and testing during application development stage, installing hardware, testing of AMS systems during initial implementation and modifications that include functional enhancements (>$100,000).

o Capital Charge Codes 54201829

o O&M Charge codes (defining requirements, training, etc) 11033011

- Project Management for Automated Grid deployment- Project lead,

Administrative support, Electric Distribution Engineering, Distribution Operations, DACS Support, RTO, GIS, Distribution Automation supporting the initial

deployment of field devices to support the automated grid functionality. o Charge Codes:

- Overall project deployment support and

administration-11032970

- Specific device (e.g. switches) installation- use work order assigned to that job

- Substation Project Coordination- Staff Engineering specialist, Construction

coordinator, EMS Programmer Analysts, System Controllers, SITE Commission, and Inspectors RTO, GIS, supporting the initial deployment of substation

equipment to support the automated grid functionality. o Charge Codes:

- Specific equipment installation- use work order assigned to that job

(3)

- Electric Market Operations- Managers and analysts not assigned full-time to

the SGIG project but developing and documenting requirements for the SGIG system

o Charge code 10 11031850

- Metering Production Support- Technical analysts supporting DCE in

production

o Charge code 10 51789276

Service Company Employees

- Information Systems Development- IT Enterprise Architects (SOA), IT

Managers/Programmers Analysts (CIS/EAI), AMS Manager/Programmer Analysts, HAN Business Analysts designing software configuration and

interfaces, coding and testing during application development stage, installing hardware, testing of AMS systems during initial implementation and

modifications that include functional enhancements (>$100,000). o Capital Charge Codes

Description Internal orders IT

IOSS 11032064

SD SOA 11032065

SD EAI 11032066

SD CIS 11032067

Communications Network Services - ECDC 11032069

Pulse overflow S/156200/CP/HED071

- Development of AMS Integrated Services Monitoring Systems- IT Systems

Manager/Programmers designing software configuration and interfaces, coding and testing during application development stage, installing hardware, testing of AMS systems during initial implementation and modifications that include

(4)

o unarge t;odes:

Description Internal orders IT

AIS - Tivoli Services 11032070

AIS - NOC 11032071

- Program Management Office- VP, Project Management, Directors, Admins,

Finance, Project Scheduling, Tracking, Reporting Manager/Analysts, Process Change and Benefits Realization Director/Analysts supporting the overall progress of the program.

o Charge Codes:

- Project Lead, Governance, Support AMS Only-0 cc 159445 (Regulatory)

• cc 257019 (IT)

• cc 257032 (Shared services)

• cc 257036 (Corporate communications) • cc 257038 (Human Resources)

• cc 257039 (Finance- Project support) • cc 257046 (Finance- Production support) • cc 257040 (Government affairs) • 11031843 (Convenience copy) • 11031844 (Office supplies) • 11031845 (Mail services) • 11031846 (Copy services) • 11031847 (Properties) • 11031849 (Corporate Travel) - Administrative Activities for DOE

SGIG-• 11032722 (Legal AMS) • 11032723 (Legal IG)

- Consumer Education- Corporate Communications personnel developing

programs to educate and engage consumers to utilize advance meters technology.

(5)

APPENDIX E - COST REIMBURSABLE BILLINGS INVOICE

Summary Data For Invoice

AM5

A B C D E F G

Current Billing Period

8/1/10 TO 8/31/10

Federal Non-Federal Federal Non-Federal

Share Share Total Costs Share Share Total Cumulative

A $1,102,579. $2,205,159.5 $2,658,895.6 Personnel $226,868.02 $226,868.02 $453,736.03 79 $1,102,579.79 8 1 B $1,137,456.9 Fringe Beneflts $96,880.25 $96,880.25 $193,760.50 $471,848.22 $471,848.22 $943,696.44 4 C Equi pment $13,045.54 $13,045.54 $26,091.08 $188,073.31 $188,073.31 $376,146.61 $402,237.69 D Supplies $8.53 $8.53 $17.05 $33,532.57 $33,532.57 $67,065.13 $67,082.18 E $9,968,123. $19,936,246 $66,699,345 $133,398,690 $153,334,936 Contractual 17 $9,968,123.17 .33 .30 $66,699,345.30 .60 .93 F. Construction $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 G Other $12,601.65 $12,601.65 $25,203.30 $36,839.91 $36,839.91 $73,679.82 $98,883.12 H Total Direct $10,317,527 $20,635,054 $68,532,219 $137,064,438 $157,699,492 Charges .14 $10,317,527.14 .29 .09 $68,532,219.09 .18 .47 1. Indirect Charges $27,132.98 $27,132.98 $54,265.96 $181,723.90 $181,723.90 $363,447.79 $417,713.75 Total Outlays $10,344,660 $20,689,320 $68,713,942 $137,427,885 $158,117,206 J. This Period .12 $10,344,660.12 .25 .99 $68,713,942.99 .97 .22 Intelligent Grid A B C D E F G Current Bil ^ 8/1/10 TO 8/31/10

A Personnel $97,091.36 $97,091.36 $194,182.71 $233,226.62 $233,226.62 $466,453.23 $660,635.94 B Fringe Beneflts $42,232.86 $42,232.86 $84,465.72 $101,628.79 $101,628.79 $203,257.58 $287,723.30 C Equipment -$26.86 -$26.86 -$53.72 $95,349.79 $95,349.79 $190,699.57 $190,645.85 D Supplies $598.49 $598.49 $1,196.97 $1,672.41 $1,672.41 $3,344.81 $4,541.78 E $1,215,946. $2,431,892.9 $3,192,332.9 Contractual $380,220.00 $380,220.00 $760,439.99 49 $1,215,946.49 8 7 F. Construction $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 G Other $0.00 $0.00 $0.00 $0.00 $0.00 $67,889.96 $67,889.96 H Total Direct $1,040,231. $1,681,769. $3,363,538.1 $4,403,769.8 Charges $520,115.84 $520,115.84 67 06 $1,681,769.06 3 0

(6)

J. I

TTotal

his Perioidys 1$533,676.48 $533,676.48 1$1,067,3 926. I$1,686,3 $6 I 51.686.300.86 I$3,372,601.^ I$4,439,954.6

Smart Grid (AMS and Intelligent Grid)

A B C D E F G

Current Billing Period

8/1/10 TO 8/31/10

A $1,335,806. $2,671,612.8 $3,319,531.5 Personnel $323,959.37 $323,959.37 $647,918.74 41 $1,335,806.41 1 5 B $1,146,954.0 $1,425,180.2 Fringe Benefits $139,113.11 $139,113.11 $278,226.22 $573,477.01 $573,477.01 2 4 C Equi pment $13,018.68 $13,018.68 $26,037.36 $283,423.09 $283,423.09 $566,846.18 $592,883.54 D Supplies $607.01 $607.01 $1,214.02 $35,204.97 $35,204.97 $70,409.94 $71,623.96 E $10,348,343 $20,696,686 $67,915,291 $135,830,583 $156,527,269 Contractual .16 $10,348,343.16 .32 .79 $67,915,291.79 .58 .90 F. Construction $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 G Other $12,601.65 $12,601.65 $25,203.30 $36,839.91 $36,839.91 $141,569.78 $166,773.08 H Total Direct $10,837,642 _$21,675,285 _$70,180,043 _$140,427,976 _$162,103,262 Charges .98 $10,837,642.98 .96 .18 $70,180,043.18 .31 .27 1. Indirect Charges $40,693.63 $40,693.63 $81,387.25 $186,255.70 $186,255.70 $372,511.39 $453,898.64 Total Outlays $10,878,336 $21,756,673 $70,366,298 $140,800,487 $162,557,160 1. This Period .61 $10,878,336.61 .21 .87 $70,366,298.87 .70 .91

(7)

I hereby certify that a true and correct copy of the foregoing document was served on all parties of record in this proceeding by facsimile, hand delivery, e- all, or United States first class mail on this 24h day of February, 2014.