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

BID NAME: 62nd Avenue North & 25the Street North Intersection Improvements              PID No. 002069A BID No. 23-0348-ITB-CP STEP 2
ADDENDUM No. _ (if applicable) |  |  |  | Engineer Estimate |  |  | MTM Contractors Inc. |  | % Difference from Engineer's Estimate |  | MTM Sum minus [NAME] | % of MTM Bid
Pay Item No. | Description | Quantity | Unit | UnitPrice | Amount |  | UnitPrice | Amount
400-4-2 | CONCRETE CLASS IV, Endwalls | 3 | CY | 900 |  |  | 1995
104-15 | SOIL TRACKING PREVENTION DEVICE | 2 | EA | 3000 |  |  | 500
104-18 | INLET PROTECTION SYSTEMS | 9 | EA | 300 |  |  | 225
425-14-11 | INLETS, CURB TYPE J-1, <10' | 4 | EA | 16000 |  |  | 9950
425-2-41 | MANHOLE,P-7, <10" | 1 | EA | 9200 |  |  | 8995
425-2-71 | MANHOLE,J-7, <10" | 3 | EA | 13900 |  |  | 8550
425-5 | MANHOLE, ADJUST | 4 | EA | 1400 |  |  | 3550
[PHONE] | CURB INLET, PCED TYPE RC-3,3'-6" X 3'-6", <10' | 2 | EA | 5600 |  |  | 7500
[PHONE] | CURB, INLET, PCED Type RC-5, 5'-0" x 5'-0", < 10' | 2 | EA | 5400 |  |  | 9500
102-99 | PORTABLE CHANGEABLE MESSAGE SIGN, (Temporary) | 484 | ED | 11 |  |  | 35
102-14 | TRAFFIC CONTROL OFFICER | 76 | HR | 71 |  |  | 95
102-71-13 | [NAME], F&I, LOW PROFILE, Concrete | 119 | LF | 30 |  |  | 95
102-71-23 | [NAME], Relocate, LOW PROFILE, Concrete | 119 | LF | 10 |  |  | 35
104-10-3 | SEDIMENT BARRIER | 3640 | LF | 2 |  |  | 3.75
104-12 | TURBIDITY BARRIER, Staked | 25 | LF | 3 |  |  | 35
430-174-115 | PIPE CULVERT, OPTIONAL MATERIAL, Round, 15" SD | 4 | LF | 285 |  |  | 300
430-174-118 | PIPE CULVERT, OPTIONAL MATERIAL, Round, 18" SD | 20 | LF | 135 |  |  | 355
430-174-124 | PIPE CULVERT, OPTIONAL MATERIAL, Round, 24" SD | 96 | LF | 250 |  |  | 155
430-175-224 | PIPE CULVERT, OPTIONAL MATERIAL,OTHER SHAPE-ELIP/ARCH, 24" S/CD | 2 | LF | 160 |  |  | 500
430-175-230 | PIPE CULVERT, OPTIONAL MATERIAL, OTHERSHAPE-ELIP/ARCH, 30"S/CD | 18 | LF | 230 |  |  | 525
430-175-236 | PIPE CULVERT, OPTIONAL MATERIAL, OTHER SHAPE-ELIP/ARCH, 36" S/CD | 281 | LF | 301 |  |  | 625
430-175-248 | PIPE CULVERT, OPTIONAL MATERIAL, OTHER SHAPE-ELIP/ARCH, 48" S/CD | 337 | LF | 331 |  |  | 1295
515-1-1 | [NAME], STEEL | 35 | LF | 82 |  |  | 250
520-1-10 | CURB & GUTTER, Concrete, FDOT Type F | 1804 | LF | 45 |  |  | 45
520-1305-1000 | CURB & GUTTER, Concrete, Type A, PCED, Index 1305 | 184 | LF | 47 |  |  | 45
520-2-4 | CURB & GUTTER, Concrete, FDOT Type D | 129 | LF | 51 |  |  | 45
550-10 | Reset Existing Fence | 124 | LF | 16 |  |  | 45
800-1615 | IRRIGATION (SPRINKLER) REPAIR, INCLUDING FITTINGS, HEADS, AND RELATED APPURTENANCES | 1500 | LF | 10 |  |  | 15
005-0701 | SURVEY AND LAYOUT BY CONTRACTOR | 1 | LS | 30000 |  |  | 49995
101-0100 | MOBILIZATION | 1 | LS | 120000 |  |  | 250000
102-1000 | [NAME] | 1 | LS | 158700 |  |  | 95375
104-10 | PREVENTION, CONTROL AND ABATEMENT OF EROSION & WATER POLLUTION | 1 | LS | 10000 |  |  | 49995
110-0100 | CLEARING AND GRUBBING | 1 | LS | 100000 |  |  | 115000
120-1100 | GRADING | 1 | LS | 82000 |  |  | 45995
120-1500 | Removal of 2 Signs & 2 Palm Trees at Southernaire Mobile Home Park | 1 | LS | 10000 |  |  | 4500
800-1601 | RESTORATION OF PRIVATELY OWNED FETURES | 1 | LS | 20000 |  |  | 12000
160-4 | Type B Stabilization | 2407 | SY | 17.5 |  |  | 15
287-7-09 | OPTIONAL BASE, Base Group 09 | 2407 | SY | 50 |  |  | 98
327-70-6 | MILLING EXISTING ASPHALT PAVEMENT, 1-1/2" Average Depth | 5068 | SY | 5 |  |  | 6.15
353-0103 | DRIVEWAY RESTORATION, in County Right of Way, DECORATIVE BLOCK placed on pallets | 108 | SY | 150 |  |  | 45
353-102 | DRIVEWAY RESTORATION, In Kind, Decorative Block at 6201 25th Street N | 22 | SY | 150 |  |  | 178
522-2 | CONCRETE SIDEWALK and DRIVEWAYS, 6" Min. Thickness | 2725 | SY | 86 |  |  | 85
522-3006 | SIDEWALK AT TREES, CONCRETE W/REINFORCING STEEL, REMOVE and REPLACE | 108 | SY | 67 |  |  | 125
524-1-49 | CONCRETE DITCH PAVEMENT,  6", REINFORCED | 5 | SY | 82 |  |  | 155
527-2 | [NAME] | 107 | SY | 42 |  |  | 265
570-1-2 | PERFORMANCE TURF, SOD | 3715 | SY | 10.5 |  |  | 6.75
102-5000 | WATER, for Dust Control | 50 | THG | 130 |  |  | 225
334-1-13 | SUPERPAVE [NAME], Traffic Level C | 976 | TN | 151 |  |  | 237.5
Roadway/Drainage
 | Roadway/Drainage Total
