jagomart
digital resources
picture1_Excel Sheet Download 11488 | 2022 Hi Flap Application Ee Samples | Sample Application


 277x       Filetype XLSX       File size 0.21 MB       Source: highways.dot.gov


File: Excel Sheet Download 11488 | 2022 Hi Flap Application Ee Samples | Sample Application
sheet 1 read first instructions for cost estimate 1 choose a sample estimate that fits closest to your scope 2 update the following assumed delivery year 2027 current call for ...

icon picture XLSX Filetype Excel XLSX | Posted on 05 Jul 2022 | 3 years ago
Partial file snippet.
Sheet 1: READ FIRST

Instructions for Cost Estimate


1) Choose a sample estimate that fits closest to your scope.


2) Update the following:



Assumed Delivery Year: 2027





*Current Call for Projects is projected FY26-27, but choose last year as previous years are assumed to be already programmed out.





3) Update the yellow highlighted cells on the Estimate tab only for the following information: (Cost field will automatically adjust by formula.)



a) Project Name






b) Scope of Work






c) Work Items






d) Unit Price






e) Quantity





4) Double check rounding in Total Project Cost (Rounded).





5) Submit spreadsheet with application.














For additional information on estimating construction costs, please refer to:






https://highways.dot.gov/federal-lands/estimates/cfl














Specifically, please refer to the CFL Engineer's Estimate Manual located here:






https://highways.dot.gov/federal-lands/estimates/cfl/estimate-manual






























Sheet 2: Sample 1
Hawaii FLAP Application Proposed Project Cost Estimate Sample 1
Sample Project # 1
1.1 miles of major reconstruction of an existing road, widening, improving roadway geometry, constructing rockfall catchment areas, new guardrail, slope armoring, drainage improvements, retaining walls and minor bridge rehabiliation - CFLHD delivered.
Work Item Description Unit Unit Price Quantity Cost Remarks






Watering for Dust Control LPSM $30,000 1 $30,000
Removals of Structures and Obstructions LPSM $20,000 1 $20,000
Roadway Excavation CUYD $40 20,000 $800,000
Waste CUYD $25 5,000 $125,000
Aggregate Base CUYD $40 8,000 $320,000 Assume 6" Depth
Pavement Recycling MILE $100,000 1.10 $110,000
Soil Nail/Rock Bolt/Mesh for slope armoring LPSM $100,000 1.00 $100,000
Asphalt Pavement TON $140 4,000 $560,000 Assume 3" Depth
Bridge Repair, Railing LPSM $100,000 1 $100,000
Retaining Walls SQFT $30 1,000 $30,000 Assume 10 ft tall x 400 ft
Drainage Improvements LPSM $200,000 1 $200,000 Assume 2500 ft of CMP, 70 ft of RCBC
Guardrail LNFT $35 1,000 $35,000
Turf Re-establishment ACRE $2,000 20 $40,000
Permanent Traffic Control & Striping LPSM $45,000 1 $45,000
Right of Way Acqusition LPSM $20,000 1 $20,000 Assume 2 private parcels at approx. $10k each.
Utility Relocation LPSM $10,000 1 $10,000 Relocation of telephone line.






Subtotal $2,545,000


% of above Subtotal







Mobilization LPSM 10% $255,000
Construction Survey and Staking LPSM 2% $51,000
Contractor Quality Control & Testing LPSM 5% $128,000
Temporary Erosion Control LPSM 3% $77,000
Clearing and Grubbing LPSM 2% $51,000
Temporary Traffic Control LPSM 8% $204,000






Subtotal $3,311,000
Contingency (Required for all projects) 30% $994,000 Refer to Table 1 in the CFL Engineer's Estimate Manual for guidance on contingencies
Inflation (Assumed 3% per year) 3% $685,675
Total Construction (CN) 2027 $4,990,675






Preliminary Engineering (PE) (Required for all projects) 12% $598,881
Construction Engineering (CE) (Required for all projects) 12% $598,881






Total Project Cost $6,188,437
Total Project Cost (Rounded) $6,190,000

Sheet 3: Sample 2
Hawaii FLAP Application Proposed Project Cost Estimate Sample 2
Sample Project # 2
10 miles of roadway rehabilitation including full depth reclamation, full depth asphalt, signing and striping - CFLHD delivered.
Work Item Description Unit Unit Price Quantity Cost Remarks






Roadway Excavation CUYD $40 5,000 $200,000
Roadway Aggregate (for shouldering) CUYD $28 8,000 $224,000 Assume 10 miles x 4 ft x 6" depth
Full Depth Reclamation SQYD $8 141,000 $1,128,000
Asphalt Pavement TON $140 27,000 $3,780,000 Assume 10 miles x 28 ft x 3"
Drainage Improvements LPSM $200,000 1 $200,000
Guardrail LNFT $35 4,000 $140,000
Permanent Erosion Control LPSM $45,000 1 $45,000
Permanent Traffic Control & Striping LPSM $75,000 1 $75,000






Subtotal $5,792,000


% of above Subtotal







Mobilization LPSM 10% $580,000
Construction Survey and Staking LPSM 2% $116,000
Contractor Quality Control & Testing LPSM 5% $290,000
Temporary Erosion Control LPSM 5% $290,000
Clearing and Grubbing LPSM 5% $290,000
Temporary Traffic Control LPSM 8% $464,000






Subtotal $7,822,000
Contingency (Required for all projects) 30% $2,347,000 Refer to Table 1 in the CFL Engineer's Estimate Manual for guidance on contingencies
Inflation (Assumed 3% per year) 3% $1,619,658
Total Construction (CN) 2027 $11,788,658






Preliminary Engineering (PE) (Required for all projects) 12% $1,414,638.97
Construction Engineering (CE) (Required for all projects) 10% $1,178,865.81






Total Project Cost $14,382,163
Total Project Cost (Rounded) $14,390,000

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet read first instructions for cost estimate choose a sample that fits closest to your scope update the following assumed delivery year current call projects is projected fy but last as previous years are be already programmed out yellow highlighted cells on tab only information field will automatically adjust by formula project name b of work c items d unit price e quantity double check rounding in total rounded submit spreadsheet with application additional estimating construction costs please refer httpshighwaysdotgovfederallandsestimatescfl specifically cfl engineer s manual located here httpshighwaysdotgovfederallandsestimatescflestimatemanual hawaii flap proposed miles major reconstruction an existing road widening improving roadway geometry constructing rockfall catchment areas new guardrail slope armoring drainage improvements retaining walls and minor bridge rehabiliation cflhd delivered item description remarks watering dust control lpsm removals structures obstructions ex...

no reviews yet
Please Login to review.