15-007 Analysis
19 KB Posted
- Solicitation number
- 23-007
- Issued by
- Fulton County, Georgia
About this file
This document is a bid analysis spreadsheet for tree pruning services prepared for the City of Alpharetta, Georgia. The spreadsheet compares actual costs from a 2014 tree work contract against three 2015 bid proposals from contractors KDM, Southern Pride, and Tatum. The analysis covers a total of 47 trees across six size categories ranging from 16"-24" diameter at breast height (DBH) to 61"-72" DBH, with pricing structured by tree size and service type (trimming versus removal). The 2014 contract generated actual costs of $59,050.00 for routine trimming work, with additional emergency costs of $4,874.00 for crane services. The contract scope includes all necessary labor, supervision, tools, equipment, supplies, materials, and expertise to accomplish tree pruning and removal operations throughout the city on an ongoing basis.
The 2015 bid analysis reveals three competing proposals for the renewal contract: KDM bid $57,821.99, Southern Pride bid $60,273.60, and Tatum bid $61,588.30, compared to the old contract cost baseline of $51,157.50 adjusted for 2015 pricing. KDM's bid represents the lowest cost proposal and represents a cost reduction from the 2014 actual spending. The pricing structure maintains the hourly rate of $120 for trimming services while individual tree costs vary by size category, with larger trees (61"-72" DBH) commanding rates up to $3,600.00 per tree. The contract includes provisions for additional emergency work and crane services at supplemental rates, with total emergency costs in 2014 reaching $4,874.00.
Text of this file
Sheet1
| Contractor Tree Work 2014 | |||||||||
| Tree Size | Actual Cost | Date | Cost | Schedule | Trimming $120/Hr. | ||||
| 18" | 450.00 | 2/5 | 350-450 | 16"-24" | Cost | Hours | Date | ||
| 27" | 950.00 | 2/5 | 700-950 | 25"-36" | 700.00 | 5.83 | 2/21 | ||
| 29" | 950.00 | 2/5 | 700-950 | 25"-36" | 450.00 | 3.75 | 3/4 | ||
| 20" | 450.00 | 2/5 | 350-450 | 16"-24" | 300.00 | 2.50 | 5/14 | ||
| 24" | 450.00 | 2/5 | 350-450 | 16"-24" | 200.00 | 1.67 | 5/20 | ||
| 26" | 950.00 | 2/25 | 700-950 | 25"-36" | 425.00 | 3.54 | 7/23 | ||
| 33" | 950.00 | 3/4 | 700-950 | 25"-36" | 400.00 | 3.33 | 8/5 | ||
| 50" | 2350.00 | 4/9 | 1900-2350 | 49"-60" | 600.00 | 5.00 | 8/5 | ||
| 31" | 950.00 | 4/9 | 700-950 | 25"-36" | 300.00 | 2.50 | 9/30 | ||
| 24" | 450.00 | 4/25 | 350-450 | 16"-24" | 2800.00 | 23.33 | 12/1 | ||
| 25" | 450.00 | 5/7 | 700-950 | 25"-36" | 250.00 | 2.08 | 12/9 | ||
| 20" | 1000.00 | 5/14 | 350-450 | 16"-24" | E | Total | 6425.00 | 53.53 | |
| 36" | 950.00 | 6/24 | 700-950 | 25"-36" | |||||
| 33" | 950.00 | 6/24 | 700-950 | 25"-36" | |||||
| 32" | 950.00 | 6/24 | 700-950 | 25"-36" | |||||
| 20" | 450.00 | 6/24 | 350-450 | 16"-24" | |||||
| 43" | 1875.00 | 6/24 | 1500-1875 | 37"-48" | Extra Costs | Date | |||
| 20" | 450.00 | 7/23 | 350-450 | 16"-24" | 2437.00 | crane | 7/30 | ||
| 28" | 950.00 | 7/23 | 700-950 | 25"-36" | 2437.00 | crane | 12/1 | ||
| 42" | 1875.00 | 7/23 | 1500-1875 | 37"-48" | Total | 4874.00 | |||
| 49" | 2350.00 | 7/30 | 1900-2350 | 49"-60" | |||||
| 62" | 3100.00 | 8/15 | 3000-3600 | 61"-72" | |||||
| 50" | 2350.00 | 8/26 | 1900-2350 | 49"-60" | Number of Trees | ||||
| 27" | 950.00 | 8/26 | 700-950 | 25"-36" | 0 | 15" and Under | |||
| 26" | 950.00 | 8/26 | 700-950 | 25"-36" | 10 | 16"-24" | |||
| 16" | 450.00 | 9/11 | 350-450 | 16"-24" | 23 | 25"-36" | |||
| 28" | 950.00 | 9/11 | 700-950 | 25"-36" | 8 | 37"-48" | |||
| 30" | 950.00 | 9/11 | 700-950 | 25"-36" | 5 | 49"-60" | |||
| 41" | 1875.00 | 9/11 | 1500-1875 | 37"-48" | 1 | 61"-72" | |||
| 31" | 950.00 | 9/11 | 700-950 | 25"-36" | Total | 47 | |||
| 40" | 1875.00 | 9/17 | 1500-1875 | 37"-48" | |||||
| 52" | 2350.00 | 10/1 | 1900-2350 | 49"-60" | |||||
| 38" | 1875.00 | 10/1 | 1500-1875 | 37"-48" | |||||
| 40" | 1875.00 | 10/1 | 1500-1875 | 37"-48" | |||||
| 42" | 1875.00 | 11/20 | 1500-1875 | 37"-48" | |||||
| 30"&22" | 2700.00 | 12/1 | 350-450 700-950 | 16"-24" 25"-36" | |||||
| 29" | 950.00 | 12/1 | 700-950 | 25"-36" | |||||
| 27" | 950.00 | 12/1 | 700-950 | 25"-36" | |||||
| 18" | 450.00 | 12/3 | 350-450 | 16"-24" | |||||
| 41" | 1875.00 | 12/3 | 1500-1875 | 37"-48" | |||||
| 36" | 950.00 | 12/4 | 700-950 | 25"-36" | |||||
| 27" | 950.00 | 12/9 | 700-950 | 25"-36" | |||||
| 31" | 950.00 | 12/9 | 700-950 | 25"-36" | |||||
| 29" | 950.00 | 12/11 | 700-950 | 25"-36" | |||||
| 27" | 950.00 | 12/11 | 700-950 | 25"-36" | |||||
| 51" | 3850.00 | 12/12 | 1900-2350 | 49"-60" | |||||
| Total | 59050.00 | ||||||||
| E = Emergency |
Sheet2
| 2015 Tree Contract Bid Analysis | ||||||||||||||
| Old Contract | KDM | Southern Pride | Tatum | KDM | Southern Pride | Tatum | ||||||||
| Tree Size | Actual Cost | Date | Cost | Schedule | Bid Rates 2015 | Trimming $120/Hr. | $ 124.50 | $ 120.00 | $ 110.00 | |||||
| 18" | $ 450.00 | 2/5 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | Cost | Hours | Date | Cost | |||
| 27" | $ 950.00 | 2/5 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 700.00 | 5.83 | 2/21 | $ 725.84 | $ 699.60 | $ 641.30 | |
| 29" | $ 950.00 | 2/5 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 450.00 | 3.75 | 3/4 | $ 466.88 | $ 450.00 | $ 412.50 | |
| 20" | $ 450.00 | 2/5 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | 300.00 | 2.50 | 5/14 | $ 311.25 | $ 300.00 | $ 275.00 | |
| 24" | $ 450.00 | 2/5 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | 200.00 | 1.67 | 5/20 | $ 207.92 | $ 200.40 | $ 183.70 | |
| 26" | $ 950.00 | 2/25 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 425.00 | 3.54 | 7/23 | $ 440.73 | $ 424.80 | $ 389.40 | |
| 33" | $ 950.00 | 3/4 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 400.00 | 3.33 | 8/5 | $ 414.59 | $ 399.60 | $ 366.30 | |
| 50" | $ 2,350.00 | 4/9 | 1900-2350 | 49"-60" | $ 2,232.50 | $ 2,350.00 | $ 2,400.00 | 600.00 | 5.00 | 8/5 | $ 622.50 | $ 600.00 | $ 550.00 | |
| 31" | $ 950.00 | 4/9 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 300.00 | 2.50 | 9/30 | $ 311.25 | $ 300.00 | $ 275.00 | |
| 24" | $ 450.00 | 4/25 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | 2800.00 | 23.33 | 12/1 | $ 2,904.58 | $ 2,799.60 | $ 2,566.30 | |
| 25" | $ 450.00 | 5/7 | 700-950 | 25"-36" | $ 427.50 | $ 450.00 | $ 475.00 | 250.00 | 2.08 | 12/9 | $ 258.96 | $ 249.60 | $ 228.80 | |
| 20" | $ 1,000.00 | 5/14 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | Total | 6425.00 | 53.53 | $ 6,664.49 | $ 6,423.60 | $ 5,888.30 | |
| 36" | $ 950.00 | 6/24 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 33" | $ 950.00 | 6/24 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 32" | $ 950.00 | 6/24 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 20" | $ 450.00 | 6/24 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | |||||||
| 43" | $ 1,875.00 | 6/24 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | Extra Costs | Date | |||||
| 20" | $ 450.00 | 7/23 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | 2437.00 | crane | 7/30 | ||||
| 28" | $ 950.00 | 7/23 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 2437.00 | crane | 12/1 | ||||
| 42" | $ 1,875.00 | 7/23 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | Total | 4874.00 | |||||
| 49" | $ 2,350.00 | 7/30 | 1900-2350 | 49"-60" | $ 2,232.50 | $ 2,350.00 | $ 2,400.00 | |||||||
| 62" | $ 3,100.00 | 8/15 | 3000-3600 | 61"-72" | $ 3,420.00 | $ 3,600.00 | $ 3,675.00 | |||||||
| 50" | $ 2,350.00 | 8/26 | 1900-2350 | 49"-60" | $ 2,232.50 | $ 2,350.00 | $ 2,400.00 | Number of Trees | ||||||
| 27" | $ 950.00 | 8/26 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 0 | 15" and Under | |||||
| 26" | $ 950.00 | 8/26 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 10 | 16"-24" | |||||
| 16" | $ 450.00 | 9/11 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | 23 | 25"-36" | |||||
| 28" | $ 950.00 | 9/11 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 8 | 37"-48" | |||||
| 30" | $ 950.00 | 9/11 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | 5 | 49"-60" | |||||
| 41" | $ 1,875.00 | 9/11 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | 1 | 61"-72" | |||||
| 31" | $ 950.00 | 9/11 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | Total | 47 | |||||
| 40" | $ 1,875.00 | 9/17 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | |||||||
| 52" | $ 2,350.00 | 10/1 | 1900-2350 | 49"-60" | $ 2,232.50 | $ 2,350.00 | $ 2,400.00 | |||||||
| 38" | $ 1,875.00 | 10/1 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | |||||||
| 40" | $ 1,875.00 | 10/1 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | |||||||
| 42" | $ 1,875.00 | 11/20 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | |||||||
| 30"&22" | $ 2,700.00 | 12/1 | 350-450 700-950 | 16"-24" 25"-36" | $ 1,330.00 | $ 1,400.00 | $ 1,475.00 | |||||||
| 29" | $ 950.00 | 12/1 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 27" | $ 950.00 | 12/1 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 18" | $ 450.00 | 12/3 | 350-450 | 16"-24" | $ 427.50 | $ 450.00 | $ 475.00 | |||||||
| 41" | $ 1,875.00 | 12/3 | 1500-1875 | 37"-48" | $ 1,781.25 | $ 1,875.00 | $ 1,900.00 | |||||||
| 36" | $ 950.00 | 12/4 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 27" | $ 950.00 | 12/9 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 31" | $ 950.00 | 12/9 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 29" | $ 950.00 | 12/11 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 27" | $ 950.00 | 12/11 | 700-950 | 25"-36" | $ 902.50 | $ 950.00 | $ 1,000.00 | |||||||
| 51" | $ 3,850.00 | 12/12 | 1900-2350 | 49"-60" | ||||||||||
| $ 59,050.00 | $ 51,157.50 | $ 53,850.00 | $ 55,700.00 |
Bid 2015 Comparison $ 57,821.99 $ 60,273.60 $ 61,588.30
Other files
| File | Type | Posted |
|---|---|---|
| Award Information | — | |
| Award Information | — | |
| BID INSTRUCTIONS | — | |
| Bid Tabulation | — | |
| Award Information | — | |
| Tree Database - 2022 | — | |
| 11-008 Tally | — | |
| Tree Trimming and Removal Serv | — | |
| NOIA | — | |
| Award Information | — | |
| Addendum #1 | — | |
| 15-007 Tally | — | |
| Addendum #2 | — | |
| Addendum 1 | — | |
| Driskell Park 1021 S McKinley | — | |
| Award Information | — | |
| Addendum 4 | — | |
| Addendum 2 | — | |
| Addendum 5 | — | |
| Addendum 3 | — | |
| Award Information | — |
Show all 21
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
File details come from the government source that posted it. Updated .