FAVZ - Pronostico al 15 Julio 2015 (2).xls

40
Razón Social: Hotel: FA / FI FAVZ C o n c e p t o Mes % Plan % Cuartos Ocupados 3,703 2,950 Cuartos Disponibles 7,223 7,223 % Ocupación 51.3% 40.8% Ocupación s/libros 0.0% Ocupación mes a la fecha 0.0% Tar. Prom. mes a la fecha 0 Tarifa Promedio 1,659 1,413 Tarifa Efectiva 850 577 No. de Comensales 10,954 10,313 Cheque Promedio Alim. 187 210 No. personas Beb. 10,954 10,313 Cheque Promedio Beb. 39 53 No. de huespedes 7,955 5,989 Cons. prom x huesped 1,058 1,106 INGRESOS Ing Habitaciones 6,142 73.0% 4,169 62.9% Ing Alimentos, Bebidas y Ot 2,088 24.8% 2,221 33.5% Ing Otros 183 2.2% 235 3.5% Total de Ingresos 8,413 100.0% 6,625 100.0% COSTOS Costos Alimentos 522 32.2% 486 30.0% Costos Bebidas 66 15.5% 110 20.1% Costos Otros 19 10.5% 16 6.7% Total de Costo 607 7.2% 611 9.2% NOMINA Nom Habitaciones 624 10.2% 704 16.9% Nom Alimentos y Bebidas 723 34.6% 711 32.0% Nom Otros 28 15.3% 36 15.4% Nomina y Relativos 1,375 16.3% 1,451 21.9% OTROS GASTOS Gtos Habitaciones 605 9.8% 520 12.5% Gtos Alimentos y Bebidas 182 8.7% 206 9.3% Gtos Otros 3 1.6% 5 2.3% Total Otros Gastos 790 9.4% 731 11.0% UTILIDAD DEPTAL Util Habitaciones 4,914 80.0% 2,945 70.6% Util Alimentos, Bebidas y O 595 28.5% 709 31.9%

Transcript of FAVZ - Pronostico al 15 Julio 2015 (2).xls

Page 1: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ ENEROC o n c e p t o Mes % Plan % $ Var.

Cuartos Ocupados 3,703 2,950 753 Cuartos Disponibles 7,223 7,223 0 % Ocupación 51.3% 40.8% 10.4%Ocupación s/libros 0.0%Ocupación mes a la fecha 0.0%Tar. Prom. mes a la fecha 0Tarifa Promedio 1,659 1,413 245 Tarifa Efectiva 850 577 273

No. de Comensales 10,954 10,313 641 Cheque Promedio Alim. 187 210 -23 No. personas Beb. 10,954 10,313 641 Cheque Promedio Beb. 39 53 -14 No. de huespedes 7,955 5,989 1,967 Cons. prom x huesped 1,058 1,106 -49

INGRESOSIng Habitaciones 6,142 73.0% 4,169 62.9% 1,973 Ing Alimentos, Bebidas y O 2,088 24.8% 2,221 33.5% -133 Ing Otros 183 2.2% 235 3.5% -52

Total de Ingresos 8,413 100.0% 6,625 100.0% 1,788

COSTOSCostos Alimentos 522 32.2% 486 30.0% -36 Costos Bebidas 66 15.5% 110 20.1% 44 Costos Otros 19 10.5% 16 6.7% -4

Total de Costo 607 7.2% 611 9.2% 4

NOMINANom Habitaciones 624 10.2% 704 16.9% 80 Nom Alimentos y Bebidas 723 34.6% 711 32.0% -11 Nom Otros 28 15.3% 36 15.4% 8

Nomina y Relativos 1,375 16.3% 1,451 21.9% 77

OTROS GASTOSGtos Habitaciones 605 9.8% 520 12.5% -85 Gtos Alimentos y Bebidas 182 8.7% 206 9.3% 23 Gtos Otros 3 1.6% 5 2.3% 2

Total Otros Gastos 790 9.4% 731 11.0% -59

UTILIDAD DEPTALUtil Habitaciones 4,914 80.0% 2,945 70.6% 1,968 Util Alimentos, Bebidas y O 595 28.5% 709 31.9% -113 Util Otros 133 72.5% 178 75.6% -45

Total Utilidad Deptal 5,642 67.1% 3,831 57.8% 1,810

Page 2: FAVZ - Pronostico al 15 Julio 2015 (2).xls

GASTOS INDIRECTOSGtos Admon. y Grales. 945 11.2% 854 12.9% -91 Entretenimiento AI 0 0.0% 0 0.0% 0 Gtos Ventas 873 10.4% 748 11.3% -125 Gtos Mantenimiento 633 7.5% 662 10.0% 29 Gtos Recursos humanos 156 1.9% 183 2.8% 27 Gtos Energéticos 657 7.8% 507 7.7% -149

Gastos Indirectos 3,264 38.8% 2,955 44.6% -309

G.O.P. 2,378 28.3% 876 13.2% 1,502 GOP X CTO MN 10,206 3,761 6,444 GOP X CTO DLS 695 285 410

Gastos de Inmobiliaria 0 0.0% 8 0.1% 8 Incentivos 166 2.0% 61 0.9% -105 Seguros contra daños 0 0.0% 0 0.0% 0 Impuesto predia 0 0.0% 0 0.0% 0 Zona Federal 0 0.0% 0 0.0% 0 Reserva Extraordinaria 0 0.0% 0 0.0% 0

Total Inmobiliara 166 2.0% 69 1.0% -98

EBITDA 2,211 26.3% 807 12.2% 1,404

NOMINA TOTALNom Deptales. 1,375 16.3% 1,451 21.9% 77 Nom Admon. y Grales. 446 5.3% 439 6.6% -7 Nom Entretenimiento AI 0 0.0% 0 0.0% 0 Nom Ventas 246 2.9% 279 4.2% 34 Nom Mantenimiento 259 3.1% 291 4.4% 32 Nom Recursos Humanos 87 1.0% 115 1.7% 28 Nom Lavanderia 0 0.0% 0 0.0% 0

0 0.0% 0 0.0% 0

Nomina Total 2,413 28.7% 2,576 38.9% 163

Ing Alimentos 1,624 1,620 Ing Bebidas 424 545 Ing Otros A&B 40 57 Total AyB 2,088 2,221

x

Page 3: FAVZ - Pronostico al 15 Julio 2015 (2).xls

ENERO% de Var Año Ant. % $ Var. % Var A/A

25.5% 3,648 55 1.5%0.0% 7,223 0 0.0%

25.5% 50.5% 0.8% 1.5%

17.4% 1,469 190 12.9%47.3% 742 108 14.6%

6.2% 11,152 -198 (1.8%)(10.9%) 202 -15 (7.6%)

6.2% 11,152 -198 (1.8%)(26.7%) 47 -8 (17.4%)

32.8% 7,569 386 5.1%(4.4%) 1,056 2 0.2%

47.3% 5,359 67.1% 783 14.6%(6.0%) 2,317 29.0% -229 (9.9%)

(22.0%) 314 3.9% -131 (41.7%)

27.0% 7,989 100.0% 424 5.3%

(7.5%) 497 28.6% -25 (5.1%)40.1% 109 20.9% 44 39.9%

(22.2%) 26 8.4% 7 26.5%

0.7% 632 7.9% 25 4.0%

11.4% 691 12.9% 68 9.8%(1.6%) 688 29.7% -35 (5.1%)22.2% 41 13.1% 13 31.7%

5.3% 1,420 17.8% 45 3.2%

(16.3%) 661 12.3% 56 8.5%11.4% 202 8.7% 20 9.8%45.8% 3 0.9% -0 (9.1%)

(8.0%) 866 10.8% 76 8.8%

66.8% 4,007 74.8% 907 22.6%(16.0%) 821 35.4% -226 (27.5%)(25.2%) 244 77.7% -111 (45.6%)

47.2% 5,072 63.5% 570 11.2%

Page 4: FAVZ - Pronostico al 15 Julio 2015 (2).xls

(10.7%) 904 11.3% -41 (4.6%)0.0% 0 0.0% 0 0.0%

(16.6%) 923 11.6% 50 5.4%4.4% 598 7.5% -35 (5.8%)

15.0% 166 2.1% 10 6.2%(29.4%) 635 7.9% -22 (3.4%)

(10.4%) 3,226 40.4% -38 (1.2%)

171.3% 1,846 23.1% 532 28.8%171.3% 7,921 2,284 28.8%143.6% 593 102 17.3%

100.0% 8 0.1% 8 100.0%(171.3%) 129 1.6% -37 (28.8%)

0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(141.4%) 137 1.7% -30 (21.7%)

1.7388566 1,709 21.4% 503 29.4%

5.3% 1,420 17.8% 45 3.2%(1.5%) 404 5.1% -42 (10.4%)

0.0% 0 0.0% 0 0.0%12.1% 306 3.8% 60 19.7%10.9% 272 3.4% 12 4.5%24.2% 104 1.3% 17 16.1%

0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

6.3% 2,505 31.4% 93 3.7%

1,734 523

60 2,317

x

Page 5: FAVZ - Pronostico al 15 Julio 2015 (2).xls

x

Page 6: FAVZ - Pronostico al 15 Julio 2015 (2).xls

x

Page 7: FAVZ - Pronostico al 15 Julio 2015 (2).xls

x

Page 8: FAVZ - Pronostico al 15 Julio 2015 (2).xls

x

Page 9: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ FEBREROC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 3,728 3,257 471 14.5% 3,807 -79 (2.1%)Cuartos Disponibles 6,524 6,524 0 0.0% 6,524 0 0.0%% Ocupación 57.1% 49.9% 7.2% 14.5% 58.4% (1.2%) (2.1%)Ocupación s/libros 0.0%Ocupación mes a la fecha 0.0%Tar. Prom. mes a la fecha 0Tarifa Promedio 1,552 1,363 189 13.9% 1,469 83 5.6%Tarifa Efectiva 887 680 207 30.3% 857 30 3.4%

No. de Comensales 13,298 11,036 2,262 20.5% 13,730 -432 (3.1%)Cheque Promedio Alim. 243 210 34 16.0% 195 49 25.1%No. personas Beb. 13,298 11,036 2,262 20.5% 13,730 -432 (3.1%)Cheque Promedio Beb. 76 53 23 43.9% 42 34 80.4%No. de huespedes 7,522 6,612 910 13.8% 7,539 -17 (0.2%)Cons. prom x huesped 1,241 1,067 174 16.3% 1,138 103 9.1%

INGRESOSIng Habitaciones 5,787 62.0% 4,439 62.9% 1,347 30.3% 5,594 65.2% 193 3.4%Ing Alimentos, Bebidas y O 3,316 35.5% 2,377 33.7% 939 39.5% 2,741 32.0% 575 21.0%Ing Otros 233 2.5% 240 3.4% -7 (2.9%) 244 2.8% -10 (4.2%)

