Contract ID: | 120074 | Estimate Number: | 0007 | 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 MILES. | ||||||||||||
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: | 02/01/2013 TO 12/31/2013 |
Date Awarded: | 03/05/2012 | Date Work Began: | 06/12/2012 | Original Contract Time: | 95 |
Date Contract Executed: | 03/20/2012 | Date Time Stopped: | 11/12/2013 | Current Time Charged: | 225.00 |
Date NTP Issued: | 04/23/2012 | Completion Date: | 11/12/2013 | Current Time Allowed: | 196.00 |
General Liability Expires: | 10/18/2014 | Workman's Comp Expires: | 10/18/2014 | Percent Time Used: | 114.80 % |
Specification Year: | 2009 | Date Approved: | |||
Bid Amount: | $952,036.39 | Total to Date | Prev to Date | This Estimate | |||
Funds Available (Bid + Positive C/O): | $952,036.39 | Participating: | $0.00 | $0.00 | $0.00 | ||
Percent Complete: | 89.89 % | Non Participating: | $952,288.81 | $944,470.76 | $7,818.05 | ||
Unearned Balance: | $96,247.58 | Total Earnings: | $952,288.81 | $944,470.76 | $7,818.05 | ||
Stockpiled Materials: | $0.00 | $0.00 | $0.00 | ||||
Gross Earnings: | $952,288.81 | $944,470.76 | $7,818.05 | ||||
Other Adjustments: | $182,000.00 | $0.00 | $182,000.00 | ||||
Liq Dam/Disincentive: | $-278,500.00 | $-329,000.00 | $50,500.00 | ||||
TOTAL: | $855,788.81 | $615,470.76 | $240,318.05 |
Contract ID: | 120074 | Estimate Number: | 0007 | Primary JP: | 28128(46) | |||
CHANGE ORDER HISTORY | |||||
Change Order Nbr. | Change Order Description | Status | Approval Date | Contract Time Adjustment | Total Change Order Amount |
001 | Change Order for Disincentive & LD adjustments | Approved | 12/13/2013 | 192.0 | $0.00 |
002 | Change Order for Patch Panel, Seed & Mulch | Approved | 01/08/2014 | 0.0 | $-119.20 |
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 |
System Application of Liquidated Damages | 0003 | --30 | $500.00 | $-15,000.00 |
System Application of Liquidated Damages | 0004 | --46 | $500.00 | $-23,000.00 |
System Application of Liquidated Damages | 0005 | --30 | $500.00 | $-15,000.00 |
System Application of Liquidated Damages | 0006 | --16 | $500.00 | $-8,000.00 |
System Application of Liquidated Damages | 0007 | -101 | $500.00 | $50,500.00 | Subtotals For Liquidated Damages | $-14,500.00 |
CONTRACT ADJUSTMENTS HISTORY | ||
Adjustment Description | Estimate Nbr | Adjustment Amount |
Milstone Adjust. (C/O) | 0007 | $182,000.00 | Subtotals For Contract Adjustments | $182,000.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 | 12/04/2012 | 156.00 DYS | $2,000.00 | Y | |||
02 | Fiber Optic Cable Installation | 11/29/2012 | 12/21/2012 | 30.00 DYS | $2,000.00 | Y |
MILESTONE ADJUSTMENTS | |||
Milestone Number | Milestone Adjustment Description | Estimate Nbr | Total |
01 | System Application of Disincentive Adj | 0002 | $-74,000.00 |
01 | System Application of Disincentive Adj | 0003 | $-60,000.00 |
01 | System Application of Disincentive Adj | 0004 | $-92,000.00 |
01 | System Application of Disincentive Adj | 0005 | $-38,000.00 | Subtotals For Milestones | $-264,000.00 |
Contract ID: | 120074 | Estimate Number: | 0007 | 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 | 0.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 | 859.000 | $6.09 | $0.00 | $5,231.31 | |
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 | -1.360 | 5.200 | $139.41 | $-189.60 | $724.93 |
0006 | 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED | 802(A) 8316 | LF | 1,702.000 | 1,702.000 | 1,497.000 | $69.99 | $0.00 | $104,775.03 | |
0007 | 3" GALV. STEEL ELECTRICAL CONDUIT PUSHED OR BORED | 802(A) 8318 | LF | 100.000 | 100.000 | 420.000 | $16.16 | $0.00 | $6,787.20 | |
0008 | 1 1/2" HIGH DENSITY PE PIPE - BORED | 802(C) 8551 | LF | 12,577.000 | 12,577.000 | 15,509.000 | $10.75 | $0.00 | $166,721.76 | |
0009 | 1 1/2" HIGH DENSITY PE PIPE - TRENCHED | 802(C) 8556 | LF | 37,628.000 | 37,628.000 | 0.000 | 59,415.000 | $3.56 | $0.00 | $211,517.40 |
0010 | 1 1/2" HIGH DENSITY PE PIPE - PLOWED | 802(C) 8565 | LF | 101,668.000 | 101,668.000 | 78,263.000 | $2.28 | $0.00 | $178,439.64 | |
0011 | GROUND BOX (R3248) | 803(B) 8135 | EA | 39.000 | 39.000 | 38.000 | $975.14 | $0.00 | $37,055.32 | |
0012 | GROUND BOX (B2-48) | 803(B) 8150 | EA | 16.000 | 16.000 | 8.000 | $1,073.68 | $0.00 | $8,589.44 | |
0013 | REINFORCING STEEL | 804(B) 2916 | LB | 192.000 | 192.000 | 144.000 | 144.000 | $5.54 | $797.76 | $797.76 |
0014 | (SP)FIBER OPTIC CABLE, 24 SMF | 818(A) 8715 | LF | 2,757.000 | 2,757.000 | 1,906.000 | $0.69 | $0.00 | $1,315.14 | |
0015 | (SP)FIBER OPTIC CABLE, 96 SMF | 818(A) 8730 | LF | 161,447.000 | 161,447.000 | 162,556.000 | $0.73 | $0.00 | $118,665.88 | |
0016 | (SP) FIBER OPTIC CABLE, 24 INDOOR/OUTDOOR PLENUM | 818(A) 8738 | LF | 300.000 | 300.000 | 250.000 | $1.93 | $0.00 | $482.50 | |
0017 | (SP) FIBER OPTIC CABLE, 48 INDOOR/OUTDOOR PLENUM | 818(A) 8739 | LF | 1,200.000 | 1,200.000 | 734.000 | $1.93 | $0.00 | $1,416.62 | |
0018 | (SP)FIBER OPTIC PATCH PANEL, 24 PORT | 818(B) 8745 | EA | 1.000 | 1.000 | 1.000 | $1,116.38 | $0.00 | $1,116.38 | |
0019 | (SP)FIBER OPTIC CABLE SPLICE | 818(C) 8735 | EA | 8.000 | 8.000 | 11.000 | $2,154.58 | $0.00 | $23,700.38 | |
0020 | (SP)FIBER OPTIC CABLE TERMINATION | 818(D) 8740 | EA | 200.000 | 200.000 | 200.000 | $230.67 | $0.00 | $46,134.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 | 11.000 | $244.45 | $0.00 | $2,688.95 | |
0023 | (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION | 818(G) 5570 | EA | 177.000 | 177.000 | 145.000 | $87.95 | $0.00 | $12,752.75 | |
8000 | (SP)FIBER OPTIC PATCH PANEL, 96 PORT | 818(B) 8755 | EA | 0.000 | 1.000 | 1.000 | 1.000 | $1,914.49 | $1,914.49 | $1,914.49 |
8001 | VEGETATIVE MULCHING | 233(A) 2817 | AC | 0.000 | 3.340 | 3.340 | 3.340 | $816.83 | $2,728.21 | $2,728.21 |
Subtotals For Category 0300/TRAFFIC | $5,250.86 | $933,555.09 | ||||||||
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 | 0.000 | 0.000 | $20.63 | $0.00 | $0.00 | |
0025 | FLAGGER | 880(I) 8902 | SD | 35.000 | 35.000 | 16.000 | $206.25 | $0.00 | $3,300.00 | |
0026 | CONSTRUCTION TRAFFIC CONTROL | 880(J) 8905 | LSUM | 1.000 | 1.000 | 0.250 | 1.000 | $6,500.00 | $1,625.00 | $6,500.00 |
0027 | PORT.CHANGEABLE MESSAGE SIGN | 882(A) 8306 | SD | 130.000 | 130.000 | 16.000 | $10.31 | $0.00 | $164.96 | |
Subtotals For Category 0301/TEMPORARY TRAFFIC | $1,625.00 | $9,964.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.250 | 1.000 | $3,768.75 | $942.19 | $3,768.76 |
0029 | MOBILIZATION | 641 1552 | LSUM | 1.000 | 1.000 | 1.000 | $5,000.00 | $0.00 | $5,000.00 | |
Subtotals For Category 0640/CONSTRUCTION | $942.19 | $8,768.76 | ||||||||
Subtotals For Project BTOP-261B(002) /28128(46) | $7,818.05 | $952,288.81 |