Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    09/05/2012
Contract ID: 120074   Estimate Number: 0002     Contract No: 710988
Residency: MCALESTER (02400)   Estimate Type: Progressive     Account No: 404200

Project Number(s): BTOP-261B(002)
Primary Job Piece No: 28128(46)
Contract Description: SAFETY IMPROVEMENT (FIBER OPTIC CABLE) US-270: FROM MCALESTER, EXTEND EAST TO WILBURTON. PROJECT LENGTH = 28.920 MILESPREQUALIFICATION FOR THIS PROJECT HAS BEEN WAIVED, HOWEVER, ALL 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: PITTSBURG              
Name of Road: US-270              
Prime Contractor: BEAR COMMUNICATIONS, LLC              
    725 N 2ND ST SUITE M              
    LAWRENCE , KS   66044              
Surety Company: THE CINCINNATI INSURANCE CO.              

Date Let: 02/16/2012 NTP Effective Date: 05/21/2012 Pay Period: 07/01/2012  TO  08/31/2012
Date Awarded: 03/05/2012 Date Work Began: 06/12/2012 Original Contract Time: 95
Date Contract Executed: 03/20/2012 Date Time Stopped: Current Time Charged: 103.00
Date NTP Issued: 04/23/2012 Completion Date: Current Time Allowed: 95.00
General Liability Expires: 10/18/2012 Workman's Comp Expires: 10/18/2012 Percent Time Used: 108.42 %
Specification Year: 2009     Date Approved:

Current Contract Amount: $952,036.39 Total to Date Prev to Date This Estimate
Bid Amount: $952,036.39 Participating: $0.00 $0.00 $0.00
Percent Complete: 22.91 % Non Participating: $296,073.72 $151,369.78 $144,703.94
Funds Available: $733,962.67 Total Earnings: $296,073.72 $151,369.78 $144,703.94
Unearned Balance: $733,962.67 Stockpiled Materials: $0.00 $0.00 $0.00
Gross Earnings: $296,073.72 $151,369.78 $144,703.94
Other Adjustments: $0.00 $0.00 $0.00
Liq Dam/Disincentive: $-78,000.00 $0.00 $-78,000.00
TOTAL: $218,073.72 $151,369.78 $66,703.94

Estimate Adjustment Detail

Contract ID: 120074   Estimate Number: 0002     Primary JP: 28128(46)



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
System Application of Liquidated Damages 0002 --8.0 $500.00 $-4,000.00
Subtotals For Liquidated Damages $-4,000.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
01 Conduit & Ground Boxes 05/21/2012 NOT ENTERED 65.00 DYS $2,000.00 N
02 Fiber Optic Cable Installation NOT ENTERED NOT ENTERED 30.00 DYS $2,000.00 N


MILESTONE ADJUSTMENTS
Milestone Number Milestone Adjustment Description Estimate Nbr Total
01 System Application of Disincentive Adj 0002 $-74,000.00
Subtotals For Milestones $-74,000.00

Line Item Detail

