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 years | Total | 79716 | 2 | 159432 | 4 | 637728 | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost | |
| (2 sweepers) | x 4 years | Total | Gutter Brooms | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost | |||||
| (2 sweepers) | x 4 years | Total | 120 | 80 | 9600 | 4 | 38400 | Pickup (Main) Brooms | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost |
| (2 sweepers) | x 4 years | Total | 325 | 12 | 3900 | 4 | 15600 | Total | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost |
| (2 sweepers) | x 4 years | Total | 172932 | 4 | 691728 |
Sheet1
| BUDGET ESTIMATE | ||||||
| Item Description | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost | |||
| (2 sweepers) | x 4 years | Total | ||||
| Lease of Sweepers w/Full Maint Svs (2 Sweepers) | $ 79,716.00 | 2 | $ 159,432.00 | 4 | $ 637,728.00 |
| Gutter Brooms | $ 120.00 | 80 | $ 9,600.00 | 4 | $ 38,400.00 |
| Pickup (Main) Brooms | $ 325.00 | 12 | $ 3,900.00 | 4 | $ 15,600.00 |
| Total | $ 172,932.00 | 4 | $ 691,728.00 |
with Escalation 2% $ 760,000.00
| Item Description | Single Unit Cost w/Full Maint. | Annual Qty (2 sweepers) | Annual Est. Total Cost | |||
| (2 sweepers) | x 4 years | Total | ||||
| Lease of Sweepers w/Full Maint Svs (2 Sweepers) | $ 79,716.00 | 2 | $ 159,432.00 | 4 | $ 637,728.00 |
| Gutter Brooms | $ 120.00 | 80 | $ 9,600.00 | 4 | $ 38,400.00 | 16 | 32 |
| Pickup Main Brooms | $ 325.00 | 12 | $ 3,900.00 | 4 | $ 15,600.00 | 7 | 11 |
| Total | $ 445.00 | $ 13,500.00 | $ 691,728.00 |
| Total Lease and Brooms | $ 172,932.00 | 4 |
| with Escalation 2% |
| units/63 mos x 12 | -12 wasted gutter | |||
| Gutter | 22.86 | avg | yr | |
| Pickup | 61.90 | avg | yr |
| factor double duty on sweeper & round up | 114.29 | 110 |
| 309.52 | 35 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .