Construction cost estimating
Overall Estimating Assumptions
How was the estimated developed ?
i.e. elemental parametric method or using historical cost comparisons on relevant, similar projects i.e. was the estimate developed by project team or independantly
Explain other assumptions and how they may influence or impact costs?
i.e. Type of terrain - extreme, mountainous, rolling, level.
i.e. Geographic location within BC - Lower Mainland; Northern; Southern Interior; Vancouver Island etc. i.e. Development Density (ie.Urban, Suburban, Rural) impacts work complexity, traffic managment and utilities etci.e. Scope Uncertainty: What is the quality/quantity of available project information? current, complete, & accuratei.e. Overall complexity and constructability issues
Any other overall assumption or costing decisions to document ?
Project Management and Planning Calculations
How is planning and project managment cost determined as a % of total cost or some other method?
Is design amount determined as a % of Construction or some other method?
Example: Calculated as a 7% of Grade Construction and/or 8% of Structural
What was the basis for determining property information and impacts?
What types of properties are involved (residential, commercial, industrial) ? And how many?
How was market values of the property established?
How are the variable costs determined? What's included? Is there an allowance for internal costs and legal fees? Attach property detailed sheets as necessary outlining calculations
Is the work within an sensitive area? Is this a CEAA project?
How was compensation value determined?
How much mitigation work is anticipated? How was it valued?
What is the project delivery/procurement method? (Design-Bid-Build/Design-Build/Day Labour/P3/DBFO) Is there a Design Criteria Sheet completed for the project?
Geotechnical information: What were the significant material assumptions: solid rock, boulders, mixed, dirt ?
__________________________________________________________________________________________A ssumptions Worksheet Page No. 1 - Cost Estimate for Project No. XXXX
Were there any structures included? How many watercourses were identified or assumed?
What was the assumed road cross-section? Material depths? Asphalt?
Detailed calculations for construction cost elements contained on estimate 'detail sheets'
i.e include 'detail sheets' outlining quantity calculations (based on most probable?)
i.e. provide explanation of unit prices (e.g. prices of similar projects, MOT cost data; labour, matr'l, equip) i.e traffic management considerations
i.e mobilization and demobilization considerations
Construction Supervision Calculation
How was the construction supervision determined?
Example: Calculated as a % of each Construction component (including contingency) as follows: Grading 7%, Operational and Other 8%, Structural and Paving 6.5%, and Environmental Compensation 8%
Was a comprehensive Risk Assessment conducted?
What are the major risk items? How were they identified and quantified?
How were these risks allowed for in the estimate? Are they covered by contingency or included in base Cost Elements
Was contingency applied as a set % basis or was a Risk Assessment conducted identifying and quantifying Risks? Was contingency applied uniformly to all Cost Elements and project segments (Yes or No) ?
What is the amount or % that was applied ?
Is contingency based on the current level of project knowledge and associated risk to deliver the project scope ?
Inclusion and Exclusions
Is there anything NOT included in the estimate? (i.e. pre-project development costs etc.)Is there anything specifically included in the estimate that may be unusual or not normally be part of project cost?
NOTE: The Assumptions Worksheet may differ depending the 'Level of Estimate' being prepared (conceptual, planningprelim, detailed, pre-tender) and the approach of the Estimator. This is a SAMPLE of areas and items to consider and include. It is not an exhaustive list and/or may include items not applicable to all estimates.
Design of rectangle concrete with excelThe beam is rectangle shape and with or without compression reinforcement.
concrete beam design xls
concrete beam design example
concrete beam design calculator
Shear Wall Design Based on ACI 318-02 - excel spreadsheet
concrete beam design spreadsheet
concrete beam design excel
reinforced concrete l beam design
reinforced concrete t-beam design example
reinforced concrete beam design for torsion
construction Cost Estimate
Download this example of House construction budget in spreadsheet format.
Construction cost analysis template excel
Download this example of Construction Cost Template in Excel, with estimated construction budget.
Cost Plan Workbook
UC Component Cost Summary
Insert Project Title in Cell A1.
Insert Plant Account number in Cell E1.
Insert Date of Estimate in Cell E2.
Leave the CCCI in Cell E4 as XXXX, until information is provided by UCOP. Insert Overall Gross Square Feet (OGSF) for project in Cell G6.
In the shaded cells of Column E, enter construction cost from the cost estimate in thousands of-dollars ($,000).
Complete the shaded inflation calculations using project schedule and estimated percentages for annual inflation.
Specify the design contingency assumptions incorporated in the base component costs, as a percentage in Cell B64.
Cost Plan Summary and P or W Submit. Cost Plan Summ
These forms are completed automatically with the information provided in the Component Cost Summary worksheet and require no input.
Cost Conversion to CIB Format
In the shaded cells of Columns D, F, H, and J, enter the construction cost for those items that are outside the construction contract and will be completed by the campus (i.e., telecommunications, builder’s risk insurance, etc.). Provide the description of the cost in Column A.
The totals in Row 32 should match Lines 0, 1, 2, and 4 on your CIB.
Area and Control Quantities
Insert in the shaded areas of Column D the unit values of key control quantities (i.e., enclosed area, volume, elevators, etc.). This information needs to be provided either in this worksheet or in the detailed cost estimate.