Installation Data Sheet Amendment 0004.xlsx

XLSX spreadsheet 67 KB Posted Jan 31, 2012

Attached to: Strategic Petroleum Reserve Federal contract opportunity
Solicitation number: SP0600-11-R-0440
Issued by: Defense Logistics Agency Energy

About this file

From the source

Amendment 0004 Installation Data Sheet

View the file

Other files for this federal contract opportunity

Other files attached to Strategic Petroleum Reserve, newest first.
File	Type	Posted
Attachment III_ Amendment 0004.pdf	PDF	Jan 31, 2012
SP0600-11-R-0440_Amendment 0004.pdf	PDF	Jan 31, 2012
Amendment 0004.pdf	PDF	Jan 31, 2012
Amendment 0003.doc	DOC document	Jan 5, 2012
SP0600-11-R-0440_Amendment 0003.pdf	PDF	Jan 5, 2012
Amendment 0002.pdf	PDF	Dec 21, 2011
SP0600-11-R-0440_Amendment 0002.pdf	PDF	Dec 21, 2011
Attachment III_ Amendment 0001.xls	XLS spreadsheet	Nov 17, 2011
SP0600-11-R-0440_Amendment 0001.pdf	PDF	Nov 17, 2011
Amendment 0001.pdf	PDF	Nov 17, 2011
Installation Data Sheet Amendment 0001.xls	XLS spreadsheet	Nov 17, 2011
SP0600-11-R-0440.pdf	PDF	Sep 22, 2011
Attachment II - Experience with End Users.pdf	PDF	Sep 22, 2011
Attachment III.xlsx	XLSX spreadsheet	Sep 22, 2011
Attachment IV.pdf	PDF	Sep 22, 2011
Attachment I - Retail Customers Credit Rating Information.pdf	PDF	Sep 22, 2011

Show all 16

On GovTribe

Work with this file on GovTribe

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.

Historical Data

Strategic Petroleum Reserve Bryan Mound
Delivery Period: Meter read in Mach 2010 through Meter read in March 2012.
Line			Meter Read	Total	On Peak	Off Peak	Delivery
Item	Account	Utility	Date	kWh Usage	kWh	kWh	KW
4814a	1008901000144290012100	Centerpoint	5/31/11	101,536.25	-	-	208.00
			5/1/11	92,610.75	-	-	187.00
Svc Address:	1900 FPT Bryan Mound Road, Angleton, TX 77515		3/31/11	73,129.25	-	-	165.00
Rate Code: 993			2/28/11	96,624.00	-	-	314.00
			1/31/11	92,993.75	-	-	248.00
			1/2/11	94,700.50	-	-	218.00
			11/30/10	87,717.25	-	-	227.00
			10/31/10	103,259.75	-	-	229.00
			9/30/10	125,664.75	65,805.25	59,859.50	234.00
			8/31/10	132,017.25	66,600.25	65,417.00	237.00
			8/1/10	134,777.25	65,972.75	68,804.50	220.00
			6/30/10	93,554.25	47,042.50	46,511.75	223.00
			Total	1,228,585.00

Strategic Petroleum Reserve Bryan Mound
Delivery Period: Meter read in Mach 2010 through Meter read in March 2012.
Line			Meter Read	Total	On Peak	Off Peak	Delivery
Item	Account	Utility	Date	kWh Usage	kWh	kWh	KW
4814b	1008901000144180015100	Centerpoint	5/31/11	561,060.75	-	-	4,383.00
			5/1/11	381,259.25	-	-	8,378.00
Svc Address:	1900 FPT Bryan Mound Road, Angleton, TX 77515		3/31/11	669,282.75	-	-	5,909.00
Rate Code: 993			2/28/11	1,238,156.00	-	-	3,514.00
			1/31/11	1,460,930.25	-	-	3,538.00
			1/2/11	1,631,597.50	-	-	5,727.00
			11/30/10	1,546,106.75	-	-	4,422.00
			10/31/10	1,660,836.25	-	-	6,417.00
			9/30/10	1,505,578.25	727,095.75	778,482.50	5,980.00
			8/31/10	1,473,640.75	704,109.75	769,531.00	3,158.00
			8/1/10	1,795,240.75	888,784.25	906,456.50	6,871.00
			6/30/10	1,090,556.75	555,104.50	535,452.25	6,238.00
			Total	15,014,246.00

