Engineer_Estimate_20250130_UTL_AT_edits_Ransom_additions_(Review_Only).xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Cured-In-Place Pipe (CIPP) Stormwater Pipe Rehabilitation (Re-Bid)
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.DescriptionQuantityUnitUnit PriceAmount
MOBILIZATION
101-0100-0001Mobilization for Routine Response120.00EA$3,000.00$ 360,000.00
101-0100-0002Mobilization for Emergency Response60.00EA$6,500.00$ 390,000.00
SUBTOTAL$ 750,000.00$ 750,000.00
TEMPORARY TRAFFIC CONTROL
102-1602Flagmen (Per-Flagmen)120.00HR$50.00$ 6,000.00
102-1000-613Multi Lane (FDOT Index No. 102-613)160.00EA/DY$300.00$ 48,000.00
102-1000-615Multi Lane (FDOT Index No. 102-615)20.00EA/DY$300.00$ 6,000.00
102-1076Arrow Boards/ Advance Warning Arrow Panel160.00EA/DY$50.00$ 8,000.00
102-1099SIGN, VARIABLE MESSAGE (Temporary)20.00EA/DY$50.00$ 1,000.00
102-0071-13Concrete Barrier (FDOT Index No. 102-100)160.00LF$10.00$ 1,600.00
102-0071-16Low Profile Barrier (FDOT Index No. 102-120)160.00LF$10.00$ 1,600.00
102-1600Work Zone Signs3,200.00EA/DY$4.50$ 14,400.00
102-1652BARRICADE, Type I, II or Drum, FDOT Index No. 600 (Temporary)40.00EA/DY$5.00$ 200.00
102-1655BARRICADE, Type III (Temporary)40.00EA/DY$8.00$ 320.00
SUBTOTAL$ 87,120.00$ 837,120.00
EROSION AND SEDIMENT CONTROL
104-6Sediment Barrier160.00LF$3.00$ 480.00
104-16Staked Turbidity Barrier320.00LF$10.00$ 3,200.00
104-18Inlet Protection System40.00EA$300.00$ 12,000.00
104-16Turbidity Barrier, Floating320.00LF$20.00$ 6,400.00
SUBTOTAL$ 22,080.00$ 859,200.00
CLEANING / SURFACE PREPARATION
460-101-0015Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (15" or less)15,000.00LF$2.00$ 30,000.00
460-101-1521Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (> 15" - 21")15,000.00LF$3.00$ 45,000.00
460-101-2142Pipe Cleaning - Light Cleaning - 0 - 1/4 diameter of pipe depth (> 21" - 42")15,000.00LF$4.00$ 60,000.00
460-101-4254Pipe Cleaning - Light Cleaning - 0 - 1/4" diameter of pipe depth (> 42" - 54")5,000.00LF$7.00$ 35,000.00
460-101-5499Pipe Cleaning - Light Cleaning - 0 - 1/4" diameter of pipe depth (> 54")25,000.00LF$10.00$ 250,000.00
460-102-0015Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (15" or less)10,000.00LF$3.00$ 30,000.00
460-102-1521Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (> 15" - 21")10,000.00LF$3.00$ 30,000.00
460-102-2142Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe depth (> 21" - 42")5,000.00LF$5.00$ 25,000.00
460-102-4254Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe (> 42" - 54")2,000.00LF$6.00$ 12,000.00
460-102-5499Pipe Cleaning - Medium Cleaning - 1/4" - 1/2" diameter of pipe (> 54")250.00LF$9.00$ 2,250.00
460-103-0015Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe debris (15" or less)5,000.00LF$3.00$ 15,000.00
460-103-1521Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 15" - 21")15,000.00LF$5.00$ 75,000.00
460-103-2142Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 21" - 42")15,000.00LF$8.00$ 120,000.00
460-103-4254Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 42" - 54")1,500.00LF$15.00$ 22,500.00
460-103-5499Pipe Cleaning - Heavy Cleaning - greater than 1/2" diameter of pipe (> 54")1,000.00LF$30.00$ 30,000.00
460-104-0015Pipe Cleaning - Special Cleaning (15" or less)2,000.00LF$3.00$ 6,000.00
460-104-1521Pipe Cleaning - Special Cleaning (> 15" - 21")2,000.00LF$5.00$ 10,000.00
460-104-2142Pipe Cleaning - Special Cleaning (> 21" - 42")2,500.00LF$6.00$ 15,000.00
460-104-4254Pipe Cleaning - Special Cleaning (> 42" - 54")1,200.00LF$8.00$ 9,600.00
460-104-5499Pipe Cleaning - Special Cleaning (> 54")500.00LF$9.00$ 4,500.00
SUBTOTAL$ 826,850.00$ 1,686,050.00
TELEVISED INSPECTIONS
460-201-0021Televised Inspections - 21" Diameter and Less20,000.00LF$4.00$ 80,000.00
460-201-0099Televised Inspections - Greater than 21" Diameter20,000.00LF$6.00$ 120,000.00
SUBTOTAL$ 200,000.00$ 1,886,050.00
REMOVE PROTRUDING SERVICES
SS-330131-304-A001Remove Protruding Services10.00EA$149.00$ 1,490.00
SUBTOTAL$ 1,490.00$ 1,887,540.00
GRIND, GROUT, AND SEAL EXISTING SERVICE OPENING
SS-330131-304-A002Grind, Grout, and Seal Existing Service Opening10.00EA$297.00$ 2,970.00
SUBTOTAL$ 2,970.00$ 1,890,510.00
BY-PASSING PUMPING SET UP AND OPERATION
SS-333301-301-B2-08108"-10" diameter SET UP AND OPERATION10.00EA/DAY$75.00$ 750.00
SS-333301-301-B2-121412"-14" diameter SET UP AND OPERATION10.00EA/DAY$149.00$ 1,490.00
SS-333301-301-B2-152115"-21" diameter SET UP AND OPERATION10.00EA/DAY$149.00$ 1,490.00
SS-333301-301-B2-243024"-30" diameter SET UP AND OPERATION10.00EA/DAY$149.00$ 1,490.00
SS-333301-301-B2-364236"-42" diameter SET UP AND OPERATION10.00EA/DAY$2,967.00$ 29,670.00
SS-333301-301-B2-486048"-60" diameter SET UP AND OPERATION10.00EA/DAY$3,264.00$ 32,640.00
SS-333301-301-B2-6099> 60" diameter SET UP AND OPERATION10.00EA/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-00088" Pipe Diameter CIPP (6 mm)30,000.00LF$42.00$1,260,000.00
SS-330131-305-001010" Pipe Diameter CIPP (7.5 mm)5,000.00LF$50.00$250,000.00
SS-330131-305-001212" Pipe Diameter CIPP (7.5 mm)1,500.00LF$60.00$90,000.00
SS-330131-305-001515" Pipe Diameter CIPP (9 mm)500.00LF$70.00$35,000.00
SS-330131-305-001818" Pipe Diameter CIPP (9 mm)500.00LF$100.00$50,000.00
SS-330131-305-002121" Pipe Diameter CIPP (9 mm)500.00LF$115.00$57,500.00
SS-330139-304-001Cured-in-place lateral and lateral connection liner, 8" to 12" main, 4" & 6" lateral pipe up to 20 linear feet-initial15.00EA$5,000.00$75,000.00
SS-330139-304-002Cured in Place Lateral liner 4" & 6" pipe - additional100.00LF$70.00$7,000.00
SUBTOTAL$1,824,500.00
PIPE REHABILITATION WITH CIPP LINER, FURNISH AND INSTALLATION - Stormwater
460-300-015115" Pipe Diameter CIPP (9 mm)8,000.00LF$101.00$808,000.00
460-300-015215" Pipe Diameter - Add/deduct per 1 mm increment variance2,500.00LF$3.00$7,500.00
460-300-018118" Pipe Diameter CIPP (9 mm)4,000.00LF$109.00$436,000.00
460-300-018218" Pipe Diameter - Add/deduct per 1 mm increment variance8,000.00LF$3.00$24,000.00
460-300-021121" Pipe Diameter CIPP (9 mm)160.00LF$112.00$17,920.00
460-300-021221" Pipe Diameter - Add/deduct per 1 mm increment variance300.00LF$4.00$1,200.00
460-300-024124" Pipe Diameter CIPP (10.5 mm)4,000.00LF$148.00$592,000.00
460-300-024224" Pipe Diameter - Add/deduct per 1 mm increment variance8,000.00LF$7.00$56,000.00
460-300-030130" Pipe Diameter CIPP (13.5 mm)3,000.00LF$202.00$606,000.00
460-300-030230" Pipe Diameter - Add/deduct per 1 mm increment variance5,500.00LF$8.00$44,000.00
460-300-036136" Pipe Diameter CIPP (13.5 mm)3,000.00LF$217.00$651,000.00
460-300-036236" Pipe Diameter - Add/deduct per 1 mm increment variance20,000.00LF$10.00$200,000.00
460-300-042142" Pipe Diameter CIPP (13.5 mm)2,000.00LF$279.00$558,000.00
460-300-042242" Pipe Diameter - Add/deduct per 1 mm increment variance13,000.00LF$11.00$143,000.00
460-300-048148" Pipe Diameter CIPP (15 mm)1,500.00LF$310.00$465,000.00
460-300-048248" Pipe Diameter - Add/deduct per 1 mm increment variance20,000.00LF$17.00$340,000.00
460-300-054154" Pipe Diameter CIPP (18 mm)800.00LF$403.00$322,400.00
460-300-054254" Pipe Diameter - Add/deduct per 1 mm increment variance7,500.00LF$19.00$142,500.00
460-300-060160" Pipe Diameter CIPP (21 mm)700.00LF$465.00$325,500.00
460-300-060260" Pipe Diameter - Add/deduct per 1 mm increment variance9,000.00LF$22.00$198,000.00
460-300-066166" Pipe Diameter CIPP (21 mm)100.00LF$550.00$55,000.00
460-300-066266" Pipe Diameter - Add/deduct per 1 mm increment variance100.00LF$25.00$2,500.00
460-300-072172" Pipe Diameter CIPP (22.5 mm)80.00LF$635.00$50,800.00
460-300-072272" Pipe Diameter - Add/deduct per 1 mm increment variance80.00LF$28.00$2,240.00
SUBTOTAL$ 9,697,560.00$ 11,691,200.00
RECONNECT SERVICE LINE - Sanitary Sewer
SS-330131-307-001Reconnect Service Line600.00EA$233.00$ 139,800.00
SUBTOTAL$ 139,800.00$ 11,831,000.00
LIFTING OF STRUCTURAL LIDS
460-250-0001Lifting of Structure Lids100.00EA$450.00$ 45,000.00
SUBTOTAL$ 45,000.00$ 11,876,000.00
JOINT REPAIRS BY INJECTION
460-500-0001Joint Repairs by Injection60.00GAL$50.00$ 3,000.00
SUBTOTAL$ 3,000.00$ 11,879,000.00
CURING WATER REMOVAL
460-300-0099Curing Water Removal (per 1,000 gallons)3,000.00EA$39.00$ 117,000.00
SUBTOTAL$ 117,000.00$ 11,996,000.00
INTERNAL POINT REPAIRS
460-400-2101Internal Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length50.00EA$2,670.00$ 133,500.00
460-400-2103Internal Repair - 6" - 21" Diameter Pipe - Additional 1-ft Incremental Length60.00LF$223.00$ 13,380.00
460-400-2401Internal Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length60.00EA$3,709.00$ 222,540.00
460-400-2403Internal Repair - 24" - 30" Diameter Pipe - Additional 1-ft Incremental Length120.00LF$445.00$ 53,400.00
460-400-3601Internal Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length20.00EA$4,450.00$ 89,000.00
460-400-3603Internal Repair - 36" - 42" Diameter Pipe - Additional 1-ft Incremental Length20.00LF$520.00$ 10,400.00
460-400-4801Internal Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length20.00EA$5,563.00$ 111,260.00
460-400-4803Internal Repair - 48" - 60" Diameter Pipe - Additional 1-ft Incremental Length50.00LF$742.00$ 37,100.00
460-400-6601Internal Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length30.00EA$7,417.00$ 222,510.00
460-400-6603Internal Repair - 66" - 72" Diameter Pipe - Additional 1-ft Incremental Length30.00LF$1,113.00$ 33,390.00
SUBTOTAL$ 926,480.00$ 12,922,480.00
EXTERNAL POINT REPAIRS
460-401-2101External Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length (0' - 5' Deep)20.00EA$1,484.00$ 29,680.00
460-401-2105External Repair - 6" - 21" Diameter Pipe - Initial 3-ft Length (5' - 10' Deep)10.00EA$3,264.00$ 32,640.00
460-401-2106External Repair - 6" - 21" Diameter Pipe -Additional 1-ft Incremental Length10.00LF$127.00$ 1,270.00
460-401-2401External Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length (0' - 5' Deep)10.00EA$1,780.00$ 17,800.00
460-401-2405External Repair - 24" - 30" Diameter Pipe - Initial 3-ft Length (5' - 10' Deep)10.00EA$4,005.00$ 40,050.00
460-401-2406External Repair - 24" - 30" Diameter Pipe -Additional 1-ft Incremental Length20.00LF$178.00$ 3,560.00
460-401-3601External Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length (0' - 10' Deep)10.00EA$2,522.00$ 25,220.00
460-401-3605External Repair - 36" - 42" Diameter Pipe - Initial 3-ft Length (10' - 15' Deep)10.00EA$5,192.00$ 51,920.00
460-401-3606External Repair - 36" - 42" Diameter Pipe -Additional 1-ft Incremental Length20.00LF$223.00$ 4,460.00
460-401-4801External Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length (0' - 10' Deep)10.00EA$3,709.00$ 37,090.00
460-401-4805External Repair - 48" - 60" Diameter Pipe - Initial 3-ft Length (10' - 15' Deep)10.00EA$6,379.00$ 63,790.00
460-401-4806External Repair - 48" - 60" Diameter Pipe -Additional 1-ft Incremental Length10.00LF$260.00$ 2,600.00
460-401-6601External Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length (0' - 15' Deep)10.00EA$6,675.00$ 66,750.00
460-401-6605External Repair - 66" - 72" Diameter Pipe - Initial 3-ft Length (15' - 20' Deep)10.00EA$9,642.00$ 96,420.00
460-401-6606External Repair - 66" - 72" Diameter Pipe -Additional 1-ft Incremental Length10.00LF$300.00$ 3,000.00
SUBTOTAL$ 476,250.00$ 13,398,730.00
UNSPECIFIED
999-0000UNSPECIFIED WORK200,000.00EA$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 .