Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    05/17/2010
Contract ID: 090476   Estimate Number: 0004     Contract No: 510072
Residency: PURCELL (03200)   Estimate Type: Progressive     Account No: 400300

Project Number(s): STP-STIM(236)AG
Primary Job Piece No: 26640(04)
Contract Description: TRAFFIC SIGNAL CITY STREET(24TH AVE. W.): FROM SH-9, EXTEND NORTH TO TECUMSEH ROAD IN THE CITY OF NORMAN.
Primary County: CLEVELAND              
Name of Road: CITY STREET              
Prime Contractor: TRAFFIC & LIGHTING SYSTEMS, LLC              
    13305 N. SANTE FE              
    OKLA. CITY , OK   73114              
Surety Company: OHIO CASUALTY INSURANCE COMPANY              

Date Let: 06/18/2009 NTP Effective Date: 08/03/2009 Pay Period: 10/01/2009  TO  05/15/2010
Date Awarded: 06/22/2009 Date Work Began: 08/03/2009 Original Contract Time: 60
Date Contract Executed: 07/07/2009 Date Time Stopped: Current Time Charged: 286.00
Date NTP Issued: 07/09/2009 Completion Date: Current Time Allowed: 296.00
General Liability Expires: 07/01/2010 Workman's Comp Expires: 07/01/2010 Percent Time Used: 96.62 %
Specification Year: 1999     Date Approved: 05/17/2010

Current Contract Amount: $670,256.95 Total to Date Prev to Date This Estimate
Bid Amount: $604,709.90 Participating: $476,194.75 $353,624.01 $122,570.74
Percent Complete: 99.69 % Non Participating: $73,727.20 $0.00 $73,727.20
Funds Available: $2,100.00 Non ARRA: $118,235.00 $0.00 $118,235.00
Unearned Balance: $-63,447.05 Total Earnings: $668,156.95 $353,624.01 $314,532.94
Stockpiled Materials: $0.00 $0.00 $0.00
Gross Earnings: $668,156.95 $353,624.01 $314,532.94
Other Adjustments: $0.00 $0.00 $0.00
Liq Dam/Disincentive: $0.00 $0.00 $0.00
TOTAL: $668,156.95 $353,624.01 $314,532.94

Estimate Adjustment Detail

Contract ID: 090476   Estimate Number: 0004     Primary JP: 26640(04)



CHANGE ORDER HISTORY
Change Order Nbr. Change Order Description Status Approval Date Contract Time Adjustment Total Change Order Amount
001 Changes to contract pay items plus additions of pay items. Approved 05/03/2010 0.0 $65,547.05


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
No line item adjustments have been created on this contract.
Subtotals For Line Item Adjustments $0.00


MILESTONE ADJUSTMENTS
Milestone Number Milestone Description Time Allowed Time Used Rate Total
No milestones exist for this contract.

Line Item Detail

