| The column titles for this worksheet are in row 2. They span cells A2. The data spans cells A3 through K61. There is information in every cell for column A through K inclusive. If you are not using a screen reader, you can press Alt + R, T for the Review Ribbon, Edit Comment to move to and open a Comment once you are on a cell with a Comment. When you are finished reading the Comment, press Escape to close the comment and return to the worksheet. If you are using the JAWS screen reader, press Ctrl + Shift + Apostrophe to get a list of Comments and their cell coordinates in the worksheet. Press Enter on the Comment you want to go to or Escape once you’ve read the Comment for a cell. You are returned to the workbook. Note that there is no keyboard command with JAWS to reread Comments or read Comments once you are on them in a cell. You must use the ability to list Comments in order to read them if you are using the JAWS screen reader. |
|
|
|
|
Title should be what ever phase estimate it is. For example, Planning, Preliminary, PS&E. Final, etc.… Estimate
PLANNING COST ESTIMATE |
© |
|
This is just an example with fictitious numbers.
Remove this text.
Please read all the comments for the cells.
Example |
| EA: |
DS-123456 |
|
|
|
EA: DS-123456 PID: DS1234567 |
|
|
|
| PID: |
DS1234567 |
|
|
|
|
|
|
District-County-Route: |
00-XXX-X-000 |
|
|
|
|
|
|
|
|
|
PM: |
00.0 - 00.0 |
|
|
Example: Project Scope Summary Report (PSSR)
Type of Estimate : |
Project Scope Summary Report |
|
|
Example: SHOPP-RAS-HA22
Program Code : |
STIP |
|
|
Route(s)/PMs
Project Limits : |
X street west of a highway to y street east of route b. |
|
|
Match Status Description
Example: Lengthen Turn Lanes
Project Description: |
Freeway widening, bridge widen/replace and maintenance structure. |
|
|
Example: Pavement Widening; Cold Planning; 2 lane highway to 4 lane expressway; etc.
Scope : |
Freeway Widening and Building Work - Not a real example. |
|
|
Example:#1, #2, #3, Preferred, etc.
Alternative : |
Alternative # 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SUMMARY OF PROJECT COST ESTIMATE |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current includes contingency and the risk amounts
Current Year Cost |
|
Escalated Cost |
|
|
|
|
|
|
|
|
|
|
|
|
|
Dollar amount totals on worksheet 1 of 11 and 2 of 11 are derived from the totals from other sheets. Therefore you only need to enter Quantities and Unit Costs for each item in worksheets 3 of 11 to 9 of 11. Please be aware that there are lots of formulas on each worksheet. Fill in the additional data required in all of the sheets from the most current available information.
|
TOTAL ROADWAY COST |
$52,718,800 |
|
$63,100,732 |
|
|
|
TOTAL STRUCTURES COST |
$28,350,000 |
|
$32,933,099 |
|
|
|
SUBTOTAL CONSTRUCTION COST |
$81,068,800 |
|
$96,033,831 |
|
|
|
TOTAL RIGHT OF WAY COST |
$10,050,000 |
|
$15,000,000 |
|
|
|
TOTAL CAPITAL OUTLAY COSTS |
$91,119,000 |
|
$111,034,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PA/ED SUPPORT |
$4,037,128 |
|
$4,080,233 |
|
|
|
PS&E SUPPORT |
$3,049,041 |
|
$3,371,848 |
|
|
|
RIGHT OF WAY SUPPORT |
$139,688 |
|
$155,554 |
|
|
|
CONSTRUCTION SUPPORT |
$4,464,060 |
|
$5,468,409 |
|
|
|
All support costs are from sheet 11 of 11 and are escalated to year of expenditure.
TOTAL SUPPORT COST |
$11,690,000 |
|
$13,077,000 |
|
|
|
|
|
|
|
|
|
|
TOTAL PROJECT COST |
$103,000,000 |
|
$125,000,000 |
Adjust the Roundup formula if needed
*Value Analysis is required for any project with escalated cost of $25 million or greater.
* |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
If project has been programmed enter the programmed amount.
Programmed Amount |
|
$250,000,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Month |
/ |
Year |
|
|
|
|
|
|
|
Date of Estimate (Month/Year) |
1 |
/ |
2018 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimated Construction Start (Month/Year) |
1 |
/ |
2023 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Working Days |
= |
Enter total working days.
1305 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimated Mid-Point of Construction (Month/Year) |
7 |
/ |
2024 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Estimated Construction End (Month/Year) |
12 |
/ |
2026 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Plant Establishment Days |
|
261 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
REQUIRED: Enter dates below
Estimated Project Schedule |
|
|
|
|
|
PID Approval |
1/15/2014 |
|
|
|
|
|
PA/ED Approval |
12/10/2017 |
|
|
|
|
|
PS&E |
6/25/2023 |
|
|
|
|
|
RTL |
12/18/2023 |
|
|
|
|
|
Begin Construction |
1/19/2023 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Reviewed by District O.E. or Cost Estimate Certifier |
|
|
|
|
xx/xx/xxxx |
|
(xxx) xxx-xxxx |
|
|
|
|
|
Office Engineer / Cost Estimate Certifier |
|
|
Date |
|
Phone |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Approved by Project Manager |
|
|
|
|
xx/xx/xxxx |
|
(xxx) xxx-xxxx |
|
|
|
|
|
Project Manager |
|
|
Date |
|
Phone |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Copyright 2018 California Department of Transportation All Rights |
|
|
|
|
| PLEASE READ ALL THE SUGGESTIONS THAT ARE INCLUDED IN THE CELLS SHOWING RED TRIANGLE COMMENT MARKS. |
|
|
|
|
|
|
|
This will not print!
|
|
|
| Only use sheets 1 through 10 for attachment to approval documents, skip sheet 11 since Support Cost are include in separate attachment i.e. Programing Sheet. |
|
|
|
|
|
|
|
|
|
|
| *Value Analysis is required for any project with escalated cost of $25 million or greater. |
|
|
|
|
|
|
|
Last updated: |
4/24/2019 |
|
| The column titles for this worksheet are in row 2. They span cells A2. The data spans cells A3 through J61. There is information in every cell for column A through J inclusive. If you are not using a screen reader, you can press Alt + R, T for the Review Ribbon, Edit Comment to move to and open a Comment once you are on a cell with a Comment. When you are finished reading the Comment, press Escape to close the comment and return to the worksheet. If you are using the JAWS screen reader, press Ctrl + Shift + Apostrophe to get a list of Comments and their cell coordinates in the worksheet. Press Enter on the Comment you want to go to or Escape once you’ve read the Comment for a cell. You are returned to the workbook. Note that there is no keyboard command with JAWS to reread Comments or read Comments once you are on them in a cell. You must use the ability to list Comments in order to read them if you are using the JAWS screen reader. |
|
|
|
|
|
|
|
|
EA: DS-123456 PID: DS1234567 |
| SECTION 1: EARTHWORK |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Add items not listed here or remove the items not needed by inserting rows or deleting rows. Make sure that the formulas in the template are adjusted to account for the changes you make.
Item code |
|
Unit |
Fill in the latest available Quantities.
Quantity |
|
Fill in the latest available unit prices.
Unit Price ($) |
|
Cost |
|
|
| 190101 |
Roadway Excavation |
CY |
100,000 |
x |
9.00 |
= |
$900,000 |
|
|
| 152320 |
Include item for "Lead Compliance Plan" under "Specialty Items."
Lead Compliance Plan |
LS |
1 |
x |
3,000.00 |
= |
$3,000 |
|
|
| 194001 |
Ditch Excavation |
CY |
100,000 |
x |
35.00 |
= |
$3,500,000 |
|
|
| 19801X |
Imported Borrow |
CY/TON |
|
x |
|
= |
$- |
|
|
| 192037 |
See Standard Plan A62B/A62C for limits of payment for Structure Excavation.
Structure Excavation (Retaining Wall) |
CY |
50,000 |
x |
25.00 |
= |
$1,250,000 |
|
|
| 193013 |
See Standard Plan A62B/A62C for limits of payment for Structure Backfill.
Structure Backfill (Retaining Wall) |
CY |
10,000 |
x |
30.00 |
= |
$300,000 |
|
|
| 193031 |
Pervious Backfill Material (Retaining Wall) |
CY |
|
x |
|
= |
$- |
|
|
| 16010X |
Estimate is based on the amount of Acres that would be cleared and grubbed. Use $3000 per Acre as a general rule. You may include the amount as acres or Lump Sum.
Clearing & Grubbing |
LS/ACRE |
10,000 |
x |
10.00 |
= |
$100,000 |
|
|
| 170101 |
Include this item if earthwork exceeds 5,000 CY. Depending on difficulty, use $10,000 as an initial estimate of cost.
Develop Water Supply |
LS |
|
x |
|
= |
$- |
|
|
| 19801X |
Imported Borrow |
CY/TON |
|
x |
|
= |
$- |
|
|
| 210130 |
Duff |
ACRE |
|
x |
|
= |
$- |
|
|
| XXXXXX |
Some Item |
Unit |
|
x |
|
= |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL EARTHWORK SECTION ITEMS |
|
$6,053,000 |
|
|
|
|
|
|
|
|
|
|
| SECTION 2: PAVEMENT STRUCTURAL SECTION |
|
|
|
|
|
|
Material Recommendation will spell out what material need to be used for the roadway. E.g. PCC vs HMA, etc. Usually if high traffic volume and higher weight traffic is expected them PCC might be recommended.
|
|
|
|
|
|
|
|
|
|
|
|
|
| Item code |
|
Unit |
Quantity |
|
Unit Price ($) |
|
Cost |
|
|
| 401050 |
If you have this item, you may also have items for "Seal Pavement Joint" and "Seal Longitudinal Isolation Joint."
Jointed Plain Concrete Pavement |
CY |
|
x |
|
= |
$- |
|
|
| 400050 |
Continuously Reinforced Concrete Pavement |
CY |
|
x |
|
= |
$- |
|
|
| 404092 |
Seal Pavement Joint |
LF |
|
x |
|
= |
$- |
|
|
| 404093 |
Seal Isolation Joint |
LF |
|
x |
|
= |
$- |
|
|
| 413117 |
Seal Concrete Pavement Joint (Silicone) |
LF |
|
x |
|
= |
$- |
|
|
| 413118 |
Seal Pavement Joint (Asphalt Rubber) |
LF |
50,000 |
x |
8.00 |
= |
$400,000 |
|
|
| 280010 |
If you have this item, you may also have items for "Seal Joint (Existing Concrete Pavement)", "Grind Existing Concrete Pavement", "Dowel Bar (Drill and Bond)" and "Repair Spalled Joints (Polyester Grout)."
Rapid Strength Concrete Base |
CY |
|
x |
|
= |
$- |
|
|
| 410095 |
Dowel Bar (Drill and Bond) |
EA |
|
x |
|
= |
$- |
|
|
| 390132 |
Use the conversion: 2 TON/CY
Formerly known as: "Asphalt Concrete" (Type A).
Hot Mix Asphalt (Type A) |
TON |
70,000 |
x |
68.00 |
= |
$4,760,000 |
|
|
| 390137 |
Use the conversion: 1.9 TON/CY
Formerly known as "Rubberized Asphalt Concrete (Type G)".
Rubberized Hot Mix Asphalt (Gap Graded) |
TON |
|
x |
|
= |
$- |
|
|
| 39300X |
Geosynthetic Pavement Interlayer (Type X) |
SQYD |
|
x |
|
= |
$- |
|
|
| 26020X |
Class 2 Aggregate Base |
TON/CY |
50,000 |
x |
12.00 |
= |
$600,000 |
|
|
| 290201 |
Asphalt Treated Permeable Base |
CY |
|
x |
|
= |
$- |
|
|
| 250401 |
Class 4 Aggregate Subbase |
CY |
50,000 |
x |
63.00 |
= |
$3,150,000 |
|
|
| 374002 |
Use on all new or existing HMA/AC surfaces within the project limits, excluding traveled way and detours, per D11 PDPM manual.
Estimate:
0.02-0.06 GAL/SQYD and 240 GAL/TON.
This item is also used on seal coat projects along with additional items. For application rates for bituminous seals, see Section 37 of the Standard Specifications.
Asphaltic Emulsion (Fog Seal Coat) |
TON |
|
x |
|
= |
$- |
|
|
| 397005 |
Required for Cold Plane AC/HMA projects. All vertical and horizontal cold planed surfaces and intermediate layers are tacked with binder prior to HMA placement. Estimate 0.02-0.07 GAL/SQYD and 240 GAL/TON. See Standard Specifications Section 39 for spread rates based on pavement type.
Tack Coat |
TON |
|
x |
|
= |
$- |
|
|
| 377501 |
Slurry Seal |
TON |
|
x |
|
= |
$- |
|
|
| 3750XX |
To be used on chip seal projects. You may also have items for "Asphaltic Emulsion (Polymer Modified)", "Asphaltic Emulsion (Fog Seal Coat)", and "Sand Cover." Include type.
Screenings (Type XX) |
TON |
|
x |
|
= |
$- |
|
|
| 374492 |
To be used on chip seal projects. You may also have items for "sand cover", "asphaltic emulsion (fog seal coat)", and "screenings."
Asphaltic Emulsion (Polymer Modified) |
TON |
100,000 |
x |
20.00 |
= |
$2,000,000 |
|
|
| 370001 |
To be used on chip seal projects. You may also have items for "asphaltic emulsion (polymer modified)", "asphaltic emulsion (fog seal coat)", and "screenings."
Sand Cover (Seal) |
TON |
|
x |
|
= |
$- |
|
|
| 731530 |
Minor Concrete (Textured Paving) |
CY |
|
x |
|
= |
$- |
|
|
| 731502 |
Minor Concrete (Miscellaneous Construction) |
CY |
50,000 |
x |
75.00 |
= |
$3,750,000 |
|
|
| 39407X |
In addition to per LF quantity, Place Hot Mix Asphalt Dike is also paid by the TON, and added to other work as "Minor Hot Mix Asphalt" See Standard Plan A87B for dike quantities.
Formerly known as "Place AC Dike"
Place Hot Mix Asphalt Dike (Type X) |
LF |
|
x |
|
= |
$- |
|
|
| 150771 |
Dike Removal, when part of Roadway Excavation for pavement widening, is NOT a pay item. Use this item when dike is removed as part of a rehabilitation (cold plane), etc.
Remove Asphalt Concrete Dike |
LF |
|
x |
|
= |
$- |
|
|
| 420201 |
Usually required on slab replacement projects to restore ride quality.
Grind Existing Concrete Pavement |
SQYD |
|
x |
|
= |
$- |
|
|
| 150860 |
Primarily used to remove detours. When pavement and portions of base are removed for other cases, the item should be "Roadway Excavation."
Remove Base and Surfacing |
CY |
|
x |
|
= |
$- |
|
|
| 390095 |
Replace Asphalt Concrete Surfacing |
CY |
|
x |
|
= |
$- |
|
|
| 15312X |
Remove Concrete |
LF/CY/LS |
|
x |
|
= |
$- |
|
|
| 394090 |
In addition to SQYD quantity, Place Hot Mix Asphalt (Misc. Area) is also paid by the TON, and added to other work as "Hot Mix Asphalt (Type A)."
Formerly known as "Place Asphalt Concrete (Misc. Area)".
Place Hot Mix Asphalt (Miscellaneous Area) |
SQYD |
|
x |
|
= |
$- |
|
|
| 153103 |
Although plans include a breakdown of different cold plane depths, for project studies purposes, add all quantities together here. Include an item for "Asphaltic Emulsion (Paint Binder)."
Cold Plane Asphalt Concrete Pavement |
SQYD |
|
x |
|
= |
$- |
|
|
| 39405X |
Shoulder Rumble Strip (HMA, X-In Indentations) |
STA |
|
x |
|
= |
$- |
|
|
| 413113 |
Repair Spalled Joints, Polyester Grout |
SQYD |
|
x |
|
= |
$- |
|
|
| 420102 |
Groove Existing Concrete Pavement |
SQYD |
|
x |
|
= |
$- |
|
|
| 390136 |
Minor Hot Mix Asphalt |
TON |
50,000 |
x |
65.00 |
= |
$3,250,000 |
|
|
| 394095 |
Roadside Paving (Miscellaneous Areas) |
SQYD |
|
x |
|
= |
$- |
|
|
| XXXXXX |
Some Item |
Unit |
|
x |
|
= |
$- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL PAVEMENT STRUCTURAL SECTION ITEMS |
|
$17,910,000 |
Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
