Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    06/14/2012
Contract ID: 120063   Estimate Number: 0004     Contract No: 710893
Residency: COBB ENGINEERING CO., INC. (06003)   Estimate Type: Progressive     Account No: 404600

Project Number(s): BTOP-277N(001)
Primary Job Piece No: 28128(37)
Contract Description: SAFETY IMPROVEMENTS (FIBER OPTIC CABLE) US-412: FROM THE CITY OF WOODWARD TO THE CITY OF ORIENTA. PROJECT LENGTH = 54.3 MILESPREQUALIFICATION FOR THIS PROJECT HAS BEEN WAIVED, HOWEVER, BIDDERS WILL BE REQUIRED TO PROVIDE VERIFICATION OF EXPERIENCE PRIOR TO RECEIVING BID DOCUMENTS. BOTH BID EXPRESS AND WRITTEN BIDS WILL BE ACCEPTABLE.
Primary County: WOODWARD              
Name of Road: US-412              
Prime Contractor: ROHL NETWORKS, LP              
    2875 JUPITER PARK DRIVE, STE. 900              
    JUPITER , FL   33458              
Surety Company: TRAVELERS INDEMNITY COMPANY              

Date Let: 01/19/2012 NTP Effective Date: 03/26/2012 Pay Period: 05/16/2012  TO  05/31/2012
Date Awarded: 02/06/2012 Date Work Began: 03/26/2012 Original Contract Time: 160
Date Contract Executed: 02/21/2012 Date Time Stopped: Current Time Charged: 65.00
Date NTP Issued: 03/01/2012 Completion Date: Current Time Allowed: 160.00
General Liability Expires: 01/19/2013 Workman's Comp Expires: 01/19/2013 Percent Time Used: 40.63 %
Specification Year: 2009     Date Approved:

Current Contract Amount: $1,698,546.26 Total to Date Prev to Date This Estimate
Bid Amount: $1,698,546.26 Participating: $0.00 $0.00 $0.00
Percent Complete: 99.51 % Non Participating: $1,688,543.87 $1,403,634.15 $284,909.72
Funds Available: $8,407.38 Total Earnings: $1,688,543.87 $1,403,634.15 $284,909.72
Unearned Balance: $8,407.38 Stockpiled Materials: $1,595.01 $12,448.37 $-10,853.36
Gross Earnings: $1,690,138.88 $1,416,082.52 $274,056.36
Other Adjustments: $0.00 $0.00 $0.00
Liq Dam/Disincentive: $0.00 $0.00 $0.00
TOTAL: $1,690,138.88 $1,416,082.52 $274,056.36

Estimate Adjustment Detail

