Excel Sample Sheet 40116 | F0002294 11 Page Preliminary Cost Estimate Template Example A11y

Partial file snippet.

Sheet 1: 1 of 11

	
	
	
	
	
	
	
	
	
		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
		

	



Sheet 2: 2 of 11

	
	
	
	
	
	
		The column titles for this worksheet are in row 4. They span cells A4. The data spans cells A5 through H49. There is information in every cell for column A through H 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
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		I.  ROADWAY ITEMS SUMMARY
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		Section
		

		

		Cost
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		1
		Earthwork
		

		

		 $6,053,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		2
		Pavement Structural Section
		

		

		 $17,910,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		3
		Drainage
		

		

		 $116,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		4
		Specialty Items
		

		

		 $640,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		5
		Environmental 
		

		

		 $175,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		6
		Traffic Items
		

		

		 $246,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		7
		Detours
		

		

		 $5,000,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		8
		Minor Items
		

		

		 $3,014,000 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		9
		Roadway Mobilization
		

		

		 $3,315,400 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		10
		Supplemental Work
		

		

		 $1,461,200 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		11
		State Furnished
		

		

		 $680,100 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		12
		Time-Related Overhead
		

		

		 $3,564,300 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		13
		Total Roadway Contingency
		

		

		 $10,543,800 
		

	
	
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		TOTAL ROADWAY ITEMS
		

		 $52,718,800 
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Estimate Prepared By :
		

		

		

		

		

		

	
	
		

		

		

		Name and Title 
		

		

		Date
		Phone
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Estimate Reviewed By :
		

		

		

		

		

		

	
	
		

		

		

		Name and Title
		

		

		Date
		Phone
		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		By signing this estimate you are attesting that you have discussed your project with all functional units and have incorporated all their comments or have discussed with them why they will not be incorporated. 
		



Sheet 3: 3 of 11

	
	
	
	
	
	
	
	
	
	
	
		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

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

...Sheet of the column titles for this worksheet are in row they span cells a data spans through k there is information every cell inclusive if you not using screen reader can press alt r t review ribbon edit comment to move and open once on with when finished reading escape close return jaws ctrl shift apostrophe get list comments their coordinates enter want go or rsquo ve read returned workbook note that no keyboard command reread them must use ability order title should be what ever phase estimate it example planning preliminary ps amp e final etc hellip cost copy just an fictitious numbers remove text please all ea ds pid districtcountyroute xxxx pm project scope summary report pssr type shopprasha program code stip route s pms limits x street west highway y east b match status description lengthen turn lanes freeway widening bridge widenreplace maintenance structure pavement cold lane expressway building work real preferred alternative current includes contingency risk amounts year ...

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

Related files

Share

Help

The column titles for this worksheet are in row 4. They span cells A4. The data spans cells A5 through H49. There is information in every cell for column A through H 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


I. ROADWAY ITEMS SUMMARY


	Section					Cost


	1	Earthwork				$6,053,000

	2	Pavement Structural Section				$17,910,000

	3	Drainage				$116,000

	4	Specialty Items				$640,000

	5	Environmental				$175,000

	6	Traffic Items				$246,000

	7	Detours				$5,000,000

	8	Minor Items				$3,014,000

	9	Roadway Mobilization				$3,315,400

	10	Supplemental Work				$1,461,200

	11	State Furnished				$680,100

	12	Time-Related Overhead				$3,564,300

	13	Total Roadway Contingency				$10,543,800


		TOTAL ROADWAY ITEMS				$52,718,800



Estimate Prepared By :
			Name and Title		Date	Phone


Estimate Reviewed By :
			Name and Title		Date	Phone


By signing this estimate you are attesting that you have discussed your project with all functional units and have incorporated all their comments or have discussed with them why they will not be incorporated.

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

Related files

Share

Share to social media

Help

Login Area