GUU: 674 Detailed Project Report: Commercial Site (Sector 87, Mohali)
GUU: 674 Detailed Project Report: Commercial Site (Sector 87, Mohali)
(SESSION 2020-2022)
|Page
Detailed Project Report (sector 87 Mohali),2021
Table of Contents
Chapter 1 Introduction...............................................................................................................1
1.6 Methodology.....................................................................................................................2
2.1 Definitions........................................................................................................................4
2.2 Terminology.....................................................................................................................4
3.2 3 Surrounding.................................................................................................................12
i|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
4.3 Income............................................................................................................................33
4.9 Installments.....................................................................................................................40
4.15 Conclusion....................................................................................................................46
References.........................................................................................................................47
ii | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
List of Tables:
Table 3-1 Administrative Structure of District SAS Nagar.....................................................12
Table 3-2 Surrounding Landmarks of Sector 87......................................................................12
Table 3-3 Details of the components of the site.......................................................................16
Table 3-4 Area under circulation components.........................................................................18
Table 3-5 Details of the utilities provided in the site plan.......................................................21
Table 4-1 List of Activities in development of site..................................................................25
Table 4-2 Details of activities with their quantities and their cost estimation.........................27
Table 4-3 Details of saleable components of the site...............................................................31
Table 4-4 Details of selling components..................................................................................34
Table 4-5 Details of selling Plots.............................................................................................35
Table 4-6 Location of components and their market price......................................................37
Table 4-7 Details of selling component of SCO......................................................................38
Table 4-8 Details of selling component of SCF.......................................................................38
Table 4-9 Details of selling component of Booth....................................................................39
Table 4-10 Details of Auction of Malls...................................................................................40
Table 4-11 Details of cost recover from Installments..............................................................40
Table 4-12 Details of components cost recovery from installment.........................................41
Table 4-13 Details of Income incurred through all selling components..................................42
Table 4-14 Details of Cumulative Income & Expenditure of Every month............................45
iii | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
List of Figure:
Figure 1-1 Methodology............................................................................................................2
Figure 2-1 Life cycle of Project.................................................................................................5
Figure 2-2 Types of Network Techniques.................................................................................8
Figure 2-3 PERT diagram..........................................................................................................8
Figure 2-4 CPM diagram...........................................................................................................9
Figure 2-5 GNATT chart.........................................................................................................10
Figure 3-1 Location of Sector 87.............................................................................................12
Figure 3-2 Surrounding Landmarks of Sector 87....................................................................13
Figure 3-3 Land Distribution Data...........................................................................................13
Figure 3-4 Layout Plan.............................................................................................................15
Figure 3-5 Circulation Layout..................................................................................................19
Figure 3-6 Cross-section of Major Road..................................................................................20
Figure 3-7 Cross-section of Minor Road.................................................................................20
Figure 3-8 Proposed Utility Plan..............................................................................................22
Figure 3-9 Detailed cross section of utility trench...................................................................23
Figure 3-10 Details of Trees Planted along the Road..............................................................23
Figure 3-11 Proposed Landscape Plan.....................................................................................24
Figure 4-1 Network diagram of the development of commercial site.....................................43
iv | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Chapter 1 Introduction
1.1 Introduction to exercise
Preparation of Detailed Project Report (DPR) is an important tool in any development plan. It
gives the idea of project how, when the project is completed and at what cost, whether it
makes profit or not are been studied while preparing DPR. We the students of Master of
Planning (Urban) semester III under the Planning Practice GUU:674 Detailed Project Report
of Urban Project have to undertake the Project of site development plan. This exercise mainly
focuses on the preparation of DPR for different projects related to residential, commercial &
Industrial site plans. We had taken commercial site plan of sector 87 in SAS Nagar, Mohali.
1|Page
Detailed Project Report (sector 87 Mohali),2021
1.6 Methodology
On the basis of site plan prepared for sector 87, SAS Nagar, Mohali the detailed project
report would be prepared. The stages to be followed in the preparation detailed project report
for commercial site plan would be as follows:
Stage 1 Theoretical Framework: it would cover the literature which include the need,
scope, objectives, definition of project, project formulation and DPR, types of DPR, project
life cycle, network diagrams, PERT, CPM, GNATT Chart.
Stage 2 Site selection, requirement and site plans: It would cover the requirements for
commercial, public/semi-public, water requirements and parks and open spaces on the basis
of population to be catered, area of site and considering the norms and standards and
development controls. This stage would cover the proposals for different aspects including
layout plan, circulation plan, utility plan and landscaping plan.
Stage 3
1. Identification of Activities:
This would include identification of various activities of project and the framing of these
activities. The events that would be included under various activities are also identified.
2|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
3|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
2.1 Definitions
Project
2.2 Terminology
Network: It is a graphical plan of all the activities that must be completed to reach the end
objective of the project showing their interdependency and inter-relationship. The
components which make up the network are events and activities.
Event: Event, also called mode, is a specific definable accomplishment in a project plan. It is
a point in time at which an activity begins or ends. It consumes neither time nor resources. It
4|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
is a point in time and not passage in time. It is the state between the completion of preceding
activity and the beginning of succeeding one.
Activity: It is the smallest unit of productive effort in a project. It is the performance of task
between any two events. It is a task performed over a period of time. It is a homogeneous
element of continuous work consuming time and resources in a network plan. It is
represented by an arrow.
Gantt Charts: A Gantt chart is a type of bar chart, devised by Henry Gantt in the 1910s, that
illustrates a project schedule. Gantt charts illustrate the start and finish dates of the terminal
elements and summary elements of a project. Terminal elements and summary elements
comprise the work breakdown structure of the project. It is a pictorial device in which the
activities are represented by horizontal bars on the time axis. The left end of the bar shows
the beginning of time, the right end shows the ending time. The duration of the activity is
indicated by the length of the bar.
PROJECT PREPARATION
PROJECT EVALUATION Objectives, pre –requisites,
Evaluation or assessment is inputs, output, organization,
done stagewise and after participants, costs and earnings
completion of the project. are calculated, a financial plan
is prepared.
5|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Project Identification: The project need is identified in the initiation phase. It signals
the start of a project. The first phase explores concept, scope, feasibility studies,
project charter.
Project preparation/planning: Planning phase is where the project solution is
further explored and the steps necessary to achieve their goals. This phase further
details the scope and tasks and resources are identified and assigned during this phase.
Project Appraisal: The project is been assessed in this phase where the project is
feasible in terms its benefits and their maximum extent of reach.
Project implementation & monitoring: The project management and lines of
command of established, and various implementation procedures established. The
monitoring of the project is also done during the implementation of project.
Project Evaluation: The project Evaluation or assessment is done stagewise and after
completion of the project.
This step is very important in this required activity are identified for the implementation of
the layout and to get desired output. Activity decides the required resources to be used in the
project. E.g.: In Residential project: levelling, slope for laying utility lines, plotting etc.
According to the decided activity required resources and their sources are identified and
estimation is done. Eg: Labour requirement, raw material for construction etc.
a) Sources of Finance:
Private: A private sector project is one in which the ownership is completely in the hands of
the project promoters and investors. Profit maximization is the prime objective of private
sector projects since the investors invest their money in such projects only with the sole idea
of earning better returns. Public sector projects are those that are owned by the state. The sole
idea of the projects is the betterment and development of the country. Public Private
6|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Partnership: Joint sector projects are those in which the ownership is shared by the
Government and by private entrepreneurs.
The project schedule is the tool that communicates what work needs to be performed, which
resources of the organization will perform the work and the timeframes in which that work
needs to be performed. The project schedule should reflect all of the work associated with
delivering the project on time. Without a full and complete schedule, the project manager will
be unable to communicate the complete effort, in terms of cost and resources, necessary to
deliver the project.
Project manager is responsible for getting the job done in a scheduled way with a specific
budget and the resources are under his control. Network techniques assist the manager in
planning, scheduling and controlling the work. The techniques minimize the troubles such as
bottlenecks, delays and the intervention of critical factors. It enables the project formulation
team to identify the critical path with long series of activities. The events and activities are
to be identified for the successful completion of the work.
7|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
PERT Chart
Construction Tools: Constructed with a variety of attributes, such as earliest and latest start
dates for each task, earliest and latest finish dates for each task, and slack time between tasks.
Uses: The PERT chart is very useful for planning and tracking entire projects or for
scheduling and tracking the implementation phase of a planning or improvement effort. It
works to avoid unrealistic timetables and schedule expectations. It helps to identify and
shorten tasks that are bottlenecks. It focuses and attention on most critical tasks. A PERT
chart can document an entire project or a key phase of a project.[ CITATION Mna16 \l
1033 ]
8|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Advantages of PERT
This technique gives the management the ability to plan the best possible use of resources to
achieve a given goal within the overall time and cost limitations. It helps management to
handle the uncertainties involved in programmes. It presses for the right action, at the
right point and at that right time in the organization.
Disadvantages of PERT
The basic difficulty comes in the way of time estimates for the completion of activities
because of non-repetitive type. This technique does not consider resources required at various
stages of the project. Use of this technique for active control of a project requires frequent
updating and revising the PERT calculations and this proves quite a costly affair.
The CPM or Critical Path Analysis, is a mathematically based algorithm for scheduling a set
of project activities. Critical Path Method is a technique for analyzing projects by
determining the longest sequence of tasks through a project network. By concentrating on the
most critical tasks, it can be ensured that the project is on time and is keeping pace with the
schedule setup.
Importance of CPM
It helps the top management to concentrate their attention on critical activities and their
completion in time. If any activity on the critical path is delayed it will the delay the project
completion. Knowledge of critical and non-critical activities helps the management to divert
the resources from non-critical activities which are in advance to critical activities for
achieving economy.
9|Page
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Advantages of CPM
• It helps in ascertaining the time schedule
• It identifies the most critical elements and thus more attention can be paid to these
activities.
Disadvantages of CPM
• CPM fails to incorporate statistical analysis in determining the time estimates.
• It operates on the assumption that there is a precise known time that each activity take
but this may not be true in actual life.
• It is difficult to use CPM as a controlling device for the simple reason that one must
repeat the entire evaluation of the project each time when changes are introduced into
the network.
GNATT Chart
It is a type of bar chart, developed by Henry Gantt in the 1910s, that illustrates a project
schedule. Gantt charts illustrate the start and finish dates of the terminal elements and
summary elements of a project which comprise the work breakdown structure of the project.
Some Gantt charts also show the dependency relationships between activities.
10 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Advantages
• Gantt chart is useful and valuable for small projects that fit on a single sheet or screen
Disadvantages
2. Work Breakdown Structure: Both PERT and Gantt charts will display the tasks to be
completed, but the charts emphasize different pieces. In Gantt charts, the focus is on
percentage completion of each task without demonstrating the link that two tasks may have to
each other. In PERT, it does not show the percentage completed, because it employs a
network model, it is easy to see which tasks depend on each other.
11 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
3. Simplification: Gantt charts are ideal for straightforward projects with few interlinking
tasks. Gantt charts present project tasks and time allocation as the only two pieces of data an
a limitation where there are interconnecting tasks that depend on each other. PERT charts,
including project tasks and time allocation, display dependency. Gantt charts are easier to
change as a task moves along and it comes closer to completion.
4. Accuracy: Gantt charts are simpler to read but PERT charts extend an element of detail to
the project scheduling through both the network model's ability to display dependency and
PERT's unique ability to anticipate actual time that a task will take to completion. Tasks in
PERT charts will have 3 representative time structures i.e., optimistic, most likely, and
pessimistic. By averaging these times, a manager can predict how long a task will actually
take to complete more realistically than the single time that Gantt charts provide.
3.23 Surrounding
Table 3-1 Administrative Structure of District SAS Nagar
12 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Important towns of the Mohali (HQ), Kharar, Zirakpur & Dera Bassi,
district Kurali
Source: Primary Census Abstract, Census of India, 2011
13 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Land
12%
Distribution
25%
Data
18%
45%
3.5 Layout
Plan
Covered area Open space Roads Green Area
The Site is
accessible
from all the four sides i.e. It has four exit and entry points. There is an integration of
recreational area with cultural and commercial area. Grid iron pattern is taken into
consideration. Pedestrianization and vehicular movement are interrelated yet segregated.
The site is further divided into seven zones depending on its functions.
ZONE 1 is based on the concept of Introvert Planning. Centralized Parking is provided at
the entrance. Whole of the zone is pedestrianized. Large Plazas and Green Areas are
provided at various intervals. The components are arranged in such a way that it gives the
feeling of grandness and openness. It includes various components such as SCOs, SCFs,
restaurant and hotel.
ZONE 2 is a Cultural Zone which also have Centralized Parking is at the entrance. The
components are arranged in such a way that they are easily accessible by vehicles and is
also pedestrian friendly. Exhibition Ground at the center surrounded by cultural shops
promotes traditional craftsmanship along with cultural and heritage of the city. Some of
the components are library, art gallery, club, multiplex, cultural shops, info centre,
restaurant, and hotel along with booths.
ZONE 4 is a Silent Zone which have Centralized Parking is at the centre. The
components are arranged in such a way that they are easily accessible by vehicles.
Components here are filling stations, dispensary, bank, police post, fire station,
gymnasium, hotel, restaurant, limited wholesale and warehouse.
ZONE 5 is a Hot Zone mainly consists of Commercial Offices. It is mainly accessible by
vehicles. The offices are arranged in such a way that maximum of four offices share
common green outdoor areas. The post-COVID office may be forever changed where
designing portable toolboxes, germ-free pods and modular barriers that can adapt existing
14 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
spaces while shaping the way we will work in the future. This zone also includes
restaurants.
ZONE 6 is also a Gold Mine Zone mainly consists of Commercial areas such as
showrooms, Malls, food court and amphitheater. The layout of this zone is different from
rest, the components are placed here are aligned diagonally with respect to the dashmesh
canal passing through the site. It also includes the main recreational area of the site. It is
one of the main revenues generating zone of the site. It has Centralized Parking is at the
entrance is fully pedestrian friendly.
ZONE 7 is also a Silver Mine Zone mainly consists of Commercial shops such as small,
medium and large shops. The layout of this zone is similar to that of zone 4, gold mine
zone. It also includes the plazas and large open green spaces. Zone 7 and 6 are well
connected through the ramp.
15 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
S.no Component Name Site area (sq.mt) FAR Buitup area sq.mt
ZONE 1
1 Shop cum offices 18684.72 3 49132198.8
2 Shops Cum Flats 11999.82 3 49132198.8
16 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
17 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
The components derived under commercial and public / semi-public land use are further
distributed by following norms and standards provided by Punjab Urban Planning &
Development Authority (PUDA) as well as URDPFI Guidelines. The basis of assumption
was taken through the comparative analysis of case studies as well as catchment analysis.
These are shown in the following table
18 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
19 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
20 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Water supply: Water is supplied through municipal corporation pipelines. Loop system will
be followed for water supply system. Hierarchy of pipes has been followed. The water supply
network is laid out in the area along the road network under Footpath Street so that at the
time of maintenance of sewerage and water pipes streets are not been broken nor the roots of
trees harm the pipes. Water supply connections are taken from Min to sub-main pipes.
Earthen pipes are used. The details of their length and width were mentioned below. Pumps
are used for flatted development relief valve are used to control pressure in pipes and prevent
it from bursting. Shut off valve are used to cut off water supply when the maintenance work
of pipes is need to be done. Junction valves are used to control the water pressure at
junctions.
Sewerage: Tree system will be followed for sewerage system. Combined sewerage system is
used as the rainfall in SAS Nagar, Mohali is moderate hence to acquire self-cleaning velocity
of sewers this type of system is used moreover the cost of pipes is reduced. Egg-shape
21 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
sewers are used so that sewers have sufficient self-cleaning velocity even when rainfall is
low. Earthen pipes are used for service pipes. The details of Sewer pipes are mentioned
below. Rectangular manholes are provided with concrete sewers are used for collector pipes.
Manholes are placed 40 m apart & at junctions of pipes & at dead ends. Laid to a slope of 1
in 75 acquiring a self-cleaning velocity of 0.90m/sec. Ventilation valves are provided at
100m distance to avoid foul smell from pipes and for decreasing air pressure from pipes.
Table 3-5 Details of the utilities provided in the site plan
Dustbins (No.s) 42
Source: computed values
22 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
23 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Power cables
Storm water
Water pipe
Sewer line
24 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
25 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
26 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
The activities are recognized, and the events that occur within the activities are documented,
as each activity has a certain number of events. Because engineering and structural drawings
are not taken, estimated rates are taken as generalized rates. Tenders or other government
projects, as well as contractor and architect on-site work, can be used to determine rates. All
27 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
activities require money to be completed or developed, and cost estimation for the entire
project is required to determine the project's cost as well as the amount of money that must be
made in order to make a profit.
Table 4-7 Details of activities with their quantities and their cost estimation
S.N Activity Sub- Activity Durati Units Unit Quant Estimated Estimated
o on of (area cost in um cost cost per
Activit (sq.m), rupee compone
y length s nt
(m)
1 Acquisition Preliminary 0 10117 11862 Sq.mt 12000785 12000785
of land notification 00 400 400
(section 4)
2 Objection
(section 5)
3 Decision of
Objection
(section 6)
4 Possession of
Land
5 Award made
(section 11)
6 Compensation
charges
7 Demarcati 15 4280 4000 Mt 17120000 17120000
on of
Boundary
8 Site 30 250 5000 Acres 1250000 1250000
Leveling
and
Cleaning
9 Designing 20 10117 100 Sq.mt 10117000 10117000
of Layout 00 0 0
10 Demarcati 20 10536 100 Sq.mt 10536800 10536800
on of 8
Roads as
per Layout
Plan
28 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
29 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
250mm dia
pipe
26 Storm Laying of 30 12600 3,000 Mt 37800000 38280000
Water Storm Water
Network Pipelines
28 construction 320 1,500 No.s 480000
of strom water
manholes
29 Utility Laying of 30 11630 2,000 Mt 23260000 46520000
cables power cables
30 Laying of 11630 1,000 Mt 11630000
Telecommunic
ation cables
31 Laying of 11630 1,000 Mt 11630000
Optical Fiber
cables
32 Roads Construction 200 5688 2600 Sq.mt 14788800 12825630
(Major) of roads 0
carriage way
of 15.5m wide
Construction 50430 2250 Sq.mt 11346750
of roads 0
carriage way
of 13.5m wide
33 Roads Construction 120 5112 2000 Sq.mt 10224000 10350000
(Minor) of roads 0
carriage way
of 8 m wide
34 Construction 24138 2000 Sq.mt 48276000
of roads
carriage way
of 6 m wide
35 Construction 20000 2250 Sq.mt 45000000
of roads
carriage way
of 13.5m wide
36 ESS Construction 120 2 40000 No’s 8000000 8000000
of ESS 00
37 Street construction 60 385 3000 No’s 1155000 1155000
Lights of Street Lights
foundation
and
installment of
poles
38 transforme Laying of 30 12 10000 No’s 1200000 1200000
rs transformers 0
39 OHR Construction 180 2 80000 No’s 1600000 1600000
of OHR 0
40 WPS Construction 120 1 55000 No’s 5500000 5500000
of WPS 00
41 Constructi SCO 210 56050 5000 Sq.mt 28025000 50868800
30 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
on of 0 0
42 buildings SCF 36018 5000 Sq.mt 18009000
0
43 Small booths 84 30000 No’s 25200000
0
44 cultural shops 11574 2000 Sq.mt 23148000
45 Parking Construction 40 25619 1000 Sq.mt 25619000 25619000
facilities of open
parking
46 Constructi 45 23472 6500 Sq.mt 15256800 15256800
on of cycle 0 0
tracks
47 Constructi 30 33884 500 Sq.mt 16942000 16942000
on of
footpaths
48 Plantation Pulkhan tree 15 200 200 No’s 40000 168150
49 along the Kusum tree 145 150 No’s 21750
50 road Kanak champa 40 200 No’s 8000
51 Devil tree 180 180 No’s 32400
52 Arjuna tree 440 150 No’s 66000
53 Landscape Trees in 140
cultural areas
54 Amaltas trees 68 250 No’s 17000 30000
55 Nili gulmohar 60 100 No’s 6000
56 Jacranda 20 150 No’s 3000
mimososafelio
57 Casa javanicia 20 200 No’s 4000
58 Trees in
recreational
park
59 Amaltas 30 250 No’s 7500 24250
60 Gulmohar 25 150 No’s 3750
61 Casa javanicia 30 200 No’s 6000
62 Jacranda 20 150 No’s 3000
mimososafelio
63 White champa 20 200 No’s 4000
64 Green area Green areas in 30 13137 450 Sq.mt 5911650 29464665
developme cultural zone .6
65 nt Green area in 25575. 600 Sq.mt 15345465
recreational 78 .6
park
66 Green area in 18239 450 Sq.mt 8207550
zone 1 and 5
67 Auction Auction of 20
malls
68 Informal Installation of 20 640 10000 No’s 64000000 64000000
Unit units 0
69 Infrastruct installation of 10 8 50000 No’s 4000000 5936000
ure public toilets 0
70 installation of 9 10000 No’s 900000
31 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
portable water 0
71 installation of 42 8000 No’s 336000
dustbins
72 Installation of 70 10000 No’s 700000
benches
73 Handover 30
Total Development cost 12875543
626
Source: - Computed values
S.no Component Name Site area (sq.mt) FAR Built-up area sq.mt
ZONE 1
1 Shop cum offices 18684.72 3 49132198.8
2 Shops Cum Flats 11999.82 3 49132198.8
3 Restaurant 3999.94 2 32754799.2
4 Hotel 5649.92 2 32754799.2
5 Booths (2.4sqmt) 62.40 1 62.4
ZONE 2 0
6 Recreational Clubs 10159.85 1 32892390.4
7 Restaurant -1 5549.92 2 32754799.2
8 Miniplex 6099.91 1.25 20471749.5
9 Exhibition hall-1 5149.92 1.5 24566099.4
10 Hotel -1 8129.88 2 32754799.2
11 Restaurant -2 5999.91 2 32754799.2
12 Art/ Craft/ Music/ Dance Centre 2499.96 1.2 19652879.52
13 Admin office 3999.94 1.25 20471749.5
14 Information Centre 3999.94 1.5 24566099.4
15 Museum 13799.80 1.3 21290619.48
16 Post Office 969.99 1.25 20471749.5
17 Hotel -2 3999.94 2 32754799.2
18 Booths 699.99 1 16377399.6
19 Art Galleries 11999.82 1.5 24566099.4
20 Library 5649.92 1.5 24566099.4
21 Cultural shops 5767.91 1 16377399.6
22 Exhibition Ground 3039.00
23 Booths (2.4sqmt) 48.00 1 48
ZONE-3
24 Restaurant -1 Zone-3 5999.91 2 32754799.2
25 Auditorium 7999.88 1 16377399.6
26 Museum Zone-2 13799.80 1.3 21290619.48
27 Art Gallery-1 Zone-3 5999.91 1.5 24566099.4
28 Art Gallery-2 Zone-3 5999.91 1.5 24566099.4
32 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
= 12875543626/482702.34
33 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
4.3 Income
This section contains a list of the income made from the sale of various components whose
minimum price is determined by the reserved price. As a result, this chapter discusses the
selling price of various specified activities, break even points, net profit, and cost recovery
methods.
Total development cost of the site is 12875543626 crores and the saleable area for the site
calculated is 482702.34 sq.m. Therefore, the reserve price so calculated is Rs 26, 673 per
sq.m.
34 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
Centre
Information Centre 4,000 106692000
Museum Zone-2 13800 368087400
Art Galleries Zone-2 6,000 160038000
Library 5,650 150702450
Cultural shops Zone-2 28 746844
Auditorium 8000 213384000
Museum Zone-2 13800 368087400
Art Gallery-1 Zone-3 6,000 160038000
Art Gallery-2 Zone-3 6,000 160038000
Exhibition -1 Zone 3 6500 173374500
Exhibition -2 Zone 3 6500 173374500
Cultural shops Zone-3 28 746844
Transferrable Dispensary 1300 34674900
sites
Dispensary 1300 34674900
Electric substations 1000 26673000
Fire Station 4,100 109359300
Police post 2,025 54012825
Bank-1 3000 80019000
Bank-2 3000 80019000
Post Office 970 25872810
Grand total 2955661803
35 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
36 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
According to market price from online source we assumed our selling price different
components as their details are mentioned below
Ground floor
37 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
According to above table the selling components of SCO and SCF buildings were taken as
per market price. The details are mentioned below
38 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
39 | P a g e
Detailed Project Report (sector 87 Mohali),2021
= 640,00,000
40 | P a g e
Detailed Project Report (sector 87 Mohali),2021
Auctions of malls
Zone-5 Mall-1 10000 2 4.94 150000 1500000000.00 3000000000.00
Source: computed Value
4.9 Installments
We have assumed four instalments i.e., 15%, 20%, 30% and 30% and 5 % taken on
application These components are profit oriented and pure commercial in nature. The first
instalment after the application installment cost is of 15 % is set during the construction of
roads and services. The second instalment of 20% is set during the beginning of construction
of SCOs, SCF and Booths and other infrastructure like OHR, transformer laying. Further,
third instalment of 30% is set during construction of Showrooms, SCOs, Booths & SCFs and
before the landscaping works. In end, the last i.e., fourth instalment of 30% is set to charge on
possession of SCOs, Booths & SCFs. The instalments fixed for components i.e., SCOs,
Booths and SCFs are given below
Compiled Installment
Application (5%) 4438412915
Installment-I (15%) 13929964950
Installment-II (20%) 17753651660
Installment-III (30%) 26630477490
Installment-IV (30%) 26630477490
Grand Total (Rs. ) 89382984505
41 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
SCOs (Unit Area=100 sq.m) GF GF+Corner FF FF+Corner SF SF + Corner TF TF + Corner FF FF+Corner Grand Total
1. Plaza Facing 3230000000 561000000 2907000000 504900000 2616300000 454410000 2354670000 408969000 2119203000 368072100 15524524100
Application (5%) 161500000 28050000 145350000 25245000 130815000 22720500 117733500 20448450 105960150 18403605 776226205
Installment-I (15%) 48,45,00,000 11,22,00,000 58,14,00,000 10,09,80,000 52,32,60,000 9,08,82,000 47,09,34,000 8,17,93,800 42,38,40,600 7,36,14,420 2943404820
Installment-II (20%) 64,60,00,000 11,22,00,000 58,14,00,000 10,09,80,000 52,32,60,000 9,08,82,000 47,09,34,000 8,17,93,800 42,38,40,600 7,36,14,420 3104904820
Installment-III (30%) 96,90,00,000 16,83,00,000 87,21,00,000 15,14,70,000 78,48,90,000 13,63,23,000 70,64,01,000 12,26,90,700 63,57,60,900 11,04,21,630 4657357230
Installment-IV (30%) 96,90,00,000 16,83,00,000 87,21,00,000 15,14,70,000 78,48,90,000 13,63,23,000 70,64,01,000 12,26,90,700 63,57,60,900 11,04,21,630 4657357230
2. Non Plaza Facing (No.) 2892500000 286000000 2603250000 257400000 2342925000 231660000 2108632500 208494000 1897769250 187644600 13016275350
Application (5%) 144625000 14300000 130162500 12870000 117146250 11583000 105431625 10424700 94888462.5 9382230 650813767.5
Installment-I (15%) 43,38,75,000 4,29,00,000 39,04,87,500 3,86,10,000 35,14,38,750 3,47,49,000 31,62,94,875 3,12,74,100 28,46,65,388 2,81,46,690 1952441303
Installment-II (20%) 57,85,00,000 5,72,00,000 52,06,50,000 5,14,80,000 46,85,85,000 4,63,32,000 42,17,26,500 4,16,98,800 37,95,53,850 3,75,28,920 2603255070
Installment-III (30%) 86,77,50,000 8,58,00,000 78,09,75,000 7,72,20,000 70,28,77,500 6,94,98,000 63,25,89,750 6,25,48,200 56,93,30,775 5,62,93,380 3904882605
Installment-IV (30%) 86,77,50,000 8,58,00,000 78,09,75,000 7,72,20,000 70,28,77,500 6,94,98,000 63,25,89,750 6,25,48,200 56,93,30,775 5,62,93,380 3904882605
SCF (Unit Area=100 sq.m) GF GF+Corner FF FF+Corner SF SF + Corner TF TF + Corner FF FF+Corner Grand Total
1. Plaza Facing (No.) 960000000 264000000 864000000 237600000 777600000 213840000 699840000 192456000 629856000 173210400 5012402400
Application (5%) 48000000 13200000 43200000 11880000 38880000 10692000 34992000 9622800 31492800 8660520 250620120
Installment-I (15%) 14,40,00,000 3,96,00,000 12,96,00,000 3,56,40,000 11,66,40,000 3,20,76,000 10,49,76,000 2,88,68,400 9,44,78,400 2,59,81,560 751860360
Installment-II (20%) 19,20,00,000 5,28,00,000 17,28,00,000 4,75,20,000 15,55,20,000 4,27,68,000 13,99,68,000 3,84,91,200 12,59,71,200 3,46,42,080 1002480480
Installment-III (30%) 28,80,00,000 7,92,00,000 25,92,00,000 7,12,80,000 23,32,80,000 6,41,52,000 20,99,52,000 5,77,36,800 18,89,56,800 5,19,63,120 1503720720
Installment-IV (30%) 28,80,00,000 7,92,00,000 25,92,00,000 7,12,80,000 23,32,80,000 6,41,52,000 20,99,52,000 5,77,36,800 18,89,56,800 5,19,63,120 1503720720
1. Non Plaza Facing (No.) 3097500000 924000000 2787750000 831600000 2508975000 748440000 2258077500 673596000 2032269750 606236400 16468444650
Application (5%) 154875000 46200000 139387500 41580000 125448750 37422000 112903875 33679800 101613487.5 30311820 823422232.5
Installment-I (15%) 46,46,25,000 13,86,00,000 41,81,62,500 12,47,40,000 37,63,46,250 11,22,66,000 33,87,11,625 10,10,39,400 30,48,40,463 9,09,35,460 2470266698
Installment-II (20%) 61,95,00,000 18,48,00,000 55,75,50,000 16,63,20,000 50,17,95,000 14,96,88,000 45,16,15,500 13,47,19,200 40,64,53,950 12,12,47,280 3293688930
Installment-III (30%) 92,92,50,000 27,72,00,000 83,63,25,000 24,94,80,000 75,26,92,500 22,45,32,000 67,74,23,250 20,20,78,800 60,96,80,925 18,18,70,920 4940533395
Installment-IV (30%) 92,92,50,000 27,72,00,000 83,63,25,000 24,94,80,000 75,26,92,500 22,45,32,000 67,74,23,250 20,20,78,800 60,96,80,925 18,18,70,920 4940533395
42 | P a g e
Detailed Project Report (sector 87 Mohali),2021
Compiled Installment
Application (5%) 4438412915
Installment-I (15%) 13929964950
Installment-II (20%) 17753651660
Before determining the selling price for SCOs, SCFs booths, the favored site criteria was
taken into account. The highest price will be paid for the corner plots on the ground floor.
The minimum and maximum rates were determined using two different criteria: reserve price
43 | P a g e
Detailed Project Report (sector 87 Mohali),2021
and market price. As a result, the project's total income, as computed, is just Rs. 8855.55
lakhs.
44 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
45 | P a g e
Detailed Project Report (sector 87 Mohali),2021
Months
15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th 28th
Expenditure (RS in crores) 18.16 10.50 7.65 9.60 7.29 6.54 0.00 0.00 0.00 0.00 1.47 1.47 6.70 0.30
Cumulative Expenditure (CE) 1282.47 1292.97 1300.62 1310.22 1317.51 1324.05 1324.05 1324.06 1324.06 1324.06 1325.53 1327.01 1333.70 1334.00
Income (RS in crores) 0.00 0.00 0.00 0.00 266.30 2396.74 0.00 0.00 0.00 0.00 0.00 2666.74 302.06 0.64
Cumulative Income (CI) (RS in
3219.05 3219.05 3219.05 3219.05 3485.36 5882.10 5882.10 5882.10 5882.10 5882.10 5882.10 8548.84 8850.91 8851.55
crores)
Balance (CI-CE) (RS in crores) 1936.58 1926.08 1918.43 1908.83 2167.84 4558.04 4558.04 4558.04 4558.04 4558.04 4556.57 7221.84 7517.20 7517.55
Source:- Computed Values
46 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar
Detailed Project Report (sector 87 Mohali),2021
4.15 Conclusion
The project's selling price and profits are discussed in this chapter. The selling prices were
determined by GMADA using the site's market value, which was derived via online tenders.
The income was then compared to the expenses to determine the net profit, which came to
485.77 percent. Hence it will be a profitable project. The relation between cumulative income
and expenditure is shown graphically via GANTT chart.
47 | P a g e
Detailed Project Report (sector 87 Mohali),2021
References
48 | P a g e
Guru Ramdas School of Planning, GNDU, Amritsar