Attachment_C_-_GRT_and_PUCA_Eval_Methodology.xlsx

XLSX spreadsheet 44 KB Posted Dec 14, 2016

Attached to: Texas 2017
Solicitation number: SPE600-16-R-0414
Issued by: Defense Logistics Agency Energy

About this file

From the source

Attachment C - GRT and PUCA Eval Methodology

View the file

Other files

File	Type	Posted
Attachment_IV_-_A0003_-_Fort_Hood_Invoice_Checklist_Verification.docx	DOCX document	Dec 14, 2016
Attachment_III_-_A0003_-_Installation_Data_Sheet_.xlsx	XLSX spreadsheet	Dec 14, 2016
Attachment_B_-_CLIN00016_NASA_JSC_Summary_Invoice.pdf	PDF	Dec 14, 2016
SPE600-16-R-0414_A0003_Conformed.pdf	PDF	Dec 14, 2016
Attachment_VII_-_A0003_-_NASA-JSC_Block_Purchase_Schedule.xlsx	XLSX spreadsheet	Dec 14, 2016
SF30_A0003.pdf	PDF	Dec 14, 2016
Attachment_I-A0001_-_Past_Performance.docx	DOCX document	Oct 6, 2016
Attachment_IV_-_Fort_Hood_Invoice_Checklist_A0001.docx	DOCX document	Oct 6, 2016
SPE600-16-R-0414_A0002_Conformed.pdf	PDF	Oct 6, 2016
SPE600-16-R-0414_A0002_Questions_Answers.docx	DOCX document	Oct 6, 2016
SF30_A0002.pdf	PDF	Oct 6, 2016
Attachment_III-_A0001_-_Installation_Data_Sheet_.xlsx	XLSX spreadsheet	Oct 6, 2016
SPE600-16-R-0414_A0001_CONFORMED_TEXAS_2017.pdf	PDF	Sep 28, 2016
SPE600-16-R-0413_A0001_SF30.pdf	PDF	Sep 28, 2016
Attachment_VII_-_NASA-JSC_Block_Purchase_Schedule.xlsx	XLSX spreadsheet	Aug 29, 2016
Attachment_V_-_SPID_LIST.pdf	PDF	Aug 29, 2016
Attachment_II_-_Small_Business_Subcontracting_Plan.pdf	PDF	Aug 29, 2016
SPE600-16-R-0414_TEXAS_2017.pdf	PDF	Aug 29, 2016
Attachment_IV_-_Fort_Hood_Invoice_Checklist.pdf	PDF	Aug 29, 2016
Attachment_III_-_Installation_Data_Sheet_.xlsx	XLSX spreadsheet	Aug 29, 2016
Attachment_I_-_Past_Performance.pdf	PDF	Aug 29, 2016

Show all 21

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.

CLIN 0001 EVAL

CLIN	CUSTOMER	ESI ID	SERVICE ADDRESS	INCORPORATED CITY / TOWN	U.S CENSUS JULY 1 2015 POPULATION ESTIMATE	Applicable GRT Rate	Applicable PUCA Rate	12 MONTH TOTAL kWh	24 MONTH kWh ESTIMATE	PERCENT OF TOTAL ESTIMATED QUANTITY	ADJUSTED GRT/PUC RATE	OFFEROR AUCTION PRICE per kWh	ADJUSTMENT TO OFFERED PRICE	EVALUATED PRICE per kWh	TOTAL EVALUATED PRICE	OFFEROR 24 MONTH BID (gross receipts)	PUCA (% gross receipts) 0.001667	GRT (% gross receipts) (rates / population ) 0.00581 for 1-2.5K 0.0107 for 2.5 to 10K 0.01997 for > 10K	OFFEROR 24 MONTH BID WITH PUCA & GRT TOTAL
CLIN 0001	Army/AF Exchange Svc (AAFES)	ESI ID# 10443720002997554	3911 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	8,723,403	17,446,806	26.53%	0.5741%
		ESI ID# 10443720003300516	3911 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	17,038	34,076	0.05%	0.0011%
		ESI ID# 10443720006772797	3911 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	11,779,322	23,558,644	35.83%	0.7752%
		ESI ID# 10443720007044667	3911 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	2,473,066	4,946,132	7.52%	0.1628%
		ESI ID# 10443720007547301	3911 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	25,757	51,514	0.08%	0.0017%
		ESI ID# 10443720008934334	4015 S Walton Walker Blvd, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	- 0	- 0	0.00%	0.0000%
		ESI ID# 10443720003062406	Joseph Hardin & Coun Drive, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	6,335	12,670	0.02%	0.0004%
		ESI ID# 10443720004297913	4600 Exchange Service Dr., Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	23,491	46,982	0.07%	0.0015%
		ESI ID# 10443720008744428	4602 Exchange Service Dr, Dallas, TX 75236	DALLAS	1,300,092	1.997%	0.1667%	33,950	67,900	0.10%	0.0022%
		ESI ID# 10443720004840438	1801 Exchange Pkwy, Waco, TX 76712	WACO	132,356	1.997%	0.1667%	6,600	13,200	0.02%	0.0004%
		ESI ID# 10443720004840469	1801 Exchange Pkwy, Waco, TX 76712	WACO	132,356	1.997%	0.1667%	7,831,974	15,663,948	23.82%	0.5154%
		ESI ID# 10443720006184071	1801 Exchange Pkwy, Waco, TX 76712	WACO	132,356	1.997%	0.1667%	228	456	0.00%	0.0000%
		ESI ID# 10443720004368220	8901 Autobahn Dr; Dallas, TX 75237	DALLAS	1,300,092	1.997%	0.1667%	1,957,259	3,914,518	5.95%	0.1288%
												↓↓Offerored Price↓↓	↓↓Supply Adj↓↓
								32,878,423	65,756,846	100%	2.1637%	$0.34560	$0.00748	$0.35308	$23,217,279.05	$ 22,725,565.98	$ 37,883.52	$ 453,829.55	$ 23,217,279.05
											↑↑Adj GRT/PUC Rate↑↑	$0.01697	$0.00037	←TDSP Adj
			Population	GRT Rates	PUC Rate							↑↑Est TDSP Rate↑↑	$0.00784	$0.35344	$23,241,420.78
			Greater than 1,000 but less than 2,500	0.581%	0.1667%								↑↑Total Offer Adj↑↑	↑↑Evaluated Rate / Price↑↑
			2,500 or more but less than 10,000	1.070%	0.1667%
			10,000 or more	1.997%	0.1667%

Texas 2017 Attachment C GRT and PUC Eval Methodology SPE600-16-R-0414

CLIN 0001 TDSP