Contract ID: 090476   Estimate Number: 0004     Primary JP: 26640(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(236)AG Project:    26640(04) Category:    0300/TRAFFIC
0001 2" PVC SCH.40 PLASTIC CONDUIT TRENCHED 802(B) 8342 LF 380.000 14,425.000 110.000 14,425.000 $3.00 $330.00 $43,275.00
0002 3" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8344 LF 4,200.000 0.000   0.000 $21.00 $0.00 $0.00
0003 3" PVC SCH.40 PLASTIC CONDUIT TRENCHED 802(B) 8346 LF 14,045.000 0.000   0.000 $5.45 $0.00 $0.00
0004 GROUND BOX (GB36) 803 8085 EA 10.000 0.000   0.000 $1,050.00 $0.00 $0.00
0005 GROUND BOX (R48) 803 8105 EA 40.000 21.000 2.000 21.000 $1,715.00 $3,430.00 $36,015.00
0006 (PL)FIBER OPTIC CABLE, 24, SMF-28 818 8715 LF 1,100.000 1,300.000 1,300.000 1,300.000 $4.46 $5,798.00 $5,798.00
0007 (PL)FIBER OPTIC CABLE, 144, SMF-28 818 8733 LF 21,655.000 27,200.000 1,178.000 27,200.000 $1.58 $1,861.24 $42,976.00
0008 (PL)FIBER OPTIC CABLE SPLICE 818 8735 EA 264.000 540.000 540.000 540.000 $120.75 $65,205.00 $65,205.00
0009 (PL)FIBER OPTIC CABLE TERMINATION 818 8740 EA 264.000 264.000 264.000 264.000 $99.75 $26,334.00 $26,334.00
0010 (PL)FIBER OPTIC PATCH PANEL, 24 PORT 818 8745 EA 11.000 11.000 11.000 11.000 $257.25 $2,829.75 $2,829.75
0011 (PL)E.P.S. OPTICAL DETECTOR 840(B) 8593 EA 12.000 8.000   8.000 $325.00 $0.00 $2,600.00
0012 (PL)E.P.S. OPTICAL DETECTOR CABLE 840(C) 8594 LF 6,000.000 2,000.000 1,527.000 2,000.000 $1.00 $1,527.00 $2,000.00
0013 (PL)E.P.S. 2 CHANNEL PHASE SELECTOR 840(D) 8595 EA 3.000 4.000 1.000 4.000 $1,600.00 $1,600.00 $6,400.00
0014 (PL)FIBER OPTIC ROUTE SIGN & INSTALLATION 877 5570 EA 44.000 44.000 44.000 44.000 $63.00 $2,772.00 $2,772.00
0015 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.250 1.000 $6,000.00 $1,500.00 $6,000.00
0016 (PL)SHIELD ISOLATION PEDESTAL 887 8370 EA 11.000 11.000 11.000 11.000 $315.00 $3,465.00 $3,465.00
0017 (PL)TRAFFIC ITEMS 890 7700 LSUM 1.000 1.000   1.000 $191,700.00 $0.00 $191,700.00
0018 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 1.000 1.000   1.000 $12,000.00 $0.00 $12,000.00
0019 (PL)REMOVAL OF PULL BOX 890(A) 8704 EA 30.000 30.000   18.000 $175.00 $0.00 $3,150.00
8000 3" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8344 LF 0.000 0.000   0.000 $21.00 $0.00 $0.00
Subtotals For Category     0300/TRAFFIC    $116,651.99 $452,519.75
Fed/State Project Number:    STP-STIM(236)AG Project:    26640(04) Category:    0640/CONSTRUCTION
0020 MOBILIZATION 641 1552 LSUM 1.000 1.000 0.250 1.000 $23,675.00 $5,918.75 $23,675.00
Subtotals For Category     0640/CONSTRUCTION    $5,918.75 $23,675.00
Fed/State Project Number:    STP-STIM(236)AG Project:    26640(04) Category:    0850/Non ARRA Funding
8002 2" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8340 LF 0.000 4,200.000 4,200.000 4,200.000 $20.00 $84,000.00 $84,000.00
8003 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 0.000 10.000 10.000 10.000 $970.00 $9,700.00 $9,700.00
8004 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 0.000 7.000 7.000 7.000 $2,843.75 $19,906.25 $19,906.25
8005 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 0.000 7.000 7.000 7.000 $436.25 $3,053.75 $3,053.75
8006 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 0.000 15.000 15.000 15.000 $35.00 $525.00 $525.00
8007 (PL)TRAFFIC ITEMS(SIGNALS) 890 7706 LSUM 0.000 15.000 15.000 15.000 $70.00 $1,050.00 $1,050.00
Subtotals For Category     0850/Non ARRA Funding    $118,235.00 $118,235.00
Fed/State Project Number:    STP-STIM(236)AG Project:    26640(04) Category:    0900/Federal Non Participating
8001 (PL)FIBER OPTIC CABLE, 144, SMF-28 818 8733 LF 0.000 13,340.000 13,340.000 13,340.000 $3.58 $47,757.20 $47,757.20
8008 CONSTRUCTION MISCELLANEOUS 104 0300 LF 0.000 26,500.000 26,500.000 26,500.000 $0.98 $25,970.00 $25,970.00
Subtotals For Category     0900/Federal Non Participating    $73,727.20 $73,727.20
Subtotals For Project STP-STIM(236)AG /26640(04) $314,532.94 $668,156.95