The URL can be used to link to this page

Home My WebLink AboutPrice Industrial Electric = FQS -, Cont. 1086 - 2.3.2025CITY OF WATERLOO, IOWA FINAL QUANTITY SUMMARY_ PROJECT: FY 2024 FIBER-OPTIC OUTSIDE PLANT (OSP), ECONOMIC DEVELOPMENT ADMINSTRATION (EDA) AWARD NUMBER 05-79-06185, CONTRACT NO. 1086 Date Prepared: 01/13/2025 AMOUNT: $ 530,318.39 DECREASE TO: PRICE INDUSTRIAL ELECTRIC., Contractor You are hereby ordered to make the following changes from the plans and specifications or perform the following extra work on your contract dated 02/05/2024. A. Description of change to be made or extra work to be done: Adjustinent of original construction quantities and contract amounts to actual construction quantities and actual amounts. B. Reason for ordering change or extra work: Construction is complete. C. Settlement for cost of work to be made as follows: Compensation to be made to contractor through bid items. See attached summary. Total Net Decrease $530,318.39 CITY OF WATERLOO BY: Q 2 /7 1/2 9 5 21312, Mayor Date ATTEST: City Clerk Date CON BY: -2s" PRINTED NAME: ern' -' KiPh City Engineer TITLE: APPROVED: 1/16/2025 ity Engineer Date Exhibit P - Schedule of Values JOB NAME: Waterloo EDA Fiber APPLICATION NUMBER: 10 APPLICATION DATE: 1/15/2025 A B C D E G H I ITEM NO. DESCRIPTION OF WORK ORIGINAL QUANTITY CHANGE ORDERS TOTAL APPROVED QUANTITY UNIT PRICE ORGINAL CONTRACT AMOUNT TOTAL AMOUNT APPROVED WITH CO's UNITS COMPLETED FROM PREVIOUS APPLICATION (D+E) AMOUNT APPROVED FROM PREVIOUS APPLICATION UNITS COMPLETE D THIS PERIOD AMOUNT COMPLETED THIS PERIOD TOTAL UNITS COMPLETED TO DATE (D+E) TOTAL AMOUNT APPROVED TO DATE UNIT COMPLETE D PERCENT (G/C) QUANTITY TO FINISH BALANCE TO FINISH RETAINAGE TO DATE 1 Directional Bore (0) 1" and (0) 2" and (2) 1.25" 174 -174 0 $20.00 $3,480.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 2 Directional Bore (0) 1" and (0) 2" and (3) 1.25" 53,103 -3,861 49,242 $13.15 $698,304.45 $647,532.30 49,242 $ 647,532.30 $ - 49,242 $ 647,532.30 100.00% 0 $0 $0.00 4 Directional Bore (0) 1" and (1) 2" and (2) 1.25" 143 98 241 $20.00 $2,860.00 $4,820.00 241 $ 4,820.00 $ - 241 $ 4,820.00 100.00% 0 $0 $0.00 5 Directional Bore (0) 1" and (1) 2" and (3) 1.25" 3,334 -274 3,060 $14.40 $48,009.60 $44,064.00 3,060 $ 44,064.00 $ - 3,060 $ 44,064.00 100.00% 0 $0 $0.00 11 Directional Bore (1) 1" and (0) 2" and (0) 1.25" 3,118 -3,118 0 $11.15 $34,765.70 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 14 Directional Bore (1) 1" and (0) 2" and (3) 1.25" 14,395 -1,055 13,340 $14.15 $203,689.25 $188,761.00 13,340 $ 188,761.00 $ - 13,340 $ 188,761.00 100.00% 0 $0 $0.00 28 Bore 6" Casing (Steel) 1 -1 0 $200.00 $200.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 29 Bore 6" Casing (PVC) 1 -1 0 $200.00 $200.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 30 Bore 8" Casing (Steel) 1,083 -1,083 0 $50.00 $54,150.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 31 Bore 8" Casing (PVC) 1 -1 0 $200.00 $200.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 33 Install Muletape in New Conduit 234,192 -86,026 148,166 $0.50 $117,096.00 $74,083.00 148,166 $ 74,083.00 $ - 148,166 $ 74,083.00 100.00% 0 $0 $0.00 36 Install #12 AWG Insulated Tracer Wire 68,763 5,520 74,283 $0.25 $17,190.75 $18,570.75 74,283 $ 18,570.75 $ - 74,283 $ 18,570.75 100.00% 0 $0 $0.00 37 Install 5/8"x8' Copper Clad Ground Rod 35 -10 25 $40.00 $1,400.00 $1,000.00 25 $ 1,000.00 $ - 25 $ 1,000.00 100.00% 0 $0 $0.00 38 Install 3.5" Dia PVC Round Marker Posts with Orange Dome Top 87 -87 0 $100.00 $8,700.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 39 Install 3.5" Dia PVC Round Marker Posts with Orange Dome Top with Test Station 29 -5 24 $350.00 $10,150.00 $8,400.00 24 $ 8,400.00 $ - 24 $ 8,400.00 100.00% 0 $0 $0.00 46 Installation, Underground Fiber Cable - Including Slack (All other fiber) 77,388 -7,296 70,092 $1.50 $116,082.00 $105,138.00 70,092 $ 105,138.00 $ - 70,092 $ 105,138.00 100.00% 0 $0 $0.00 51 Installation, Vault 24" x 36" 77 -4 73 $800.00 $61,600.00 $58,400.00 73 $ 58,400.00 $ - 73 $ 58,400.00 100.00% 0 $0 $0.00 52 Installation, Large Vault 30" x 48" 2 6 8 $1,000.00 $2,000.00 $8,000.00 8 $ 8,000.00 $ - 8 $ 8,000.00 100.00% 0 $0 $0.00 53 Installation, Extra Large Vault 48" x 60" 2 -2 0 $1,500.00 $3,000.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 57 Sawcut, Remove and Replace Asphalt 6" Thick 1,146 -1,146 0 $17.00 $19,487.67 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 58 Sawcut, Remove and Replace Concrete 6" Thick 1,146 -1,146 0 $17.00 $19,487.67 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 60 Sawcut, Remove and Replace Asphalt 8" Thick 1,146 -1,146 0 $24.00 $27,512.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 61 Sawcut, Remove and Replace Concrete 8" Thick 1,146 -1,146 0 $24.00 $27,512.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 62 Sawcut, Remove and Replace Asphalt 10" Thick 1,146 -1,146 0 $30.00 $34,390.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 63 Sawcut, Remove and Replace Concrete 10" Thick 1,146 -1,146 0 $30.00 $34,390.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 127 Install New Splice Case & Prep Cable 10 -2 8 $300.00 $3,000.00 $2,400.00 8 $ 2,400.00 $ - 8 $ 2,400.00 100.00% 0 $0 $0.00 130 Splicing, Fusion, Single Fiber 2,880 -2,304 576 $30.00 $86,390.64 $17,280.00 576 $ 17,280.00 $ - 576 $ 17,280.00 100.00% 0 $0 $0.00 131 Splicing Fusion, Single fiber Pigtail at panel 562 -562 0 $30.00 $16,860.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 134 Testing, OTDR, Bi-Directional, Power Meter Testing 562 14 576 $6.00 $3,372.00 $3,456.00 576 $ 3,456.00 $ - 576 $ 3,456.00 100.00% 0 $0 $0.00 148 Install rack mounted patch panel (Any Size) and tails 2 -2 0 $500.00 $1,000.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 149 Install Wall Mount Fiber Enclosure 2 -2 0 $500.00 $1,000.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 150 Install 7ft Rack for patch panels 1 -1 0 $500.00 $500.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 161 Pull fiber through building 300 -300 0 $3.50 $1,050.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 162 Install 2" Electric Metal Tubing (EMT) 15 -15 0 $60.00 $900.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 163 4" Core Bore 3 -3 0 $500.00 $1,500.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 164 2" Building Riser with LB - Up to 10' 3 -3 0 $1,000.00 $3,000.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 178 24 CT Fiber Cable 527 -527 0 $0.47 $247.69 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 180 96 CT Fiber Cable 3,235 -3,235 0 $1.08 $3,493.80 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 183 288 CT Fiber Cable 73,627 73,627 $2.80 $206,155.60 $206,155.60 73,627 $ 206,155.60 $ - 73,627 $ 206,155.60 100.00% 0 $0 $0.00 196 1" HDPE Roll Conduit, Orange -SDR 11 17,513 -2,513 15,000 $0.44 $7,705.72 $6,600.00 15,000 $ 6,600.00 $ - 15,000 $ 6,600.00 100.00% 0 $0 $0.00 197 1.25" HDPE Roll Conduit, Orange - SDR 11 213,130 213,130 $0.35 $74,595.50 $74,595.50 213,130 $ 74,595.50 $ - 213,130 $ 74,595.50 100.00% 0 $0 $0.00 198 2" HDPE Roll Conduit, Orange - SDR 11 3,477 3,477 $0.71 $2,468.67 $2,468.67 3,477 $ 2,468.67 $ - 3,477 $ 2,468.67 100.00% 0 $0 $0.00 202 Mule Tape 234,192 -39,192 195,000 $0.03 $7,025.76 $5,850.00 195,000 $ 5,850.00 $ - 195,000 $ 5,850.00 100.00% 0 $0 $0.00 203 #12 AWG Solid Thhn Insulated Tracer Wire 68,763 18,737 87,500 $0.27 $18,566.01 $23,625.00 87,500 $ 23,625.00 $ - 87,500 $ 23,625.00 100.00% 0 $0 $0.00 204 5/8"x8' Copper Clad Ground Rod 35 35 $26.45 $925.75 $925.75 35 $ 925.75 $ - 35 $ 925.75 100.00% 0 $0 $0.00 207 Vault, 24" x 36" 77 -2 75 $654.35 $50,384.95 $49,076.25 75 $ 49,076.25 $ - 75 $ 49,076.25 100.00% 0 $0 $0.00 208 Large Vault, 30" x 48" 2 6 8 $920.00 $1,840.00 $7,360.00 8 $ 7,360.00 $ - 8 $ 7,360.00 100.00% 0 $0 $0.00 209 Extra Large Vault 48" x 60" (Split Lid) 2 -2 0 $1,592.75 $3,185.50 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 215 3.5" Dia PVC Round Marker Posts with Orange Dome Top, 8 ft. in length 87 -87 0 $28.52 $2,481.24 $0.00 $ $ 0 $ 100.00% 0 $0 $0.00 216 3.5" Dia PVC Round Locate Posts with Orange "Top Hat", 8 ft. in length with shorting straps 29 29 $50.54 $1,465.66 $1,465.66 29 $ 1,465.66 $ - 29 $ 1,465.66 100.00% 0 $0 $0.00 219 6" SDR 11 36 -36 0 $12.00 $432.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 220 8" SDR 11 1,083 -1,083 0 $10.00 $10,830.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 221 6" Steel Casing 36 -36 0 $75.00 $2,700.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 222 8" Steel Casing 36 -36 0 $100.00 $3,600.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 235 FOSC 450 D Closure 10 -2 8 $505.00 $5,050.00 $4,040.00 8 $ 4,040.00 $ - 8 $ 4,040.00 100.00% 0 $0 $0.00 236 D Size splice Tray 20 -12 8 $50.00 $1,000.00 $400.00 8 $ 400.00 $ - 8 $ 400.00 100.00% 0 $0 $0.00 237 Slack Basket for D-Gel Closure 10 -2 8 $35.00 $350.00 $280.00 8 $ 280.00 $ - 8 $ 280.00 100.00% 0 $0 $0.00 284 288 port rack mount panel 2 -2 0 $9,700.00 $19,400.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 285 Wall Mount Fiber Enclosure 2 -2 0 $250.00 $500.00 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 286 7ft Rack for patch panels 1 -1 0 $232.30 $232.30 $0.00 $ - $ - 0 $ - 100.00% 0 $0 $0.00 287 NEMA Enclosure 3 1 -3 0 $2,000.00 $6,000.00 $9,289.70 $0.00 $ - $ - 0 $ - 100.00% 100.00% 0 0 $0 $0.00 CO1 RR Insurance and Flagging Fees 1 $9,289.70 $9,289.70 1 $ 9,289.70 $ - 1 $ 9,289.70 $0 $0.00 TOTALS 1,083,082 -135,460 947,622 $2,104,355.57 $1,574,037.18 947,6201 $ 1,574,037.18 0 $ - 947,620 $ 1,574,037.18 100.00% - $0 $0.00