Projection Data

Bryan Mound Process Load Profile	Bryan Mound Hotel Load Profile
ESI ID 1008901000144180015100	ESI ID 1008901000144290012100
Service Address: 1900 FPT Bryan Md Rd Angleton, TX 77515	Service Address: 1900 FPT Bryan Md Rd Angleton, TX 77515
Based on History Data (FY 2011)	Based on History Data (FY 2011)
New Negotiated Contract to start April 2012	New Negotiated Contract to start April 2012

		Demand	Total			Demand	Total
Date		kW	kWhs	Date		kW	kWhs
12-Mar	Projection	2,406	773,854	12-Mar	Projection	269	84,000
Apr-12	Projection	2,406	773,854	Apr-12	Projection	269	84,000
May-12	Projection	2,406	794,854	May-12	Projection	269	105,000
Jun-12	Projection	2,406	801,854	Jun-12	Projection	269	112,000
Jul-12	Projection	2,406	812,854	Jul-12	Projection	269	123,000
Aug-12	Projection	2,406	813,854	Aug-12	Projection	269	124,000
Sep-12	Projection	2,406	798,854	Sep-12	Projection	269	109,000
Oct-12	Projection	2,406	788,854	Oct-12	Projection	269	99,000
Nov-12	Projection	2,406	767,854	Nov-12	Projection	269	78,000
Dec-12	Projection	2,406	788,854	Dec-12	Projection	269	99,000
Jan-13	Projection	2,406	785,854	Jan-13	Projection	269	96,000
Feb-13	Projection	2,406	776,854	Feb-13	Projection	269	87,000
Mar-13	Projection	2,406	773,854	Mar-13	Projection	269	84,000
Apr-13	Projection	2,406	773,854	Apr-13	Projection	269	84,000
May-13	Projection	2,406	794,854	May-13	Projection	269	105,000
Jun-13	Projection	2,406	801,854	Jun-13	Projection	269	112,000
Jul-13	Projection	2,406	812,854	Jul-13	Projection	269	123,000
Aug-13	Projection	2,406	813,854	Aug-13	Projection	269	124,000
Sep-13	Projection	2,406	798,854	Sep-13	Projection	269	109,000
Oct-13	Projection	2,406	788,854	Oct-13	Projection	269	99,000
Nov-13	Projection	2,406	767,854	Nov-13	Projection	269	78,000
Dec-13	Projection	2,406	788,854	Dec-13	Projection	269	99,000
Jan-14	Projection	2,406	785,854	Jan-14	Projection	269	96,000
Feb-14	Projection	2,406	776,854	Feb-14	Projection	269	87,000
Mar-14	Projection	2,406	773,854	Mar-14	Projection	269	84,000
24 Months			18,956,496	24 Months			2,400,000
25 Months			19,730,350	25 Months			2,484,000

NOTE: 25 months of data projection is given to cover meter reading dates through April 2014

2 YR BM Power Proj Recap

Bryan Mound Power Projection for the period of coverage from March 2012 through March 2014

Constellation Energy Houston Ship Channel Market Price Index

Total Consumption of Power (Breakdown by Hotel and Process Operations)

New DESC Power Contract starting in March 2012

			2,289,630 / 4
25 Month	Hotel	Process	Process	Process	Process	Process Total
Projection	kWhs	kWhs	kWhs	kWhs	kWhs	kWhs	All kWhs
	5 year		FY 11 Avg (4 mos)
	avg. by mo.		572,408
Month / Year	Hotel Load kWhs	Other or Max STEs	Other Oil & Brine Transfers	Leach @ 50MBD	Quarterly Pump Testing	Process Total	Grand Total
		None	kWhs	kWhs	kWhs	kWhs	All kWhs
