Data analysis

  1. Build decision models for the 18-hole international standard Cunningham Gudgal Golf Resort with a standard clubhouse, the original shareholders’ exclusive clubhouse, and the three options for the exclusive clubhouse (5 decision models).
  2. Write a 1500-word business report (proposal) to Oscar Cunningham, the CEO of CHL Hospitality outlining your analysis of your decision models and recommendations. Oscar Cunningham will then present your report in the upcoming Board meeting.

In helping you to prepare the business report, you MUST do the following to provide evidence to support your proposal:

Part 1: Action Plan (30%) In the action plan you have to describe the process you will undertake to transform the business problem into a set of mathematical equations using the four steps approach. 1. Identify the decision variables – the unknown values that the model seeks to determine. 2. Identify the objective function – the quantity to be minimized or maximized. 3. Identify all appropriate constraints – limitations, requirements, or other restrictions that are imposed on any solution, either from practical or technological considerations or by management policy. 4. Write the objective function and constraints as mathematical expressions.

Part 2: Spreadsheet Model Implementation (30%) Here, it includes the Excel and Solver implementation of your five (5) models. 1. Standard clubhouse model (management plan) 2. Exclusive clubhouse model (shareholder’s request) 3. Three (3) options of the exclusive clubhouse model. Clearly state what have changed in each of the option from the original exclusive clubhouse model.

Part 3: Business Report & Communication (40%) In the business report, first provide a description of the implementation of your five decision models (the management’s standard clubhouse, the original shareholders’ exclusive clubhouse and the three options for the exclusive clubhouse.
Provide an analysis of the four feasible models (the standard and the three options of the exclusive clubhouse) on their holes configuration, total enjoyment index, total land used and the total construction cost. Discuss the implication on four feasible models whether they meet shareholders’ original exclusive clubhouse requirement.

Make a recommendation to Oscar your proposal model. In doing so you can rank your four feasible models based on international golfing requirement and whether meeting shareholders’ requirement. Justify your recommendation.

Sample Solution