Analytical Case Study of Cunningham Holdings

Analytical case study of Cunningham
Holdings

Table of Contents
Issue 1 current average price of differentiation by brands, state and locations...........................2
Issue 2 Price differentiation exist between price and brands.......................................................3
Issue 3: Price differentiation exist between state and brands......................................................4
Issue 4 Price differentiation between location and accommodation brands................................4
Issue 5..........................................................................................................................................5
APPENDIX......................................................................................................................................6
Issue 2..........................................................................................................................................6
Issue 3..........................................................................................................................................7
Issue 4..........................................................................................................................................8
Issue 5........................................................................................................................................10

Overview
The current study is based upon the Cunninghm Holdings which is a diversified family
owned business and it also focus on the sustainable products and services which is underpinned
by the have a global business perspective and build leadership and management skills that helps
to meet the define aim. For that the study will analyse the 5 issues through which the company
determine the new price of its accommodation facilities. Therefore, current study will help to
determine the current average price of accommodation as per brands, states and locations.
Further, study will analyze price differentiation exist between the state, location and comfort
brand with accommodation brands.
Issue 1 current average price of differentiation by brands, state and locations
Particulars Average of Price
Resort 200.2704167
Cottage 202.65625
Classic 201.4627083
Grand Total 201.463125
Row Labels Average of Price
NSW 201.02375
QLD 202.196875
VIC 201.16875
Grand Total 201.463125
Row Labels Average of Price
Metropolitan Cities 201.5591667
Regional Cities 201.3670833
Grand Total 201.463125
Interpretation: From the above, it is analyzed that the average price of all the i.e. Brand,
comfort and location is $201.463 such that average price of the accommodation by brand, stated
and location is not varies. From the above table, it is interpreted that by using excel,
accommodation price of all the areas is similar and that is why, the price is nit varies as per the
availability and it is fixed i.e. 201. 46 in dollars.

Issue 2 Price differentiation exist between price and brands
Particulars Price of resort Price of Cottage Price of Classic
Price of resort 1 0.27 0.24
Price of Cottage 0.27 1 0.49
Price of Classic 0.24 0.49 1
Descriptive statistics
Particulars Resort Cottage Classic
Mean 200.2704 202.6563 201.4627
Standard Error 0.393541 0.445979 0.48986
Median 199.55 202.695 200.995
Mode 199.18 198.43 #N/A
Standard Deviation 2.72653 3.08983 3.393848
Sample Variance 7.433966 9.547049 11.5182
Kurtosis 0.860547 0.692926 -0.20077
Skewness 0.78074 0.76659 0.638174
Range 12.01 12.94 13.54
Minimum 195 197.63 196.11
Maximum 207.01 210.57 209.65
Sum 9612.98 9727.5 9670.21
Count 48 48 48
ANOVA
Source of
Variation SS df MS F P-value F crit
Rows 734.73 47 15.63263 2.877548 0.000212 1.623755
Columns 34.19 1 34.189 6.293278 0.015628 4.0471
Error 255.33 47 5.432622
Total 1024.256 95
Interpretation: As per the above, it is interpreted that the significant value is 0.0002 which is
below from 0.05 and as a result, there is a different between the factors. Such that customers