Mar-12	84,000	0	167,316	488,538	34,000	689,854	773,854
Apr-12	84,000	0	167,316	488,538	34,000	689,854	773,854
May-12	105,000	0	167,316	488,538	34,000	689,854	794,854
Jun-12	112,000	0	167,316	488,538	34,000	689,854	801,854
Jul-12	123,000	0	167,316	488,538	34,000	689,854	812,854
Aug-12	124,000	0	167,316	488,538	34,000	689,854	813,854
Sep-12	109,000	0	167,316	488,538	34,000	689,854	798,854
Oct-12	99,000	0	167,316	488,538	34,000	689,854	788,854
Nov-12	78,000	0	167,316	488,538	34,000	689,854	767,854
Dec-12	99,000	0	167,316	488,538	34,000	689,854	788,854
Jan-13	96,000	0	167,316	488,538	34,000	689,854	785,854
Feb-13	87,000	0	167,316	488,538	34,000	689,854	776,854
Mar-13	84,000	0	167,316	488,538	34,000	689,854	773,854
Apr-13	84,000	0	167,316	488,538	34,000	689,854	773,854
May-13	105,000	0	167,316	488,538	34,000	689,854	794,854
Jun-13	112,000	0	167,316	488,538	34,000	689,854	801,854
Jul-13	123,000	0	167,316	488,538	34,000	689,854	812,854
Aug-13	124,000	0	167,316	488,538	34,000	689,854	813,854
Sep-13	109,000	0	167,316	488,538	34,000	689,854	798,854
Oct-13	99,000	0	167,316	488,538	34,000	689,854	788,854
Nov-13	78,000	0	167,316	488,538	34,000	689,854	767,854
Dec-13	99,000	0	167,316	488,538	34,000	689,854	788,854
Jan-14	96,000	0	167,316	488,538	34,000	689,854	785,854
Feb-14	87,000	0	167,316	488,538	34,000	689,854	776,854
Mar-14	84,000	0	167,316	488,538	34,000	689,854	773,854
Projection Totals	2,484,000	0	4,182,900	12,213,450	850,000	17,246,350	19,730,350

Projected kWhs based on fiscal year 2011 historical actual for Other Oil and Brine Transfers

Projected kWhs based on fiscal year 2011 historical actual for Mini Leach

Oil Brine Transfers and Mini Leach not separately metered. Estimates based on a 29% vs 71% proration of historical process power usage vs barrels moved.

Projected kWhs for quarterly pump testing

Hotel Load

Bryan Mound Power Projection

Hotel Load is based on current monthly actual usage

March 2012 through March 2014

5 year average

by month

Monthly

kWhs

Mar-12	84,000
Apr-12	84,000
May-12	105,000
Jun-12	112,000
Jul-12	123,000
Aug-12	124,000
Sep-12	109,000
Oct-12	99,000
Nov-12	78,000
Dec-12	99,000
Jan-13	96,000
Feb-13	87,000
12 Month Total	1,200,000

Monthly

kWhs

Mar-13	84,000
Apr-13	84,000
May-13	105,000
Jun-13	112,000
Jul-13	123,000
Aug-13	124,000
Sep-13	109,000
Oct-13	99,000
Nov-13	78,000
Dec-13	99,000
Jan-14	96,000
Feb-14	87,000
Mar-14	84,000
13 Month Total	1,284,000

Total 2,484,000 Hotel kilowatt hours

No STEs

BRYAN MOUND POWER PROJECTON

NO OTHER OR MAX STEs IN THE SCHEDULE OF OPERATIONS

FY 2012 TABLETOP EXERCISE

FY 2013 MOD RPX

FY 2014 TABLETOP EXERCISE

Other Oil & Brine Transfers

Bryan Mound Power Projection

Other Oil and Brine Transfers

Process Load is based on current monthly actual usage

March 2012 through March 2014

FY 11 Avg (4 mos) with mini leach and normal oil/brine transfers and no degas operations

572,408

Monthly

kWhs

Mar-12	167,316
Apr-12	167,316
May-12	167,316
Jun-12	167,316
Jul-12	167,316
Aug-12	167,316
Sep-12	167,316
Oct-12	167,316
Nov-12	167,316
Dec-12	167,316
Jan-13	167,316
Feb-13	167,316
12 Month Total	2,007,792

Monthly

kWhs

Mar-13	167,316
Apr-13	167,316
May-13	167,316
Jun-13	167,316
Jul-13	167,316
Aug-13	167,316
Sep-13	167,316
Oct-13	167,316
Nov-13	167,316
Dec-13	167,316
Jan-14	167,316
Feb-14	167,316
Mar-14	167,316
13 Month Total	2,175,108

Total 4,182,900 Other Oil & Brine Transfer kilowatt hours

Mini Leach

Bryan Mound Power Projection

Mini Leach

March 2012 through March 2014

FY 11 Avg (4 mos) with no degas operations

572,408

Monthly

