Report_Id:   234305   Est NO  0018

Date:01/21/2025

COMMONWEALTH OF KENTUCKY

TRANSPORTATION CABINET


Contract ID 234305 Estimate Number 0018 Estimate Type PROGRESS
District Office LOUISVILLE (05380)  Barnett, Joseph W.

Contractor MAC CONSTRUCTION & EXCAVATING INC ADDR SN 0 VC Code KY0028406
EXCAVATING INC
PO BOX 6787
NEW ALBANY , IN , 47151-6787
Pay Period 12/13/2024  TO  12/31/2024
Date Approved 01/10/2025
Primary Proj Number 0503704212201
Project No. HSIP 4201(087)
Primary County FRANKLIN
Name of Road BALD KNOB ROAD (US 421)
Description FROM 0.095 MILES NORTH OF CLIFTY DRIVE EXTENDING NORTH TO KY 12
     
     
Date Let 07/20/2023 Formal Acceptance
Date Awarded 07/31/2023 Date Work Began 02/19/2023
Date Contract Executed 08/29/2023 Open To Traffic
Date NTP Issued 08/29/2023 Actual Completion Date

Current Contract Amount

$3,555,350.00

Total to Date

Prev to Date

This Estimate

Original Amount

$3,420,000.00

Total Earnings

$2,673,229.84

$2,554,818.22

$118,411.62

Percent Complete

77.07

Stockpiled Materials

$66,860.27

$93,023.08

$-26,162.81

Funds Available

$815,259.89

Gross Earnings

$2,740,090.11

$2,647,841.30

$92,248.81

Total Change Orders

$135,350.00

Other Adjustments

$0.00

$0.00

$0.00

TOTAL

$2,740,090.11

$2,647,841.30

$92,248.81

Contract Id 234305

Change Order Summary

County FRANKLIN
Estimate Nbr 0018 Project Number HSIP 4201(087)
Contractor MAC CONSTRUCTION & EXCAVATING INC Period 12/13/2024  TO  12/31/2024
 
 
CHANGE ORDERS HISTORY  
CHANGE ORDER NBR DESCRIPTION STATUS APPROVAL DATE TOTAL CO AMOUNT CONTRACT TIME ADJUSTED
001 Landslide correction Approved 06/25/2024 $135,350.00 17.0
 
 
 
 

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 234305

COMMONWEALTH OF KENTUCKY

County FRANKLIN
Contract Type ARHR   ASPHALT PAVEMENT & ROADWAY REHAB

TRANSPORTATION CABINET