Signing and Pavement Markings
700-1-11 | SIGN, SINGLE POST, FURNISH & INSTALL - LESS THAN 12 SF | 11 | AS | 428.63 |  |  | 522
700-1-50 | SIGN, SINGLE POST, RELOCATE | 5 | AS | 323.81 |  |  | 290
700-1-60 | SIGN, SINGLE POST, REMOVE | 7 | AS | 56.58 |  |  | 116
700-2-50 | SIGN, RELOCATE, MULTI - POST | 1 | AS | 6152.97 |  |  | 500
700-3-101 | SIGN PANEL, FURNISH & INSTALL GROUND MOUNT, UP to 12 SF | 2 | AS | 2000 |  |  | 775
705-10-4 | MARKER OBJECT, POST MOUNTED, TYPE END OF ROAD, TYPE 4 | 1 | EA | 224.72 |  |  | 250
706-1-3 | RAISED PAVEMENT MARKER, TYPE B | 105 | EA | 3.71 |  |  | 10
710-11-290 | PAINTED PAVEMENT MARKING, STD, YELLOW, ISLAND NOSE | 8 | SF | 2.42 |  |  | 15
710-90 | PAVEMENT MARKING, PAINTED, FINAL SURFACE | 1 | LS | 13141.06 |  |  | 27500
 | Signing and Pavement Markings Total