ESI ID	Actual KWH	TDSP Charges	Start Date	End Date
10443720002997554	700,130	$ 11,860.33	10/22/2015	11/20/2015
10443720002997554	775,496	$ 11,966.75	11/20/2015	12/22/2015
10443720002997554	832,862	$ 12,215.00	12/22/2015	1/25/2016
10443720002997554	723,648	$ 12,061.95	1/25/2016	2/23/2016
10443720002997554	712,224	$ 12,345.00	2/23/2016	3/23/2016
10443720002997554	731,989	$ 12,335.25	3/23/2016	4/22/2016
10443720002997554	710,523	$ 12,175.17	4/22/2016	5/23/2016
10443720002997554	696,446	$ 12,057.88	5/23/2016	6/22/2016
10443720002997554	730,461	$ 12,007.00	6/22/2016	7/22/2016
10443720002997554	791,416	$ 11,839.93	7/22/2016	8/23/2016
10443720002997554	720,414	$ 11,852.83	8/23/2016	9/22/2016
10443720002997554	667,813	$ 11,751.55	9/22/2016	10/21/2016
10443720003062406	496	$ 23.69	10/22/2015	11/20/2015
10443720003062406	548	$ 25.21	11/20/2015	12/22/2015
10443720003062406	546	$ 24.63	12/22/2015	1/25/2016
10443720003062406	502	$ 23.39	1/25/2016	2/23/2016
10443720003062406	487	$ 23.59	2/23/2016	3/23/2016
10443720003062406	452	$ 22.57	3/23/2016	4/22/2016
10443720003062406	458	$ 22.38	4/22/2016	5/23/2016
10443720003062406	441	$ 21.90	5/23/2016	6/22/2016
10443720003062406	526	$ 24.33	6/22/2016	7/22/2016
10443720003062406	836	$ 33.19	7/22/2016	8/23/2016
10443720003062406	940	$ 37.11	8/23/2016	9/22/2016
10443720003062406	965	$ 37.86	9/22/2016	10/21/2016
10443720003300516	253	$ 16.64	10/22/2015	11/20/2015
10443720003300516	1,257	$ 45.79	11/20/2015	12/22/2015
10443720003300516	3,472	$ 106.87	12/22/2015	1/25/2016
10443720003300516	2,272	$ 73.16	1/25/2016	2/23/2016
10443720003300516	1,910	$ 65.42	2/23/2016	3/23/2016
10443720003300516	1,093	$ 41.41	3/23/2016	4/22/2016
10443720003300516	683	$ 28.81	4/22/2016	5/23/2016
10443720003300516	961	$ 36.76	5/23/2016	6/22/2016
10443720003300516	1,330	$ 47.30	6/22/2016	7/22/2016
10443720003300516	1,509	$ 52.42	7/22/2016	8/23/2016
10443720003300516	1,220	$ 45.41	8/23/2016	9/22/2016
10443720003300516	611	$ 27.38	9/22/2016	10/21/2016
10443720004297913	2,305	$ 76.24	10/22/2015	11/20/2015
10443720004297913	3,259	$ 103.94	11/20/2015	12/22/2015
10443720004297913	3,403	$ 104.94	12/22/2015	1/25/2016
10443720004297913	2,419	$ 77.27	1/25/2016	2/23/2016
10443720004297913	2,100	$ 71.01	2/23/2016	3/23/2016
10443720004297913	1,830	$ 63.06	3/23/2016	4/22/2016
10443720004297913	1,632	$ 55.95	4/22/2016	5/23/2016
10443720004297913	1,657	$ 56.65	5/23/2016	6/22/2016
10443720004297913	1,932	$ 64.52	6/22/2016	7/22/2016
10443720004297913	1,980	$ 65.89	7/22/2016	8/23/2016
10443720004297913	1,849	$ 64.02	8/23/2016	9/22/2016
10443720004297913	1,553	$ 55.27	9/22/2016	10/21/2016
10443720004368220	160,425	$ 2,863.04	10/16/2015	11/16/2015
10443720004368220	140,683	$ 2,856.07	11/16/2015	12/17/2015
10443720004368220	119,400	$ 2,645.76	12/17/2015	1/19/2016
10443720004368220	105,156	$ 2,640.73	1/19/2016	2/17/2016
10443720004368220	100,863	$ 2,740.44	2/17/2016	3/17/2016
10443720004368220	148,286	$ 2,762.20	3/17/2016	4/18/2016
10443720004368220	142,338	$ 2,679.68	4/18/2016	5/17/2016
10443720004368220	164,805	$ 2,690.00	5/17/2016	6/16/2016
10443720004368220	198,922	$ 2,785.46	6/16/2016	7/18/2016
10443720004368220	192,325	$ 2,826.76	7/18/2016	8/17/2016
10443720004368220	163,124	$ 2,600.24	8/17/2016	9/16/2016
10443720004368220	146,950	$ 2,597.10	9/16/2016	10/17/2016
10443720004840438	900	$ 735.30	10/6/2015	11/4/2015
10443720004840438	300	$ 311.05	11/4/2015	12/7/2015
10443720004840438	300	$ 390.07	12/7/2015	1/7/2016
10443720004840438	150	$ 351.72	1/7/2016	2/5/2016
10443720004840438	600	$ 694.15	2/5/2016	3/7/2016
10443720004840438	300	$ 694.01	3/7/2016	4/6/2016
10443720004840438	600	$ 402.91	4/6/2016	5/5/2016
10443720004840438	900	$ 280.90	5/5/2016	6/6/2016
10443720004840438	1,200	$ 290.44	6/6/2016	7/6/2016
10443720004840438	750	$ 318.41	7/6/2016	8/4/2016
10443720004840438	750	$ 290.72	8/4/2016	9/6/2016
10443720004840438	750	$ 875.97	9/6/2016	10/5/2016
10443720004840469	632,422	$ 13,246.13	10/7/2015	11/5/2015
10443720004840469	609,950	$ 12,454.34	11/5/2015	12/8/2015
10443720004840469	554,407	$ 13,138.11	12/8/2015	1/8/2016
10443720004840469	555,380	$ 13,138.85	1/8/2016	2/8/2016
10443720004840469	530,465	$ 13,162.18	2/8/2016	3/8/2016
10443720004840469	571,645	$ 13,161.97	3/8/2016	4/7/2016
10443720004840469	576,757	$ 12,989.29	4/7/2016	5/6/2016
10443720004840469	676,221	$ 13,402.37	5/6/2016	6/7/2016
10443720004840469	744,325	$ 14,338.56	6/7/2016	7/7/2016
10443720004840469	776,993	$ 14,105.97	7/7/2016	8/5/2016
10443720004840469	867,322	$ 15,546.68	8/5/2016	9/7/2016
10443720004840469	728,409	$ 15,369.51	9/7/2016	10/6/2016
10443720006184071	28	$ 10.10	10/6/2015	11/4/2015
10443720006184071	- 0	$ 9.29	11/4/2015	12/7/2015
10443720006184071	- 0	$ 9.29	12/7/2015	1/7/2016
10443720006184071	- 0	$ 9.29	1/7/2016	2/5/2016
10443720006184071	- 0	$ 9.29	2/5/2016	3/7/2016
10443720006184071	1	$ 9.32	3/7/2016	4/6/2016
10443720006184071	- 0	$ 9.29	4/6/2016	5/5/2016
10443720006184071	5	$ 9.43	5/5/2016	6/6/2016
10443720006184071	- 0	$ 9.29	6/6/2016	7/6/2016
10443720006184071	6	$ 9.46	7/6/2016	8/4/2016
10443720006184071	- 0	$ 9.29	8/4/2016	9/6/2016
10443720006184071	7	$ 9.49	9/6/2016	10/5/2016
10443720006772797	923,225	$ 13,047.88	10/22/2015	11/20/2015
10443720006772797	993,428	$ 13,002.23	11/20/2015	12/22/2015
10443720006772797	1,059,125	$ 12,346.28	12/22/2015	1/25/2016
10443720006772797	923,010	$ 12,353.18	1/25/2016	2/23/2016
10443720006772797	904,184	$ 12,818.83	2/23/2016	3/23/2016
10443720006772797	937,822	$ 12,782.51	3/23/2016	4/22/2016
10443720006772797	972,068	$ 12,478.37	4/22/2016	5/23/2016
10443720006772797	954,973	$ 12,647.84	5/23/2016	6/22/2016
10443720006772797	977,086	$ 12,742.22	6/22/2016	7/22/2016
10443720006772797	1,061,868	$ 12,856.50	7/22/2016	8/23/2016
10443720006772797	981,146	$ 12,820.80	8/23/2016	9/22/2016
10443720006772797	915,642	$ 12,675.01	9/22/2016	10/21/2016
10443720007044667	190,451	$ 4,289.72	10/22/2015	11/20/2015
10443720007044667	199,262	$ 4,292.83	11/20/2015	12/22/2015
10443720007044667	157,688	$ 4,183.02	12/22/2015	1/25/2016
10443720007044667	168,096	$ 4,186.70	1/25/2016	2/23/2016
10443720007044667	176,774	$ 4,345.02	2/23/2016	3/23/2016
10443720007044667	192,577	$ 4,422.83	3/23/2016	4/22/2016
10443720007044667	192,113	$ 4,251.65	4/22/2016	5/23/2016
10443720007044667	244,310	$ 4,554.89	5/23/2016	6/22/2016
10443720007044667	298,485	$ 4,548.72	6/22/2016	7/22/2016
10443720007044667	316,479	$ 4,450.59	7/22/2016	8/23/2016
10443720007044667	275,506	$ 4,321.71	8/23/2016	9/22/2016
10443720007044667	218,086	$ 4,076.77	9/22/2016	10/21/2016
10443720007547301	2,556	$ 83.53	10/22/2015	11/20/2015
10443720007547301	2,886	$ 93.09	11/20/2015	12/22/2015
10443720007547301	2,644	$ 83.62	12/22/2015	1/25/2016
10443720007547301	1,749	$ 58.45	1/25/2016	2/23/2016
10443720007547301	1,607	$ 56.52	2/23/2016	3/23/2016
10443720007547301	1,561	$ 55.17	3/23/2016	4/22/2016
10443720007547301	1,492	$ 51.94	4/22/2016	5/23/2016
10443720007547301	1,365	$ 48.30	5/23/2016	6/22/2016
10443720007547301	1,610	$ 55.31	6/22/2016	7/22/2016
10443720007547301	2,847	$ 90.66	7/22/2016	8/23/2016
10443720007547301	1,613	$ 57.05	8/23/2016	9/22/2016
10443720008744428	2,181	$ 123.53	10/22/2015	11/20/2015
10443720008744428	3,235	$ 132.07	11/20/2015	12/22/2015
10443720008744428	3,514	$ 146.91	12/22/2015	1/25/2016
10443720008744428	2,954	$ 154.75	1/25/2016	2/23/2016
10443720008744428	2,922	$ 154.26	2/23/2016	3/23/2016
10443720008744428	2,842	$ 146.22	3/23/2016	4/22/2016
10443720008744428	1,958	$ 111.10	4/22/2016	5/23/2016
10443720008744428	1,937	$ 111.09	5/23/2016	6/22/2016
10443720008744428	2,363	$ 119.01	6/22/2016	7/22/2016
10443720008744428	3,189	$ 119.39	7/22/2016	8/23/2016
10443720008744428	3,040	$ 125.75	8/23/2016	9/22/2016
10443720008744428	1,886	$ 116.91	9/22/2016	10/21/2016
10443720008934334	- 0	$ 9.29	10/22/2015	11/20/2015
10443720008934334	- 0	$ 9.29	11/20/2015	12/22/2015
10443720008934334	- 0	$ 9.29	12/22/2015	1/25/2016
10443720008934334	- 0	$ 9.29	1/25/2016	2/23/2016
10443720008934334	- 0	$ 9.29	2/23/2016	3/23/2016
10443720008934334	- 0	$ 9.29	3/23/2016	4/22/2016
10443720008934334	- 0	$ 9.29	4/22/2016	5/23/2016
10443720008934334	- 0	$ 9.29	5/23/2016	6/22/2016
10443720008934334	- 0	$ 9.29	6/22/2016	7/22/2016
10443720008934334	- 0	$ 9.29	7/22/2016	8/23/2016
10443720008934334	- 0	$ 9.29	8/23/2016	9/22/2016
10443720008934334	- 0	$ 9.29	9/22/2016	10/21/2016
TOTAL	32,745,584	$ 555,626.75
TDSP	AVG $/kWh	$ 0.01697

