Module 1 Peer Assessment (Base) (1) (1) (XLSX) - Fichier XLS

Fichier partagé

Module 1 Peer Assessment (Base) (1) (1) (XLSX)

Aperçu texte

 Base information Rate increase 10% OTA Bookings increase 10% Brand.com bookings increase 10%
Days 30 30 30 30
Daily rate 100 110 100 100
Number of rooms 200 200 200 200
Occupancy 65% 65% 65% 65%
    
Cost of Sales  12.00   12.00   12.00   12.00 
Labour cost " 80 000 " " 80 000 " " 80 000 " " 80 000 "
OTA Commission 20% 20% 20% 20%
Marketing Cost " 32 000 " " 32 000 " " 32 000 " " 32 000 "
Utilities " 50 000 " " 50 000 " " 50 000 " " 50 000 "
    
Distribution Channel Mix    
Direct 50% 50% 40% 40%
GDS 10% 10% 10% 10%
OTA 20% 10% 30% 20%
Brand.com 10% 20% 10% 20%
Other 10% 10% 10% 10%
    
Rooms sold through each channel    
Direct 1950 1950 1560 1560
GDS 390 390 390 390
OTA 780 390 858 780
Brand.com 390 780 390 429
Other 390 390 390 390
    
Number of empty rooms 2100 2100 2412 2451
Occupancy percentage 65% 65% 60% 59%
    
Hotel Financial Performance    
Sales 390000 429000 358800 354900
Cost of Sales " 46 800 " " 46 800 " " 43 056 " " 42 588 "
Gross Profit 343200 " 382 200 " " 315 744 " " 312 312 "
GP% 88.00% 89.09% 88.00% 88.00%
    
Labour cost " 80 000 " " 80 000 " " 80 000 " " 80 000 "
OTA cost " 15 600 " " 8 580 " " 17 160 " " 15 600 "
Marketing cost " 32 000 " " 32 000 " " 32 000 " " 32 000 "
Utilities " 50 000 " " 50 000 " " 50 000 " " 50 000 "
Total Costs " 177 600 " " 170 580 " " 179 160 " " 177 600 "
    
Operating Profit " 165 600 " " 211 620 " " 136 584 " " 134 712 "
    
Debt Interest 60000 60000 60000 
    
Net Profit " 105 600 " " 151 620 " " 76 584 " " 134 712 "
NP% 27% 35% 21% 38%
    
Increase in sales  39000.0000000001 -31200 -35099.9999999999
Percentage increase in sales  10% -8% -9%
    
Increase in profits  " 46 020 " "-29 016 " " 29 112 "
Percentage increase in profits  44% -27% 28%

Module 1 Peer Assessment (Base) (1) (1) (XLSX) - Fichier XLS

Module 1 Peer Assessment (Base) (1) (1) (XLSX)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent