Pricing_Spreadsheet.xlsx

This is a pricing spreadsheet for a boiler maintenance and repair contract with Pinellas County, Florida, covering preventative maintenance services across multiple county facilities. The contract encompasses four scheduled inspections per boiler annually—one major annual inspection and three minor quarterly safety inspections—performed at three-month intervals beginning at contract inception. Services are required at three distinct location groups: Group A (DET facility in Clearwater with multiple boiler systems across various departments), Group B (MID facilities in Largo including the Gulf Coast Museum of Art, Animal Services, Medical Examiner, and Veterinary Technical facilities), and Group C (Utilities at Logan Lab in Largo). The preventative maintenance program includes monthly site visits, quarterly and annual inspections, and all associated reporting requirements including written reports and monthly logs. The contract term is five years, with the county maintaining the right to require separate invoicing and prior approval for any repairs, equipment, or parts not associated with the preventative maintenance program discovered during routine inspections.

The pricing spreadsheet itemizes costs for 50 boiler maintenance line items across the three facility groups, with an estimated annual parts spend of $50,000 (totaling $250,000 over the five-year term). Additional pricing is required for regular hourly service calls (7:00 AM–3:30 PM, estimated at 500 annual hours) and after-hours service calls including evenings, weekends, and holidays (estimated at 500 annual hours). The spreadsheet also includes a parts discount percentage provision off list pricing. The current contract total is estimated at $50,000 annually with a five-year term total of $250,000, plus an unspecified contingency of 10 percent ($25,000 annually, $275,000 over five years) designated as a not-to-exceed amount that will not be used to determine contract award.