TEXAS 2017 Attachment C

Eval Methodology SPE600-16-R-0414

CLIN 0002 EVAL

CLIN	CUSTOMER	ESI ID	SERVICE ADDRESS	INCORPORATED CITY/TOWN	U.S CENSUS JULY 1 2015 POPULATION ESTIMATE	Applicable GRT Rate	Applicable PUCA Rate	12 MONTH TOTAL kWh	24 MONTH kWh ESTIMATE	PERCENT OF TOTAL ESTIMATED QUANTITY	ADJUSTED GRT/PUC RATE	OFFEROR AUCTION PRICE per kWh	ADJUSTMENT TO OFFERED PRICE	EVALUATED PRICE per kWh	TOTAL EVALUATED PRICE	OFFEROR 24 MONTH BID (gross receipts)	PUCA (% gross receipts) 0.001667	GRT (% gross receipts) (rates / population ) 0.00581 for 1-2.5K 0.0107 for 2.5 to 10K 0.01997 for > 10K	OFFEROR 24 MONTH BID WITH PUCA & GRT TOTAL
CLIN 0002	DYESS AIR FORCE BASE	ESI ID# 10204049777217140	Abilene Unit Marion, Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	31,686	63,372	0.05%	0.0011%
		ESI ID# 10204049722266680	Abilene Unit Midlmrk, Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	- 0	- 0	0.00%	0.0000%
		ESI ID# 10204049703156330	Dyess, Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	19,721	39,442	0.03%	0.0007%
		ESI ID# 10204049768362900	DYESS UNIT HRITA, Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	22,793	45,586	0.04%	0.0008%
		ESI ID# 10204049771827515	Dyess AFB Unit Sub 2, 2 Military Dr., Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	45,943,011	91,886,022	72.40%	1.5666%
		ESI ID# 10204049790399991	Dyess AFB Unit Sub 3, 3 Millitary Dr., Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	5,206,235	10,412,470	8.20%	0.1775%
		ESI ID# 10204049794837267	Dyess AFB Unit Sub 1, 1 Military Dr., Abilene, TX 79607	ABILENE	121,721	1.997%	0.1667%	11,566,520	23,133,040	18.23%	0.3944%
		ESI ID# 10443720006948383	03199 Fm 1607, Snyder, TX 79549	SNYDER	11,768	1.997%	0.1667%	360,240	720,480	0.57%	0.0123%
		ESI ID# 10443720006963449	4651 Fm 1610, Snyder, TX 79549	SNYDER	11,768	1.997%	0.1667%	117,200	234,400	0.18%	0.0040%
									126,534,812							$ 4,373,043.10

