Attachment IX - AAFES Pricing Sheet.xlsx

XLSX spreadsheet 31 KB Posted Aug 19, 2020

Attached to: Texas 2021 - Electricity - Solicitation - A0008
Solicitation number: SPE60420R0409
Issued by: Defense Logistics Agency Energy

View the file

Other files

File	Type	Posted
SF30_SPE60420R0409_A0008.pdf	PDF	Dec 10, 2020
0409A0008 - Solicitation.pdf	PDF	Dec 10, 2020
Attachment IX - AAFES Pricing Sheet_0007.xlsx	XLSX spreadsheet	Dec 7, 2020
SF30_SPE60420R0409_A0007.pdf	PDF	Dec 7, 2020
0409A0007 - Solicitation.pdf	PDF	Dec 7, 2020
SF30_SPE60420R0409_A0006.pdf	PDF	Dec 4, 2020
0409A0006 - Solicitation.pdf	PDF	Dec 4, 2020
Attachment I - Installation Data Sheet_0005.xlsx	XLSX spreadsheet	Nov 25, 2020
SF30_SPE60420R0409_A0005.pdf	PDF	Nov 25, 2020
Attachment VII - NASA JSC Pricing Sheet_0005.xlsx	XLSX spreadsheet	Nov 25, 2020
Attachment VI - NASA JSC Block Schedule_0005.xlsx	XLSX spreadsheet	Nov 25, 2020
0409A0005 - Solicitation.pdf	PDF	Nov 25, 2020
0409A0004 - Solicitation - Conf.pdf	PDF	Nov 18, 2020
SPE60420R0409A0004 SF30.pdf	PDF	Nov 18, 2020
Attachment I - Installation Data Sheet_0004.xlsx	XLSX spreadsheet	Nov 18, 2020
0409A0003 - Solicitation.pdf	PDF	Oct 30, 2020
Attachment I - Installation Data Sheet_0003.xlsx	XLSX spreadsheet	Oct 30, 2020
SF30-A0003.pdf	PDF	Oct 30, 2020
Attachment I - Installation Data Sheet_0002.xlsx	XLSX spreadsheet	Sep 1, 2020
SF30 0409A0002.pdf	PDF	Sep 1, 2020
0409A0002 - Solicitation.pdf	PDF	Sep 1, 2020
Attachment X - Question Responses.docx	DOCX document	Sep 1, 2020
Attachment II - Experience with End Users.doc	DOC document	Sep 1, 2020
0409A0001 - Solicitation.pdf	PDF	Aug 19, 2020
Attachment VIII - AAFES Block Schedule.xlsx	XLSX spreadsheet	Aug 19, 2020
Attachment I - Installation Data Sheet - A0001.xlsx	XLSX spreadsheet	Aug 19, 2020
Attachment VII - NASA JSC Pricing Sheet.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment IX - NAS Kingsville Pricing Sheet.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment XI - JRB Navy Reserves Pricing Sheet.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment V - Navy Service Point ID (SPID) List.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment I - Installation Data Sheet.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment IV - Fort Hood Invoice Checklist Verification.pdf	PDF	Aug 11, 2020
Attachment X - JRB Navy Reserves Block Schedule.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment XIII - NAS Corpus Christi Pricing Sheet.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment III - Small Business Subcontracting Plan.pdf	PDF	Aug 11, 2020
Attachment XII - NAS Corpus Christi Block Schedule.xlsx	XLSX spreadsheet	Aug 11, 2020
Attachment VIII - NAS Kingsville Block Schedule.xlsx	XLSX spreadsheet	Aug 11, 2020
Solicitation SPE60420R0409.pdf	PDF	Aug 11, 2020
Attachment VI - NASA JSC Block Schedule.xlsx	XLSX spreadsheet	Aug 11, 2020

Show all 39

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.

AAFES Pricing Sheet

Offeror:
SPE60420R0409 - Amendment 0001 Attachment IX - AAFES Pricing Sheet
Pricing Type	ESI-ID Number	Applicable TDSP	Evaluation Element	Estimated Quantity (kWh)	Estimated Price of Energy ($/kWh)	Offered Unit Price ($/kWh)	Estimated Price

Block Accounts	10443720002997554	ONCOR	Supply Service Fee	89,015,775	$ - 0	$ - 0
	10443720003062406		ATC BLOCK	63,576,000	$ - 0	$ - 0
	10443720003300516		On-Peak Block	2,560,000	$ - 0	$ - 0
	10443720004297913		Remaining Market kWh	22,879,775	$ 0.05000	$ 1,143,988.75
	10443720004368220				Total Evaluated Price	$ 1,143,988.75
	10443720004840438
	10443720004840469			ENTER OFFERED UNIT PRICES BELOW
	10443720006184071			Do Not Exceed 5 Decimal Places ($X.XXXXX / kWh)
	10443720006772797			Pricing Type	Unit Price
	10443720007044667			Supply Service Fee (Block Accts)		per kWh
	10443720007547301			ATC Block Price		per MW
	10443720008744428			On-Peak Block Price		per MW
	10443720008934334

