Hughes_Financial_Analysis_02.02.26.xlsx

This is a Purchase Order Data spreadsheet from Pinellas County, Florida documenting fiscal year 2023 transactions across multiple county departments and operational sections. The file contains detailed records of 120+ purchase orders issued to various vendors for maintenance, repairs, supplies, and services supporting county facilities including detention centers, administrative offices, courthouses, and operational buildings. Products and services span multiple categories including elevator maintenance, equipment leasing, janitorial services, pest control, plumbing services, HVAC systems, roofing, fencing, landscaping, and specialized consulting services. Purchase orders range in value from under $10 to over $760,000, with most transactions occurring between October 2022 and February 2023. The majority of purchase orders are marked as "Cancelled" or "Closed," indicating completed transactions within the fiscal year 2023 period. Contract terms vary significantly by vendor and service type, with some contracts extending through 2026 and others carrying specific end dates tied to service completion.

Pricing structures within the purchase orders reflect diverse compensation models including fixed unit prices, hourly labor rates ranging from $7.50 to $150 per hour, cost-plus arrangements with percentage markups (typically 10-20%), and monthly lease charges. The file identifies multiple incumbents providing ongoing services, particularly Schindler Elevator Corporation for elevator maintenance, Sprinklermatic Florida LLC for irrigation services, Johnson Controls Inc for HVAC services, and American Facility Services Inc for janitorial operations. Funding is distributed across multiple cost centers and accounts aligned with operational sections including the Jail Section, Mid-County Section, Northwest Section, Southeast Section, and Real Property Leases. The data demonstrates substantial capital allocation to facility operations and maintenance, with cumulative spending across captured transactions exceeding $3.8 million. No specific set-asides are documented in this operational data file, though the county's stated commitment to supporting local vendors is evidenced by the inclusion of numerous locally-based suppliers in procurement decisions.