Write a business report to Oscar Cunningham

Assignment Help Case Study
Reference no: EM132310047

Assignment -

Description: The aim of this assessment is to apply business analytics and decision modelling approaches to develop a business report (proposal) for a given business scenario using Excel and Solver as decision model implementation and solving tools.

Instructions - You are the Cunningham Holdings senior Business Analyst working with Oscar Cunningham the CEO of the CHL Hospitality subsidiary to submit a 1500 word business report (proposal) for a new golf course resort. The management's plan is to build the standard clubhouse golf course. However, shareholders' request that the management build the exclusive clubhouse golf course (the original exclusive clubhouse model).

During your modelling process, you confirmed that within the current constraints it is not viable to build the shareholders' demanded exclusive clubhouse golf course. You are required to propose three options for the exclusive clubhouse model. Analysis and discuss the four feasible models (the standard and the three options of the exclusive clubhouse). You then make a recommendation with justification to the management the proposed model.

Requirements -

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

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 minimised or maximised.

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

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

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.

Note: It is possible the standard clubhouse model be your recommended model although it does not meet shareholders requirement, but it may has the best international golfing requirement in terms of golfer enjoyment index, holes configuration and it is the cheapest to construct.

Attachment:- Case Study.rar

Verified Expert

The task is about the decision making of a Golf resort which has a number of alternatives to choose from. Each alternative has been evaluated with respect to the technical requirements, budget constant and profitability of the project to finally come to a conclusion which alternative the firm should choose to invest in. The alternatives were evaluated using Liner Programming Problem model. There is also some comparative static analysis as well.

Reference no: EM132310047

Questions Cloud

Fair assessment of their ethical standards : From Nike's standpoint, is this a fair assessment of their ethical standards? Explain the some of the ethical issues that Nike is facing in the case.
Should we inflict western values on this society : Should we inflict western values on this society? Bring in the concepts of social responsibility, integrity and other business ethics practices.
What were your results for each conflict style : Prepare a business brief that provides insights into your conflict management style. Begin by taking the personal conflict assessment provided.
Which is mandatory as an industry standard : Define the legislation " ISO 10002 Customer Satisfaction and Complaints Handling" Which is mandatory as an industry standard.
Write a business report to Oscar Cunningham : Write a 1500-word business report (proposal) to Oscar Cunningham, the CEO of CHL Hospitality outlining your analysis of your decision models and recommendations
Critically evaluate the proposed investment plan : BAO5534 - Business Finance - Victoria University - what financial goals dose Studebaker seem to be focusing? Is it the correct goal? Explain
Why is the competitor response profile created : Why is the competitor response profile created on a businesses most fierce competitor? Please explain in detail?
Framework for managing change in organizations : Lewin's Change Management Model is a relatively easy-to-understand framework for managing change in organizations.
How you perceive the process of self-reflecting : How you perceive the process of self-reflecting on teaching practices and education policy in order to utilize research, ethical practice, and other resources.

Reviews

len2310047

5/22/2019 3:03:57 AM

No Of Pages/Words – 2500. The description of assignment is provided in the two screenshots and case study is the pdf file. Please follow each and every instruction carefully as it is of heigh weightage. The action plan should be of 1500 words and communication report should be of 1500 words. Your first task is first to build a decision model that meet the management plan – The standard clubhouse golf course model. Oscar Cunningham, the CEO of CHL Hospitality wants to know whether the shareholders’ request can be fulfil. Hence, your second task is to build the exclusive clubhouse golf course model.

len2310047

5/22/2019 3:03:51 AM

Note: Construction costs are estimates only, as this development is rare in rural communities and reliable estimates are not available. Further work will be required if the board accepts the initial proposal. The case study is prepared based on the assumption that there is no solution for the original shareholders exclusive clubhouse golf course. When you make change to options 1, 2 and 3, the changes MUST be better than the standard clubhouse (management plan). For example, Option 1, when you reduce the size of the exclusive clubhouse, it should be between 2 and 4 hectares. Number of golfing holes MUST be INTEGER.

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd