| Contract ID: | 120076 | Estimate Number: | 0004 | Contract No: | 711055 | |||
| Residency: | COBB ENGINEERING CO., INC. (03003) | Estimate Type: | Progressive | Account No: | 404300 | |||
| Project Number(s): | BTOP-267N(001) | ||||||||||||
| Primary Job Piece No: | 28128(32) | ||||||||||||
| Contract Description: | SAFETY IMPROVEMENTS (FIBER OPTIC CABLE) US-270/SH-99: US-270 FROM SEMINOLE STATE COLLEGE IN SEMINOLE EAST TO SH-99, THEN NORTH ON SH-99 TO I-40. PROJECT LENGTH = 11.3 MILES. | ||||||||||||
| Primary County: | SEMINOLE | ||||||||||||
| Name of Road: | US-270 / SH-99 | ||||||||||||
| Prime Contractor: | BEAR COMMUNICATIONS, LLC | ||||||||||||
| 725 N 2ND ST SUITE M | |||||||||||||
| LAWRENCE , KS 66044 | |||||||||||||
| Surety Company: | THE CINCINNATI INSURANCE CO. | ||||||||||||
| Date Let: | 03/15/2012 | NTP Effective Date: | 05/21/2012 | Pay Period: | 07/01/2013 TO 01/13/2014 |
| Date Awarded: | 04/02/2012 | Date Work Began: | 05/28/2012 | Original Contract Time: | 35 |
| Date Contract Executed: | 04/10/2012 | Date Time Stopped: | 06/19/2013 | Current Time Charged: | 231.00 |
| Date NTP Issued: | 04/23/2012 | Completion Date: | 06/19/2013 | Current Time Allowed: | 215.00 |
| General Liability Expires: | 10/18/2014 | Workman's Comp Expires: | 10/18/2014 | Percent Time Used: | 107.44 % |
| Specification Year: | 2009 | Date Approved: | |||
| Bid Amount: | $576,938.70 | Total to Date | Prev to Date | This Estimate | |||
| Funds Available (Bid + Positive C/O): | $576,938.70 | Participating: | $425,267.55 | $446,402.87 | $-21,135.32 | ||
| Percent Complete: | 68.30 % | Non Participating: | $26,781.00 | $0.00 | $26,781.00 | ||
| Unearned Balance: | $182,890.15 | Total Earnings: | $452,048.55 | $446,402.87 | $5,645.68 | ||
| Stockpiled Materials: | $0.00 | $0.00 | $0.00 | ||||
| Gross Earnings: | $452,048.55 | $446,402.87 | $5,645.68 | ||||
| Other Adjustments: | $360,000.00 | $452,500.00 | $-92,500.00 | ||||
| Liq Dam/Disincentive: | $-418,000.00 | $-508,000.00 | $90,000.00 | ||||
| TOTAL: | $394,048.55 | $390,902.87 | $3,145.68 | ||||
| Contract ID: | 120076 | Estimate Number: | 0004 | Primary JP: | 28128(32) | |||
| CHANGE ORDER HISTORY | |||||
| Change Order Nbr. | Change Order Description | Status | Approval Date | Contract Time Adjustment | Total Change Order Amount |
| 001 | Excess Material into Warehouse Stock | Approved | 12/16/2013 | 0.0 | $-13,897.16 |
| 002 | Time Adjustment due to lower Production Rates | Approved | 01/10/2014 | 360.0 | $0.00 |
| 003 | F.Q.C.O. | Pending | 0 | 0.0 | $-110,992.99 |
| 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 | --196 | $500.00 | $-98,000.00 |
| System Application of Liquidated Damages | 0004 | -180 | $500.00 | $90,000.00 | Subtotals For Liquidated Damages | $-8,000.00 |
| CONTRACT ADJUSTMENTS HISTORY | ||
| Adjustment Description | Estimate Nbr | Adjustment Amount |
| LD Adjustment (Prog. Est. Only) | 0002 | $74,000.00 |
| Milestone Adjust. (Prog. Est. Only) | 0002 | $202,000.00 |
| Milestone Adjust. (Prog. Est. Only) | 0002 | $132,000.00 |
| Milestone Adjust. (Prog. Est. Only) | 0003 | $28,000.00 |
| LD Adjustment (Prog. Est. Only) | 0003 | $16,500.00 |
| Milestone Adjust. (Prog. Est. Only) | 0004 | $-92,500.00 | Subtotals For Contract Adjustments | $360,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/20/2012 | 10/31/2012 | 154.00 DYS | $2,000.00 | Y | |||
| 02 | Fiber Optic Cable Installation | 10/31/2012 | 01/15/2013 | 61.00 DYS | $2,000.00 | Y | |||
| MILESTONE ADJUSTMENTS | |||
| Milestone Number | Milestone Adjustment Description | Estimate Nbr | Total |
| 01 | System Application of Disincentive Adj | 0002 | $-278,000.00 |
| 02 | System Application of Disincentive Adj | 0002 | $-132,000.00 | Subtotals For Milestones | $-410,000.00 |
| Contract ID: | 120076 | Estimate Number: | 0004 | Primary JP: | 28128(32) | |||
| 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-267N(001) | Project: 28128(32) | Category: 0300/TRAFFIC | ||||||||
| 0001 | CLEARING AND GRUBBING | 201(A) 0102 | LSUM | 1.000 | 1.000 | 1.000 | $9,100.00 | $0.00 | $9,100.00 | |
| 0002 | TEMPORARY SILT FENCE | 221(C) 2801 | LF | 2,000.000 | 2,000.000 | 0.000 | 520.000 | $6.22 | $0.00 | $3,234.40 |
| 0003 | SOLID SLAB SODDING | 230(A) 2806 | SY | 2,000.000 | 2,000.000 | 33.330 | $6.43 | $0.00 | $214.31 | |
| 0004 | CLASS A CONCRETE | 509(B) 0321 | CY | 20.000 | 20.000 | 0.000 | $150.27 | $0.00 | $0.00 | |
| 0005 | 3" GALV. STEEL ELECTRICAL CONDUIT EXPOSED | 802(A) 8316 | LF | 275.000 | 275.000 | 262.000 | $85.92 | $0.00 | $22,511.04 | |
| 0006 | 1 1/2" HIGH DENSITY PE PIPE - BORED | 802(C) 8551 | LF | 7,284.000 | 7,284.000 | -1,265.000 | 5,977.000 | $12.99 | $-16,432.35 | $77,641.23 |
| 0007 | 1 1/2" HIGH DENSITY PE PIPE - TRENCHED | 802(C) 8556 | LF | 5,000.000 | 5,000.000 | -514.000 | 3,490.000 | $4.57 | $-2,348.98 | $15,949.30 |
| 0008 | 1 1/2" HIGH DENSITY PE PIPE - PLOWED | 802(C) 8565 | LF | 64,669.000 | 64,669.000 | -361.000 | 52,365.000 | $3.20 | $-1,155.20 | $167,568.00 |
| 0009 | GROUND BOX (R3248) | 803(B) 8135 | EA | 43.000 | 21.000 | -3.000 | 18.000 | $838.03 | $-2,514.09 | $15,084.54 |
| 0010 | GROUND BOX (B2-48) | 803(B) 8150 | EA | 25.000 | 0.000 | 0.000 | $889.66 | $0.00 | $0.00 | |
| 0011 | REINFORCING STEEL | 804(B) 2916 | LB | 360.000 | 360.000 | 0.000 | $5.74 | $0.00 | $0.00 | |
| 0012 | (SP)FIBER OPTIC CABLE, 96 SMF | 818(A) 8730 | LF | 69,435.000 | 69,435.000 | -2,140.000 | 72,094.000 | $0.98 | $-2,097.20 | $70,652.12 |
| 0013 | (SP)FIBER OPTIC PATCH PANEL, 96 PORT | 818(B) 8755 | EA | 2.000 | 2.000 | 2.000 | $1,536.60 | $0.00 | $3,073.20 | |
| 0014 | (SP)FIBER OPTIC CABLE TERMINATION | 818(D) 8740 | EA | 192.000 | 192.000 | 192.000 | $70.97 | $0.00 | $13,626.24 | |
| 0015 | (SP) SHIELD ISOLATION PEDESTAL | 818(F) 8370 | EA | 5.000 | 5.000 | 0.000 | $236.40 | $0.00 | $0.00 | |
| 0016 | (SP) SHIELD ISOLATION PEDESTAL (MINI) | 818(F) 8375 | EA | 9.000 | 9.000 | 3.000 | $189.63 | $0.00 | $568.89 | |
| 0017 | (SP)FIBER OPTIC ROUTE SIGN & INSTALLATION | 818(G) 5570 | EA | 62.000 | 62.000 | 64.000 | $103.27 | $0.00 | $6,609.28 | |
| Subtotals For Category 0300/TRAFFIC | $-24,547.82 | $405,832.55 | ||||||||
| Fed/State Project Number: BTOP-267N(001) | Project: 28128(32) | Category: 0301/TRAFFIC CONTROL | ||||||||
| 0018 | (PL)TRUCK MOUNTED ATTENUATOR | 876(A) 8482 | SD | 50.000 | 50.000 | 0.000 | $110.50 | $0.00 | $0.00 | |
| 0019 | FLAGGER | 880(I) 8902 | SD | 15.000 | 15.000 | 0.000 | $572.00 | $0.00 | $0.00 | |
| 0020 | CONSTRUCTION TRAFFIC CONTROL | 880(J) 8905 | LSUM | 1.000 | 1.000 | 1.000 | $4,680.00 | $0.00 | $4,680.00 | |
| 0021 | PORT.CHANGEABLE MESSAGE SIGN | 882(A) 8306 | SD | 50.000 | 50.000 | 0.000 | $71.50 | $0.00 | $0.00 | |
| Subtotals For Category 0301/TRAFFIC CONTROL | $0.00 | $4,680.00 | ||||||||
| Fed/State Project Number: BTOP-267N(001) | Project: 28128(32) | Category: 0640/CONSTRUCTION | ||||||||
| 0022 | SWPPP DOCUMENTATION AND MANAGEMENT | 220 2800 | LSUM | 1.000 | 1.000 | 0.250 | 1.000 | $13,650.00 | $3,412.50 | $13,650.00 |
| 0023 | MOBILIZATION | 641 1552 | LSUM | 1.000 | 1.000 | 1.000 | $1,105.00 | $0.00 | $1,105.00 | |
| Subtotals For Category 0640/CONSTRUCTION | $3,412.50 | $14,755.00 | ||||||||
| Fed/State Project Number: BTOP-267N(001) | Project: 28128(32) | Category: 0900/FEDERAL NON PARTICIPATING | ||||||||
| 8000 | GROUND BOX (R3248) | 803(B) 8135 | EA | 0.000 | 22.000 | 22.000 | 22.000 | $473.00 | $10,406.00 | $10,406.00 |
| 8001 | GROUND BOX (B2-48) | 803(B) 8150 | EA | 0.000 | 25.000 | 25.000 | 25.000 | $607.00 | $15,175.00 | $15,175.00 |
| 8002 | CONSTRUCTION MISCELLANEOUS | 104 0700 | LSUM | 0.000 | 1.000 | 1.000 | 1.000 | $1,200.00 | $1,200.00 | $1,200.00 |
| Subtotals For Category 0900/FEDERAL NON PARTICIPATING | $26,781.00 | $26,781.00 | ||||||||
| Subtotals For Project BTOP-267N(001) /28128(32) | $5,645.68 | $452,048.55 | ||||||||