Spreadsheet: 150364d1334480943-issue-with-lookup-and-advice-on-crrect-formulae-test-2
Sheet: Sheet1

Budget / Cost Head |  |  |  |  | Description | Note
1 |  |  |  | 1 | Land and Surveys |  |  |  | 'po1
 | 1.1 |  |  | 1.1 | Land
 |  | 1.1.1 |  | 1.1.1 | Site Evaluation Study | Includes third party consultants and not PCM related fees or expenses.
 |  | 1.1.2 |  | 1.1.2 | Cost of Land | Cost of land to include Land Deed transfer fee and all other associated costs.
 |  | 1.1.3 |  | 1.1.3' | Legal Counsel | This relates only to legal cost of land purchase along with land deed preparation.
 |  | 1.1.4 |  | 1.1.4 | Real Estate Agent Fees
 |  | 1.1.5 |  | 1.1.5 | City Development Fees | City development fees would include cost to get temporary connections for power, water, sewage and other utilities
 |  | 1.1.6 |  | 1.1.6 | Others
 | 1.2 |  |  | 1.2 | Surveys
 |  | 1.2.1 |  | 1.2.1 | Aerial Surveys
 |  | 1.2.2 |  | 1.2.2 | Topographic Survey
 |  | 1.2.3 |  | 1.2.3 | Geotechnical Survey
 |  | 1.2.4 |  | 1.2.4 | Sun / Wind / Rain Studies
 |  | 1.2.5 |  | 1.2.5 | Environmental Impact Assessment
 |  | 1.2.6 |  | 1.2.6 | Hydrological Survey
 |  | 1.2.7 |  | 1.2.7 | Zoning Variance Studies
 |  | 1.2.8 |  | 1.2.8 | Others
 | 1.3 |  |  | 1.3 | VAT | All VAT payment related to land and initial development works need to be input here
2 |  |  |  | 2 | Construction
 | 2.1 |  |  | 2.1 | Pre-Construction
 |  | 2.1.1 |  | 2.1.1 | FSLC- Foundation Stone Laying Ceremony | Only the direct costs associated with the foundation stone laying ceremony needs to be input here.
 |  | 2.1.2 |  | 2.1.2 | Boundary Wall & Guard Offices | Only the temporary boundary wall expenses needs to be included here.
 |  | 2.1.3 |  | 2.1.3 | Demolition of Existing Structures | Cost of demolition of existing structures including removal of debris from the site.
 |  | 2.1.4 |  | 2.1.4 | Site Development Works | Includes cost of initial site cleaning and laying of site wide water, electric and sewage connection etc
 |  | 2.1.5 |  | 2.1.5 | Plant Nursery | Cost of setting up nursery to start plantation so that this can act as a source for grown up planst as the project is completed.
 |  | 2.1.6 |  | 2.1.6 | External Utilities Connection | Cost incurred in utilities connection from the point of connnection to the property boundary.
 | 2.2 |  |  | 2.2 | Main Construction - General Contractor
 |  | 2.2.1 |  | 2.2.1 | Preliminaries
 |  | 2.2.2 |  | 2.2.2 | Civil Works
 |  | 2.2.3 |  | 2.2.3 | Mechanical Works
 |  | 2.2.4 |  | 2.2.4 | Electrical and Control Works
 |  | 2.2.5 |  | 2.2.5 | Plumbing & Fire Fighting Works
 |  | 2.2.6 |  | 2.2.6 | Provisional Sums
 |  |  | 2.2.6.1 | 2.2.6.1 | Civil Works
 |  |  | 2.2.6.2 | 2.2.6.2 | Mechanical Works
 |  |  | 2.2.6.3 | 2.2.6.3 | Electrical Works
 |  |  | 2.2.6.4 | 2.2.6.4 | Plumbing & Fire Fighting Works
 |  | 2.2.7 |  | 2.2.7 | Mock Up | This covers construction of mock up rooms or any other building element for review and approval purpose
 | 2.3 |  |  | 2.3 | Owner Furnished Materials
 |  | 2.3.1 |  | 2.3.1 | Civil Works
 |  | 2.3.2 |  | 2.3.2 | Mechanical Works
 |  | 2.3.3 |  | 2.3.3 | Electrical Works
 |  | 2.3.4 |  | 2.3.4 | Plumbing & Fire Fighting Works
 | 2.4 |  |  | 2.4 | Owner [NAME]
 |  | 2.4.1 |  | 2.4.1 | Civil Works
 |  | 2.4.2 |  | 2.4.2 | Mechanical Works
 |  | 2.4.3 |  | 2.4.3 | Electrical Works
 |  | 2.4.4 |  | 2.4.4 | Plumbing & Fire Fighting Works
 | 2.5 |  |  | 2.5 | Construction Contingency
 | 2.6 |  |  | 2.6 | VAT