Contract ID: 120063   Estimate Number: 0004     Primary JP: 28128(37)



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
28128(37) 0007 Marking Tape Stockpiled Material Adjustment 0002 $-301.56
28128(37) 0007 Marking Tape Stockpiled Material Initial Payment 0001 $363.60
28128(37) 0007 Marking Tape Stockpiled Material Adjustment 0001 $-62.04
28128(37) 0007 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0001 $-659.69
28128(37) 0007 1-1/2" Pipe and Couplers Stockpiled Material Initial Payment 0001 $4,635.67
28128(37) 0007 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0002 $-3,975.98
28128(37) 0008 Marking Tape Stockpiled Material Initial Payment 0001 $1,408.40
28128(37) 0008 Marking Tape Stockpiled Material Adjustment 0001 $-89.16
28128(37) 0008 Marking Tape Stockpiled Material Adjustment 0002 $-667.44
28128(37) 0008 Marking Tape Stockpiled Material Adjustment 0003 $-651.80
28128(37) 0008 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0003 $-6,930.75
28128(37) 0008 1-1/2" Pipe and Couplers Stockpiled Material Initial Payment 0001 $14,975.86
28128(37) 0008 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0001 $-948.06
28128(37) 0008 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0002 $-7,097.05
28128(37) 0009 Marking Tape Stockpiled Material Initial Payment 0001 $9,272.00
28128(37) 0009 Marking Tape Stockpiled Material Adjustment 0001 $-925.20
28128(37) 0009 Marking Tape Stockpiled Material Adjustment 0003 $-396.88
28128(37) 0009 Marking Tape Stockpiled Material Adjustment 0002 $-7,949.92
28128(37) 0009 1-1/2" Pipe and Couplers Stockpiled Material Initial Payment 0001 $98,591.49
28128(37) 0009 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0001 $-9,837.88
28128(37) 0009 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0003 $-4,220.12
28128(37) 0009 1-1/2" Pipe and Couplers Stockpiled Material Adjustment 0002 $-84,533.48
28128(37) 0010 R2348 Ground Boxes Stockpiled Material Adjustment 0004 $-9,920.00
28128(37) 0010 R2348 Ground Boxes Stockpiled Material Adjustment 0002 $-9,920.00
28128(37) 0010 R2348 Ground Boxes Stockpiled Material Initial Payment 0002 $40,300.00
28128(37) 0010 R2348 Ground Boxes Stockpiled Material Adjustment 0003 $-19,220.00
28128(37) 0011 Ground Rods Stockpiled Material Initial Payment 0001 $3,573.76
28128(37) 0011 Ground Rods Stockpiled Material Adjustment 0003 $-2,680.32
28128(37) 0011 Ground Rods Stockpiled Material Adjustment 0004 $-223.36
28128(37) 0011 Ground Rods Stockpiled Material Adjustment 0002 $-670.08
28128(37) 0011 Ground Boxes Stockpiled Material Adjustment 0004 $-710.00
28128(37) 0011 Ground Boxes Stockpiled Material Adjustment 0003 $-4,260.00
28128(37) 0011 Ground Boxes Stockpiled Material Initial Payment 0001 $6,390.00
28128(37) 0011 Ground Boxes Stockpiled Material Adjustment 0002 $-1,065.00
Subtotals For Stockpile Payments $1,595.01


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
01 Incentive/Disincentive Conduit & Gound Boxes 03/25/2012 05/24/2012 110.00 DYS $2,000.00 Y
02 Incentive/Disincentive Fiber Optic Cable Installation NOT ENTERED NOT ENTERED 50.00 DYS $2,000.00 N


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: 120063   Estimate Number: 0004     Primary JP: 28128(37)



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:    BTOP-277N(001) Project:    28128(37) Category:    0300/TRAFFIC
0001 CLEARING AND GRUBBING 201(A) 0102 LSUM 1.000 1.000   1.000 $5,500.00 $0.00 $5,500.00
0002 TEMPORARY SILT FENCE 221(C) 2801 LF 2,000.000 2,000.000 4,136.000 4,136.000 $3.90 $16,130.40 $16,130.40
0003 SOLID SLAB SODDING 230(A) 2806 SY 2,000.000 2,000.000   0.000 $3.60 $0.00 $0.00
0004 CLASS A CONCRETE 509(B) 0321 CY 11.520 11.520 10.000 10.000 $250.00 $2,500.00 $2,500.00
0005 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED 802(A) 8316 LF 2,620.000 2,620.000   2,230.000 $51.95 $0.00 $115,848.50
0006 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED 802(A) 8318 LF 100.000 100.000   0.000 $62.50 $0.00 $0.00
0007 1 1/2" HIGH DENSITY PE PIPE - BORED 802(C) 8551 LF 15,805.000 15,805.000 0.000 22,557.000 $10.31 $0.00 $232,562.67
0008 1 1/2" HIGH DENSITY PE PIPE - TRENCHED 802(C) 8556 LF 35,210.000 35,210.000 1,018.000 46,944.000 $8.21 $8,357.78 $385,410.24
0009 1 1/2" HIGH DENSITY PE PIPE - PLOWED 802(C) 8565 LF 231,800.000 231,800.000   237,737.000 $2.46 $0.00 $584,833.02
0010 GROUND BOX (R3248) 803(B) 8135 EA 65.000 65.000 16.000 63.000 $880.30 $14,084.80 $55,458.90
0011 GROUND BOX (B2-48) 803(B) 8150 EA 18.000 18.000 2.000 17.000 $1,276.06 $2,552.12 $21,693.02
0012 REINFORCING STEEL 804(B) 2916 LB 216.000 216.000 190.000 190.000 $3.60 $684.00 $684.00
0013 (SP)FIBER OPTIC CABLE, 24 SMF 818(A) 8715 LF 5,590.000 5,590.000 5,566.000 5,566.000 $0.88 $4,898.08 $4,898.08
0014 (SP)FIBER OPTIC CABLE, 96 SMF 818(A) 8730 LF 323,256.000 323,256.000 243,198.000 243,198.000 $0.88 $214,014.24 $214,014.24
0015 (SP) FIBER OPTIC CABLE, 24 INDOOR/OUTDOOR PLENUM 818(A) 8738 LF 200.000 200.000   0.000 $0.88 $0.00 $0.00
0016 (SP)FIBER OPTIC PATCH PANEL, 24 PORT 818(B) 8745 EA 1.000 1.000   0.000 $442.29 $0.00 $0.00
0017 (SP)FIBER OPTIC PATCH PANEL, 96 PORT 818(B) 8755 EA 2.000 2.000   0.000 $1,653.80 $0.00 $0.00
0018 (SP)FIBER OPTIC CABLE SPLICE 818(C) 8735 EA 8.000 8.000   0.000 $87.87 $0.00 $0.00
0019 (SP)FIBER OPTIC CABLE TERMINATION 818(D) 8740 EA 200.000 200.000   0.000 $36.05 $0.00 $0.00
0020 (SP) SHIELD ISOLATION PEDESTAL 818(F) 8370 EA 5.000 5.000   0.000 $101.40 $0.00 $0.00
0021 (SP) SHIELD ISOLATION PEDESTAL (MINI) 818(F) 8375 EA 16.000 16.000 15.000 15.000 $55.60 $834.00 $834.00
0022 (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION 818(G) 5570 EA 400.000 400.000 210.000 210.000 $70.33 $14,769.30 $14,769.30
Subtotals For Category     0300/TRAFFIC    $278,824.72 $1,655,136.37
Fed/State Project Number:    BTOP-277N(001) Project:    28128(37) Category:    0301/TRAFFIC CONTROL
0023 (PL)TRUCK MOUNTED ATTENUATOR 876(A) 8482 SD 220.000 220.000   0.000 $172.50 $0.00 $0.00
0024 FLAGGER 880(I) 8902 SD 50.000 50.000   0.000 $63.25 $0.00 $0.00
0025 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.250 0.750 $18,400.00 $4,600.00 $13,800.00
0026 PORT.CHANGEABLE MESSAGE SIGN 882(A) 8306 SD 220.000 220.000   0.000 $86.25 $0.00 $0.00
Subtotals For Category     0301/TRAFFIC CONTROL    $4,600.00 $13,800.00
Fed/State Project Number:    BTOP-277N(001) Project:    28128(37) Category:    0640/CONSTRUCTION
0027 SWPPP DOCUMENTATION AND MANAGEMENT 220 2800 LSUM 1.000 1.000 0.500 0.750 $2,970.00 $1,485.00 $2,227.50
0028 MOBILIZATION 641 1552 LSUM 1.000 1.000   1.000 $17,380.00 $0.00 $17,380.00
Subtotals For Category     0640/CONSTRUCTION    $1,485.00 $19,607.50
Subtotals For Project BTOP-277N(001) /28128(37) $284,909.72 $1,688,543.87