Summary

This is a purchase order analysis spreadsheet for Pinellas County, Florida, documenting fiscal year 2023 transactions across multiple service categories and vendors. The file contains detailed records of approximately 800+ purchase orders issued between October 2022 and December 2022, covering operations and maintenance activities across the county's facilities including administrative buildings, detention facilities, parks, and other county-owned properties. The services procured include elevator maintenance, carpet cleaning, facility management, roofing services, plumbing repairs, HVAC maintenance, landscaping, electrical supplies, pest control, janitorial services, and various other facilities and operations support functions. The purchase orders reflect both one-time emergency service calls and ongoing blanket purchase agreements with vendors, with individual order values ranging from less than $100 to over $750,000.

The spreadsheet documents approved amounts, billed amounts, and encumbered balances for each line item, with the majority of orders showing complete billing status. Notable vendors include Schindler Elevator Corporation, Johnson Controls Inc., American Facility Services Inc., W.W. Grainger Inc., Advanced Roofing Inc., and Sprinklermatic Florida LLC, among others. Most purchase orders are classified as "Cancelled" or "Closed" status, indicating completed transactions. The funds are allocated across multiple cost centers representing different county departments and sections (Northwest, Southeast, Mid-County operations, detention facilities, real property leases, and asset management), with contract periods varying from short-term service calls to multi-year blanket purchase agreements extending through 2026 and 2027. The data reflects the county's ongoing commitment to maintaining its infrastructure and facilities through a diverse vendor network providing specialized maintenance and repair services.