Data Analysis and Decision Modelling Report: Golf Course Planning

This report presents a data analysis and decision modeling project for the Cunningham Gudgal Golf Resort, focusing on the development of an 18-hole international standard golf club. The project explores decision variables, objective functions, and constraints related to the construction of different golf course models, including standard and exclusive clubhouses with various options. The analysis employs techniques like spreadsheet simulation and Excel Solver to address linear and non-linear programming problems, offering insights into land size, construction costs, enjoyment indices, and budgetary constraints. The report includes a business report and communication section, evaluating the feasibility of different models and their potential impact on profitability and customer satisfaction. It also assesses how the proposed models align with shareholder requirements and overall business goals, providing a comprehensive overview of the project's findings and conclusions.

Data analysis and decision
modelling

Table of Contents
INTRODUCTION...........................................................................................................................4
PART 1............................................................................................................................................4
Action Plan.............................................................................................................................4
Part 2:...............................................................................................................................................6
PART 3............................................................................................................................................9
Business Report & Communication.......................................................................................9
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................12

INTRODUCTION
Data analysis is defined as the process of evaluating and assessing the collected or stored
data to determine the key variable and make proper decision within a particular time frame (Ho,
2013). There must be specific technical ability to analysis the large data which help to ascertain
the valuable outcome and ease the process of decision making. On the other side, data modelling
is related with managing of collected data in a desired manner according to the company IT
system. Data modelling needs a few spot of data analysis to make appropriate solution or
decision to the problems.
In this project, BDM for the 18-hole international standard Cunningham Gudgal Golf
Resort that include standard clubhouse, the exclusive clubhouse as well as three options
for the exclusive clubhouse.
PART 1
Action Plan
Decision variable
The answer's conclusions are expressed by symbols like X1, X2, X3, .... Xn. These
variables reflect uncertain quantities such as number of items to be produced, amount of money
to be invested, etc. For decision parameters, whether the model comprises of a continuous goal
value and linear restrictions, it is considered a linear programming method. A dynamical
programming design consisting of an intrinsic nonlinear equation and non-linear restrictions
(Demirkan and Delen, 2013). In the context of the above case study, it has been determined that
the main decision variable is making 18-hole international golf club comprising of 5 modes.
Such as:
Kind of golfing hole Par Size taken up by
hole
Enjoyment Index Building Cost
Straight par 5 5 3 hectares 2 $1,000,000
Dogleg par 5 5 3.5 hectares 1.5 $1,500,000
Straight par 4 4 2 hectares 1.5 $750,000
Dogleg par 4 4 2.5 hectares 2 $900,000
Long par 3 3 1 hectare 1.75 $600,000
Short par 3 3 0.75 hectare 2.25 $650,000

Objective function
The problem's intent is reflected in decision parameters as numerical representation. The
goal can be to optimize the benefit, reduce the expense, distance, time, etc. In the respect of
Cunningham Gudgal Golf Resort the requirement to build different sort of golf club which are
included within management plan are:
Clubhouse Cost Area Enjoyment index Estimated
Budgeted cost
Standard
clubhouse
$3,500,000. 2 hectare 2 $4,000,000.
Exclusive
clubhouse
$6,000,000 4 hectares 4 $7,500,000.
Exclusive
clubhouse
(Option 1)
$6,000,000 3 hectares 4 $7,500,000.
Exclusive
clubhouse
(Option 2)
$4,000,000 4 hectares 4 $7,500,000.
Exclusive
clubhouse
(Option 3)
$6,000,000 4 hectares 4 $5,500,000.
All appropriate constraints
The weaknesses or specifications of the issue are represented in decision parameters as
disparities or coefficients. There are number of problems while constructing the different sort of
golf ground such as the non-availability of proper equipment (Sagiroglu and Sinanc, 2013).
Condition and weather of the place, less gathering of audience as they consider golf to be a slow
game, improper etiquette and attitude of the staff managing the ground. The cost of membership
of golf is too high so that many commentators noted the expense of the tools, shoes and clothes
for golf clubs. Similar to the perspectives of golf courses, it is a tough area to fix for sports. Each
manufacturer of golf equipment now can enjoy the benefits of state of the art technologies,

engineering and creativity to improve and grow their goods, and with rising inflation (30 per cent
in the last ten years) such price increases can be supported relative to ten years ago.
Part 2:
In an online course on operations research individual demonstrate any use of spreadsheet
simulation and Excel Solver to address linear and nonlinear programming problems (Zsambok,
2014). This is particularly helpful for multidisciplinary workshops which involve issues with
automation.
Standard clubhouse model (management plan) – In accordance of given information in the
case study, this can be find out that Cunningham holding is making plan to build an international
standard golf course including a standard clubhouse. Herein, underneath some key requirements
of this club are mentioned in such manner:
Size of land (In terms of hectares) Cost of construction
2 hectares 3500000 dollar
This plan is an estimation which is made by management team of above company.
Though, there may be fluctuation in the cost due to variation in needed value of materials.
Straight
par (5)
Straight
par (5)
Straight
par (5)
Straight
par (4)
Straight
par (4)
Straight
par (4)
Total
par ECH SCH
Decision values 4 14 4 14 14 20 70 20 50
Objective
function 2 1.5 1.5 1.75 2.25 4 13 5 8
Constraints
Area of land 0.7 0.9 0.3 0.9 0.8 0.4 4 4 2
Budget
allocated 542500 542500 542500 542500 542500 542500 3E+06 2E+07
Additional constraints
Straight par (5) 1 1 1 1
Straight par (5) 1 0 1
Straight par (5) 1 0

