|
Report_Id: 194311 Est NO 0005 |
Date:09/24/2020 |
COMMONWEALTH OF KENTUCKY
TRANSPORTATION CABINET
| Contract ID | 194311 | Estimate Number | 0005 | Estimate Type | PROGRESS | ||
| District Office | LEXINGTON (07320) Bidwell, Kyle S. | ||||||
| Contractor | BLUEGRASS ELECTRICAL CONSULTANTS INC | ADDR SN 0 VC Code KY0022642 | |||||
| CONSULTANTS INC | |||||||
| 1495 PRODUCTION DR | |||||||
| BURLINGTON , KY , 41005 | |||||||
| Pay Period | 06/11/2020 TO 09/02/2020 | ||||||
| Date Approved | 09/11/2020 | ||||||
| Primary Proj Number | 0311402311901 | ||||||
| Project No. | AID 6000 (154), AID 6000 (153), AID 6000 (153) | ||||||
| Primary County | MADISON | ||||||
| Name of Road | INSTALL OF DEDICATED DSRC SYSTEM ON KY-876, US-25, & US-231 | ||||||
| Description | INSTALLATION OF A DEDICATED SHORT RANGE COMMUNICATION SYSTEM ON US-231 FROM MILEPOINT 6.600 EXTENDING NORTHWEST TO MILEP | ||||||
| Date Let | 11/22/2019 | Formal Acceptance | |||||
| Date Awarded | 12/06/2019 | Date Work Began | 02/24/2020 | ||||
| Date Contract Executed | 01/13/2020 | Open To Traffic | |||||
| Date NTP Issued | 01/13/2020 | Actual Completion Date | |||||
| Current Contract Amount | $763,429.00 |
Total to Date |
Prev to Date |
This Estimate |
||
| Original Amount | $763,429.00 |
Total Earnings | $398,567.50 |
$157,395.50 |
$241,172.00 |
|
| Percent Complete | 52.21 |
Stockpiled Materials | $0.00 |
$0.00 |
$0.00 |
|
| Funds Available | $364,861.50 |
Gross Earnings | $398,567.50 |
$157,395.50 |
$241,172.00 |
|
| Total Change Orders | $0.00 |
Other Adjustments | $0.00 |
$0.00 |
$0.00 |
|
| TOTAL | $398,567.50 |
$157,395.50 |
$241,172.00 |
|||
| Contract Id | 194311 | Change Order Summary |
County | MADISON | ||||||
| Estimate Nbr | 0005 | Project Number | AID 6000 (154), AID 6000 (153), AID 6000 (153) | |||||||
| Contractor | BLUEGRASS ELECTRICAL CONSULTANTS INC | Period | 06/11/2020 TO 09/02/2020 | |||||||
| CHANGE ORDERS HISTORY | ||||||||||
| CHANGE ORDER NBR | DESCRIPTION | STATUS | APPROVAL DATE | TOTAL CO AMOUNT | CONTRACT TIME ADJUSTED | |||||
CONTRACT ADJUSTMENTS HISTORY
| Contract Adjustments |
|
|
| Adjustment Description | Est No |
Adjustment Amount |
| Line Item Adjustments History | |||||||||
| PROJECT | ITEM NBR | DESCRPITION | TYPE | EST NO | ADJ QUANTITY |
UNIT PRICE |
ADJUSTED AMOUNT |
||
| Contract Id | 194311 | COMMONWEALTH OF KENTUCKY |
County | MADISON | ||||||
| Contract Type | SLS SIGNS-LIGHTING-SIGNALS | TRANSPORTATION CABINET |
Primary Project Number | 0311402311901 | ||||||
| Estimate Nbr | 0005 | Period | 06/11/2020 TO 09/02/2020 | |||||||
| Contractor | BLUEGRASS ELECTRICAL CONSULTANTS INC | |||||||||
| Project | 0311402311901 | Fed/State Project Number | AID 6000 (154) | Category | 0001 INTELLIGENT TRANSPORTATION SYSTEMS | |||||||
| LINE ITEM NUMBER | ITEM DESCRIPTION | ITEM NO. | UNIT | PLAN QTY | CURRENT QUANTITY | QUANTITY PAID THIS EST | QUANTITY PAID PREV. EST | QUANTITY PAID TO DATE | UNIT PRICE | AMOUNT PAID THIS EST | AMOUNT PAID TO DATE | |
| 0095 | MAINTAIN & CONTROL TRAFFIC WARREN COUNTY US 231 | 02650 | LS | 1.00 | 1.000 | 0.750 | 0.750 | 16,000.00 | 12,000.00 | |||
| 0100 | DSRC ROADSIDE UNIT | 25038EC | EACH | 23.00 | 23.000 | 19.000 | 0.000 | 19.000 | 5,592.00 | 106,248.00 | 106,248.00 | |
| 0105 | CONNECTED VEHICLE MODULE FOR CONTROLLER | 25039EC | EACH | 23.00 | 23.000 | 0.000 | 0.000 | 1,185.00 | 0.00 | |||
| 0110 | SYSTEM CONFIGURATION | 25040EC | EACH | 23.00 | 23.000 | 4.000 | 0.000 | 4.000 | 2,975.00 | 11,900.00 | 11,900.00 | |
| 0115 | SYSTEM VALIDATION WARREN COUNTY US 231 | 25041EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 23,550.00 | 0.00 | |||
| 0120 | BURN-IN WARREN COUNTY US 231 | 25042EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 8,156.00 | 0.00 | |||
| 0125 | DSRC ON-BOARD UNITS | 25043EC | EACH | 2.00 | 2.000 | 0.000 | 0.000 | 5,174.00 | 0.00 | |||
| 0130 | MODIFY CABINET | 25044EC | EACH | 2.00 | 2.000 | 0.000 | 0.000 | 4,620.00 | 0.00 | |||
| 0140 | INSTALL CONTROLLER CABINET SERIAL | 23206EC | EACH | 2.00 | 2.000 | 2.000 | 2.000 | 4,620.00 | 9,240.00 | |||
| Project | 0311402311901 | Fed/State Project Number | AID 6000 (154) | Category | 0002 DEMOBILIZATION | |||||||
| 0135 | DEMOBILIZATION | 02569 | LS | 1.00 | 1.000 | 0.000 | 0.000 | 5,000.00 | 0.00 | |||
| SUBTOT | $118,148.00 |
$139,388.00 |
||||||||||
| LNNBR | STOCKPILE ADJUSTMENTS | UNIT |
ADJ. QUANTITY |
EST NBR |
UNIT PRICE | ADJUSTED AMOUNT |
||||||
| SUBTOT | $0.00 |
|||||||||||
| Project | 0707600251901 | Fed/State Project Number | AID 6000 (153) | Category | 0001 INTELLIGENT TRANSPORTATION SYSTEMS | |||||||
| LINE ITEM NUMBER | ITEM DESCRIPTION | ITEM NO. | UNIT | PLAN QTY | CURRENT QUANTITY | QUANTITY PAID THIS EST | QUANTITY PAID PREV. EST | QUANTITY PAID TO DATE | UNIT PRICE | AMOUNT PAID THIS EST | AMOUNT PAID TO DATE | |
| 0005 | MAINTAIN & CONTROL TRAFFIC MADISON COUNTY US 25 | 02650 | LS | 1.00 | 1.000 | 0.500 | 0.500 | 16,000.00 | 8,000.00 | |||
| 0010 | INSTALL RADAR DETECTION TY B | 24601EC | EACH | 20.00 | 20.000 | 20.000 | 20.000 | 1,700.00 | 34,000.00 | |||
| 0015 | DSRC ROADSIDE UNIT | 25038EC | EACH | 10.00 | 10.000 | 9.000 | 0.000 | 9.000 | 5,592.00 | 50,328.00 | 50,328.00 | |
| 0020 | CONNECTED VEHICLE MODULE FOR CONTROLLER | 25039EC | EACH | 10.00 | 10.000 | 0.000 | 0.000 | 1,185.00 | 0.00 | |||
| 0025 | SYSTEM CONFIGURATION | 25040EC | EACH | 10.00 | 10.000 | 0.750 | 0.750 | 2,975.00 | 2,231.25 | |||
| 0030 | SYSTEM VALIDATION MADISON COUNTY US 25 | 25041EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 10,931.00 | 0.00 | |||
| 0035 | BURN-IN MADISON COUNTY US 25 | 25042EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 4,400.00 | 0.00 | |||
| Project | 0707600251901 | Fed/State Project Number | AID 6000 (153) | Category | 0002 DEMOBILIZATION | |||||||
| 0040 | DEMOBILIZATION | 02569 | LS | 1.00 | 1.000 | 0.000 | 0.000 | 5,000.00 | 0.00 | |||
| SUBTOT | $50,328.00 |
$233,947.25 |
||||||||||
| LNNBR | STOCKPILE ADJUSTMENTS | UNIT |
ADJ. QUANTITY |
EST NBR |
UNIT PRICE | ADJUSTED AMOUNT |
||||||
| SUBTOT | $0.00 |
|||||||||||
| Project | 0707608761901 | Fed/State Project Number | AID 6000 (153) | Category | 0001 INTELLIGENT TRANSPORTATION SYSTEMS | |||||||
| LINE ITEM NUMBER | ITEM DESCRIPTION | ITEM NO. | UNIT | PLAN QTY | CURRENT QUANTITY | QUANTITY PAID THIS EST | QUANTITY PAID PREV. EST | QUANTITY PAID TO DATE | UNIT PRICE | AMOUNT PAID THIS EST | AMOUNT PAID TO DATE | |
| 0045 | MAINTAIN & CONTROL TRAFFIC MADISON COUNTY KY 876 | 02650 | LS | 1.00 | 1.000 | 0.250 | 0.250 | 16,000.00 | 4,000.00 | |||
| 0050 | INSTALL RADAR DETECTION TY B | 24601EC | EACH | 32.00 | 32.000 | 32.000 | 32.000 | 1,700.00 | 54,400.00 | |||
| 0055 | DSRC ROADSIDE UNIT | 25038EC | EACH | 16.00 | 16.000 | 13.000 | 4.000 | 17.000 | 5,592.00 | 72,696.00 | 95,064.00 | |
| 0060 | CONNECTED VEHICLE MODULE FOR CONTROLLER | 25039EC | EACH | 16.00 | 16.000 | 0.000 | 0.000 | 1,185.00 | 0.00 | |||
| 0065 | SYSTEM CONFIGURATION | 25040EC | EACH | 16.00 | 16.000 | 3.750 | 3.750 | 2,975.00 | 11,156.25 | |||
| 0070 | SYSTEM VALIDATION MADISON COUNTY KY 876 | 25041EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 17,006.00 | 0.00 | |||
| 0075 | BURN-IN MADISON COUNTY KY 876 | 25042EC | LS | 1.00 | 1.000 | 0.000 | 0.000 | 6,200.00 | 0.00 | |||
| 0080 | DSRC ON-BOARD UNITS | 25043EC | EACH | 5.00 | 5.000 | 0.000 | 0.000 | 5,174.00 | 0.00 | |||
| 0085 | MODIFY CABINET | 25044EC | EACH | 2.00 | 2.000 | 0.000 | 0.000 | 4,620.00 | 0.00 | |||
| Project | 0707608761901 | Fed/State Project Number | AID 6000 (153) | Category | 0002 DEMOBILIZATION | |||||||
| 0090 | DEMOBILIZATION | 02569 | LS | 1.00 | 1.000 | 0.000 | 0.000 | 5,000.00 | 0.00 | |||
| SUBTOT | $72,696.00 |
$398,567.50 |
||||||||||
| LNNBR | STOCKPILE ADJUSTMENTS | UNIT |
ADJ. QUANTITY |
EST NBR |
UNIT PRICE | ADJUSTED AMOUNT |
||||||
| SUBTOT | $0.00 |
|||||||||||