Fantazja Essay

FINDINGS:

No of Hotels / Size per Region:

There exists an equitable distribution of hotels from among the three regions. Slovakia leads hotel count by mere 4 hotels.  Poland holds 37% of total small and medium-sized hotels, while Slovakia dominates the large hotel category with a 44% share. (See Appendix A)

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Distance:

Small-sized hotels are farthest to the rail link with a mean of 2.5 and Standard Deviation of .97 against the mean of medium and large hotels at 2.2 and 2.3 respectively. (See Appendix B)

Advertising:

Large Hotels spend the most in advertising at a mean of 1,482 pounds. (See Appendix B)

Workforce:

The 3 hotel categories present minimal differences in number of workforce:  A mean of 18 employees for small hotels, 19 for medium and 23 for the large hotels. (See Appendix B)

Accommodation Type “A” Income:

The 3 hotel categories present minimal differences as well in terms of income for this accommodation:  Large hotels have a mean income of 391K pounds while medium and small-sized hotels are not far behind at 389K and 386K pounds respectively. (See Appendix B)

Accommodation Type “B” Income:

For this type of accommodation, medium-sized hotels earned the most at P217K, followed by small and large hotels at 213K and 207K pounds respectively. (See Appendix B)

SUMMARY

Closest to Rail Link:  Large Hotels

Farthest to Rail Link:  Small Hotels

Most Number of Employees:  Large Hotels

Least Number of Employees: Small Hotels

Highest Advertising Spender: Large Hotels

Highest Income Earners:

            Accommodation A – Large Hotels

            Accommodation B –  Medium Hotels

CONCLUSION

Based on the above information, it appears that the three categories of hotels from various regions do not have much disparity in terms of mean income earned in both accommodation types.  While large hotels lead mean revenues for accommodation type A, the hotels from other categories earned revenues close to that of large hotels.  Large hotels also were also behind in terms of mean income from the other hotel categories for accommodation type B.

The above information should prompt Fantazia management to review the performance of its hotels per category.  To increase income, management could decide to increase advertising budget for small and medium-sized hotels while probably reassessing the location of its large hotels.

Word Count: 370

APPENDICES

Appendix B

Cross Tabulation

Tabulation A:

# of Hotels per Size / Region

Count of    Hotel
Size

Count of    Hotel
Size

Region
Small
Medium
Large
Grand Total

Region
Small
Medium
Large
Grand Total
Poland
13
13
9
35

Poland
38%
41%
26%
35%
Czech Republic
9
7
10
26

Czech Republic
26%
22%
29%
26%
Slovakia
12
12
15
39

Slovakia
35%
38%
44%
39%
Grand Total
34
32
34
100

Grand Total
100%
100%
100%
100%

Tabulation B:

Years Experience of Hotel Manager

Count of    Hotel
Year

Count of    Hotel
Year

Size
0 to 3
4 to 7
> 7
Grand Total

Size
0 to 3
4 to 7
> 7
Grand Total
Small
15
15
4
34

Small
33%
38%
29%
34%
Medium
17
12
3
32

Medium
37%
30%
21%
32%
Large
14
13
7
34

Large
30%
33%
50%
34%
Grand Total
46
40
14
100

Grand Total
100%
100%
100%
100%

APPENDIX B

Mean and Standard Deviation

Advertising Expenses:

# of Employees:

Type A

Type B

Small Hotel

Mean
1172.188485

18.03030303

386,984.85

213,003.03
Median
1310

16

350200

211200
Mode
1310

14

336000

226000
Standard Deviation
849.2798066

4.64680568

114,438.42

8914.716935
Sample Variance
721276.1899

21.59280303

13096151951

79472178.03
Count
33

33

33

33

APPENDIX B (Continued)

Mean and Standard Deviation

Medium Hotel

Mean
1313.741935

19.74193548

389,761.29

216,516.13
Median
1341

20

376000

217000
Mode
111

13

325000

226000
Standard Deviation
807.8694188

4.795607309

89,340.57

8005.751964
Sample Variance
652652.9978

22.99784946

7981737785

64092064.52
Count
31

31

31

31

Large Hotel

Mean
1482.121212

23.24242424

391,766.67

206,921.28
Median
1344

22

367000

214000
Mode
1131

22

353000

226000
Standard Deviation
808.8016891

6.388614399

90,649.53

41202.03424
Count
33

33

33

33

APPENDIX C

APPENDIX D

APPENDIX E:

APPENDIX F:

APPENDIX G:

Standard Deviation of Incomes

Type A Accomodation

Type B Accomodation

Mean
385319

Mean
211219.0225
Standard Deviation
99456.83973

Standard Deviation
26126.40667
Range
490500

Range
228497.75

APPENDIX H:

Correlation of Income to Hotel Distance from Rail link

Correlation: Distance to Income Type A

1.7
474000

1.7
1

474000
-0.5935634
1

Correlation: Distance to Income Type B

214000
1.7

214000
1

1.7
-0.1077135
1

Yes, there exists a significant correlation.  Based on the results, as the distance from the rail link increases, the income of the hotel would be considerably reduced as well.

BIBLIOGRAPHY

Black, Ken.  Business Statistics: Contemporary Decision Making.

2nd Ed. St Paul, MN: West Publishing Company, 1997.

Middleton, Michael R.  Data Analysis Using Microsoft Excel.

USA: Wadsworth Publishing Company, 1997

Walpole, Ronald E. Introduction to Statistics. 3rd Edition.

New York: Macmillan Publishing Co., Inc. 1982