ESI ID# 10204049742989121	FM 576 W UNIT NEXRA, Moran, TX 76430	MORAN (closest)	268	0.000%	0.1667%	186,214	372,428	0.29%	0.0005%
										↓↓Offerored Price↓↓	↓↓Supply Adj↓↓
						63,453,620	126,907,240	100.00%	2.1578%	$0.03456	$0.00075	$0.03530575	$ 4,480,555.20	$ 4,385,914.21	$ 7,311.32	$ 87,329.67	$ 4,480,555.20
									↑↑Adj GRT/PUC Rate↑↑	$0.00856	$0.00018	←TDSP Adj
	Population	GRT Rates	PUC Rate							↑↑Est TDSP Rate↑↑	$0.00093	$0.03549	$4,504,000.03
	Greater than 1,000 but less than 2,500	0.581%	0.1667%								↑↑Total Offer Adj↑↑	↑↑Evaluated Rate / Price↑↑
	2,500 or more but less than 10,000	1.070%	0.1667%
	10,000 or more	1.997%	0.1667%

TEXAS 2017 Attachment C

Eval Methodology SPE600-16-R-0414

CLIN 0002 TDSP

ESI ID	Actual KWH	TDSP Charges	Start Date	End Date
10204049703156330	424	$ 79.94	9/3/15	10/2/15
10204049703156330	372	$ 73.26	10/3/15	11/2/15
10204049703156330	378	$ 72.95	11/3/15	12/3/15
10204049703156330	389	$ 71.68	12/4/15	1/6/16
10204049703156330	317	$ 70.99	1/7/16	2/4/16
10204049703156330	348	$ 71.94	2/5/16	3/4/16
10204049703156330	472	$ 74.74	3/5/16	4/5/16
10204049703156330	509	$ 74.76	4/6/16	5/4/16
10204049703156330	483	$ 74.13	5/5/16	6/3/16
10204049703156330	676	$ 77.33	6/4/16	7/5/16
10204049703156330	1,045	$ 85.27	7/6/16	8/3/16
10204049703156330	508	$ 63.32	8/4/16	9/1/16
10204049703156330	1,213	$ 75.24	9/2/16	10/3/16
10204049722266680	- 0	$ 16.15	9/3/15	10/2/15
10204049722266680	- 0	$ 16.15	10/3/15	11/2/15
10204049722266680	- 0	$ 16.15	11/3/15	12/3/15
10204049722266680	- 0	$ 16.15	12/4/15	1/6/16
10204049722266680	- 0	$ 16.15	1/7/16	2/4/16
10204049722266680	- 0	$ 16.15	2/5/16	3/4/16
10204049722266680	- 0	$ 16.15	3/5/16	4/5/16
10204049722266680	- 0	$ 16.15	4/6/16	5/4/16
10204049722266680	- 0	$ 16.15	5/5/16	6/3/16
10204049722266680	- 0	$ 16.15	6/4/16	7/5/16
10204049722266680	- 0	$ 16.15	7/6/16	8/3/16
10204049722266680	- 0	$ 16.15	8/4/16	9/1/16
10204049722266680	- 0	$ 16.15	9/2/16	10/3/16
10204049742989121	15,879	$ 219.00	9/19/15	10/19/15
10204049742989121	14,073	$ 210.30	10/20/15	11/17/15
10204049742989121	13,287	$ 207.91	11/18/15	12/18/15
10204049742989121	16,395	$ 197.31	12/19/15	1/21/16
10204049742989121	14,332	$ 199.28	1/22/16	2/19/16
10204049742989121	14,910	$ 200.30	2/20/16	3/21/16
10204049742989121	15,427	$ 201.81	3/22/16	4/20/16
10204049742989121	15,257	$ 220.04	4/21/16	5/19/16
10204049742989121	18,759	$ 234.39	5/20/16	6/20/16
10204049742989121	18,274	$ 244.89	6/21/16	7/20/16
10204049742989121	14,035	$ 245.94	7/21/16	8/18/16
10204049742989121	19,699	$ 260.54	8/19/16	9/19/16
10204049742989121	16,718	$ 259.07	9/20/16	10/18/16
10204049768362900	870	$ 99.94	9/3/15	10/2/15
10204049768362900	694	$ 131.95	10/3/15	11/2/15
10204049768362900	2,679	$ 190.29	11/3/15	12/3/15
10204049768362900	4,164	$ 178.78	12/4/15	1/6/16
10204049768362900	5,214	$ 155.87	1/7/16	2/4/16
10204049768362900	3,002	$ 155.02	2/5/16	3/4/16
10204049768362900	1,310	$ 153.57	3/5/16	4/5/16
10204049768362900	1,161	$ 109.12	4/6/16	5/4/16
10204049768362900	1,221	$ 120.94	5/5/16	6/3/16
10204049768362900	2,570	$ 122.85	6/4/16	7/5/16
10204049768362900	2,700	$ 122.60	7/6/16	8/3/16
10204049768362900	2,270	$ 136.27	8/4/16	9/1/16
10204049768362900	1,987	$ 135.12	9/2/16	10/2/16
10204049771827515	4,716,000	$ 21,237.92	9/3/15	10/2/15
10204049771827515	4,240,800	$ 19,574.20	10/3/15	11/2/15
10204049771827515	3,909,600	$ 19,383.11	11/3/15	12/3/15
10204049771827515	4,183,200	$ 16,035.09	12/4/15	1/6/16
10204049771827515	3,715,200	$ 16,049.60	1/7/16	2/4/16
10204049771827515	3,679,200	$ 16,174.61	2/5/16	3/4/16
10204049771827515	3,967,200	$ 16,173.17	3/5/16	4/5/16
10204049771827515	3,592,800	$ 16,175.05	4/6/16	5/4/16
10204049771827515	4,111,200	$ 17,185.96	5/5/16	6/3/16
10204049771827515	5,162,400	$ 18,859.17	6/4/16	7/5/16
10204049771827515	5,169,600	$ 19,801.20	7/6/16	8/3/16
10204049771827515	4,528,800	$ 22,688.09	8/4/16	9/1/16
10204049771827515	4,953,600	$ 21,292.89	9/2/16	10/3/16
10204049777217140	3,000	$ 107.26	9/3/15	10/2/15
10204049777217140	1,200	$ 100.96	10/3/15	11/2/15
10204049777217140	2,400	$ 106.87	11/3/15	12/3/15
10204049777217140	3,000	$ 121.81	12/4/15	1/6/16
10204049777217140	3,000	$ 128.68	1/7/16	2/4/16
10204049777217140	3,000	$ 129.36	2/5/16	3/4/16
10204049777217140	3,000	$ 122.42	3/5/16	4/5/16
10204049777217140	1,800	$ 110.48	4/6/16	5/4/16
10204049777217140	2,400	$ 114.55	5/5/16	6/3/16
10204049777217140	3,000	$ 111.06	6/4/16	7/5/16
10204049777217140	3,600	$ 125.87	7/6/16	8/3/16
10204049777217140	3,000	$ 222.82	8/4/16	9/1/16
10204049777217140	2,400	$ 220.37	9/2/16	10/3/16
10204049790399991	- 0	$ 9,951.47	9/3/15	10/2/15
10204049790399991	- 0	$ 7,783.46	10/3/15	11/2/15
10204049790399991	- 0	$ 7,783.46	11/3/15	12/3/15
10204049790399991	- 0	$ 7,794.03	12/4/15	1/6/16
10204049790399991	- 0	$ 7,794.03	1/7/16	2/4/16
10204049790399991	- 0	$ 7,794.27	2/5/16	3/4/16
10204049790399991	- 0	$ 7,794.27	3/5/16	4/5/16
10204049790399991	165,600	$ 11,304.15	4/6/16	5/4/16
10204049790399991	- 0	$ 9,085.08	5/5/16	6/3/16
10204049790399991	- 0	$ 9,085.08	6/4/16	7/5/16
10204049790399991	- 0	$ 9,085.08	7/6/16	8/3/16
10204049790399991	338,400	$ 17,720.15	8/4/16	9/1/16
10204049790399991	- 0	$ 14,218.55	9/2/16	10/3/16
10204049794837267	1,272,000	$ 16,515.93	9/3/15	10/2/15
10204049794837267	931,200	$ 15,775.81	10/3/15	11/2/15
10204049794837267	720,000	$ 15,556.94	11/3/15	12/3/15
10204049794837267	806,400	$ 15,890.10	12/4/15	1/6/16
10204049794837267	648,000	$ 15,895.01	1/7/16	2/4/16
10204049794837267	633,600	$ 16,152.14	2/5/16	3/4/16
10204049794837267	715,200	$ 16,151.73	3/5/16	4/5/16
10204049794837267	734,400	$ 16,151.64	4/6/16	5/4/16
10204049794837267	936,000	$ 16,274.90	5/5/16	6/3/16
10204049794837267	1,363,200	$ 17,059.73	6/4/16	7/5/16
10204049794837267	1,488,000	$ 17,253.88	7/6/16	8/3/16
10204049794837267	1,353,600	$ 18,495.19	8/4/16	9/1/16
10204049794837267	1,224,000	$ 17,324.85	9/2/16	10/3/16
10443720006948383	28,000	$ 696.25	10/6/2015	11/4/2015
10443720006948383	32,280	$ 665.08	11/4/2015	12/7/2015
10443720006948383	30,720	$ 567.21	12/7/2015	1/7/2016
10443720006948383	30,080	$ 566.99	1/7/2016	2/5/2016
10443720006948383	25,400	$ 523.62	2/5/2016	3/7/2016
10443720006948383	23,600	$ 545.85	3/7/2016	4/6/2016
10443720006948383	23,840	$ 525.30	4/6/2016	5/5/2016
10443720006948383	27,320	$ 555.54	5/5/2016	6/6/2016
10443720006948383	28,360	$ 563.75	6/6/2016	7/6/2016
10443720006948383	33,000	$ 704.99	7/6/2016	8/4/2016
10443720006948383	37,120	$ 773.13	8/4/2016	9/6/2016
10443720006948383	28,640	$ 636.24	9/6/2016	10/5/2016
10443720006963449	9,880	$ 192.83	10/1/2015	10/30/2015
10443720006963449	10,400	$ 189.54	10/30/2015	12/2/2015
10443720006963449	10,440	$ 179.20	12/2/2015	1/4/2016
10443720006963449	9,160	$ 164.99	1/4/2016	2/2/2016
10443720006963449	9,720	$ 173.37	2/2/2016	3/2/2016
10443720006963449	9,880	$ 165.45	3/2/2016	4/1/2016
10443720006963449	9,880	$ 168.83	4/1/2016	5/2/2016
10443720006963449	9,680	$ 168.74	5/2/2016	6/1/2016
10443720006963449	9,560	$ 176.42	6/1/2016	6/30/2016
10443720006963449	10,960	$ 161.61	6/30/2016	8/1/2016
10443720006963449	10,000	$ 161.17	8/1/2016	8/31/2016
10443720006963449	10,120	$ 187.18	8/31/2016	9/30/2016
TOTAL	70,006,061	$ 599,345.38
TDSP	AVG $/kWh	$ 0.00856

