A Case Study on Cunningham Gudgal Golf Resort 2022

International Standard Golf Course Modelling by Integer
Programming – A Case Study on Cunningham Gudgal Golf
Resort
1

Table of Contents
Part 1: Action Plan.....................................................................................................................2
Part 2: Spread Sheet Model Implementation.............................................................................3
Part 3: Business Report & Communication...............................................................................8
Executive Summary.................................................................................................................10
Overview of the Study.............................................................................................................11
Management Policy..............................................................................................................11
Mathematical Modelling......................................................................................................11
Analysis and Findings..............................................................................................................12
Model 1: Standard Clubhouse Model..................................................................................12
Model 2: Exclusive Clubhouse Model.................................................................................12
Model 3: Exclusive Clubhouse with Reduced Area............................................................13
Model 4: Exclusive Clubhouse with Reduced Cost.............................................................13
Model 5: Exclusive Clubhouse with Increased Overall Cost...............................................14
Discussion of Implications.......................................................................................................14
Recommendation......................................................................................................................15
References................................................................................................................................16
2

Part 1: Action Plan
1. There were six decision variables in the optimization problem. Number of golfing holes
to be built were the desion variables of the study. The list provided below with
abbreviation and algebric name for each variable.
Table 1: Decision Variables with abbreviation and algebraic form
Kind of golfing
hole
Abbreviation Algebric Expression
“Straight par 5” Sp5 X1
“Dogleg par 5” Dp5 X2
“Straight par 4” Sp4 X3
“Dogleg par 4” Dp4 X4
“long par 3” lp3 X5
“short par 3” sp3 X6
2. The objective was to maximize enjoyment index of golfers. Hence, the objective function
was the enjoyment index from golf course and clubhouse.
3. The constraints were practical, mangement oriented or technological in nature. – There
were limitations as well as requirement criterion with some restrictions.
Table 2: Constraints with limitations, requirement and restrictions
Contraint
Type
Constraint Requirement Restrictio
n
Limitation
Technical Sp5 ≥ 1
Dp5 ≥ 1
Sp4 ≥ 2
Dp4 ≥ 2
lp3 ≥ 1
sp3 ≥ 1
Sp5 & Dp5 ≤ 4
Sp4 & Dp4 ≤ 14
lp3 & sp3 ≤ 4
Total Par ≥ 70 ≤ 72
Total Golf -Holes = 18
Total acreage ≥ 36 ≤ 42
Management Standard Clubhouse Acreage = 2
Standard Clubhouse Cost = $ 3.5 Million
Overall Budget = 20 Million
Exclusive Clubhouse Acreage ≤ 4
Exclusive Clubhouse Cost ≤ $ 6 Million
3

Practical Sp5, Dp5, Sp4, Dp4, lp3, sp3 Integer
4. Mathematical modelling of the integer programming problem was stated as below.
Objective Function:
Max Z = 2X1 + 1.5 X2 + 1.5 X3 + 2X4 + 1.75 X5 + 2.25 X6 +X7
X7 = Enjoyment Index of Clubhouse (Standard = 0, Exclusive = 4)
Constraints:
Individual Pars => X1 ≥ 1, X2 ≥ 1, X3 ≥ 1, X4 ≥ 1, X5 ≥ 1, X6 ≥ 1
Sum of Pars => X1 + X2 ≥ 4, X3 + X4 ≥ 14, X5 + X6 ≥ 4
Total Par => 70 ≤ 5X1 + 5X2 + 4X3 + 4X4 + 3X5 + 3X6 ≤ 72
Total Holes => X1 + X2 + X3 + X4 + X5 + X6 = 18
Acreage: 36 ≤ 3X1 + 3.5X2 + 2X3 + 2.5 X4 + X5 + 0.75X6 + X8 ≤ 42
X8 : Clubhouse Areage (Standard = 2, Exclusive = 4)
Budget => 10,00,000 X1 + 15,00,000 X2 + 7,50,000 X3 + 9,00,000 X4 + 6,00,000 X5 +
6,50,000 X6 + X9 ≤ 2,00,00,000
X9 = Clubhouse Cost (Standard = $ 3.5 Million, Exclusive =$ 6 Million)
X1, X2, X3, X4, X5, X6 ≥ 0 (Integer), X7, X8, X9 ≥ 0 (Mason, 2012).
Part 2: Spread Sheet Model Implementation
Standard Clubhouse Model
4