Attachment-f-project-estimate_Highland-Redlands Connector Gap ProjectATP - Application Instructions for
Detailed Project Estimate and Total Project Cost- Cycle 7
• Applicants are expected to use this template for estimating/documenting the cost of construction items and the overall project costs. (Eligible and Ineligible)
•The Detailed Engineer's Estimate and Total Project Costs must tie to the information presented in Part A through C of the ATP Application Form.
• Do NOT input values in gray cells. These cells are formula-driven and will automatically update.
Project (Engineer's) Information
• The Licensed Engineer in 'responsible charge' of the overall ATP application must review all information presented in this Estimate form and ensure the values are consistent with the
corresponding plans included in the application. This requirement is considered necessary to ensure the ATP application meets the CTC's PSR-Equivalent requirement - including the
use of construction items, quantities and unit prices that meets industry standards for PSR-Equivalents. The engineer is also expected to review the breakdown of eligible (participating)
vs. ineligible (non-participating) costs shown in estimate and confirm they are consistent with the ATP Guidelines and ATP Eligible Infrastructure Costs Guidance.
Engineer's Estimate & Cost Breakdown
For each construction item in this table, the following items must be filled:
Item: indicate the name of a construction item used in this project.
Quantity: indicate the total quantity of each construction item
Units: indicate the units of measurement (i.e. Square Feet or SQFT.) Only use Lump Sum (LS) for items listed on the Allowable Lump Sum tab.
Unit Cost: indicate the unit cost for one quantity. Note: Unit Cost estimate should be escalated forward to the date of anticipated mid-point of construction using available forecasted
indices for construction cost escalation and/or inflation.
Total Item Cost will be automatically calculated once the above information are provided for each line item (row).
The Project Estimate form only has a limited number of lines. If your estimate has more items; you will have to combine similar items. If an applicant has already developed a complete
estimate using another tool, the items can be grouped into sub-categories such as overhead, bike lanes, sidewalks, drainage, utilities etc., as long as the full estimate is attached
to the estimate or with the application in the Additional Attachments section.
General Overhead:
Costs for these items have been separated out to reduce confusion relating to eligible vs. ineligible costs calculations.
The % of eligible vs. ineligible costs are automatically calculated based on the ratio of these costs for all of the other construction items.
Cost Breakdown See ATP Eligible Infrastructure Costs Guidance for details on eligible and ineligible items located here: https://dot.ca.gov/-/media/dot-media/programs/local-assistance/do
cuments/atp/general-and-technical-info/final-eligible-infrastructure-costs-guidance20231220.pdf
ATP Eligible Items/costs: these are expected to represent all construction items that are ATP eligible.
%- Insert the percentage of the total item cost that is directly attributed to "ATP Eligible items".
$- This field will automatically calculate once a percentage is entered in the previous question.
ATP Ineligible (non-participating) Items/costs: these are expected to represent all construction costs that are not ATP eligible. The % and costs are automatically calculated based
on the "%" value the applicant entered for the eligible costs.
To be constructed by Corps/CCC: these are expected to include all items & costs that will be constructed by the Corps/CCC.
%- Insert the percentage of the total item cost that is directly attributed to "Corps/CCC to construct".
$- This field will automatically calculate once a percentage is entered in the previous question.
Subtotals and Contingencies:
Subtotal of Construction Items: This field will automatically calculate the total of all construction items indicated above.
Construction Item Contingencies: Contingency compensates for the use of limited information available during early phases of a project. Insert percentage of contingencies, which is
intended to account for the cost of minor construction items not defined at the time the ATP applications are prepared. The amount for contingency varies for project capital cost estimates
rather it is risk-based contingency for identified known risks and additional or residual contingency for unidentified undetermined risks, such as unrefined scope adjustments, unit
cost uncertainties, and construction phase uncertainties.
Total (Construction Items and Contingencies) Cost: This field will automatically calculate the total from all information indicated above.
Project Delivery Costs: The eligible vs. ineligible split is automatically calculated for all Project Delivery Costs.
Project Approval & Environmental Document (PA&ED): Total cost of Environmental Studies and Permits phase of the project. Note: Cost estimate should be escalated forward to the date
of anticipated mid-point of the activities using available forecasted indices for PA&ED escalation and/or inflation.
Plans, Specifications & Estimate (PS&E): Total cost of Plans, Specifications and Estimates phase of the project. Note: Cost estimate should be escalated forward to the date of anticipated
mid-point of the activities using available forecasted indices for PS&E escalation and/or inflation.
Total Preliminary Engineering (PE): This total is automatically calculated. Total of (PA&ED) + (PS&E) Note: Per the Caltrans Local Assistance Procedures Manual, the total cost for
PE should not exceed 25%. All costs over the 25% must be shown in the application as ineligible (non-participating).
Right of Way Engineering: Total cost of Right of Way Engineering, including obtaining the RW Certification. Note: Cost estimate should be escalated forward to the date of anticipated
mid-point of the activities using available forecasted indices for right of way engineering cost escalation and/or inflation.
Acquisitions and Utilities: Total cost of Acquisitions and Utilities. Note: Cost estimate should be escalated forward to the date of anticipated mid-point of the activites using available
forecasted indices for aquisition and utility cost escalation and/or inflation.
Total RW: This total is automatically calculated. Total of (RW Eng.) + (Acq.&Utilities)
Total Pre-Construction Costs: This total is automatically calculated. Total of (PE) + (RW)
Construction Engineering (CE): Total cost of Construction Engineering. Note: Cost estimate should be escalated forward to the date of anticipated mid-point of construction using
available forecasted indices for construction cost escalation and/or inflation. Per the Caltrans Local Assistance Procedures Manual, the total cost for CE should not exceed 15%.
All costs over the 15% must be shown in the application as ineligible (non-participating).
Total Construction Costs: This total is automatically calculated. Total of (CE) + (Con. Item. & Contig.)
Total Project Cost Estimate: The eligible vs. ineligible split is automatically calculated for the Total Project Costs.
• This is automatically calculated from all information entered above.
• This value must represent the total estimated cost of the entire ATP project.
• The application must account for the ineligible (non-participating) costs being funded with local funds. Note: Local funding for ineligible (non-participating) costs cannot be considered
as leveraging and/or match funds.
Documentation of Eligible (Participating) and/or Ineligible (Non-Participating) Costs:
The following is an example of how Engineer's can present their logic and calculations for splitting the projects costs between eligible (participating) and ineligible (non-participating)
costs.
Example #1 - Pavement Rehabilitation: The paving and base repair needed for the 1,000 linear feet two-lane roadway is within the limits of the new 5-foot Class II bike lanes with 3-foot
buffer and 11-foot vehicular lanes in each direction. The area within the physical limits of the new bike lanes and buffer is estimated to be 2 x ((5+3) ft x 1,000 ft) = 16,000 sqft
and the area outside these limits is estimated to be 2 x 11 ft x 1,000 ft = 22,000 sqft. The ATP eligible reimbursement for all costs related to the Pavement Rehabilitation is calculated
to be 16,000/(16,000+22,000) = 42%. This split was used for Hot Mix Asphalt, Aggregate Base, and Excavation.
Do not attach these instructions to the ATP application
Item No.
General Overhead-Related Construction Items
1
2
3
4
5
6
7
8
9
10
General Construction Items
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Documentation of Eligible (Participating) and/or Ineligible (Non-Participating) Costs:
The Engineer's justification for including typical ATP-Ineligible items in the ATP-Eligible column and logic and/or calculations for splitting costs between ATP-Eligible and Ineligible
costs must be documented in this section of the Estimate form.
Separate justification is required for each item which is partly ineligible for ATP funding or is required for the construction of an ineligible item/element of the project.
Item #:
Important: Read the Instructions in the first sheet (tab) before entering data. Do not enter data in shaded fields (with formulas).
Agency:
Mobilization
Traffic Control
Stormwater Protection Plan
Construction Survey & Monumentation Restortation
Clearing and Grubbing
Unclassified Excavation
Site Grading (Cut)
Site Grading (Fill)
Site Import
Remove Ex. Scrubs, Trees, & Roots. D<36"
Remove Ex. Scrubs, Trees, & Roots. D>36"
Construct 8" AC Dike per City of Highland or Redlands Std Plan
Construct 8" PCC C&G per City of Highland Std Plan
Construct 4" AC Trail
Construct 6" Crushed Miscellanous Base
Construct 4" PCC Trail over 90% Compacted Native
Construct 4" PCC Sidewalk
Construct PCC Curb Ramp per SPPWC Std Plan
Construct AC Driveway Approach per SPPWD Std Plan
1.5" Min. Cold Plan
Overlay 1.5" Thickness
Construct Retaining Wall per SPPWC Std Plan 618-3, Case 1 Type B
Water Valve/Water Meter Boxes to be Adjusted to Grade
Construct CMP, Drain Pipe, Size Shown
Construct Gate per City of Highland Std Plan 509B
Construct Removable Bollards per Plan
Construct Type 842 Barrier per Caltrans Std Plan B11-60
Construct Curb Opening Catch Basin per SPPWC Std Plan No. 300-3
Construct Curb Outlet Strucutre per City of Highland Std Plan 210A
Relocate Existing Fire Hydrant
Construct 4" AC Pavement
Construct 6" Crushed Miscellanous Base
Install 20 Feet K-Rails
Restore Irrigation and Landscape In-Kind
Construct Pre-Fabricated Bridge and Abutment. Location "1"
Construct Pre-Fabricated Bridge and Abutments. Location "2"
Construct Pre-Fabricated Bridge and Abutments. Location "3"
Install Guard Rail per Caltrans Std Plan A77L1, A77N6 & A77R4 (Type 16B) including End Treatment MSKT-MGS or equal
Install Pedestrian Light (Solar/LED)
Install Metal Hand Railings per SPPWD Std Plan No. 606-4, Type A
Relocate Existing Street Light
Adjust manhole Frame and Cover to Grade
Signing and Striping
Traffic Signal Location 1 (Cemex and Orange St) and Location 2 (Greenspot/5th and Orange St)
Environmental Mitigation Cost (Endanger Species)
Detailed Project Estimate and Total Project Costs - Cycle 7
San Bernardino County Transportation Authority
Project Description:
Project Location:
Project Estimate (for Construction Items Only)
Item
Description of Engineer's Justification: (See example shown in the Instructions)
Construction Class I, II, and IV bicycle and pedestrian paths
Orange Street from Domestic Ave to Greenspot Road
Quantity
1
1
1
1
1
242
4381
8373
4904
41
2
402
133
1473
1058
40492
993
7
32
13697
133
7040
5
53
13
12
504
1
3
1
282
205
2
2
1
1
1
315
11
231
1
28
1
1
1
Units
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
CY
CY
CY
CY
EA
EA
LF
LF
TON
CY
SF
SF
EA
TON
SF
TON
SF
EA
LF
LF
EA
LF
LS
EA
EA
TON
CY
EA
LS
LS
LS
LS
LF
EA
LF
EA
EA
LS
LS
LS
Construction Item Contingencies (% of Construction Items):
Type of Project Cost
Project Approval and Environmental Document (PA&ED):
Plans, Specifications and Estimates (PS&E):
Total PE:
Right of Way Engineering:
Acquisitions and Utilities:
Total RW:
Total Pre-Construction Costs (PE+RW):
Construction Engineering (CE):
Total Construction Costs:
Total Project Cost:
Unit Cost
175000
100000
25000
100000
75000
82.65
85.25
82.25
85.25
610
2500
20
60
125
92
10
10
5575
125
0.7
130
81.5
400
320
75
650
550
50000
6250
7000
125
92.5
1500
13000
750000
490000
305000
185
6100
65
13000
785
625000
80000
7780000
Subtotal of Construction Items:
0.1
Total (Construction Items & Contingencies) cost:
Project Delivery Costs:
Cost $
150000
600000
900000
17083548.02
Project Information:
Project Estimate and Cost Breakdown:
Total
Item Cost
175000
100000
25000
0
0
0
0
0
0
0
100000
75000
20001.3
373480.25
688679.25
418066
25010
5000
8040
7980
184125
97336
404920
9930
39025
4000
9587.9
17290
573760
2000
16960
975
7800
277200
50000
18750
7000
35250
18962.5
3000
26000
750000
490000
305000
58275
67100
15015
13000
21980
625000
80000
7780000
14030498.2
1403049.82
15433548.02
Preliminary Engineering (PE)
750000
Right of Way (RW)
0
750000
Construction Engineering (CE)
16333548.02
Licensed Engineer in responsible charge of preparing or reviewing this PSR-Equivalent Cost Estimate:
ATP Eligible
Costs/Items
%
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Reyes S. "Sal' Chavez
$
175000
100000
25000
0
0
0
0
0
0
0
100000
75000
20001.3
373480.25
688679.25
418066
25010
5000
8040
7980
184125
97336
404920
9930
39025
4000
9587.9
17290
573760
2000
16960
975
7800
277200
50000
18750
7000
35250
18962.5
3000
26000
750000
490000
305000
58275
67100
15015
13000
21980
625000
80000
7780000
14030498.2
1403049.82
15433548.02
ATP Eligible Costs
150000
600000
750000
0
0
0
750000
900000
16333548.02
ATP Eligible Costs
17083548.02
Cost Breakdown
ATP Ineligible
Costs/Items
%
0
0
0
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Date:
$
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
ATP Ineligible Costs
0
0
0
0
0
0
0
0
0
ATP Ineligible Costs
0
4/12/2024
License #:
Corps/CCC
to construct
%
"PE" costs / "CON" costs
4.85954363201573E-02
"CE" costs / "CON" costs
5.83145235841888E-02
C41904
$
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25% Max
15% Max
Item Description- Common to ATP
CLEARING AND GRUBBING
CONSTRUCTION AREA SIGNS
CONSTRUCTION SURVEY/STAKING
DEVELOP WATER SUPPLY
DUST CONTROL
EROSION CONTROL
FINISHING ROADWAY
JOB SITE MANAGEMENT
MITIGATION
MOBILIZATION
MOBILIZATION, DEMOBILIZATION, AND FINAL CLEANUP
PERMITS
PREPARE STORM WATER POLLUTION PREVENTION PLAN
PREPARE WATER POLLUTION CONTROL PROGRAM
RAILROAD FLAGGING & MISCELLANEOUS
RE OFFICE
SIGNS
STRIPING
TRAFFIC CONTROL SYSTEM
TRAFFIC MANAGEMENT PLAN
Item Description- Not common to ATP
ABANDON SEWER
ADL BURIAL LOCATION REPORT
ASBESTOS COMPLIANCE PLAN
AUTOMATED WORK ZONE INFORMATION SYSTEM
BOOSTER PUMP
BRIDGE REMOVAL
BUILDING WORK
CAMERA SYSTEMS
CERTIFY EXISTING BACKFLOW PREVENTERS
CHANGEABLE MESSAGE SIGN SYSTEM
CHECK AND TEST EXISTING IRRIGATION FACILITIES
CLEAN AND PAINT BRIDGE RAILING
CLEAN AND PAINT STEEL SOLDIER PILING
CLEAN AND PAINT STRUCTURAL STEEL
CLEAN AND PAINT STRUCTURAL STEEL (EXISTING BRIDGE)
CLEAN STRUCTURAL STEEL (EXISTING BRIDGE)
CONTRACTOR-SUPPLIED BIOLOGIST (LS)
CONTROL AND NEUTRAL CONDUCTORS
CONTROL AND NEUTRAL CONDUCTORS (ARMOR-CLAD)
DATA CORE
DRAINAGE PUMPING EQUIPMENT
DUST CONTROL PLAN (NATURALLY OCCURRING ASBESTOS)
DUST PALLIATIVE
ELECTRIC SERVICE FOR BOOSTER PUMP
ELECTRIC SERVICE FOR IRRIGATION
FIBER OPTIC CABLE SYSTEMS
FISH PROTECTION
FLASHING BEACON SYSTEM
HEALTH AND SAFETY PLAN
INDUCTIVE LOOP DETECTOR (LS)
INTELLIGENT COMPACTION
INTERCONNECTION CONDUIT AND CABLE (LS)
INVASIVE SPECIES CONTROL
IRRIGATION WATER SERVICE CHARGES
JACKING SUPERSTRUCTURE
LEAD COMPLIANCE PLAN
LIGHTING SYSTEM-(Electroliers are a seperate item (EA))
MAINTAIN EXISTING PLANTED AREAS
MAINTAINING EXISTING TRAFFIC MANAGEMENT SYSTEM ELEMENTS DURING CONSTRUCTION
MIX DESIGN (FULL DEPTH RECLAMATION-FOAMED ASPHALT)
MIX DESIGN (FULL-DEPTH RECLAMATION-CEMENT)
MOBILIZATION (MARINE ACCESS)
MODIFY BRIDGE RAILING (LS)
MODIFY PUMP PLANT
MODIFYING EXISTING ELECTRICAL SYSTEM
MONITOR WELL
NATURAL RESOURCE PROTECTION PLAN
NOA BURIAL LOCATION REPORT
NOISE MONITORING
OPERATE EXISTING IRRIGATION FACILITIES
PAINT STRUCTURAL STEEL (EXISTING BRIDGE)
PERMANENT EROSION CONTROL ESTABLISHMENT WORK
PLANT ESTABLISHMENT WORK
PORTABLE CHANGEABLE MESSAGE SIGN (LS)
PREPAVING INERTIAL PROFILER
PRESTRESSING
PRESTRESSING CAST-IN-PLACE CONCRETE
PRESTRESSING PRECAST GIRDER
PRESTRESSING STEEL GIRDERS
PROGRESS SCHEDULE (CRITICAL PATH METHOD)
PRUNE EXISTING PLANTS
PUBLIC SAFETY PLAN
PUMPING PLANT ELECTRICAL EQUIPMENT
PUMPING PLANT EQUIPMENT
RADAR SPEED FEEDBACK SIGN SYSTEMS
RAMP METERING SYSTEM
RECONSTRUCT DRAINAGE FACILITY (LS)
RECONSTRUCT FENDER
RECYCLED WATER IDENTIFICATION AND WARNING SIGNS
REMOVE CONCRETE (LS)
REMOVE CONCRETE (MISCELLANEOUS) (LS)
REMOVE CONCRETE CURB (LS)
REMOVE DOWNDRAIN (LS)
REMOVE DRAINAGE FACILITY (LS)
REMOVE IRRIGATION FACILITY
REMOVE RAILING
REMOVE REINFORCED CONCRETE BOX CULVERT (LS)
REMOVE RETAINING WALL (LS)
REMOVE RETAINING WALL (PORTION) (LS)
REMOVE SIGN STRUCTURE (LS)
REMOVE SIGN STRUCTURE WALKWAY (LS)
REMOVE SLOPE PAVING (LS)
REMOVE SOUND WALL (LS)
REMOVING EXISTING ELECTRICAL SYSTEM
ROADSIDE CLEARING
SALVAGE IRRIGATION FACILITY
SAMPLING AND ANALYSIS PLAN (NATURALLY OCCURRING ASBESTOS)
SIGN ILLUMINATION SYSTEM
STAIN GALVANIZED SURFACES (LS)
STRAY CURRENT PROTECTION (BRIDGE)
STREET SWEEPING
TEMPORARY ACTIVE TREATMENT SYSTEM
TEMPORARY CONCRETE WASHOUT
TEMPORARY CONSTRUCTION MAT (LS)
TEMPORARY CREEK DIVERSION SYSTEMS
TEMPORARY DECKING
TEMPORARY FLASHING BEACON
TEMPORARY LIGHTING SYSTEM
TEMPORARY PEDESTRIAN ACCESS ROUTE
TEMPORARY SHORING
TEMPORARY SIGNAL AND LIGHTING
TEMPORARY SIGNAL SYSTEM
TEMPORARY SUPPORT
TIME-RELATED OVERHEAD (LS)
TRAFFIC MONITORING STATION SYSTEM
WATER METER CHARGES
WATER SUPPLY SYSTEM
WELL DEVELOPMENT
WORK AREA MONITORING (BRIDGE)
Unit Pay
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
Unit Pay
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS
LS