kWhs

Mar-12	488,538
Apr-12	488,538
May-12	488,538
Jun-12	488,538
Jul-12	488,538
Aug-12	488,538
Sep-12	488,538
Oct-12	488,538
Nov-12	488,538
Dec-12	488,538
Jan-13	488,538
Feb-13	488,538
12 Month Total	5,862,456

Monthly

kWhs

Mar-13	488,538
Apr-13	488,538
May-13	488,538
Jun-13	488,538
Jul-13	488,538
Aug-13	488,538
Sep-13	488,538
Oct-13	488,538
Nov-13	488,538
Dec-13	488,538
Jan-14	488,538
Feb-14	488,538
Mar-14	488,538
13 Month Total	6,350,994

Total 12,213,450 Mini Leach kilowatt hours

Quarterly Pump Testing

Bryan Mound Power Projection

Quarterly Pump Testing

Monthly

kWhs

Mar-12	34,000
Apr-12	34,000
May-12	34,000
Jun-12	34,000
Jul-12	34,000
Aug-12	34,000
Sep-12	34,000
Oct-12	34,000
Nov-12	34,000
Dec-12	34,000
Jan-13	34,000
Feb-13	34,000
12 Month Total	408,000

Monthly

kWhs

Mar-13	34,000
Apr-13	34,000
May-13	34,000
Jun-13	34,000
Jul-13	34,000
Aug-13	34,000
Sep-13	34,000
Oct-13	34,000
Nov-13	34,000
Dec-13	34,000
Jan-14	34,000
Feb-14	34,000
Mar-14	34,000
13 Month Total	442,000

Total 850,000 Quarterly Pump Testing kilowatt hours

original per qtr est	100,845.00
3 mos per qtr	3
monthly estimate	33,615.00
rounded to	34,000.00

Attachment A

ATTACHMENT A

25 Month Power Contract

Period of Coverage is March 2012 through March 2014

Bryan Mound Hotel Load Profile

ESI ID 1008901000144290012100

Service Address: 1900 FPT Bryan Md Rd Angleton, TX 77515

Based on History Data (FY 2011)

New Negotiated Contract to start March 2012

		Demand	Total
Date		KVA	kWhs
Mar-12	Projection	269	84,000
Apr-12	Projection	269	84,000
May-12	Projection	269	105,000
Jun-12	Projection	269	112,000
Jul-12	Projection	269	123,000
Aug-12	Projection	269	124,000
Sep-12	Projection	269	109,000
Oct-12	Projection	269	99,000
Nov-12	Projection	269	78,000
Dec-12	Projection	269	99,000
Jan-13	Projection	269	96,000
Feb-13	Projection	269	87,000
Mar-13	Projection	269	84,000
Apr-13	Projection	269	84,000
May-13	Projection	269	105,000
Jun-13	Projection	269	112,000
Jul-13	Projection	269	123,000
Aug-13	Projection	269	124,000
Sep-13	Projection	269	109,000
Oct-13	Projection	269	99,000
Nov-13	Projection	269	78,000
Dec-13	Projection	269	99,000
Jan-14	Projection	269	96,000
Feb-14	Projection	269	87,000
Mar-14	Projection	269	84,000
26 Months			2,484,000

NOTE: 25 months of data projection is given to cover meter reading dates through March 2014

Attachment B

ATTACHMENT B

25 Month Power Contract

Period of Coverage is March 2012 through March 2014

Bryan Mound Process Load Profile

ESI ID 1008901000144180015100

Service Address: 1900 FPT Bryan Md Rd Angleton, TX 77515

Based on History Data (FY 2011)

New Negotiated Contract to start March 2012

		Demand	Total
Date		KVA	kWhs
Mar-12	Projection	2,135	773,854
Apr-12	Projection	2,135	773,854
May-12	Projection	2,135	794,854
Jun-12	Projection	2,135	801,854
Jul-12	Projection	2,135	812,854
Aug-12	Projection	2,135	813,854
Sep-12	Projection	2,135	798,854
Oct-12	Projection	2,135	788,854
Nov-12	Projection	2,135	767,854
Dec-12	Projection	2,135	788,854
Jan-13	Projection	2,135	785,854
Feb-13	Projection	2,135	776,854
Mar-13	Projection	2,135	773,854
Apr-13	Projection	2,135	773,854
May-13	Projection	2,135	794,854
Jun-13	Projection	2,135	801,854
Jul-13	Projection	2,135	812,854
Aug-13	Projection	2,135	813,854
Sep-13	Projection	2,135	798,854
Oct-13	Projection	2,135	788,854
Nov-13	Projection	2,135	767,854
Dec-13	Projection	2,135	788,854
Jan-14	Projection	2,135	785,854
Feb-14	Projection	2,135	776,854
Mar-14	Projection	2,135	773,854
25 Months			19,730,350

