Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    09/01/2010
Contract ID: 100131   Estimate Number: 0002     Contract No: 511188
Residency: OKLAHOMA CITY (04600)   Estimate Type: Progressive     Account No: 400400

Project Number(s): STP-STIM(404)AG
Primary Job Piece No: 26742(04)
Contract Description: TRAFFIC SIGNALS CITY STREET (NE 23RD STREET): AT NICHOLS DRIVE IN NICOMA PARK.
Primary County: OKLAHOMA              
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: 03/18/2010 NTP Effective Date: 07/26/2010 Pay Period: 08/01/2010  TO  08/31/2010
Date Awarded: 04/12/2010 Date Work Began: 07/26/2010 Original Contract Time: 30
Date Contract Executed: 04/23/2010 Date Time Stopped: Current Time Charged: 37.00
Date NTP Issued: 06/01/2010 Completion Date: Current Time Allowed: 37.00
General Liability Expires: 07/01/2011 Workman's Comp Expires: 02/01/2011 Percent Time Used: 100.00 %
Specification Year: 1999     Date Approved:

Current Contract Amount: $72,188.75 Total to Date Prev to Date This Estimate
Bid Amount: $72,188.75 Participating: $69,844.05 $21,832.50 $48,011.55
Percent Complete: 91.16 % Non Participating: $0.00 $0.00 $0.00
Funds Available: $6,378.40 Non ARRA: $0.00 $0.00 $0.00
Unearned Balance: $6,378.40 Total Earnings: $69,844.05 $21,832.50 $48,011.55
Stockpiled Materials: $0.00 $0.00 $0.00
Gross Earnings: $69,844.05 $21,832.50 $48,011.55
Other Adjustments: $-4,033.70 $-360.00 $-3,673.70
Liq Dam/Disincentive: $0.00 $0.00 $0.00
TOTAL: $65,810.35 $21,472.50 $44,337.85

Estimate Adjustment Detail

