Contract ID: | 120011 | Estimate Number: | 0008 | 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/01/2013 TO 01/15/2013 |
Date Awarded: | 03/05/2012 | Date Work Began: | 07/20/2012 | Original Contract Time: | 60 |
Date Contract Executed: | 03/20/2012 | Date Time Stopped: | Current Time Charged: | 167.00 | |
Date NTP Issued: | 03/21/2012 | Completion Date: | Current Time Allowed: | 60.00 | |
General Liability Expires: | 03/01/2013 | Workman's Comp Expires: | 03/01/2013 | Percent Time Used: | 278.33 % |
Specification Year: | 2009 | Date Approved: | 01/18/2013 | ||
Current Contract Amount: | $1,083,917.00 | Total to Date | Prev to Date | This Estimate | |||
Bid Amount: | $1,083,917.00 | Participating: | $1,001,153.50 | $858,737.40 | $142,416.10 | ||
Percent Complete: | 94.98 % | Non Participating: | $0.00 | $0.00 | $0.00 | ||
Funds Available: | $54,440.58 | Total Earnings: | $1,001,153.50 | $858,737.40 | $142,416.10 | ||
Unearned Balance: | $54,440.58 | Stockpiled Materials: | $108,572.92 | $161,173.20 | $-52,600.28 | ||
Gross Earnings: | $1,109,726.42 | $1,019,910.60 | $89,815.82 | ||||
Other Adjustments: | $0.00 | $0.00 | $0.00 | ||||
Liq Dam/Disincentive: | $-80,250.00 | $-70,500.00 | $-9,750.00 | ||||
TOTAL: | $1,029,476.42 | $949,410.60 | $80,065.82 |
Contract ID: | 120011 | Estimate Number: | 0008 | Primary JP: | 27795(04) | |||
CHANGE ORDER HISTORY | |||||
Change Order Nbr. | Change Order Description | Status | Approval Date | Contract Time Adjustment | Total Change Order Amount |
No change orders have been created for this contract. |
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 Initial Payment | 0002 | $10,195.98 |
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 | 0007 | $-104.04 |
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 Adjustment | 0005 | $-4,057.55 |
27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Initial Payment | 0002 | $39,764.30 |
27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0006 | $-11,362.39 |
27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0008 | $-811.60 |
27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0007 | $-405.80 |
27795(04) | 0008 | STRESS CRETE ANCHOR BOLTS | Stockpiled Material Adjustment | 0005 | $-15,826.19 |
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 | 0006 | $-3,791.42 |
27795(04) | 0008 | STRESSCRETE KCT2-31-BP-E40-AG | Stockpiled Material Adjustment | 0005 | $-5,280.90 |
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 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 | 0008 | $-47.39 |
27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Adjustment | 0007 | $-23.70 |
27795(04) | 0008 | STRESSCRETE KA36-T-2-12 | Stockpiled Material Initial Payment | 0002 | $4,810.47 |
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 BANNER ARMS | Stockpiled Material Adjustment | 0008 | $-575.48 |
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 KA36-T-1-12 | Stockpiled Material Adjustment | 0006 | $-6,729.84 |
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 | 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 Initial Payment | 0002 | $14,408.81 |
27795(04) | 0009 | Double Mast Arm | Stockpiled Material Adjustment | 0007 | $-14,408.81 |
27795(04) | 0010 | HOLOPHANE LEDG120354KAHKL3 | Stockpiled Material Adjustment | 0008 | $-42,775.00 |
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 LEDG120354KASKL3R | Stockpiled Material Adjustment | 0007 | $-5,117.00 |
27795(04) | 0010 | HOLOPHANE LEDG120354KASKL3R | Stockpiled Material Adjustment | 0005 | $-8,041.00 |
27795(04) | 0010 | HOLOPHANE LEDG120354KASKL3R | Stockpiled Material Initial Payment | 0002 | $13,158.00 |
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 Initial Payment | 0002 | $3,642.75 |
27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0008 | $-3,642.75 |
27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Adjustment | 0008 | $-1,262.82 |
27795(04) | 0013 | ELEC WIRE-BHL | Stockpiled Material Initial Payment | 0002 | $1,262.82 | Subtotals For Stockpile Payments | $108,572.92 |
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 | Subtotals For Liquidated Damages | $-80,250.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: | 0008 | 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,600.000 | 7,648.000 | $12.50 | $0.00 | $95,600.00 | |
0002 | 1 1/2" PVC SCH.40 PLASTIC CONDUIT TRENCHED | 802(B) 8338 | LF | 2,800.000 | 2,800.000 | 2,018.000 | $3.00 | $0.00 | $6,054.00 | |
0003 | 2" PVC SCH.40 PLASTIC CONDUIT BORED | 802(B) 8340 | LF | 9,050.000 | 9,050.000 | 7,804.000 | $13.00 | $0.00 | $101,452.00 | |
0004 | 2" PVC SCH.40 PLASTIC CONDUIT TRENCHED | 802(B) 8342 | LF | 2,800.000 | 2,800.000 | 2,018.000 | $3.50 | $0.00 | $7,063.00 | |
0005 | PULL BOX(SIZE I) | 803(A) 8065 | EA | 91.000 | 91.000 | 47.000 | 91.000 | $250.00 | $11,750.00 | $22,750.00 |
0006 | STRUCTURAL CONCRETE | 804(A) 2915 | CY | 54.600 | 54.600 | 4.900 | 54.600 | $500.00 | $2,450.00 | $27,300.00 |
0007 | REINFORCING STEEL | 804(B) 2916 | LB | 3,120.000 | 3,120.000 | 3,003.000 | 3,080.000 | $1.20 | $3,603.60 | $3,696.00 |
0008 | DECORATIVE POLE AND MAST ARM | 806(E) 0200 | EA | 71.000 | 71.000 | 2.000 | 70.000 | $6,901.00 | $13,802.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 | 103.000 | 75.000 | 101.000 | $1,000.00 | $75,000.00 | $101,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 | 34,100.000 | 0.000 | 19,592.000 | $1.75 | $0.00 | $34,286.00 |
0013 | 1/C NO.6 ELECTRICAL CONDUCTOR | 811 8040 | LF | 45,900.000 | 45,900.000 | 32,555.000 | 32,555.000 | $1.10 | $35,810.50 | $35,810.50 |
0014 | CONSTRUCTION TRAFFIC CONTROL | 880(J) 8905 | LSUM | 1.000 | 1.000 | 0.560 | $1,000.00 | $0.00 | $560.00 | |
Subtotals For Category 0300/TRAFFIC | $142,416.10 | $999,778.50 | ||||||||
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.750 | $500.00 | $0.00 | $375.00 | |
Subtotals For Category 0600/STAKING | $0.00 | $375.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 | ||||||||
Subtotals For Project STPG-114B(278)AG /27795(04) | $142,416.10 | $1,001,153.50 |