Spreadsheet: 838890d1691496318-average-based-on-part-number-if-statement-ls-test
Sheet: 002228A

PROJECT NAME:  [NAME] Project                                               BID COMPARISON PID NO.: 002228A  BID NO.:  23-0427-ITB-CP
 |  |  |  |  | Engineer Estimate | CONE & GRAHAM |  | Difference from [NAME] | GOSALIA CONCRETE CONSTRUCTORS INC. |  | Difference from [NAME] | KIEWIT INFRASTRUCTURE SOUTH CO |  | Difference from [NAME] |  |  | sum Cone | sum [NAME] | sum Kiewit
Pay Item No. | Description | Quantity | Unit | Unit Price | Amount | Unit Price | Amount |  | Unit Price | Amount |  | Unit Price | Amount |  | Avg | [NAME]
700-20-11 | SIGN, SINGLE POST- LESS THAN 12 SF | 1 | AS | 750 |  | 149 |  |  | 837.28 |  |  | 1000
700-20-40 | SIGN, SINGLE POST, RELOCATE | 1 | AS | 390 |  | 24 |  |  | 239.45 |  |  | 1000
700-20-60 | SIGN, SINGLE POST, REMOVE | 1 | AS | 175 |  | 212 |  |  | 38.57 |  |  | 1000
401-70-2 | SPALL AREAS RESTORATION | 30 | CF | 1000 |  | 834.43 |  |  | 730 |  |  | 1000
400-4-5 | CONCRETE CLASS IV, SUBSTRUCTURE | 23.5 | CY | 2200 |  | 1285.69 |  |  | 2600 |  |  | 2100 |  |  |  | 71
400-4-8 | CONCRETE CLASS IV, BULKHEAD | 196.1 | CY | 1550 |  | 1953.5 |  |  | 3850 |  |  | 3500
104-7 | INLET PROTECTION SYSTEMS | 21 | EA | 200 |  | 155.87 |  |  | 100 |  |  | 200
[PHONE] | INLET, [NAME], FDOT Type S, <10' | 9 | EA | 7500 |  | 9873.5 |  |  | 14000 |  |  | 20000
[PHONE] | INLET, [NAME], PCED [NAME], 3'-6" x 4'-6", Index 1260, < 10' | 5 | EA | 13500 |  | 17367.96 |  |  | 21000 |  |  | 20000
[PHONE] | INLET, [NAME], PCED Type J-6, 4'-6" x 3'-6", Index 1260, < 10' | 1 | EA | 12500 |  | 17535.19 |  |  | 22000 |  |  | 20000
536-86 | GUARDRAIL, End Anchorage, Type ET- 2000 | 2 | EA | 3500 |  | 3600 |  |  | 3600 |  |  | 5500
706-3 | PAVEMENT MARKERS, RETRO-REFLECTIVE | 131 | EA | 5 |  | 4.06 |  |  | 4.06 |  |  | 7.5
700-13-15 | RETROREFLECTIVE SIGN STRIP - FURNISH AND INSTALL, 5' | 1 | EA | 150 |  | 521 |  |  | 340.7 |  |  | 29
999-1000 | Unspecified | 470000 | EA | 1 |  | 1 |  |  | 1 |  |  | 1
102-1099 | SIGN, VARIABLE MESSAGE (3 Lines) (Temporary) | 360 | ED | 17 |  | 16 |  |  | 18 |  |  | 28
415-1-5 | REINFORCING STEEL, SUBSTRUCTURE | 1460 | LB | 2.5 |  | 1.82 |  |  | 3 |  |  | 1.9
415-1-7 | REINFORCING STEEL, BULKHEAD | 15241 | LB | 3.5 |  | 2.09 |  |  | 3 |  |  | 1.9
460-2-2 | STRUCTURAL STEEL, LOW ALLOY | 781.64 | LB | 15 |  | 21.71 |  |  | 25 |  |  | 30
104-6 | SEDIMENT BARRIERS | 1440 | LF | 3 |  | 5 |  |  | 2.05 |  |  | 2
104-16 | TURBIDITY BARRIER, Floating | 1085 | LF | 20 |  | 12.96 |  |  | 10 |  |  | 20
110-73 | REMOVE EXISTING BULKHEAD | 992 | LF | 100 |  | 36.92 |  |  | 150 |  |  | 500
411-1 | EPOXY INJECTION OF CRACKS IN CONCRETE STRUCTURES | 200 | LF | 300 |  | 87.21 |  |  | 260 |  |  | 38
[PHONE] | PIPE CULVERT, CONCRETE, Round, 18" ID | 968 | LF | 160 |  | 147.54 |  |  | 231 |  |  | 350
520-1000-0700 | CURB & GUTTER, Concrete, FDOT Type E | 183 | LF | 60 |  | 27.5 |  |  | 115 |  |  | 90
520-6 | SHOULDER GUTTER-CONCRETE | 939 | LF | 60 |  | 35 |  |  | 110 |  |  | 100
536-1-1 | GUARDRAIL, Roadway | 163 | LF | 35 |  | 46.5 |  | 0 | 46.5 |  |  | 70
536-73 | GUARDRAIL, REMOVAL | 153 | LF | 15 |  | 10 |  |  | 10 |  |  | 15
710-11-123 | PAINTED PAVEMENT MARKING, STD, WHITE, SOLID, 12" | 128 | LF | 6 |  | 1.94 |  |  | 1.94 |  |  | 3
710-11-125 | PAINTED PAVEMENT MARKING, STD, WHITE, SOLID, 24" | 100 | LF | 12 |  | 3.6 |  |  | 3.6 |  |  | 5.5
710-11-224 | PAINTED PAVEMENT MARKING, STD, YELLOW, SOLID, 18" | 158 | LF | 7 |  | 2.6 |  |  | 2.6 |  |  | 5
800-1615 | IRRIGATION (SPRINKLER) REPAIR OR REPLACE, Including Fittings, Heads, and Related Appurtenances | 20 | LF | 14 |  | 50 |  |  | 458.83 |  |  | 200
005-0700 | Survey,  [NAME] | 1 | LS | 10000 |  | 20350 |  |  | 20000 |  |  | 100000
005-0800 | Survey, Quantity Measurements | 1 | LS | 10000 |  | 11550 |  |  | 4500 |  |  | 50000
005-0850 | Survey, As-Built Survey | 1 | LS | 5000 |  | 11550 |  |  | 5600 |  |  | 50000
101-0100 | MOBILIZATION | 1 | LS | 240000 |  | 441000 |  |  | 170000 |  |  | 830000
102-1000 | [NAME] | 1 | LS | 250000 |  | 185000 |  |  | 145000 |  |  | 600000
104-1 | PREVENTION, CONTROL AND ABATEMENT OF EROSION AND WATER POLLUTION | 1 | LS | 10000 |  | 38791.56 |  |  | 27500 |  |  | 106000
108-1 | MONITOR EXISTING STRUCTURES - INSPECTION AND SETTLEMENT MONITORING | 1 | LS | 16000 |  | 7500 |  |  | 110000 |  |  | 12000
108-2 | MONITOR EXISTING STRUCTURES - VIBRATION MONITORING | 1 | LS | 30000 |  | 49375 |  |  | 15000 |  |  | 55000
110-0100 | CLEARING & GRUBBING | 1 | LS | 25000 |  | 155463.61 |  |  | 310000 |  |  | 250000
120-0810 | DEWATERING | 1 | LS | 10000 |  | 23000 |  |  | 75000 |  |  | 10000
120-1100 | GRADING | 1 | LS | 20000 |  | 92074.56 |  |  | 125000 |  |  | 500000
710-11-111 | PAINTED PAVEMENT MARKING, STD, WHITE, SOLID, 6" | 0.46 | NM | 5100 |  | 1800 |  |  | 1800 |  |  | 7000
710-11-211 | PAINTED PAVEMENT MARKING, STD, YELLOW, SOLID, 6" | 0.54 | NM | 5000 |  | 1800 |  |  | 1800 |  |  | 7000
455-133-1 | PILING, SHEET, STEEL | 31723.2 | SF | 80 |  | 51.46 |  |  | 60.3 |  |  | 86
527-2 | [NAME] | 47.5 | SF | 200 |  | 55 |  |  | 50 |  |  | 80
380-1150 | MILLING EXISTING ASPHALT PAVEMENT, 1-1/2" Average Depth | 3565.8 | SY | 15 |  | 5.75 |  |  | 4.3 |  |  | 4.25
514-11 | PLASTIC EROSION MAT, E-3 FDOT Index No. 199 | 483.4 | SY | 15 |  | 32.88 |  |  | 30 |  |  | 20
522-0006 | SIDEWALK, CONCRETE, 6" Min. Thickness | 1159.2 | SY | 125 |  | 66.1 |  |  | 135 |  |  | 140
575-0105 | SODDING, [NAME], (Including Water & Fertilizer) | 4540.21 | SY | 7 |  | 3.15 |  |  | 4.56 |  |  | 5
102-5000 | WATER, for Dust Control | 30 | THG | 100 |  | 830.04 |  |  | 200 |  |  | 500
125-3057 | BEDDING MATERIAL, Crushed Stone, Size #57 | 4.2 | TN | 150 |  | 449.11 |  |  | 1000 |  |  | 600
234-1250-000 | SUPERPAVE ASPHALT BASE, Type B 12.5, Variable Thickness | 287.6 | TN | 163 |  | 215.5 |  |  | 335 |  |  | 210
334-0095-000 | SUPERPAVE ASPHALT CONCRETE, Leveling Course, Type SP 9.5, Fine, Traffic Level C, Variable Thickness | 10 | TN | 250 |  | 341.25 |  |  | 860 |  |  | 700
334-3125-000 | SUPERPAVE ASPHALT CONCRETE, Type SP 12.5, Fine, Traffic Level C, Variable Thickness | 390 | TN | 287 |  | 170 |  |  | 220 |  |  | 250
339-1 | ASPHALT, [NAME] | 5.6 | TN | 670 |  | 701.25 |  |  | 1490 |  |  | 2500
530-2200 | RIPRAP, Rubble, w/Filter Fabric | 20 | TN | 250 |  | 610.01 |  |  | 330 |  |  | 600
 |  | TOTAL BID