NOTE: 25 months of data projection is given to cover meter reading dates through April 2014

Attachment C Drawdown Load

ATTACHMENT C
Bryan Mound Drawdown Process Load Profile			Horsepower Conversion to Demand for BM Full Drawdown
ESI ID 1008901000144180015100
Service Address: 1900 FPT Bryan Md Rd Angleton, TX 77515	Phase 1	90% of 232 MMB = 209 MMB
		Flow Rate @ 1.5 MMB = 139 Days

			RWINT	(Intake)	3	1,500	4,500	0.83	3,735
	Bryan Mound Load Profile for Full Drawdown		RWINJ	(Injection)	7	3,500	24,500	0.83	20,335
	Site Storage is 232 MMB		COTP @ 25%	(transfer)	2	1,000	2,000	0.83	415
	90% Drawdown of 209 MMB Flow Rate is 1.5 MMB for 139 Days						Total KVA Demand		24,070
	10% Drawdown of 23 MMB Flow Rate is 0.750 MMB for 31 Days		Ramp Up - In approximately 2 Hours					Ramp Down - In approximately 2 Hours
			Step 1	Pumps on line ( 1 RWINT + 2 RWINJ)				Step 1	Pumps on line ( 3 RWINT + 7 RWINJ)
			Step 3	Pumps on line ( 3 RWINT + 7 RWINJ)				Step 3	Pumps on line ( 1 RWINT + 2 RWINJ)
Note: These figures are presented for contingent planning purposes only.
Currently no drawdown is scheduled, however the contractor must be		Phase 2	30 Day Cavern Rebound ( No Drawdown)
prepared to supply all power with thirteen (13) days notice by the SPR

		Process Operations
		Motors & Pumps	Total	Phase 3	10% of 232 MMB = 23 MMB
		Demand	Estimated		Flow Rate @ 0.750 MMB = 31 Days
		KVA	kWh
Phase 1	30 Days	24,000	14,400,000		Pump Description		# of Pumps	HP	HP	@ 83%	Demand
	30 Days	24,000	14,400,000
	30 Days	24,000	14,400,000		RWINT	(Intake)	2	1,500	3,000	0.83	2,490
	30 Days	24,000	14,400,000		RWINJ	(Injection)	4	3,500	14,000	0.83	11,620
	19 Days	24,000	9,120,000		COTP @ 25%	(transfer)	2	1,000	2,000	0.83	415
	139 Days		66,720,000						Total KVA Demand		14,110

Phase 2	30 Days	0	0
Cavern				Ramp Up - In approximately 2 Hours		Ramp Down - In approximately 2 Hours
Rebound				Step 1	Pumps on line ( 1 RWINT + 2 RWINJ)	Step 1	Pumps on line ( 2 RWINT + 4 RWINJ)
				Step 2	Pumps on line ( 2 RWINT + 4 RWINJ)	Step 2	Pumps on line ( 1 RWINT + 2 RWINJ)
Phase 3	31 Days	14,000	8,400,090

TOTAL 200 Days 75,120,090

Curole 5 yr mo avg hotel 5 Years of Hotel Actual kWh plus FY 2011 through June

							Profile
	FY 2006	FY 2007	FY 2008	FY 2009	FY 2010	FY 2011	Average
Oct	97	89	106	98	103	103	99
Nov	103	71	92	39	74	88	78
Dec	115	101	80	101	100	95	99
Jan	70	115	102	95	103	93	96
Feb	76	86	80	72	111	97	87
Mar	95	82	80	84	91	73	84
Apr	88	61	89	82	92	93	84
May	109	103	108	99	107	102	105
Jun	123	118	108	114	94	112	112
Jul	115	113	120	130	135		123
Aug	125	125	122	117	132		124
Sep	114	121	80	106	126		109
	1,230	1,185	1,167	1,137	1,268	856	1,200

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