3 |  |  |  | 3 | Professional Fees
 | 3.1 |  |  | 3.1 | Design Competition
 |  | 3.1.1 |  | 3.1.1 | Preparation of Competition Documents
 |  | 3.1.2 |  | 3.1.2 | Remuneration for Participants
 |  | 3.1.3 |  | 3.1.3 | Remuneration for Judges
 |  | 3.1.4 |  | 3.1.4 | Reimbursables
 |  |  | 3.1.4.1 | 3.1.4.1 | Travel
 |  |  | 3.1.4.2 | 3.1.4.2 | RCA
 | 3.2 |  |  | 3.2 | Prime Consultant or Architect
 |  | 3.2.1 |  | 3.2.1 | Design Fees inc Site Supervision
 |  |  | 3.2.1.1 | 3.2.1.1 | Masterplanning
 |  |  | 3.2.1.2 | 3.2.1.2 | Concept Design
 |  |  | 3.2.1.3 | 3.2.1.3 | Schematic Design
 |  |  | 3.2.1.4 | 3.2.1.4 | Design Development
 |  |  | 3.2.1.5 | 3.2.1.5 | Construction Drawings
 |  |  | 3.2.1.6 | 3.2.1.6 | Tender
 |  |  | 2.2.1.7 | 2.2.1.7 | Construction Administration
 |  | 3.2.2 |  | 3.2.2 | Reimbursables
 |  |  | 3.2.2.1 | 3.2.2.1 | Travel
 |  |  | 3.2.2.2 | 3.2.2.2 | RCA
 | 3.3 |  |  | 3.3 | Architect on Record
 |  | 3.3.1 |  | 3.3.1 | Design Fees inc Site Supervision
 |  | 3.3.2 |  | 3.3.2 | Reimbursable
 |  |  | 3.3.2.1 | 3.3.2.1 | Travel
 |  |  | 3.3.2.2 | 3.3.2.2 | RCA
 | 3.4 |  |  | 3.4 | Engineering Consultants
 |  | 3.4.1 |  | 3.4.1 | Design Fees - Structural Consultant
 |  | 3.4.2 |  | 3.4.2 | Design Fees - MEP Consultant
 |  | 3.4.3 |  | 3.4.3 | Reimbursable - Structural Consultant
 |  |  | 3.4.3.1 | 3.4.3.1 | Travel
 |  |  | 3.4.3.2 | 3.4.3.2 | RCA
 |  | 3.4.4 |  | 3.4.4 | Reimbursable - MEP Consultant
 |  |  | 3.4.4.1 | 3.4.4.1 | Travel
 |  |  | 3.4.4.2 | 3.4.4.2 | RCA
 | 3.5 |  |  | 3.5 | Quantity Surveyor
 |  | 3.5.1 |  | 3.5.1 | Fees
 |  | 3.5.2 |  | 3.5.2 | Reimbursables
 |  |  | 3.5.2.1 | 3.5.2.1 | Travel
 |  |  | 3.5.2.2 | 3.5.2.2 | RCA
 | 3.6 |  |  | 3.6 | Landscape Architect
 |  | 3.6.1 |  | 3.6.1 | Design Fees
 |  | 3.6.2 |  | 3.6.2 | Reimbursables
 |  |  | 3.6.2.1 | 3.6.2.1 | Travel
 |  |  | 3.6.2.2 | 3.6.2.2 | RCA
 | 3.7 |  |  | 3.7 | Legal Consultants
 |  | 3.7.1 |  | 3.7.1 | Professional Fees
 |  | 3.7.2 |  | 3.7.2 | Reimbursables
 |  |  | 3.7.2.1 | 3.7.2.1 | Travel
 |  |  | 3.7.2.2 | 3.7.2.2 | RCA
 | 3.8 |  |  | 3.8 | Specialty Consultants
 |  | 3.8.1 |  | 3.8.1 | Interior Design Consultant
 |  | 3.8.2 |  | 3.8.2 | Hydrological Consultant
 |  | 3.8.3 |  | 3.8.3 | Traffic Consultant
 |  | 3.8.4 |  | 3.8.4 | Acoustic Consultant
 |  | 3.8.5 |  | 3.8.5 | [NAME]
 |  | 3.8.6 |  | 3.8.6 | Laundry Consultant
 |  | 3.8.7 |  | 3.8.7 | Spa Consultant
 |  | 3.8.8 |  | 3.8.8 | Back of the House Consultant
 |  | 3.8.9 |  | 3.8.9 | Others
