Copy_of_Sweeper_Lease_Budget_Estimate_rev_2-19-25_(for_review).xlsx

XLSX spreadsheet 20 KB Posted

Attached to
Street Sweeping Lease
Solicitation number
25-0398-ITB
Issued by
Pinellas County, Florida

About this file

This is a budget estimate spreadsheet for a lease of street sweepers, likely for a municipal or county public works department. The document outlines a four-year contract for leasing two street sweepers with full maintenance services, including associated equipment like gutter brooms and pickup brooms. The total estimated contract value is $691,728, with a 2% escalation factor bringing the total to approximately $760,000. The lease includes two sweepers at $79,716 per unit annually, 80 gutter brooms at $120 each, and 12 pickup main brooms at $325 each.

The pricing breakdown shows an annual cost of $172,932 for the two sweepers and associated equipment, which multiplies to $691,728 over the four-year contract term. The budget estimate includes a built-in 2% annual escalation clause, suggesting potential price adjustments for inflation or increased operational costs. The spreadsheet provides detailed cost calculations for each component, including the sweeper lease, gutter brooms, and pickup brooms, with both single-unit and total annual and multi-year projections. The document appears to be a preliminary budget estimate for procurement planning purposes, offering a comprehensive view of the expected equipment lease and maintenance expenses.

View the file

Other files

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

Chart1

Lease of Sweepers w/Full Maint Svs (2 Sweepers)Single Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal7971621594324637728Single Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotalGutter BroomsSingle Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal120809600438400Pickup (Main) BroomsSingle Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal325123900415600TotalSingle Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal1729324691728

Sheet1

BUDGET ESTIMATE
Item DescriptionSingle Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal
Lease of Sweepers w/Full Maint Svs (2 Sweepers)$ 79,716.002$ 159,432.004$ 637,728.00
Gutter Brooms$ 120.0080$ 9,600.004$ 38,400.00
Pickup (Main) Brooms$ 325.0012$ 3,900.004$ 15,600.00
Total$ 172,932.004$ 691,728.00

with Escalation 2% $ 760,000.00

Item DescriptionSingle Unit Cost w/Full Maint.Annual Qty (2 sweepers)Annual Est. Total Cost
(2 sweepers)x 4 yearsTotal
Lease of Sweepers w/Full Maint Svs (2 Sweepers)$ 79,716.002$ 159,432.004$ 637,728.00
Gutter Brooms$ 120.0080$ 9,600.004$ 38,400.001632
Pickup Main Brooms$ 325.0012$ 3,900.004$ 15,600.00711
Total$ 445.00$ 13,500.00$ 691,728.00
Total Lease and Brooms$ 172,932.004
with Escalation 2%
units/63 mos x 12-12 wasted gutter
Gutter22.86avgyr
Pickup61.90avgyr
factor double duty on sweeper & round up114.29110
309.5235

Sheet2

Sheet3

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