1MIS.CIS.01 CONTRACT TIME STATEMENT CONTRACT 9023204 MGR.NO. 062 PAGE 001 CONT 0598 SEC 02 JOB 033 RES ENGR DOCK GEE, P.E. PROJ CM 2002(778) HWY SH 288 P.O. BOX 1386 HOUSTON CNTY BRAZORIA DIST 12 CONTRACT PRICE $ 2,641,330.21 REPORT DATE 08/27/2009 10.50.05 CONTRACTOR MASTEC NORTH AMERICA, INC. 10699 EST PERIOD OCT 31,2002 TO JUL 01,2009 EST NO 084 & FINAL --------------------------------------------------------------------------------------------------------- DATE WORK BEGAN DEC 01, 2003 TIME COMPUTED FROM OCT 31, 2002 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 = 375 2,435 440 1,995 BROUGHT FORWARD ADDL DAYS GRANTED = 157 JUL 09 1 1 WORK COMPLETED AND ACCEPTED TOTAL DAYS ALLOWED = 532 DATE WORK COMPLETED 07/01/09 DAYS CHARGED TO DATE = 440 ASSESSED LIQ DAMAGES = 0 LIQ DAMAGE RATE $ 900 0 LIQUIDATED DAMAGES 0 DAYS AT $ 900 PER DAY TOTAL = $ .00 0 CERTIFIED AS CORRECT AND ONE COPY HAS BEEN GIVEN TO THE CONTRACTOR - ---------------------------- AREA/PROJECT ENGINEER - - - - - ----- ----- ----- 2,436 440 1,996 0 SATURDAY 0 SUNDAY 0 HOLIDAY 1 WORK COMPLETED AND ACCEPTED 1MIS.CIS.03 CONSTRUCTN ESTIMATE BREAKDOWN CONTRACT 9023204 MGR.NO. 062 PAGE 001 CONT 0598 SEC 02 JOB 033 RES ENGR DOCK GEE, P.E. PROJ CM 2002(778) HWY SH 288 P.O. BOX 1386 HOUSTON CNTY BRAZORIA DIST 12 CONTRACT PRICE $ 2,641,330.21 REPORT DATE 08/27/2009 10.50.05 CONTRACTOR MASTEC NORTH AMERICA, INC. 10699 EST PERIOD OCT 31,2002 TO JUL 01,2009 EST NO 084 & FINAL DIST. 12 COUNTY BRAZORIA CONTROL 0598-02-033 PROJECT CM 2002(778) HIGHWAY SH 288 0LIMITS- HARRIS COUNTY LINE SH 6 0TYPE OF WORK- INST CTMS 0 0005 PREPARED BY GARY TRIETSCH,P.E.,DIST. ENGR. 0010 DATE:AUG,2002 0 0060 ALL ITEMS NET LENGTH 7.299 MILES 0 LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES ON CONTRACT PRICE($) ($) - 0065 0416 DRILL SHAFT (36 IN) LF 240.000 240.000 140.000 33,600.00 0070 0416 DRILL SHAFT (48 IN) LF 96.000 96.000 175.000 16,800.00 0075 0500 MOBILIZATION LS 1.000 1.000 55,000.000 55,000.00 0080 0502 BARRICADES, SIGNS AND TRAF HANDLE MO 15.000 50.000 1,200.000 60,000.00 0080 0502 ADJ EST QUANTITY TO DATE 50.000 0085 0540 MTL BEAM GD FEN (12 GA) LF 1,875.000 2,000.000 25.000 50,000.00 0090 0540 TERM ANCHOR SECT (12 GA) EA 15.000 16.000 475.000 7,600.00 0095 0618 CONDUIT (RM)(3 ") LF 1,220.000 1,180.000 19.700 23,246.00 0100 0618 CONDUIT (PVC)(SCHD 40)(3 ") LF 75,940.000 81,968.000 4.700 385,249.60 0105 0618 CONDUIT (PVC)(SCHD 80)(2 ") LF 6,180.000 8,657.000 3.000 25,971.00 0110 0618 CONDUIT (PVC)(SCHD 80)(3 ") LF 520.000 830.000 6.000 4,980.00 0115 0618 CONDUIT (PVC)(SCHD 80)(4 ") LF 150.000 260.000 9.000 2,340.00 0120 0618 CONDUIT (PVC)(SCHD 80)(2 ")(BORE) LF 420.000 3,289.000 12.000 39,468.00 0125 0618 CONDUIT (PVC)(SCHD 80)(3 ")(BORE) LF 2,780.000 3,990.000 13.000 51,870.00 0130 0620 ELEC CONDUCTOR (NO. 8) BARE LF 1,440.000 5,145.000 .330 1,697.85 0135 0620 ELEC CONDUCTOR (NO. 6) BARE LF 1,280.000 1,385.000 .400 554.00 0140 0620 ELEC CONDUCTOR (NO. 4) BARE LF 1,175.000 2,145.000 .490 1,051.05 0145 0620 ELEC CONDUCTOR (NO. 2) BARE LF 661.000 4,650.000 .660 3,069.00 0150 0620 ELEC CONDUCTOR (NO. 8) INSULATED LF 3,005.000 10,760.000 .400 4,304.00 0155 0620 ELEC CONDUCTOR (NO. 6) INSULATED LF 3,045.000 3,315.000 .490 1,624.35 0160 0620 ELEC CONDUCTOR (NO. 4) INSULATED LF 2,970.000 5,455.000 .560 3,054.80 0165 0620 ELEC CONDUCTOR (NO. 2) 1 INSULATED LF 1,525.000 11,360.000 .750 8,520.00 0170 0624 GROUND BOX TY 1 EA 22.000 34.000 725.000 24,650.00 0175 0624 GROUND BOX TY 2 EA 67.000 69.000 1,000.000 69,000.00 0180 0628 ELEC SERV TYD(120/240)100(NS)SS(N)SP(O EA 20.000 19.000 2,100.000 39,900.00 0185 0650 OVHD SGN SUPT (25 FT BAL TEE)(21.0 HT) EA 4.000 4.000 14,500.000 58,000.00 0190 0654 SGN WLKWY W/HNDRL (36 IN) LF 100.000 100.000 135.000 13,500.00 0195 5249 TEMP SEDMT CONT FENCE LF 1,000.000 10,084.000 1.000 10,084.00 0200 5249 TEMP SEDMT CONT FENCE (REMOV) LF 1,000.000 4,899.000 .500 2,449.50 0205 5819 SINGLE GUARDRAIL TERM (TY III) EA 15.000 16.000 1,600.000 25,600.00 0210 6607 SYSTEM SUPPORT EQUIPMENT LS 1.000 0.000 44,000.000 .00 0215 8483 PREP OF EXISTING CONDUIT LF 7,710.000 3,328.000 .300 998.40 0220 8485 COMMUN CABLE (6 PAIR)(22 AWG) LF 45,250.000 44,323.000 1.000 44,323.00 0225 8803 MULTI-DUCT COND SYS (PVC) LF 76,590.000 81,968.000 7.100 581,972.80 0230 8803 MULTI-DUCT COND SYS (BORE) LF 2,640.000 4,110.000 15.300 62,883.00 0235 8803 MULTI-DUCT COND SYS (RM) LF 1,580.000 1,180.000 32.000 37,760.00 0240 8804 COMMUNICATIONS HUB BUILDING EA 5.000 5.000 26,000.000 130,000.00 0245 8805 CAMERA POLE STRUCTURE EA 16.000 16.000 7,500.000 120,000.00 0250 8806 FIBER OPTIC CABLE (6 STRAND)(S/M) LF 47,580.000 54,568.000 .610 33,286.48 0255 8806 FIBER OPTIC CABLE (36 STRAND)(M/M) LF 45,190.000 61,292.000 2.050 125,648.60 0260 8806 FIBER OPTIC CABLE (36 STRAND)(S/M) LF 45,190.000 61,292.000 1.030 63,130.76 0265 8807 FIBER OPTIC RS-232 DATA MODEM (S/M) EA 40.000 40.000 800.000 32,000.00 0270 8810 VIDEO FIBER OPTIC TX (S/M) EA 16.000 16.000 600.000 9,600.00 0275 8810 VIDEO FIBER OPTIC RX (S/M) EA 16.000 16.000 700.000 11,200.00 0280 8811 FIBER OPTIC VIDEO MULTIPLEXOR SYSTEM EA 1.000 1.000 38,000.000 38,000.00 0285 8812 RS-232 PORT SHARING DEVICE EA 13.000 13.000 325.000 4,225.00 0290 8813 D/I MULDEM EA 5.000 5.000 12,800.000 64,000.00 0295 8814 CCTV FIELD EQUIPMENT EA 16.000 16.000 6,300.000 100,800.00 0300 8815 DATA FIBER OPTIC TRANS (MULTIMODE) EA 10.000 10.000 4,500.000 45,000.00 0305 8903 FIBER OPTIC DMS FIELD EQUIPMENT (18") EA 4.000 4.000 85,000.000 340,000.00 0306 9004*REMOV/RELO 5 CCTV CAM POLES/FOUNDATIONS EA. 1.000 1.000 43,042.560 43,042.56 0307 9008*REPARING 2" CONDUIT EA 1.000 1.000 4,635.300 4,635.30 0308 9009*ADDITIONAL MULIT-DUCT CONDUIT DEPTH LS 1.000 1.000 10,457.100 10,457.10 0309 9010*LOCATING AND UNCOVERING PULL BOXES EA 1.000 1.000 865.440 865.44 0 SUBTOTAL BID ITEMS $ 2,927,011.59 1 MATERIAL ON HAND 0 LINE MATRL. NO MATERIAL DESCRIPTION UNIT QUANTITY % INV UNIT PRICE AMOUNT NO. PRICE ALLOWED($) ($) 0 0310 775 MATERIAL ON HAND EA 0.000 100 1.000 .00 0 LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES ON CONTRACT PRICE($) ($) 0 0312 9006*FINDING BURRIED PULLBOXES LS 1.000 1.000 13,813.000 13,813.00 0313 9007*CCTV CABINET CLEAN UP LS 1.000 1.000 9,322.000 9,322.00 0 SUBTOTAL BID ITEMS $ 23,135.00 0 TOTAL AMOUNT WORK DONE ALL ITEMS $ 2,950,146.59 0 0355 CONTRACTOR FORCE ACT OR AGR UNIT NET LENGTH 0.000 MILES 0 LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES ON CONTRACT PRICE($) ($) - 0356 PRICE (PART) 0357 UNIFORMED POLICE OFFICERS 0 0365 9001*ADJUSTMENT FOR UTILITY CONSTRUCTION EA. 79,098.740 79,098.740 1.000 79,098.74 0 SUBTOTAL BID ITEMS $ 79,098.74 0 TOTAL AMOUNT WORK DONE CONTRACTOR FORCE ACT OR AGR UNIT $ 79,098.74 0 TOTAL AMOUNT WORK DONE CONTROL 0598-02-033 $ 3,029,245.33 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 1MIS.CIS.04 CONSTRUCTION ESTIMATE COMBINED CONTRACT 9023204 MGR.NO. 062 PAGE 001 CONT 0598 SEC 02 JOB 033 RES ENGR DOCK GEE, P.E. PROJ CM 2002(778) HWY SH 288 P.O. BOX 1386 HOUSTON CNTY BRAZORIA DIST 12 CONTRACT PRICE $ 2,641,330.21 REPORT DATE 08/27/2009 10.50.06 CONTRACTOR MASTEC NORTH AMERICA, INC. 10699 EST PERIOD OCT 31,2002 TO JUL 01,2009 EST NO 084 & FINAL 0*********************************************************************************************************************************** -LIMITS - INST CTMS DATE WORK BEGAN DEC 1 , 2003 WORKING DAYS USED 440 PERCENT COMPLETE 100.00 PERCENT TIME USED 82.70 DATE COMPLETED JUL 1 2009 0 CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0 0598-02-033 CM 2002(778) 12 SH 288 BRAZORIA - ITEM DESCRIPTION UNIT ESTIMATED WORK DONE CONTRACT AMOUNT NO. QUANTITIES ON CONTRACT PRICE($) ($) -0416 DRILL SHAFT (36 IN) LF 240.000 240.000 140.000 33,600.00 0416 DRILL SHAFT (48 IN) LF 96.000 96.000 175.000 16,800.00 0500 MOBILIZATION LS 1.000 1.000 55,000.000 55,000.00 0502 BARRICADES, SIGNS AND TRAF HANDLE MO 15.000 50.000 1,200.000 60,000.00 0502 ADJ EST QUANTITY TO DATE 50.000 0540 MTL BEAM GD FEN (12 GA) LF 1,875.000 2,000.000 25.000 50,000.00 0540 TERM ANCHOR SECT (12 GA) EA 15.000 16.000 475.000 7,600.00 0618 CONDUIT (RM)(3 ") LF 1,220.000 1,180.000 19.700 23,246.00 0618 CONDUIT (PVC)(SCHD 40)(3 ") LF 75,940.000 81,968.000 4.700 385,249.60 0618 CONDUIT (PVC)(SCHD 80)(2 ") LF 6,180.000 8,657.000 3.000 25,971.00 0618 CONDUIT (PVC)(SCHD 80)(3 ") LF 520.000 830.000 6.000 4,980.00 0618 CONDUIT (PVC)(SCHD 80)(4 ") LF 150.000 260.000 9.000 2,340.00 0618 CONDUIT (PVC)(SCHD 80)(2 ")(BORE) LF 420.000 3,289.000 12.000 39,468.00 0618 CONDUIT (PVC)(SCHD 80)(3 ")(BORE) LF 2,780.000 3,990.000 13.000 51,870.00 0620 ELEC CONDUCTOR (NO. 8) BARE LF 1,440.000 5,145.000 .330 1,697.85 0620 ELEC CONDUCTOR (NO. 6) BARE LF 1,280.000 1,385.000 .400 554.00 0620 ELEC CONDUCTOR (NO. 4) BARE LF 1,175.000 2,145.000 .490 1,051.05 0620 ELEC CONDUCTOR (NO. 2) BARE LF 661.000 4,650.000 .660 3,069.00 0620 ELEC CONDUCTOR (NO. 8) INSULATED LF 3,005.000 10,760.000 .400 4,304.00 0620 ELEC CONDUCTOR (NO. 6) INSULATED LF 3,045.000 3,315.000 .490 1,624.35 0620 ELEC CONDUCTOR (NO. 4) INSULATED LF 2,970.000 5,455.000 .560 3,054.80 10620 ELEC CONDUCTOR (NO. 2) INSULATED LF 1,525.000 11,360.000 .750 8,520.00 0624 GROUND BOX TY 1 EA 22.000 34.000 725.000 24,650.00 0624 GROUND BOX TY 2 EA 67.000 69.000 1,000.000 69,000.00 0628 ELEC SERV TYD(120/240)100(NS)SS(N)SP(O EA 20.000 19.000 2,100.000 39,900.00 0650 OVHD SGN SUPT (25 FT BAL TEE)(21.0 HT) EA 4.000 4.000 14,500.000 58,000.00 0654 SGN WLKWY W/HNDRL (36 IN) LF 100.000 100.000 135.000 13,500.00 5249 TEMP SEDMT CONT FENCE LF 1,000.000 10,084.000 1.000 10,084.00 5249 TEMP SEDMT CONT FENCE (REMOV) LF 1,000.000 4,899.000 .500 2,449.50 5819 SINGLE GUARDRAIL TERM (TY III) EA 15.000 16.000 1,600.000 25,600.00 8483 PREP OF EXISTING CONDUIT LF 7,710.000 3,328.000 .300 998.40 8485 COMMUN CABLE (6 PAIR)(22 AWG) LF 45,250.000 44,323.000 1.000 44,323.00 8803 MULTI-DUCT COND SYS (PVC) LF 76,590.000 81,968.000 7.100 581,972.80 8803 MULTI-DUCT COND SYS (BORE) LF 2,640.000 4,110.000 15.300 62,883.00 8803 MULTI-DUCT COND SYS (RM) LF 1,580.000 1,180.000 32.000 37,760.00 8804 COMMUNICATIONS HUB BUILDING EA 5.000 5.000 26,000.000 130,000.00 8805 CAMERA POLE STRUCTURE EA 16.000 16.000 7,500.000 120,000.00 8806 FIBER OPTIC CABLE (6 STRAND)(S/M) LF 47,580.000 54,568.000 .610 33,286.48 8806 FIBER OPTIC CABLE (36 STRAND)(M/M) LF 45,190.000 61,292.000 2.050 125,648.60 8806 FIBER OPTIC CABLE (36 STRAND)(S/M) LF 45,190.000 61,292.000 1.030 63,130.76 8807 FIBER OPTIC RS-232 DATA MODEM (S/M) EA 40.000 40.000 800.000 32,000.00 8810 VIDEO FIBER OPTIC TX (S/M) EA 16.000 16.000 600.000 9,600.00 8810 VIDEO FIBER OPTIC RX (S/M) EA 16.000 16.000 700.000 11,200.00 8811 FIBER OPTIC VIDEO MULTIPLEXOR SYSTEM EA 1.000 1.000 38,000.000 38,000.00 8812 RS-232 PORT SHARING DEVICE EA 13.000 13.000 325.000 4,225.00 8813 D/I MULDEM EA 5.000 5.000 12,800.000 64,000.00 8814 CCTV FIELD EQUIPMENT EA 16.000 16.000 6,300.000 100,800.00 8815 DATA FIBER OPTIC TRANS (MULTIMODE) EA 10.000 10.000 4,500.000 45,000.00 8903 FIBER OPTIC DMS FIELD EQUIPMENT (18") EA 4.000 4.000 85,000.000 340,000.00 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 09001* ADJUSTMENT FOR UTILITY CONSTRUCTION EA. 79,098.740 79,098.740 1.000 79,098.74 9004* REMOV/RELO 5 CCTV CAM POLES/FOUNDATIONS EA. 1.000 1.000 43,042.560 43,042.56 9006* FINDING BURRIED PULLBOXES LS 1.000 1.000 13,813.000 13,813.00 9007* CCTV CABINET CLEAN UP LS 1.000 1.000 9,322.000 9,322.00 9008* REPARING 2" CONDUIT EA 1.000 1.000 4,635.300 4,635.30 19009* ADDITIONAL MULIT-DUCT CONDUIT DEPTH LS 1.000 1.000 10,457.100 10,457.10 9010* LOCATING AND UNCOVERING PULL BOXES EA 1.000 1.000 865.440 865.44 0 SUBTOTAL BID ITEMS $ 3,029,245.33 0 CONTRACT TOTAL ALL ITEMS $ 3,029,245.33 1MIS.CIS.05 CONSTR ESTIMATE DISTRIBUTION CONTRACT 9023204 MGR.NO. 062 PAGE 001 CONT 0598 SEC 02 JOB 033 RES ENGR DOCK GEE, P.E. PROJ CM 2002(778) HWY SH 288 P.O. BOX 1386 HOUSTON CNTY BRAZORIA DIST 12 CONTRACT PRICE $ 2,641,330.21 REPORT DATE 08/27/2009 10.50.06 CONTRACTOR MASTEC NORTH AMERICA, INC. 10699 EST PERIOD OCT 31,2002 TO JUL 01,2009 EST NO 084 & FINAL ********************************************************************************************************************************** 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 TOTAL ( %) PREV BALANCE BANK RELEASE BANK REFUND NEW BALANCE DEP IN TRST RETAINAGE IN TRUST TO CONTRACTOR TO STATE IN TRUST THIS EST ********************************************************************************************************************************** 20 CM 2002(778) 0598-02-033 3,029,245.33 .00 3,029,245.33 .00 .00 3,029,245.33 2,963,270.42 65,974.91 .00 60,474.91 60,474.91 .00 .00 60,474.91- ---------------------------------------------------------------------------------------------------------------------------------- 0********************************** TOTALS ***************************************************************************** TOTAL AMOUNT .00 % DIFFERENCE LESS TOTAL LESS LIQ DIFFERENCE LESS PREV AMOUNT DUE WORK DONE RETAINAGE SPL DEDUCTS DAMAGE PAYMENTS THIS EST TOTAL ( %) PREV BALANCE BANK RELEASE BANK REFUND NEW BALANCE DEP IN TRST RETAINAGE IN TRUST TO CONTRACTOR TO STATE IN TRUST THIS EST ********************************************************************************************************************************** 3,029,245.33 .00 3,029,245.33 .00 .00 3,029,245.33 2,963,270.42 65,974.91 .00 60,474.91 60,474.91 .00 .00 60,474.91- ---------------------------------------------------------------------------------------------------------------------------------- 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 9023204 MGR.NO. 062 PAGE 001 CONT 0598 SEC 02 JOB 033 RES ENGR DOCK GEE, P.E. PROJ CM 2002(778) HWY SH 288 P.O. BOX 1386 HOUSTON CNTY BRAZORIA DIST 12 CONTRACT PRICE $ 2,641,330.21 REPORT DATE 08/27/2009 10.50.06 CONTRACTOR MASTEC NORTH AMERICA, INC. 10699 EST PERIOD OCT 31,2002 TO JUL 01,2009 EST NO 084 & FINAL ********************************************************************************************************************* - CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0598-02-033 CM 2002(778) 12 SH 288 BRAZORIA -LIMITS - INST CTMS LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES THIS ESTIMATE PRICE($) ($) 0 75 0500 MOBILIZATION LS 1.000 0.100 55,000.000 5,500.00 --------------- - TOTAL BID ITEMS DONE THIS ESTIMATE - $ 5,500.00 0 TOTAL AMOUNT WORK DONE TO DATE - $ 3,029,245.33