Oklahoma Department of Transportation
Progressive Estimate Summary
Created:    04/19/2012
Contract ID: 120065   Estimate Number: 0001     Contract No:
Residency: ENID (04300)   Estimate Type: Progressive     Account No:

Project Number(s): BTOP-247N(001), BTOP-224N(001)
Primary Job Piece No: 28128(39)
Contract Description: SAFETY IMPROVEMENTS (FIBER OPTIC CABLE) US-412: FROM THE CITY OF ORIENTA EAST TO I-35. PROJECT LENGTH = 65.8 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: GARFIELD              
Name of Road: US-412              
Prime Contractor: B & H CONSTRUCTION, INC              
    1471 SW 12TH AVE.              
    GOLDSBY , OK   73093              
Surety Company: ARCH INSURANCE CO.              

Date Let: 01/19/2012 NTP Effective Date: 03/12/2012 Pay Period: 02/15/2012  TO  04/15/2012
Date Awarded: 02/06/2012 Date Work Began: 03/12/2012 Original Contract Time: 210
Date Contract Executed: 02/13/2012 Date Time Stopped: Current Time Charged: 36.00
Date NTP Issued: 02/15/2012 Completion Date: Current Time Allowed: 210.00
General Liability Expires: 10/01/2012 Workman's Comp Expires: 10/01/2012 Percent Time Used: 17.14 %
Specification Year: 2009     Date Approved:

Current Contract Amount: $1,643,186.00 Total to Date Prev to Date This Estimate
Bid Amount: $1,643,186.00 Participating: $0.00 $0.00 $0.00
Percent Complete: 82.64 % Non Participating: $1,379,576.34 $0.00 $1,379,576.34
Funds Available: $285,327.16 Total Earnings: $1,379,576.34 $0.00 $1,379,576.34
Unearned Balance: $285,327.16 Stockpiled Materials: $0.00 $0.00 $0.00
Gross Earnings: $1,379,576.34 $0.00 $1,379,576.34
Other Adjustments: $-21,717.50 $0.00 $-21,717.50
Liq Dam/Disincentive: $0.00 $0.00 $0.00
TOTAL: $1,357,858.84 $0.00 $1,357,858.84

Estimate Adjustment Detail

Contract ID: 120065   Estimate Number: 0001     Primary JP: 28128(39)



CHANGE ORDER HISTORY
Change Order Nbr. Change Order Description Status Approval Date Contract Time Adjustment Total Change Order Amount
001 River Crossing Poly Pipe Pending 0 0.0 $9,800.00


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
28128(38) 0003 TEMPORARY SILT FENCE * Missing Material Certification 0001 -687.00 $2.50 $-1,717.50
28128(38) 0007 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED * Missing Material Certification 0001 -255.00 $40.00 $-10,200.00
28128(39) 0031 TEMPORARY SILT FENCE * Missing Material Certification 0001 -350.00 $2.50 $-875.00
28128(39) 0035 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED * Missing Material Certification 0001 -255.00 $35.00 $-8,925.00
Subtotals For Line Item Adjustments $-21,717.50
* = User applied Line Item Adjustments


