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
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.26 | Term: 7.1.23 - 6.30.24 | Term: 7.1.24 - 6.30.25 | Term: 7.1.25 - 6.30.26 | ||||||||||||
| AP Business Unit | No. of POs | No. of Vouchers | AP Amount | AP Business Unit | No. of POs | No. of Vouchers | AP Amount | AP Business Unit | No. of POs | No. of Vouchers | AP Amount | AP Business Unit | No. of POs | No. of Vouchers | AP Amount |
| DOTM1 | 37 | 534 | 1,091,586.55 | DOTM1 | 4 | 289 | 409,747.72 | DOTM1 | 18 | 163 | 350,934.87 | DOTM1 | 15 | 82 | 330,903.96 |
| DEPM1 | 96 | 1080 | 380,626.81 | DEPM1 | 45 | 414 | 151,772.48 | DEPM1 | 30 | 340 | 97,121.90 | DEPM1 | 21 | 326 | 131,732.43 |
| MHAM1 | 1 | 149 | 93,951.65 | MHAM1 | 1 | 47 | 28,571.90 | MHAM1 | 51 | 31,618.50 | MHAM1 | 51 | 33,761.25 | ||
| DOCM1 | 67 | 171 | 87,797.50 | DOCM1 | 20 | 50 | 21,584.30 | DOCM1 | 14 | 56 | 38,090.90 | DOCM1 | 33 | 65 | 28,122.30 |
| DCFM1 | 6 | 152 | 30,676.25 | DCFM1 | 1 | 52 | 10,287.50 | DCFM1 | 4 | 57 | 11,472.00 | DCFM1 | 1 | 43 | 8,916.75 |
| ECDM1 | 4 | 22 | 4,009.25 | ECDM1 | 2 | 10 | 1,780.25 | ECDM1 | 7 | 1,381.25 | ECDM1 | 2 | 5 | 847.75 | |
| MILM1 | 4 | 10 | 1,729.00 | MILM1 | 3 | 3 | 776.00 | MILM1 | 1 | 2 | 444.00 | MILM1 | 5 | 509.00 | |
| DASM1 | 1 | 11 | 737.25 | DASM1 | 11 | 737.25 | DASM1 | 1 | DASM1 | ||||||
| DDSM1 | 1 | 1 | 150.50 | DDSM1 | DDSM1 | DDSM1 | 1 | 1 | 150.50 | ||||||
| Grand Total | 217 | 2130 | 1,691,264.76 | Grand Total | 76 | 876 | 625,257.40 | Grand Total | 68 | 676 | 531,063.42 | Grand Total | 73 | 578 | 534,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 | |||||||||||||||
| DOTM1 | Department of Transportation | ||||||||||||||
| DEPM1 | Department of Energy & Environmental Protection | ||||||||||||||
| MHAM1 | Department of Mental Health and Addiction Service | ||||||||||||||
| DOCM1 | Department of Correction | ||||||||||||||
| DCFM1 | Department of Children and Families | ||||||||||||||
| ECDM1 | Department of Economic and Community Development | ||||||||||||||
| MILM1 | Connecticut Military Department | ||||||||||||||
| DASM1 | Department of Administrative Services | ||||||||||||||
| DDSM1 | Department of Developmental Services |
File details come from the government source that posted it. Updated .