Block Structure

ATC Block

On-Peak Block

On / Off Peak Hours per Month

Delivery Year

Delivery Month

Estimated kWh

Block kWh

Market kWh

ATC kWh

Peak kWh

Month

Year

Flat

Peak

Off-Peak

1x16H

Peak Days

Total Days

Holidays

2021	Jan	1,165,053	744,000.00	421,052.50	1.0	1,000	744,000	0.0	0	0	Jan	2021	744	320	424	96	20	31	1
2021	Feb	2,174,292	1,344,000.00	830,292.00	2.0	2,000	1,344,000	0.0	0	0	Feb	2021	672	320	352	64	20	28	0
2021	Mar	2,349,681	1,486,000.00	863,681.00	2.0	2,000	1,486,000	0.0	0	0	Mar	2021	743	368	375	64	23	31	0
2021	Apr	2,219,096	1,440,000.00	779,096.00	2.0	2,000	1,440,000	0.0	0	0	Apr	2021	720	352	368	64	22	30	0
2021	May	2,564,142	2,392,000.00	172,142.00	3.0	3,000	2,232,000	0.5	500	160,000	May	2021	744	320	424	96	20	31	1
2021	Jun	2,775,852	2,336,000.00	439,852.00	3.0	3,000	2,160,000	0.5	500	176,000	Jun	2021	720	352	368	64	22	30	0
2021	Jul	2,852,233	2,400,000.00	452,233.00	3.0	3,000	2,232,000	0.5	500	168,000	Jul	2021	744	336	408	80	21	31	1
2021	Aug	2,777,639	2,408,000.00	369,639.00	3.0	3,000	2,232,000	0.5	500	176,000	Aug	2021	744	352	392	80	22	31	0
2021	Sep	2,889,926	2,328,000.00	561,926.00	3.0	3,000	2,160,000	0.5	500	168,000	Sep	2021	720	336	384	80	21	30	1
2021	Oct	2,341,721	1,488,000.00	853,721.00	2.0	2,000	1,488,000	0.0	0	0	Oct	2021	744	336	408	80	21	31	0
2021	Nov	2,150,770	1,442,000.00	708,770.00	2.0	2,000	1,442,000	0.0	0	0	Nov	2021	721	336	385	80	21	30	1
2021	Dec	2,246,468	1,488,000.00	758,468.00	2.0	2,000	1,488,000	0.0	0	0	Dec	2021	744	368	376	80	23	31	1
2022	Jan	2,330,105	1,488,000.00	842,105.00	2.0	2,000	1,488,000	0.0	0	0	Jan	2022	744	336	408	96	21	31	1
2022	Feb	2,174,292	1,344,000.00	830,292.00	2.0	2,000	1,344,000	0.0	0	0	Feb	2022	672	320	352	64	20	28	0
2022	Mar	2,349,681	1,486,000.00	863,681.00	2.0	2,000	1,486,000	0.0	0	0	Mar	2022	743	368	375	64	23	31	0
2022	Apr	2,219,096	1,440,000.00	779,096.00	2.0	2,000	1,440,000	0.0	0	0	Apr	2022	720	336	384	64	21	30	0
2022	May	2,564,142	2,400,000.00	164,142.00	3.0	3,000	2,232,000	0.5	500	168,000	May	2022	744	336	408	96	21	31	1
2022	Jun	2,775,852	2,336,000.00	439,852.00	3.0	3,000	2,160,000	0.5	500	176,000	Jun	2022	720	352	368	64	22	30	0
2022	Jul	2,852,233	2,392,000.00	460,233.00	3.0	3,000	2,232,000	0.5	500	160,000	Jul	2022	744	320	424	96	20	31	1
2022	Aug	2,777,639	2,416,000.00	361,639.00	3.0	3,000	2,232,000	0.5	500	184,000	Aug	2022	744	368	376	64	23	31	0
2022	Sep	2,889,926	2,328,000.00	561,926.00	3.0	3,000	2,160,000	0.5	500	168,000	Sep	2022	720	336	384	80	21	30	1
2022	Oct	2,341,721	1,488,000.00	853,721.00	2.0	2,000	1,488,000	0.0	0	0	Oct	2022	744	336	408	80	21	31	0
2022	Nov	2,150,770	1,442,000.00	708,770.00	2.0	2,000	1,442,000	0.0	0	0	Nov	2022	721	336	385	80	21	30	1
2022	Dec	2,246,468	1,488,000.00	758,468.00	2.0	2,000	1,488,000	0.0	0	0	Dec	2022	744	336	408	80	21	31	1
2023	Jan	2,330,105	1,488,000.00	842,105.00	2.0	2,000	1,488,000	0.0	0	0	Jan	2023	744	336	408	96	21	31	1
2023	Feb	2,174,292	1,344,000.00	830,292.00	2.0	2,000	1,344,000	0.0	0	0	Feb	2023	672	320	352	64	20	28	0
2023	Mar	2,349,681	1,486,000.00	863,681.00	2.0	2,000	1,486,000	0.0	0	0	Mar	2023	743	368	375	64	23	31	0
2023	Apr	2,219,096	1,440,000.00	779,096.00	2.0	2,000	1,440,000	0.0	0	0	Apr	2023	720	320	400	80	20	30	0
2023	May	2,564,142	2,408,000.00	156,142.00	3.0	3,000	2,232,000	0.5	500	176,000	May	2023	744	352	392	80	22	31	1
2023	Jun	2,775,852	2,336,000.00	439,852.00	3.0	3,000	2,160,000	0.5	500	176,000	Jun	2023	720	352	368	64	22	30	0
2023	Jul	2,852,233	2,392,000.00	460,233.00	3.0	3,000	2,232,000	0.5	500	160,000	Jul	2023	744	320	424	96	20	31	1
2023	Aug	2,777,639	2,416,000.00	361,639.00	3.0	3,000	2,232,000	0.5	500	184,000	Aug	2023	744	368	376	64	23	31	0
2023	Sep	2,889,926	2,320,000.00	569,926.00	3.0	3,000	2,160,000	0.5	500	160,000	Sep	2023	720	320	400	80	20	30	1
2023	Oct	2,341,721	1,488,000.00	853,721.00	2.0	2,000	1,488,000	0.0	0	0	Oct	2023	744	352	392	80	22	31	0
2023	Nov	2,150,770	1,442,000.00	708,770.00	2.0	2,000	1,442,000	0.0	0	0	Nov	2023	721	336	385	80	21	30	1
2023	Dec	2,246,468	1,488,000.00	758,468.00	2.0	2,000	1,488,000	0.0	0	0	Dec	2023	744	320	424	96	20	31	1
2024	Jan	1,165,053	744,000.00	421,052.50	1.0	1,000	744,000	0.0	0	0	Jan	2024	744	352	392	80	22	31	1
TOTAL kWh		89,015,775	66,136,000	22,879,775			63,576,000			2,560,000

