Spreadsheet Modeling and Business Report: Golf Course Case Study

This case study examines the development of an international standard golf course at the Cunningham Gudgal Golf Resort, focusing on spreadsheet modeling and a comprehensive business report. The assignment involves creating multiple models, including a management model with a standard clubhouse and several shareholder models with an exclusive clubhouse, each with varying constraints on acreage, cost, and budget. The core of the analysis utilizes integer programming within MS Excel to optimize the golf course layout, considering decision variables like different types of golf holes, an objective function to maximize the enjoyment index, and various technological and practical constraints. The report presents findings, analysis, and recommendations for each model, exploring the implications of different scenarios and providing insights into the optimal configuration of the golf course to maximize enjoyment and meet financial limitations. The models are compared, and recommendations are made based on the results, including an executive summary and introduction providing background and context to the project.