TEXAS 2017 Attachment C

Eval Methodology SPE600-16-R-0414

CLIN 0008 EVAL

CLIN	CUSTOMER	ESI ID	SERVICE ADDRESS	INCORPORATED CITY/TOWN	U.S CENSUS JULY 1 2015 POPULATION ESTIMATE	Applicable GRT Rate	Applicable PUCA Rate	12 MONTH TOTAL kWh	24 MONTH kWh ESTIMATE	PERCENT OF TOTAL ESTIMATED QUANTITY	ADJUSTED GRT/PUC RATE	OFFEROR AUCTION PRICE per kWh	ADJUSTMENT TO OFFERED PRICE	EVALUATED PRICE per kWh	TOTAL EVALUATED PRICE	OFFEROR 24 MONTH BID (gross receipts)	PUCA (% gross receipts) 0.001667	GRT (% gross receipts) (rates / population) 0.00581 for 1-2.5K 0.0107 for 2.5 to 10K 0.01997 for > 10K	OFFEROR 24 MONTH BID WITH PUCA & GRT BY TOWN/CITY	OFFEROR 24 MONTH BID WITH PUCA & GRT TOTAL
												↓↓Offerored Price↓↓	↓↓Supply Adj↓↓
CLIN 0008	MCRC GALVESTON	ESI ID# 1008901023813192070102	2 FORT POINT # 6B , GALVESTON, TX 77550	GALVESTON	50,180	1.997%	0.1667%	441,900	883,800	100%	2.1637%	$0.03456	$0.00075	$0.03531	$31,205.01	$ 30,544.13	$ 50.92	$ 609.97	$ 31,205.01	$ 31,205.01
											↑↑Adj GRT/PUC Rate↑↑	$0.02686	$0.00058	←TDSP Adj
			Population	GRT Rates	PUC Rate							↑↑Est TDSP Rate↑↑	$0.00133	$0.03589	$31,718.69
			Greater than 1,000 but less than 2,500	0.581%	0.1667%								↑↑Total Offer Adj↑↑	↑↑Evaluated Rate / Price↑↑
			2,500 or more but less than 10,000	1.070%	0.1667%
			10,000 or more	1.997%	0.1667%

