| Contract ID: | 090678 | Estimate Number: | 0007 | Contract No: | 510725 | |||
| Residency: | CLAREMORE (08300) | Estimate Type: | Progressive | Account No: | 400800 | |||
| Project Number(s): | STP-STIM(272)IG | ||||||||||||
| Primary Job Piece No: | 26692(04) | ||||||||||||
| Contract Description: | TRAFFIC SIGNALS AND STRIPING CITY STREET (CHEROKEE STREET): AT THE SOUTH SCHOOL ENTRANCE ROAD IN THE CITY OF CATOOSA. | ||||||||||||
| Primary County: | ROGERS | ||||||||||||
| Name of Road: | CITY STREET | ||||||||||||
| Prime Contractor: | MIDSTATE TRAFFIC CONTROL, INC. | ||||||||||||
| 12501 N. SANTA FE AVE. | |||||||||||||
| OKLAHOMA CITY , OK 73114 | |||||||||||||
| Surety Company: | LIBERTY MUTUAL INSURANCE COMPANY | ||||||||||||
| Date Let: | 11/19/2009 | NTP Effective Date: | 04/12/2010 | Pay Period: | 09/01/2010 TO 02/28/2011 |
| Date Awarded: | 12/07/2009 | Date Work Began: | 04/21/2010 | Original Contract Time: | 120 |
| Date Contract Executed: | 12/21/2009 | Date Time Stopped: | 12/09/2010 | Current Time Charged: | 242.00 |
| Date NTP Issued: | 01/12/2010 | Completion Date: | 12/09/2010 | Current Time Allowed: | 257.00 |
| General Liability Expires: | 03/01/2011 | Workman's Comp Expires: | 03/01/2011 | Percent Time Used: | 94.16 % |
| Specification Year: | 1999 | Date Approved: | |||
| Current Contract Amount: | $155,571.50 | Total to Date | Prev to Date | This Estimate | |||
| Bid Amount: | $154,755.50 | Participating: | $145,420.56 | $143,379.25 | $2,041.31 | ||
| Percent Complete: | 93.37 % | Non Participating: | $0.00 | $0.00 | $0.00 | ||
| Funds Available: | $10,321.24 | Non ARRA: | $550.00 | $0.00 | $550.00 | ||
| Unearned Balance: | $9,505.24 | Total Earnings: | $145,970.56 | $143,379.25 | $2,591.31 | ||
| Stockpiled Materials: | $0.00 | $0.00 | $0.00 | ||||
| Gross Earnings: | $145,970.56 | $143,379.25 | $2,591.31 | ||||
| Other Adjustments: | $-720.30 | $-4,725.30 | $4,005.00 | ||||
| Liq Dam/Disincentive: | $0.00 | $0.00 | $0.00 | ||||
| TOTAL: | $145,250.26 | $138,653.95 | $6,596.31 | ||||
| Contract ID: | 090678 | Estimate Number: | 0007 | Primary JP: | 26692(04) | |||
| CHANGE ORDER HISTORY | |||||
| Change Order Nbr. | Change Order Description | Status | Approval Date | Contract Time Adjustment | Total Change Order Amount |
| 001 | Supplemental agreement adjusting work order date. | Approved | 03/31/2010 | 0.0 | $0.00 |
| 002 | Supplemental agreement adding pedestrian pole. | Approved | 09/29/2010 | 0.0 | $816.00 |
| STOCKPILE PAYMENT HISTORY | |||||
| Project | Line Nbr | Stockpile Description | Adjustment Type | Estimate Nbr | Adjusted Amount |
| No material stockpiles have been created for this contract. | Subtotals For Stockpile Payments | $0.00 | |||
| LIQUIDATED DAMAGES HISTORY | |||||||||
| Adjustment Description | Estimate Nbr | Time Units | Rate | Adjustment Amount | |||||
| No liquidated damages have been assessed on this contract. | |||||||||
| CONTRACT ADJUSTMENTS HISTORY | ||
| Adjustment Description | Estimate Nbr | Adjustment Amount |
| No general contract adjustments have been created on this contract. | Subtotals For Contract Adjustments | $0.00 |
| LINE ITEM ADJUSTMENT HISTORY | |||||||
| Project | Item Nbr | Line Item Description | Adjustment Type | Estimate Nbr | Adj Quantity | Unit Price | Adjusted Amount |
| 26692(04) | 0003 | SOLID SLAB SODDING | * Material Discrepancy Adjustments | 0003 | -140.00 | $8.00 | $-1,120.00 |
| 26692(04) | 0009 | (SP)ASPHALT CONCRETE TYPE S3(PG 64-22 OK) | Asphalt Binder Adjustment | 0002 | 0.00 | $0.00 | $195.89 |
| 26692(04) | 0010 | (SP)ASPHALT CONCRETE TYPE S4(PG 64-22 OK) | Asphalt Binder Adjustment | 0002 | 0.00 | $0.00 | $203.81 |
| 26692(04) | 0049 | (PL)E.P.S. 2 CHANNEL PHASE SELECTOR | * Material Discrepancy Adjustments | 0005 | -1.00 | $1,850.00 | $-1,850.00 |
| 26692(04) | 0049 | (PL)E.P.S. 2 CHANNEL PHASE SELECTOR | * Material Discrepancy Adjustments | 0006 | 1.00 | $1,850.00 | $1,850.00 |
| 26692(04) | 0050 | MAST ARM MOUNTED SIGNS(ALUMINUM) | * Material Discrepancy Adjustments | 0003 | -89.00 | $45.00 | $-4,005.00 |
| 26692(04) | 0050 | MAST ARM MOUNTED SIGNS(ALUMINUM) | * Material Discrepancy Adjustments | 0007 | 89.00 | $45.00 | $4,005.00 | Subtotals For Line Item Adjustments | $-720.30 | * = User applied Line Item Adjustments |
| MILESTONE ADJUSTMENTS | |||||||||
| Milestone Number | Milestone Description | Time Allowed | Time Used | Rate | Total | ||||
| No milestones exist for this contract. | |||||||||
| Contract ID: | 090678 | Estimate Number: | 0007 | Primary JP: | 26692(04) | |||
| Line Item Number | Item Description | Item Number | Units | Bid Qty | Current Quantity | Quantity Paid This Est. | Quantity Paid To Date | Unit Price | Amount Paid This Est. | Amount Paid To Date |
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0100/STP-STIM(272)IG - ROADWAY | ||||||||
| 0001 | UNCLASSIFIED EXCAVATION | 202(A) 0183 | CY | 150.000 | 150.000 | 0.740 | 102.430 | $10.00 | $7.40 | $1,024.30 |
| 0002 | TYPE A-SALVAGED TOPSOIL | 205 4229 | LSUM | 1.000 | 1.000 | 1.000 | $1,500.00 | $0.00 | $1,500.00 | |
| 0003 | SOLID SLAB SODDING | 230(A) 2806 | SY | 100.000 | 100.000 | 0.000 | 140.000 | $8.00 | $0.00 | $1,120.00 |
| 0004 | AGGREGATE BASE | 303 0192 | CY | 60.000 | 65.320 | 60.000 | $50.00 | $0.00 | $3,000.00 | |
| 0005 | SEPARATOR FABRIC | 325 5271 | SY | 225.000 | 225.000 | 0.000 | $5.50 | $0.00 | $0.00 | |
| 0006 | (SP)MODIFIED SUBGRADE | 327(J) 4290 | SY | 225.000 | 225.000 | 0.000 | $8.00 | $0.00 | $0.00 | |
| 0007 | TACK COAT | 407 0250 | GAL | 40.000 | 40.000 | 0.000 | 6.000 | $5.00 | $0.00 | $30.00 |
| 0008 | PRIME COAT | 408 5774 | GAL | 50.000 | 50.000 | 0.000 | $5.00 | $0.00 | $0.00 | |
| 0009 | (SP)ASPHALT CONCRETE TYPE S3(PG 64-22 OK) | 411(S3) 5945 | TON | 70.000 | 70.000 | 49.870 | $110.00 | $0.00 | $5,485.70 | |
| 0010 | (SP)ASPHALT CONCRETE TYPE S4(PG 64-22 OK) | 411(S4) 5960 | TON | 30.000 | 30.000 | 45.400 | $132.00 | $0.00 | $5,992.80 | |
| 0011 | 4" CONCRETE SIDEWALK | 610(A) 0602 | SY | 5.000 | 5.000 | 0.000 | $99.00 | $0.00 | $0.00 | |
| 0012 | 18" R.C.PIPE CLASS III | 613(B) 0491 | LF | 55.000 | 55.000 | 55.000 | $66.00 | $0.00 | $3,630.00 | |
| 0013 | 18" PREFAB. CULVERT END SECTION, ROUND | 613(M) 5726 | EA | 1.000 | 1.000 | 1.000 | $1,000.00 | $0.00 | $1,000.00 | |
| 0014 | TRENCH EXCAVATION | 613(S) 1180 | CY | 50.000 | 50.000 | 32.290 | $55.00 | $0.00 | $1,775.95 | |
| 0015 | STANDARD BEDDING MATERIAL | 613(T) 1181 | CY | 40.000 | 40.000 | 15.070 | $44.00 | $0.00 | $663.08 | |
| 0016 | REMOVAL OF STRUCTURES & OBSTRUCTIONS | 619(A) 0920 | LSUM | 1.000 | 1.000 | 1.000 | $1,500.00 | $0.00 | $1,500.00 | |
| 0017 | SAWING PAVEMENT | 619(C) 0924 | LF | 150.000 | 150.000 | 38.000 | $5.00 | $0.00 | $190.00 | |
| Subtotals For Category 0100/STP-STIM(272)IG - ROADWAY | $7.40 | $26,911.83 | ||||||||
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0300/STP-STIM(272)IG - TRAFFIC | ||||||||
| 0018 | TRAFFIC STRIPE(PLASTIC)(4" WIDE) | 855(A) 8812 | LF | 6,200.000 | 6,200.000 | -229.000 | 6,063.000 | $0.50 | $-114.50 | $3,031.50 |
| 0019 | TRAFFIC STRIPE(PLASTIC)(ARROWS) | 855(B) 8818 | EA | 6.000 | 6.000 | 8.000 | $90.00 | $0.00 | $720.00 | |
| 0020 | CONSTRUCTION TRAFFIC CONTROL | 880(J) 8905 | LSUM | 1.000 | 1.000 | 1.000 | $2,500.00 | $0.00 | $2,500.00 | |
| Subtotals For Category 0300/STP-STIM(272)IG - TRAFFIC | $-114.50 | $6,251.50 | ||||||||
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0301/STP-STIM(272)IG - TRAFFIC SIGNALS | ||||||||
| 0021 | 3" PVC SCH.40 PLASTIC CONDUIT BORED | 802(B) 8344 | LF | 200.000 | 200.000 | 173.000 | $22.00 | $0.00 | $3,806.00 | |
| 0022 | 3" PVC SCH.40 PLASTIC CONDUIT TRENCHED | 802(B) 8346 | LF | 200.000 | 200.000 | 38.000 | 237.000 | $10.00 | $380.00 | $2,370.00 |
| 0023 | PULL BOX(SIZE II) | 803 8066 | EA | 3.000 | 3.000 | 3.000 | $580.00 | $0.00 | $1,740.00 | |
| 0024 | PULL BOX(SIZE III) | 803 8067 | EA | 1.000 | 1.000 | 1.000 | $835.00 | $0.00 | $835.00 | |
| 0025 | STRUCTURAL CONCRETE | 804(A) 2915 | CY | 10.000 | 10.000 | 0.040 | 8.360 | $400.00 | $16.00 | $3,344.00 |
| 0026 | REINFORCING STEEL | 804(B) 2916 | LB | 1,200.000 | 1,200.000 | 983.040 | 1,275.110 | $1.00 | $983.04 | $1,275.11 |
| 0027 | 32'MH POLE 25'TS & 8'LMA(G.STL.) | 806(A) 8286 | EA | 1.000 | 1.000 | 1.000 | $3,414.00 | $0.00 | $3,414.00 | |
| 0028 | 32'MH POLE 35'TS & 8'LMA(G.STL.) | 806(A) 8307 | EA | 2.000 | 2.000 | 2.000 | $4,650.00 | $0.00 | $9,300.00 | |
| 0029 | 32'MH POLE 45'TS & 8'LMA(G.STL.) | 806(A) 8309 | EA | 1.000 | 1.000 | 1.000 | $6,650.00 | $0.00 | $6,650.00 | |
| 0030 | (PL)ROADWAY LUMINAIRE | 809(A) 8090 | EA | 4.000 | 4.000 | 1.000 | $300.00 | $0.00 | $300.00 | |
| 0031 | SERVICE POLE | 810(A) 3118 | EA | 1.000 | 1.000 | 1.000 | $200.00 | $0.00 | $200.00 | |
| 0032 | 1/C NO.6 ELECTRICAL CONDUCTOR | 811 8040 | LF | 500.000 | 500.000 | 36.000 | 376.000 | $0.75 | $27.00 | $282.00 |
| 0033 | 1/C NO.8 ELECTRICAL CONDUCTOR | 811 8042 | LF | 200.000 | 200.000 | -301.500 | 58.500 | $0.75 | $-226.13 | $43.87 |
| 0034 | 1/C NO.10 ELECTRICAL CONDUCTOR | 811 8044 | LF | 350.000 | 350.000 | 153.000 | 153.000 | $0.60 | $91.80 | $91.80 |
| 0035 | 1/C NO.12 ELECTRICAL CONDUCTOR | 811 8046 | LF | 625.000 | 625.000 | -27.500 | 376.500 | $0.40 | $-11.00 | $150.60 |
| 0036 | VEH.ACT.SOL.ST.TRAF.SIG.CON.ASM | 825 8550 | EA | 1.000 | 1.000 | 1.000 | $17,880.00 | $0.00 | $17,880.00 | |
| 0037 | (PL)DETECTION SYSTEM (VIDEO) | 828 8132 | LSUM | 1.000 | 1.000 | 1.000 | $31,700.00 | $0.00 | $31,700.00 | |
| 0038 | PEDESTRIAN PUSH BUTTON | 830 8000 | EA | 6.000 | 6.000 | 2.000 | 6.000 | $200.00 | $400.00 | $1,200.00 |
| 0039 | 1WAY 3SEC. ADJ. SIG. HD. S-6 | 831 8231 | EA | 3.000 | 3.000 | 3.000 | $625.00 | $0.00 | $1,875.00 | |
| 0040 | 1WAY 3SEC. ADJ. SIG. HD. S-10 | 831 8262 | EA | 1.000 | 1.000 | 1.000 | 1.000 | $610.00 | $610.00 | $610.00 |
| 0041 | 1WAY 5SEC. ADJ. SIG. HD. S-19 | 831 8286 | EA | 4.000 | 4.000 | 4.000 | $1,016.00 | $0.00 | $4,064.00 | |
| 0042 | 1WAY 2SEC. ADJ. PED. SIG. HD. S-20 | 831 8295 | EA | 6.000 | 6.000 | 6.000 | $900.00 | $0.00 | $5,400.00 | |
| 0043 | 5/C TRAF.SIG.ELECT.CABLE | 834(A) 8207 | LF | 600.000 | 600.000 | 15.000 | 248.000 | $1.00 | $15.00 | $248.00 |
| 0044 | 7/C TRAF.SIG.ELECT.CABLE | 834(A) 8208 | LF | 600.000 | 600.000 | -21.000 | 202.500 | $1.10 | $-23.10 | $222.75 |
| 0045 | 21/C TRAF.SIG.EL.CABLE | 834(A) 8213 | LF | 600.000 | 600.000 | 1.000 | 376.000 | $2.00 | $2.00 | $752.00 |
| 0046 | 2/C SHIELDED LOOP DETECTOR LEAD-IN CABLE | 834(B) 8220 | LF | 600.000 | 600.000 | -66.000 | 303.000 | $0.70 | $-46.20 | $212.10 |
| 0047 | (PL)E.P.S. OPTICAL DETECTOR | 840(B) 8593 | EA | 2.000 | 2.000 | 2.000 | $675.00 | $0.00 | $1,350.00 | |
| 0048 | (PL)E.P.S. OPTICAL DETECTOR CABLE | 840(C) 8594 | LF | 350.000 | 350.000 | -70.000 | 86.000 | $1.00 | $-70.00 | $86.00 |
| 0049 | (PL)E.P.S. 2 CHANNEL PHASE SELECTOR | 840(D) 8595 | EA | 1.000 | 1.000 | 1.000 | $1,850.00 | $0.00 | $1,850.00 | |
| 0050 | MAST ARM MOUNTED SIGNS(ALUMINUM) | 850(C) 8118 | SF | 60.000 | 60.000 | 0.000 | 89.000 | $45.00 | $0.00 | $4,005.00 |
| Subtotals For Category 0301/STP-STIM(272)IG - TRAFFIC SIGNALS | $2,148.41 | $105,257.23 | ||||||||
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0600/STP-STIM(272)IG - STAKING | ||||||||
| 0051 | STAKING | 642 0098 | LSUM | 1.000 | 1.000 | 1.000 | $2,500.00 | $0.00 | $2,500.00 | |
| Subtotals For Category 0600/STP-STIM(272)IG - STAKING | $0.00 | $2,500.00 | ||||||||
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0640/STP-STIM(272)IG - CONSTRUCTION | ||||||||
| 0052 | MOBILIZATION | 641 1552 | LSUM | 1.000 | 1.000 | 1.000 | $4,500.00 | $0.00 | $4,500.00 | |
| Subtotals For Category 0640/STP-STIM(272)IG - CONSTRUCTION | $0.00 | $4,500.00 | ||||||||
| Fed/State Project Number: STP-STIM(272)IG | Project: 26692(04) | Category: 0850/NON ARRA FUNDING | ||||||||
| 8000 | 12' MTG.HT.TS PED.POLE(G.STL.) | 806(B) 8896 | EA | 0.000 | 1.000 | 1.000 | 1.000 | $550.00 | $550.00 | $550.00 |
| Subtotals For Category 0850/NON ARRA FUNDING | $550.00 | $550.00 | ||||||||
| Subtotals For Project STP-STIM(272)IG /26692(04) | $2,591.31 | $145,970.56 | ||||||||