Contract ID: 120074   Estimate Number: 0002     Primary JP: 28128(46)



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-261B(002) Project:    28128(46) Category:    0300/TRAFFIC
0001 RAILROAD FLAGGING 104 0900 HOUR 32.000 32.000   0.000 $65.00 $0.00 $0.00
0002 CLEARING AND GRUBBING 201(A) 0102 LSUM 1.000 1.000   0.000 $11,875.00 $0.00 $0.00
0003 TEMPORARY SILT FENCE 221(C) 2801 LF 2,000.000 2,000.000   0.000 $6.09 $0.00 $0.00
0004 SOLID SLAB SODDING 230(A) 2806 SY 2,000.000 2,000.000   0.000 $6.37 $0.00 $0.00
0005 CLASS A CONCRETE 509(B) 0321 CY 10.240 10.240   0.000 $139.41 $0.00 $0.00
0006 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED 802(A) 8316 LF 1,702.000 1,702.000   582.000 $69.99 $0.00 $40,734.18
0007 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED 802(A) 8318 LF 100.000 100.000   0.000 $16.16 $0.00 $0.00
0008 1 1/2" HIGH DENSITY PE PIPE - BORED 802(C) 8551 LF 12,577.000 12,577.000 1,992.000 1,992.000 $10.75 $21,414.00 $21,414.00
0009 1 1/2" HIGH DENSITY PE PIPE - TRENCHED 802(C) 8556 LF 37,628.000 37,628.000 6,118.000 6,118.000 $3.56 $21,780.08 $21,780.08
0010 1 1/2" HIGH DENSITY PE PIPE - PLOWED 802(C) 8565 LF 101,668.000 101,668.000 41,850.000 88,529.000 $2.28 $95,418.00 $201,846.12
0011 GROUND BOX (R3248) 803(B) 8135 EA 39.000 39.000   0.000 $975.14 $0.00 $0.00
0012 GROUND BOX (B2-48) 803(B) 8150 EA 16.000 16.000   0.000 $1,073.68 $0.00 $0.00
0013 REINFORCING STEEL 804(B) 2916 LB 192.000 192.000   0.000 $5.54 $0.00 $0.00
0014 (SP)FIBER OPTIC CABLE, 24 SMF 818(A) 8715 LF 2,757.000 2,757.000   0.000 $0.69 $0.00 $0.00
0015 (SP)FIBER OPTIC CABLE, 96 SMF 818(A) 8730 LF 161,447.000 161,447.000   0.000 $0.73 $0.00 $0.00
0016 (SP) FIBER OPTIC CABLE, 24 INDOOR/OUTDOOR PLENUM 818(A) 8738 LF 300.000 300.000   0.000 $1.93 $0.00 $0.00
0017 (SP) FIBER OPTIC CABLE, 48 INDOOR/OUTDOOR PLENUM 818(A) 8739 LF 1,200.000 1,200.000   0.000 $1.93 $0.00 $0.00
0018 (SP)FIBER OPTIC PATCH PANEL, 24 PORT 818(B) 8745 EA 1.000 1.000   0.000 $1,116.38 $0.00 $0.00
0019 (SP)FIBER OPTIC CABLE SPLICE 818(C) 8735 EA 8.000 8.000   0.000 $2,154.58 $0.00 $0.00
0020 (SP)FIBER OPTIC CABLE TERMINATION 818(D) 8740 EA 200.000 200.000   0.000 $230.67 $0.00 $0.00
0021 (SP) SHIELD ISOLATION PEDESTAL 818(F) 8370 EA 5.000 5.000   0.000 $224.11 $0.00 $0.00
0022 (SP) SHIELD ISOLATION PEDESTAL (MINI) 818(F) 8375 EA 14.000 14.000   0.000 $244.45 $0.00 $0.00
0023 (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION 818(G) 5570 EA 177.000 177.000   0.000 $87.95 $0.00 $0.00
Subtotals For Category     0300/TRAFFIC    $138,612.08 $285,774.38
Fed/State Project Number:    BTOP-261B(002) Project:    28128(46) Category:    0301/TEMPORARY TRAFFIC
0024 (PL)TRUCK MOUNTED ATTENUATOR 876(A) 8482 SD 130.000 130.000   0.000 $20.63 $0.00 $0.00
0025 FLAGGER 880(I) 8902 SD 35.000 35.000   0.000 $206.25 $0.00 $0.00
0026 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.250 0.500 $6,500.00 $1,625.00 $3,250.00
0027 PORT.CHANGEABLE MESSAGE SIGN 882(A) 8306 SD 130.000 130.000 8.000 16.000 $10.31 $82.48 $164.96
Subtotals For Category     0301/TEMPORARY TRAFFIC    $1,707.48 $3,414.96
Fed/State Project Number:    BTOP-261B(002) Project:    28128(46) Category:    0640/CONSTRUCTION
0028 SWPPP DOCUMENTATION AND MANAGEMENT 220 2800 LSUM 1.000 1.000 0.500 0.500 $3,768.75 $1,884.38 $1,884.38
0029 MOBILIZATION 641 1552 LSUM 1.000 1.000 0.500 1.000 $5,000.00 $2,500.00 $5,000.00
Subtotals For Category     0640/CONSTRUCTION    $4,384.38 $6,884.38
Subtotals For Project BTOP-261B(002) /28128(46) $144,703.94 $296,073.72