Projected Usage

DELIVERY MONTH	TOTAL PROJECTED 12-MONTH kWh	ACCOUNTS
		10443720002997554	10443720003062406	10443720003300516	10443720004297913	10443720004368220	10443720004840438	10443720004840469	10443720006184071	10443720006772797	10443720007044667	10443720007547301	10443720008744428	10443720008934334
January	2,330,105	662111	945	2255	2970	65755	150	459,657	21	952862	181534	307	1105	433
February	2,174,292	622682	799	2390	2973	69682	300	462,044	21	868159	143409	260	1204	369
March	2,349,681	641177	789	1346	2380	60375	450	521,142	19	968577	151516	281	1239	390
April	2,219,096	539036	696	792	1853	60253	900	573,246	1	914534	126045	259	1124	357
May	2,564,142	659771	873	345	1373	86560	750	682,187	1	923235	207361	446	764	476
June	2,775,852	659154	901	781	1525	100702	900	813,457	0	958155	238518	464	829	466
July	2,852,233	672356	962	1946	1817	94699	600	805,249	6	995927	276737	495	958	481
August	2,777,639	607934	733	2302	2017	101227	600	872,002	20	924353	264768	276	937	470
September	2,889,926	652300	740	2608	2068	110388	600	883,945	25	972253	263259	235	1004	501
October	2,341,721	614900	757	1503	1852	89460	1650	529,816	24	886370	213629	241	994	525
November	2,150,770	605991	770	1353	2431	35405	450	510,671	23	836185	155893	259	973	366
December	2,246,468	623082	882	2664	2854	71156	150	493,480	24	867622	182833	276	1054	391
TOTAL kWh	29,671,925	7,560,494	9,847	20,285	26,113	945,662	7,500	7,606,896	185	11,068,232	2,405,502	3,799	12,185	5,225

File details come from the government source that posted it. Updated Aug 19, 2020.