Transcript
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%