TEXAS 2017 Attachment C

Eval Methodology SPE600-16-R-0414

CLIN 0008 TDSP

ESI ID	Actual KWH	TDSP Charges	Start Date	End Date
1008901023813192070102	33,000	$ 1,088.12	10/24/15	11/23/15
1008901023813192070102	37,500	$ 1,139.14	11/24/15	12/28/15
1008901023813192070102	34,500	$ 1,221.89	12/29/15	1/27/16
1008901023813192070102	45,300	$ 1,337.04	1/28/16	2/25/16
1008901023813192070102	47,700	$ 1,350.96	2/26/16	3/28/16
1008901023813192070102	49,500	$ 1,326.20	3/29/16	4/26/16
1008901023813192070102	47,700	$ 1,262.30	4/27/16	5/25/16
1008901023813192070102	38,400	$ 1,055.54	5/26/16	6/24/16
1008901023813192070102	59,700	$ 1,321.17	6/25/16	7/26/16
1008901023813192070102	58,800	$ 1,312.29	7/27/16	8/24/16
1008901023813192070102	60,300	$ 1,349.57	8/25/16	9/23/16
TOTAL	512,400	$ 13,764.22
TDSP	AVG $/kWh	$ 0.02686

TEXAS 2017 Attachment C

Eval Methodology SPE600-16-R-0414

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