# Data Analysis Golf Course Design

Topics: Golf, Spreadsheet, Howard Staunton Pages: 6 (1481 words) Published: September 8, 2013
2013

Decision Modeling Assignment: Golf Course Design

CO 5124 Data Analysis & Decision Modeling Tutorial : B By Madhumita Srinivasan (12772343) Submitted to Dr.Eddie Chng

1 |CO5124 DATA ANALYSIS & DECISION MODELING

INTRODUCTION
Paradise Palm Golf Club, a well established golf club in Cairns, has planned to expand its operations by building a brand new golf course in Townsville. As the success of the golf course largely depends on the extent to which the users find it enjoyable, Future designers now face the challenge of designing an 18-hole Golf course that fits within 42 acres, that has a maximum enjoyability index. Based on the enjoyability index associated with each type of hole in the golf course, we should pick the number of holes in each category such that overall enjoyability level is at its highest. Also, Future designers have an additional option of having an extended club house, which is known to enhance user enjoyment. Two models are developed using Linear Optimization Model (LP) for each alternative, and we analyze and evaluate both the current scenarios and their impact on the overall enjoyability of the gold course’s users. Based on the findings, recommendations are provided to the management of Paradise Palm Golf Club.

2 |CO5124 DATA ANALYSIS & DECISION MODELING

STEP ONE: DECISION VARIABLES
The first step towards designing a golf course that commands a good enjoyability index is to identify the decision variables that have to be changed to in order to arrive at an optimum solution. As per the information provided, the following decision variables have been identified.      

No. of Units Straight par-5 holes No. of Units Dogleg par-5 holes No. of Units Straight par-4 holes No. of Units Dogleg par-4 holes No. of Units Long par-3 holes No. of Units Short par-3 holes

STEP TWO: OBJECTIVE FUNCTION
The objective function in designing the Golf Course is found to be the maximization of the Enjoyability Index which is based upon Player Enjoyment. This largely determines the success of the Golf Course in entertaining its users. The Enjoyability index associated with each type of hole is listed as follows: Kind of hole Enjoyability index

Straight par 5 2 Dogleg par 5 1.5

Straight par 4 1.5 Dogleg par 4 Long par 3 Short par 3 2 1.75 2.25

Type of Club House Additional Enjoyability index Standard Extended 0 4

3 |CO5124 DATA ANALYSIS & DECISION MODELING

This leaves us with two alternatives. We can either choose to build a golf course with a standard clubhouse, or build a golf course with extended golf course. The Objective Function for each case will be as follows: Standard Club House Enjoyability Index = (no. of units of Straight Par 5 x enjoyability index of Straight Par 5) + (no. of units of Dogleg Par 5 x enjoyability index of Dogleg Par 5) + (no. of units of Straight Par 4 x enjoyability index of Straight Par 4) + (no. of units of Dogleg Par 5 x enjoyability index of Degleg Par 5) + (no. of units of Long Par 3 x enjoyability index of Long Par 3) + (no. of units of Short Par 3 x enjoyability index of Short Par 3) Extended Club House Enjoyability Index = (no. of units of Straight Par 5 x enjoyability index of Straight Par 5) + (no. of units of Dogleg Par 5 x enjoyability index of Dogleg Par 5) + (no. of units of Straight Par 4 x enjoyability index of Straight Par 4) + (no. of units of Dogleg Par 5 x enjoyability index of Degleg Par 5) + (no. of units of Long Par 3 x enjoyability index of Long Par 3) + (no. of units of Short Par 3 x enjoyability index of Short Par 3) + 4 Objective Function Enjoyability Index = Maximum

4 |CO5124 DATA ANALYSIS & DECISION MODELING

STEP THREE: FORMULATION OF CONSTRAINTS
We apply the constraints pertaining to design of the golf Course and convert them into mathematical formulae as listed below         Clubhouse + Parking = 1 No. of Units Dogleg Par 5 >= 1 No. of Units Straight Par 4 >= 2 No. of Units Dogleg Par 4 >= 2 No. of...