Total de Ingresos 9,336 100.0% 7,057 100.0% 2,280 32.3% 8,579 100.0% 757 8.8%

COSTOSCostos Alimentos 645 29.0% 520 30.0% -125 (24.1%) 643 30.7% -2 (0.4%)Costos Bebidas 156 15.5% 117 20.1% -39 (33.4%) 142 24.6% -14 (9.9%)Costos Otros 9 3.9% 17 7.0% 8 45.9% 22 9.1% 13 58.7%

Total de Costo 811 8.7% 654 9.3% -157 (24.0%) 807 9.4% -4 (0.4%)

NOMINANom Habitaciones 602 10.4% 660 14.9% 58 8.8% 674 12.1% 72 10.7%Nom Alimentos y Bebidas 700 21.1% 688 28.9% -12 (1.8%) 662 24.2% -38 (5.7%)Nom Otros 27 11.7% 34 14.1% 7 19.3% 35 14.5% 8 22.3%

Nomina y Relativos 1,330 14.2% 1,382 19.6% 52 3.8% 1,372 16.0% 42 3.1%

OTROS GASTOSGtos Habitaciones 780 13.5% 544 12.3% -235 (43.2%) 597 10.7% -182 (30.5%)Gtos Alimentos y Bebidas 481 14.5% 218 9.2% -263 (120.7%) 262 9.6% -219 (83.5%)Gtos Otros 5 2.0% 5 2.3% 1 15.1% 7 2.9% 2 33.3%

Total Otros Gastos 1,265 13.6% 768 10.9% -497 (64.8%) 867 10.1% -399 (46.0%)

UTILIDAD DEPTALUtil Habitaciones 4,405 76.1% 3,235 72.9% 1,170 36.2% 4,322 77.3% 83 1.9%Util Alimentos, Bebidas y O 1,333 40.2% 834 35.1% 499 59.9% 1,032 37.6% 302 29.2%Util Otros 192 82.4% 184 76.6% 8 4.5% 179 73.6% 13 7.2%

Total Utilidad Deptal 5,930 63.5% 4,253 60.3% 1,678 39.4% 5,533 64.5% 397 7.2%

GASTOS INDIRECTOSGtos Admon. y Grales. 947 10.1% 872 12.4% -75 (8.6%) 950 11.1% 2 0.2%Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 891 9.5% 741 10.5% -150 (20.3%) 781 9.1% -110 (14.1%)Gtos Mantenimiento 724 7.8% 659 9.3% -65 (9.9%) 732 8.5% 8 1.1%Gtos Recursos humanos 141 1.5% 179 2.5% 38 21.3% 166 1.9% 25 15.0%Gtos Energéticos 622 6.7% 565 8.0% -57 (10.1%) 625 7.3% 3 0.4%

Gastos Indirectos 3,325 35.6% 3,016 42.7% -309 (10.2%) 3,253 37.9% -72 (2.2%)

G.O.P. 2,605 27.9% 1,236 17.5% 1,369 110.7% 2,280 26.6% 325 14.3%GOP X CTO MN #VALUE! 5,307 #VALUE! #VALUE! 9,785 #VALUE! #VALUE!GOP X CTO DLS #VALUE! 402 #VALUE! #VALUE! 740 #VALUE! #VALUE!

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 182 2.0% 87 1.2% -96 (110.7%) 160 1.9% -23 (14.3%)Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 182 2.0% 87 1.2% -96 (110.7%) 160 1.9% -23 (14.3%)

EBITDA 2,423 25.9% 1,150 16.3% 1,273 1.106872 2,120 24.7% 302 14.3%

