1MIS.CIS.01 CONTRACT TIME STATEMENT CONTRACT 9124017 MGR.NO. 063 PAGE 001 CONT 6216 SEC 80 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 621680001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 519,425.00 REPORT DATE 04/30/2013 08.06.01 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 01,2013 TO APR 30,2013 EST NO 005 SOLUTIONS, INC. 15586 --------------------------------------------------------------------------------------------------------- DATE WORK BEGAN DEC 04, 2012 TIME COMPUTED FROM DEC 04, 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 = 730 118 118 0 BROUGHT FORWARD ADDL DAYS GRANTED = 0 APR 13 1 1 TOTAL DAYS ALLOWED = 730 2 1 DATE WORK COMPLETED 3 1 DAYS CHARGED TO DATE = 148 4 1 ASSESSED LIQ DAMAGES = 0 5 1 LIQ DAMAGE RATE $ 610 6 1 7 1 LIQUIDATED DAMAGES 8 1 0 DAYS AT $ 610 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 0 ----- ----- ----- 148 148 0 0 SATURDAY 0 SUNDAY 0 HOLIDAY 1MIS.CIS.03 CONSTRUCTN ESTIMATE BREAKDOWN CONTRACT 9124017 MGR.NO. 063 PAGE 001 CONT 6216 SEC 80 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 621680001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 519,425.00 REPORT DATE 04/30/2013 08.06.03 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 01,2013 TO APR 30,2013 EST NO 005 SOLUTIONS, INC. 15586 DIST. 18 COUNTY DALLAS CONTROL 6216-80-001 PROJECT RMC - 621680001 HIGHWAY IH0035E 0LIMITS- VARIOUS ROADWAYS IN THE DALLAS DISTRICT 0TYPE OF WORK- ROADWAY ILLUMINATION MAINTENANCE 0 0005 PREPARED BY BYRON STEPHENS 0 0055 ROADWAY ILLUMINATION MAINTENANCE 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 50.000 8.000 50.000 400.00 0065 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 400.000 70.000 110.000 7,700.00 0070 0432 RIPRAP (CONC) (CL B) (4") CY 18.000 0.000 75.000 .00 0075 0610 RELOCATE RD IL ASM (SHO-BASE) EA 10.000 0.000 100.000 .00 0080 0610 RELOCATE RD IL ASM (TRANS-BASE) EA 10.000 0.000 100.000 .00 0085 0610 RELOCATE RD IL ASM (U/P) EA 8.000 0.000 100.000 .00 0090 0610 REMOVE RD IL ASM (BRIDGE MOUNT) EA 10.000 0.000 75.000 .00 0095 0610 REMOVE RD IL ASM (SHOE-BASE) EA 10.000 0.000 75.000 .00 0100 0610 REMOVE RD IL ASM (TRANS-BASE) EA 10.000 5.000 75.000 375.00 0105 0610 REMOVE RD IL ASM (U/P) EA 16.000 0.000 75.000 .00 0110 0618 CONDT (PVC) (SCHD 40) (1 1/2") LF 200.000 0.000 6.000 .00 0115 0618 CONDT (PVC) (SCHD 40) (1 1/2") (BORE) LF 200.000 0.000 15.000 .00 0120 0618 CONDT (PVC) (SCHD 40) ( 2") LF 5,000.000 453.000 7.000 3,171.00 0125 0618 CONDT (PVC) (SCHD 40) (2") (BORE) LF 1,000.000 0.000 16.000 .00 0130 0618 CONDT (PVC) (SCHD 40) (3") LF 100.000 0.000 7.000 .00 0135 0618 CONDT (PVC) (SCHD 40) (3") (BORE) LF 100.000 0.000 17.000 .00 0140 0618 CONDT (RM) (3/4") LF 1,000.000 0.000 7.000 .00 0145 0618 CONDT (RM) (1 1/2") LF 250.000 10.000 10.000 100.00 0150 0618 CONDT (RM) (2") LF 100.000 2.000 11.000 22.00 0155 0618 CONDT (RM) (3") LF 100.000 0.000 12.000 .00 1 0160 0620 ELEC CONDR (NO. 2) BARE LF 250.000 0.000 2.000 .00 0165 0620 ELEC CONDR (NO. 2) INSULATED LF 500.000 0.000 2.150 .00 0170 0620 ELEC CONDR (NO. 4) BARE LF 250.000 0.000 1.500 .00 0175 0620 ELEC CONDR (NO. 4) INSULATED LF 500.000 0.000 1.650 .00 0180 0620 ELEC CONDR (NO. 6) BARE LF 1,000.000 112.000 1.250 140.00 0185 0620 ELEC CONDR (NO. 6) INSULATED LF 2,000.000 224.000 1.350 302.40 0190 0620 ELEC CONDR (NO. 8) BARE LF 1,000.000 4,345.000 1.000 4,345.00 0195 0620 ELEC CONDR (NO. 8) INSULATED LF 2,000.000 13,358.000 1.150 15,361.70 0200 0620 ELEC CONDR (NO.12) BARE LF 500.000 226.000 .900 203.40 0205 0620 ELEC CONDR (NO.12) INSULATED LF 1,000.000 4,424.000 1.000 4,424.00 0210 0624 GROUND BOX TY A (122311) W/APRON EA 25.000 1.000 675.000 675.00 0215 0624 REMOVE EXISTING GROUND BOXES EA 10.000 0.000 200.000 .00 0220 0628 ELC SRV TY A 240/480 100 (NS)SS(E)PS(U) EA 2.000 0.000 1,600.000 .00 0225 0628 REMOVE ELECTRICAL SERVICES EA 5.000 0.000 400.000 .00 0230 0628 ELC SRV TY A 240/480 100 (NS)SS(E)GC(O) EA 2.000 0.000 1,800.000 .00 0235 7424 LANE CLOSURE TYPE 1 (8 HR) EA 2.000 6.000 500.000 3,000.00 0240 7424 LANE CLOSURE TYPE 2 (8 HR) EA 2.000 0.000 400.000 .00 0245 7424 LANE CLOSURE TYPE 3 (8 HR) EA 6.000 0.000 350.000 .00 0250 7424 LANE CLOSURE TYPE 5 (8 HR) EA 6.000 0.000 450.000 .00 0255 7424 LANE CLOSURE TYPE 9 (8 HR) EA 2.000 0.000 400.000 .00 0260 7424 LANE CLOSURE TYPE 12 (8 HR) EA 4.000 0.000 350.000 .00 0265 7424 LANE CLOSURE TYPE 16 (8 HR) EA 25.000 52.000 350.000 18,200.00 0270 7424 LANE CLOSURE TYPE 17 HR 32.000 23.000 400.000 9,200.00 0275 8368 CONDUIT (PREPARE) LF 500.000 0.000 .250 .00 0280 8368 GROUND BOX (PREPARE) EA 5.000 0.000 50.000 .00 0285 8841 INSTALL ELECTRICAL SPLICE EA 25.000 30.000 150.000 4,500.00 0290 8841 REPAIR ABOVE-GROUND CONDUIT EA 5.000 0.000 25.000 .00 0295 8841 REPAIR UNDERGROUND CONDUIT EA 15.000 0.000 300.000 .00 0300 8841 REPAIR UNDERGROUND DUCT CABLE EA 5.000 0.000 50.000 .00 0305 8841 INSTALL ROADWAY ILLUMINATION ASSEMBLY EA 20.000 7.000 500.000 3,500.00 0310 8841 REPLACE ROADWAY ILLIMINATION ASSEMBLY EA 5.000 19.000 700.000 13,300.00 0315 8841 INSTALL UNDERPASS LUMINAIRE EA 8.000 0.000 250.000 .00 0320 8841 REPLACE UNDERPASS LUMINAIRE EA 8.000 7.000 225.000 1,575.00 0325 8841 INSTALL INDUCTION FLUORESCENT FIXTURE EA 4.000 0.000 150.000 .00 0330 8841 REPLACE INDUCTION FLUORESCENT FIXTURE EA 4.000 0.000 200.000 .00 0335 8841 INSTALL LED FIXTURE EA 10.000 0.000 150.000 .00 0340 8841 REMOVE LED FIXTURE EA 10.000 0.000 75.000 .00 0345 8841 REPLACE LED FIXTURE EA 10.000 0.000 125.000 .00 0350 8841 REPLACE LUMINAIRES EA 100.000 19.000 125.000 2,375.00 0355 8841 REPLACE HIGH MAST LUMINAIRES EA 50.000 0.000 125.000 .00 0360 8841 REPLACE LUMINAIRE ARM(S) EA 20.000 0.000 50.000 .00 0365 8841 MAINTAIN ROADWAY ILLUMINATION EA 1,500.000 238.000 75.000 17,850.00 1 0370 8841 MAINTAIN HIGH MAST ILLUMINATION EA 25.000 0.000 200.000 .00 0375 8841 MAINTAIN UNDERPASS FIXTURE EA 400.000 6.000 75.000 450.00 0380 8841 MAINTAIN INDUCTION FLUORESCENT FIXTURE EA 25.000 0.000 75.000 .00 0385 8841 MAINTAIN LED FIXTURE EA 25.000 0.000 75.000 .00 0390 8841 REPLACE TIMBER SERVICE POLE EA 5.000 0.000 125.000 .00 0395 8841 REPLACE CONCRETE SERVICE POLE EA 5.000 0.000 125.000 .00 0400 8841 REPLACE TRANSFORMER BASE EA 20.000 7.000 225.000 1,575.00 0405 8841 REPLACE TRANSFORMER BASE COVER EA 50.000 0.000 20.000 .00 0410 8841 REPLACE HAND HOLE COVER EA 50.000 0.000 10.000 .00 0415 8841 INSTALL GROUND ROD EA 10.000 0.000 100.000 .00 0420 8841 REPLACE BALLAST EA 100.000 6.000 50.000 300.00 0425 8841 REPLACE BALLAST (HIGH MAST LIGHTING) EA 50.000 0.000 75.000 .00 0430 8841 INSTALL FUSED DISCONNECT EA 10.000 0.000 50.000 .00 0435 8841 REPLACE FUSED DISCONNECT EA 10.000 0.000 50.000 .00 0440 8841 REPL LAMP SOCKET FOR POLE MOUNTED FIXT EA 100.000 1.000 20.000 20.00 0445 8841 REPL LAMP SOCKET FOR UNDERPASS FIXT EA 25.000 0.000 10.000 .00 0450 8841 REPL LAMP SOCKET FOR WALL PACK FIXT EA 25.000 0.000 10.000 .00 0455 8841 REPL LAMP FOR POLE MOUNTED FIXTURES EA 1,000.000 52.000 50.000 2,600.00 0460 8841 REPLACE LAMP FOR UNDERPASS FIXTURES EA 100.000 2.000 50.000 100.00 0465 8841 REPLACE LAMP FOR WALL PACK FIXTURES EA 25.000 0.000 25.000 .00 0470 8841 REPLACE LAMP (HIGH MAST LIGHTING) EA 500.000 0.000 25.000 .00 0475 8841 REPLACE WALL PACK LUMINAIRE EA 25.000 0.000 50.000 .00 0480 8841 REPLACE LENS FOR POLE MOUNTED FIXTURE EA 100.000 0.000 15.000 .00 0485 8841 REPLACE LENS FOR UNDERPASS FIXTURE EA 20.000 0.000 10.000 .00 0490 8841 REPLACE LENS FOR WALL PACK FIXTURE EA 10.000 0.000 10.000 .00 0495 8841 REPLACE LENS FOR HIGH MAST FIXTURE EA 25.000 0.000 15.000 .00 0500 8841 REPLACE WALL PACK GUARD EA 10.000 0.000 10.000 .00 0505 8841 REPLACE FUSE EA 150.000 113.000 30.000 3,390.00 0510 8841 REPLACE FUSE HOLDER EA 50.000 80.000 50.000 4,000.00 0515 8841 REPLACE BREAKAWAY FUSE HOLDER EA 25.000 12.000 50.000 600.00 0520 8841 REPLACE STARTING AID EA 50.000 22.000 25.000 550.00 0525 8841 REPLACE PHOTOCELL AND BRACKET EA 10.000 2.000 35.000 70.00 0530 8841 REPLACE AVIATION WARNING 1 FIXTURE EA 10.000 0.000 20.000 .00 0535 8841 REPLACE AVIATION WARNING LAMP EA 10.000 0.000 10.000 .00 0540 8841 REPLACE HAND-OFF-AUTO SWITCH EA 15.000 0.000 75.000 .00 0545 8841 REPLACE CONTACTOR EA 15.000 0.000 75.000 .00 0550 8841 REPLACE METER BASE EA 10.000 0.000 75.000 .00 0555 8841 REPLACE BREAKER PANEL EA 10.000 0.000 650.000 .00 0560 8841 REPLACE CIRCUIT BREAKER EA 50.000 0.000 40.000 .00 0565 8841 REPL FLEXIBLE POWER CABLE OR CORD LF 300.000 0.000 15.000 .00 0570 8841 REPLACE TWIST LOCK CONNECTOR EA 25.000 0.000 25.000 .00 0575 8841 REPLACE SAFETY CHAIN LF 20.000 0.000 5.000 .00 0580 8841 RAIS AND LOWR RING (HIGH MAST LIGHT) EA 50.000 0.000 100.000 .00 0585 8841 RE-STRAP EXISTING CONDUIT EA 20.000 0.000 10.000 .00 0 SUBTOTAL BID ITEMS $ 124,374.50 0 TOTAL AMOUNT WORK DONE ROADWAY ILLUMINATION MAINTENANCE $ 124,374.50 0 TOTAL AMOUNT WORK DONE CONTROL 6216-80-001 $ 124,374.50 1MIS.CIS.04 CONSTRUCTION ESTIMATE COMBINED CONTRACT 9124017 MGR.NO. 063 PAGE 001 CONT 6216 SEC 80 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 621680001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 519,425.00 REPORT DATE 04/30/2013 08.06.04 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 01,2013 TO APR 30,2013 EST NO 005 SOLUTIONS, INC. 15586 0*********************************************************************************************************************************** -LIMITS - VARIOUS ROADWAYS IN 0 THE DALLAS DISTRICT DATE WORK BEGAN DEC 4 , 2012 WORKING DAYS USED 148 PERCENT COMPLETE 23.94 PERCENT TIME USED 20.20 DATE COMPLETED 0 CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0 6216-80-001 RMC - 621680001 18 IH0035E DALLAS - ITEM DESCRIPTION UNIT ESTIMATED WORK DONE CONTRACT AMOUNT NO. QUANTITIES ON CONTRACT PRICE($) ($) -0104 REMOVING CONC (FOUNDATIONS) CY 50.000 8.000 50.000 400.00 0416 DRILL SHAFT (RDWY ILL POLE) (30 IN) LF 400.000 70.000 110.000 7,700.00 0610 REMOVE RD IL ASM (TRANS-BASE) EA 10.000 5.000 75.000 375.00 0618 CONDT (PVC) (SCHD 40) ( 2") LF 5,000.000 453.000 7.000 3,171.00 0618 CONDT (RM) (1 1/2") LF 250.000 10.000 10.000 100.00 0618 CONDT (RM) (2") LF 100.000 2.000 11.000 22.00 0620 ELEC CONDR (NO. 6) BARE LF 1,000.000 112.000 1.250 140.00 0620 ELEC CONDR (NO. 6) INSULATED LF 2,000.000 224.000 1.350 302.40 0620 ELEC CONDR (NO. 8) BARE LF 1,000.000 4,345.000 1.000 4,345.00 0620 ELEC CONDR (NO. 8) INSULATED LF 2,000.000 13,358.000 1.150 15,361.70 0620 ELEC CONDR (NO.12) BARE LF 500.000 226.000 .900 203.40 0620 ELEC CONDR (NO.12) INSULATED LF 1,000.000 4,424.000 1.000 4,424.00 0624 GROUND BOX TY A (122311) W/APRON EA 25.000 1.000 675.000 675.00 7424 LANE CLOSURE TYPE 1 (8 HR) EA 2.000 6.000 500.000 3,000.00 7424 LANE CLOSURE TYPE 16 (8 HR) EA 25.000 52.000 350.000 18,200.00 7424 LANE CLOSURE TYPE 17 HR 32.000 23.000 400.000 9,200.00 8841 INSTALL ELECTRICAL SPLICE EA 25.000 30.000 150.000 4,500.00 8841 INSTALL ROADWAY ILLUMINATION ASSEMBLY EA 20.000 7.000 500.000 3,500.00 8841 REPLACE ROADWAY ILLIMINATION ASSEMBLY EA 5.000 19.000 700.000 13,300.00 8841 REPLACE UNDERPASS LUMINAIRE EA 8.000 7.000 225.000 1,575.00 18841 REPLACE LUMINAIRES EA 100.000 19.000 125.000 2,375.00 8841 MAINTAIN ROADWAY ILLUMINATION EA 1,500.000 238.000 75.000 17,850.00 8841 MAINTAIN UNDERPASS FIXTURE EA 400.000 6.000 75.000 450.00 8841 REPLACE TRANSFORMER BASE EA 20.000 7.000 225.000 1,575.00 8841 REPLACE BALLAST EA 100.000 6.000 50.000 300.00 8841 REPL LAMP SOCKET FOR POLE MOUNTED FIXT EA 100.000 1.000 20.000 20.00 8841 REPL LAMP FOR POLE MOUNTED FIXTURES EA 1,000.000 52.000 50.000 2,600.00 8841 REPLACE LAMP FOR UNDERPASS FIXTURES EA 100.000 2.000 50.000 100.00 8841 REPLACE FUSE EA 150.000 113.000 30.000 3,390.00 8841 REPLACE FUSE HOLDER EA 50.000 80.000 50.000 4,000.00 8841 REPLACE BREAKAWAY FUSE HOLDER EA 25.000 12.000 50.000 600.00 8841 REPLACE STARTING AID EA 50.000 22.000 25.000 550.00 8841 REPLACE PHOTOCELL AND BRACKET EA 10.000 2.000 35.000 70.00 0 SUBTOTAL BID ITEMS $ 124,374.50 0 CONTRACT TOTAL ALL ITEMS $ 124,374.50 1MIS.CIS.05 CONSTR ESTIMATE DISTRIBUTION CONTRACT 9124017 MGR.NO. 063 PAGE 001 CONT 6216 SEC 80 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 621680001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 519,425.00 REPORT DATE 04/30/2013 08.06.05 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 01,2013 TO APR 30,2013 EST NO 005 SOLUTIONS, INC. 15586 ********************************************************************************************************************************** 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 - 621680001 6216-80-001 124,374.50 .00 124,374.50 .00 .00 124,374.50 101,831.50 22,543.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 ********************************************************************************************************************************** 124,374.50 .00 124,374.50 .00 .00 124,374.50 101,831.50 22,543.00 ---------------------------------------------------------------------------------------------------------------------------------- 0INPUT PROOF READ BY- SUPPORTING PAPERS OK ------------------------------ ---------------------------- 0 APPROVED DATE --------------------------------- ----------------- 1MIS.CIS.07 WORK PERFORMED THIS PERIOD CONTRACT 9124017 MGR.NO. 063 PAGE 001 CONT 6216 SEC 80 JOB 001 RES ENGR SURRATT, LANNY PROJ RMC - 621680001 HWY IH0035E 4777 E. HWY 80 MESQUITE CNTY DALLAS DIST 18 CONTRACT PRICE $ 519,425.00 REPORT DATE 04/30/2013 08.06.06 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 01,2013 TO APR 30,2013 EST NO 005 SOLUTIONS, INC. 15586 ********************************************************************************************************************* - CONTROL PROJECT DISTRICT HIGHWAY COUNTY 6216-80-001 RMC - 621680001 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 50.000 1.000 50.000 50.00 65 0416 DRILL SHAFT (RDWY ILL POLE) LF 400.000 10.000 110.000 1,100.00 (30 IN) 190 0620 ELEC CONDR (NO. 8) BARE LF 1,000.000 68.000 1.000 68.00 195 0620 ELEC CONDR (NO. 8) INSULATED LF 2,000.000 3,584.000 1.150 4,121.60 200 0620 ELEC CONDR (NO.12) BARE LF 500.000 226.000 0.900 203.40 205 0620 ELEC CONDR (NO.12) INSULATED LF 1,000.000 650.000 1.000 650.00 265 7424 LANE CLOSURE TYPE 16 (8 HR) EA 25.000 16.000 350.000 5,600.00 285 8841 INSTALL ELECTRICAL SPLICE EA 25.000 10.000 150.000 1,500.00 310 8841 REPLACE ROADWAY ILLIMINATION EA 5.000 5.000 700.000 3,500.00 ASSEMBLY 365 8841 MAINTAIN ROADWAY EA 1,500.000 57.000 75.000 4,275.00 ILLUMINATION 400 8841 REPLACE TRANSFORMER BASE EA 20.000 3.000 225.000 675.00 505 8841 REPLACE FUSE EA 150.000 10.000 30.000 300.00 510 8841 REPLACE FUSE HOLDER EA 50.000 10.000 50.000 500.00 --------------- - TOTAL BID ITEMS DONE THIS ESTIMATE - $ 22,543.00 0 TOTAL AMOUNT WORK DONE TO DATE - $ 124,374.50