jagomart
digital resources
picture1_Excel Sheet Download 31274 | Project Estimate


 249x       Filetype XLSX       File size 0.69 MB       Source: www.uottawa.ca


File: Excel Sheet Download 31274 | Project Estimate
sheet 1 id universit eacute d ottawa university of ottawa service des immeubles physical resources service project identification document project date building room s project title project description purpose of ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: ID
Université d'Ottawa / University of Ottawa







Service des immeubles / Physical Resources Service
















Project Identification Document









Project #:


Date:
Building:
Room(s):



Project Title:


Project Description:


Purpose of the Project:


Faculty / Service:
Leader (PL)
Client(s):
Manager (PM):

Consultant:
Guesstimate Cost:
Anticipated Start Date:
Anticipated Funding Source:
Anticipated Completion Date:










Sheet 2: Initial Estimate


0











000-000-000










[dd/mm/yy]










Prepared by:






















Project Estimate Class:






















3-Jan-00


Enter Total Surface (m2):

Carefully read the project estimate classes and choose from the pull down the class that corresponds to the class of estimate you are preparing.







Entering the total project m² will automatically create an analysis of m² cost per item on the right of the estimate amount columns and produce a cost analysis report at the bottom of the estimate sheet. (Analysis required to produce statistics to help with estimating standard).

Entering the total project m² will automatically create an analysis of m² cost per item on the right of the estimate amount columns and produce a cost analysis report at the bottom of the estimate sheet. (Analysis required to produce statistics to help with estimating standard).



Schematic Design within 30% plus or minus of actual project cost











Net Taxes Total Cost/m2 % of Total Cost
How to Estimate















A Professional Fees











100 Prime Professional Fees












101 Project Manager Extended Offer
0.00 HST 0.00
Enter only if the project will be managed externally. To use the default fee calculation, choose "Extended Offer" from the pull down menu. (Formula is based on 2008-2010 Extended offers). The variable % fee (from 3% to 9%) is multiplied by the project cost excluding section 800. If the fees are different from the current "Extended Offer", override the formula to put the appropriate negotiated amount.


102 Prime Architect Extended Offer
0.00 HST 0.00
Enter only if the project has an external architect. To use the default fee calculation, choose "Extended Offer" from the pull down menu. (Formula is based on 2008-2010 Extended offers). The variable % fee (from 10% to 17%) is multiplied by the "Architectural" and the "Design Related Costs" (items 501 and 503). If the fee is different from the current "Extended Offer", override the formula to put the appropriate negotiated amount.


103 Prime Engineer Extended Offer
0.00 HST 0.00
Enter only if the project has an external architect. To use the default fee calculation, choose "Extended Offer" from the pull down menu. The 10% (9.6%+ disb) fee is multiplied by the "Mechanical ,Electrical " and the "Design Related costs" (items 502 and 503). If the fee is different from the current "Extended Offer", override the formula to put the appropriate negotiated amount.


104 Project Delivery Fee

0.00
#NAME? #NAME? #NAME?
The first $250,000 of all capital projects are exempt of fee, the remaining total net project cost is subject to a PRS delivery fee.
If item 101 Project Manager, 102 Prime Consultant or 103 Prime Engineer is used the default calculation is 0.5%, if none are used the default is 4%. The delivery fee % is calculated on the total project cost excluding 801 project contingency and 802 escalation provision.




Total Prime Professional Fees

0.00
#NAME? #NAME? #NAME?
Default calculation, total cost of the section 100















200 Miscellaneous Professional Fees in Addition to Prime Professional Fees












201 Geotechnical Investigation (Soils Report)


HST 0.00
To be estimated or upon negotiated received offer(s).


202 Feasibility Study (i.e.. CFI)


HST 0.00
To be estimated or upon negotiated received offer(s).


203 Cost Monitoring


HST 0.00
To be estimated or upon negotiated received offer(s).


204 Surveying


HST 0.00
To be estimated or upon negotiated received offer(s).


205 Urban Planner


HST 0.00
To be estimated or upon negotiated received offer(s).


206 Mechanical, Electrical


HST 0.00
If not included in item 103 Prime Engineer, to be estimated or upon negotiated received offer(s).


207 Structural


