26PSX0023 Addendum 3 Data.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Environmental Analytical Services
Solicitation number
26PSX0023
Issued by
Hartford County, Connecticut

About this file

Addendum 3 Data Summary for Environmental Analytical Services Contract 26PSX0023

This is an expenditure data sheet documenting usage of Connecticut's Environmental Analytical Services blanket order contract (26PSX0023) by various State of Connecticut Executive Branch agencies across the contract term of July 1, 2023 through June 30, 2026. The data is segmented into three performance periods: Year 1 (7/1/23–6/30/24), Year 2 (7/1/24–6/30/25), and Year 3 (7/1/25–6/30/26). The contract has generated significant utilization, with a combined total of 217 purchase orders (POs) and 2,130 vouchers totaling $1,691,264.76 in expenditures across the full term. The data explicitly notes that PO-to-voucher ratios differ due to the blanket order structure and that this data represents only State of Connecticut Executive Branch spending and does not include municipalities, non-profit organizations, educational entities, or laboratory services paid through contracted consultants.

Ten state agencies accessed the contract, with the Department of Transportation (DOTM1) accounting for the largest share at $1,091,586.55, followed by the Department of Energy and Environmental Protection (DEPM1) at $380,626.81. Additional using agencies included the Department of Mental Health and Addiction Services, Department of Correction, Department of Children and Families, Department of Economic and Community Development, Connecticut Military Department, Department of Administrative Services, and Department of Developmental Services. Expenditure patterns show decreasing usage in Years 2 and 3 relative to Year 1, with Year 2 totaling $625,257.40 and Year 3 totaling $534,943.94. The data documentation explicitly acknowledges that significant expenditures for laboratory services with contracted providers paid through contracted consultants are not reflected in these figures and are not readily available.

View the file

Other files

File Type Posted
Exhibit B Schedule 4 PFAS Methods.xlsx XLSX spreadsheet
26PSX0023 Addendum 2.pdf PDF
Exhibit B Schedule 2 SW846 Methods 8.3.26.xlsx XLSX spreadsheet
26PSX0023_Aug_17_26_solicitation_doc.pdf PDF
26PSX0023_Aug_27_26_solicitation_doc.pdf PDF
26PSX0023_Sep_4_26_solicitation_doc.pdf PDF
26PSX0023_Sep_24_26_solicitation_doc.pdf PDF
26PSX0023_Oct_2_26_solicitation_doc.pdf PDF
26PSX0023_Oct_7_26_solicitation_doc.pdf PDF
Exhibit B Schedule 3 Wastewater Methods 40 CFR Part 136.xlsx XLSX spreadsheet
Exhibit B Schedule 5 Tissue Analysis.xlsx XLSX spreadsheet
Exhibit B Schedule 1 Drinking Water Methods.xlsx XLSX spreadsheet
26PSX0023_Jul_2_26_solicitation_doc.pdf PDF
26PSX0023 Contract Document GS V13 8.3.26.pdf PDF
PROSPECTIVE BIDDERS - 6.pdf PDF
26PSX0023_Sep_1_26_solicitation_doc.pdf PDF
26PSX0023_Sep_10_26_solicitation_doc.pdf PDF
26PSX0023_Oct_13_26_solicitation_doc.pdf PDF
26PSX0023 Environmental Analytical Services.pdf PDF
26PSX0023_Aug_10_26_solicitation_doc.pdf PDF
Exhibit B Schedule 6 Miscellaneous Costs 8.3.26.xlsx XLSX spreadsheet
26PSX0023_Aug_21_26_solicitation_doc.pdf PDF
26PSX0023_Aug_28_26_solicitation_doc.pdf PDF
26PSX0023_Sep_16_26_solicitation_doc.pdf PDF
Exhibit B Schedule 6 Miscellaneous Costs.xlsx XLSX spreadsheet
Exhibit B Schedule 2 SW846 Methods.xlsx XLSX spreadsheet
26PSX0023 Addendum 1.pdf PDF
26PSX0023 Addendum 4.pdf PDF
26PSX0023 Addendum 3.pdf PDF
26PSX0023_Aug_19_26_solicitation_doc.pdf PDF
26PSX0023_Sep_11_26_solicitation_doc.pdf PDF
26PSX0023_Sep_17_26_solicitation_doc.pdf PDF
26PSX0023_Oct_8_26_solicitation_doc.pdf PDF
26PSX0023_Oct_15_26_solicitation_doc.pdf PDF
Show all 34

On GovTribe

Work with this file

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

Text version

Sheet1

Please note: PO to Voucher ratio differs due to blanket order issuance.
Term: 7.1.23 - 6.30.26Term: 7.1.23 - 6.30.24Term: 7.1.24 - 6.30.25Term: 7.1.25 - 6.30.26
AP Business UnitNo. of POsNo. of VouchersAP AmountAP Business UnitNo. of POsNo. of VouchersAP AmountAP Business UnitNo. of POsNo. of VouchersAP AmountAP Business UnitNo. of POsNo. of VouchersAP Amount
DOTM1375341,091,586.55DOTM14289409,747.72DOTM118163350,934.87DOTM11582330,903.96
DEPM1961080380,626.81DEPM145414151,772.48DEPM13034097,121.90DEPM121326131,732.43
MHAM1114993,951.65MHAM114728,571.90MHAM15131,618.50MHAM15133,761.25
DOCM16717187,797.50DOCM1205021,584.30DOCM1145638,090.90DOCM1336528,122.30
DCFM1615230,676.25DCFM115210,287.50DCFM145711,472.00DCFM11438,916.75
ECDM14224,009.25ECDM12101,780.25ECDM171,381.25ECDM125847.75
MILM14101,729.00MILM133776.00MILM112444.00MILM15509.00
DASM1111737.25DASM111737.25DASM11DASM1
DDSM111150.50DDSM1DDSM1DDSM111150.50
Grand Total21721301,691,264.76Grand Total76876625,257.40Grand Total68676531,063.42Grand Total73578534,943.94
This is only State of CT Executive Branch expenditures. This does not include all other using entities such as municipalities, non-profit, education, etc.
This also does not reflect expenditures for lab services with contracted providers paid through contracted consultants. This data is not readily available however it is rather significant.
AP Business Units
DOTM1Department of Transportation
DEPM1Department of Energy & Environmental Protection
MHAM1Department of Mental Health and Addiction Service
DOCM1Department of Correction
DCFM1Department of Children and Families
ECDM1Department of Economic and Community Development
MILM1Connecticut Military Department
DASM1Department of Administrative Services
DDSM1Department of Developmental Services

File details come from the government source that posted it. Updated .