Primary Project Number 0503704212201
Estimate Nbr 0018 Period 12/13/2024  TO  12/31/2024
Contractor MAC CONSTRUCTION & EXCAVATING INC
 
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category
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
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0001 PAVING
0005 DGA BASE 00001 TON 674.00 674.000 69.630 1,504.000 1,573.630 55.00 3,829.65 86,549.65
0010 CRUSHED AGGREGATE SIZE NO 2 00078 TON 415.00 415.000 99.020 325.840 424.860 55.00 5,446.10 23,367.30
0015 ASPHALT SEAL AGGREGATE 00100 TON 40.70 40.700 51.880 51.880 600.00 31,128.00
0020 ASPHALT SEAL COAT 00103 TON 4.86 4.860 0.000 0.000 4,000.00 0.00
0025 LEVELING & WEDGING PG64-22 00190 TON 205.00 205.000 139.530 139.530 165.00 23,022.45
0030 CL2 ASPH BASE 1.00D PG64-22 00212 TON 164.00 164.000 145.980 145.980 240.00 35,035.20
0035 CL2 ASPH SURF 0.38D PG64-22 00301 TON 229.00 229.000 354.190 354.190 250.00 88,547.50
0040 ASPHALT MATERIAL FOR TACK 00356 TON 2.10 2.100 0.800 0.800 1.00 0.80
0045 ASPHALT WEDGE CURB 01897 LF 1,165.00 1,165.000 1,319.000 1,319.000 16.00 21,104.00
0050 MOBILIZATION FOR MILL & TEXT (FRANKLIN US 421) 02676 LS 1.00 1.000 0.000 0.000 4,900.00 0.00
0055 ASPHALT PAVE MILLING & TEXTURING 02677 TON 225.00 225.000 197.000 197.000 120.00 23,640.00
0060 EDGELINE RUMBLE STRIPS 02697 LF 2,525.00 2,525.000 0.000 0.000 3.50 0.00
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0002 ROADWAY
0065 REMOVE TREES OR STUMPS 02460 EACH 2.00 2.000 2.000 2.000 7,000.00 14,000.00
0070 CHANNEL LINING CLASS II 02483 TON 258.00 258.000 0.000 0.000 200.00 0.00
0075 TEMPORARY SIGNS 02562 SQFT 300.00 300.000 316.000 316.000 12.00 3,792.00
0080 FABRIC-GEOTEXTILE CLASS 2 02603 SQYD 1,596.00 2,046.000 1,452.900 1,452.900 3.00 4,358.70
0085 MAINTAIN & CONTROL TRAFFIC (FRANKLIN US 421) 02650 LS 1.00 1.000 0.700 0.700 910,000.00 637,000.00
0090 PORTABLE CHANGEABLE MESSAGE SIGN 02671 EACH 2.00 2.000 2.000 2.000 9,000.00 18,000.00
0095 TEMP SILT FENCE 02701 LF 15,399.00 15,399.000 390.000 390.000 2.50 975.00
0100 SILT TRAP TYPE A 02703 EACH 6.00 6.000 0.000 0.000 700.00 0.00
0105 SILT TRAP TYPE B 02704 EACH 6.00 6.000 0.000 0.000 700.00 0.00
0110 SILT TRAP TYPE C 02705 EACH 6.00 6.000 0.000 0.000 720.00 0.00
0115 CLEAN SILT TRAP TYPE A 02706 EACH 6.00 6.000 0.000 0.000 1.00 0.00
0120 CLEAN SILT TRAP TYPE B 02707 EACH 6.00 6.000 0.000 0.000 1.00 0.00
0125 CLEAN SILT TRAP TYPE C 02708 EACH 6.00 6.000 0.000 0.000 1.00 0.00
0130 STAKING (FRANKLIN US 421) 02726 LS 1.00 1.000 0.700 0.700 49,814.01 34,869.80
0135 RAILROAD RAILS-DRILLED 03234 LF 9,660.00 11,240.000 11,255.000 11,255.000 37.50 422,062.50
0140 EXCAVATION AND BACKFILL 03235 CUYD 330.00 434.000 40.000 363.150 403.150 100.00 4,000.00 40,315.00
0145 CRIBBING 03236 SQFT 4,230.00 6,102.000 800.000 7,641.000 8,441.000 12.50 10,000.00 105,512.50
0150 BASE FAILURE REPAIR 03240 SQYD 135.00 317.000 317.000 317.000 225.00 71,325.00
0155 TEMP SIGNAL 2 PHASE 04933 EACH 1.00 1.000 0.000 0.000 35,000.00 0.00
0160 TEMP SIGNAL MULTI PHASE 04934 EACH 1.00 1.000 1.000 1.000 45,000.00 45,000.00
0165 EROSION CONTROL BLANKET 05950 SQYD 10,653.00 10,653.000 0.000 0.000 3.10 0.00
0170 TEMP MULCH 05952 SQYD 19,684.00 19,684.000 0.000 0.000 0.24 0.00
0175 TEMP SEEDING AND PROTECTION 05953 SQYD 14,763.00 14,763.000 0.000 0.000 0.25 0.00
0180 INITIAL FERTILIZER 05963 TON 0.17 0.170 0.000 0.000 1,200.00 0.00
0185 MAINTENANCE FERTILIZER 05964 TON 0.10 0.100 0.000 0.000 1,200.00 0.00
0190 SEEDING AND PROTECTION 05985 SQYD 17,806.00 17,806.000 236.900 236.900 0.68 161.09
0195 SODDING 05990 SQYD 1,065.00 1,065.000 0.000 0.000 12.21 0.00
0200 PAVE STRIPING-TEMP PAINT-4 IN 06510 LF 4,760.00 4,760.000 2,823.000 2,823.000 0.22 621.06
0205 PAVE STRIPING-PERM PAINT-6 IN 06515 LF 123,192.00 123,192.000 0.000 0.000 0.27 0.00
0210 RETAINING WALL (STANDARD GRAVITY OR POLYPROPYLENE BARRI 08018 SQFT 400.00 400.000 576.000 576.000 250.00 144,000.00
0215 SHOULDER MILLING/TRENCHING 20748ED SQYD 554.00 554.000 437.300 437.300 50.00 21,865.00
0220 ROADSIDE REGRADING 26175EC LF 855.00 855.000 267.000 267.000 85.00 22,695.00
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0003 DRAINAGE
0225 CULVERT PIPE-18 IN 00462 LF 6.00 6.000 16.000 16.000 750.00 12,000.00
0230 PIPE CULVERT HEADWALL-18 IN 01204 EACH 1.00 1.000 1.000 1.000 2,500.00 2,500.00
0235 REMOVE PIPE 01310 LF 4.00 4.000 0.000 0.000 400.00 0.00
0240 FLUME INLET TYPE 2 01691 EACH 4.00 4.000 4.000 4.000 7,000.00 28,000.00
0245 REMOVE HEADWALL 02625 EACH 1.00 1.000 1.000 1.000 1,000.00 1,000.00
0250 FITTINGS 21819NN EACH 1.00 1.000 0.000 0.000 750.00 0.00
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0004 SIGNING
0255 SBM ALUM SHEET SIGNS .080 IN 06406 SQFT 1,884.19 1,884.190 0.000 0.000 49.98 0.00
0260 SBM ALUM SHEET SIGNS .125 IN 06407 SQFT 5.56 5.560 0.000 0.000 71.38 0.00
0265 STEEL POST TYPE 1 06410 LF 3,965.00 3,965.000 0.000 0.000 31.92 0.00
0270 REMOVE SIGN 21373ND EACH 89.00 89.000 0.000 0.000 50.00 0.00
0275 BARCODE SIGN INVENTORY 24631EC EACH 451.00 451.000 0.000 0.000 40.82 0.00
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0005 GUARDRAIL
0280 DELINEATOR FOR GUARDRAIL BI DIRECTIONAL WHITE 01987 EACH 366.00 366.000 41.000 265.000 306.000 12.60 516.60 3,855.60
0285 SITE PREPARATION (EMBED EXISTING GUARDRAIL POST) 02187 EACH 249.00 249.000 128.000 711.000 839.000 5.67 725.76 4,757.13
0290 GUARDRAIL TERMINAL SECTION NO 1 02360 EACH 41.00 41.000 9.000 40.000 49.000 82.20 739.80 4,027.80
0295 GUARDRAIL END TREATMENT TYPE 1 02367 EACH 5.00 5.000 3.000 10.000 13.000 3,939.64 11,818.92 51,215.32
0300 GUARDRAIL END TREATMENT TYPE 2A 02369 EACH 2.00 2.000 0.000 0.000 1,063.56 0.00
0305 GUARDRAIL END TREATMENT TYPE 7 02371 EACH 3.00 3.000 3.000 3.000 1,575.26 4,725.78
0310 REMOVE GUARDRAIL 02381 LF 16,850.00 16,850.000 937.500 15,198.800 16,136.300 3.30 3,093.75 53,249.79
0315 GUARDRAIL END TREATMENT TYPE 4A 02391 EACH 25.00 25.000 0.000 0.000 4,724.67 0.00
0320 EXTRA LENGTH GUARDRAIL POST 02399 EACH 249.00 249.000 82.000 244.000 326.000 122.18 10,018.76 39,830.68
0325 GUARDRAIL-BRIDGE CASE I 08805 LF 50.00 50.000 0.000 0.000 182.36 0.00
0330 G/R STEEL W BEAM-S FACE (7 FT POST) 21802EN LF 17,095.00 17,095.000 2,022.000 14,253.050 16,275.050 33.74 68,222.28 549,120.18
Project 0503704212201 Fed/State Project Number HSIP 4201(087) Category 0006 DEMOBILIZATION
0335 DEMOBILIZATION 02569 LS 1.00 1.000 0.000 0.000 55,000.00 0.00

SUBTOT

$118,411.62

$2,673,229.84

LNNBR STOCKPILE ADJUSTMENTS

UNIT

ADJ. QUANTITY

EST NBR

UNIT PRICE

ADJUSTED AMOUNT

0290-1-0I

GRDRAIL ACCESSORIES

EACH

41.00 0004 $42.750000 $1,752.75

0295-1-0I

GUARDRAIL END TR 1

EACH

5.00 0004 $1900.000000 $9,500.00

0300-1-0I

GUARDRAIL END TR 2A

EACH

2.00 0004 $546.250000 $1,092.50

0315-1-0I

GUARDRAIL END TR 4A

EACH

25.00 0004 $1995.000000 $49,875.00

0320-1-0I

GUARDRAIL, POST STE

EACH

249.00 0004 $67.450000 $16,795.00

0330-1-0I

GDRAIL GALV AW .109

FT

17,095.00 0004 $12.730000 $217,619.35

0295-1-0A

GUARDRAIL END TR 1

EACH

1.00 0006 $1900.000000 $-1,900.00

0330-1-0A

GDRAIL GALV AW .109

FT

387.00 0006 $12.730000 $-4,926.51

0290-1-0A

GRDRAIL ACCESSORIES

EACH

14.00 0012 $42.750000 $-598.50

0295-1-0A

GUARDRAIL END TR 1

EACH

1.00 0012 $1900.000000 $-1,900.00

0320-1-0A

GUARDRAIL, POST STE

EACH

26.00 0012 $67.450000 $-1,753.69

0330-1-0A

GDRAIL GALV AW .109

FT

3,182.50 0012 $12.730000 $-40,513.23

0290-1-0A

GRDRAIL ACCESSORIES

EACH

3.00 0013 $42.750000 $-128.25

0295-1-0A

GUARDRAIL END TR 1

EACH

2.00 0013 $1900.000000 $-3,800.00

0320-1-0A

GUARDRAIL, POST STE

EACH

13.00 0013 $67.450000 $-876.85

0330-1-0A

GDRAIL GALV AW .109

FT

1,002.50 0013 $12.730000 $-12,761.83

0290-1-0A

GRDRAIL ACCESSORIES

EACH

5.00 0014 $42.750000 $-213.75

0295-1-0A

GUARDRAIL END TR 1

EACH

1.00 0014 $1900.000000 $-1,900.00

0320-1-0A

GUARDRAIL, POST STE

EACH

31.00 0014 $67.450000 $-2,090.94

0330-1-0A

GDRAIL GALV AW .109

FT

2,731.25 0014 $12.730000 $-34,768.81

0290-1-0A

GRDRAIL ACCESSORIES

EACH

6.00 0015 $42.750000 $-256.50

0320-1-0A

GUARDRAIL, POST STE

EACH

38.00 0015 $67.450000 $-2,563.09

0330-1-0A

GDRAIL GALV AW .109

FT

2,165.00 0015 $12.730000 $-27,560.45

0290-1-0A

GRDRAIL ACCESSORIES

EACH

7.00 0016 $42.750000 $-299.25

0320-1-0A

GUARDRAIL, POST STE

EACH

94.00 0016 $67.450000 $-6,340.28

0330-1-0A

GDRAIL GALV AW .109

FT

2,628.80 0016 $12.730000 $-33,464.62

0290-1-0A

GRDRAIL ACCESSORIES

EACH

4.00 0017 $42.750000 $-171.00

0320-1-0A

GUARDRAIL, POST STE

EACH

42.00 0017 $67.450000 $-2,832.89

0330-1-0A

GDRAIL GALV AW .109

FT

1,727.50 0017 $12.730000 $-21,991.08

0290-1-0A

GRDRAIL ACCESSORIES

EACH

2.00 0018 $42.750000 -85.50 $-85.50

0320-1-0A

GUARDRAIL, POST STE

EACH

5.00 0018 $67.450000 -337.26 $-337.26

0330-1-0A

GDRAIL GALV AW .109

FT

2,022.00 0018 $12.730000 -25,740.06 $-25,740.06
SUBTOT

$66,860.26