| Contract ID: | 120011 | Estimate Number: | 0009 | Contract No: | 710959 | |||
| Residency: | ATKINS NORTH AMERICA, INC. (AKA PBS & J) (03010) | Estimate Type: | Progressive | Account No: | 400350 | |||
| Project Number(s): | STPG-114B(278)AG | ||||||||||||
| Primary Job Piece No: | 27795(04) | ||||||||||||
| Contract Description: | LIGHTING CITY STREET: ON MAIN STREET, FROM MERKLE DRIVE, EXTEND WEST IN THE CITY OF NORMAN. PROJECT LENGTH = 1.46 MILES. | ||||||||||||
| Primary County: | CLEVELAND | ||||||||||||
| 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: | 02/16/2012 | NTP Effective Date: | 07/19/2012 | Pay Period: | 01/16/2013 TO 08/15/2015 |
| Date Awarded: | 03/05/2012 | Date Work Began: | 07/20/2012 | Original Contract Time: | 60 |
| Date Contract Executed: | 03/20/2012 | Date Time Stopped: | 07/06/2015 | Current Time Charged: | 208.00 |
| Date NTP Issued: | 03/21/2012 | Completion Date: | 07/06/2015 | Current Time Allowed: | 222.00 |
| General Liability Expires: | 03/01/2016 | Workman's Comp Expires: | 03/01/2016 | Percent Time Used: | 93.69 % |
| Specification Year: | 2009 | Date Approved: | 08/18/2015 | ||
| Bid Amount: | $1,083,917.00 | Total to Date | Prev to Date | This Estimate | |||
| Funds Available (Bid + Positive C/O): | $1,160,180.25 | Participating: | $1,076,545.54 | $1,001,153.50 | $75,392.04 | ||
| Percent Complete: | 96.45 % | Non Participating: | $42,491.98 | $0.00 | $42,491.98 | ||
| Unearned Balance: | $41,142.73 | Total Earnings: | $1,119,037.52 | $1,001,153.50 | $117,884.02 | ||
| Stockpiled Materials: | $0.00 | $108,572.92 | $-108,572.92 | ||||
| Gross Earnings: | $1,119,037.52 | $1,109,726.42 | $9,311.10 | ||||
| Other Adjustments: | $0.00 | $0.00 | $0.00 | ||||
| Liq Dam/Disincentive: | $0.00 | $-80,250.00 | $80,250.00 | ||||
| TOTAL: | $1,119,037.52 | $1,029,476.42 | $89,561.10 | ||||
| Contract ID: | 120011 | Estimate Number: | 0009 | Primary JP: | 27795(04) | |||
| CHANGE ORDER HISTORY | |||||
| Change Order Nbr. | Change Order Description | Status | Approval Date | Contract Time Adjustment | Total Change Order Amount |
| 001 | To add multiple new project pay items & utility delay | Approved | 10/06/2014 | 162.0 | $76,263.25 |
| 002 | FQCO | Approved | 06/23/2015 | 0.0 | $-33,644.15 |
| STOCKPILE PAYMENT HISTORY | |||||
| Project | Line Nbr | Stockpile Description | Adjustment Type | Estimate Nbr | Adjusted Amount |
| 27795(04) | 0008 | SINGLE MAST ARM | Stockpiled Material Adjustment | 0005 | $-22,642.41 |
| 27795(04) | 0008 | SINGLE MAST ARM | Stockpiled Material Initial Payment | 0002 | $22,642.41 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0005 | $-4,057.55 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0007 | $-104.04 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0008 | $-208.08 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0006 | $-2,913.11 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Initial Payment | 0002 | $10,195.98 |
| 27795(04) | 0008 | STRESS CRETE KCT2-31-BP-E40-AG | Stockpiled Material Closure | 0009 | $-2,913.20 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0006 | $-11,362.39 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Initial Payment | 0002 | $39,764.30 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Closure | 0009 | $-11,358.32 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0008 | $-811.60 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0005 | $-15,826.19 |
| 27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0007 | $-405.80 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Closure | 0009 | $-18,009.83 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Initial Payment | 0002 | $27,488.38 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0007 | $-135.41 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0006 | $-3,791.42 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0008 | $-270.82 |
| 27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0005 | $-5,280.90 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Adjustment | 0008 | $-47.39 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Closure | 0009 | $-3,151.81 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Initial Payment | 0002 | $4,810.47 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Adjustment | 0005 | $-924.11 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Adjustment | 0006 | $-663.46 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Adjustment | 0007 | $-23.70 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Adjustment | 0008 | $-575.48 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Closure | 0009 | $-38,270.90 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Adjustment | 0005 | $-11,221.91 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Adjustment | 0007 | $-287.74 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Adjustment | 0006 | $-8,056.76 |
| 27795(04) | 0008 | STRESSCRETE BANNER ARMS | Stockpiled Material Initial Payment | 0002 | $58,412.79 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Adjustment | 0005 | $-9,373.71 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Initial Payment | 0002 | $48,791.86 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Adjustment | 0006 | $-6,729.84 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Closure | 0009 | $-31,967.26 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Adjustment | 0008 | $-480.70 |
| 27795(04) | 0008 | STRESSCRETE KA36-T-1-12 | Stockpiled Material Adjustment | 0007 | $-240.35 |
| 27795(04) | 0009 | Double Mast Arm | Stockpiled Material Adjustment | 0007 | $-14,408.81 |
| 27795(04) | 0009 | Double Mast Arm | Stockpiled Material Initial Payment | 0002 | $14,408.81 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KAHKL3 | Stockpiled Material Adjustment | 0007 | $-10,875.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KAHKL3 | Stockpiled Material Adjustment | 0005 | $-7,975.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KAHKL3 | Stockpiled Material Initial Payment | 0002 | $61,625.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KAHKL3 | Stockpiled Material Adjustment | 0008 | $-42,775.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KASKL3R | Stockpiled Material Initial Payment | 0002 | $13,158.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KASKL3R | Stockpiled Material Adjustment | 0007 | $-5,117.00 |
| 27795(04) | 0010 | HOLOPHANE LEDG120354KASKL3R | Stockpiled Material Adjustment | 0005 | $-8,041.00 |
| 27795(04) | 0012 | ELEC WIRE-BHL | Stockpiled Material Closure | 0009 | $-2,901.60 |
| 27795(04) | 0012 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0006 | $-2,410.40 |
| 27795(04) | 0012 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0007 | $-1,508.00 |
| 27795(04) | 0012 | ELEC WIRE-BHL | Stockpiled Material Initial Payment | 0002 | $6,820.00 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0008 | $-2,525.64 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Initial Payment | 0002 | $2,525.64 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0008 | $-3,642.75 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Initial Payment | 0002 | $3,642.75 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Initial Payment | 0002 | $1,262.82 |
| 27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0008 | $-1,262.82 | Subtotals For Stockpile Payments | $0.00 |
| LIQUIDATED DAMAGES HISTORY | ||||
| Adjustment Description | Estimate Nbr | Time Units | Rate | Adjustment Amount |
| System Application of Liquidated Damages | 0003 | --8.0 | $750.00 | $-6,000.00 |
| System Application of Liquidated Damages | 0004 | --30 | $750.00 | $-22,500.00 |
| System Application of Liquidated Damages | 0005 | --28 | $750.00 | $-21,000.00 |
| System Application of Liquidated Damages | 0006 | --15 | $750.00 | $-11,250.00 |
| System Application of Liquidated Damages | 0007 | --13 | $750.00 | $-9,750.00 |
| System Application of Liquidated Damages | 0008 | --13 | $750.00 | $-9,750.00 |
| System Application of Liquidated Damages | 0009 | -107 | $750.00 | $80,250.00 | Subtotals For Liquidated Damages | $0.00 |
| 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 |
| No line item adjustments have been created on this contract. | Subtotals For Line Item Adjustments | $0.00 | |||||
| MILESTONE INFORMATION | |||||||||
| Milestone Number | Milestone Description | Start Date | End Date | Current Time Allowed | Rate | Milestone Closed | |||
| No milestones exist for this contract. | |||||||||
| MILESTONE ADJUSTMENTS | |||||||||
| Milestone Number | Milestone Adjustment Description | Estimate Nbr | Total | ||||||
| No milestones adjustments exist for this contract. | Subtotals For Milestones | $ | |||||||
| Contract ID: | 120011 | Estimate Number: | 0009 | Primary JP: | 27795(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: STPG-114B(278)AG | Project: 27795(04) | Category: 0300/TRAFFIC | ||||||||
| 0001 | 1 1/2" PVC SCH.40 PLASTIC CONDUIT BORED | 802(B) 8336 | LF | 8,600.000 | 8,983.000 | 1,335.000 | 8,983.000 | $12.50 | $16,687.50 | $112,287.50 |
| 0002 | 1 1/2" PVC SCH.40 PLASTIC CONDUIT TRENCHED | 802(B) 8338 | LF | 2,800.000 | 2,258.000 | 240.000 | 2,258.000 | $3.00 | $720.00 | $6,774.00 |
| 0003 | 2" PVC SCH.40 PLASTIC CONDUIT BORED | 802(B) 8340 | LF | 9,050.000 | 9,267.000 | 1,463.000 | 9,267.000 | $13.00 | $19,019.00 | $120,471.00 |
| 0004 | 2" PVC SCH.40 PLASTIC CONDUIT TRENCHED | 802(B) 8342 | LF | 2,800.000 | 2,258.000 | 240.000 | 2,258.000 | $3.50 | $840.00 | $7,903.00 |
| 0005 | PULL BOX(SIZE I) | 803(A) 8065 | EA | 91.000 | 92.000 | 1.000 | 92.000 | $250.00 | $250.00 | $23,000.00 |
| 0006 | STRUCTURAL CONCRETE | 804(A) 2915 | CY | 54.600 | 54.830 | 0.230 | 54.830 | $500.00 | $115.00 | $27,415.00 |
| 0007 | REINFORCING STEEL | 804(B) 2916 | LB | 3,120.000 | 3,131.250 | 51.250 | 3,131.250 | $1.20 | $61.50 | $3,757.50 |
| 0008 | DECORATIVE POLE AND MAST ARM | 806(E) 0200 | EA | 71.000 | 70.000 | 0.000 | 70.000 | $6,901.00 | $0.00 | $483,070.00 |
| 0009 | DECORATIVE POLE AND TWIN MAST ARM | 806(E) 0210 | EA | 7.000 | 7.000 | 7.000 | $8,591.00 | $0.00 | $60,137.00 | |
| 0010 | ROADWAY LUMINAIRE | 809(A) 8090 | EA | 103.000 | 105.000 | 4.000 | 105.000 | $1,000.00 | $4,000.00 | $105,000.00 |
| 0011 | SERVICE POLE | 810(A) 3118 | EA | 6.000 | 6.000 | 6.000 | $3,500.00 | $0.00 | $21,000.00 | |
| 0012 | 1/C NO.4 ELECTRICAL CONDUCTOR | 811 8038 | LF | 34,100.000 | 20,868.000 | 1,276.000 | 20,868.000 | $1.75 | $2,233.00 | $36,519.00 |
| 0013 | 1/C NO.6 ELECTRICAL CONDUCTOR | 811 8040 | LF | 45,900.000 | 36,830.000 | 4,275.000 | 36,830.000 | $1.10 | $4,702.50 | $40,513.00 |
| 0014 | CONSTRUCTION TRAFFIC CONTROL | 880(J) 8905 | LSUM | 1.000 | 1.000 | 0.440 | 1.000 | $1,000.00 | $440.00 | $1,000.00 |
| 8000 | 4" CONCRETE SIDEWALK | 610(A) 0602 | SY | 0.000 | 132.280 | 132.280 | 132.280 | $65.00 | $8,598.20 | $8,598.20 |
| 8001 | 1/C NO.12 ELECT.COND. | 811 8046 | LF | 0.000 | 15,680.000 | 15,680.000 | 15,680.000 | $0.38 | $5,958.40 | $5,958.40 |
| 8002 | REMOVAL OF EXISTING STRUCTURES | 619(B) 4778 | EA | 0.000 | 43.000 | 43.000 | 43.000 | $230.00 | $9,890.00 | $9,890.00 |
| 8006 | CONSTRUCTION MISCELLANEOUS | 104 0700 | LSUM | 0.000 | 1.000 | 1.000 | 1.000 | $1,751.94 | $1,751.94 | $1,751.94 |
| Subtotals For Category 0300/TRAFFIC | $75,267.04 | $1,075,045.54 | ||||||||
| Fed/State Project Number: STPG-114B(278)AG | Project: 27795(04) | Category: 0600/STAKING | ||||||||
| 0015 | CONSTRUCTION STAKING LEVEL I | 642(A) 0095 | LSUM | 1.000 | 1.000 | 0.250 | 1.000 | $500.00 | $125.00 | $500.00 |
| Subtotals For Category 0600/STAKING | $125.00 | $500.00 | ||||||||
| Fed/State Project Number: STPG-114B(278)AG | Project: 27795(04) | Category: 0640/CONSTRUCTION | ||||||||
| 0016 | MOBILIZATION | 641 1552 | LSUM | 1.000 | 1.000 | 1.000 | $1,000.00 | $0.00 | $1,000.00 | |
| Subtotals For Category 0640/CONSTRUCTION | $0.00 | $1,000.00 | ||||||||
| Fed/State Project Number: STPG-114B(278)AG | Project: 27795(04) | Category: 0900/FEDERAL NON PARTICIPATING | ||||||||
| 8003 | NEGOTIATED SETTLEMENT OF CONTR'S CLAIM | 109 1100 | LSUM | 0.000 | 1.000 | 0.850 | 0.850 | $49,990.56 | $42,491.98 | $42,491.98 |
| Subtotals For Category 0900/FEDERAL NON PARTICIPATING | $42,491.98 | $42,491.98 | ||||||||
| Subtotals For Project STPG-114B(278)AG /27795(04) | $117,884.02 | $1,119,037.52 | ||||||||