1MIS.CIS.01 CONTRACT TIME STATEMENT CONTRACT 8121502 MGR.NO. 096 PAGE 001 CONT 6247 SEC 54 JOB 001 RES ENGR FRIENSENHAHN,JUDITH PROJ RMC - 624754001 HWY IH0010 4615 NW LOOP 410 SAN ANTO CNTY BEXAR DIST 15 CONTRACT PRICE $ 236,350.00 REPORT DATE 11/20/2013 10.09.24 CONTRACTOR F & W ELECTRICAL CONTRACTORS, EST PERIOD OCT 10,2012 TO NOV 04,2013 EST NO 014 & FINAL INC. 07653 --------------------------------------------------------------------------------------------------------- DATE WORK BEGAN OCT 10, 2012 TIME COMPUTED FROM OCT 10, 2012 SUMMARY INFORMATION 0 DATE WORKING REASONS FOR DAYS CREDITED MONTH/YEAR OR DAYS DAYS /COMMENTS FOR DAYS CHARGED PHASE I DAYS CHARGED CREDITED CONTRACT WORK DAYS = 365 387 387 0 BROUGHT FORWARD ADDL DAYS GRANTED = 26 NOV 13 1 1 TOTAL DAYS ALLOWED = 391 2 1 DATE WORK COMPLETED 11/04/13 3 1 DAYS CHARGED TO DATE = 390 4 1 WORK COMPLETED AND ACCEPTED ASSESSED LIQ DAMAGES = 0 LIQ DAMAGE RATE $ 590 0 LIQUIDATED DAMAGES 0 DAYS AT $ 590 PER DAY TOTAL = $ .00 0 CERTIFIED AS CORRECT AND ONE COPY HAS BEEN GIVEN TO THE CONTRACTOR - ---------------------------- AREA/PROJECT ENGINEER - - - - - ----- ----- ----- 391 390 1 0 SATURDAY 0 SUNDAY 0 HOLIDAY 1 WORK COMPLETED AND ACCEPTED 1MIS.CIS.03 CONSTRUCTN ESTIMATE BREAKDOWN CONTRACT 8121502 MGR.NO. 096 PAGE 001 CONT 6247 SEC 54 JOB 001 RES ENGR FRIENSENHAHN,JUDITH PROJ RMC - 624754001 HWY IH0010 4615 NW LOOP 410 SAN ANTO CNTY BEXAR DIST 15 CONTRACT PRICE $ 236,350.00 REPORT DATE 11/20/2013 10.09.26 CONTRACTOR F & W ELECTRICAL CONTRACTORS, EST PERIOD OCT 10,2012 TO NOV 04,2013 EST NO 014 & FINAL INC. 07653 DIST. 15 COUNTY BEXAR CONTROL 6247-54-001 PROJECT RMC - 624754001 HIGHWAY IH0010 0LIMITS- DISTRICTWIDE DISTRICTWIDE 0TYPE OF WORK- EMERGENCY REPAIR OF TRAFFIC SIGNALS 0 0005 PREPARED BY SUSAN ATKINS 0 0055 TRAFFIC SIGNAL MAINT AND REPAIR NET LENGTH 0.001 MILES 0 LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES ON CONTRACT PRICE($) ($) - 0060 0104 REMOVING CONC (MISC) SY 100.000 2.000 26.000 52.00 0065 0536 CONC DIRECTIONAL ISLAND SY 100.000 0.000 76.000 .00 0070 0416 DRILL SHAFT (NON-REINFORCED)(12 IN) LF 12.000 7.000 75.000 525.00 0075 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 24.000 34.000 120.000 4,080.00 0080 0621 TRAY CABLE (3 CONDR) (12 AWG) LF 1,000.000 810.000 1.600 1,296.00 0085 0690 REMOVAL OF CONDUIT LF 50.000 0.000 4.000 .00 0090 0690 INSTALL OF CONDUIT BY TRENCHING LF 2,000.000 1,316.000 6.500 8,554.00 0095 0690 INSTALL OF CONDUIT BY BORING LF 500.000 245.000 34.500 8,452.50 0100 0690 INSTALL OF VEHICLE DETECTORS LF 500.000 0.000 12.500 .00 0105 0690 REMOVAL OF GROUND BOXES EA 1.000 1.000 127.000 127.00 0110 0690 REPLACE OF GROUND BOXES EA 5.000 6.000 580.000 3,480.00 0115 0690 INSTALL OF GROUND BOXES EA 5.000 9.000 580.000 5,220.00 0120 0690 REMOVAL OF CABLES LF 1,500.000 0.000 .850 .00 0125 0690 REPLACE OF CABLES LF 15,000.000 6,235.000 1.900 11,846.50 0130 0690 INSTALL OF CABLES LF 10,000.000 3,876.000 1.900 7,364.40 0135 0690 REMOVAL OF SPAN CABLE ASSM LF 200.000 0.000 1.050 .00 0140 0690 REPLACE OF SPAN CABLE ASSM LF 2,000.000 820.000 3.650 2,993.00 0145 0690 INSTALL OF SPAN CABLE ASSM LF 2,000.000 0.000 3.650 .00 0150 0690 REPLACE OF ELECTRICAL SERVICE EA 2.000 1.000 1,525.000 1,525.00 0155 0690 INSTALL OF ELECTRICAL SERVICE EA 1.000 0.000 1,525.000 .00 0160 0690 REMOVAL OF TIMBER POLES EA 2.000 1.000 275.000 275.00 0165 0690 REPLACE OF TIMBER POLES EA 4.000 3.000 450.000 1,350.00 0170 0690 INSTALL OF TIMBER POLES EA 8.000 2.000 450.000 900.00 1 0175 0690 REMOVAL OF SIGNAL HEAD ASSM EA 4.000 0.000 88.500 .00 0180 0690 REPLACE OF SIGNAL HEAD ASSM EA 5.000 30.000 156.000 4,680.00 0185 0690 INSTALL OF SIGNAL HEAD ASSM EA 10.000 3.000 156.000 468.00 0190 0690 REMOVAL OF SIGNAL RELATED SIGNS EA 2.000 0.000 66.500 .00 0195 0690 REPLACE OF SIGNAL RELATED SIGNS EA 20.000 15.000 83.000 1,245.00 0200 0690 INSTALL OF SIGNAL RELATED SIGNS EA 10.000 3.000 83.000 249.00 0205 0690 REMOVAL OF PEDESTRIAN PUSH BUTTONS EA 1.000 0.000 51.000 .00 0210 0690 REPLACE OF PEDESTRIAN PUSH BUTTONS EA 12.000 10.000 111.000 1,110.00 0215 0690 INSTALL OF PEDESTRIAN PUSH BUTTONS EA 4.000 1.000 111.000 111.00 0220 0690 REMOVAL OF TRAFFIC SIGNAL POLE FND LF 2.000 6.000 825.000 4,950.00 0225 0690 INSTALL OF FND FOR GROUND MNT CABINETS EA 2.000 0.000 3,500.000 .00 0230 0690 REMOVAL OF CONTROL CABINET (GRND MNT) EA 1.000 0.000 175.000 .00 0235 0690 REPLACE OF CONTROL CABINET (GRND MNT) EA 4.000 0.000 252.000 .00 0240 0690 INSTALL OF CONTROL CABINET (GRND MNT) EA 4.000 0.000 252.000 .00 0245 0690 REMOVAL OF FLASHER CABINET EA 1.000 2.000 111.000 222.00 0250 0690 REPLACE OF FLASHER CABINET EA 1.000 0.000 250.000 .00 0255 0690 INSTALL OF FLASHER CABINET EA 4.000 0.000 250.000 .00 0260 0690 REMOVAL OF RDSD FLSH BEACON ASSM EA 1.000 2.000 130.000 260.00 0265 0690 REPLACE OF RDSD FLSH BEACON ASSM EA 1.000 0.000 590.000 .00 0270 0690 INSTALL OF RDSD FLSH BEACON ASSM EA 8.000 0.000 590.000 .00 0275 0690 REMOVAL OF SIGNAL POLE ASSM EA 1.000 0.000 365.000 .00 0280 0690 REPLACE OF SIGNAL POLE ASSM EA 4.000 14.000 500.000 7,000.00 0285 0690 INSTALL OF SIGNAL POLE ASSM EA 1.000 2.000 900.000 1,800.00 0290 0690 REMOVAL OF CURBS LF 5.000 0.000 33.000 .00 0295 0690 REPLACE OF CURBS LF 200.000 40.000 15.000 600.00 0300 0690 INSTALL OF CURBS LF 100.000 0.000 15.000 .00 0305 0690 REMOVAL OF PEDESTRIAN RAMPS EA 1.000 0.000 667.000 .00 0310 0690 REPLACE OF PEDESTRIAN RAMPS EA 2.000 2.000 1,486.000 2,972.00 0315 0690 INSTALL OF PEDESTRIAN RAMPS EA 8.000 4.000 1,486.000 5,944.00 0320 0690 REMOVAL OF SIDEWALKS SF 50.000 0.000 5.750 .00 0325 0690 REPLACE OF SIDEWALKS SF 100.000 252.500 6.750 1,704.38 0330 0690 INSTALL OF SIDEWALKS SF 4.000 0.000 93.750 .00 0335 0690 REMOVAL OF CONCRETE FOUNDATIONS EA 2.000 2.000 850.000 1,700.00 0340 0690 REMOVAL OF LUMINAIRE HEAD EA 1.000 0.000 66.000 .00 0345 0690 REPLACE OF LUMINAIRE HEAD EA 4.000 3.000 99.000 297.00 0350 0690 INSTALL OF LUMINAIRE HEAD EA 4.000 1.000 99.000 99.00 1 0355 0690 REMOVAL OF LUMINAIRE MAST ARMS EA 1.000 0.000 88.000 .00 0360 0690 REPLACE OF LUMINAIRE MAST ARMS EA 4.000 4.000 117.000 468.00 0365 0690 INSTALL OF LUMINAIRE MAST ARMS EA 4.000 1.000 117.000 117.00 0370 0690 INS OF TRF SIG PL FND (24" DRIL SHFT) LF 50.000 142.400 95.000 13,528.00 0375 0690 INS OF TRF SIG PL FND (30" DRIL SHFT) LF 100.000 17.300 128.000 2,214.40 0380 0690 INS OF TRF SIG PL FND (36" DRIL SHFT) LF 50.000 92.400 190.000 17,556.00 0385 0690 INS OF TRF SIG PL FND (42" DRIL SHFT) LF 2.000 0.000 307.000 .00 0390 0690 INS OF TRF SIG PL FND (48" DRIL SHFT) LF 2.000 0.000 340.000 .00 0395 0690 INSTL PED POLE ASSM EA 4.000 0.000 580.000 .00 0400 0690 REPLACE PED POLE ASSM EA 4.000 0.000 580.000 .00 0405 0690 REMOVE DOWN GUY AND ANCHOR W/GUARD EA 1.000 0.000 117.000 .00 0410 0690 INSTL DOWN GUY AND ANCHOR W/GUARD EA 1.000 0.000 336.000 .00 0415 0690 REPLACE DOWN GUY AND ANCHOR W/GUARD EA 6.000 2.000 336.000 672.00 0420 0690 INSTALL LUMINAIRE POLE EA 1.000 0.000 385.000 .00 0425 0690 REPLACE LUMINAIRE POLE EA 2.000 1.000 385.000 385.00 0430 0690 REMOVE LUMINAIRE POLE FOUNDATION EA 2.000 0.000 470.000 .00 0435 0690 REMOVE PED POLE ASSM EA 2.000 0.000 137.000 .00 0440 6006 SPREAD SPECTRUM RADIO EA 1.000 0.000 220.000 .00 0445 6006 HELIAX CABLE LF 800.000 0.000 3.500 .00 0450 6006 ANTENNA (OMNI-DIRECTIONAL) EA 1.000 0.000 170.000 .00 0455 6006 ANTENNA (UNI-DIRECTIONAL) EA 1.000 1.000 170.000 170.00 0460 6007 REMOVING TRAFFIC SIGNALS EA 2.000 1.000 900.000 900.00 0465 6266 VIVDS PROCESSOR SYSTEM EA 1.000 0.000 208.500 .00 0470 6266 VIVDS CAMERA ASSEMBLY EA 16.000 19.000 230.000 4,370.00 0475 6266 VIVDS COMMUNICATION CABLE (COAXIAL) LF 2,000.000 650.000 2.000 1,300.00 0480 9001*POLICE OFFICERS DOL 374.060 374.060 1.000 374.06 0485 9002*POLICE OFFICERS DOL 903.000 903.000 1.000 903.00 0 SUBTOTAL BID ITEMS $ 136,409.24 0 TOTAL AMOUNT WORK DONE TRAFFIC SIGNAL MAINT AND REPAIR $ 136,409.24 0 TOTAL AMOUNT WORK DONE CONTROL 6247-54-001 $ 136,409.24 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 1MIS.CIS.04 CONSTRUCTION ESTIMATE COMBINED CONTRACT 8121502 MGR.NO. 096 PAGE 001 CONT 6247 SEC 54 JOB 001 RES ENGR FRIENSENHAHN,JUDITH PROJ RMC - 624754001 HWY IH0010 4615 NW LOOP 410 SAN ANTO CNTY BEXAR DIST 15 CONTRACT PRICE $ 236,350.00 REPORT DATE 11/20/2013 10.09.27 CONTRACTOR F & W ELECTRICAL CONTRACTORS, EST PERIOD OCT 10,2012 TO NOV 04,2013 EST NO 014 & FINAL INC. 07653 0*********************************************************************************************************************************** -LIMITS - DISTRICTWIDE 0 DISTRICTWIDE DATE WORK BEGAN OCT 10, 2012 WORKING DAYS USED 390 PERCENT COMPLETE 100.00 PERCENT TIME USED 99.70 DATE COMPLETED NOV 4 2013 0 CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0 6247-54-001 RMC - 624754001 15 IH0010 BEXAR - ITEM DESCRIPTION UNIT ESTIMATED WORK DONE CONTRACT AMOUNT NO. QUANTITIES ON CONTRACT PRICE($) ($) -0104 REMOVING CONC (MISC) SY 100.000 2.000 26.000 52.00 0416 DRILL SHAFT (NON-REINFORCED)(12 IN) LF 12.000 7.000 75.000 525.00 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 24.000 34.000 120.000 4,080.00 0621 TRAY CABLE (3 CONDR) (12 AWG) LF 1,000.000 810.000 1.600 1,296.00 0690 INSTALL OF CONDUIT BY TRENCHING LF 2,000.000 1,316.000 6.500 8,554.00 0690 INSTALL OF CONDUIT BY BORING LF 500.000 245.000 34.500 8,452.50 0690 REMOVAL OF GROUND BOXES EA 1.000 1.000 127.000 127.00 0690 REPLACE OF GROUND BOXES EA 5.000 6.000 580.000 3,480.00 0690 INSTALL OF GROUND BOXES EA 5.000 9.000 580.000 5,220.00 0690 REPLACE OF CABLES LF 15,000.000 6,235.000 1.900 11,846.50 0690 INSTALL OF CABLES LF 10,000.000 3,876.000 1.900 7,364.40 0690 REPLACE OF SPAN CABLE ASSM LF 2,000.000 820.000 3.650 2,993.00 0690 REPLACE OF ELECTRICAL SERVICE EA 2.000 1.000 1,525.000 1,525.00 0690 REMOVAL OF TIMBER POLES EA 2.000 1.000 275.000 275.00 0690 REPLACE OF TIMBER POLES EA 4.000 3.000 450.000 1,350.00 0690 INSTALL OF TIMBER POLES EA 8.000 2.000 450.000 900.00 0690 REPLACE OF SIGNAL HEAD ASSM EA 5.000 30.000 156.000 4,680.00 0690 INSTALL OF SIGNAL HEAD ASSM EA 10.000 3.000 156.000 468.00 0690 REPLACE OF SIGNAL RELATED SIGNS EA 20.000 15.000 83.000 1,245.00 10690 INSTALL OF SIGNAL RELATED SIGNS EA 10.000 3.000 83.000 249.00 0690 REPLACE OF PEDESTRIAN PUSH BUTTONS EA 12.000 10.000 111.000 1,110.00 0690 INSTALL OF PEDESTRIAN PUSH BUTTONS EA 4.000 1.000 111.000 111.00 0690 REMOVAL OF TRAFFIC SIGNAL POLE FND LF 2.000 6.000 825.000 4,950.00 0690 REMOVAL OF FLASHER CABINET EA 1.000 2.000 111.000 222.00 0690 REMOVAL OF RDSD FLSH BEACON ASSM EA 1.000 2.000 130.000 260.00 0690 REPLACE OF SIGNAL POLE ASSM EA 4.000 14.000 500.000 7,000.00 0690 INSTALL OF SIGNAL POLE ASSM EA 1.000 2.000 900.000 1,800.00 0690 REPLACE OF CURBS LF 200.000 40.000 15.000 600.00 0690 REPLACE OF PEDESTRIAN RAMPS EA 2.000 2.000 1,486.000 2,972.00 0690 INSTALL OF PEDESTRIAN RAMPS EA 8.000 4.000 1,486.000 5,944.00 0690 REPLACE OF SIDEWALKS SF 100.000 252.500 6.750 1,704.38 0690 REMOVAL OF CONCRETE FOUNDATIONS EA 2.000 2.000 850.000 1,700.00 0690 REPLACE OF LUMINAIRE HEAD EA 4.000 3.000 99.000 297.00 0690 INSTALL OF LUMINAIRE HEAD EA 4.000 1.000 99.000 99.00 0690 REPLACE OF LUMINAIRE MAST ARMS EA 4.000 4.000 117.000 468.00 0690 INSTALL OF LUMINAIRE MAST ARMS EA 4.000 1.000 117.000 117.00 0690 INS OF TRF SIG PL FND (24" DRIL SHFT) LF 50.000 142.400 95.000 13,528.00 0690 INS OF TRF SIG PL FND (30" DRIL SHFT) LF 100.000 17.300 128.000 2,214.40 0690 INS OF TRF SIG PL FND (36" DRIL SHFT) LF 50.000 92.400 190.000 17,556.00 0690 REPLACE DOWN GUY AND ANCHOR W/GUARD EA 6.000 2.000 336.000 672.00 0690 REPLACE LUMINAIRE POLE EA 2.000 1.000 385.000 385.00 6006 ANTENNA (UNI-DIRECTIONAL) EA 1.000 1.000 170.000 170.00 6007 REMOVING TRAFFIC SIGNALS EA 2.000 1.000 900.000 900.00 6266 VIVDS CAMERA ASSEMBLY EA 16.000 19.000 230.000 4,370.00 6266 VIVDS COMMUNICATION CABLE (COAXIAL) LF 2,000.000 650.000 2.000 1,300.00 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 09001* POLICE OFFICERS DOL 374.060 374.060 1.000 374.06 9002* POLICE OFFICERS DOL 903.000 903.000 1.000 903.00 0 SUBTOTAL BID ITEMS $ 136,409.24 0 CONTRACT TOTAL ALL ITEMS $ 136,409.24 1MIS.CIS.05 CONSTR ESTIMATE DISTRIBUTION CONTRACT 8121502 MGR.NO. 096 PAGE 001 CONT 6247 SEC 54 JOB 001 RES ENGR FRIENSENHAHN,JUDITH PROJ RMC - 624754001 HWY IH0010 4615 NW LOOP 410 SAN ANTO CNTY BEXAR DIST 15 CONTRACT PRICE $ 236,350.00 REPORT DATE 11/20/2013 10.09.27 CONTRACTOR F & W ELECTRICAL CONTRACTORS, EST PERIOD OCT 10,2012 TO NOV 04,2013 EST NO 014 & FINAL INC. 07653 ********************************************************************************************************************************** CO NO PROJECT CONT SEC JOB LINE NO TOTAL AMOUNT .00 % DIFFERENCE LESS TOTAL LESS LIQ DIFFERENCE LESS PREV AMOUNT DUE WORK DONE RETAINAGE SPL DEDUCTS DAMAGE PAYMENTS THIS EST ********************************************************************************************************************************** 15 RMC - 624754001 6247-54-001 136,409.24 .00 136,409.24 .00 .00 136,409.24 135,506.24 903.00 ---------------------------------------------------------------------------------------------------------------------------------- 0********************************** TOTALS ***************************************************************************** TOTAL AMOUNT .00 % DIFFERENCE LESS TOTAL LESS LIQ DIFFERENCE LESS PREV AMOUNT DUE WORK DONE RETAINAGE SPL DEDUCTS DAMAGE PAYMENTS THIS EST ********************************************************************************************************************************** 136,409.24 .00 136,409.24 .00 .00 136,409.24 135,506.24 903.00 ---------------------------------------------------------------------------------------------------------------------------------- 0INPUT PROOF READ BY- SUPPORTING PAPERS OK ------------------------------ ---------------------------- 0 **APPROVED BY** DATE --------------------------------------------- AREA/PROJECT ENGINEER 0 DATE --------------------------------------------- DISTRICT ENGINEER 1MIS.CIS.07 WORK PERFORMED THIS PERIOD CONTRACT 8121502 MGR.NO. 096 PAGE 001 CONT 6247 SEC 54 JOB 001 RES ENGR FRIENSENHAHN,JUDITH PROJ RMC - 624754001 HWY IH0010 4615 NW LOOP 410 SAN ANTO CNTY BEXAR DIST 15 CONTRACT PRICE $ 236,350.00 REPORT DATE 11/20/2013 10.09.28 CONTRACTOR F & W ELECTRICAL CONTRACTORS, EST PERIOD OCT 10,2012 TO NOV 04,2013 EST NO 014 & FINAL INC. 07653 ********************************************************************************************************************* - CONTROL PROJECT DISTRICT HIGHWAY COUNTY 6247-54-001 RMC - 624754001 15 IH0010 BEXAR -LIMITS - DISTRICTWIDE DISTRICTWIDE LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES THIS ESTIMATE PRICE($) ($) - * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 0 485 9002* POLICE OFFICERS DOL 0.000 903.000 1.000 903.00 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 0 --------------- - TOTAL BID ITEMS DONE THIS ESTIMATE - $ 903.00 0 TOTAL AMOUNT WORK DONE TO DATE - $ 136,409.24