Filetype Excel XLS | Posted on 08 Aug 2022 | 4 years ago
Authentication
digital resources
470x Filetype XLS File size 1.08 MB Source: www.wbdg.org
Main Menu
Cost Summary Project Data
Head End Equipment Exterior Sensors Interior Sensors
CCTV Electronic Entry
Control Systems
Print Preview Estimate
User Defined Common Items ODCs
Print Estimate
ESS Cost Estimator Version 5.1c
Project Title : ESS Cost Estimator Version 5.1c
Project Data
Current Filename : Q:\Projects\Security\NAVY-Cost-Estimator\F
Estimator's Name : Your Name
Today is : 08/08/2022
Project Title : ESS Cost Estimator Version 5.1c
Site Contact : John Doe 123-123-1234
Other Contact : Jane Doe 222-222-2222
Input Range
Labor Multiplier : 1.0 0.1 to 10
Cost Growth of Job Input Range
Date of Estimate : 11/07/2007 MM/DD/YYYY
Construction Start Date : 11/30/2008 MM/DD/YYYY
Construction Duration : 6 Months
Escalation Index Value for the Date of Estimate : 4533 Integer
Escalation Index Value for the MPC : 4633 Integer
Escalation index may need to be updated. Please reference UFC 3-701-XX, Table 4B for an update.
Cost Summary Inputs Input Range
Taxes : 20.00% 0% to 30% * 5% is typical
Contractor Costs Overhead : 50.00% 0% to 100% *30% is typical
Profit : 15.00% 0% to 15% *10% is typical
Contingencies : 30.00% 0% to 30% *5% is typical
Supervision & Administration : 15.00% 0% to 15% *8% is typical
White cells are the only input cells. Use the TAB key to cycle through the input cells.
ESS Cost Estimator Version 5.1c Total
ESS Cost Estimator Version 5 Update $ -
August 8, 2022
Exterior Sensors $ -
Interior Sensors $ -
CCTV $ -
EECS $ -
User Defined Equipment $ -
Common Items $ -
Head End Equipment $ -
Subtotal $ -
Taxes : 20.00% $ -
Direct Costs : $ -
ODCs : $ -
Subtotal $ -
Contractor Costs
Overhead: 50.00% $ -
Profit: 15.00% $ -
Bond: 0.00% $ -
Subtotal $ -
Cost Growth - Inflation 2.21% $ -
Subtotal $ -
Contingencies 30.00% $ -
Subtotal $ -
Supervision & Administration 15.00% $ -
Total CWE $ -
Calcs ]
PROFIT FACTORS
USING OCE WEIGHTED GUIDELINES
8/8/2022
PROJECT TITLE: ESS Cost Estimator Version 5.1c
COST GROWTH: AR ADJ
DATE OF ESTIMATE PRICING (DOE) = 4533
MIDPOINT OF CONSTRUCTION (MPC) = 4633
COST GROWTH = (MPC)/(DOE) = 1.0221
Inflation 2.21
BOND CALCULATION: PCT CONTRACT BOND BOND
% AMOUNT AMOUNT RATE
0 TO 100,000 0.00 0 0
100,000 TO 500,000 0.00 0 0
500,000 TO 2,500,000 0.00 0 0
2,500,000 TO 5,000,000 0.00 0 0
5,000,000 TO 7,500,000 0.00 0 0
OVER 7,500,000 0.00 0 0
$0 $0 0.0%
Size of Job VLookUp Per of Perf VLookUp Direct Costs : $ -
0 0.12 0 0.0525 Contractor:
100000 0.12 24 0.12 Overhead: $ -
5000001 0.04 Profit: $ -
10000001 0.03
ess_cost_est.xls 08/08/2022
no reviews yet
Please Login to review.