HST 0.00
If not included in item 103 Prime Engineer, to be estimated or upon negotiated received offer(s).


208 Civil


HST 0.00
If not included in item 103 Prime Engineer, to be estimated or upon negotiated received offer(s).


209 Landscape Architect


HST 0.00
To be estimated or upon negotiated received offer(s).


210 Building Science (Envelope & Roof)


HST 0.00
To be estimated or upon negotiated received offer(s).


211 Building Code Analysis


HST 0.00
If not included in item 102 Prime Architect, to be estimated or upon negotiated received offer(s).


212 Interior Design and Furniture


HST 0.00
To be estimated or upon negotiated received offer(s).


213 Leed Assessment (Environmental)


HST 0.00
To be estimated or upon negotiated received offer(s).


214 Elevator


HST 0.00
To be estimated or upon negotiated received offer(s).


215 Commissioning (incl. Air Balancing Verification)


HST 0.00
To be estimated or upon negotiated received offer(s). Refer to the PRS commissioning manager.


216 Environmental Assessment / Inspection (Soils, Air, Asbestos, Bio-Hazards)


HST 0.00
To be estimated or upon negotiated received offer(s). Refer to PRS Environmental Health and Safety Officer.


217 Signage

0.00 HST 0.00
Default calculation, 25% of item 707 Graphics and Signage cost. (Formula based on 2009 statistics).


218 Accessibility


HST 0.00
To be estimated or upon negotiated received offer(s).


219 Other Professional (Acoustical, lighting, micro climate, traffic control, security key codes etc.)


HST 0.00
To be estimated or upon negotiated received offer(s).



Total Miscellaneous Professional Fees

0.00
0.00 - 0%
Default calculation, total cost of the section 200



Total A - Professional Fees

0.00
#NAME? #NAME? #NAME?
Default calculation, total cost of the section 100 and 200















B Soft Costs











300 Site Development Costs












301 Letter of Credit - City of Ottawa


none 0.00
Required only if a Site Plan Control is mandatory. Must calculate manually 1.25% of the amount of the letter or a minimum of $250.00 yearly


302 Certification (LEED)


HST 0.00
To be estimated or upon negotiated received offer(s). Refer to the PRS Assistant Director, Engineering and Sustainable Development.


303 Environmental Approvals (i.e.. MOE)


none 0.00
To be estimated or upon negotiated received offer(s). Refer to the PRS Assistant Director, Engineering and Sustainable Development.


304 Community & Master Plan Issues


HST 0.00
To be estimated or upon negotiated received offer(s). Refer to the PRS Director.


305 Permits (building, development)

0.00 none 0.00
Default calculation, $12 per $1,000 of item 501 and 502,estimate of the general contract tender cost or a minimum of $80.00. If a building permit is not applicable, or is based on less than the general contract tender cost, the estimator must delete or manually enter the value of the permit.



Total Site Development Costs

0.00
0.00 - 0%
Default calculation, total cost of the section 300















400 Related Soft Costs












401 Insurance


none 0.00
To be analysed and estimated by "Risk Management" if a wrap-up Insurance policy is taken by the University (may be used for construction projects).


402 Moving


HST 0.00
To be estimated or upon received quotation(s) or bids.


403 Storage (Special Requests, $15.00/sq...)


HST 0.00
Calculate $15.00 per square foot.


404 Miscellaneous Expenses (i.e.. Travel Expenses, Additional Printing)


HST 0.00
Travel expenses, parking and mileage (usually through PRS petty cash) to be estimated manually. Additional printing cost only if extra expenses are required and not included in Professional fees.



Total Related Soft Costs

0.00
0.00 - 0%
Default calculation, total cost of the section 400



Total B - Soft Costs

0.00
0.00 - 0%
Default calculation, total cost of the section 300 and 400















C Hard Costs











500 Construction / Renovation Costs (General Contract)












501 Architectural


HST 0.00
When the General Contractor's work is mostly Architectural enter the entire General Contractor's work in the section 501. To be estimated following the class of estimate or upon received quotation(s) or bids. For PRS staff, refer to estimate forms available for Class B, C and D cost estimates.


502 Mechanical, Electrical


