Spreadsheet: 838885d1691495235-average-based-on-part-number-if-statement-ls-test
Sheet: 000087A

PROJECT NAME:  22nd Ave South (51st St S - 34th St S) Roadway Improvements     BID COMPARISON PID NO.:  000087A  BID NO.:  23-0326-ITB-CP
 |  |  |  |  | Engineer Estimate |  | Kamminga & Roodvoets, Inc. | Difference from [NAME]
Pay Item No. | Description | Quantity | Unit | Unit Price | Amount | Unit Price | Amount
ROADWAY & DRAINAGE
639-1-122 | ELECTRICAL POWER SERVICE, UNDERGROUND, METER PURCHASED BY CONTRACTOR | 3 | AS | 3986.83 |  | 3575
654-2-12 | MIDBLOCK CROSSWALK: RECTANGULAR RAPID FLASHING BEACON, FURNISH & INSTALL- AC, COMPLETE SIGN ASSEMBLY- BACK TO BACK | 2 | AS | 12675 |  | 17950
660-2-101 | LOOP ASSEMBLY, TYPE A, 6' x 20', F & I | 2 | AS | 3100 |  | 1150
660-2-106 | [NAME], TYPE F | 5 | AS | 1354.54 |  | 1350
670-5-400 | TRAFFIC CONTROLLER ASSEMBLY, MODIFY | 2 | AS | 3500 |  | 3500
700-1-11 | SINGLE POST SIGN, F&I GROUND MOUNT,- UP TO 12 SF | 32 | AS | 511.25 |  | 566.5
700-11-152 | ELECTRONIC DISPLAY SIGN, FURNISH & INSTALL GROUND MOUNT- AC POWERED, ELECT REGULATORY W/FLASHING BEACON, 12-20 SF | 2 | AS | 13515.84 |  | 17663
700-1-12 | SINGLE POST SIGN, F&I GROUND MOUNT,- UP TO 12 TO 20 SF | 6 | AS | 1612.63 |  | 1800
700-1-13 | SINGLE POST SIGN, F&I GROUND MOUNT,- UP TO 21 TO 30 SF | 1 | AS | 2252.42 |  | 2000
700-1-50 | SINGLE POST SIGN, RELOCATE | 3 | AS | 337.5 |  | 200
700-1-60 | SINGLE POST SIGN, REMOVE | 41 | AS | 63.33 |  | 30
120-4 | SUBSOIL EXCAVATION | 30 | CY | 22.5 |  | 200
104-18 | INLET PROTECTION SYSTEM | 62 | EA | 188.75 |  | 150
[PHONE] | INLET, Curb, FDOT Type P-3, 4'-0" ID, < 10' | 17 | EA | 14579.39 |  | 10000
[PHONE] | INLET, Curb, FDOT Type P-4, 4'-0" ID, < 10' | 4 | EA | 12875.55 |  | 9900
425-1-561 | INLET, DITCH BOTTOM, FDOT TYPE F, <10' | 2 | EA | 7371.43 |  | 12000
[PHONE] | INLET, Curb, FDOT Type J-4, 8'-0" x 6'-0", < 10' | 1 | EA | 23251.24 |  | 19000
425-2- 71 | MANHOLE, J-7, <10' | 2 | EA | 7183.33 |  | 15000
425-2- 73 | CONVERT INLET TO MANHOLE | 6 | EA | 7974.8 |  | 5000
425-5 | MANHOLE, ADJUST | 1 | EA | 1991.66 |  | 4000
635-2-14 | PULL AND SPLICE BOX, 17" X 30" COVER SIZE | 10 | EA | 1100 |  | 1625
641-2-12 | PRESTRESSED CONCRETE POLE, F&I, TYPE P-II SERVICE POLE | 1 | EA | 1883.6 |  | 2352
660-3-11 | VEHICLE DETECTION SYSTEM - MICROWAVE, F&I, CABINET EQUIPMENT | 1 | EA | 2509.61 |  | 13995
660-3-12 | VEHICLE DETECTION SYSTEM- MICROWAVE, FURNISH & INSTALL, ABOVE GROUND EQUIPMENT | 1 | EA | 10900.3 |  | 11617
700-13-15 | RETROREFLECTIVE SIGN STRIP- FURNISH AND INSTALL, 5' | 4 | EA | 80.95 |  | 100
706-1-31 | RAISED PAVEMENT MARKER, TYPE B, YELLOW/YELLOW | 546 | EA | 4.62 |  | 4.5
706-1-32 | RAISED PAVEMENT MARKER, TYPE B, WHITE/RED | 345 | EA | 4.62 |  | 4.5
706-1-33 | RAISED PAVEMENT MARKER, TYPE B, BLUE | 17 | EA | 4.62 |  | 4.5
710-11-160 | PAINTED PAVEMENT MARKING, STD, WHITE, MESSAGE (SCHOOL) | 4 | EA | 150 |  | 50
710-11-171 | PAINTED PAVEMENT MARKING, STD, WHITE, ARROWS ([NAME]) | 11 | EA | 36.6 |  | 25
710-11-172 | PAINTED PAVEMENT MARKING, STD, WHITE, ARROWS (RIGHT) | 1 | EA | 36.6 |  | 25
711-11-160 | THERMOPLASTIC, STANDARD, WHITE, MESSAGE (SCHOOL) | 4 | EA | 150 |  | 200
711-11-171 | THERMOPLASTIC, STANDARD, WHITE, ARROW (LEFT) | 11 | EA | 77.96 |  | 60
711-11-172 | THERMOPLASTIC, STANDARD, WHITE, ARROW (RIGHT) | 1 | EA | 77.96 |  | 60
710-11-101 | PAINTED PAVEMENT MARKING, STD, WHITE, SOLID, 6" | 3.19 | GM | 2152.19 |  | 950
710-11-131 | PAINTED PAVEMENT MARKING, STD, WHITE, 10'-30', SKIP, 6" | 2.06 | GM | 585 |  | 450
710-11-201 | PAINTED PAVEMENT MARKING, STD, YELLOW, SOLID, 6" | 3.06 | GM | 2850 |  | 950
710-11-241 | PAINTED PAVEMENT MARKING, STD, YELLOW, DOTTED/GUIDELINE/ 6-10 GAP EXTENSION 6" | 0.034 | GM | 524.55 |  | 600
711-11-241 | THERMOPLASTIC, STANDARD, YELLOW, DOTTED GUIDELINE,6-10 DOTTED, 6" | 0.034 | GM | 2719.16 |  | 4000
711-15-101 | THERMOPLASTIC, STANDARD-OPEN GRADED ASPHALT SURFACES WHITE, SOLID, 6" | 2.424 | GM | 5740.14 |  | 5500
711-15-131 | THERMOPLASTIC, STANDARD-OPEN GRADED ASPHALT SURFACES, WHITE, SKIP, 6",10-30 SKIP OR 3-9 LANE DROP | 1.91 | GM | 1901.33 |  | 1800
711-15-201 | THERMOPLASTIC, STANDARD-OPEN GRADED ASPHALT SURFACES, YELLOW, SOLID, 6" | 2.601 | GM | 6531.71 |  | 5500
102-71-13 | [NAME], F&I, LOW PROFILE, CONCRETE | 1207 | LF | 66 |  | 56
104-10-3 | SEDIMENT BARRIER | 1280 | LF | 2.97 |  | 2
104-11 | TURBIDITY BARRIER, FLOATING | 52 | LF | 25 |  | 20
110-0130 | GRANITE CURB, REMOVAL | 3011 | LF | 24 |  | 7
430-175-115 | PIPE CULVERT, CONCRETE, Round, 15" ID | 633 | LF | 112.98 |  | 150
430-175-118 | PIPE CULVERT, CONCRETE, Round, 18" ID | 397 | LF | 123.13 |  | 155
430-175-124 | PIPE CULVERT, CONCRETE, Round, 24" ID | 568 | LF | 189 |  | 160
430-175-215 | PIPE CULVERT, CONCRETE, Elliptical, 12" x 18" ID | 133 | LF | 130.57 |  | 230
520-1-10 | CURB & GUTTER, Concrete, Type F | 3009 | LF | 46.75 |  | 69
520-2-4 | CURB & GUTTER, Concrete, Type D | 87 | LF | 51.1 |  | 49
520-3010-1000 | CURB, GRANITE, Re-Install | 1500 | LF | 45 |  | 50
630-2-11 | CONDUIT, SIGNALS, F & I, UNDERGROUND (2") | 110 | LF | 20 |  | 18
630-2-12 | CONDUIT, F & I, DIRECTIONAL BORE | 345 | LF | 30 |  | 35
630-2-14 | CONDUIT, SIGNALS, F & I, ABOVEGROUND (2") | 210 | LF | 41.06 |  | 44
639-2-1 | ELECTRICAL SERVICE WIRE, F&I | 345 | LF | 15 |  | 8.5
710-11-123 | PAINTED PAVEMENT MARKING, STD, WHITE, SOLID, 12" | 2112 | LF | 2.08 |  | 1
710-11-125 | PAINTED PAVEMENT MARKINGS, STD., WHITE, SOLID FOR STOP LINE, 24" | 634 | LF | 2.75 |  | 1.25
710-11-224 | PAINTED PAVEMENT MARKING, STD, YELLOW, SOLID, 18" | 687 | LF | 3.5 |  | 1.25
711-11-123 | THERMOPLASTIC, STANDARD, WHITE, SOLID, 12" | 2159 | LF | 6.08 |  | 4
711-11-125 | THERMOPLASTIC, STANDARD, WHITE, SOLID, 24" | 589 | LF | 12 |  | 7
711-11-224 | THERMOPLASTIC, STANDARD, YELLOW, SOLID, 18" | 673 | LF | 5.88 |  | 5
711-14-125 | THERMOPLASTIC, PREFORMED, WHITE, SOLID, 24" FOR CROSSWALK | 2058 | LF | 23.67 |  | 15
800-1615 | IRRIGATION (SPRINKLER) REPAIR, INCLUDING FITTINGS, HEADS, AND_RELATED APPURTENANCES | 1000 | LF | 10 |  | 15
005-0701 | SURVEY AND LAYOUT BY CONTRACTOR | 1 | LS | 30000 |  | 65000
101-0100 | MOBILIZATION | 1 | LS | 122000 |  | 725000
102-1000 | [NAME] | 1 | LS | 269000 |  | 405000
104-10 | PREVENTION, CONTROL AND ABATEMENT OF EROSION & WATER POLLUTION | 1 | LS | 25000 |  | 200000
110-0100 | CLEARING & GRUBBING | 1 | LS | 46267.37 |  | 473000
120-1100 | GRADING | 1 | LS | 63921.9 |  | 402000
999-0000 | UNSPECIFIED AMOUNT | 375000 | LS | 1 |  | 1
527-2 | DETECTABLE WARNING | 1036 | SF | 34.66 |  | 50
710-11-290 | PAINTED PAVEMENT MARKING, STD, YELLOW, ISLAND NOSE | 25 | SF | 2.78 |  | 5
285-711 | OPTIONAL BASE GROUP 11 (TYPE B-12.5) 7" MIN THICKNESS | 1238 | SY | 68 |  | 133
327-70-47 | MILLING EXISTING ASPHALT PAVEMENT, DEPTH VARIES | 2040 | SY | 5 |  | 10
327-70-5 | MILLING EXISTING ASPHALT PAVEMENT, 2" AVG DEPTH | 31192 | SY | 7.73 |  | 6
522-2 | CONCRETE SIDEWALK AND DRIVEWAYS, 6" THICK | 5755 | SY | 102.25 |  | 100
522-2-100 | CONCRETE SIDEWALK AND DRIVEWAYS, 6" THICK, WITH BACK OF SIDEWALK CURB | 369 | SY | 110 |  | 122
524-2-2 | CONCRETE SLOPE PAVEMENT, NON-REINFORCED, 4" | 44 | SY | 124.48 |  | 120
570-1-2 | PERFORMANCE TURF, SOD | 5522 | SY | 6.18 |  | 10
570-1-119 | ST. AUGUSTINE "Floratam" SOD | 276 | SY | 6.18 |  | 12
102-5000 | WATER, for Dust Control | 30 | THG | 200 |  | 120
334-1-53 | SUPERPAVE ASPHALT CONCRETE, TRAFFIC C, PG 76-22, 2" MIN. THICKNESS | 3961.9 | TN | 220 |  | 194.5
 | Roadway & Drainage SUBTOTAL
CITY OF ST. PETERSBURG
G-1.1 | Mobilization | 1 | LS | 120000 |  | 175000
G.3.1 | Clearing and Grubbing (Contingent) | 1 | LS | 10000 |  | 153000
G-3.2 | Excavation, Unsuitable Material (Contingent) | 20 | CY | 100 |  | 150
G-3.3 | Excavation, Rock (Contingent) | 20 | CY | 125 |  | 200
G-3.4 | Excavation, Muck (Contingent) | 20 | CY | 100 |  | 175
G-4.1 | Borrow Material (Contingent) | 20 | CY | 100 |  | 60
[NAME] | Stone Bedding (contingent) | 40 | CY | 150 |  | 100
G-6.1 | Concrete Plain (Contingent) | 20 | CY | 300 |  | 500
G-7.1 | Flowable Fill (Contingent) | 20 | CY | 300 |  | 600
F-1.1 | 6" RJ Ductile Iron Pipe | 5 | LF | 150 |  | 200
[NAME] | 6" RJ PVC Pipe | 123 | LF | 80 |  | 105
F-7.1 | DI Fittings Compact | 226 | LBS | 10 |  | 12
F-13.1 | 6" Existing LS Connection | 1 | EA | 2500 |  | 5000
F-13.2 | 6" Existing Manhole Connection | 1 | EA | 3000 |  | 21000
[NAME] | 30" RJ Ductile Iron Pipe | 378 | LF | 700 |  | 560
W-1.2 | 24" RJ Ductile Iron Pipe | 24 | LF | 450 |  | 500
W-1.3 | 12" RJ Ductile Iron Pipe | 606 | LF | 275 |  | 190
W-1.4 | 8" RJ Ductile Iron Pipe | 1082 | LF | 175 |  | 150
W-1.5 | 6" RJ Ductile Iron Pipe | 57 | LF | 150 |  | 145
W-3.1 | 30" Butterfly Valve and Valve Box | 1 | EA | 15000 |  | 24000
W-3.2 | 12" Butterfly Valve and Valve Box | 5 | EA | 3500 |  | 5400
W-3.3 | 8" Gate Valve and Valve Box | 4 | EA | 2500 |  | 3100
W-3.4 | 6" Gate Valve and Valve Box | 2 | EA | 2000 |  | 2300
[NAME] | 30"x24" Tapping Sleeve, Valve and VB | 2 | EA | 30000 |  | 60000
W-7.1 | DI Fittings Compact | 11600 | LBS | 9 |  | 8
W-8.1 | Hydrant Assembly | 2 | EA | 2500 |  | 9000
W-8.2 | Hydrant Relocation | 5 | EA | 1500 |  | 2500
[NAME] | 8" Temporary Blow-off Assembly | 2 | EA | 3000 |  | 1500
W-9.2 | 4" Temporary Blow-off Assembly | 1 | EA | 2000 |  | 1000
W-13.1 | 30" Existing Main Connection | 2 | EA | 20000 |  | 37500
W-13.2 | 12" Existing Main Connection | 3 | EA | 3500 |  | 6000
W-13.3 | 8" Existing Main Connection | 3 | EA | 3000 |  | 3500
W-13.4 | 6" Existing Main Connection | 2 | EA | 2500 |  | 3400
W-19.1 | Relocate Existing Meter | 35 | EA | 1500 |  | 590
W-23.1 | Manual Air Release Valve | 5 | EA | 2500 |  | 2000
W-25.1 | 30" Line Stop | 2 | EA | 50000 |  | 37800
W-25.2 | 12" Line Stop (Contingent) | 2 | EA | 9000 |  | 13900
W-25.3 | 8" Line Stop (Contingent) | 2 | EA | 7000 |  | 10600
W-25.4 | 6" Line Stop (Contingent) | 2 | EA | 6000 |  | 9000
W-26.1 | Grout Existing Main (Contingent) | 60 | CY | 600 |  | 600
I-1.1 | Construction Phase Engineering & Inspection | 1 | LS | 78865 |  | 0
M-13 | Allowance for Contract Amendment | 1 | LS | 200000 |  | 78336.6
H-1 | Salvage Hydrant Assembly | 2 | EA | 1000 |  | 1000
H-8.1 | Salvage Granite Curve (Contingent) | 20 | LF | 50 |  | 35
N-12.2 | Adjust Water Valve Box | 31 | EA | 600 |  | 370
 | City of St. Petersburg SUBTOTAL