PPL2011Exhibit1data.xls

XLS spreadsheet 396 KB Posted Oct 4, 2011

Attached to: Electric power supply to Federal accounts in Pennsylvania behind Pennsylvania Power and Light Company (PPL)
Solicitation number: GS-00P-11-BSD-0831
Issued by: General Services Administration Public Buildings Service Central Office Energy Division

About this file

From the source

Exhibit 1

View the file

Other files

File	Type	Posted
PPL2011electricsolic.doc	DOC document	Oct 4, 2011

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

PPLAccts2011

				GSA Solicitation	GS-00P-11-BSD-0832
				PPL Accounts
				Exhibit 1 - Basic Monthly Data
													Estimated Annual
Series	Zip	Interval	ICAP (KW)	Transmission (KW)		Meter	PPL						KWH
No.	Code	Data Y/N	6/1/11-5/31/12	1/1/11-12/31/11	Bill Cycle	Number	Rate Code	Account Number	Agency	Address	Location	State	Consumption
1	17954	Yes	1,131.08	1,277.60	17	93397779	LP4	7656033007	FCI Minersville	Rt 901	Minersville	PA	9,401,400
2	17752	Yes	12.58	13.59	18	93397570&86900583	LP4	2757045008	US Justice Dept	Bureau of Prison	Montgomery	PA	184,200
3	17752	Yes	4,813.97	5,355.64	7	97128677	LP4	1486050007	US Justice Dept	New Allenwood Prison	Montgomery	PA	30,480,000
4	18472	Yes	2,011.28	2,099.90	6	93397257&88889419	LP4	4573560026	Federal Bur of Prison	3057 Easton TPKE, Prison	Waymart	PA	14,719,200
5	17837	Yes	1,496.15	1,656.42	17	93397200	LP4	8136050003	US Justice Dept	Institutional Acct RR3	Lewisburg	PA	10,459,200
6	17701	Yes	368.10	396.75	17	93397553	LP4	8778035008	GSA PA	240 W 3rd Street	Williamsport	PA	1,548,000
7	18701	Yes	273.60	293.02	2	93397404	LP4	8921029010	GSA Fin Div Utilities	197 S. Main Street	Wilkes Barre	PA	937,200
8	18702	Yes	972.04	1,040.37	3	93397350&93397372	LP4	0282030004	SSA	1150 E Mountain Drive	Wilkes Barre	PA	6,370,200
9	18702	Yes	2,653.70	2,858.77	20	93397378&93397373	LP4	7419041005	VA Hospital	1111 E End Blvd	Wilkes Barre	PA	15,692,400
10	18503	No	781.01	774.98	19	95702910	GS3	8942305426	GSA Federal Building	N Wash and Linden St	Scranton	PA	2,771,250
11	17108	No	907.27	961.80	10	90885663	GS3	6949066000	GSA Region 3	228 Walnut Street	Harrisburg	PA	3,048,000
12	18101	Yes	307.72	328.10	9	94710398	GS3	8368035490	Federal Bldg GSA Fin	5th and Hamilton Street	Allentown	PA	1,220,250
13	18705	Yes	211.58	281.68	8	91115948	GS3	2847028006	General Services Adm	Off Courthright Street	Plains	PA	980,400
			15,940	17,339									97,811,700
			Basic Monthly
			Data
	Account	7656033007	2757045008	1486050007	4573560026	8136050003	8778035008	8921029010	0282030004	7419041005	8942305426	6949066000	8368035490	2847028006
	Location	FCI Minersville	US Justice Dept	US Justice Dept	Federal Bur of Prison	US Justice Dept	GSA PA	GSA Fin Div Utilities	SSA	VA Hospital	GSA Federal Building	GSA Region 3	Federal Bldg GSA Fin	General Services Adm
	Jan	831,600	19,800	2,496,000	1,243,200	852,000	189,000	74,400	540,000	1,116,000	217,500	244,200	95,250	82,800
	Feb	853,200	33,600	2,534,400	1,164,000	876,000	187,200	70,800	482,400	1,090,800	198,750	219,600	85,500	79,600
	Mar	723,600	25,200	2,376,000	1,252,800	756,000	129,000	64,800	482,400	1,152,000	183,000	237,600	82,500	81,200
	Apr	741,600	18,600	2,289,600	1,171,200	780,000	104,400	64,800	523,800	1,191,600	201,750	234,000	93,000	79,200
	May	747,000	14,400	2,438,400	1,132,800	852,000	103,200	75,600	507,600	1,267,200	205,500	226,200	90,000	74,800
	Jun	768,600	10,800	2,524,800	1,288,800	955,200	108,000	93,600	538,200	1,616,400	305,250	282,000	111,000	89,600
	Jul	799,200	10,800	2,779,200	1,260,000	1,015,200	124,200	103,200	563,400	1,638,000	338,250	303,000	133,500	101,200
	Aug	835,200	9,000	2,995,200	1,322,400	1,032,000	118,200	93,600	619,200	1,486,800	272,250	308,400	128,250	100,800
	Sep	783,000	9,600	2,716,800	1,380,000	926,400	97,200	84,000	556,200	1,458,000	244,500	304,200	121,500	72,000
	Oct	718,200	7,800	2,433,600	1,152,000	813,600	91,800	68,400	558,000	1,184,400	207,000	250,200	110,250	67,600
	Nov	748,800	9,600	2,366,400	1,113,600	736,800	116,400	69,600	514,800	1,173,600	196,500	217,800	87,000	69,200
	Dec	851,400	15,000	2,529,600	1,238,400	864,000	179,400	74,400	484,200	1,317,600	201,000	220,800	82,500	82,400
		9,401,400	184,200	30,480,000	14,719,200	10,459,200	1,548,000	937,200	6,370,200	15,692,400	2,771,250	3,048,000	1,220,250	980,400	97,811,700