Straight par (4) 1 1 1 1 0.5 0.3
Straight par (4) 1 1 1
Straight par (4) 1 1 1
1 1
Points per par 2 2 1 0 3 1 1 1
Exclusive clubhouse model (shareholders’ request)- Another model among five models is
of building exclusive clubhouse. Basically, company is going to construct this clubhouse on the
behalf of request of shareholders. In accordance of expectations level, company wants that
enjoyment index for this exclusive clubhouse will be of 4. Herein, underneath some main needs
of this club are demonstrated in such manner that is as follows:
Size of land (In terms of hectares) Cost of construction
4 hectares 6000000 dollar
In this four hectares of size of land, parking space is also included. Three option of
exclusive clubhouse model.
Option one-In accordance of given information in the case study, this is being allowed to
minimise size of exclusive clubhouse. The size of exclusive clubhouse is of 4 hectares which is
decided by management team of above company. Though they have option to minimise it as per
own need.
Management plan for exclusive club Modified area of land after option one
4 hectares (including land of parking) 3 hectares (including land of parking)
Option second- In accordance of given information in the case study, this is being
allowed to minimise cost of exclusive clubhouse under option second. The cost of exclusive
clubhouse is of $ 6000000 which is decided by management team of above company. Though
they have option to minimise it as per own need.
Management plan for exclusive club Modified amount of cost after option
one
6000000 dollar 4000000 dollar
Option third- In this option, management is allowed to volume of budget allocation in a
hypothetically manner. Herein, below pre estimated budget is mentioned that can be increased
under option three in such manner:
Particulars Standard Exclusive Total

clubhouse clubhouse
Grading and
mobilization 250000 10000 260000
Drainage 500000 200000 700000
Rough and finish
shaping 100000 500000 600000
Green construction 985000 15820000 16805000
Tee construction 900000 60000 960000
Bunker construction 10000 5000 15000
Car path construction 500000 100000 600000
Irrigation system 10000 90000 50000
Total 3255000 16785000 19990000
Increased budget after making some changes under option third:
Particulars
Standard
clubhouse
Exclusive
clubhouse Total
Grading and
mobilization 250000 10000 260000
Drainage 500000 200000 700000
Rough and finish
shaping 100000 500000 600000
Green construction 985000 15820000 16805000
Tee construction 900000 700000 1600000
Bunker construction 50000 60000 110000
Car path construction 500000 100000 600000
Irrigation system 10000 90000 50000
Total 3295000 17480000 20725000
PART 3
Business Report & Communication
In the above discussed case study the five golf club model in Cunningham Gudgal Golf
Resort are being created according to the international golf standard. The decision-making model

is a generic very useful method for making valuable and solving problems in five phases that will
directly increase the overall popularity of Cunningham Holdings. These model are mainly
implemented in the golf club as it will bring more and more profitability and make customer
demand fulfil those are interested in playing golf. The cost of making different model are
appropriate and will definitely help club to generate more amount of revenue in order to attain
the desired profit margin. Exclusive clubhouse will be beneficial as these are implemented to
fulfil the need and request of key stakeholder which are consider to be valuable part of
Cunningham Holdings.
From the five decision models, the most feasible models are shown in the tables. The
implication on four feasible models whether they meet shareholders ‘original exclusive
clubhouse requirement is depended upon various factors. These factors are on their hole’s
configuration, total enjoyment index, total land used and the total construction cost.
Clubhouse Cost Area Enjoyment index Estimated
Budget
Rate
(From
10)
Standard
clubhouse
$3,500,000. 2 hectare 2 $4,000,000. 6
Exclusive
clubhouse
$6,000,000 4 hectares 4 $7,500,000. 8
Exclusive
clubhouse (Option
1)
$6,000,000 3 hectares 4 $7,500,000. 5
Exclusive
clubhouse (Option
2)
$4,000,000 4 hectares 4 $7,500,000. 9

CONCLUSION
On the basis of above project report, this can be concluded that there are four models among
five models which are described. This evaluation is being done in accordance of different
types of models and techniques such as solver test and many more.

REFERENCES
Books and Journals:
Ho, R., 2013. Handbook of univariate and multivariate data analysis with IBM SPSS. Chapman
and Hall/CRC.
Demirkan, H. and Delen, D., 2013. Leveraging the capabilities of service-oriented decision
support systems: Putting analytics and big data in cloud. Decision Support Systems.
55(1). pp.412-421.
Sagiroglu, S. and Sinanc, D., 2013, May. Big data: A review. In 2013 international conference
on collaboration technologies and systems (CTS) (pp. 42-47). IEEE.
Zsambok, C. E., 2014. Naturalistic decision making: where are we now?. In Naturalistic decision
making (pp. 23-36). Psychology Press.