HST 0.00
When the General Contractor's work is mostly Mechanical / Electrical enter the entire General Contractor's work in the section 502. To be estimated following the class of estimate or upon received quotation(s) or bids. For PRS staff, refer to estimate forms available for Class B, C and D cost estimates.


503 Design Related Costs 8.0%
0.00 HST 0.00
Default calculation, 8% of items 501 and 502, estimate of the general contract tender cost. The % can be overridden by entering a different % prior to tender. Amount must be revised to $0.00 when general contract tendered amount is known (estimate Class A). (Formula based on February 12, 2009 procedure on project contingencies)



Sub Total of Original General Contract

0.00
0.00 - 0%
Default calculation, total cost of items 501 to 503. estimate of the general contract tender cost.


504 Asbestos Abatement Paid Directly by PRS


HST 0.00
Credit amount to be estimated or upon received quotation(s) or bids



Sub Total for Provision of Original General Contract

0.00
0.00 - 0%
Default calculation, total cost of the subtotal of original general contract and 504 asbestos abatement paid directly by PRS.


505 Construction / Renovation Contingency (Change Orders) 10.0%
0.00 HST 0.00
Default calculation, 10% of items 501 to 504, subtotal for provision of original general contract under $3,000,000 and 7.5% over $3,000,000. When this tender amount is known this contingency still remains. Once work commences, the contingency is revised periodically and should be modified to reflect all change orders to complete the general contractor's work. (Formula based on February 12, 2009 procedure on project contingencies)



Total Construction / Renovation Costs (General Contract)

0.00
0.00 - 0%
Default calculation, total cost of items 501 to 505, estimate of the total construction renovation general contract cost.















550 Related Construction / Renovation Costs (Outside of General Contract)












551 Asbestos Abatement (and other Hazardous Substances Abatement)


HST 0.00
To be estimated following the class of estimate or upon negotiated received offer(s). Refer to PRS Environmental Health and Safety Officer. If this project doesn't pay for this work, no amount is to be identified and the work contract is found in the project with funds.


552 Environmental Soil Disposal


HST 0.00
To be estimated following the class of estimate or upon negotiated received offer(s).


553 Landscape Reinstatement


HST 0.00
To be estimated following the class of estimate or upon negotiated received offer(s). Refer to PRS Ground Supervisor.


554 Cleaning Site After Renovation


HST 0.00
To be estimated following the class of estimate or upon negotiated received offer(s). Refer to Sanitary Services Supervisor.


555 Energy Costs During Const. (only if sq.ft. increases)


none 0.00
To be estimated for major extension projects only. Refer to PRS Assistant Director, Engineering and Sustainable Development.


556 Other Related Construction Costs


HST 0.00
To be estimated for all other work not included in other construction cost items.



Total Related Construction / Renovation Costs (outside of General Contract)

0.00
0.00 - 0%
Default calculation, total cost of items 551 to 558, estimate of the total related construction renovation cost (outside of general contract).



Total of Construction / Renovation Costs

0.00
0.00 - 0%
Default calculation, total cost of all items within the 500 and 550 section, estimate of the total construction renovation cost (including general contract and related construction / renovation cost).















600 Materials Inspection & Testing












601 Soil Testing


HST 0.00
To be estimated or upon received quotation(s) or bids.


602 Concrete Testing


HST 0.00
To be estimated or upon received quotation(s) or bids.


603 Pile Inspection Testing


HST 0.00
To be estimated or upon received quotation(s) or bids.


604 Welding Inspection.


HST 0.00
To be estimated or upon received quotation(s) or bids.


605 Air / Vapour Barrier Inspection


HST 0.00
To be estimated or upon received quotation(s) or bids.


606 Envelope & Roofing Inspection


HST 0.00
To be estimated or upon received quotation(s) or bids.


607 Waterproofing Inspection


HST 0.00
To be estimated or upon received quotation(s) or bids.


608 Asphalt Testing


HST 0.00
To be estimated or upon received quotation(s) or bids.


609 Inspection Reports


HST 0.00
To be estimated or upon received quotation(s) or bids.



Total Materials Inspection & Testing

0.00
0.00 - 0%
Default calculation, total cost of section 600















700 Furnishings and Equipment












701 Furniture.


HST 0.00
To be estimated using the Furniture Standards or upon received quotation or bids. Refer to the University's Principal Furniture Designer.