&Llast update 10/07/08hsp

PPLAccts2011

Months Price/kwh NASA Pricing Comparison

CapacTrans 1 1

#REF!

Months

NASA Pricing Comparison

1 1

#REF!

Months

NASA Pricing Comparison

1 1

#REF!

Months

NASA Pricing Comparison

1 1

#REF!

Months

NASA Pricing Comparison

1 1

#REF!

Months

NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0
0	0

Months Price/kwh NASA Pricing Comparison

PPL Customer Peak Load Contributions
GSA Solicitation GS-00P-11-BSD-0832
		Starting Date	6/1/11	1/1/11
		End Date	5/31/12	12/31/11
Customer Name	Account Number	Rate Class	Current ICAP	Current NITS	Status	Bill Cycle
			(kW)	(kW)
FEDERAL BUR OF PRISONS	7656033007	LP-4	1131.079759	1277.601946	Active	17
US JUSTICE DEPT	2757045008	LP-4	12.58059	13.585302	Active	18
US JUSTICE DEPT	1486050007	LP-4	4813.972211	5355.643423	Active	7
FEDERAL BUR OF PRISONS	4573560026	LP-4	2011.276561	2099.901999	Active	6
US JUSTICE DEPT	8136050003	LP-4	1496.152538	1656.424106	Active	17
GSA PA 0235ZZ	8778035008	LP-4	368.104103	396.747576	Active	17
GSA FIN DIV UTILITIES	8921029010	LP-4	273.604224	293.01614	Active	2
SOCIAL SECURITY ADM	0282030004	LP-4	972.038203	1040.36715	Active	3
US VETERANS ADMIN HOSP	7419041005	LP-4	2653.695312	2858.77461	Active	20
FEDERAL BUILDING	8942305426	GS-3	781.008885	774.980399	Active	19
GSA REGION 3 AUTH 983	6949066000	GS-3	907.272581	961.795198	Active	10
FEDERAL BLDG GSA FINAN	8368035490	GS-3	307.724409	328.104915	Active	9
GENERAL SERVICES ADM	2847028006	GS-3	211.584683	281.678456	Active	8
	Total		15,940	17,339
Please Note:
- Transmission PLCs are assigned on a calendar year basis (1/1 to 12/31) as designated in the PJM Open Access Transmission Tariff.
- Capacity PLCs are assigned on a planning year basis (6/1 to 5/31) as designated in the Reliability Assurance Agreement.
- Values provided are Peak Load Contribution and represent the customer average contribution to the highest hour on the five highest peak load days.
- PLCs do not include any scaling factors or reserves adjustments used by PJM to determine obligations.
- A PLC of 999999999 indicates that no PLC value is available for this period or no PLC value has been calculated for the account.
- Applicable Transmission Loss Factors
	Loss Factors
Transmission	1.0268
Primary	1.0536
Secondary	1.0805
Loss Factors by Rate Class are available on our Supplier Web Site by clicking here.

HopeSParker:

Updated HopeSParker:

Updated Loss Factors by Rate Class are available on our Supplier Web Site by clicking here.

File details come from the government source that posted it. Updated Nov 14, 2017.