MILESTONE INFORMATION
Milestone Number Milestone Description Start Date End Date Current Time Allowed Rate Milestone Closed
01 Incentive/Disincentive Conduit & Ground Boxes NOT ENTERED NOT ENTERED 145.00 DYS $2,000.00 N
02 Incentive/Disincentive Fiber Optic Cable Installation NOT ENTERED NOT ENTERED 65.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: 120065   Estimate Number: 0001     Primary JP: 28128(39)



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-247N(001) Project:    28128(38) Category:    0300/TRAFFIC - BTOP-247N(001)
0001 RAILROAD FLAGGING 104 0900 HOUR 48.000 48.000   0.000 $104.17 $0.00 $0.00
0002 CLEARING AND GRUBBING 201(A) 0102 LSUM 1.000 1.000   0.000 $5,000.00 $0.00 $0.00
0003 TEMPORARY SILT FENCE 221(C) 2801 LF 2,000.000 2,000.000 687.000 687.000 $2.50 $1,717.50 $1,717.50
0004 SOLID SLAB SODDING 230(A) 2806 SY 2,000.000 2,000.000   0.000 $2.50 $0.00 $0.00
0005 CLASS A CONCRETE 509(B) 0321 CY 17.000 17.000   0.000 $500.00 $0.00 $0.00
0006 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED 802(A) 8316 LF 3,100.000 3,100.000   0.000 $40.00 $0.00 $0.00
0007 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED 802(A) 8318 LF 205.000 205.000 255.000 255.000 $40.00 $10,200.00 $10,200.00
0008 1 1/2" HIGH DENSITY PE PIPE - BORED 802(C) 8551 LF 12,265.000 12,265.000 41,395.000 41,395.000 $15.00 $620,925.00 $620,925.00
0009 1 1/2" HIGH DENSITY PE PIPE - TRENCHED 802(C) 8556 LF 35,905.000 35,905.000   0.000 $2.00 $0.00 $0.00
0010 1 1/2" HIGH DENSITY PE PIPE - PLOWED 802(C) 8565 LF 148,735.000 148,735.000 160,368.000 160,368.000 $1.71 $274,229.28 $274,229.28
0011 GROUND BOX (R3248) 803(B) 8135 EA 45.000 45.000   0.000 $1,000.00 $0.00 $0.00
0012 GROUND BOX (B2-48) 803(B) 8150 EA 26.000 26.000   0.000 $1,500.00 $0.00 $0.00
0013 REINFORCING STEEL 804(B) 2916 LB 312.000 312.000   0.000 $9.62 $0.00 $0.00
0014 (SP)FIBER OPTIC CABLE, 96 SMF 818(A) 8730 LF 209,400.000 209,400.000   0.000 $0.24 $0.00 $0.00
0015 (SP) FIBER OPTIC CABLE, 24 INDOOR/OUTDOOR PLENUM 818(A) 8738 LF 835.000 835.000   0.000 $11.98 $0.00 $0.00
0016 (SP)FIBER OPTIC PATCH PANEL, 24 PORT 818(B) 8745 EA 1.000 1.000   0.000 $10,000.00 $0.00 $0.00
0017 (SP)FIBER OPTIC PATCH PANEL, 96 PORT 818(B) 8755 EA 1.000 1.000   0.000 $10,000.00 $0.00 $0.00
0018 (SP)FIBER OPTIC CABLE SPLICE 818(C) 8735 EA 8.000 8.000   0.000 $2,500.00 $0.00 $0.00
0019 (SP)FIBER OPTIC CABLE TERMINATION 818(D) 8740 EA 200.000 200.000   0.000 $200.00 $0.00 $0.00
0020 (SP) SHIELD ISOLATION PEDESTAL 818(F) 8370 EA 3.000 3.000   0.000 $1,666.67 $0.00 $0.00
0021 (SP) SHIELD ISOLATION PEDESTAL (MINI) 818(F) 8375 EA 11.000 11.000   0.000 $454.54 $0.00 $0.00
0022 (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION 818(G) 5570 EA 174.000 174.000   0.000 $50.00 $0.00 $0.00
Subtotals For Category     0300/TRAFFIC - BTOP-247N(001)    $907,071.78 $907,071.78
Fed/State Project Number:    BTOP-247N(001) Project:    28128(38) Category:    0301/TEMPORARY TRAFFIC - BTOP-247N(001)
0023 (PL)TRUCK MOUNTED ATTENUATOR 876(A) 8482 SD 170.000 170.000   0.000 $88.24 $0.00 $0.00
0024 FLAGGER 880(I) 8902 SD 40.000 40.000   0.000 $250.00 $0.00 $0.00
0025 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.500 0.500 $25,000.00 $12,500.00 $12,500.00
0026 PORT.CHANGEABLE MESSAGE SIGN 882(A) 8306 SD 170.000 170.000   0.000 $58.82 $0.00 $0.00
Subtotals For Category     0301/TEMPORARY TRAFFIC - BTOP-247N(001)    $12,500.00 $12,500.00
Fed/State Project Number:    BTOP-247N(001) Project:    28128(38) Category:    0640/CONSTRUCTION - BTOP-247N(001)
0027 SWPPP DOCUMENTATION AND MANAGEMENT 220 2800 LSUM 1.000 1.000 0.750 0.750 $30,000.00 $22,500.00 $22,500.00
0028 MOBILIZATION 641 1552 LSUM 1.000 1.000 0.500 0.500 $20,000.00 $10,000.00 $10,000.00
Subtotals For Category     0640/CONSTRUCTION - BTOP-247N(001)    $32,500.00 $32,500.00
Subtotals For Project BTOP-247N(001) /28128(38) $952,071.78 $952,071.78


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-224N(001) Project:    28128(39) Category:    0300/TRAFFIC - BTOP-224N(001)
0029 RAILROAD FLAGGING 104 0900 HOUR 48.000 48.000   0.000 $208.33 $0.00 $0.00
0030 CLEARING AND GRUBBING 201(A) 0102 LSUM 1.000 1.000   0.000 $5,000.00 $0.00 $0.00
0031 TEMPORARY SILT FENCE 221(C) 2801 LF 2,000.000 2,000.000 350.000 350.000 $2.50 $875.00 $875.00
0032 SOLID SLAB SODDING 230(A) 2806 SY 2,000.000 2,000.000   0.000 $2.50 $0.00 $0.00
0033 CLASS A CONCRETE 509(B) 0321 CY 13.000 13.000   0.000 $500.00 $0.00 $0.00
0034 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED 802(A) 8316 LF 670.000 670.000   0.000 $35.00 $0.00 $0.00
0035 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED 802(A) 8318 LF 315.000 315.000 255.000 255.000 $35.00 $8,925.00 $8,925.00
0036 1 1/2" HIGH DENSITY PE PIPE - BORED 802(C) 8551 LF 5,235.000 5,235.000 11,657.000 11,657.000 $18.00 $209,826.00 $209,826.00
0037 1 1/2" HIGH DENSITY PE PIPE - TRENCHED 802(C) 8556 LF 7,295.000 7,295.000 2,303.000 2,303.000 $2.25 $5,181.75 $5,181.75
0038 1 1/2" HIGH DENSITY PE PIPE - PLOWED 802(C) 8565 LF 144,720.000 144,720.000 132,863.000 132,863.000 $1.50 $199,294.50 $199,294.50
0039 GROUND BOX (R3248) 803(B) 8135 EA 30.000 30.000   0.000 $1,000.00 $0.00 $0.00
0040 GROUND BOX (B2-48) 803(B) 8150 EA 19.000 19.000   0.000 $1,500.00 $0.00 $0.00
0041 REINFORCING STEEL 804(B) 2916 LB 228.000 228.000   0.000 $10.96 $0.00 $0.00
0042 (SP)FIBER OPTIC CABLE, 96 SMF 818(A) 8730 LF 166,850.000 166,850.000   0.000 $0.30 $0.00 $0.00
0043 (SP) FIBER OPTIC CABLE, 48 INDOOR/OUTDOOR PLENUM 818(A) 8739 LF 600.000 600.000   0.000 $13.33 $0.00 $0.00
0044 (SP)FIBER OPTIC PATCH PANEL, 96 PORT 818(B) 8755 EA 5.000 5.000   0.000 $1,600.00 $0.00 $0.00
0045 (SP)FIBER OPTIC CABLE SPLICE 818(C) 8735 EA 56.000 56.000   0.000 $428.57 $0.00 $0.00
0046 (SP)FIBER OPTIC CABLE TERMINATION 818(D) 8740 EA 384.000 384.000   0.000 $83.33 $0.00 $0.00
0047 (SP) SHIELD ISOLATION PEDESTAL 818(F) 8370 EA 3.000 3.000   0.000 $1,333.34 $0.00 $0.00
0048 (SP) SHIELD ISOLATION PEDESTAL (MINI) 818(F) 8375 EA 9.000 9.000   0.000 $444.44 $0.00 $0.00
0049 (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION 818(G) 5570 EA 137.000 137.000   0.000 $50.00 $0.00 $0.00
Subtotals For Category     0300/TRAFFIC - BTOP-224N(001)    $424,102.25 $424,102.25
Fed/State Project Number:    BTOP-224N(001) Project:    28128(39) Category:    0301/TEMPORARY TRAFFIC - BTOP-224N(001)
0050 (PL)TRUCK MOUNTED ATTENUATOR 876(A) 8482 SD 130.000 130.000   0.000 $57.69 $0.00 $0.00
0051 FLAGGER 880(I) 8902 SD 30.000 30.000   0.000 $100.00 $0.00 $0.00
0052 CONSTRUCTION TRAFFIC CONTROL 880(J) 8905 LSUM 1.000 1.000 0.500 0.500 $6,804.61 $3,402.31 $3,402.31
0053 PORT.CHANGEABLE MESSAGE SIGN 882(A) 8306 SD 130.000 130.000   0.000 $57.69 $0.00 $0.00
Subtotals For Category     0301/TEMPORARY TRAFFIC - BTOP-224N(001)    $3,402.31 $3,402.31
Subtotals For Project BTOP-224N(001) /28128(39) $427,504.56 $427,504.56