Master Estimate Spreadsheet

ESTIMATE INSTRUCTIONS Do NOT delete this page!
and SETUP of ESTIMATE DATA
NOTICE! Read This First and Prefill the information in the Data Field Green Boxes per the instructions below!
Compliance and the correct use of this spreadsheet saves YOU time and makes a more accurate estimate!
Project Title:
DATA FIELD Input info in darker cells, will carry thru summary; Use drop-down selections
Estimate (Today's) Date = 1-Jun-20 20.0% = Engr Contingency No Have Net Cost Est?
Constr Start Date = 1-Aug-20 5.743% = % Escl to Midpoint 12.0% = Net Cost % Default
Constr Compl Date = 30-Jun-23 14-Jan-22 = Duration Midpoint 34.9 = Sch Constr Dur Mo
Project Location = NY 12 = Active Constr in Mo 20% = Sub's OH&P
Project Type = Building 8% = Extra Work Public Adv = Contract Type
Escalation % per Yr = 3.50% 10,000 = Project Unit of Measure (GSF, camera count, etc)
LD Proj Mgr: Project ID #: Predominant Work Hours: (specify)
D-B Mgr:
Line
Lead Eng/Arch: Department: TB&T NTP, BO Dates and Duration:
Contract No: Cost Center #:
Stage / % Compl: Internal Order #: Prepared by InHouse/Consultant:
Bid Date: WBS Element:
Never delete or over-write formulas. Ever.
* Note: Lighter Cells that are the in Data Field have formula's that should not be erased. Darker Cells require manual input
The person doing the estimate must always input data into green cells, indicated like this:
* Note: Always click in the cell that contains a dropdown list. Again, don't delete or overwrite formulas, ever.
When adding space to an estimate, ALWAYS copy the line above and insert it as many times as you need.
Copy the cells from the full row or column, not just the area you need. There are hidden cells and formats in the cells,
plus the ranges need to be included in added area. NEVER insert blank cells!
Clearly identify items which are Classified versus Unclassified in the detail of the estimate.
The Estimators will assist with sorting these items on the summary sheet.
While this file calculates Design-Build and Design-Bid-Build at the same time, there are many other cost influences and
changes that need to be considered for a correct budget. Do NOT issue the summaries as comparisons between the
contract types without review and verification from the Estimating Unit and the Design-Build team leadership.
NJ NY BOTH Building Non-Building
AAV
Ver 1.1 5-May-20
Yes No
Public Adv
PQL
SBE
Design-Build
VVP
Neg PQL
PACC
Work Order
Net Cost Conv
(Other)
08/20 35
06/23 08/20 to 06/23, 35 mo
TB&T
PATH
WTC
Aviation
Ports
(Other)
Design-Build Estimate format
Definitions of Estimate Markups and Scope Intent
NOTE - Written by an estimator, not a lawyer. 18-Feb-20
A General Conditions
General Conditions (or Provisions) are in essence similar to Design-Build in that they cover all the resources, tools,
and equipment needed to build a project, but not directly related to the physical construction activities, that a
Design-Builder is entitled to be compensated for. As Design-Builders take on more responsibility for designing,
managing and building the work, it is sometimes useful to consider breaking out certain elements - if not in the
estimate, then certainly in the schedule of values as it is developed. Design and Preconstruction services are
highlighted in lines Q.2, Q.3 and Q.4. Other activities that may be beneficial to break out of the General Provisions as
the schedule of values is developed for pricing include mobilization payments (typically 1-3% depending on the
nature of the project), specific project insurances, costs of co-located office spaces, partnering/collaboration
workshops including Value Engineering, Design-Builder QA/QC activities, A/EoR construction administration
activities, and production of O&M/Record Information. This will give the PA transparency of cost, ability to control
payments, and reassurance that adequate resources have been allocated to these important activities that might
not be ordinarily required for Design-Bid-Build projects
N Construction Allowances
Risk Assessment and allocation is a key part of any Design-Build contract. Project contingencies shall be held for
specific risks and unknowns. Where the Design-Builder is responsible for the design, management and
implementation of these risk items and the PA wishes to be transparent about the pricing and payment of such,
allowances shall be included within the direct costs to reflect these items. Examples might include removal of
hazardous materials where quantities are unknown, quantities and pricing of work generally defined late in design
such as door hardware, or pricing of FFE items where final product selections/quantites are not known due to Line
Department or technological change. Allowances shall be allocated against specific work items and estimated with
stated assumptions and, as direct cost, which are marked up by the Design-Builder on the summary sheet.
Q.1 D-B Design Contingency
Design Contingencies are downside risk allowances that intend to compensate for several different types of changes
in the project. These changes can include, but are not limited to, (1) changes in scope of the project that are
determined by various needs (including Line Department requests, changes in building codes and engineering
practices), (2) changing conditions under which the project will be executed, and public needs; (3) changes in existing
site or structure conditions, including those which may have not been fully resolved at earlier stages of design; (4)
changes in economic conditions as well as construction marketplace activity; and (5) possible errors that may be
disclosed during early design and estimating efforts. For Design-Build contracts, the policies established by the Chief
Estimator in the Estimating Manual shall be utilized. However, at the request of the Line Department, the percent of
contingency may be adjusted by unanimous decision of a committee to review the project. This committee will
consist of a representative of the LD, the Chief of Design, the Chief Estimator, and the Project EOP or Design-Build
Manager, or their designees.
Q.2 D-B A/E Services, Preliminary
A/E services are intended to include all of the costs to perform a design for the project. In this case, "Preliminary" is
intended to include only such services that would complete the design to Schematic Design, or Phase 1 in PA
terminology. (This may be further redefined on a contractual basis.) The intent of this step allows the Line
Department or other Agency-level decision makers to have severability in the progress of a project. The scope of
these services should be established by the PA and verified during the procurement process with RFP responses.
Note that costs incurred by the Port Authority are not included in this category; these are part of TPC and are not
included in the estimate.
Q.3 D-B Preconstruction Services
Services that are generally reserved for the contractor or builder which do not require specific construction activity.
These services could include estimating, scheduling, constructability, site logistics, market research, MWSBE
outreach, and any other non-physical, non-design work required for a project. This work may be concurrent with
preliminary design as well as later design; the limits to this work are defined by fixed deliverables as well as schedule
milestones.
Q.4 D-B A/E Services, Final

Design-Build Architectural/Engineering (A/E) services are intended to include all of the costs to perform a design for
the project. In this case, "Final" is defined as the balance of the design for the entire project after completion of the
Preliminary design, as well as all subspecialties of design. Construction Administration is included in this portion of
the services.
Q.5 D-B Contractor Overhead

This is the cost for the selected Design-Build Contract holder to cover the cost of running his business efforts for the
project itself. It does not include General Conditions (item A) or profit.
Q.6 D-B Contractor Profit

This is the fee, or overall gain to the Design-Build Contract holder, to be paid for performing the contract.
R Total: Design Build Engineer's Estimate (DBEE)
This value is the summary of items A thru P. This corresponds to the PA's "Engineer's Estimate" on conventional
contracts.
S.1 Net Cost Work

The customary PA fund for work identified as Net Cost. This value should be estimated with multiple line items and
have an additional markup for the D-B Contractor.
S.3 Extra Work
The customary PA fund for work identified as Extra Work. This corresponds to industry standard terminology for a
Construction Contingency and be itemized/configured to provide for funds for unknowns and for risk items that are
outside of the Design-Builder's control. This value should be estimated as an allowance and be inclusive of markup
for the D-B Contractor.
S.4 Other
The estimate summary must include additional costs here in order to reflect contract requirements. These "Other"
costs could include (but are not limited to) bonus clauses, risk premiums, payments to utility or other firms, permits
at various government levels, and the like. Always be clear in the description of what these costs are and include on
a seperate tab the calculation basis for these costs. Add lines as appropriate.
T Sub-Total: Design Builder Construction Cost

This value is the summary of items Q thru R. This corresponds to the PA's "Total Construction Cost (TCC)" on
conventional contracts except it does not include bonding.
U Subcontractor and D-B Contractor Perf Bond
This is the cost for performance bonds that guarantee completion by the D-B Contractor. It also includes the cost of
subrogated performance bonds from subcontractors that are intended to protect the D-B Contractor in the event of
subcontractor default. It is customary industry practice to include this second-tier bonding in contracts (sometimes
referred to Subguard Insurance) in order for the D-B Contractor to minimize his own risk.
V Total: Design-Build Cost (TDBC)

This value is the summary of items A thru T. This corresponds to the PA's "Total Construction Cost (TCC)" on
conventional contracts except it includes bonding.
General notes:
The estimate intends to capture Direct Construction Cost (DCC), Design-Build Engineer's Estimate (DBEE), and Total
Design-Build Cost (TDBC). It does NOT intend to capture Total Project Cost (TPC) which has costs that may include
the following:
Stipends
PA Engineering Costs
PA Supervision and Administration Costs
Cost of Financing
Project Contingency
Internal PA Permitting via QAD
Other permitting, EIS or ULURP costs
Land/property/rights acquisitions
FF&E and rolling stock
These costs must be reviewed and included as part of the Total Project Cost.
AAV
l the resources, tools,

n activities, that a
ility for designing,
ments - if not in the
tion services are
he General Provisions as
depending on the
ng/collaboration
administration
cost, ability to control
activities that might
ies shall be held for

ment and
d payment of such,
clude removal of
defined late in design
not known due to Line
ms and estimated with
mmary sheet.
fferent types of changes

project that are
s and engineering
ds; (3) changes in existing
r stages of design; (4)
e errors that may be
established by the Chief
artment, the percent of
his committee will
t EOP or Design-Build
s case, "Preliminary" is
or Phase 1 in PA
lows the Line
roject. The scope of
with RFP responses.
rt of TPC and are not
fic construction activity.
search, MWSBE
y be concurrent with
ables as well as schedule
to perform a design for

after completion of the
uded in this portion of
business efforts for the
he contract.
e" on conventional
multiple line items and
ard terminology for a

d for risk items that are
be inclusive of markup
ements. These "Other"

or other firms, permits
osts are and include on
n Cost (TCC)" on
lso includes the cost of

ntractor in the event of
contracts (sometimes
Cost (TCC)" on
mate (DBEE), and Total

osts that may include
Stage I Estimate Form
Contract No.: Discipline: Sheet: _____ of ____

Charge Code: Engineering Department Prepared by: Date:
Project Mgr.: Stage I Cost Estimate Checked by: Date:
Project Title:
Consultant Name: Consultant Contact:
Item # Description Quantity Unit Unit Price $ Total $ Assumption / Basis
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Page 10
Engineering Department
Engineer's Estimate Summary DRAFT
Project Title: 0
Proj Mgr/ext: 0 Project ID #: 0 Work Hours: (specify)
Lead Eng/Arch: 0 Cont/Proc Code: Public Adv Construction Start-Finish-Duration: 08/20 to 06/23, 35 mo
Contract No: 0 Cost Center #: 0 Estimate Issue Date: 1-Jun-20
Stage / % Compl: 0 Internal Order #: 0 Prepared by InHouse/Consultant: 0
Bid Date: 30-Dec-1899 WBS Element: 0 Estimate Revision #/ By:
Total
Item Descriptions Dollars Comments
1 General Conditions $222,000 13.2 = % of EE
2 Maintenance of Traffic $261,954
3 Civil $12,011
4 Structural $4,528
5 Architectural $2,645
6 Mechanical $4,590
7 Plumbing $4,615
8 Fire Protection $2,456
9 Electrical $14,194
10 Electronics $130,967
11 Environmental $277,251
12 Geotechnical $131,521
13 Traffic (permanent construction only) $131,798
14 Escalation @ 3.5 %/year $68,949 Calculated from estimate date to midpoint of construction
15 Sub-Total $1,269,479
16 GC Overhead & Profit 10% $126,948
17 Engineering Contingency 20% $279,285 Rounded EE Use: Net Cost %
18 Engineer's Estimate (EE) Sub-Total $1,675,712 $1,676,000 12.00%
19 Classified 0.0%
20 Unclassified (Lump Sum) $1,676,000
21 Net Cost Work $201,085
22 Gen Contractor Markup on Net Cost Work $0 based on = 15.0% <- Markup Not Req'd / PA Policy
23 Payments to Contractors (Items 18, 21, 22) $1,877,085 SAP Total $167.60
24 Extra Work 8% $134,100 $2,011,185 ^^ EE $ per Unit ^^
25 Performance Bond (1% of Rounded EE) $16,760 $47,962
26 Total Construction Cost (TCC) $2,027,945 ^^ EE Avg $/Mo ^^
GASB 49 Value for MBD = $81,600

This Engineer's Estimate Summary can be downloaded from EOL - http://eol/home/EngineeringTools/Estimating/tabid/85/Default.aspx
Refer to the "INSTRUCTIONS and DATA" tab of this file for an explanation of cell calculations and their content.
GASB 49 value is an internal estimate of asbestos abatement costs, disposal of hazardous materials, and composite of all markups.
This estimate is not to be disseminated outside of the Port Authority or consultants invoved in this specific project.
Ver 1.1
Additional Notes: SAP Req #: __________________
Concurrence:
Project Manager Date
EOD Estimator Date Lead Engr/Architect Date Chief Estimator Date

*** Signatures Required for Issuance to Line Department ***
820068902.xlsx
Engineering Department
Design-Build Engineer's Estimate Summary DRAFT
Project Title: 0
LD Proj Manager: 0 Project ID #: 0 Predominant Work Hours: (specify)
D-B Manager: 0 Contract/Proc
Lead Eng/Arch: 0 Format: ERROR-STOP NTP, BO Dates and Duration: 08/20 to 06/23, 35 mo
Contract No: 0 Cost Center #: 0 Estimate Issue Date: 1-Jun-20
Stage / % Compl: 0 Internal Order #: 0 Prepared by InHouse/Consultant: 0
Bid Date: 30-Dec-1899 WBS Element: 0 Estimate Revision #/ By:
Item Descriptions Total Dollars Comments
A General Conditions $222,000 15.93 = % of DCC
B MOT / Maintenance of Traffic $261,954
C Civil $12,011
D Structural $4,528
E Architectural $2,645
F Mechanical $4,590
G Plumbing $4,615
H Fire Protection $2,456
I Electrical $14,194
J Electronics $130,967
K Environmental $277,251
L Geotechnical $131,521
M Traffic (permanent construction only) $131,798
N Construction Allowances $124,104 Refer to detailed list/tab
O Escalation @ 3.5 %/year 5.74% $68,949 Calculated from estimate date to midpoint of construction
P Sub-Total: Direct Construction Cost (DCC) $1,393,583
Q.1 D-B Design Contingency 10.00% $139,358
Q.2 D-B A/E Services, Preliminary 2.50% $34,840
Q.3 D-B Preconstruction Services 0.50% $6,968 Ref % Type Marked Up DBEE
Q.4 D-B A/E Services, Final 6.50% $99,641 0% Classified
Q.5 D-B Contractor Overhead 5.00% $83,719 100% Unclassified $1,926,000
Q.6 D-B Contractor Profit 10.00% $167,439 $192.60 = DBEE Cost/Unit
R Total: Design Build Engineer's Estimate (DBEE) $1,926,000 $161,000 = DBEE Avg $/Mo
S.1 PA Allow Net Cost Work $231,120
S.2 PA Allow Markup on NC Work 15.50% $0 <- Markup Not Required Based on PA Policy
S.3 PA Allow Extra Work 8.00% $154,100
S.4 Other (specify here) $0
T Sub-Total: Design Builder Construction Cost $2,311,220 GASB 49 Value for MBD = $83,300
U Subcontractor and D-B Contractor Perf Bond $19,260

V Total: Design-Build Cost (TDBC) $2,331,000
This Engineer's Estimate Summary can be downloaded from EOL - http://eol/home/EngineeringTools/Estimating/tabid/85/Default.aspx Ver 1.1
Refer to the "INSTRUCTIONS and DATA" tab of this file for an explanation of auto calculations and content, and "DB Definitions" tab for meaning and inclusion.
GASB 49 value is an internal estimate of asbestos abatement costs, disposal of hazardous materials, and composite of all markups.
This estimate is not to be disseminated outside of the Port Authority or consultants invoved in this specific project.
IMPORTANT ESTIMATE/BUDGET NOTES:
Concurrence: Concurrence:
_________________________________
Project Manager Date Design-Build Manager Date SAP Requisition #
EOD Estimator Date Lead Engr/Architect Date Chief Estimator Date

*** Signatures are Required for Estimate Issuance to Line Department ***
820068902.xlsx
Prepared by: Port Authority of NY & NJ -- Engineering Department Proj. Mgr.:
Charge No.: Net Cost Summary Estimate Stage:
Contract No.: 0 Prepared Date:
Checked By:
Project Title: 0
Unit
Item Description Quantity Unit Price Total Remarks
1 Test 0 1 ea 100,000.00 $ 100,000

2 Test 1 5,000 ea 2.00 $ 10,000
3 Test 2 1 ea 100.00 $ 100
4 $ -
5 $ -
6 $ -
7 $ -
8 $ -
9 $ -
10 $ -
11 $ -
12 $ -
13 $ -
14 $ -
15 $ -
16 $ -
17 $ -
18 $ -
File: 820068902.xlsx
19 $ -
20 $ -
21 $ -
22 $ -
23 $ -
24 $ -
$ -
$ -
$ -
Total not including Overhead & Profit $ 110,100
DO NOT MOVE, CHANGE OR DELETE THIS BOX!
Gen Contractor Markup Determination for Net Cost
EE Low EE High EE Qualified NetCost Qualified Final Qualified

0 1,000,000 0 0 0
1,000,000 5,000,000 1 0 0
5,000,000 10,000,000 0 0 0
10,000,000 20,000,000 0 1 0
20,000,000 999,999,999,999 0 0 0
Test Indicator = 0
Prepared by: Port Authority of NY & NJ -- Engineering Department Proj. Mgr.:
Charge No.: General Conditions Summary Estimate Stage:
Contract No.: 0 Date:
Title: 0
Unit
Item Description Quantity Unit Price Total Remarks
1 Mobilization & Demobilization 1 ls $ -

2 Field Supervis'n, Admin. & Maintenance 12 mo 18,500.00 $ 222,000
3 Site Surveys & Testing 1 ls $ -
4 Temporary Utilities 12 mo $ -
5 Sidewalk Bridges & Construction Aids $ -
6 Maintenance of Traffic $ - Verify not double-counted on summary.
7 Site Enclosure & Security $ -
8 Staff SWAC - ea 510.00 $ -
9 Temporary Access $ -
10 Field Offices and Sheds $ -
11 Special G.C. Equipment Rentals 12 mo $ -
$ -
$ -
Total not including Overhead & Profit $ 222,000
Verify not double-counted on summary.
MOT
Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Charge Code: Department Prepared by: Date:
Project Mgr: Design Estimate - All Stages Checked by: Date:
Project Title: 0
Item Unit Price $ Total $

Description Quantity Unit Total $ Assumption / Basis
# Material Labor Material Labor
- - -
- - -
Maintenance of Traffic - - -
Test Item A 300 ea 300.00 61.00 90,000 18,300 108,300
Test Item B 150 ea 60.00 601.00 9,000 90,150 99,150
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 99,000 108,450 207,450

Labor Premiums (define): 10% 10,845 10,845 Define premium conditions in these cells
Subtotal: 218,295
Subcontractor's OH&P: 20.00% 43,659
TOTAL: 261,954
Note: Equipment cost is included under Labor column when a separate column for equipment is not used.
Note: When adding new rows, make sure to copy one of the already formulated rows to ensure formulas are active in the new rows you have created
Page 19
Civil

Project Title: 0

Civil Work - Classified - - -

Test Item C 10 ea 4.00 4.00 40 40 80
Test Item D 100 ea 40.00 6.00 4,000 600 4,600
Subtotal - Classified: 4,040 640 4,680

Labor Premiums (define): 10% 64 64 Define premium conditions in these cells
Subtotal: 4,744
Subcontractor's OH&P: 20% 949
TOTAL CLASSIFIED: 5,693
Civil Work - Unclassified - - -

Test Item C1 11 ea 4.00 4.00 44 44 88
Test Item D1 111 ea 40.00 6.00 4,440 666 5,106
Subtotal - Unclassified: 4,484 710 5,194

Subtotal: 5,265
Subcontractor's OH&P: 20% 1,053
TOTAL - UNCLASSIFIED: 6,318
TOTAL - ALL CIVIL: 12,011 Estimating will sort classified/unclassified on summary.
Note: Equipment cost is included under Material column when a separate column for equipment is not used.
Page 20
Civil
ed/unclassified on summary.
Page 21
Structural

Project Title: 0

- - -
- - -
Structural - - -
Test Item E 10 ea 43.00 63.00 430 630 1,060
Test Item F 100 ea 10.00 15.00 1,000 1,500 2,500
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 1,430 2,130 3,560

Subtotal: 3,773
Subcontractor's OH&P: 20.00% 755
TOTAL: 4,528
Page 22
Architectural

Project Title: 0

- - -
- - -
Architectural - - -
Test Item G 10 ea 44.00 64.00 440 640 1,080
Test Item H 100 ea 4.00 6.00 400 600 1,000
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 840 1,240 2,080

Subtotal: 2,204
TOTAL: 2,645
Page 23
Mechanical

Project Title: 0

- - -
- - -
Mechanical - - -
Test Item I 10 ea 45.00 65.00 450 650 1,100
Test Item J 100 ea 20.00 6.00 2,000 600 2,600
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 2,450 1,250 3,700

Subtotal: 3,825
TOTAL: 4,590
Page 24
Plumbing

Project Title: 0

- - -
- - -
Plumbing - - -
Test Item K 10 ea 46.00 66.00 460 660 1,120
Test Item L 100 ea 20.00 6.00 2,000 600 2,600
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 2,460 1,260 3,720

Subtotal: 3,846
TOTAL: 4,615
Page 25
Fire Protection

Project Title: 0

- - -
- - -
Fire Protection - - -
Test Item M 10 ea 47.00 67.00 470 670 1,140
Test Item N 100 ea 4.00 4.00 400 400 800
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 870 1,070 1,940

Subtotal: 2,047
TOTAL: 2,456
Page 26
Electrical

Project Title: 0

- - -
- - -
Electrical - - -
Test Item O 10 ea 48.00 68.00 480 680 1,160
Test Item P 100 ea 40.00 60.00 4,000 6,000 10,000
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 4,480 6,680 11,160

Subtotal: 11,828
TOTAL: 14,194
Page 27
Electronics

Project Title: 0

- - -
- - -
Electronics - - -
Test Item Q 10 ea 49.00 69.00 490 690 1,180
Test Item R 100 ea 409.00 609.00 40,900 60,900 101,800
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 41,390 61,590 102,980

Subtotal: 109,139
TOTAL: 130,967
Page 28
Environmental

Project Title: 0

Environmental Work - Classified - - -

Test Item S 10 ea 50.00 70.00 500 700 1,200
Test Item T 100 ea 410.00 610.00 41,000 61,000 102,000
- - -
Subtotal - Classified: 41,500 61,700 103,200
Subtotal: 109,370
TOTAL CLASSIFIED: 131,244
Environmental Work - Unclassified - - -

Test Item C1 11 ea 51.11 71.11 562 782 1,344
Test Item D1 111 ea 411.11 611.11 45,633 67,833 113,466
Subtotal - Unclassified: 46,195 68,615 114,811

Subtotal: 121,672
TOTAL - UNCLASSIFIED: 146,007
TOTAL - ALL ENVIRONMENTAL: 277,251 Estimating will sort classified/unclassified on summary.
Page 29
Geotechnical

Project Title: 0

- - -
- - -
Geotechnical - - -
Test Item Y 10 ea 51.00 71.00 510 710 1,220
Test Item Z 100 ea 411.00 611.00 41,100 61,100 102,200
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 41,610 61,810 103,420

Subtotal: 109,601
TOTAL: 131,521
Page 30
Traffic-Perm

Project Title: 0

- - -
- - -
Traffic (Permanent) - - -
Test Item W 10 ea 52.00 72.00 520 720 1,240
Test Item X 100 ea 412.00 612.00 41,200 61,200 102,400
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 41,720 61,920 103,640

Subtotal: 109,832
TOTAL: 131,798
Page 31
Constr Allowances

Project Title: 0

- - -
- - -
Construction Allowances (for Design-Build) - - -
Test Item U 10 ea 51.00 71.00 510 710 1,220
Test Item V 100 ea 411.00 611.00 41,100 61,100 102,200
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
- - -
Subtotal: 41,610 61,810 103,420

Labor Premiums (define): 0% - - Must include and describe in item detail
Subtotal: 103,420
TOTAL: 124,104
Page 32

Master Estimate Spreadsheet

Uploaded by

Copyright:

Available Formats

Master Estimate Spreadsheet

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Master Estimate Spreadsheet

Uploaded by

Copyright:

Available Formats

ESTIMATE INSTRUCTIONS Do NOT delete this page!

and SETUP of ESTIMATE DATA

Never delete or over-write formulas. Ever.

NOTE - Written by an estimator, not a lawyer. 18-Feb-20

Q.1 D-B Design Contingency

Q.2 D-B A/E Services, Preliminary

Q.4 D-B A/E Services, Final

Q.5 D-B Contractor Overhead

Q.6 D-B Contractor Profit

S.1 Net Cost Work

S.3 Extra Work

T Sub-Total: Design Builder Construction Cost

U Subcontractor and D-B Contractor Perf Bond

V Total: Design-Build Cost (TDBC)

l the resources, tools,

ies shall be held for

fferent types of changes

to perform a design for

business efforts for the

multiple line items and

ard terminology for a

ements. These "Other"

lso includes the cost of

mate (DBEE), and Total

Contract No.: Discipline: Sheet: _____ of ____

GASB 49 Value for MBD = $81,600

Project Manager Date

EOD Estimator Date Lead Engr/Architect Date Chief Estimator Date

U Subcontractor and D-B Contractor Perf Bond $19,260

EOD Estimator Date Lead Engr/Architect Date Chief Estimator Date

1 Test 0 1 ea 100,000.00 $ 100,000

EE Low EE High EE Qualified NetCost Qualified Final Qualified

1 Mobilization & Demobilization 1 ls $ -

Total not including Overhead & Profit $ 222,000

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 99,000 108,450 207,450

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Civil Work - Classified - - -

Subtotal - Classified: 4,040 640 4,680

Civil Work - Unclassified - - -

Subtotal - Unclassified: 4,484 710 5,194

TOTAL - ALL CIVIL: 12,011 Estimating will sort classified/unclassified on summary.

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 1,430 2,130 3,560

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 840 1,240 2,080

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 2,450 1,250 3,700

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 2,460 1,260 3,720

Contract No.: 0 Engineering Discipline: Sheet: _____ of _____

Item Unit Price $ Total $

Subtotal: 870 1,070 1,940

Contract No.: Discipline: Sheet: _ of

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _

Contract No.: 0 Engineering Discipline: Sheet: _ of _