1MIS.CIS.01 CONTRACT TIME STATEMENT CONTRACT 5094027 MGR.NO. 063 PAGE 001 CONT 6190 SEC 03 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 619003001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 341,299.55 REPORT DATE 02/07/2012 15.38.35 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD JAN 01,2012 TO JAN 31,2012 EST NO 029 SYSTEMS, CORP. 13538 --------------------------------------------------------------------------------------------------------- DATE WORK BEGAN SEP 01, 2009 TIME COMPUTED FROM SEP 01, 2009 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 = 730 852 852 0 BROUGHT FORWARD ADDL DAYS GRANTED = 274 JAN 12 1 1 TOTAL DAYS ALLOWED =1,004 2 1 DATE WORK COMPLETED 3 1 DAYS CHARGED TO DATE = 883 4 1 ASSESSED LIQ DAMAGES = 0 5 1 LIQ DAMAGE RATE $ 0 6 1 7 1 LIQUIDATED DAMAGES 8 1 0 DAYS AT $ 0 PER DAY 9 1 TOTAL = $ .00 10 1 11 1 CERTIFIED AS CORRECT AND 12 1 ONE COPY HAS BEEN GIVEN 13 1 TO THE CONTRACTOR 14 1 15 1 16 1 ---------------------------- 17 1 AREA/PROJECT ENGINEER 18 1 19 1 20 1 21 1 22 1 23 1 24 1 25 1 26 1 27 1 28 1 29 1 30 1 31 1 ----- ----- ----- 883 883 0 0 SATURDAY 0 SUNDAY 0 HOLIDAY 1MIS.CIS.03 CONSTRUCTN ESTIMATE BREAKDOWN CONTRACT 5094027 MGR.NO. 063 PAGE 001 CONT 6190 SEC 03 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 619003001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 341,299.55 REPORT DATE 02/07/2012 15.38.36 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD JAN 01,2012 TO JAN 31,2012 EST NO 029 SYSTEMS, CORP. 13538 DIST. 18 COUNTY DALLAS CONTROL 6190-03-001 PROJECT RMC - 619003001 HIGHWAY IH0035E 0LIMITS- VARIOUS ROADWAYS IN THE DALLAS DISTRICT 0TYPE OF WORK- ILLUMINATION 0 0005 PREPARED BY JENNIFER HIGGINBOTHAM & BYRON STEPHENS 0 0055 ILLUMINATION 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 (FOUNDATIONS) CY 25.000 52.000 254.590 13,238.68 0060 0104 ADJ EST QUANTITY TO DATE 75.000 0065 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 155.000 309.000 153.800 47,524.20 0065 0416 ADJ EST QUANTITY TO DATE 300.000 0070 0416 DRILL SHAFT (TRF SIG POLE) (24 IN) LF 18.000 24.000 105.160 2,523.84 0070 0416 ADJ EST QUANTITY TO DATE 36.000 0075 0628 ELC SRV TY A 120/240 070 (NS)SS(E)GC(O) EA 3.000 1.000 3,193.550 3,193.55 0076 0628*ELC SRV TY A 240/480 100 (NS)SS(E)GC(O) EA 2.000 4.000 4,760.640 19,042.56 0077 0628*ELC SRV TY A 240/480 150 (NS)SS(E)GC(O) EA 2.000 2.000 6,639.740 13,279.48 0078 0628*ELC SRV TY A 240/480 200 (NS)SS(E)GC(O) EA 2.000 1.000 6,639.740 6,639.74 0080 0610 REMOVE RDWY ILL ASSEM EA 40.000 26.000 212.160 5,516.16 0085 7458 REPLACE LAMP EA 550.000 452.000 63.650 28,769.80 0090 7458 REPLACE FUSE EA 300.000 875.000 27.580 24,132.50 0090 7458 ADJ EST QUANTITY TO DATE 850.000 0095 7458 REPLACE FUSE HOLDER EA 185.000 680.000 45.400 30,872.00 0095 7458 ADJ EST QUANTITY TO DATE 650.000 0100 7458 REPLACE STARTER BOARD EA 5.000 70.000 10.610 742.70 0100 7458 ADJ EST QUANTITY TO DATE 75.000 0105 7458 INSTALL UNDERGROUND SPLICE EA 70.000 110.000 106.080 11,668.80 0105 7458 ADJ EST QUANTITY TO DATE 100.000 0110 7458 INSTALL ABOVE GROUND SPLICE EA 230.000 189.000 106.080 20,049.12 0115 7458 INSTALL CONDUCTOR LF 45,000.000 102,244.000 1.910 195,286.04 0115 7458 ADJ EST QUANTITY TO DATE 105,000.000 1 0120 7458 INSTALL ABOVE GROUND CONDUIT LF 4,700.000 1,961.000 6.360 12,471.96 0125 7458 REMOVE ABOVE GROUND CONDUIT LF 100.000 1,047.000 2.210 2,313.87 0125 7458 ADJ EST QUANTITY TO DATE 1,050.000 0130 7458 INSTALL UNDERGROUND CONDUIT LF 2,100.000 8,599.000 4.240 36,459.76 0130 7458 ADJ EST QUANTITY TO DATE 10,000.000 0135 7458 INSTALL ROADWAY ILLUMINATION ASSEMBLY EA 45.000 85.000 339.450 28,853.25 0135 7458 ADJ EST QUANTITY TO DATE 100.000 0140 7458 INSTALL LUMINAIRE MAST ARM EA 60.000 1.000 63.650 63.65 0145 7458 INSTALL LUMINAIRE HEAD EA 85.000 426.000 106.080 45,190.08 0145 7458 ADJ EST QUANTITY TO DATE 400.000 0150 7458 INSTALL ELECTRICAL SERVICE EA 2.000 2.000 848.620 1,697.24 0155 7458 REMOVE ELECTRICAL SERVICE EA 2.000 8.000 169.720 1,357.76 0155 7458 ADJ EST QUANTITY TO DATE 10.000 0160 7458 INSTALL GROUND BOX EA 22.000 34.000 414.200 14,082.80 0160 7458 ADJ EST QUANTITY TO DATE 50.000 0165 7458 REMOVE GROUND BOX EA 3.000 13.000 84.860 1,103.18 0165 7458 ADJ EST QUANTITY TO DATE 13.000 0170 7458 CONDUIT BORE LF 1,250.000 1,127.000 18.040 20,331.08 0175 7458 INSTALL GROUND ROD EA 8.000 4.000 21.220 84.88 0180 7458 INSTALL TRANSFORMER BASE COVER EA 15.000 10.000 12.730 127.30 0185 7458 REPLACE LAMP SOCKET EA 10.000 4.000 21.220 84.88 0190 7458 INSTALL LUMINAIRE WALL PACK EA 5.000 0.000 84.860 .00 0195 7458 REMOVE LUMINAIRE WALL PACK EA 5.000 9.000 42.430 381.87 0195 7458 ADJ EST QUANTITY TO DATE 10.000 0200 7458 INSTALL TYPE I/II UNDERPASS FIXTURE EA 15.000 19.000 127.290 2,418.51 0205 7458 REMOVE TYPE I/II UNDERPASS FIXTURE EA 15.000 12.000 84.860 1,018.32 0210 7458 REPLACE PHOTOCELL EA 3.000 26.000 21.220 551.72 0210 7458 ADJ EST QUANTITY TO DATE 30.000 0215 7458 REPLACE PHOTOCELL BRACKET EA 3.000 6.000 10.610 63.66 0215 7458 ADJ EST QUANTITY TO DATE 5.000 0220 7458 REP 3 PSTN HAND-OFF-AUTO CNTL SWITCH EA 5.000 11.000 42.430 466.73 0220 7458 ADJ EST QUANTITY TO DATE 9.000 0225 7458 REPLACE FUSED DISCONNECT SWITCH EA 3.000 3.000 42.430 127.29 0230 7458 REPLACE LIGHTING CONTACTOR EA 3.000 9.000 42.430 381.87 0230 7458 ADJ EST QUANTITY TO DATE 7.000 0235 7458 REPLACE METER BASE EA 5.000 1.000 42.430 42.43 0240 7458 REPLACE TIME CLOCK EA 3.000 0.000 42.430 .00 0245 7458 REPLACE BREAKER PANEL EA 3.000 1.000 293.650 293.65 0250 7458 REPLACE CIRCUIT BREAKER EA 3.000 11.000 21.220 233.42 0250 7458 ADJ EST QUANTITY TO DATE 25.000 0255 7458 RE-STRAP CONDUIT EA 50.000 42.000 8.660 363.72 0260 7458 INSTALL OVERHEAD LENS EA 10.000 1.000 21.220 21.22 0265 7458 INSTALL WALL PACK LENS EA 5.000 0.000 21.220 .00 0270 7458 INSTALL WALL PACK LENS GUARD EA 5.000 0.000 21.220 .00 0275 7458 REPLACE WALL PACK BALLAST EA 25.000 48.000 72.280 3,469.44 1 0275 7458 ADJ EST QUANTITY TO DATE 50.000 0280 7458 RE-AIM AND CLEAN HIGH-MAST HEAD EA 200.000 312.000 53.930 16,826.16 0280 7458 ADJ EST QUANTITY TO DATE 320.000 0285 7458 REPLACE TRANSFORMER BASE ONLY EA 3.000 19.000 286.110 5,436.09 0285 7458 ADJ EST QUANTITY TO DATE 35.000 0 SUBTOTAL BID ITEMS $ 618,796.96 0 TOTAL AMOUNT WORK DONE ILLUMINATION $ 618,796.96 0 TOTAL AMOUNT WORK DONE CONTROL 6190-03-001 $ 618,796.96 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 1MIS.CIS.04 CONSTRUCTION ESTIMATE COMBINED CONTRACT 5094027 MGR.NO. 063 PAGE 001 CONT 6190 SEC 03 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 619003001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 341,299.55 REPORT DATE 02/07/2012 15.38.37 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD JAN 01,2012 TO JAN 31,2012 EST NO 029 SYSTEMS, CORP. 13538 0*********************************************************************************************************************************** -LIMITS - VARIOUS ROADWAYS IN 0 THE DALLAS DISTRICT DATE WORK BEGAN SEP 1 , 2009 WORKING DAYS USED 883 PERCENT COMPLETE 99.99 PERCENT TIME USED 87.90 DATE COMPLETED 0 CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0 6190-03-001 RMC - 619003001 18 IH0035E DALLAS - ITEM DESCRIPTION UNIT ESTIMATED WORK DONE CONTRACT AMOUNT NO. QUANTITIES ON CONTRACT PRICE($) ($) -0104 REMOVING CONC (FOUNDATIONS) CY 25.000 52.000 254.590 13,238.68 0104 ADJ EST QUANTITY TO DATE 75.000 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 155.000 309.000 153.800 47,524.20 0416 ADJ EST QUANTITY TO DATE 300.000 0416 DRILL SHAFT (TRF SIG POLE) (24 IN) LF 18.000 24.000 105.160 2,523.84 0416 ADJ EST QUANTITY TO DATE 36.000 0610 REMOVE RDWY ILL ASSEM EA 40.000 26.000 212.160 5,516.16 0628 ELC SRV TY A 120/240 070 (NS)SS(E)GC(O) EA 3.000 1.000 3,193.550 3,193.55 7458 REPLACE LAMP EA 550.000 452.000 63.650 28,769.80 7458 REPLACE FUSE EA 300.000 875.000 27.580 24,132.50 7458 ADJ EST QUANTITY TO DATE 850.000 7458 REPLACE FUSE HOLDER EA 185.000 680.000 45.400 30,872.00 7458 ADJ EST QUANTITY TO DATE 650.000 7458 REPLACE STARTER BOARD EA 5.000 70.000 10.610 742.70 7458 ADJ EST QUANTITY TO DATE 75.000 7458 INSTALL UNDERGROUND SPLICE EA 70.000 110.000 106.080 11,668.80 7458 ADJ EST QUANTITY TO DATE 100.000 7458 INSTALL ABOVE GROUND SPLICE EA 230.000 189.000 106.080 20,049.12 7458 INSTALL CONDUCTOR LF 45,000.000 102,244.000 1.910 195,286.04 7458 ADJ EST QUANTITY TO DATE 105,000.000 7458 INSTALL ABOVE GROUND CONDUIT LF 4,700.000 1,961.000 6.360 12,471.96 7458 REMOVE ABOVE GROUND CONDUIT LF 100.000 1,047.000 2.210 2,313.87 17458 ADJ EST QUANTITY TO DATE 1,050.000 7458 INSTALL UNDERGROUND CONDUIT LF 2,100.000 8,599.000 4.240 36,459.76 7458 ADJ EST QUANTITY TO DATE 10,000.000 7458 INSTALL ROADWAY ILLUMINATION ASSEMBLY EA 45.000 85.000 339.450 28,853.25 7458 ADJ EST QUANTITY TO DATE 100.000 7458 INSTALL LUMINAIRE MAST ARM EA 60.000 1.000 63.650 63.65 7458 INSTALL LUMINAIRE HEAD EA 85.000 426.000 106.080 45,190.08 7458 ADJ EST QUANTITY TO DATE 400.000 7458 INSTALL ELECTRICAL SERVICE EA 2.000 2.000 848.620 1,697.24 7458 REMOVE ELECTRICAL SERVICE EA 2.000 8.000 169.720 1,357.76 7458 ADJ EST QUANTITY TO DATE 10.000 7458 INSTALL GROUND BOX EA 22.000 34.000 414.200 14,082.80 7458 ADJ EST QUANTITY TO DATE 50.000 7458 REMOVE GROUND BOX EA 3.000 13.000 84.860 1,103.18 7458 ADJ EST QUANTITY TO DATE 13.000 7458 CONDUIT BORE LF 1,250.000 1,127.000 18.040 20,331.08 7458 INSTALL GROUND ROD EA 8.000 4.000 21.220 84.88 7458 INSTALL TRANSFORMER BASE COVER EA 15.000 10.000 12.730 127.30 7458 REPLACE LAMP SOCKET EA 10.000 4.000 21.220 84.88 7458 REMOVE LUMINAIRE WALL PACK EA 5.000 9.000 42.430 381.87 7458 ADJ EST QUANTITY TO DATE 10.000 7458 INSTALL TYPE I/II UNDERPASS FIXTURE EA 15.000 19.000 127.290 2,418.51 7458 REMOVE TYPE I/II UNDERPASS FIXTURE EA 15.000 12.000 84.860 1,018.32 7458 REPLACE PHOTOCELL EA 3.000 26.000 21.220 551.72 7458 ADJ EST QUANTITY TO DATE 30.000 7458 REPLACE PHOTOCELL BRACKET EA 3.000 6.000 10.610 63.66 7458 ADJ EST QUANTITY TO DATE 5.000 7458 REP 3 PSTN HAND-OFF-AUTO CNTL SWITCH EA 5.000 11.000 42.430 466.73 7458 ADJ EST QUANTITY TO DATE 9.000 7458 REPLACE FUSED DISCONNECT SWITCH EA 3.000 3.000 42.430 127.29 7458 REPLACE LIGHTING CONTACTOR EA 3.000 9.000 42.430 381.87 7458 ADJ EST QUANTITY TO DATE 7.000 7458 REPLACE METER BASE EA 5.000 1.000 42.430 42.43 7458 REPLACE BREAKER PANEL EA 3.000 1.000 293.650 293.65 7458 REPLACE CIRCUIT BREAKER EA 3.000 11.000 21.220 233.42 7458 ADJ EST QUANTITY TO DATE 25.000 7458 RE-STRAP CONDUIT EA 50.000 42.000 8.660 363.72 7458 INSTALL OVERHEAD LENS EA 10.000 1.000 21.220 21.22 7458 REPLACE WALL PACK BALLAST EA 25.000 48.000 72.280 3,469.44 7458 ADJ EST QUANTITY TO DATE 50.000 7458 RE-AIM AND CLEAN HIGH-MAST HEAD EA 200.000 312.000 53.930 16,826.16 7458 ADJ EST QUANTITY TO DATE 320.000 7458 REPLACE TRANSFORMER BASE ONLY EA 3.000 19.000 286.110 5,436.09 17458* ADJ EST QUANTITY TO DATE 35.000 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 00628* ELC SRV TY A 240/480 100 (NS)SS(E)GC(O) EA 2.000 4.000 4,760.640 19,042.56 0628* ELC SRV TY A 240/480 150 (NS)SS(E)GC(O) EA 2.000 2.000 6,639.740 13,279.48 0628* ELC SRV TY A 240/480 200 (NS)SS(E)GC(O) EA 2.000 1.000 6,639.740 6,639.74 0 SUBTOTAL BID ITEMS $ 618,796.96 0 CONTRACT TOTAL ALL ITEMS $ 618,796.96 1MIS.CIS.05 CONSTR ESTIMATE DISTRIBUTION CONTRACT 5094027 MGR.NO. 063 PAGE 001 CONT 6190 SEC 03 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 619003001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 341,299.55 REPORT DATE 02/07/2012 15.38.37 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD JAN 01,2012 TO JAN 31,2012 EST NO 029 SYSTEMS, CORP. 13538 ********************************************************************************************************************************** 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 ********************************************************************************************************************************** 57 RMC - 619003001 6190-03-001 618,796.96 .00 618,796.96 .00 .00 618,796.96 601,826.35 16,970.61 ---------------------------------------------------------------------------------------------------------------------------------- 0********************************** TOTALS ***************************************************************************** TOTAL AMOUNT .00 % DIFFERENCE LESS TOTAL LESS LIQ DIFFERENCE LESS PREV AMOUNT DUE WORK DONE RETAINAGE SPL DEDUCTS DAMAGE PAYMENTS THIS EST ********************************************************************************************************************************** 618,796.96 .00 618,796.96 .00 .00 618,796.96 601,826.35 16,970.61 ---------------------------------------------------------------------------------------------------------------------------------- 0INPUT PROOF READ BY- SUPPORTING PAPERS OK ------------------------------ ---------------------------- 0 APPROVED DATE --------------------------------- ----------------- 1MIS.CIS.07 WORK PERFORMED THIS PERIOD CONTRACT 5094027 MGR.NO. 063 PAGE 001 CONT 6190 SEC 03 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 619003001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 341,299.55 REPORT DATE 02/07/2012 15.38.37 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD JAN 01,2012 TO JAN 31,2012 EST NO 029 SYSTEMS, CORP. 13538 ********************************************************************************************************************* - CONTROL PROJECT DISTRICT HIGHWAY COUNTY 6190-03-001 RMC - 619003001 18 IH0035E DALLAS -LIMITS - VARIOUS ROADWAYS IN THE DALLAS DISTRICT LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES THIS ESTIMATE PRICE($) ($) 0 60 0104 REMOVING CONC (FOUNDATIONS) CY 25.000 1.000 254.590 254.59 65 0416 DRILL SHAFT (RDWY ILL POLE) LF 155.000 30.000 153.800 4,614.00 (30 IN) 80 0610 REMOVE RDWY ILL ASSEM EA 40.000 3.000 212.160 636.48 85 7458 REPLACE LAMP EA 550.000 5.000 63.650 318.25 90 7458 REPLACE FUSE EA 300.000 10.000 27.580 275.80 95 7458 REPLACE FUSE HOLDER EA 185.000 10.000 45.400 454.00 100 7458 REPLACE STARTER BOARD EA 5.000 1.000 10.610 10.61 110 7458 INSTALL ABOVE GROUND SPLICE EA 230.000 6.000 106.080 636.48 115 7458 INSTALL CONDUCTOR LF 45,000.000 2,234.000 1.910 4,266.94 120 7458 INSTALL ABOVE GROUND CONDUIT LF 4,700.000 60.000 6.360 381.60 130 7458 INSTALL UNDERGROUND CONDUIT LF 2,100.000 565.000 4.240 2,395.60 135 7458 INSTALL ROADWAY ILLUMINATION EA 45.000 1.000 339.450 339.45 ASSEMBLY 145 7458 INSTALL LUMINAIRE HEAD EA 85.000 22.000 106.080 2,333.76 210 7458 REPLACE PHOTOCELL EA 3.000 1.000 21.220 21.22 215 7458 REPLACE PHOTOCELL BRACKET EA 3.000 1.000 10.610 10.61 250 7458 REPLACE CIRCUIT BREAKER EA 3.000 1.000 21.220 21.22 --------------- - TOTAL BID ITEMS DONE THIS ESTIMATE - $ 16,970.61 0 TOTAL AMOUNT WORK DONE TO DATE - $ 618,796.96