702 Equipment


HST 0.00
To be estimated or upon received quotation(s) or bids.


703 Communication System - CCS (Cable, Telephone)


none 0.00
To be estimated with UofO CCS established costs or upon CCS quotations.


704 Security System - Protection (Alarms, Cameras, etc.)


none 0.00
To be estimated with Protection Services or upon Protection Services quotations.


705 Audio-Visual Equipment - Multimedia Distribution


none 0.00
To be estimated with TLSS Services or upon TLSS Services quotations.


706 Door Hardware (New Cylinders and Keys)


HST 0.00
If small quantities to be provided, to be estimated with PRS locksmith (ref. To Adm. Directive #1436-5). For greater quantities, if part of general contractor included in item 501, if not to be estimated upon received quotation(s) or bids


707 Graphics and Signage

0.00 HST 0.00
Default calculation, 0.5% of Construction / Renovation cost with a minimum of $500. (Formula based on 2009 statistics). Refer to PRS Signage Coordinator.


708 Window Treatments


HST 0.00
To be estimated or upon received quotation(s) or bids.



Total Furnishings and Equipment Costs

0.00
0.00 - 0%
Default calculation, total cost of section 700



Total C - Hard Costs

0.00
0.00 - 0%
Default calculation, total cost of sections 500, 550, 600 and 700















D Contingencies











800 Contingencies












801 Project Contingency (excl. Construction / Renovation Cost Component) 10.0% 0.00 HST 0.00
Default calculation, 10% of project costs less section 500 total construction /renovation costs (general contract). Once work commences, the contingency is revised periodically and should be modified to reflect reasonable contingency to protect from unknowns to project completion. (Formula based on February 12, 2009 procedure on project contingencies)


802 Escalation Provision 5.0% 0.00 0.00 HST 0.00
Default, 5% of total project cost times number of years to enter in box on the right of the percentage. (Formula as per Hanscomb statistics).


803 Other Contingencies / Allowances


HST 0.00
To be estimated upon special circumstances.



Total D - Contingencies

0.00
0.00 - 0%
Default calculation, total cost of section 800

















Total Excluding Tax

0.00



Default calculation, total cost of sections A, B, C and D excluding tax



Tax to be paid by Project (3.41% of HST when applicable)

#NAME?
IN ABOVE


Default calculation, net tax to be paid by the project (net tax includes the University rebate therefore only 3.41% and not 13%).



Grand Total

#NAME?
#NAME? #NAME? #NAME?
Default calculation, this amount is the total project estimate (used when preparing a Project Brief).































External Client : nwatson: Enter only if the project will be paid by an external client (clients without a banner account (i.e. Student Federation, University tenants like Starbucks)). To use the default calculation, choose "HST" from the pull down menu.






































Project Estimate Accuracy












Based on the estimate Class the project cost could range from:

#NAME? to #NAME?







Exclusions:





























$ cost / m²
% of total costs Total Soft Costs Total Hard Costs



100 Prime Professional Fees #NAME?
#NAME? #NAME? $0.00



200 Miscellaneous Professional Fees in Addition to Prime Professional Fees $-
0% #NAME? #NAME?



300 Site Development Costs $-
0%





400 Related Soft Costs $-
0%





500 Construction / Renovation Costs (General Contract) $-
0%





550 Related Construction / Renovation Costs (Outside of General Contract) $-
0%





600 Materials Inspection & Testing $-
0%





700 Furnishings and Equipment $-
0%





800 Contingencies $-
0%










#NAME?
#NAME?







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

...Sheet id universit eacute d ottawa university of service des immeubles physical resources project identification document date building room s title description purpose the faculty leader pl client manager pm consultant guesstimate cost anticipated start funding source completion initial estimate prepared by class jan enter total surface m carefully read classes and choose from pull down that corresponds to you are preparing entering sup will automatically create an analysis per item on right amount columns produce a report at bottom required statistics help with estimating standard schematic design within plus or minus actual net taxes costm how professional fees prime extended offer hst only if be managed externally use default fee calculation quot menu formula is based offers variable multiplied excluding section different current override put appropriate negotiated architect has external architectural related costs items engineer disb mechanical electrical delivery name first all c...

no reviews yet
Please Login to review.