Reference no: EM132299201

Case study - Cunningham Holdings Limited

Background

Cunningham Holdings Limited is a diversified family owned business. For more information about the company see the company profile (link to company profile). The Company has embarked on a radical re-think in relation to how they do business aligned with their new Corporate vision " Creating Sustainable Products and Services for Globally Connected Communities" The vision identifies key United Nations Sustainable Development goals into all planning activities for business innovation.

You are the senior Business Analyst in the CHL Hospitality and Mr Oscar assign you the task to analyse the pricing and competition situations of the four brands and report to him your findings.

Mr Oscar has requested you to analyse the data collected and present a report on summarising the findings of your analysis for the following five issues. The expansion of the ‘Feel Welcome' package to other states in Australia is very much depend on the outcome of your analyst and insights. The data are available in the CHL Accommodation Data.xlsx

Issue 1
Mr Oscar wants to have a clear idea about the current pricing among the accommodation brands, by state and by location.

Issue 2
Since the accommodations are allow to set their own rates and cater for different segment of market, Mr Oscar believes that is a price differentiation between the Resort, Cottage, and Classic brands (i.e., whether the price between the brands are different).

Issue 3
The accommodations surveyed are located in NSW, QLD, and VIC. Due to the size of market, weather preference, and types of attractions available among the states. Mr Oscar want to know whether there is a price difference across the three states among the accommodation brands (i.e., whether the state factor do influence the pricing of Resort, Cottage and Classic brand - Two factors State and Brand).

Issue 4
Similarly, the accommodations are located in various suburbs and locations among the states. Some at metropolitan cities and some at regional cities. Mr Oscar believes price difference exist at different locations among the accommodation brands (i.e., whether the location factor do influence the pricing of Resort, Cottage and Classic brand - Two factors Location and Brand).

Issue 5
Finally, Mr Oscar would like to know whether the introduction of the Comfort brand has increased internal competition among the accommodation brands (i.e., If competition exist, the pricing of a brand say Resort with a Comfort nearby is lower than a similar Resort with no Comfort nearby).

Requirement

Analyse the data collected and present an 800 word report summarising you're the findings of your analysis to Mr Oscar. In preparing the report, you need to perform the followings.

1. Action Plan
In the action plan you are required to describe the process how do you response to Mr Oscar's five issues one by one.

For Issue 2 to 5 you need to describe your process involving hypothesis-testing Procedure.
i. Identifying the population parameter of interest and formulating the hypothesis to test
ii. Select a level of significance (α), which defines the risk of drawing an incorrect conclusion when the assumed hypothesis is actually true
iii. Determine the decision rule on which to base a conclusion
iv. Collect data and calculate the test statistics. Here, you need to mention what type of test you are performing.
v. Apply the decision rule to the test statistics and drawing conclusion. You also need to make a statement whether you agree with the view of the Mr Oscar.

In conducting the test for issues 2 to 5, you need to explain whether you use One-Factor ANOVA (with Turkey Kramer) or Two-Factor ANOVA. For Question 5, you may need to perform more than one tests in order to conclude whether internal competition does exist among three brands (Resort, Cottage, and Classic) when Comfort were nearby. For example, if internal competition does exist, the average price of a brand (for example, Cottage), the average price of a Cottage will be lower where a Comfort was nearby as compare to a price of Cottage with NO Comfort nearby. Depends on how you structure your data and frame your hypothesis, state clearly whether you are conducting upper-tailed or lower-tailed test.

2. Spreadsheet Analysis

The spreadsheets must contain all the analytics and tests you have performed. Replicate the original data file given into five new spreadsheet files. Name the spreadsheets as Issues 1 to 5. Keep the original data file as backup. Perform you analysis for each issue using the replicate spreadsheet file. In preparing your analysis for each issue, you are required to demonstrate how you prepare and organise the data for your analysis (see Action Plan).

3. Communication

In this report, you must use your findings to address ALL the issues raised by Mr Oscar. The report length limit is 800 words.

Attachment:- Cunningham Holdings case study.docx