Signalization
630-2-11 | CONDUIT, OPEN TRENCH, UNDERGROUND F & I (2") | 195 | LF | 10.89 |  |  | 50
630-2-12 | CONDUIT, F & I, DIRECTIONAL BORE < 6" | 285 | LF | 25.8 |  |  | 112.5
632-7-1 | SIGNAL CABLE, F & I | 1 | PI | 6354.33 |  |  | 21850
635-2-11 | PULL & SPLICE BOX, F & I, 13" X 24" COVER SIZE | 14 | EA | 796.41 |  |  | 1495
639-1-122 | ELECTRICAL POWER SERVICE, F & I, UNDERGROUND, METER PURCHASED BY CONTRACTOR | 1 | AS | 3435.33 |  |  | 7500
639-2-1 | SIGNALS, ELECTRICAL SERVICE WIRE | 160 | LF | 11.68 |  |  | 25
639-3-11 | ELECTRICAL SERVICE DISCONNECT, F & I, POLE MOUNT | 2 | EA | 1398.77 |  |  | 1150
641-2-12 | PRESTRESSED CONCRETE SERVICE POLE, F&I, TYPE II SERVICE POLE | 2 | EA | 1516.32 |  |  | 3450
641-2-80 | PRESTRESSED CONCRETE POLE, COMPLETE POLE REMOVAL - POLE 30' AND GREATER | 2 | EA | 4221.33 |  |  | 17250
646-1-11 | SIGNAL HEAD AUXILIARIES, F & I, ALUMINUM PEDESTAL Aluminum Signal Pole, Pedestal | 9 | EA | 1832.51 |  |  | 3450
649-21-13 | MAST ARM, F & I, DBL ARM 60'-50' | 1 | EA | 69529.72 |  |  | 163250
649-21-9 | STEEL MAST ARM, F & I, DBL ARM 50'-50' | 1 | EA | 81829.96 |  |  | 155250
650-1-23 | TRAFFIC SIGNAL,  F & I, Polycarbonate with Aluminum Top Section, 3 Section, 1 way | 9 | AS | 1013.63 |  |  | 2500
650-1-24 | TRAFFIC SIGNAL,  F & I, Polycarbonate with Aluminum Top Section, 4 Section, 1 way | 2 | EA | 1327.59 |  |  | 3450
653-1-60 | PEDESTRIAN SIGNAL, REMOVE PED SIGNAL - POLE/PEDESTAL TO REMAIN | 1 | AS | 111.47 |  |  | 230
653-191 | PEDESTRIAN SIGNAL, F&I, LED, COUNT DOWN, 1 DIRECTION | 8 | AS | 640.2 |  |  | 1150
660-4-31 | VEHICLE DETECTION SYSTEM- VIDEO INSTALL, CABINET EQUIPMENT | 1 | EA | 17304.88 |  |  | 12650
660-4-32 | VEHICLE DETECTION SYSTEM- VIDEO INSTALL, ABOVE GROUND EQUIPMENT | 4 | EA | 6347.66 |  |  | 18400
663-1-111 | SIGNAL PRIORITY AND PREEMPTION SYSTEM, F&I, OPTICAL, CABINET ELECTRONICS | 1 | EA | 2238.8 |  |  | 11500
663-1-112 | SIGNAL PRIORITY AND PREEMPTION SYSTEM, F&I, OPTICAL, DETECTOR | 4 | EA | 1564.28 |  |  | 5750
665-1-11 | PEDESTRIAN DETECTOR, F&I, Standard | 8 | EA | 281.09 |  |  | 1625
670-5-111 | TRAFFIC CONTROLLER ASSEMBLY, F&I, NEMA, 1 PREEMPTION | 1 | AS | 30495.12 |  |  | 57500
670-5-600 | TRAFFIC CONTROLLER ASSEMBLY, REMOVE CONTROLLER WITH CABINET | 1 | AS | 696.4 |  |  | 1150
685-1-11 | UNINTERRUPTIBLE POWER SUPPLY, FURNISH AND INSTALL, LINE INTERACTIVE | 1 | EA | 4433.75 |  |  | 11150
700-5-21 | INTERNAL ILLUMINATED SIGN, F & I, UP TO 12 SF | 4 | EA | 2647.29 |  |  | 5750
 | Signalization Total
Sanitary Sewer
SS-005-0701 | SURVEY, CONSTRUCTION LAYOUT (SEWER) | 1 | LS | 5400 |  |  | 1500
SS-005-0850 | SURVEY, PERMITTING AS BUILT REQUIREMENTS (SEWER) | 1 | LS | 520 |  |  | 1500
SS-101-0100 | MOBILIZATION | 1 | LS | 4990 |  |  | 15000
SS-102-1000 | [NAME] | 1 | LS | 3600 |  |  | 12995
SS-204-1000 | ROADWAY BASE, CRUSHED CONCRETE/GRADED AGGREGATE, MIN. LBR 100, VARIABLE THICKNESS | 39 | CY | 57 |  |  | 225
SS-[PHONE] | 8" DIA. - CIPP SEWER MAIN | 227 | LF | 51 |  |  | 155
SS-[PHONE] | RECONNECT SERVICE LATERAL | 4 | EA | 162 |  |  | 1995
SS-[PHONE] | 8" DIAMETER FORCEMAIN PIPE OFFSET | 2 | EA | 5400 |  |  | 4595
SS-333900-202-D001 | REPLACE MANHOLE RING & COVER (IN PAVEMENT) | 2 | EA | 1300 |  |  | 2500
 | Sanitary Sewer Total
OTHER ITEMS
999-0000 | UNSPECIFIED WORK ROADWAY AND DRAINAGE | 150000 | EA | 1 |  |  | 1
SS-999-0000 | UNSPECIFIED WORK SANITARY SEWER | 8600 | EA | 1 |  |  | 1
 | OTHER ITEMS SUBTOTAL
 |  | TOTAL BID