Contract ID: 100131   Estimate Number: 0002     Primary JP: 26742(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.


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
26742(04) 0021 MAST ARM MOUNTED SIGNS(ALUMINUM) * Material Discrepancy Adjustments 0002 -68.00 $24.75 $-1,683.00
26742(04) 0022 TRAFFIC STRIPE(PLASTIC)(4" WIDE) * Material Discrepancy Adjustments 0002 -1,404.00 $0.70 $-982.80
26742(04) 0023 TRAFFIC STRIPE(PLASTIC)(8" WIDE) * Material Discrepancy Adjustments 0002 -162.00 $0.75 $-121.50
26742(04) 0024 TRAFFIC STRIPE(PLASTIC)(24" WIDE) * Material Discrepancy Adjustments 0002 -88.00 $2.55 $-224.40
26742(04) 0025 TRAFFIC STRIPE(PLASTIC)(ARROWS) * Material Discrepancy Adjustments 0002 -4.00 $188.00 $-752.00
26742(04) 0026 TRAFFIC STRIPE(PLASTIC)(WORDS) * Material Discrepancy Adjustments 0002 -3.00 $90.00 $-270.00
26742(04) 0028 CONSTRUCTION TRAFFIC CONTROL * Material Discrepancy Adjustments 0001 -0.20 $1,800.00 $-360.00
26742(04) 0028 CONSTRUCTION TRAFFIC CONTROL * Material Discrepancy Adjustments 0002 0.20 $1,800.00 $360.00
Subtotals For Line Item Adjustments $-4,033.70
* = User applied Line Item Adjustments


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

Line Item Detail

Contract ID: 100131   Estimate Number: 0002     Primary JP: 26742(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(404)AG Project:    26742(04) Category:    0400/TRAFFIC
0001 1 1/2" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8336 LF 200.000 200.000 361.000 361.000 $12.00 $4,332.00 $4,332.00
0002 1 1/2" PVC SCH.40 PLASTIC CONDUIT TRENCHED 802(B) 8338 LF 850.000 850.000 376.000 376.000 $3.60 $1,353.60 $1,353.60
0003 2" PVC SCH.40 PLASTIC CONDUIT TRENCHED 802(B) 8342 LF 50.000 50.000   0.000 $3.90 $0.00 $0.00
0004 3" PVC SCH.40 PLASTIC CONDUIT BORED 802(B) 8344 LF 250.000 250.000 218.000 218.000 $13.30 $2,899.40 $2,899.40
0005 3" PVC SCH.40 PLASTIC CONDUIT TRENCHED 802(B) 8346 LF 50.000 50.000 36.000 36.000 $4.20 $151.20 $151.20
0006 PULL BOX(SIZE I) 803 8065 EA 14.000 14.000 8.000 13.000 $315.00 $2,520.00 $4,095.00
0007 PULL BOX(SIZE II) 803 8066 EA 1.000 1.000 1.000 1.000 $455.00 $455.00 $455.00
0008 (PL)POLE & TWIN TS MST.ARM(G.STL.) 806(A) 8740 EA 2.000 2.000   2.000 $9,148.00 $0.00 $18,296.00
0009 1/C NO.6 ELECTRICAL CONDUCTOR 811 8040 LF 400.000 400.000 90.000 90.000 $0.95 $85.50 $85.50
0010 VEH.ACT.SOL.ST.TRAF.SIG.CON.ASM 825 8550 EA 1.000 1.000 1.000 1.000 $8,785.00 $8,785.00 $8,785.00
0011 SOL.STE.DIGITAL IND.VEH.LP.DET. 828(A) 8135 EA 7.000 7.000 7.000 7.000 $115.00 $805.00 $805.00
0012 LOOP DETECTOR WIRE 828(B) 8138 LF 3,200.000 3,200.000 3,360.000 3,360.000 $2.45 $8,232.00 $8,232.00
0013 1WAY 3SEC. ADJ. SIG. HD. S-6 831 8231 EA 7.000 7.000 7.000 7.000 $465.00 $3,255.00 $3,255.00
0014 1WAY 5SEC. ADJ. SIG. HD. S-19 831 8286 EA 3.000 3.000 3.000 3.000 $828.00 $2,484.00 $2,484.00
0015 BACKPLATE 833 3030 EA 10.000 10.000 10.000 10.000 $81.00 $810.00 $810.00
0016 5/C TRAF.SIG.ELECT.CABLE 834(A) 8207 LF 600.000 600.000 391.000 391.000 $1.15 $449.65 $449.65
0017 7/C TRAF.SIG.ELECT.CABLE 834(A) 8208 LF 300.000 300.000 182.000 182.000 $1.25 $227.50 $227.50
0018 12/C TRAF.SIG.ELECT.CABLE 834(A) 8210 LF 200.000 200.000 206.000 206.000 $2.20 $453.20 $453.20
0019 15/C TRAF.SIG.EL.CABLE 834(A) 8211 LF 50.000 50.000   0.000 $2.80 $0.00 $0.00
0020 2/C SHIELDED LOOP DETECTOR LEAD-IN CABLE 834(B) 8220 LF 1,200.000 1,200.000 1,309.000 1,309.000 $0.70 $916.30 $916.30
0021 MAST ARM MOUNTED SIGNS(ALUMINUM) 850(C) 8118 SF 68.000 68.000 68.000 68.000 $24.75 $1,683.00 $1,683.00
0022 TRAFFIC STRIPE(PLASTIC)(4" WIDE) 855(A) 8812 LF 1,630.000 1,630.000 1,804.000 1,804.000 $0.70 $1,262.80 $1,262.80
0023 TRAFFIC STRIPE(PLASTIC)(8" WIDE) 855(A) 8814 LF 150.000 150.000 162.000 162.000 $0.75 $121.50 $121.50
0024 TRAFFIC STRIPE(PLASTIC)(24" WIDE) 855(A) 8825 LF 95.000 95.000 88.000 88.000 $2.55 $224.40 $224.40
0025 TRAFFIC STRIPE(PLASTIC)(ARROWS) 855(B) 8818 EA 4.000 4.000 4.000 4.000 $188.00 $752.00 $752.00
0026 TRAFFIC STRIPE(PLASTIC)(WORDS) 855(B) 8821 EA 3.000 3.000 3.000 3.000 $90.00 $270.00 $270.00
0027 PAVEMENT MARKING REMOVAL(TRAFFIC STRIPE) 859(A) 8006 LF 1,400.000 1,400.000   0.000 $0.55 $0.00 $0.00
0028 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.500 0.700 $1,800.00 $900.00 $1,260.00
0029 (PL)TRAFFIC ITEMS 890 7700 LSUM 1.000 1.000 1.000 1.000 $2,800.00 $2,800.00 $2,800.00
0030 (PL)REMOVAL OF EXISTING SIGNS 890(A) 8722 LSUM 1.000 1.000 1.000 1.000 $30.00 $30.00 $30.00
Subtotals For Category     0400/TRAFFIC    $46,258.05 $66,489.05
Fed/State Project Number:    STP-STIM(404)AG Project:    26742(04) Category:    0600/STAKING
0031 STAKING 642 0098 LSUM 1.000 1.000 0.650 0.900 $380.00 $247.00 $342.00
Subtotals For Category     0600/STAKING    $247.00 $342.00
Fed/State Project Number:    STP-STIM(404)AG Project:    26742(04) Category:    0640/CONSTRUCTION
0032 MOBILIZATION 641 1552 LSUM 1.000 1.000 0.500 1.000 $3,013.00 $1,506.50 $3,013.00
Subtotals For Category     0640/CONSTRUCTION    $1,506.50 $3,013.00
Subtotals For Project STP-STIM(404)AG /26742(04) $48,011.55 $69,844.05