NOMINA TOTALNom Deptales. 1,330 14.2% 1,382 19.6% 52 3.8% 1,372 16.0% 42 3.1%Nom Admon. y Grales. 417 4.5% 439 6.2% 22 5.0% 401 4.7% -16 (3.9%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 266 2.8% 249 3.5% -16 (6.5%) 175 2.0% -91 (52.2%)Nom Mantenimiento 249 2.7% 276 3.9% 27 9.9% 266 3.1% 16 6.2%Nom Recursos Humanos 78 0.8% 115 1.6% 37 32.2% 108 1.3% 30 27.7%Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,339 25.1% 2,461 34.9% 122 5.0% 2,321 27.1% -18 (0.8%)

Ing Alimentos 2,226 1,733 2,092 Ing Bebidas 1,011 583 578 Ing Otros A&B 79 61 71 Total AyB 3,316 2,377 2,741

Page 10: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ MARZOC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 3,747 3,783 -36 (1.0%) 4,693 -946 (20.2%)Cuartos Disponibles 7,223 7,223 0 0.0% 7,223 0 0.0%% Ocupación 51.9% 52.4% (0.5%) (1.0%) 65.0% (13.1%) (20.2%)Ocupación s/libros 51.9%Ocupación mes a la fecha 51.9%Tar. Prom. mes a la fecha 1752.47Tarifa Promedio 1,752 1,354 398 29.4% 1,611 142 8.8%Tarifa Efectiva 909 709 200 28.2% 1,047 -137 (13.1%)

No. de Comensales 12,334 12,876 -542 (4.2%) 14,108 -1,774 (12.6%)Cheque Promedio Alim. 195 210 -15 (7.1%) 187 8 4.3%No. personas Beb. 12,334 12,876 -542 (4.2%) 14,108 -1,774 (12.6%)Cheque Promedio Beb. 43 53 -10 (19.4%) 45 -3 (6.2%)No. de huespedes 8,039 7,679 360 4.7% 9,873 -1,834 (18.6%)Cons. prom x huesped 1,154 1,061 93 8.8% 1,067 87 8.2%

INGRESOSIng Habitaciones 6,567 70.8% 5,122 62.9% 1,444 28.2% 7,560 71.8% -993 (13.1%)Ing Alimentos, Bebidas y O 2,447 26.4% 2,773 34.0% -327 (11.8%) 2,701 25.6% -254 (9.4%)Ing Otros 266 2.9% 254 3.1% 12 4.6% 273 2.6% -8 (2.8%)

Total de Ingresos 9,279 100.0% 8,149 100.0% 1,129 13.9% 10,534 100.0% -1,255 (11.9%)

COSTOSCostos Alimentos 623 33.1% 607 30.0% -16 (2.6%) 681 34.1% 58 8.6%Costos Bebidas 94 17.9% 137 20.1% 43 31.3% 168 26.3% 74 44.2%Costos Otros 20 7.5% 20 7.8% -0 (0.7%) 28 10.3% 8 29.7%

Total de Costo 736 7.9% 763 9.4% 27 3.5% 877 8.3% 141 16.1%

NOMINANom Habitaciones 627 9.5% 687 13.4% 60 8.7% 715 9.5% 88 12.4%Nom Alimentos y Bebidas 721 29.5% 734 26.5% 13 1.7% 702 26.0% -19 (2.8%)Nom Otros 28 10.4% 40 15.6% 12 30.1% 42 15.5% 15 34.4%

Nomina y Relativos 1,376 14.8% 1,460 17.9% 85 5.8% 1,459 13.9% 84 5.7%

OTROS GASTOSGtos Habitaciones 712 10.8% 607 11.9% -104 (17.2%) 784 10.4% 72 9.2%Gtos Alimentos y Bebidas 268 11.0% 248 8.9% -21 (8.3%) 244 9.0% -24 (9.8%)Gtos Otros 2 0.8% 6 2.2% 4 63.6% 3 1.0% 1 28.7%

Total Otros Gastos 982 10.6% 861 10.6% -121 (14.1%) 1,031 9.8% 49 4.8%

UTILIDAD DEPTALUtil Habitaciones 5,228 79.6% 3,828 74.7% 1,400 36.6% 6,060 80.2% -833 (13.7%)Util Alimentos, Bebidas y O 741 30.3% 1,048 37.8% -308 (29.3%) 906 33.5% -165 (18.2%)Util Otros 216 81.3% 189 74.4% 27 14.3% 200 73.1% 16 8.1%

Total Utilidad Deptal 6,185 66.7% 5,065 62.2% 1,119 22.1% 7,166 68.0% -981 (13.7%)

GASTOS INDIRECTOSGtos Admon. y Grales. 947 10.2% 922 11.3% -25 (2.7%) 978 9.3% 31 3.2%Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 936 10.1% 819 10.0% -117 (14.3%) 962 9.1% 26 2.7%Gtos Mantenimiento 779 8.4% 713 8.7% -66 (9.3%) 807 7.7% 28 3.4%Gtos Recursos humanos 185 2.0% 183 2.3% -2 (0.9%) 179 1.7% -6 (3.2%)Gtos Energéticos 567 6.1% 622 7.6% 55 8.8% 765 7.3% 198 25.9%

Gastos Indirectos 3,414 36.8% 3,259 40.0% -155 (4.8%) 3,691 35.0% 277 7.5%

G.O.P. 2,771 29.9% 1,807 22.2% 964 53.4% 3,475 33.0% -704 (20.3%)GOP X CTO MN #VALUE! 7,754 #VALUE! #VALUE! 14,914 #VALUE! #VALUE!GOP X CTO DLS #VALUE! 588 #VALUE! #VALUE! 1,142 #VALUE! #VALUE!

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 194 2.1% 126 1.6% -68 (53.4%) 313 3.0% 119 38.0%Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 194 2.1% 126 1.6% -68 (53.4%) 313 3.0% 119 38.0%

EBITDA 2,577 27.8% 1,680 20.6% 897 0.533858 3,162 30.0% -585 (18.5%)

NOMINA TOTALNom Deptales. 1,376 14.8% 1,460 17.9% 85 5.8% 1,459 13.9% 84 5.7%Nom Admon. y Grales. 450 4.9% 439 5.4% -11 (2.5%) 409 3.9% -41 (10.1%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 278 3.0% 260 3.2% -18 (7.0%) 220 2.1% -58 (26.3%)Nom Mantenimiento 263 2.8% 291 3.6% 28 9.6% 269 2.6% 6 2.2%Nom Recursos Humanos 91 1.0% 115 1.4% 24 21.1% 117 1.1% 26 22.3%Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,458 26.5% 2,565 31.5% 108 4.2% 2,474 23.5% 16 0.7%

Ing Alimentos 1,879 2,022 1,996 Ing Bebidas 525 680 640 Ing Otros A&B 43 71 65 Total AyB 2,447 2,773 2,701

85.39%

Page 11: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ ABRILC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 5,143 4,763 380 8.0% 5,600 -457 (8.2%)Cuartos Disponibles 6,990 6,990 0 0.0% 6,990 0 0.0%% Ocupación 73.6% 68.1% 5.4% 8.0% 80.1% (6.5%) (8.2%)Ocupación s/libros 73.6%Ocupación mes a la fecha 73.6%Tar. Prom. mes a la fecha 1936.03Tarifa Promedio 1,936 1,633 303 18.6% 1,929 7 0.3%Tarifa Efectiva 1,424 1,113 312 28.0% 1,546 -121 (7.8%)

No. de Comensales 19,068 16,976 2,092 12.3% 19,925 -857 (4.3%)Cheque Promedio Alim. 207 207 1 0.3% 190 17 9.2%No. personas Beb. 19,068 16,976 2,092 12.3% 19,925 -857 (4.3%)Cheque Promedio Beb. 55 51 3 6.5% 47 8 17.1%No. de huespedes 10,649 9,812 837 8.5% 12,579 -1,930 (15.3%)Cons. prom x huesped 1,334 1,188 146 12.3% 1,189 145 12.2%

INGRESOSIng Habitaciones 9,957 70.1% 7,778 66.7% 2,179 28.0% 10,804 72.2% -847 (7.8%)Ing Alimentos, Bebidas y O 4,009 28.2% 3,599 30.9% 410 11.4% 3,890 26.0% 118 3.0%Ing Otros 242 1.7% 281 2.4% -39 (13.8%) 267 1.8% -26 (9.5%)

Total de Ingresos 14,208 100.0% 11,657 100.0% 2,550 21.9% 14,962 100.0% -755 (5.0%)

COSTOSCostos Alimentos 900 30.9% 792 30.0% -108 (13.7%) 885 31.0% -15 (1.7%)Costos Bebidas 196 18.9% 175 20.1% -21 (12.2%) 187 20.1% -9 (5.0%)Costos Otros 24 10.0% 25 9.0% 1 4.4% 22 8.2% -2 (10.4%)

Total de Costo 1,121 7.9% 992 8.5% -129 (13.0%) 1,094 7.3% -27 (2.5%)

NOMINANom Habitaciones 633 6.4% 701 9.0% 68 9.7% 729 6.7% 97 13.2%Nom Alimentos y Bebidas 715 17.8% 735 20.4% 20 2.7% 775 19.9% 60 7.8%Nom Otros 28 11.5% 37 13.0% 9 24.1% 34 12.9% 7 19.5%

Nomina y Relativos 1,375 9.7% 1,472 12.6% 97 6.6% 1,539 10.3% 163 10.6%

OTROS GASTOSGtos Habitaciones 1,138 11.4% 798 10.3% -339 (42.5%) 936 8.7% -202 (21.5%)Gtos Alimentos y Bebidas 444 11.1% 301 8.4% -144 (47.7%) 301 7.7% -144 (47.9%)Gtos Otros 3 1.4% 6 2.0% 2 41.3% 3 1.0% -1 (26.9%)

Total Otros Gastos 1,585 11.2% 1,105 9.5% -481 (43.5%) 1,239 8.3% -346 (27.9%)

UTILIDAD DEPTALUtil Habitaciones 8,186 82.2% 6,278 80.7% 1,908 30.4% 9,139 84.6% -952 (10.4%)Util Alimentos, Bebidas y O 1,753 43.7% 1,596 44.4% 156 9.8% 1,743 44.8% 10 0.6%Util Otros 187 77.2% 213 76.0% -27 (12.4%) 209 78.0% -22 (10.4%)

Total Utilidad Deptal 10,126 71.3% 8,088 69.4% 2,038 25.2% 11,090 74.1% -965 (8.7%)

GASTOS INDIRECTOSGtos Admon. y Grales. 1,165 8.2% 1,076 9.2% -90 (8.3%) 1,135 7.6% -30 (2.7%)Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 1,172 8.3% 1,082 9.3% -90 (8.4%) 1,312 8.8% 140 10.7%Gtos Mantenimiento 840 5.9% 776 6.7% -64 (8.2%) 919 6.1% 79 8.6%Gtos Recursos humanos 175 1.2% 200 1.7% 25 12.6% 199 1.3% 24 12.0%Gtos Energéticos 659 4.6% 752 6.5% 94 12.4% 720 4.8% 62 8.6%

Gastos Indirectos 4,010 28.2% 3,885 33.3% -125 (3.2%) 4,285 28.6% 275 6.4%

G.O.P. 6,116 43.0% 4,203 36.1% 1,913 45.5% 6,805 45.5% -690 (10.1%)GOP X CTO MN #VALUE! 18,038 #VALUE! #VALUE! 29,208 #VALUE! #VALUE!GOP X CTO DLS #VALUE! 1,372 #VALUE! #VALUE! 2,231 #VALUE! #VALUE!

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 612 4.3% 420 3.6% -191 (45.5%) 681 4.5% 69 10.1%Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 612 4.3% 420 3.6% -191 (45.5%) 681 4.5% 69 10.1%

EBITDA 5,504 38.7% 3,783 32.4% 1,721 0.455109 6,125 40.9% -621 (10.1%)

NOMINA TOTALNom Deptales. 1,375 9.7% 1,472 12.6% 97 6.6% 1,539 10.3% 163 10.6%Nom Admon. y Grales. 444 3.1% 461 4.0% 17 3.7% 406 2.7% -38 (9.3%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 272 1.9% 273 2.3% 1 0.2% 253 1.7% -19 (7.6%)Nom Mantenimiento 272 1.9% 294 2.5% 23 7.7% 264 1.8% -7 (2.7%)Nom Recursos Humanos 97 0.7% 120 1.0% 23 19.1% 116 0.8% 20 16.8%Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,460 17.3% 2,620 22.5% 160 6.1% 2,578 17.2% 119 4.6%

Ing Alimentos 2,909 2,637 2,852 Ing Bebidas 1,041 870 929 Ing Otros A&B 58 91 110 Total AyB 4,009 3,599 3,890

75.00%

Page 12: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ MAYOC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 5,141 4,650 491 10.6% 5,471 -330 (6.0%)Cuartos Disponibles 7,223 7,223 0 0.0% 7,223 0 0.0%% Ocupación 71.2% 64.4% 6.8% 10.6% 75.7% (4.6%) (6.0%)Ocupación s/libros 71.2%Ocupación mes a la fecha 71.2%Tar. Prom. mes a la fecha 1673.89Tarifa Promedio 1,674 1,535 139 9.0% 1,598 76 4.7%Tarifa Efectiva 1,191 988 203 20.6% 1,211 -19 (1.6%)

No. de Comensales 18,552 15,906 2,646 16.6% 15,813 2,739 17.3%Cheque Promedio Alim. 212 210 2 1.1% 196 16 8.1%No. personas Beb. 18,552 15,906 2,646 16.6% 15,813 2,739 17.3%Cheque Promedio Beb. 59 53 6 11.4% 54 5 9.8%No. de huespedes 10,371 9,440 932 9.9% 10,555 -184 (1.7%)Cons. prom x huesped 1,243 1,148 95 8.3% 1,151 92 8.0%

INGRESOSIng Habitaciones 8,605 66.7% 7,138 65.8% 1,468 20.6% 8,743 72.0% -138 (1.6%)Ing Alimentos, Bebidas y O 4,024 31.2% 3,426 31.6% 598 17.5% 3,220 26.5% 804 25.0%Ing Otros 265 2.1% 276 2.6% -11 (4.0%) 188 1.5% 78 41.3%

Total de Ingresos 12,895 100.0% 10,840 100.0% 2,055 19.0% 12,151 100.0% 744 6.1%

COSTOSCostos Alimentos 860 30.2% 749 30.0% -110 (14.7%) 716 31.7% -144 (20.1%)Costos Bebidas 199 18.2% 169 20.1% -30 (17.8%) 197 23.3% -2 (1.0%)Costos Otros 24 9.1% 24 8.8% 0 1.3% 22 11.6% -2 (10.7%)

Total de Costo 1,083 8.4% 943 8.7% -140 (14.9%) 935 7.7% -148 (15.8%)

NOMINANom Habitaciones 657 7.6% 718 10.1% 61 8.4% 742 8.5% 85 11.5%Nom Alimentos y Bebidas 738 18.3% 747 21.8% 9 1.2% 709 22.0% -29 (4.1%)Nom Otros 28 10.7% 40 14.6% 12 29.5% 44 23.5% 16 35.3%

Nomina y Relativos 1,424 11.0% 1,505 13.9% 82 5.4% 1,495 12.3% 72 4.8%

OTROS GASTOSGtos Habitaciones 1,064 12.4% 775 10.9% -289 (37.3%) 1,027 11.7% -37 (3.6%)Gtos Alimentos y Bebidas 399 9.9% 287 8.4% -112 (39.0%) 272 8.5% -126 (46.4%)Gtos Otros 2 0.9% 6 2.0% 3 57.3% 7 3.9% 5 67.8%

Total Otros Gastos 1,465 11.4% 1,067 9.8% -398 (37.3%) 1,307 10.8% -158 (12.1%)

UTILIDAD DEPTALUtil Habitaciones 6,885 80.0% 5,646 79.1% 1,239 22.0% 6,975 79.8% -90 (1.3%)Util Alimentos, Bebidas y O 1,828 45.4% 1,473 43.0% 355 24.1% 1,325 41.1% 503 38.0%Util Otros 211 79.3% 206 74.6% 4 2.2% 115 61.1% 96 83.6%

Total Utilidad Deptal 8,923 69.2% 7,325 67.6% 1,599 21.8% 8,414 69.2% 510 6.1%

GASTOS INDIRECTOSGtos Admon. y Grales. 1,087 8.4% 1,046 9.6% -41 (4.0%) 1,040 8.6% -47 (4.5%)Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 1,064 8.3% 1,034 9.5% -31 (3.0%) 1,071 8.8% 7 0.7%Gtos Mantenimiento 827 6.4% 748 6.9% -79 (10.5%) 928 7.6% 100 10.8%Gtos Recursos humanos 208 1.6% 197 1.8% -11 (5.3%) 214 1.8% 6 2.7%Gtos Energéticos 666 5.2% 728 6.7% 62 8.5% 758 6.2% 92 12.2%

Gastos Indirectos 3,853 29.9% 3,753 34.6% -100 (2.7%) 4,011 33.0% 158 3.9%

G.O.P. 5,071 39.3% 3,572 32.9% 1,499 42.0% 4,403 36.2% 668 15.2%GOP X CTO MN 21,763 15,329 6,434 42.0% 18,896 2,866 15.2%GOP X CTO DLS 1,655 1,166 489 42.0% 1,469 186 12.7%

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 507 3.9% 321 3.0% -186 (57.7%) 440 3.6% -67 (15.2%)Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 507 3.9% 321 3.0% -186 (57.7%) 440 3.6% -67 (15.2%)

EBITDA 4,564 35.4% 3,250 30.0% 1,314 0.40414 3,963 32.6% 601 15.2%

NOMINA TOTALNom Deptales. 1,424 11.0% 1,505 13.9% 82 5.4% 1,495 12.3% 72 4.8%Nom Admon. y Grales. 463 3.6% 461 4.3% -2 (0.5%) 447 3.7% -17 (3.8%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 257 2.0% 286 2.6% 29 10.1% 281 2.3% 24 8.6%Nom Mantenimiento 286 2.2% 303 2.8% 16 5.4% 292 2.4% 6 2.0%Nom Recursos Humanos 125 1.0% 120 1.1% -6 (4.9%) 126 1.0% 1 0.7%Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,555 19.8% 2,674 24.7% 119 4.4% 2,641 21.7% 86 3.2%

Ing Alimentos 2,846 2,498 2,258 Ing Bebidas 1,091 840 847 Ing Otros A&B 86 88 115 Total AyB 4,024 3,426 3,220

72.96%

Page 13: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ JUNIOC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 3,916 4,285 -369 (8.6%) 4,606 -690 (15.0%)Cuartos Disponibles 6,990 6,990 0 0.0% 6,990 0 0.0%% Ocupación 56.0% 61.3% (5.3%) (8.6%) 65.9% (9.9%) (15.0%)Ocupación s/libros 56.0%Ocupación mes a la fecha 56.0%Tar. Prom. mes a la fecha 1592.21Tarifa Promedio 1,592 1,478 115 7.7% 1,504 88 5.8%Tarifa Efectiva 892 906 -14 (1.5%) 991 -99 (10.0%)

No. de Comensales 14,933 14,630 303 2.1% 18,280 -3,347 (18.3%)Cheque Promedio Alim. 210 210 0 0.0% 227 -17 (7.6%)No. personas Beb. 14,933 14,630 303 2.1% 18,280 -3,347 (18.3%)Cheque Promedio Beb. 64 53 11 20.6% 61 2 3.6%No. de huespedes 8,152 8,699 -547 (6.3%) 8,513 -361 (4.2%)Cons. prom x huesped 1,196 1,121 75 6.7% 1,347 -152 (11.2%)

INGRESOSIng Habitaciones 6,235 64.0% 6,332 64.9% -97 (1.5%) 6,929 60.4% -694 (10.0%)Ing Alimentos, Bebidas y O 3,220 33.0% 3,151 32.3% 69 2.2% 4,238 36.9% -1,017 (24.0%)Ing Otros 294 3.0% 267 2.7% 27 10.2% 304 2.7% -10 (3.3%)

Total de Ingresos 9,750 100.0% 9,750 100.0% -0 (0.0%) 11,471 100.0% -1,721 (15.0%)

COSTOSCostos Alimentos 704 32.3% 689 30.0% -15 (2.1%) 841 27.8% 137 16.3%Costos Bebidas 188 19.8% 155 20.1% -33 (20.9%) 206 18.3% 18 8.7%Costos Otros 8 2.8% 22 8.4% 14 62.7% 23 7.5% 15 63.5%

Total de Costo 900 9.2% 867 8.9% -33 (3.8%) 1,070 9.3% 170 15.9%

NOMINANom Habitaciones 661 10.6% 691 10.9% 30 4.3% 686 9.9% 25 3.7%Nom Alimentos y Bebidas 726 22.5% 729 23.1% 4 0.5% 722 17.0% -4 (0.5%)Nom Otros 29 9.7% 37 13.9% 8 22.7% 36 11.9% 8 21.0%

Nomina y Relativos 1,415 14.5% 1,457 14.9% 42 2.9% 1,444 12.6% 29 2.0%

OTROS GASTOSGtos Habitaciones 706 11.3% 722 11.4% 16 2.2% 767 11.1% 61 7.9%Gtos Alimentos y Bebidas 259 8.0% 267 8.5% 8 3.1% 332 7.8% 73 22.0%Gtos Otros 8 2.8% 5 2.0% -3 (51.9%) 3 1.0% -5 (168.2%)

Total Otros Gastos 973 10.0% 994 10.2% 21 2.1% 1,102 9.6% 129 11.7%

UTILIDAD DEPTALUtil Habitaciones 4,868 78.1% 4,920 77.7% -51 (1.0%) 5,477 79.0% -608 (11.1%)Util Alimentos, Bebidas y O 1,344 41.7% 1,310 41.6% 34 2.6% 2,137 50.4% -793 (37.1%)Util Otros 249 84.6% 202 75.7% 47 23.2% 242 79.5% 7 2.9%

Total Utilidad Deptal 6,461 66.3% 6,432 66.0% 30 0.5% 7,855 68.5% -1,394 (17.7%)

GASTOS INDIRECTOSGtos Admon. y Grales. 979 10.0% 1,006 10.3% 27 2.7% 1,001 8.7% 22 2.2%Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 912 9.4% 940 9.6% 27 2.9% 985 8.6% 72 7.4%Gtos Mantenimiento 739 7.6% 709 7.3% -30 (4.2%) 916 8.0% 177 19.3%Gtos Recursos humanos 203 2.1% 194 2.0% -8 (4.2%) 197 1.7% -6 (3.0%)Gtos Energéticos 613 6.3% 671 6.9% 57 8.5% 738 6.4% 125 16.9%

Gastos Indirectos 3,446 35.3% 3,520 36.1% 74 2.1% 3,837 33.4% 390 10.2%

G.O.P. 3,015 30.9% 2,911 29.9% 103 3.6% 4,019 35.0% -1,004 (25.0%)GOP X CTO MN 12,939 12,495 444 3.6% 17,248 -4,308 (25.0%)GOP X CTO DLS 984 951 34 3.6% 1,330 -345 (26.0%)

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 271 2.8% 204 2.1% -68 (33.1%) 362 3.2% 90 25.0%Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 271 2.8% 204 2.1% -68 (33.1%) 362 3.2% 90 25.0%

EBITDA 2,744 28.1% 2,708 27.8% 36 0.013273 3,657 31.9% -913 (25.0%)

NOMINA TOTALNom Deptales. 1,415 14.5% 1,457 14.9% 42 2.9% 1,444 12.6% 29 2.0%Nom Admon. y Grales. 437 4.5% 460 4.7% 23 5.1% 416 3.6% -21 (5.0%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 231 2.4% 268 2.7% 37 13.8% 271 2.4% 41 15.0%Nom Mantenimiento 284 2.9% 294 3.0% 10 3.5% 293 2.6% 9 3.1%Nom Recursos Humanos 129 1.3% 120 1.2% -9 (7.8%) 119 1.0% -10 (8.5%)Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,496 25.6% 2,599 26.7% 104 4.0% 2,544 22.2% 48 1.9%

Ing Alimentos 2,183 2,298 3,027 Ing Bebidas 951 773 1,124 Ing Otros A&B 86 81 87 Total AyB 3,220 3,151 4,238

-25884.34%

Page 14: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ JULIOC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 5,610 5,015 595 11.9% 5,248 362 6.9%Cuartos Disponibles 7,223 7,223 0 0.0% 7,223 0 0.0%% Ocupación 77.7% 69.4% 8.2% 11.9% 72.7% 5.0% 6.9%Ocupación s/libros 61.2%Ocupación mes a la fecha 65.7%Tar. Prom. mes a la fecha 1714.86Tarifa Promedio 1,856 1,766 90 5.1% 1,807 49 2.7%Tarifa Efectiva 1,442 1,226 215 17.6% 1,313 129 9.8%

No. de Comensales 18,032 17,532 500 2.9% 18,410 -378 (2.1%)Cheque Promedio Alim. 204 205 -2 (0.9%) 176 28 15.7%No. personas Beb. 18,032 17,532 500 2.9% 18,410 -378 (2.1%)Cheque Promedio Beb. 49 51 -1 (2.8%) 42 8 18.8%No. de huespedes 10,331 10,331 0 0.0% 13,335 -3,004 (22.5%)Cons. prom x huesped 1,400 1,242 157 12.7% 980 420 42.9%

INGRESOSIng Habitaciones 10,412 72.0% 8,856 69.0% 1,556 17.6% 9,482 72.6% 931 9.8%Ing Alimentos, Bebidas y O 3,765 26.0% 3,695 28.8% 70 1.9% 3,311 25.3% 454 13.7%Ing Otros 283 2.0% 283 2.2% 0 0.0% 272 2.1% 11 4.1%

Total de Ingresos 14,461 100.0% 12,835 100.0% 1,626 12.7% 13,065 100.0% 1,396 10.7%

COSTOSCostos Alimentos 863 31.0% 815 30.0% -48 (5.9%) 806 32.5% -57 (7.1%)Costos Bebidas 179 20.1% 179 20.1% -0 (0.0%) 167 21.9% -11 (6.8%)Costos Otros 26 9.1% 26 9.1% 0 0.0% 24 8.7% -2 (9.4%)

Total de Costo 1,068 7.4% 1,019 7.9% -48 (4.7%) 997 7.6% -71 (7.1%)

NOMINANom Habitaciones 711 6.8% 704 8.0% -7 (1.0%) 711 7.5% -1 (0.1%)Nom Alimentos y Bebidas 755 20.1% 755 20.4% 0 0.0% 738 22.3% -17 (2.3%)Nom Otros 39 13.7% 39 13.7% 0 0.0% 39 14.2% -0 (0.0%)

Nomina y Relativos 1,505 10.4% 1,498 11.7% -7 (0.5%) 1,487 11.4% -18 (1.2%)

OTROS GASTOSGtos Habitaciones 860 8.3% 801 9.0% -58 (7.3%) 721 7.6% -139 (19.3%)Gtos Alimentos y Bebidas 286 7.6% 292 7.9% 6 1.9% 236 7.1% -50 (21.1%)Gtos Otros 5 1.8% 6 2.0% 1 10.4% 4 1.3% -1 (38.4%)

Total Otros Gastos 1,151 8.0% 1,099 8.6% -52 (4.7%) 961 7.4% -190 (19.8%)

UTILIDAD DEPTALUtil Habitaciones 8,841 84.9% 7,351 83.0% 1,491 20.3% 8,050 84.9% 791 9.8%Util Alimentos, Bebidas y O 1,682 44.7% 1,654 44.8% 27 1.7% 1,363 41.2% 318 23.3%Util Otros 214 75.5% 213 75.3% 1 0.3% 206 75.8% 8 3.7%

Total Utilidad Deptal 10,737 74.2% 9,218 71.8% 1,519 16.5% 9,620 73.6% 1,117 11.6%

GASTOS INDIRECTOSGtos Admon. y Grales. 1,172 8.1% 1,111 8.7% -61 (5.5%) 1,097 8.4% -75 (6.8%)Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 1,266 8.8% 1,179 9.2% -87 (7.3%) 1,205 9.2% -61 (5.1%)Gtos Mantenimiento 834 5.8% 781 6.1% -54 (6.9%) 846 6.5% 12 1.4%Gtos Recursos humanos 209 1.4% 204 1.6% -5 (2.4%) 170 1.3% -39 (23.2%)Gtos Energéticos 766 5.3% 756 5.9% -10 (1.3%) 795 6.1% 30 3.7%

Gastos Indirectos 4,247 29.4% 4,031 31.4% -216 (5.4%) 4,113 31.5% -134 (3.3%)

G.O.P. 6,490 44.9% 5,187 40.4% 1,302 25.1% 5,507 42.2% 983 17.8%GOP X CTO MN 27,853 22,263 5,590 25.1% 23,636 4,217 17.8%GOP X CTO DLS 2,134 1,706 428 25.1% 1,810 324 17.9%

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 649 4.5% 519 4.0% -130 (25.1%) 551 4.2% -98 (17.8%)Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 649 4.5% 519 4.0% -130 (25.1%) 551 4.2% -98 (17.8%)

EBITDA 5,841 40.4% 4,669 36.4% 1,172 0.251078 4,956 37.9% 884 17.8%

NOMINA TOTALNom Deptales. 1,505 10.4% 1,498 11.7% -7 (0.5%) 1,487 11.4% -18 (1.2%)Nom Admon. y Grales. 460 3.2% 460 3.6% 0 0.0% 451 3.4% -10 (2.1%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 283 2.0% 283 2.2% 0 0.0% 293 2.2% 9 3.2%Nom Mantenimiento 301 2.1% 301 2.3% 0 0.0% 289 2.2% -12 (4.2%)Nom Recursos Humanos 125 0.9% 120 0.9% -5 (4.2%) 88 0.7% -37 (42.0%)Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,675 18.5% 2,663 20.7% -12 (0.5%) 2,607 20.0% -67 (2.6%)

Ing Alimentos 2,783 2,713 2,476 Ing Bebidas 889 889 764 Ing Otros A&B 93 93 71 Total AyB 3,765 3,695 3,311

Page 15: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ AGOSTOC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 5,400 5,250 150 2.9% 5,696 -296 (5.2%)Cuartos Disponibles 7,223 7,223 0 0.0% 7,223 0 0.0%% Ocupación 74.8% 72.7% 2.1% 2.9% 78.9% (4.1%) (5.2%)Ocupación s/libros 21.7%Ocupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,843 1,827 16 0.9% 1,806 37 2.1%Tarifa Efectiva 1,378 1,328 50 3.8% 1,424 -46 (3.2%)

No. de Comensales 18,679 18,329 350 1.9% 19,752 -1,073 (5.4%)Cheque Promedio Alim. 207 208 -1 (0.6%) 207 -1 (0.3%)No. personas Beb. 18,679 18,329 350 1.9% 19,752 -1,073 (5.4%)Cheque Promedio Beb. 50 51 -1 (1.9%) 58 -7 (12.9%)No. de huespedes 10,815 10,815 0 0.0% 12,766 -1,951 (15.3%)Cons. prom x huesped 1,313 1,275 38 3.0% 1,155 158 13.7%

INGRESOSIng Habitaciones 9,952 70.1% 9,592 69.5% 360 3.8% 10,286 69.7% -334 (3.2%)Ing Alimentos, Bebidas y O 3,959 27.9% 3,910 28.3% 49 1.3% 4,196 28.4% -237 (5.6%)Ing Otros 291 2.0% 291 2.1% 0 0.0% 266 1.8% 25 9.2%

Total de Ingresos 14,202 100.0% 13,793 100.0% 409 3.0% 14,749 100.0% -546 (3.7%)

COSTOSCostos Alimentos 891 30.5% 862 30.0% -29 (3.4%) 886 30.0% -5 (0.5%)Costos Bebidas 189 20.1% 189 20.1% -0 (0.0%) 224 19.6% 34 15.4%Costos Otros 27 9.4% 27 9.4% 0 0.0% 23 8.6% -4 (19.4%)

Total de Costo 1,107 7.8% 1,078 7.8% -29 (2.7%) 1,133 7.7% 25 2.2%

NOMINANom Habitaciones 736 7.4% 728 7.6% -8 (1.1%) 752 7.3% 16 2.2%Nom Alimentos y Bebidas 758 19.1% 758 19.4% 0 0.0% 762 18.2% 4 0.5%Nom Otros 36 12.4% 36 12.4% 0 0.0% 35 13.0% -1 (4.0%)

Nomina y Relativos 1,530 10.8% 1,522 11.0% -8 (0.5%) 1,549 10.5% 19 1.2%

OTROS GASTOSGtos Habitaciones 857 8.6% 845 8.8% -12 (1.4%) 821 8.0% -36 (4.4%)Gtos Alimentos y Bebidas 292 7.4% 308 7.9% 16 5.1% 298 7.1% 6 1.9%Gtos Otros 5 1.7% 6 1.9% 1 10.0% 11 4.0% 6 52.7%

Total Otros Gastos 1,155 8.1% 1,159 8.4% 4 0.4% 1,130 7.7% -25 (2.2%)

UTILIDAD DEPTALUtil Habitaciones 8,359 84.0% 8,019 83.6% 340 4.2% 8,713 84.7% -354 (4.1%)Util Alimentos, Bebidas y O 1,829 46.2% 1,793 45.9% 36 2.0% 2,026 48.3% -197 (9.7%)Util Otros 223 76.5% 222 76.3% 1 0.3% 198 74.4% 24 12.3%

Total Utilidad Deptal 10,410 73.3% 10,034 72.7% 377 3.8% 10,937 74.2% -527 (4.8%)

GASTOS INDIRECTOSGtos Admon. y Grales. 1,170 8.2% 1,150 8.3% -20 (1.8%) 1,271 8.6% 101 7.9%Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 1,257 8.8% 1,246 9.0% -11 (0.9%) 1,206 8.2% -51 (4.2%)Gtos Mantenimiento 816 5.7% 792 5.7% -24 (3.0%) 924 6.3% 108 11.7%Gtos Recursos humanos 213 1.5% 208 1.5% -5 (2.4%) 165 1.1% -48 (29.1%)Gtos Energéticos 795 5.6% 780 5.7% -15 (1.9%) 829 5.6% 35 4.2%

Gastos Indirectos 4,249 29.9% 4,174 30.3% -75 (1.8%) 4,395 29.8% 145 3.3%

G.O.P. 6,161 43.4% 5,860 42.5% 302 5.1% 6,543 44.4% -382 (5.8%)GOP X CTO MN 26,442 25,148 1,294 5.1% 28,080 -1,637 (5.8%)GOP X CTO DLS 2,026 1,927 99 5.1% 2,151 -125 (5.8%)

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 616 4.3% 586 4.2% -30 (5.1%) 654 4.4% 38 5.8%Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 616 4.3% 586 4.2% -30 (5.1%) 654 4.4% 38 5.8%

EBITDA 5,545 39.0% 5,274 38.2% 271 0.051458 5,888 39.9% -343 (5.8%)

NOMINA TOTALNom Deptales. 1,530 10.8% 1,522 11.0% -8 (0.5%) 1,549 10.5% 19 1.2%Nom Admon. y Grales. 461 3.2% 461 3.3% 0 0.0% 505 3.4% 44 8.8%Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 278 2.0% 278 2.0% 0 0.0% 236 1.6% -42 (17.7%)Nom Mantenimiento 301 2.1% 301 2.2% 0 0.0% 298 2.0% -3 (1.1%)Nom Recursos Humanos 125 0.9% 120 0.9% -5 (4.2%) 93 0.6% -31 (33.6%)Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,695 19.0% 2,682 19.4% -13 (0.5%) 2,682 18.2% -13 (0.5%)

Ing Alimentos 2,919 2,870 2,953 Ing Bebidas 942 942 1,143 Ing Otros A&B 98 98 100 Total AyB 3,959 3,910 4,196

73.64%

Page 16: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social: SemanaHotel: FA / FI

FAVZ SEPTIEMBREC o n c e p t o Mes % Plan % $ Var. % de Var Año Ant. % $ Var. % Var A/A

Cuartos Ocupados 4,100 4,100 0 0.0% 4,575 -475 (10.4%)Cuartos Disponibles 6,990 6,990 0 0.0% 6,990 0 0.0%% Ocupación 58.7% 58.7% 0.0% 0.0% 65.5% (6.8%) (10.4%)Ocupación s/libros 8.7%Ocupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,452 1,415 37 2.6% 1,401 50 3.6%Tarifa Efectiva 852 830 22 2.6% 917 -66 (7.2%)

No. de Comensales 13,808 13,808 0 0.0% 18,006 -4,198 (23.3%)Cheque Promedio Alim. 213 210 4 1.7% 208 5 2.6%No. personas Beb. 13,808 13,808 0 0.0% 18,006 -4,198 (23.3%)Cheque Promedio Beb. 53 53 0 0.0% 43 9 21.8%No. de huespedes 8,323 8,323 0 0.0% 8,341 -18 (0.2%)Cons. prom x huesped 1,110 1,086 24 2.2% 1,268 -158 (12.5%)

INGRESOSIng Habitaciones 5,952 64.4% 5,802 64.2% 151 2.6% 6,412 60.6% -459 (7.2%)Ing Alimentos, Bebidas y O 3,024 32.7% 2,974 32.9% 50 1.7% 3,828 36.2% -804 (21.0%)Ing Otros 261 2.8% 261 2.9% 0 0.0% 337 3.2% -76 (22.6%)

Total de Ingresos 9,238 100.0% 9,037 100.0% 201 2.2% 10,577 100.0% -1,340 (12.7%)

COSTOSCostos Alimentos 675 30.4% 651 30.0% -25 (3.8%) 823 27.8% 148 18.0%Costos Bebidas 147 20.1% 147 20.1% -0 (0.0%) 146 18.6% -1 (0.8%)Costos Otros 21 8.1% 21 8.1% 0 0.0% 25 7.5% 4 16.7%

Total de Costo 843 9.1% 818 9.1% -25 (3.0%) 994 9.4% 151 15.2%

NOMINANom Habitaciones 704 11.8% 709 12.2% 5 0.7% 740 11.5% 36 4.9%Nom Alimentos y Bebidas 719 23.8% 721 24.2% 2 0.2% 757 19.8% 38 5.0%Nom Otros 32 12.4% 32 12.4% 0 0.0% 31 9.2% -1 (3.9%)

Nomina y Relativos 1,455 15.8% 1,462 16.2% 7 0.4% 1,528 14.4% 73 4.8%

OTROS GASTOSGtos Habitaciones 705 11.9% 689 11.9% -16 (2.3%) 740 11.5% 35 4.7%Gtos Alimentos y Bebidas 253 8.4% 258 8.7% 5 1.8% 368 9.6% 115 31.2%Gtos Otros 5 1.9% 5 2.1% 0 9.2% 4 1.1% -1 (32.3%)

Total Otros Gastos 964 10.4% 953 10.5% -11 (1.2%) 1,112 10.5% 148 13.3%

UTILIDAD DEPTALUtil Habitaciones 4,543 76.3% 4,403 75.9% 140 3.2% 4,932 76.9% -388 (7.9%)Util Alimentos, Bebidas y O 1,230 40.7% 1,198 40.3% 31 2.6% 1,734 45.3% -505 (29.1%)Util Otros 203 77.6% 202 77.4% 0 0.2% 277 82.2% -75 (26.9%)

Total Utilidad Deptal 5,975 64.7% 5,804 64.2% 172 3.0% 6,943 65.6% -968 (13.9%)

GASTOS INDIRECTOSGtos Admon. y Grales. 980 10.6% 977 10.8% -3 (0.3%) 1,009 9.5% 29 2.9%Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Gtos Ventas 908 9.8% 904 10.0% -4 (0.5%) 927 8.8% 19 2.0%Gtos Mantenimiento 729 7.9% 721 8.0% -8 (1.1%) 854 8.1% 125 14.6%Gtos Recursos humanos 197 2.1% 192 2.1% -5 (2.6%) 157 1.5% -41 (25.9%)Gtos Energéticos 653 7.1% 663 7.3% 10 1.5% 697 6.6% 45 6.4%

Gastos Indirectos 3,467 37.5% 3,457 38.3% -10 (0.3%) 3,644 34.4% 177 4.8%

G.O.P. 2,508 27.2% 2,347 26.0% 161 6.9% 3,299 31.2% -791 (24.0%)GOP X CTO MN 10,765 10,073 691 6.9% 14,159 -3,395 (24.0%)GOP X CTO DLS 825 772 53 6.9% 1,053 -228 (21.7%)

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Incentivos 176 1.9% 164 1.8% -11 (6.9%) 297 2.8% 121 40.9%Seguros contra daños 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Impuesto predia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Zona Federal 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Reserva Extraordinaria 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Total Inmobiliara 176 1.9% 164 1.8% -11 (6.9%) 297 2.8% 121 40.9%

EBITDA 2,333 25.3% 2,183 24.2% 150 0.068639 3,002 28.4% -670 (22.3%)

NOMINA TOTALNom Deptales. 1,455 15.8% 1,462 16.2% 7 0.4% 1,528 14.4% 73 4.8%Nom Admon. y Grales. 461 5.0% 461 5.1% 0 0.0% 440 4.2% -21 (4.7%)Nom Entretenimiento AI 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%Nom Ventas 280 3.0% 280 3.1% 0 0.0% 272 2.6% -7 (2.7%)Nom Mantenimiento 301 3.3% 301 3.3% 0 0.0% 294 2.8% -7 (2.3%)Nom Recursos Humanos 125 1.3% 120 1.3% -5 (4.2%) 88 0.8% -37 (41.8%)Nom Lavanderia 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Nomina Total 2,621 28.4% 2,623 29.0% 2 0.1% 2,623 24.8% 1 0.1%

Ing Alimentos 2,219 2,169 2,965 Ing Bebidas 729 729 781 Ing Otros A&B 76 76 82 Total AyB 3,024 2,974 3,828

80.20%

Page 17: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ OCTUBREC o n c e p t o Mes % Plan % $ Var.

Cuartos Ocupados 4,660 4,660 0 Cuartos Disponibles 7,223 7,223 0 % Ocupación 64.5% 64.5% 0.0%Ocupación s/libros 13.5%Ocupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,428 1,428 0 Tarifa Efectiva 921 921 0

No. de Comensales 16,441 16,441 0 Cheque Promedio Alim. 215 211 4 No. personas Beb. 16,441 16,441 0 Cheque Promedio Beb. 53 53 0 No. de huespedes 9,460 9,460 0 Cons. prom x huesped 1,116 1,109 7

INGRESOSIng Habitaciones 6,654 63.0% 6,654 63.4% 0 Ing Alimentos, Bebidas y O 3,628 34.4% 3,558 33.9% 70 Ing Otros 277 2.6% 277 2.6% 0

Total de Ingresos 10,560 100.0% 10,490 100.0% 70

COSTOSCostos Alimentos 808 30.2% 779 29.9% -29 Costos Bebidas 174 20.1% 174 20.1% -0 Costos Otros 24 8.8% 24 8.8% 0

Total de Costo 1,007 9.5% 977 9.3% -29

NOMINANom Habitaciones 695 10.4% 697 10.5% 2 Nom Alimentos y Bebidas 728 20.1% 730 20.5% 2 Nom Otros 35 12.8% 35 12.8% 0

Nomina y Relativos 1,459 13.8% 1,463 13.9% 4

OTROS GASTOSGtos Habitaciones 762 11.4% 757 11.4% -5 Gtos Alimentos y Bebidas 282 7.8% 290 8.1% 7 Gtos Otros 5 1.8% 6 2.0% 1

Total Otros Gastos 1,049 9.9% 1,052 10.0% 3

UTILIDAD DEPTALUtil Habitaciones 5,197 78.1% 5,200 78.1% -3 Util Alimentos, Bebidas y O 1,636 45.1% 1,586 44.6% 50 Util Otros 212 76.6% 211 76.4% 1

Total Utilidad Deptal 7,045 66.7% 6,997 66.7% 48

Page 18: FAVZ - Pronostico al 15 Julio 2015 (2).xls

GASTOS INDIRECTOSGtos Admon. y Grales. 1,037 9.8% 1,037 9.9% 0 Entretenimiento AI 0 0.0% 0 0.0% 0 Gtos Ventas 965 9.1% 974 9.3% 9 Gtos Mantenimiento 764 7.2% 756 7.2% -8 Gtos Recursos humanos 202 1.9% 197 1.9% -5 Gtos Energéticos 724 6.9% 724 6.9% 0

Gastos Indirectos 3,692 35.0% 3,688 35.2% -4

G.O.P. 3,354 31.8% 3,309 31.5% 44 GOP X CTO MN 14,394 14,204 190 GOP X CTO DLS 1,106 1,092 15

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 Incentivos 302 2.9% 298 2.8% -4 Seguros contra daños 0 0.0% 0 0.0% 0 Impuesto predia 0 0.0% 0 0.0% 0 Zona Federal 0 0.0% 0 0.0% 0 Reserva Extraordinaria 0 0.0% 0 0.0% 0

Total Inmobiliara 302 2.9% 298 2.8% -4

EBITDA 3,052 28.9% 3,012 28.7% 40

NOMINA TOTALNom Deptales. 1,459 13.8% 1,463 13.9% 4 Nom Admon. y Grales. 461 4.4% 461 4.4% 0 Nom Entretenimiento AI 0 0.0% 0 0.0% 0 Nom Ventas 268 2.5% 268 2.6% 0 Nom Mantenimiento 301 2.9% 301 2.9% 0 Nom Recursos Humanos 125 1.2% 120 1.1% -5 Nom Lavanderia 0 0.0% 0 0.0% 0

0 0.0% 0 0.0% 0

Nomina Total 2,614 24.8% 2,613 24.9% -1

Ing Alimentos 2,673 2,603 Ing Bebidas 867 867 Ing Otros A&B 88 88 Total AyB 3,628 3,558

63.26%

Page 19: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Semana

OCTUBRE% de Var Año Ant. % $ Var. % Var A/A

0.0% 4,960 -300 (6.0%)0.0% 7,223 0 0.0%0.0% 68.7% (4.2%) (6.0%)

0.0% 1,461 -33 (2.3%)0.0% 1,003 -82 (8.2%)

0.0% 15,449 992 6.4%2.0% 206 10 4.6%0.0% 15,449 992 6.4%0.0% 54 -2 (3.0%)0.0% 8,690 770 8.9%0.7% 1,242 -126 (10.1%)

0.0% 7,247 67.2% -593 (8.2%)2.0% 3,260 30.2% 369 11.3%0.0% 285 2.6% -8 (3.0%)

0.7% 10,792 100.0% -232 (2.2%)

(3.8%) 706 30.2% -103 (14.5%)(0.0%) 155 18.5% -18 (11.8%)

0.0% 23 8.1% -1 (6.0%)

(3.0%) 884 8.2% -122 (13.8%)

0.3% 672 9.3% -23 (3.4%)0.3% 738 22.6% 10 1.3%0.0% 26 9.3% -9 (33.9%)

0.3% 1,437 13.3% -22 (1.5%)

(0.6%) 835 11.5% 73 8.7%2.6% 264 8.1% -18 (6.7%)9.7% 9 3.0% 4 42.1%

0.3% 1,108 10.3% 59 5.3%

(0.1%) 5,740 79.2% -543 (9.5%)3.2% 1,396 42.8% 240 17.2%0.3% 227 79.6% -15 (6.7%)

0.7% 7,363 68.2% -318 (4.3%)

Page 20: FAVZ - Pronostico al 15 Julio 2015 (2).xls

0.0% 1,052 9.7% 15 1.4%0.0% 0 0.0% 0 0.0%0.9% 1,005 9.3% 40 4.0%

(1.1%) 884 8.2% 119 13.5%(2.5%) 158 1.5% -44 (27.8%)

0.0% 706 6.5% -17 (2.4%)

(0.1%) 3,805 35.3% 113 3.0%

1.3% 3,558 33.0% -205 (5.8%)1.3% 15,272 -879 (5.8%)1.3% 1,138 -31 (2.7%)

0.0% 0 0.0% 0 0.0%(1.3%) 320 3.0% 18 5.8%

0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(1.3%) 320 3.0% 18 5.8%

0.013381 3,238 30.0% -186 (5.8%)

0.3% 1,437 13.3% -22 (1.5%)0.0% 446 4.1% -15 (3.4%)0.0% 0 0.0% 0 0.0%0.0% 250 2.3% -18 (7.2%)0.0% 286 2.7% -15 (5.3%)

(4.2%) 88 0.8% -37 (42.2%)0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(0.0%) 2,506 23.2% -107 (4.3%)

2,340 840

79 3,260

Page 21: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ NOVIEMBREC o n c e p t o Mes % Plan % $ Var.

Cuartos Ocupados 4,430 4,430 0 Cuartos Disponibles 6,990 6,990 0 % Ocupación 63.4% 63.4% 0.0%Ocupación s/libros 4.8%Ocupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,482 1,522 -40 Tarifa Efectiva 939 964 -25

No. de Comensales 15,986 15,986 0 Cheque Promedio Alim. 214 211 3 No. personas Beb. 15,986 15,986 0 Cheque Promedio Beb. 53 53 0 No. de huespedes 8,993 8,993 0 Cons. prom x huesped 1,150 1,165 -15

INGRESOSIng Habitaciones 6,563 63.5% 6,740 64.4% -177 Ing Alimentos, Bebidas y O 3,501 33.9% 3,461 33.0% 40 Ing Otros 274 2.6% 274 2.6% 0

Total de Ingresos 10,337 100.0% 10,475 100.0% -137

COSTOSCostos Alimentos 770 29.9% 758 29.9% -12 Costos Bebidas 169 20.0% 169 20.0% -0 Costos Otros 24 8.7% 24 8.7% 0

Total de Costo 962 9.3% 950 9.1% -12

NOMINANom Habitaciones 691 10.5% 692 10.3% 2 Nom Alimentos y Bebidas 738 21.1% 741 21.4% 3 Nom Otros 38 13.7% 38 13.7% 0

Nomina y Relativos 1,466 14.2% 1,470 14.0% 5

OTROS GASTOSGtos Habitaciones 726 11.1% 756 11.2% 30 Gtos Alimentos y Bebidas 290 8.3% 288 8.3% -2 Gtos Otros 5 1.9% 6 2.1% 1

Total Otros Gastos 1,021 9.9% 1,050 10.0% 29

UTILIDAD DEPTALUtil Habitaciones 5,147 78.4% 5,292 78.5% -146 Util Alimentos, Bebidas y O 1,534 43.8% 1,505 43.5% 29

Page 22: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Util Otros 207 75.8% 207 75.5% 1

Total Utilidad Deptal 6,888 66.6% 7,003 66.9% -116

GASTOS INDIRECTOSGtos Admon. y Grales. 1,029 10.0% 1,035 9.9% 5 Entretenimiento AI 0 0.0% 0 0.0% 0 Gtos Ventas 967 9.4% 986 9.4% 19 Gtos Mantenimiento 741 7.2% 743 7.1% 2 Gtos Recursos humanos 197 1.9% 197 1.9% 0 Gtos Energéticos 697 6.7% 707 6.8% 10

Gastos Indirectos 3,632 35.1% 3,668 35.0% 36

G.O.P. 3,256 31.5% 3,336 31.8% -80 GOP X CTO MN 13,974 14,315 -341 GOP X CTO DLS 1,074 1,100 -26

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 Incentivos 293 2.8% 300 2.9% 7 Seguros contra daños 0 0.0% 0 0.0% 0 Impuesto predia 0 0.0% 0 0.0% 0 Zona Federal 0 0.0% 0 0.0% 0 Reserva Extraordinaria 0 0.0% 0 0.0% 0

Total Inmobiliara 293 2.8% 300 2.9% 7

EBITDA 2,963 28.7% 3,035 29.0% -72

NOMINA TOTALNom Deptales. 1,466 14.2% 1,470 14.0% 5 Nom Admon. y Grales. 461 4.5% 461 4.4% 0 Nom Entretenimiento AI 0 0.0% 0 0.0% 0 Nom Ventas 270 2.6% 270 2.6% 0 Nom Mantenimiento 301 2.9% 301 2.9% 0 Nom Recursos Humanos 125 1.2% 120 1.1% -5 Nom Lavanderia 0 0.0% 0 0.0% 0

0 0.0% 0 0.0% 0

Nomina Total 2,622 25.4% 2,622 25.0% -1

Ing Alimentos 2,572 2,532 Ing Bebidas 843 843 Ing Otros A&B 85 85 Total AyB 3,501 3,461

42.04%

Page 23: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Semana

NOVIEMBRE% de Var Año Ant. % $ Var. % Var A/A

0.0% 5,490 -1,060 (19.3%)0.0% 6,990 0 0.0%0.0% 78.5% (15.2%) (19.3%)

(2.6%) 2,381 -900 (37.8%)(2.6%) 1,870 -931 (49.8%)

0.0% 13,531 2,455 18.1%1.2% 210 4 1.7%0.0% 13,531 2,455 18.1%0.0% 32 21 63.9%0.0% 8,072 921 11.4%

(1.3%) 2,009 -860 (42.8%)

(2.6%) 13,073 80.6% -6,509 (49.8%)1.2% 2,863 17.7% 638 22.3%0.0% 282 1.7% -9 (3.1%)

(1.3%) 16,218 100.0% -5,880 (36.3%)

(1.6%) 649 27.0% -120 (18.5%)(0.0%) 73 16.7% -96 (132.0%)

0.0% 28 10.0% 5 16.3%

(1.3%) 751 4.6% -212 (28.2%)

0.2% 679 5.2% -11 (1.6%)0.4% 723 25.2% -15 (2.1%)0.0% 27 9.7% -10 (37.5%)

0.3% 1,429 8.8% -37 (2.6%)

4.0% 2,634 20.1% 1,908 72.4%(0.6%) 534 18.6% 244 45.7%10.5% 3 1.1% -2 (57.1%)

2.8% 3,171 19.6% 2,150 67.8%

(2.8%) 9,759 74.7% -4,613 (47.3%)2.0% 884 30.9% 650 73.5%

Page 24: FAVZ - Pronostico al 15 Julio 2015 (2).xls

0.3% 223 79.1% -16 (7.2%)

(1.7%) 10,867 67.0% -3,979 (36.6%)

0.5% 1,004 6.2% -25 (2.5%)0.0% 0 0.0% 0 0.0%1.9% 1,205 7.4% 238 19.7%0.3% 839 5.2% 98 11.6%0.0% 161 1.0% -36 (22.5%)1.4% 668 4.1% -30 (4.4%)

1.0% 3,876 23.9% 244 6.3%

(2.4%) 6,991 43.1% -3,735 (53.4%)(2.4%) 30,003 -16,029 (53.4%)(2.4%) 2,199 -1,125 (51.2%)

0.0% 0 0.0% 0 0.0%2.4% 966 6.0% 673 69.7%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

2.4% 966 6.0% 673 69.7%

-0.02384 6,024 37.1% -3,061 (50.8%)

0.3% 1,429 8.8% -37 (2.6%)0.0% 437 2.7% -24 (5.4%)0.0% 0 0.0% 0 0.0%0.0% 222 1.4% -47 (21.3%)0.0% 269 1.7% -32 (12.0%)

(4.2%) 88 0.5% -37 (41.7%)0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(0.0%) 2,446 15.1% -177 (7.2%)

2,406 435

21 2,863

Page 25: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ DICIEMBREC o n c e p t o Mes % Plan % $ Var.

Cuartos Ocupados 4,387 4,290 97 Cuartos Disponibles 7,223 7,223 0 % Ocupación 60.7% 59.4% 1.3%Ocupación s/libros 6.7%Ocupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,836 1,835 1 Tarifa Efectiva 1,115 1,090 25

No. de Comensales 15,898 15,898 0 Cheque Promedio Alim. 227 222 5 No. personas Beb. 15,898 15,898 0 Cheque Promedio Beb. 62 62 0 No. de huespedes 8,837 8,837 0 Cons. prom x huesped 1,360 1,330 30

INGRESOSIng Habitaciones 8,056 67.0% 7,873 67.0% 184 Ing Alimentos, Bebidas y O 3,690 30.7% 3,610 30.7% 80 Ing Otros 270 2.2% 270 2.3% 0

Total de Ingresos 12,016 100.0% 11,753 100.0% 264

COSTOSCostos Alimentos 794 30.4% 758 29.9% -36 Costos Bebidas 195 19.7% 195 19.7% -0 Costos Otros 23 8.5% 23 8.5% 0

Total de Costo 1,012 8.4% 976 8.3% -36

NOMINANom Habitaciones 713 8.9% 715 9.1% 2 Nom Alimentos y Bebidas 747 20.2% 750 20.8% 3 Nom Otros 36 13.3% 36 13.3% 0

Nomina y Relativos 1,496 12.5% 1,501 12.8% 5

OTROS GASTOSGtos Habitaciones 789 9.8% 797 10.1% 9 Gtos Alimentos y Bebidas 275 7.5% 276 7.6% 0 Gtos Otros 5 1.8% 6 2.0% 1

Total Otros Gastos 1,069 8.9% 1,078 9.2% 9

UTILIDAD DEPTALUtil Habitaciones 6,554 81.4% 6,361 80.8% 194 Util Alimentos, Bebidas y O 1,678 45.5% 1,631 45.2% 47 Util Otros 206 76.4% 206 76.2% 1

Total Utilidad Deptal 8,439 70.2% 8,198 69.8% 242

Page 26: FAVZ - Pronostico al 15 Julio 2015 (2).xls

GASTOS INDIRECTOSGtos Admon. y Grales. 1,070 8.9% 1,065 9.1% -5 Entretenimiento AI 0 0.0% 0 0.0% 0 Gtos Ventas 1,107 9.2% 1,106 9.4% -1 Gtos Mantenimiento 746 6.2% 738 6.3% -8 Gtos Recursos humanos 210 1.8% 205 1.7% -5 Gtos Energéticos 722 6.0% 722 6.1% 0

Gastos Indirectos 3,855 32.1% 3,836 32.6% -19

G.O.P. 4,584 38.1% 4,361 37.1% 223 GOP X CTO MN 19,674 18,718 956 GOP X CTO DLS 1,512 1,439 74

Gastos de Inmobiliaria 0 0.0% 0 0.0% 0 Incentivos 458 3.8% 436 3.7% -22 Seguros contra daños 0 0.0% 0 0.0% 0 Impuesto predia 0 0.0% 0 0.0% 0 Zona Federal 0 0.0% 0 0.0% 0 Reserva Extraordinaria 0 0.0% 0 0.0% 0

Total Inmobiliara 458 3.8% 436 3.7% -22

EBITDA 4,126 34.3% 3,925 33.4% 201

NOMINA TOTALNom Deptales. 1,496 12.5% 1,501 12.8% 5 Nom Admon. y Grales. 461 3.8% 461 3.9% 0 Nom Entretenimiento AI 0 0.0% 0 0.0% 0 Nom Ventas 292 2.4% 292 2.5% 0 Nom Mantenimiento 301 2.5% 301 2.6% 0 Nom Recursos Humanos 125 1.0% 120 1.0% -5 Nom Lavanderia 0 0.0% 0 0.0% 0

0 0.0% 0 0.0% 0

Nomina Total 2,675 22.3% 2,675 22.8% -1

Ing Alimentos 2,615 2,535 Ing Bebidas 992 992 Ing Otros A&B 83 83 Total AyB 3,690 3,610

84.51%

Page 27: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Semana

DICIEMBRE% de Var Año Ant. % $ Var. % Var A/A

2.3% 5,020 -633 (12.6%)0.0% 7,223 0 0.0%2.3% 69.5% (8.8%) (12.6%)

0.1% 2,088 -251 (12.0%)2.3% 1,451 -336 (23.1%)

0.0% 17,032 -1,134 (6.7%)2.3% 249 -22 (8.8%)0.0% 17,032 -1,134 (6.7%)0.0% 66 -4 (6.0%)0.0% 10,470 -1,633 (15.6%)2.2% 1,457 -98 (6.7%)

2.3% 10,481 68.7% -2,425 (23.1%)2.2% 4,306 28.2% -616 (14.3%)0.0% 472 3.1% -202 (42.8%)

2.2% 15,259 100.0% -3,242 (21.2%)

(4.7%) 965 31.1% 171 17.7%(0.0%) 224 19.9% 29 13.0%

0.0% 19 4.1% -4 (18.8%)

(3.7%) 1,208 7.9% 196 16.2%

0.2% 685 6.5% -29 (4.2%)0.4% 785 18.2% 38 4.8%0.0% 28 5.9% -8 (27.5%)

0.3% 1,498 9.8% 1 0.1%

1.1% 1,061 10.1% 272 25.7%0.1% 324 7.5% 49 15.1%9.7% 8 1.7% 3 39.3%

0.9% 1,394 9.1% 325 23.3%

3.0% 8,735 83.3% -2,181 (25.0%)2.9% 2,008 46.6% -329 (16.4%)0.3% 416 88.2% -210 (50.4%)

2.9% 11,159 73.1% -2,720 (24.4%)

Page 28: FAVZ - Pronostico al 15 Julio 2015 (2).xls

(0.4%) 1,062 7.0% -8 (0.7%)0.0% 0 0.0% 0 0.0%

(0.1%) 1,057 6.9% -51 (4.8%)(1.1%) 903 5.9% 157 17.4%(2.4%) 167 1.1% -43 (26.0%)

0.0% 749 4.9% 27 3.6%

(0.5%) 3,937 25.8% 82 2.1%

5.1% 7,222 47.3% -2,638 (36.5%)5.1% 30,994 -11,320 (36.5%)5.1% 2,106 -594 (28.2%)

0.0% 0 0.0% 0 0.0%(5.1%) 722 4.7% 264 36.5%

0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(5.1%) 722 4.7% 264 36.5%

0.051088 6,499 42.6% -2,374 (36.5%)

0.3% 1,498 9.8% 1 0.1%0.0% 401 2.6% -60 (15.0%)0.0% 0 0.0% 0 0.0%0.0% 230 1.5% -62 (27.0%)0.0% 267 1.8% -34 (12.7%)

(4.2%) 91 0.6% -34 (37.6%)0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(0.0%) 2,486 16.3% -189 (7.6%)

3,106 1,130

70 4,306

Page 29: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Razón Social:Hotel: FA / FI

FAVZ TOTALC o n c e p t o Mes % Plan % $ Var.

Cuartos Ocupados 53,965 51,433 2,532 Cuartos Disponibles 85,045 85,045 0 % Ocupación 63.5% 60.5% 3.0%Ocupación s/librosOcupación mes a la fechaTar. Prom. mes a la fechaTarifa Promedio 1,684 1,565 119 Tarifa Efectiva 1,069 947 122

No. de Comensales 187,983 179,731 8,252 Cheque Promedio Alim. 211 210 1 No. personas Beb. 187,983 179,731 8,252 Cheque Promedio Beb. 55 53 2 No. de huespedes 109,447 104,989 4,458 Cons. prom x huesped 1,231 1,166 64

INGRESOSIng Habitaciones 90,883 67.5% 80,495 65.7% 10,388 Ing Alimentos, Bebidas y O 40,672 30.2% 38,756 31.6% 1,916 Ing Otros 3,139 2.3% 3,209 2.6% -70

Total de Ingresos 134,694 100.0% 122,460 100.0% 12,234

COSTOSCostos Alimentos 9,055 30.7% 8,465 30.0% -590 Costos Bebidas 1,952 18.9% 1,916 20.1% -36 Costos Otros 250 8.0% 270 8.4% 20

Total de Costo 11,258 8.4% 10,651 8.7% -607

NOMINANom Habitaciones 8,053 8.9% 8,405 10.4% 352 Nom Alimentos y Bebidas 8,768 21.6% 8,799 22.7% 31 Nom Otros 384 12.2% 440 13.7% 56

Nomina y Relativos 17,205 12.8% 17,644 14.4% 439

OTROS GASTOSGtos Habitaciones 9,702 10.7% 8,613 10.7% -1,089 Gtos Alimentos y Bebidas 3,713 9.1% 3,238 8.4% -475 Gtos Otros 54 1.7% 67 2.1% 13

Total Otros Gastos 13,469 10.0% 11,917 9.7% -1,552

UTILIDAD DEPTALUtil Habitaciones 73,128 80.5% 63,477 78.9% 9,651 Util Alimentos, Bebidas y O 17,183 42.2% 16,338 42.2% 845

Page 30: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Util Otros 2,452 78.1% 2,433 75.8% 19

Total Utilidad Deptal 92,763 68.9% 82,248 67.2% 10,515

GASTOS INDIRECTOSGtos Admon. y Grales. 12,528 9.3% 12,149 9.9% -379 Entretenimiento AI 0 0.0% 0 0.0% 0 Gtos Ventas 12,319 9.1% 11,759 9.6% -560 Gtos Mantenimiento 9,172 6.8% 8,796 7.2% -375 Gtos Recursos humanos 2,296 1.7% 2,341 1.9% 45 Gtos Energéticos 8,140 6.0% 8,197 6.7% 56

Gastos Indirectos 44,455 33.0% 43,243 35.3% -1,212

G.O.P. 48,308 35.9% 39,005 31.9% 9,303

Gastos de Inmobiliaria 0 0.0% 8 0.0% 8 Incentivos 4,427 3.3% 3,523 2.9% -904 Seguros contra daños 0 0.0% 0 0.0% 0 Impuesto predia 0 0.0% 0 0.0% 0 Zona Federal 0 0.0% 0 0.0% 0 Reserva Extraordinaria 0 0.0% 0 0.0% 0

Total Inmobiliara 4,427 3.3% 3,531 2.9% -896

EBITDA 43,881 32.6% 35,475 29.0% 8,406

NOMINA TOTALNom Deptales. 17,205 12.8% 17,644 14.4% 439 Nom Admon. y Grales. 5,420 4.0% 5,463 4.5% 43 Nom Entretenimiento AI 0 0.0% 0 0.0% 0 Nom Ventas 3,220 2.4% 3,286 2.7% 66 Nom Mantenimiento 3,422 2.5% 3,558 2.9% 136 Nom Recursos Humanos 1,355 1.0% 1,421 1.2% 67 Nom Lavanderia 0 0.0% 0 0.0% 0

0 0.0% 0 0.0% 0

Nomina Total 30,622 22.7% 31,372 25.6% 750

Ing Alimentos 29,451 28,231 Ing Bebidas 10,305 9,553 Ing Otros A&B 916 972 Total AyB 40,672 38,756

76.04%

Page 31: FAVZ - Pronostico al 15 Julio 2015 (2).xls

TOTAL% de Var Año Ant. % $ Var. % Var A/A

4.9% 58,814 -4,849 (8.2%)0.0% 85,045 0 0.0%4.9% 69.2% (5.7%) (8.2%)

7.6% 1,734 -50 (2.9%)12.9% 1,199 -130 (10.9%)

4.6% 195,188 -7,205 (3.7%)0.6% 205 7 3.4%4.6% 195,188 -7,205 (3.7%)3.1% 50 5 9.9%4.2% 118,302 -8,855 (7.5%)5.5% 1,237 -6 (0.5%)

12.9% 101,970 69.7% -11,086 (10.9%)4.9% 40,870 27.9% -199 (0.5%)

(2.2%) 3,505 2.4% -366 (10.4%)

10.0% 146,345 100.0% -11,651 (8.0%)

(7.0%) 9,098 30.1% 43 0.5%(1.9%) 1,999 20.5% 47 2.3%

7.3% 286 8.1% 35 12.4%

(5.7%) 11,383 7.8% 125 1.1%

4.2% 8,477 8.3% 424 5.0%0.4% 8,760 21.4% -8 (0.1%)

12.7% 420 12.0% 36 8.5%

2.5% 17,657 12.1% 452 2.6%

(12.6%) 11,584 11.4% 1,882 16.2%(14.7%) 3,639 8.9% -75 (2.0%)

19.4% 64 1.8% 10 15.8%

(13.0%) 15,286 10.4% 1,817 11.9%

15.2% 81,909 80.3% -8,781 (10.7%)5.2% 17,375 42.5% -192 (1.1%)

Page 32: FAVZ - Pronostico al 15 Julio 2015 (2).xls

0.8% 2,736 78.1% -285 (10.4%)

12.8% 102,020 69.7% -9,257 (9.1%)

(3.1%) 12,502 8.5% -26 (0.2%)0.0% 0 0.0% 0 0.0%

(4.8%) 12,638 8.6% 319 2.5%(4.3%) 10,148 6.9% 977 9.6%

1.9% 2,098 1.4% -198 (9.4%)0.7% 8,687 5.9% 546 6.3%

(2.8%) 46,073 31.5% 1,618 3.5%

23.8% 55,947 38.2% -7,639 (13.7%)

100.0% 8 0.0% 8 100.0%(25.6%) 5,595 3.8% 1,168 20.9%

0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

(25.4%) 5,602 3.8% 1,176 21.0%

0.236971 50,345 34.4% -6,463 (12.8%)

2.5% 17,657 12.1% 452 2.6%0.8% 5,162 3.5% -259 (5.0%)0.0% 0 0.0% 0 0.0%2.0% 3,010 2.1% -211 (7.0%)3.8% 3,360 2.3% -61 (1.8%)4.7% 1,225 0.8% -130 (10.6%)0.0% 0 0.0% 0 0.0%0.0% 0 0.0% 0 0.0%

2.4% 30,413 20.8% -209 (0.7%)

30,207 9,733

930 40,870

Page 33: FAVZ - Pronostico al 15 Julio 2015 (2).xls

Arantzia 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00% 31.00%

21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00%

Palapa 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87% 31.87%

20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00%

Rosato 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71% 34.71%

35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85% 35.85%

Room Service 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00%

21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00% 21.00%

Banquetes 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05% 28.05%

18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00% 18.00%

Lobby 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79% 19.79%