Engineer_Estimate_20250130_UTL_AT_edits_Ransom_additions_(Review_Only).xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 25-0356-ITB-C
- Issued by
- Pinellas County, Florida
About this file
The document is an Engineer's Estimate spreadsheet for a Cured-In-Place Pipe (CIPP) Lining project by Pinellas County Public Works in Florida, covering stormwater and sanitary sewer infrastructure rehabilitation. The comprehensive bid includes multiple line items for pipe rehabilitation across various pipe diameters ranging from 8" to 72", with extensive specifications for cleaning, televised inspections, temporary traffic control, erosion control, and point repairs. The project encompasses approximately 30,000 linear feet of 8" pipe, 5,000 linear feet of 10" pipe, and scaling up to smaller quantities of larger diameter pipes, with additional provisions for lateral connections, service line reconnections, and structural repairs.
The total estimated project value is $15,423,230, with significant line items including mobilization ($750,000), pipe cleaning ($826,850), CIPP liner installation for sanitary sewer ($1,824,500) and stormwater pipes ($9,697,560), and various supplementary services like bypassing pumping, joint repairs, and external/internal point repairs. The bid includes contingency funds for unspecified work ($200,000) and covers multiple rehabilitation techniques such as light, medium, and heavy pipe cleaning, televised inspections, and different repair methodologies for pipes at various depths and diameters. The project appears designed to comprehensively upgrade and maintain critical municipal infrastructure through advanced rehabilitation techniques.
View the file
Other files
Show all 23
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
Sheet2 PROJECT NAME: CIPP Lining
CONTRACT NO. :
BID NO. :
| Engineer Estimate / Vendor Name | ||||||
| Pay Item No. | Description | Quantity | Unit | Unit Price | Amount | |
| MOBILIZATION | ||||||
| 101-0100-0001 | Mobilization for Routine Response | 120.00 | EA | $3,000.00 | $ 360,000.00 | |
| 101-0100-0002 | Mobilization for Emergency Response | 60.00 | EA | $6,500.00 | $ 390,000.00 | |
| SUBTOTAL | $ 750,000.00 | $ 750,000.00 | ||||
| TEMPORARY TRAFFIC CONTROL | ||||||
| 102-1602 | Flagmen (Per-Flagmen) | 120.00 | HR | $50.00 | $ 6,000.00 | |
| 102-1000-613 | Multi Lane (FDOT Index No. 102-613) | 160.00 | EA/DY | $300.00 | $ 48,000.00 | |
| 102-1000-615 | Multi Lane (FDOT Index No. 102-615) | 20.00 | EA/DY | $300.00 | $ 6,000.00 | |
| 102-1076 | Arrow Boards/ Advance Warning Arrow Panel | 160.00 | EA/DY | $50.00 | $ 8,000.00 | |
| 102-1099 | SIGN, VARIABLE MESSAGE (Temporary) | 20.00 | EA/DY | $50.00 | $ 1,000.00 | |
| 102-0071-13 | Concrete Barrier (FDOT Index No. 102-100) | 160.00 | LF | $10.00 | $ 1,600.00 | |
| 102-0071-16 | Low Profile Barrier (FDOT Index No. 102-120) | 160.00 | LF | $10.00 | $ 1,600.00 | |
| 102-1600 | Work Zone Signs | 3,200.00 | EA/DY | $4.50 | $ 14,400.00 | |
| 102-1652 | BARRICADE, Type I, II or Drum, FDOT Index No. 600 (Temporary) | 40.00 | EA/DY | $5.00 | $ 200.00 | |
| 102-1655 | BARRICADE, Type III (Temporary) | 40.00 | EA/DY | $8.00 | $ 320.00 | |
| SUBTOTAL | $ 87,120.00 | $ 837,120.00 | ||||
| EROSION AND SEDIMENT CONTROL | ||||||
| 104-6 | Sediment Barrier | 160.00 | LF | $3.00 | $ 480.00 | |
| 104-16 | Staked Turbidity Barrier | 320.00 | LF | $10.00 | $ 3,200.00 | |
| 104-18 | Inlet Protection System | 40.00 | EA | $300.00 | $ 12,000.00 | |
| 104-16 | Turbidity Barrier, Floating | 320.00 | LF | $20.00 | $ 6,400.00 | |
| SUBTOTAL | $ 22,080.00 | $ 859,200.00 | ||||
| CLEANING / SURFACE PREPARATION | ||||||
| 460-101-0015 | Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (15" or less) | 15,000.00 | LF | $2.00 | $ 30,000.00 | |
| 460-101-1521 | Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (> 15" - 21") | 15,000.00 | LF | $3.00 | $ 45,000.00 | |
| 460-101-2142 | Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (> 21" - 42") | 15,000.00 | LF | $4.00 | $ 60,000.00 | |
| 460-101-4254 | Pipe Cleaning - Light Cleaning - 0 - 1/4" diameter of pipe depth (> 42" - 54") | 5,000.00 | LF | $7.00 | $ 35,000.00 | |
| 460-101-5499 | Pipe Cleaning - Light Cleaning - 0 - 1/4" diameter of pipe depth (> 54") | 25,000.00 | LF | $10.00 | $ 250,000.00 | |
| 460-102-0015 | Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (15" or less) | 10,000.00 | LF | $3.00 | $ 30,000.00 | |
| 460-102-1521 | Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (> 15" - 21") | 10,000.00 | LF | $3.00 | $ 30,000.00 | |
| 460-102-2142 | Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (> 21" - 42") | 5,000.00 | LF | $5.00 | $ 25,000.00 | |
| 460-102-4254 | Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe (> 42" - 54") | 2,000.00 | LF | $6.00 | $ 12,000.00 | |
| 460-102-5499 | Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe (> 54") | 250.00 | LF | $9.00 | $ 2,250.00 | |
| 460-103-0015 | Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe debris (15" or less) | 5,000.00 | LF | $3.00 | $ 15,000.00 | |
| 460-103-1521 | Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 15" - 21") | 15,000.00 | LF | $5.00 | $ 75,000.00 | |
| 460-103-2142 | Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 21" - 42") | 15,000.00 | LF | $8.00 | $ 120,000.00 | |
| 460-103-4254 | Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 42" - 54") | 1,500.00 | LF | $15.00 | $ 22,500.00 | |
| 460-103-5499 | Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 54") | 1,000.00 | LF | $30.00 | $ 30,000.00 | |
| 460-104-0015 | Pipe Cleaning - Special Cleaning (15" or less) | 2,000.00 | LF | $3.00 | $ 6,000.00 | |
| 460-104-1521 | Pipe Cleaning - Special Cleaning (> 15" - 21") | 2,000.00 | LF | $5.00 | $ 10,000.00 | |
| 460-104-2142 | Pipe Cleaning - Special Cleaning (> 21" - 42") | 2,500.00 | LF | $6.00 | $ 15,000.00 | |
| 460-104-4254 | Pipe Cleaning - Special Cleaning (> 42" - 54") | 1,200.00 | LF | $8.00 | $ 9,600.00 | |
| 460-104-5499 | Pipe Cleaning - Special Cleaning (> 54") | 500.00 | LF | $9.00 | $ 4,500.00 | |
| SUBTOTAL | $ 826,850.00 | $ 1,686,050.00 | ||||
| TELEVISED INSPECTIONS | ||||||
| 460-201-0021 | Televised Inspections - 21" Diameter and Less | 20,000.00 | LF | $4.00 | $ 80,000.00 | |
| 460-201-0099 | Televised Inspections - Greater than 21" Diameter | 20,000.00 | LF | $6.00 | $ 120,000.00 | |
| SUBTOTAL | $ 200,000.00 | $ 1,886,050.00 | ||||
| REMOVE PROTRUDING SERVICES | ||||||
| SS-330131-304-A001 | Remove Protruding Services | 10.00 | EA | $149.00 | $ 1,490.00 | |
| SUBTOTAL | $ 1,490.00 | $ 1,887,540.00 | ||||
| GRIND, GROUT, AND SEAL EXISTING SERVICE OPENING | ||||||
| SS-330131-304-A002 | Grind, Grout, and Seal Existing Service Opening | 10.00 | EA | $297.00 | $ 2,970.00 | |
| SUBTOTAL | $ 2,970.00 | $ 1,890,510.00 | ||||
| BY-PASSING PUMPING SET UP AND OPERATION | ||||||
| SS-333301-301-B2-0810 | 8"-10" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $75.00 | $ 750.00 | |
| SS-333301-301-B2-1214 | 12"-14" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $149.00 | $ 1,490.00 | |
| SS-333301-301-B2-1521 | 15"-21" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $149.00 | $ 1,490.00 | |
| SS-333301-301-B2-2430 | 24"-30" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $149.00 | $ 1,490.00 | |
| SS-333301-301-B2-3642 | 36"-42" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $2,967.00 | $ 29,670.00 | |
| SS-333301-301-B2-4860 | 48"-60" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $3,264.00 | $ 32,640.00 | |
| SS-333301-301-B2-6099 | > 60" diameter SET UP AND OPERATION | 10.00 | EA/DAY | $3,560.00 | $ 35,600.00 | |
| SUBTOTAL | $ 103,130.00 | $ 1,993,640.00 | ||||
| PIPE REHABILITATION WITH CIPP LINER, FURNISH AND INSTALLATION - Sanitary Sewer | ||||||
| SS-330131-305-0008 | 8" Pipe Diameter CIPP (6 mm) | 30,000.00 | LF | $42.00 | $1,260,000.00 | |
| SS-330131-305-0010 | 10" Pipe Diameter CIPP (7.5 mm) | 5,000.00 | LF | $50.00 | $250,000.00 | |
| SS-330131-305-0012 | 12" Pipe Diameter CIPP (7.5 mm) | 1,500.00 | LF | $60.00 | $90,000.00 | |
| SS-330131-305-0015 | 15" Pipe Diameter CIPP (9 mm) | 500.00 | LF | $70.00 | $35,000.00 | |
| SS-330131-305-0018 | 18" Pipe Diameter CIPP (9 mm) | 500.00 | LF | $100.00 | $50,000.00 | |
| SS-330131-305-0021 | 21" Pipe Diameter CIPP (9 mm) | 500.00 | LF | $115.00 | $57,500.00 | |
| SS-330139-304-001 | Cured-in-place lateral and lateral connection liner, 8" to 12" main, 4" & 6" lateral pipe up to 20 linear feet-initial | 15.00 | EA | $5,000.00 | $75,000.00 | |
| SS-330139-304-002 | Cured in Place Lateral liner 4" & 6" pipe - additional | 100.00 | LF | $70.00 | $7,000.00 | |
| SUBTOTAL | $1,824,500.00 | |||||
| PIPE REHABILITATION WITH CIPP LINER, FURNISH AND INSTALLATION - Stormwater | ||||||
| 460-300-0151 | 15" Pipe Diameter CIPP (9 mm) | 8,000.00 | LF | $101.00 | $808,000.00 | |
| 460-300-0152 | 15" Pipe Diameter - Add/deduct per 1 mm increment variance | 2,500.00 | LF | $3.00 | $7,500.00 | |
| 460-300-0181 | 18" Pipe Diameter CIPP (9 mm) | 4,000.00 | LF | $109.00 | $436,000.00 | |
| 460-300-0182 | 18" Pipe Diameter - Add/deduct per 1 mm increment variance | 8,000.00 | LF | $3.00 | $24,000.00 | |
| 460-300-0211 | 21" Pipe Diameter CIPP (9 mm) | 160.00 | LF | $112.00 | $17,920.00 | |
| 460-300-0212 | 21" Pipe Diameter - Add/deduct per 1 mm increment variance | 300.00 | LF | $4.00 | $1,200.00 | |
| 460-300-0241 | 24" Pipe Diameter CIPP (10.5 mm) | 4,000.00 | LF | $148.00 | $592,000.00 | |
| 460-300-0242 | 24" Pipe Diameter - Add/deduct per 1 mm increment variance | 8,000.00 | LF | $7.00 | $56,000.00 | |
| 460-300-0301 | 30" Pipe Diameter CIPP (13.5 mm) | 3,000.00 | LF | $202.00 | $606,000.00 | |
| 460-300-0302 | 30" Pipe Diameter - Add/deduct per 1 mm increment variance | 5,500.00 | LF | $8.00 | $44,000.00 | |
| 460-300-0361 | 36" Pipe Diameter CIPP (13.5 mm) | 3,000.00 | LF | $217.00 | $651,000.00 | |
| 460-300-0362 | 36" Pipe Diameter - Add/deduct per 1 mm increment variance | 20,000.00 | LF | $10.00 | $200,000.00 | |
| 460-300-0421 | 42" Pipe Diameter CIPP (13.5 mm) | 2,000.00 | LF | $279.00 | $558,000.00 | |
| 460-300-0422 | 42" Pipe Diameter - Add/deduct per 1 mm increment variance | 13,000.00 | LF | $11.00 | $143,000.00 | |
| 460-300-0481 | 48" Pipe Diameter CIPP (15 mm) | 1,500.00 | LF | $310.00 | $465,000.00 | |
| 460-300-0482 | 48" Pipe Diameter - Add/deduct per 1 mm increment variance | 20,000.00 | LF | $17.00 | $340,000.00 | |
| 460-300-0541 | 54" Pipe Diameter CIPP (18 mm) | 800.00 | LF | $403.00 | $322,400.00 | |
| 460-300-0542 | 54" Pipe Diameter - Add/deduct per 1 mm increment variance | 7,500.00 | LF | $19.00 | $142,500.00 | |
| 460-300-0601 | 60" Pipe Diameter CIPP (21 mm) | 700.00 | LF | $465.00 | $325,500.00 | |
| 460-300-0602 | 60" Pipe Diameter - Add/deduct per 1 mm increment variance | 9,000.00 | LF | $22.00 | $198,000.00 | |
| 460-300-0661 | 66" Pipe Diameter CIPP (21 mm) | 100.00 | LF | $550.00 | $55,000.00 | |
| 460-300-0662 | 66" Pipe Diameter - Add/deduct per 1 mm increment variance | 100.00 | LF | $25.00 | $2,500.00 | |
| 460-300-0721 | 72" Pipe Diameter CIPP (22.5 mm) | 80.00 | LF | $635.00 | $50,800.00 | |
| 460-300-0722 | 72" Pipe Diameter - Add/deduct per 1 mm increment variance | 80.00 | LF | $28.00 | $2,240.00 | |
| SUBTOTAL | $ 9,697,560.00 | $ 11,691,200.00 | ||||
| RECONNECT SERVICE LINE - Sanitary Sewer | ||||||
| SS-330131-307-001 | Reconnect Service Line | 600.00 | EA | $233.00 | $ 139,800.00 | |
| SUBTOTAL | $ 139,800.00 | $ 11,831,000.00 | ||||
| LIFTING OF STRUCTURAL LIDS | ||||||
| 460-250-0001 | Lifting of Structure Lids | 100.00 | EA | $450.00 | $ 45,000.00 | |
| SUBTOTAL | $ 45,000.00 | $ 11,876,000.00 | ||||
| JOINT REPAIRS BY INJECTION | ||||||
| 460-500-0001 | Joint Repairs by Injection | 60.00 | GAL | $50.00 | $ 3,000.00 | |
| SUBTOTAL | $ 3,000.00 | $ 11,879,000.00 | ||||
| CURING WATER REMOVAL | ||||||
| 460-300-0099 | Curing Water Removal (per 1,000 gallons) | 3,000.00 | EA | $39.00 | $ 117,000.00 | |
| SUBTOTAL | $ 117,000.00 | $ 11,996,000.00 | ||||
| INTERNAL POINT REPAIRS | ||||||
| 460-400-2101 | Internal Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length | 50.00 | EA | $2,670.00 | $ 133,500.00 | |
| 460-400-2103 | Internal Repair - 6" - 21" Diameter Pipe - Additional 1-ft Incremental Length | 60.00 | LF | $223.00 | $ 13,380.00 | |
| 460-400-2401 | Internal Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length | 60.00 | EA | $3,709.00 | $ 222,540.00 | |
| 460-400-2403 | Internal Repair - 24" - 30" Diameter Pipe - Additional 1-ft Incremental Length | 120.00 | LF | $445.00 | $ 53,400.00 | |
| 460-400-3601 | Internal Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length | 20.00 | EA | $4,450.00 | $ 89,000.00 | |
| 460-400-3603 | Internal Repair - 36" - 42" Diameter Pipe - Additional 1-ft Incremental Length | 20.00 | LF | $520.00 | $ 10,400.00 | |
| 460-400-4801 | Internal Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length | 20.00 | EA | $5,563.00 | $ 111,260.00 | |
| 460-400-4803 | Internal Repair - 48" - 60" Diameter Pipe - Additional 1-ft Incremental Length | 50.00 | LF | $742.00 | $ 37,100.00 | |
| 460-400-6601 | Internal Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length | 30.00 | EA | $7,417.00 | $ 222,510.00 | |
| 460-400-6603 | Internal Repair - 66" - 72" Diameter Pipe - Additional 1-ft Incremental Length | 30.00 | LF | $1,113.00 | $ 33,390.00 | |
| SUBTOTAL | $ 926,480.00 | $ 12,922,480.00 | ||||
| EXTERNAL POINT REPAIRS | ||||||
| 460-401-2101 | External Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length (0' - 5' Deep) | 20.00 | EA | $1,484.00 | $ 29,680.00 | |
| 460-401-2105 | External Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length (5' - 10' Deep) | 10.00 | EA | $3,264.00 | $ 32,640.00 | |
| 460-401-2106 | External Repair - 6" - 21" Diameter Pipe -Additional 1-ft Incremental Length | 10.00 | LF | $127.00 | $ 1,270.00 | |
| 460-401-2401 | External Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length (0' - 5' Deep) | 10.00 | EA | $1,780.00 | $ 17,800.00 | |
| 460-401-2405 | External Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length (5' - 10' Deep) | 10.00 | EA | $4,005.00 | $ 40,050.00 | |
| 460-401-2406 | External Repair - 24" - 30" Diameter Pipe -Additional 1-ft Incremental Length | 20.00 | LF | $178.00 | $ 3,560.00 | |
| 460-401-3601 | External Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length (0' - 10' Deep) | 10.00 | EA | $2,522.00 | $ 25,220.00 | |
| 460-401-3605 | External Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length (10' - 15' Deep) | 10.00 | EA | $5,192.00 | $ 51,920.00 | |
| 460-401-3606 | External Repair - 36" - 42" Diameter Pipe -Additional 1-ft Incremental Length | 20.00 | LF | $223.00 | $ 4,460.00 | |
| 460-401-4801 | External Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length (0' - 10' Deep) | 10.00 | EA | $3,709.00 | $ 37,090.00 | |
| 460-401-4805 | External Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length (10' - 15' Deep) | 10.00 | EA | $6,379.00 | $ 63,790.00 | |
| 460-401-4806 | External Repair - 48" - 60" Diameter Pipe -Additional 1-ft Incremental Length | 10.00 | LF | $260.00 | $ 2,600.00 | |
| 460-401-6601 | External Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length (0' - 15' Deep) | 10.00 | EA | $6,675.00 | $ 66,750.00 | |
| 460-401-6605 | External Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length (15' - 20' Deep) | 10.00 | EA | $9,642.00 | $ 96,420.00 | |
| 460-401-6606 | External Repair - 66" - 72" Diameter Pipe -Additional 1-ft Incremental Length | 10.00 | LF | $300.00 | $ 3,000.00 | |
| SUBTOTAL | $ 476,250.00 | $ 13,398,730.00 | ||||
| UNSPECIFIED | ||||||
| 999-0000 | UNSPECIFIED WORK | 200,000.00 | EA | $1.00 | $ 200,000.00 | |
| OTHER ITEMS SUBTOTAL | $ 200,000.00 | |||||
| Total Bid | $ 15,423,230.00 | $ 13,598,730.00 |
File details come from the government source that posted it. Updated .