1MIS.CIS.01 CONTRACT TIME STATEMENT CONTRACT 9094005 MGR.NO. 770 PAGE 001 CONT 6197 SEC 60 JOB 001 RES ENGR WEBSTER, CHUCK PROJ RMC - 619760001 HWY US0054 13301 GATEWAY WEST EL PAS CNTY EL PASO DIST 24 CONTRACT PRICE $ 1,119,642.84 REPORT DATE 05/17/2012 08.56.33 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 30,2012 TO APR 30,2012 EST NO 031 & SM-FIN SYSTEMS, CORP. 13538 --------------------------------------------------------------------------------------------------------- DATE WORK BEGAN NOV 16, 2009 TIME COMPUTED FROM NOV 09, 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 874 867 7 BROUGHT FORWARD ADDL DAYS GRANTED = 167 APR 12 1 1 TOTAL DAYS ALLOWED = 897 2 1 DATE WORK COMPLETED 04/30/12 3 1 DAYS CHARGED TO DATE = 897 4 1 ASSESSED LIQ DAMAGES = 0 5 1 LIQ DAMAGE RATE $ 625 6 1 7 1 LIQUIDATED DAMAGES 8 1 0 DAYS AT $ 625 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 ----- ----- ----- 904 897 7 0 SATURDAY 0 SUNDAY 0 HOLIDAY 1MIS.CIS.03 CONSTRUCTN ESTIMATE BREAKDOWN CONTRACT 9094005 MGR.NO. 770 PAGE 001 CONT 6197 SEC 60 JOB 001 RES ENGR WEBSTER, CHUCK PROJ RMC - 619760001 HWY US0054 13301 GATEWAY WEST EL PAS CNTY EL PASO DIST 24 CONTRACT PRICE $ 1,119,642.84 REPORT DATE 05/17/2012 08.56.35 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 30,2012 TO APR 30,2012 EST NO 031 & SM-FIN SYSTEMS, CORP. 13538 DIST. 24 COUNTY EL PASO CONTROL 6197-60-001 PROJECT RMC - 619760001 HIGHWAY US0054 0LIMITS- NEW MEXICO STATE LINE EL PASO DISTRICT LINE 0TYPE OF WORK- TRAFFIC MANAGEMENT SYSTEM MANAGEMENT 0 0005 CHARLES H. BERRY, JR., P.E. - DISTRICT ENGINEER 0010 TRAFFIC SECTION 0 0060 TRAFFIC MANAGEMENT MAINTENANCE NET LENGTH 0.010 MILES 0 LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES ON CONTRACT PRICE($) ($) - 0065 0502 BARR, SIGNS & TRAF HANDLE (MOBILE OP) HR 280.000 514.000 299.750 154,071.50 0065 0502 ADJ EST QUANTITY TO DATE 350.000 0070 7492 REPLACE LANE CONTROL LAMP EA 275.000 281.000 160.610 45,131.41 0070 7492 ADJ EST QUANTITY TO DATE 290.000 0075 7493 BARR, SIGNS & TRAF HANDLE(MAINLANES) CYC 20.000 3.000 1,806.370 5,419.11 0075 7493 ADJ EST QUANTITY TO DATE 1.000 0080 7493 BARR, SIGNS & TRAF HANDLE(SRV RD&RMP) CYC 20.000 9.000 1,412.500 12,712.50 0080 7493 ADJ EST QUANTITY TO DATE 10.000 0085 7493 TROUBLESHOOT BARRIER GATE HR 10.000 49.000 116.860 5,726.14 0085 7493 ADJ EST QUANTITY TO DATE 52.000 0090 7493 REPLC BARRIER GATE ARM EA 1.000 1.000 676.860 676.86 0090 7493 ADJ EST QUANTITY TO DATE 1.000 0095 7493 REPLC SIGNAL CABLE (2 CONDR) LF 1,000.000 460.000 1.560 717.60 0095 7493 ADJ EST QUANTITY TO DATE 300.000 0100 7493 REPLC SIGNAL CABLE (5 CONDR) LF 500.000 530.000 2.020 1,070.60 0100 7493 ADJ EST QUANTITY TO DATE 540.000 0105 7493 REPLC SIGNAL CABLE (7 CONDR) LF 500.000 984.000 2.320 2,282.88 0105 7493 ADJ EST QUANTITY TO DATE 850.000 0110 7493 REPLC SGN CBL (CONDR)(NO.6-NO.8) LF 2,500.000 1,822.000 1.090 1,985.98 0110 7493 ADJ EST QUANTITY TO DATE 1,900.000 0115 7493 REPLC SGN CBL (CONDR)(NO.12 NO.8) LF 2,500.000 5,362.000 .920 4,933.04 0115 7493 ADJ EST QUANTITY TO DATE 385.000 1 0120 7493 REPLC SGN CBL (CONDR)(NO.2-NO.I/O) LF 1,500.000 4,600.000 2.720 12,512.00 0120 7493 ADJ EST QUANTITY TO DATE 4,800.000 0125 7493 REPLC INTERCONNECT/COM CABLE (12 PAIR) LF 100.000 1,346.000 4.080 5,491.68 0125 7493 ADJ EST QUANTITY TO DATE 850.000 0130 7493 REPLC FIBER OPTIC CABLE (6 STAND) LF 1,500.000 200.000 3.670 734.00 0130 7493 ADJ EST QUANTITY TO DATE 210.000 0135 7493 REPLC FIBER OPTIC CABLE (12 STAND) LF 500.000 0.000 3.670 .00 0135 7493 ADJ EST QUANTITY TO DATE 2.000 0140 7493 REPLC FIBER OPTIC CABLE (48 STAND) LF 1,500.000 0.000 3.670 .00 0140 7493 ADJ EST QUANTITY TO DATE 2.000 0145 7493 REPLC FIBER OPTIC CABLE (96 STAND) LF 2,500.000 6,500.000 3.670 23,855.00 0145 7493 ADJ EST QUANTITY TO DATE 2.000 0150 7493 REPLC COMMUN CABLE (COAX CABLE) LF 500.000 2,924.000 2.880 8,421.12 0150 7493 ADJ EST QUANTITY TO DATE 1,250.000 0155 7493 TROUBLESHOOT POWER CABLE HR 20.000 6.000 131.860 791.16 0155 7493 ADJ EST QUANTITY TO DATE 8.000 0160 7493 TROUBLESHOOT INTERCONNECT CABLE HR 20.000 9.000 131.860 1,186.74 0160 7493 ADJ EST QUANTITY TO DATE 10.000 0165 7493 TROUBLESHOOT SIGNAL CABLE HR 24.000 5.000 131.860 659.30 0165 7493 ADJ EST QUANTITY TO DATE 6.000 0170 7493 TROUBLESHOOT FIBER OPTIC CABLE HR 60.000 0.000 203.720 .00 0170 7493 ADJ EST QUANTITY TO DATE 2.000 0175 7493 TROUBLESHOOT COMMUNICATION CABLE HR 8.000 70.000 131.860 9,230.20 0175 7493 ADJ EST QUANTITY TO DATE 75.000 0180 7493 TROUBLESHOOT CCTV OR VIVD SYSTEM HR 24.000 96.000 131.860 12,658.56 0180 7493 ADJ EST QUANTITY TO DATE 80.000 0185 7493 ADJUST CCTV CAMERA HR 8.000 5.000 131.860 659.30 0185 7493 ADJ EST QUANTITY TO DATE 8.000 0190 7493 REPLC CCTV CAMERA (INCLD PAN UNIT&LENS) EA 24.000 40.000 527.450 21,098.00 0190 7493 ADJ EST QUANTITY TO DATE 30.000 0195 7493 REPLC CCTV CAMERA CONTROLLER EA 6.000 5.000 527.450 2,637.25 0195 7493 ADJ EST QUANTITY TO DATE 6.000 0200 7493 REPLC CCTV CONTROLLER CAB(GRND/POLE MT) EA 1.000 1.000 527.450 527.45 0200 7493 ADJ EST QUANTITY TO DATE 1.000 0205 7493 REPLC CCTV CAMERA POLE EA 2.000 5.000 1,399.840 6,999.20 0205 7493 ADJ EST QUANTITY TO DATE 6.000 0210 7493 PREVENT MAINT OF CCTV CAMERA SYS UNIT EA 200.000 0.000 263.720 .00 1 0210 7493 ADJ EST QUANTITY TO DATE 2.000 0215 7493 TRBSHT MICROWAVE DETECTION (MVD) SYS HR 50.000 4.000 154.860 619.44 0215 7493 ADJ EST QUANTITY TO DATE 6.000 0220 7493 ADJUST MICROWAVE VEHICLE DETECTORS EA 50.000 0.000 550.450 .00 0220 7493 ADJ EST QUANTITY TO DATE 2.000 0225 7493 REPLACE MICROWAVE EMITTER EA 12.000 0.000 527.450 .00 0225 7493 ADJ EST QUANTITY TO DATE 2.000 0230 7493 REPLACE MICROWAVE CONTROLLER EA 4.000 0.000 527.450 .00 0230 7493 ADJ EST QUANTITY TO DATE 1.000 0235 7493 REPLC MVD CONTRLLER CAB(GRND/POLE MT) EA 1.000 1.000 680.240 680.24 0235 7493 ADJ EST QUANTITY TO DATE 1.000 0240 7493 REPLC MVD DETECTOR POLE EA 1.000 0.000 1,399.840 .00 0240 7493 ADJ EST QUANTITY TO DATE 1.000 0245 7493 PREVENTATIVE MAINTENANCE OF MVD EA 350.000 0.000 263.720 .00 0245 7493 ADJ EST QUANTITY TO DATE 2.000 0250 7493 REPLC BATTERIES (700VA-3500VA) EA 6.000 0.000 551.220 .00 0250 7493 ADJ EST QUANTITY TO DATE 1.000 0255 7493 REPLC BATTERIES (100VA-950VA) EA 2.000 4.000 551.220 2,204.88 0255 7493 ADJ EST QUANTITY TO DATE 5.000 0260 7493 REPLC BATTERIES (24&HIGHER BATTERY) EA 40.000 55.000 551.220 30,317.10 0260 7493 ADJ EST QUANTITY TO DATE 52.000 0265 7493 TROUBLESHOOT VIDEO MULTIPLEX UNIT HR 4.000 0.000 131.860 .00 0265 7493 ADJ EST QUANTITY TO DATE 1.000 0270 7493 TROUBLESHOOT VIDEO SWITCHER UNIT HR 2.000 10.000 131.860 1,318.60 0270 7493 ADJ EST QUANTITY TO DATE 5.000 0275 7493 TRBSHT DYNAMIC MESS SIGN CONTROLLER HR 30.000 45.000 131.860 5,933.70 0275 7493 ADJ EST QUANTITY TO DATE 15.000 0280 7493 REPLACE DYNAMIC MESS SIGN CONTROLLER EA 1.000 4.000 527.450 2,109.80 0280 7493 ADJ EST QUANTITY TO DATE 5.000 0285 7493 TROULBLESHOOT DYNAMIC MESS SIGN HR 80.000 107.000 131.860 14,109.02 0285 7493 ADJ EST QUANTITY TO DATE 112.000 0290 7493 PREVENTATIVE MAINTENANCE OF DMS EA 110.000 25.000 263.720 6,593.00 0290 7493 ADJ EST QUANTITY TO DATE 30.000 0295 7493 TROUBLESHOOT EQUIPMENT CABINET HR 16.000 77.000 131.860 10,153.22 0295 7493 ADJ EST QUANTITY TO DATE 65.000 0300 7493 REPLACE EQUIPMENT CABINET EA 1.000 3.000 527.450 1,582.35 0300 7493 ADJ EST QUANTITY TO DATE 4.000 1 0305 7493 TROUBLESHOOT FIBER OPTIC CABLE (SM) HR 50.000 62.000 131.860 8,175.32 0305 7493 ADJ EST QUANTITY TO DATE 60.000 0310 7493 TROUBLESHOOT FIBER OPTIC CABLE (MM) HR 12.000 0.000 131.860 .00 0310 7493 ADJ EST QUANTITY TO DATE 1.000 0315 7493 SPLICE FIBER OPTIC CABLE (SM) EA 16.000 22.000 642.450 14,133.90 0315 7493 ADJ EST QUANTITY TO DATE 24.000 0320 7493 SPLICE FIBER OPTIC CABLE (MM) EA 2.000 0.000 642.450 .00 0320 7493 ADJ EST QUANTITY TO DATE 2.000 0325 7493 TRBLSHT MLDM RCK ASM/ASSC CIRCT CARD EA 2.000 16.000 527.450 8,439.20 0325 7493 ADJ EST QUANTITY TO DATE 18.000 0330 7493 CONFIGURE A T1 NETWORK HR 12.000 15.000 131.860 1,977.90 0330 7493 ADJ EST QUANTITY TO DATE 16.000 0335 7493 REPR OR REPLC DROP/INSRT MLDM RACK MCU EA 2.000 2.000 527.450 1,054.90 0335 7493 ADJ EST QUANTITY TO DATE 2.000 0340 7493 TRBLSHT LIMITED DISTANCE MODEM RACK HR 5.000 12.000 131.860 1,582.32 0340 7493 ADJ EST QUANTITY TO DATE 14.000 0345 7493 TRBLSHT COMM HUB AND/OR VAULT CABLING HR 24.000 41.000 131.860 5,406.26 0345 7493 ADJ EST QUANTITY TO DATE 45.000 0350 7493 PREVENT MAINT AT HUB BLDG AND/OR VAULT EA 50.000 22.000 527.450 11,603.90 0350 7493 ADJ EST QUANTITY TO DATE 25.000 0355 7493 TROUBLESHOOT EQUIPMENT CABINET HR 1.000 112.000 131.860 14,768.32 0355 7493 ADJ EST QUANTITY TO DATE 110.000 0360 7493 PREVENT MAINT AT EQUIPMENT CABINET EA 300.000 190.000 263.720 50,106.80 0360 7493 ADJ EST QUANTITY TO DATE 210.000 0365 7493 TRBSHT LANE CONTROL SIGNAL (FRWY) HR 10.000 54.000 131.860 7,120.44 0365 7493 ADJ EST QUANTITY TO DATE 50.000 0370 7493 REPLC LANE CONTROL SIGNAL (FRWY) EA 6.000 69.000 3,983.200 274,840.80 0370 7493 ADJ EST QUANTITY TO DATE 61.000 0 SUBTOTAL BID ITEMS $ 817,019.99 0 0371 CHANGE ORDER #4-INCREASE QUANTITY ON LINE 370 FROM 6 TO 0372 61 ITEMS FOR INCREASE-SEE MATERIAL ON HAND 0 0375 7493 REPLC LCS SUPPORT BRACKET ASSEMBLY EA 3.000 6.000 883.950 5,303.70 0375 7493 ADJ EST QUANTITY TO DATE 3.000 0380 7493 REPLACE DIAL-UP MODEM EA 1.000 0.000 527.450 .00 1 0380 7493 ADJ EST QUANTITY TO DATE 1.000 0385 7493 REPLC PWR CONNECTION (EXCLUDING POLES) EA 12.000 29.000 3,261.120 94,572.48 0385 7493 ADJ EST QUANTITY TO DATE 32.000 0390 7493 REPLC PWR SERV POLE (EXCL SERVICES) EA 12.000 26.000 1,352.090 35,154.34 0390 7493 ADJ EST QUANTITY TO DATE 26.000 0395 7493 PREVENT MAINT DYNMC SGN ASSEMBLY COMPT EA 1.000 10.000 527.450 5,274.50 0395 7493 ADJ EST QUANTITY TO DATE 12.000 0400 7493 CONDUIT (PVC) (SCHD 40) (2") LF 3,000.000 2,642.000 7.200 19,022.40 0400 7493 ADJ EST QUANTITY TO DATE 2,434.000 0405 7493 CONDUIT (PVC) (SCHD 40) (3") LF 1,000.000 1,060.000 8.200 8,692.00 0405 7493 ADJ EST QUANTITY TO DATE 538.000 0410 7493 CONDUIT (PVC) (SCHD 40) (3") BORE LF 1,200.000 775.000 23.200 17,980.00 0410 7493 ADJ EST QUANTITY TO DATE 683.000 0415 7493 REPLC PULL BOX TY A (122311) W/APRON EA 32.000 34.000 824.740 28,041.16 0415 7493 ADJ EST QUANTITY TO DATE 35.000 0420 7493 REPLC PULL BOX TY D (162922) W/APRON EA 4.000 7.000 898.670 6,290.69 0420 7493 ADJ EST QUANTITY TO DATE 8.000 0425 7493 REPLC PULL BOX (TY 1) (122422) W/APRON EA 5.000 0.000 3,537.120 .00 0425 7493 ADJ EST QUANTITY TO DATE 1.000 0430 7493 REPLC LCU EA 1.000 4.000 527.450 2,109.80 0430 7493 ADJ EST QUANTITY TO DATE 5.000 0435 7493 REPLACE STAND ALONE LIMTD DIST MODEM EA 1.000 6.000 527.450 3,164.70 0435 7493 ADJ EST QUANTITY TO DATE 8.000 0440 7493 ADJUST VIVDS DETECTOR CAMERA HR 10.000 0.000 131.860 .00 0440 7493 ADJ EST QUANTITY TO DATE 1.000 0445 7493 REPLACE VIVDS DETECTOR CAMERA EA 4.000 7.000 1,504.950 10,534.65 0445 7493 ADJ EST QUANTITY TO DATE 6.000 0450 7493 TRBLSHT VIVDS DETECTOR CAMERA HR 4.000 0.000 131.860 .00 0450 7493 ADJ EST QUANTITY TO DATE 1.000 0455 7493 REMOVE & REPLC FND (HUB CABINET) EA 2.000 1.000 5,182.920 5,182.92 0455 7493 ADJ EST QUANTITY TO DATE 2.000 0460 7493 REMOVE & REPLC FND (PEDESTRIAN) EA 12.000 13.000 882.390 11,471.07 0460 7493 ADJ EST QUANTITY TO DATE 10.000 0465 7493 REMOVE & REPLC POLE FND (SIGNAL) EA 3.000 27.000 1,896.900 51,216.30 0465 7493 ADJ EST QUANTITY TO DATE 28.000 0470 7493 REMOVE & REPLC FND (DMS CONTROLLER) EA 1.000 0.000 3,073.130 .00 0470 7493 ADJ EST QUANTITY TO DATE 1.000 1 0475 7493 REMOVE & REPLC FND (EQUIPMENT CAB) EA 8.000 11.000 3,073.130 33,804.43 0475 7493 ADJ EST QUANTITY TO DATE 8.000 0480 7493 CLEAN CCTV CAMERA EA 400.000 448.000 263.720 118,146.56 0480 7493 ADJ EST QUANTITY TO DATE 380.000 0485 7493 SERVICE HAR EQUIPMENT EA 60.000 30.000 527.450 15,823.50 0485 7493 ADJ EST QUANTITY TO DATE 35.000 0490 7493 SPLICE FIBER (SINGLE MODE) EA 10.000 5.000 642.450 3,212.25 0490 7493 ADJ EST QUANTITY TO DATE 5.000 0495 7493 SPLICE FIBER (MULTI MODE) EA 2.000 2.000 642.450 1,284.90 0495 7493 ADJ EST QUANTITY TO DATE 2.000 0500 7494 PREVENTIVE MAINTENANCE EA 180.000 247.000 263.720 65,138.84 0500 7494 ADJ EST QUANTITY TO DATE 210.000 0505 0690 INSTALL OF VEHICLE DETECTORS LF 100.000 0.000 7.640 .00 0505 0690 ADJ EST QUANTITY TO DATE 2.000 0 SUBTOTAL BID ITEMS $ 541,421.19 0 0600 CHANGE ORDER NO.1 ADSS 3 NEW ITEMS TO THE CONTRACT. 0601 ITEM 7493-2086, ITEM 7493-2087 & ITEM 7494-2003. THESE ITEMS 0602 ARE NEEDED TO REPLACE SIGNAL CABLES AND TO CHANGE OUT LED'S. 0 0605 7493*REPLC SIGNAL CABLE (3 CONDR) LF 2,000.000 218.000 1.930 420.74 0605 7493 ADJ EST QUANTITY TO DATE 250.000 0610 7493*REPLC FIBER OPTIC CABLE (72 STAND) LF 1,000.000 0.000 3.800 .00 0610 7493 ADJ EST QUANTITY TO DATE 10.000 0615 7494*REPLC LED SIGNAL LAMP (RED) EA 175.000 260.000 49.850 12,961.00 0615 7494 ADJ EST QUANTITY TO DATE 260.000 0 SUBTOTAL BID ITEMS $ 13,381.74 0 0620 CHANGE ORDER #2 - TRAFFIC ILLUMINATION 0 0625 9001*REMOVE/REPLACE HUB CABINET(INSTALL) EA 1.000 1.000 3,750.640 3,750.64 0625 9001 ADJ EST QUANTITY TO DATE 1.000 0 SUBTOTAL BID ITEMS $ 3,750.64 0 0630 CHANGE ORDER NO. 3 - ADD LINE 2 LINES ITEMS 9002 & 9003 0 0635 9002*SPREAD SPECTRUM RADIO EA 4.000 0.000 6,060.000 .00 0635 9002 ADJ EST QUANTITY TO DATE 0.000 0638 9002*SPREAD SPECTRUM RADIO EA 4.000 4.000 1,515.000 6,060.00 0640 9003*ETHERNET MEDIA CONVERTER EA 54.000 0.000 64,800.000 .00 0640 9003 ADJ EST QUANTITY TO DATE 0.000 0643 9003*ETHERNET MEDIA CONVERTER EA 54.000 54.000 1,200.000 64,800.00 0 SUBTOTAL BID ITEMS $ 70,860.00 1 MATERIAL ON HAND 0 LINE MATRL. NO MATERIAL DESCRIPTION UNIT QUANTITY % INV UNIT PRICE AMOUNT NO. PRICE ALLOWED($) ($) 0 0800 780 MATERIAL ON HAND (MOH) EA 0.000 100 2,200.000 .00 0 TOTAL AMOUNT WORK DONE TRAFFIC MANAGEMENT MAINTENANCE $ 1,446,433.56 0 TOTAL AMOUNT WORK DONE CONTROL 6197-60-001 $ 1,446,433.56 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 1MIS.CIS.04 CONSTRUCTION ESTIMATE COMBINED CONTRACT 9094005 MGR.NO. 770 PAGE 001 CONT 6197 SEC 60 JOB 001 RES ENGR WEBSTER, CHUCK PROJ RMC - 619760001 HWY US0054 13301 GATEWAY WEST EL PAS CNTY EL PASO DIST 24 CONTRACT PRICE $ 1,119,642.84 REPORT DATE 05/17/2012 08.56.36 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 30,2012 TO APR 30,2012 EST NO 031 & SM-FIN SYSTEMS, CORP. 13538 0*********************************************************************************************************************************** -LIMITS - NEW MEXICO STATE LINE 0 EL PASO DISTRICT LINE DATE WORK BEGAN NOV 16, 2009 WORKING DAYS USED 897 PERCENT COMPLETE 100.00 PERCENT TIME USED 100.00 DATE COMPLETED APR 30 2012 0 CONTROL PROJECT DISTRICT HIGHWAY COUNTY 0 6197-60-001 RMC - 619760001 24 US0054 EL PASO - ITEM DESCRIPTION UNIT ESTIMATED WORK DONE CONTRACT AMOUNT NO. QUANTITIES ON CONTRACT PRICE($) ($) -0502 BARR, SIGNS & TRAF HANDLE (MOBILE OP) HR 280.000 514.000 299.750 154,071.50 0502 ADJ EST QUANTITY TO DATE 350.000 7492 REPLACE LANE CONTROL LAMP EA 275.000 281.000 160.610 45,131.41 7492 ADJ EST QUANTITY TO DATE 290.000 7493 BARR, SIGNS & TRAF HANDLE(MAINLANES) CYC 20.000 3.000 1,806.370 5,419.11 7493 ADJ EST QUANTITY TO DATE 1.000 7493 BARR, SIGNS & TRAF HANDLE(SRV RD&RMP) CYC 20.000 9.000 1,412.500 12,712.50 7493 ADJ EST QUANTITY TO DATE 10.000 7493 TROUBLESHOOT BARRIER GATE HR 10.000 49.000 116.860 5,726.14 7493 ADJ EST QUANTITY TO DATE 52.000 7493 REPLC BARRIER GATE ARM EA 1.000 1.000 676.860 676.86 7493 ADJ EST QUANTITY TO DATE 1.000 7493 REPLC SIGNAL CABLE (2 CONDR) LF 1,000.000 460.000 1.560 717.60 7493 ADJ EST QUANTITY TO DATE 300.000 7493 REPLC SIGNAL CABLE (5 CONDR) LF 500.000 530.000 2.020 1,070.60 7493 ADJ EST QUANTITY TO DATE 540.000 7493 REPLC SIGNAL CABLE (7 CONDR) LF 500.000 984.000 2.320 2,282.88 7493 ADJ EST QUANTITY TO DATE 850.000 7493 REPLC SGN CBL (CONDR)(NO.6-NO.8) LF 2,500.000 1,822.000 1.090 1,985.98 7493 ADJ EST QUANTITY TO DATE 1,900.000 7493 REPLC SGN CBL (CONDR)(NO.12 1 NO.8) LF 2,500.000 5,362.000 .920 4,933.04 7493 ADJ EST QUANTITY TO DATE 385.000 7493 REPLC SGN CBL (CONDR)(NO.2-NO.I/O) LF 1,500.000 4,600.000 2.720 12,512.00 7493 ADJ EST QUANTITY TO DATE 4,800.000 7493 REPLC INTERCONNECT/COM CABLE (12 PAIR) LF 100.000 1,346.000 4.080 5,491.68 7493 ADJ EST QUANTITY TO DATE 850.000 7493 REPLC FIBER OPTIC CABLE (6 STAND) LF 1,500.000 200.000 3.670 734.00 7493 ADJ EST QUANTITY TO DATE 210.000 7493 REPLC FIBER OPTIC CABLE (96 STAND) LF 2,500.000 6,500.000 3.670 23,855.00 7493 ADJ EST QUANTITY TO DATE 2.000 7493 REPLC COMMUN CABLE (COAX CABLE) LF 500.000 2,924.000 2.880 8,421.12 7493 ADJ EST QUANTITY TO DATE 1,250.000 7493 TROUBLESHOOT POWER CABLE HR 20.000 6.000 131.860 791.16 7493 ADJ EST QUANTITY TO DATE 8.000 7493 TROUBLESHOOT INTERCONNECT CABLE HR 20.000 9.000 131.860 1,186.74 7493 ADJ EST QUANTITY TO DATE 10.000 7493 TROUBLESHOOT SIGNAL CABLE HR 24.000 5.000 131.860 659.30 7493 ADJ EST QUANTITY TO DATE 6.000 7493 TROUBLESHOOT COMMUNICATION CABLE HR 8.000 70.000 131.860 9,230.20 7493 ADJ EST QUANTITY TO DATE 75.000 7493 TROUBLESHOOT CCTV OR VIVD SYSTEM HR 24.000 96.000 131.860 12,658.56 7493 ADJ EST QUANTITY TO DATE 80.000 7493 ADJUST CCTV CAMERA HR 8.000 5.000 131.860 659.30 7493 ADJ EST QUANTITY TO DATE 8.000 7493 REPLC CCTV CAMERA (INCLD PAN UNIT&LENS) EA 24.000 40.000 527.450 21,098.00 7493 ADJ EST QUANTITY TO DATE 30.000 7493 REPLC CCTV CAMERA CONTROLLER EA 6.000 5.000 527.450 2,637.25 7493 ADJ EST QUANTITY TO DATE 6.000 7493 REPLC CCTV CONTROLLER CAB(GRND/POLE MT) EA 1.000 1.000 527.450 527.45 7493 ADJ EST QUANTITY TO DATE 1.000 7493 REPLC CCTV CAMERA POLE EA 2.000 5.000 1,399.840 6,999.20 7493 ADJ EST QUANTITY TO DATE 6.000 7493 TRBSHT MICROWAVE DETECTION (MVD) SYS HR 50.000 4.000 154.860 619.44 7493 ADJ EST QUANTITY TO DATE 6.000 7493 REPLC MVD CONTRLLER CAB(GRND/POLE MT) EA 1.000 1.000 680.240 680.24 7493 ADJ EST QUANTITY TO DATE 1.000 7493 REPLC BATTERIES (100VA-950VA) EA 2.000 4.000 551.220 2,204.88 7493 ADJ EST QUANTITY TO DATE 5.000 17493 REPLC BATTERIES (24&HIGHER BATTERY) EA 40.000 55.000 551.220 30,317.10 7493 ADJ EST QUANTITY TO DATE 52.000 7493 TROUBLESHOOT VIDEO SWITCHER UNIT HR 2.000 10.000 131.860 1,318.60 7493 ADJ EST QUANTITY TO DATE 5.000 7493 TRBSHT DYNAMIC MESS SIGN CONTROLLER HR 30.000 45.000 131.860 5,933.70 7493 ADJ EST QUANTITY TO DATE 15.000 7493 REPLACE DYNAMIC MESS SIGN CONTROLLER EA 1.000 4.000 527.450 2,109.80 7493 ADJ EST QUANTITY TO DATE 5.000 7493 TROULBLESHOOT DYNAMIC MESS SIGN HR 80.000 107.000 131.860 14,109.02 7493 ADJ EST QUANTITY TO DATE 112.000 7493 PREVENTATIVE MAINTENANCE OF DMS EA 110.000 25.000 263.720 6,593.00 7493 ADJ EST QUANTITY TO DATE 30.000 7493 TROUBLESHOOT EQUIPMENT CABINET HR 16.000 77.000 131.860 10,153.22 7493 ADJ EST QUANTITY TO DATE 65.000 7493 REPLACE EQUIPMENT CABINET EA 1.000 3.000 527.450 1,582.35 7493 ADJ EST QUANTITY TO DATE 4.000 7493 TROUBLESHOOT FIBER OPTIC CABLE (SM) HR 50.000 62.000 131.860 8,175.32 7493 ADJ EST QUANTITY TO DATE 60.000 7493 SPLICE FIBER OPTIC CABLE (SM) EA 16.000 22.000 642.450 14,133.90 7493 ADJ EST QUANTITY TO DATE 24.000 7493 TRBLSHT MLDM RCK ASM/ASSC CIRCT CARD EA 2.000 16.000 527.450 8,439.20 7493 ADJ EST QUANTITY TO DATE 18.000 7493 CONFIGURE A T1 NETWORK HR 12.000 15.000 131.860 1,977.90 7493 ADJ EST QUANTITY TO DATE 16.000 7493 REPR OR REPLC DROP/INSRT MLDM RACK MCU EA 2.000 2.000 527.450 1,054.90 7493 ADJ EST QUANTITY TO DATE 2.000 7493 TRBLSHT LIMITED DISTANCE MODEM RACK HR 5.000 12.000 131.860 1,582.32 7493 ADJ EST QUANTITY TO DATE 14.000 7493 TRBLSHT COMM HUB AND/OR VAULT CABLING HR 24.000 41.000 131.860 5,406.26 7493 ADJ EST QUANTITY TO DATE 45.000 7493 PREVENT MAINT AT HUB BLDG AND/OR VAULT EA 50.000 22.000 527.450 11,603.90 7493 ADJ EST QUANTITY TO DATE 25.000 7493 TROUBLESHOOT EQUIPMENT CABINET HR 1.000 112.000 131.860 14,768.32 7493 ADJ EST QUANTITY TO DATE 110.000 7493 PREVENT MAINT AT EQUIPMENT CABINET EA 300.000 190.000 263.720 50,106.80 17493 ADJ EST QUANTITY TO DATE 210.000 7493 TRBSHT LANE CONTROL SIGNAL (FRWY) HR 10.000 54.000 131.860 7,120.44 7493 ADJ EST QUANTITY TO DATE 50.000 7493 REPLC LANE CONTROL SIGNAL (FRWY) EA 6.000 69.000 3,983.200 274,840.80 7493 ADJ EST QUANTITY TO DATE 61.000 7493 REPLC LCS SUPPORT BRACKET ASSEMBLY EA 3.000 6.000 883.950 5,303.70 7493 ADJ EST QUANTITY TO DATE 3.000 7493 REPLC PWR CONNECTION (EXCLUDING POLES) EA 12.000 29.000 3,261.120 94,572.48 7493 ADJ EST QUANTITY TO DATE 32.000 7493 REPLC PWR SERV POLE (EXCL SERVICES) EA 12.000 26.000 1,352.090 35,154.34 7493 ADJ EST QUANTITY TO DATE 26.000 7493 PREVENT MAINT DYNMC SGN ASSEMBLY COMPT EA 1.000 10.000 527.450 5,274.50 7493 ADJ EST QUANTITY TO DATE 12.000 7493 CONDUIT (PVC) (SCHD 40) (2") LF 3,000.000 2,642.000 7.200 19,022.40 7493 ADJ EST QUANTITY TO DATE 2,434.000 7493 CONDUIT (PVC) (SCHD 40) (3") LF 1,000.000 1,060.000 8.200 8,692.00 7493 ADJ EST QUANTITY TO DATE 538.000 7493 CONDUIT (PVC) (SCHD 40) (3") BORE LF 1,200.000 775.000 23.200 17,980.00 7493 ADJ EST QUANTITY TO DATE 683.000 7493 REPLC PULL BOX TY A (122311) W/APRON EA 32.000 34.000 824.740 28,041.16 7493 ADJ EST QUANTITY TO DATE 35.000 7493 REPLC PULL BOX TY D (162922) W/APRON EA 4.000 7.000 898.670 6,290.69 7493 ADJ EST QUANTITY TO DATE 8.000 7493 REPLC LCU EA 1.000 4.000 527.450 2,109.80 7493 ADJ EST QUANTITY TO DATE 5.000 7493 REPLACE STAND ALONE LIMTD DIST MODEM EA 1.000 6.000 527.450 3,164.70 7493 ADJ EST QUANTITY TO DATE 8.000 7493 REPLACE VIVDS DETECTOR CAMERA EA 4.000 7.000 1,504.950 10,534.65 7493 ADJ EST QUANTITY TO DATE 6.000 7493 REMOVE & REPLC FND (HUB CABINET) EA 2.000 1.000 5,182.920 5,182.92 7493 ADJ EST QUANTITY TO DATE 2.000 7493 REMOVE & REPLC FND (PEDESTRIAN) EA 12.000 13.000 882.390 11,471.07 7493 ADJ EST QUANTITY TO DATE 10.000 7493 REMOVE & REPLC POLE FND (SIGNAL) EA 3.000 27.000 1,896.900 51,216.30 7493 ADJ EST QUANTITY TO DATE 28.000 7493 REMOVE & REPLC FND (EQUIPMENT CAB) EA 8.000 11.000 3,073.130 33,804.43 17493 ADJ EST QUANTITY TO DATE 8.000 7493 CLEAN CCTV CAMERA EA 400.000 448.000 263.720 118,146.56 7493 ADJ EST QUANTITY TO DATE 380.000 7493 SERVICE HAR EQUIPMENT EA 60.000 30.000 527.450 15,823.50 7493 ADJ EST QUANTITY TO DATE 35.000 7493 SPLICE FIBER (SINGLE MODE) EA 10.000 5.000 642.450 3,212.25 7493 ADJ EST QUANTITY TO DATE 5.000 7493 SPLICE FIBER (MULTI MODE) EA 2.000 2.000 642.450 1,284.90 7493 ADJ EST QUANTITY TO DATE 2.000 7494 PREVENTIVE MAINTENANCE EA 180.000 247.000 263.720 65,138.84 7494* ADJ EST QUANTITY TO DATE 210.000 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 07493* REPLC SIGNAL CABLE (3 CONDR) LF 2,000.000 218.000 1.930 420.74 7493* ADJ EST QUANTITY TO DATE 250.000 7494* REPLC LED SIGNAL LAMP (RED) EA 175.000 260.000 49.850 12,961.00 7494* ADJ EST QUANTITY TO DATE 260.000 9001* REMOVE/REPLACE HUB CABINET(INSTALL) EA 1.000 1.000 3,750.640 3,750.64 9001* ADJ EST QUANTITY TO DATE 1.000 9002* SPREAD SPECTRUM RADIO EA 4.000 4.000 1,515.000 6,060.00 9003* ETHERNET MEDIA CONVERTER EA 54.000 54.000 1,200.000 64,800.00 0 SUBTOTAL BID ITEMS $ 1,446,433.56 0 CONTRACT TOTAL ALL ITEMS $ 1,446,433.56 1MIS.CIS.05 CONSTR ESTIMATE DISTRIBUTION CONTRACT 9094005 MGR.NO. 770 PAGE 001 CONT 6197 SEC 60 JOB 001 RES ENGR WEBSTER, CHUCK PROJ RMC - 619760001 HWY US0054 13301 GATEWAY WEST EL PAS CNTY EL PASO DIST 24 CONTRACT PRICE $ 1,119,642.84 REPORT DATE 05/17/2012 08.56.36 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 30,2012 TO APR 30,2012 EST NO 031 & SM-FIN 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 ********************************************************************************************************************************** 72 RMC - 619760001 6197-60-001 1,446,433.56 .00 1,446,433.56 .00 .00 1,446,433.56 1,411,031.17 35,402.39 ---------------------------------------------------------------------------------------------------------------------------------- 0********************************** TOTALS ***************************************************************************** TOTAL AMOUNT .00 % DIFFERENCE LESS TOTAL LESS LIQ DIFFERENCE LESS PREV AMOUNT DUE WORK DONE RETAINAGE SPL DEDUCTS DAMAGE PAYMENTS THIS EST ********************************************************************************************************************************** 1,446,433.56 .00 1,446,433.56 .00 .00 1,446,433.56 1,411,031.17 35,402.39 ---------------------------------------------------------------------------------------------------------------------------------- 0INPUT PROOF READ BY- SUPPORTING PAPERS OK ------------------------------ ---------------------------- 0 APPROVED DATE --------------------------------- ----------------- 1MIS.CIS.07 WORK PERFORMED THIS PERIOD CONTRACT 9094005 MGR.NO. 770 PAGE 001 CONT 6197 SEC 60 JOB 001 RES ENGR WEBSTER, CHUCK PROJ RMC - 619760001 HWY US0054 13301 GATEWAY WEST EL PAS CNTY EL PASO DIST 24 CONTRACT PRICE $ 1,119,642.84 REPORT DATE 05/17/2012 08.56.38 CONTRACTOR HIGHWAY INTELLIGENT TRAFFIC EST PERIOD APR 30,2012 TO APR 30,2012 EST NO 031 & SM-FIN SYSTEMS, CORP. 13538 ********************************************************************************************************************* - CONTROL PROJECT DISTRICT HIGHWAY COUNTY 6197-60-001 RMC - 619760001 24 US0054 EL PASO -LIMITS - NEW MEXICO STATE LINE EL PASO DISTRICT LINE LINE ITEM ESTIMATED WORK DONE CONTRACT AMOUNT NO. NO. DESCRIPTION UNIT QUANTITIES THIS ESTIMATE PRICE($) ($) 0 65 0502 BARR, SIGNS & TRAF HANDLE HR 280.000 25.000 299.750 7,493.75 (MOBILE OP) 125 7493 REPLC INTERCONNECT/COM CABLE LF 100.000 526.000 4.080 2,146.08 (12 PAIR) 190 7493 REPLC CCTV CAMERA (INCLD PAN EA 24.000 1.000 527.450 527.45 UNIT&LENS) 270 7493 TROUBLESHOOT VIDEO SWITCHER HR 2.000 6.000 131.860 791.16 UNIT 275 7493 TRBSHT DYNAMIC MESS SIGN HR 30.000 1.000 131.860 131.86 CONTROLLER 365 7493 TRBSHT LANE CONTROL SIGNAL HR 10.000 2.000 131.860 263.72 (FRWY) 480 7493 CLEAN CCTV CAMERA EA 400.000 86.000 263.720 22,679.92 500 7494 PREVENTIVE MAINTENANCE EA 180.000 5.000 263.720 1,318.60 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 0 615 7494* REPLC LED SIGNAL LAMP (RED) EA 0.000 1.000 49.850 49.85 0 * ITEMS ADDED IN ACCORDANCE WITH STANDARD SPECIFICATIONS OR BY SUPPLEMENTAL AGREEMENTS 0 --------------- - TOTAL BID ITEMS DONE THIS ESTIMATE - $ 35,402.39 0 TOTAL AMOUNT WORK DONE TO DATE - $ 1,446,433.56