Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    12/19/2012
Contract ID: 120011   Estimate Number: 0006     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: 12/01/2012  TO  12/15/2012
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: 141.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: 235.00 %
Specification Year: 2009     Date Approved: 12/19/2012

Current Contract Amount: $1,083,917.00 Total to Date Prev to Date This Estimate
Bid Amount: $1,083,917.00 Participating: $742,412.00 $517,340.50 $225,071.50
Percent Complete: 80.81 % Non Participating: $0.00 $0.00 $0.00
Funds Available: $207,975.95 Total Earnings: $742,412.00 $517,340.50 $225,071.50
Unearned Balance: $207,975.95 Stockpiled Materials: $194,279.05 $230,206.43 $-35,927.38
Gross Earnings: $936,691.05 $747,546.93 $189,144.12
Other Adjustments: $0.00 $0.00 $0.00
Liq Dam/Disincentive: $-60,750.00 $-49,500.00 $-11,250.00
TOTAL: $875,941.05 $698,046.93 $177,894.12

Estimate Adjustment Detail

Contract ID: 120011   Estimate Number: 0006     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 Initial Payment 0002 $22,642.41
27795(04) 0008 SINGLE MAST ARM Stockpiled Material Adjustment 0005 $-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 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 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 Adjustment 0005 $-15,826.19
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 0006 $-3,791.42
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 0005 $-924.11
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 0005 $-11,221.91
27795(04) 0008 STRESSCRETE BANNER ARMS Stockpiled Material Initial Payment 0002 $58,412.79
27795(04) 0008 STRESSCRETE BANNER ARMS Stockpiled Material Adjustment 0006 $-8,056.76
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 Adjustment 0005 $-9,373.71
27795(04) 0009 Double Mast Arm Stockpiled Material Initial Payment 0002 $14,408.81
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 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 Initial Payment 0002 $6,820.00
27795(04) 0012 ELEC WIRE-BHL Stockpiled Material Adjustment 0006 $-2,410.40
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 Initial Payment 0002 $1,262.82
Subtotals For Stockpile Payments $194,279.05


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
Subtotals For Liquidated Damages $-60,750.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 $

Line Item Detail

Contract ID: 120011   Estimate Number: 0006     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 885.000 2,018.000 $3.00 $2,655.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 885.000 2,018.000 $3.50 $3,097.50 $7,063.00
0005 PULL BOX(SIZE I) 803(A) 8065 EA 91.000 91.000 20.000 44.000 $250.00 $5,000.00 $11,000.00
0006 STRUCTURAL CONCRETE 804(A) 2915 CY 54.600 54.600   49.700 $500.00 $0.00 $24,850.00
0007 REINFORCING STEEL 804(B) 2916 LB 3,120.000 3,120.000   0.000 $1.20 $0.00 $0.00
0008 DECORATIVE POLE AND MAST ARM 806(E) 0200 EA 71.000 71.000 28.000 67.000 $6,901.00 $193,228.00 $462,367.00
0009 DECORATIVE POLE AND TWIN MAST ARM 806(E) 0210 EA 7.000 7.000   0.000 $8,591.00 $0.00 $0.00
0010 ROADWAY LUMINAIRE 809(A) 8090 EA 103.000 103.000   11.000 $1,000.00 $0.00 $11,000.00
0011 SERVICE POLE 810(A) 3118 EA 6.000 6.000   0.000 $3,500.00 $0.00 $0.00
0012 1/C NO.4 ELECTRICAL CONDUCTOR 811 8038 LF 34,100.000 34,100.000 12,052.000 12,052.000 $1.75 $21,091.00 $21,091.00
0013 1/C NO.6 ELECTRICAL CONDUCTOR 811 8040 LF 45,900.000 45,900.000   0.000 $1.10 $0.00 $0.00
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    $225,071.50 $741,037.00
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) $225,071.50 $742,412.00