4 |  |  |  | 4 | Project Management
 | 4.1 |  |  | 4.1 | Hourly Professional Fees
 | 4.2 |  |  | 4.2 | Head Office Reimbursables
 |  | 4.1.1 |  | 4.1.1 | Travel
 |  | 4.1.2 |  | 4.1.2 | RCA
 |  | 4.1.3 |  | 4.1.3 | Site Expenses
 |  |  | 4.1.2.1 | 4.1.2.1 | Site Staff Salaries
 |  |  | 4.1.2.2 | 4.1.2.2 | Home Travel, Medical and Other Employment Cost
 |  |  | 4.1.2.3 | 4.1.2.3 | Project Related Travel and Local Transport
 |  |  | 4.1.2.1 | 4.1.2.1 | Site CAPEX
 |  |  | 4.1.2.2 | 4.1.2.2 | Site Office - Rent, Utilities etc
 |  |  | 4.1.2.3 | 4.1.2.3 | RCA
 | 4.2 |  |  | 4.2 | VAT
5 |  |  |  | 5 | Furniture, Fittings & Equipment
 | 5.1 |  |  | 5.1 | Loose Furniture
 | 5.2 |  |  | 5.2 | Fixed Furniture / Millwork
 | 5.3 |  |  | 5.3 | Fittings / Equipment
 |  | 5.3.1 |  | 5.3.1 | Sanitary Equipment
 |  | 5.3.2 |  | 5.3.2 | [NAME]
 |  | 5.3.3 |  | 5.3.3 | Sports Equipment
 |  | 5.3.4 |  | 5.3.4 | IT Equipment
 |  | 5.3.5 |  | 5.3.5 | Laundry Equipment
 |  | 5.3.6 |  | 5.3.6 | Laboratory Equipment
 |  | 5.3.7 |  | 5.3.7 | Communication Equipment
 |  | 5.3.8 |  | 5.3.8 | Others
 | 5.4 |  |  | 5.4 | Artwork & Signages
 | 5.5 |  |  | 5.5 | Mock Up Room Furniture | This covers any FFE related expenses for a mock up room or any other building element like toilet
 | 5.6 |  |  | 5.6 | VAT
6 |  |  |  | 6 | Statutory Charges and Testing Fees
 | 6.1 |  |  | 6.1 | Statutory Charges
 | 6.2 |  |  | 6.2 | Material Testing
 | 6.3 |  |  | 6.3 | Counsel Fees
 | 6.4 |  |  | 6.4 | VAT
7 |  |  |  | 7 | Project Contingency