Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    02/20/2013
Contract ID: 120250   Estimate Number: 0005     Contract No: 810266
Residency: PURCELL (03200)   Estimate Type: Progressive     Account No: 400350

Project Number(s): STPG-114F(303)AG
Primary Job Piece No: 29011(04)
Contract Description: TRAFFIC SIGNALS CITY STREETS: MULTIPLE LOCATIONS IN THE CITY OF NORMAN.
Primary County: CLEVELAND              
Name of Road: CITY STREET              
Prime Contractor: TRAFFIC SIGNALS, INC.              
    P. O. BOX 30067              
    EDMOND , OK   73003-0002              
Surety Company: MID-CONTINENT CASUALTY CO.              

Date Let: 07/19/2012 NTP Effective Date: 11/26/2012 Pay Period: 02/01/2013  TO  02/15/2013
Date Awarded: 08/06/2012 Date Work Began: 12/03/2012 Original Contract Time: 90
Date Contract Executed: 08/21/2012 Date Time Stopped: Current Time Charged: 74.00
Date NTP Issued: 08/24/2012 Completion Date: Current Time Allowed: 90.00
General Liability Expires: 07/01/2013 Workman's Comp Expires: 02/01/2013 Percent Time Used: 82.22 %
Specification Year: 2009     Date Approved:

Current Contract Amount: $367,702.00 Total to Date Prev to Date This Estimate
Bid Amount: $367,702.00 Participating: $367,162.00 $266,043.20 $101,118.80
Percent Complete: 99.85 % Non Participating: $0.00 $0.00 $0.00
Funds Available: $540.00 Total Earnings: $367,162.00 $266,043.20 $101,118.80
Unearned Balance: $540.00 Stockpiled Materials: $0.00 $0.00 $0.00
Gross Earnings: $367,162.00 $266,043.20 $101,118.80
Other Adjustments: $0.00 $0.00 $0.00
Liq Dam/Disincentive: $0.00 $0.00 $0.00
TOTAL: $367,162.00 $266,043.20 $101,118.80

Estimate Adjustment Detail

Contract ID: 120250   Estimate Number: 0005     Primary JP: 29011(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
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.
Subtotals For Liquidated Damages $


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: 120250   Estimate Number: 0005     Primary JP: 29011(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-114F(303)AG Project:    29011(04) Category:    0300/TRAFFIC
0001 3" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8344 LF 150.000 150.000 150.000 150.000 $35.00 $5,250.00 $5,250.00
0002 PULL BOX(SIZE II) 803(A) 8066 EA 2.000 2.000 2.000 2.000 $340.00 $680.00 $680.00
0003 (SP)CABINET 824(C) 6551 EA 2.000 2.000 2.000 2.000 $24,710.00 $49,420.00 $49,420.00
0004 TRAFFIC SIGNAL CONTROLLER ASSEMBLY 825 8550 EA 20.000 20.000 3.000 20.000 $4,425.00 $13,275.00 $88,500.00
0005 SIGNAL SYSTEM CONTROLLER UPGRADE 825(A) 8559 EA 35.000 35.000 4.000 35.000 $1,580.00 $6,320.00 $55,300.00
0006 1WAY 3SEC. ADJ. SIG. HD. S-6 831 8231 EA 10.000 10.000 2.000 10.000 $690.00 $1,380.00 $6,900.00
0007 1WAY 3SEC. ADJ. SIG. HD.S-12 831 8275 EA 11.000 11.000 2.000 11.000 $690.00 $1,380.00 $7,590.00
0008 1WAY 4SEC. ADJ. SIG. HD.S-13 831 8280 EA 147.000 147.000 14.000 147.000 $799.00 $11,186.00 $117,453.00
0009 BACKPLATE 833 3030 EA 168.000 168.000 27.000 168.000 $59.00 $1,593.00 $9,912.00
0010 5/C TRAFFIC SIGNAL ELECTRICAL CABLE 834(A) 8207 LF 575.000 575.000 50.000 575.000 $1.10 $55.00 $632.50
0011 7/C TRAFFIC SIGNAL ELECTRICAL CABLE 834(A) 8208 LF 5,350.000 5,350.000 1,264.000 5,350.000 $1.20 $1,516.80 $6,420.00
0012 12/C TRAFFIC SIGNAL ELECTRICAL CABLE 834(A) 8210 LF 200.000 200.000   0.000 $2.70 $0.00 $0.00
0013 21/C TRAFFIC SIGNAL ELECTRICAL CABLE 834(A) 8213 LF 3,175.000 3,175.000 1,700.000 3,175.000 $3.34 $5,678.00 $10,604.50
0014 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.670 1.000 $3,000.00 $2,010.00 $3,000.00
Subtotals For Category     0300/TRAFFIC    $99,743.80 $361,662.00
Fed/State Project Number:    STPG-114F(303)AG Project:    29011(04) Category:    0640/CONSTRUCTION
0015 MOBILIZATION 641 1552 LSUM 1.000 1.000 0.250 1.000 $5,500.00 $1,375.00 $5,500.00
Subtotals For Category     0640/CONSTRUCTION    $1,375.00 $5,500.00
Subtotals For Project STPG-114F(303)AG /29011(04) $101,118.80 $367,162.00