excel base
DESCRIPTION
temas de labsagTRANSCRIPT
-
HOJA DE DECISIONES SIMSERVDESCRIPCIONES GENERALES P-11 P-12
10/20/2015 10/26/2015Nivel Deseado de Personal Dias-Turista 135830 60000Tarifa Deseada de Cuarto-Cama 190 160Construccin Regular de Nuevas Camas 0 50Construccin Urgente de Nuevas Camas 0 0Nmero de Unidades de Casa de Reposo 0 0Nmero de Unidades Peluquera 0 0Nmero de Unidades de Tiendas 0 0Nmero de Unidades Teatro 0 0Nmero de Unidades de Casino 0 0Nmero de Unidades de Ecoturismo 0 0Transferencia a Cuenta Valores Negociables 0 0Transferencia a Cuenta Hipoteca 0 0Transferencia a Cuenta Prstamo 0 0Transferencia a Hotel 1 0 0Transferencia a Hotel 2 0 0Transferencia a Hotel 3 0 0Tipo de Encuesta Centro Turstico Requerida 0 2
-
HOJA DE DECISIONES SIMSERVP-13 P-14 P-15 P-16 P-17 P-18
10/27/2015 11/3/2015 11/5/2015 11/9/2015 11/10/2015 11/16/201555000 55000 65000 80000165 170 175 2500 0 0 100 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 00 0 0 0
-
HOJA DE DECISIONES SIMSERVP-19 P-20
11/17/201578000265000000000000000
-
N CANTIDAD PROYECCIN ESTUDIO M. X31 24101 23919 12 25017 25160 83 26379 26610 274 28058 28354 645 30914 30477 1256 33647 33063 2167 36212 36196 3438 38789 39962 5129 45127 44444 72910 49672 49727 100011 55896 55896 $ 44,872.42 133112 63036 63036 $ 53,629.50 172813 71229 71229 $ 53,405.04 219714 80563 80563 $ 59,168.27 274415 91120 91120 $ 63,434.58 337516 102985 102985 $ 67,700.89 409617 116243 116243 $ 71,967.20 491318 130978 130978 $ 76,233.51 583219 147275 147275 $ 80,499.82 685920 165219 165219 $ 84,766.13 8000
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
0
50000
100000
150000
200000
CANTIDAD PROYECCINPERIODOS - AOS
DEMANDA CAMAS NOCHE
-
X2 X11 14 29 316 425 536 649 764 881 9
100 10121 11144 12169 13196 14225 15256 16289 17324 18361 19400 20
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
0
50000
100000
150000
200000
CANTIDAD PROYECCINPERIODOS - AOS
DEMANDA CAMAS NOCHE
-
AO DIAS ESTADIA PROMEDIO
1 8.3 710002 8.1 750003 7.9 813004 7.8 870005 7.8 930006 7.7 996007 7.6 1073008 7.6 1156009 7.8 124600
10 7.6 13800011 7.5 13888012 7.4 14608713 7.3 15329514 7.3 16050215 7.2 16770916 7.1 17491617 7.1 18212418 7.0 18933119 7.0 19653820 6.9 203745
Err:508 Err:508
POBLACION TOTAL DEL PUEBLO ALEDAO
-
8.19% $ 37,090.00 8.28% $ 38,900.00 8.35% $ 42,330.00 8.43% $ 41,730.00 8.51% $ 44,210.00 8.57% $ 47,830.00 8.67% $ 49,710.00 9.05% $ 50,870.00 9.14% $ 54,170.00 9.21% $ 56,200.00 9.29% $ 57,942.00 9.41% $ 60,058.00 9.53% $ 62,174.00 9.64% $ 64,290.00 9.76% $ 66,406.00 9.88% $ 68,522.00
10.00% $ 70,638.00 10.12% $ 72,754.00 10.23% $ 74,870.00 10.35% $ 76,986.00 Err:508 Err:508
% DE TURISTAS CON MAS DE 40 AOS
INGESO FAMILIAR MENSUAL DE LOS
TURISTAS PROMEDIO
-
$ 0.54 $ 67,059.00 $ 0.57 $ 69,609.00 $ 0.59 $ 73,397.00 $ 0.62 $ 78,068.00 $ 0.65 $ 86,016.00 $ 0.69 $ 93,621.00 $ 0.70 $ 100,757.00 $ 0.71 $ 107,927.00 $ 0.72 $ 124,380.00 $ 0.73 $ 136,518.00 $ 0.77 $ 135,630.20 $ 0.80 $ 143,247.47 $ 0.82 $ 150,864.75 $ 0.84 $ 158,482.02 $ 0.86 $ 166,099.29 $ 0.89 $ 173,716.56 $ 0.91 $ 181,333.84 $ 0.93 $ 188,951.11 $ 0.95 $ 196,568.38 $ 0.98 $ 204,185.65
Err:508 Err:508
FRACCIN CUBIERTA POR GRANDES OPERADORES
DE TURISMOTOTAL DIAS CAMA
UTILIZADOS EN LA PUNTA
-
BALANCE GENERALDESCRIPCION PERIODOP-10
EFECTIVO $ 25,000.00 VALORES NEGOCIABLES $ - TERRENO $ 80,000.00 EDIFICIOS $ 320,000.00 EQUIPO $ 110,000.00
ACTIVOS TOTALES $ 535,000 PRESTAMO $ 5,000.00 HIPOTECA $ 7,000.00
PASIVOS TOTALES $ 12,000 CAPITAL GENERAL $ 523,000.00
PASIVOS TOTALES & CAPITAL $ 535,000 ACTIVOS - PASIVOS Y PATRIMONIO $ -
ESTADO DE RESULTADOS SERVICIOS RUTINARIOS SERVICIOS AUXILIARES $ -
INGRESOS TOTALES $ - GASTOS TURISTAS HOSPEDADOS COSTOS DE SERVICIOS AUXILIARES $ - MULTA POR SOBRE OCUPACION $ - MULTA POR SUB OCUPACION PRIMA SOBRETIEMPO $ - GASTOS CONTRATAR Y DESPEDIR
GASTOS TOTALES $ - UTILIDAD OPERATIVA NETA $ -
OTROS HOTELES $ - INTERESES VALORES NEGOCIABLES $ - CAMPAA COLECTA $ -
OTROS INGRESOS TOTALES $ - TRANSFERIDOS DE OTROS HOTELES $ - INTERES DE HIPOTECA INTERES DE PRESTAMO COSTO DE EVENTOS $ - COSTO DE ENCUESTA $ - DEPRECIACION
OTROS GASTOS TOTALES $ - UTILIDAD NETA DE OTRAS FUENTES $ -
INGRESOS TOTALES - GASTOS TOTALES $ - INFORME OPERACIONAL
-
TRANSFERENCIA A VALORES NEGOCIABLESTRANSFERENCIA A HIPOTECATRANSFERENCIA PRESTAMO
TRANSFERENCIAS INTERNAS TOTALES $ - DATOS OPERACIONALES
DIAS TURISTA SERVIDOSDIAS TURISTA PERDIDOSPORCENTAJE DE OCUPACION REALRAZON DIAS TURISTA REALES A ORDENADOSPROMEDIO PONDERADO DE TARIFA CAMACOSTO DE CAMA ESTE AOCOSTO DE CONSTRUCCION CAMA ESTE AONUMERO ACTUAL DE CAMAS $ 200.00 CAMAS EMERGENCIA PROXIMO AO $ - CAMAS NUEVAS PROXIMO AO 0.00 CAMAS NUEVAS PROXIMOS DOS AOS 0.00
-
BALANCE GENERALPERIODO
P-11 P-12 P-13 $ 96,500.00 $ 93,500.00 $ 90,500.00 $ - $ - $ - $ 800,000.00 $ 800,000.00 $ 800,000.00 $ 3,088,000.00 $ 3,294,966.00 $ 3,905,886.00 $ 1,100,000.00 $ 1,100,000.00 $ 1,100,000.00 $ 5,084,500 $ 5,288,466 $ 5,896,386 $ 34,234,500.00 $ 58,617,120.00 $ 79,322,290.00 $ 70,000.00 $ 372,966.00 $ 1,079,885.00 $ 34,304,500 $ 58,990,086 $ 80,402,175 $ -29,220,000.00 $ -53,701,620.00 $ -7,450,790.00 $ 5,084,500 $ 5,288,466 $ 72,951,385 $ - $ - $ -67,054,999
ESTADO DE RESULTADOS $ 8,525,760.00 $ 8,580,720.00 $ 8,811,832.00 $ - $ - $ - $ 8,525,760 $ 8,580,720 $ 8,811,832 $ 16,963,590.33 $ 9,549,606.00 $ 9,731,037.00 $ - $ - $ - $ - $ - $ - $ 33,669.33 $ - $ - $ - $ - $ - $ 25,847,400.33 $ 12,398,210.00 $ 891,100.00 $ 42,844,660 $ 21,947,816 $ 10,622,137 $ -34,318,900 $ -13,367,096 $ -1,810,305 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ 9,100.00 $ 48,486.00 $ 140,385.00 $ 10,000.00 $ 10,955,040.00 $ 18,757,480.00 $ - $ - $ - $ - $ 15,000.00 $ - $ 112,000.00 $ 96,000.00 $ 96,000.00 $ 131,100 $ 11,114,526 $ 18,993,865 $ -131,100 $ -11,114,526 $ -18,993,865 $ -34,450,000 $ -24,481,622 $ -20,804,170
INFORME OPERACIONAL
-
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
DATOS OPERACIONALES $ 44,872.42 $ 53,629.50 $ 53,405.04 $ 7,877.29 $ - $ -
61% 76% 78%0.33 0.89 0.97
$ 164.98 $ 169.18 $ 173.69 $ 150.00 $ 163.50 $ 178.22 $ - $ 302,965.50 $ 706,919.60 $ 193.00 $ 187.00 $ 181.00 $ - $ - $ -
0.00 0.00 50.000.00 50.00 0.00
-
BALANCE GENERALPERIODO
P-14 P-15 P-16 $ 111,500.00 $ 108,000.00 $ 104,500.00 $ - $ - $ - $ 800,000.00 $ 800,000.00 $ 800,000.00 $ 3,770,617.00 $ 3,652,257.00 $ 3,533,897.00 $ 1,100,000.00 $ 1,100,000.00 $ 1,100,000.00 $ 5,782,117 $ 5,660,257 $ 5,538,397 $ 108,004,600.00 $ 8,105,563.00 $ 9,595,519.00 $ 1,079,885.00 $ 1,079,885.00 $ 1,079,885.00 $ 109,084,485 $ 9,185,448 $ 10,675,404 $ -103,302,300.00 $ -3,525,191.00 $ -5,137,007.00 $ 5,782,185 $ 5,660,257 $ 5,538,397 $ -68 $ - $ -
ESTADO DE RESULTADOS $ 11,162,390.00 $ 12,807,460.00 $ 14,000,600.00 $ - $ - $ 608,342.00 $ 11,162,390 $ 12,807,460 $ 14,608,942 $ 10,684,300.00 $ 13,763,100.00 $ 17,522,270.00 $ - $ - $ 440,892.00 $ - $ - $ 1,026,813.00 $ - $ - $ - $ 3,607,839.00 $ 2,778,241.00 $ - $ - $ 4,234,800.00 $ 5,077,600.00 $ 14,292,139 $ 20,776,141 $ 24,067,575 $ -3,129,749 $ -7,968,681 $ -9,458,633
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ 140,385.00 $ 140,385.00 $ 140,385.00 $ 25,391,130.00 $ - $ - $ - $ - $ - $ - $ - $ 135,269.00 $ 118,360.00 $ 118,360.00 $ 25,666,784 $ 258,745 $ 258,745 $ -25,666,784 $ -258,745 $ -258,745 $ -28,796,533 $ -8,227,426 $ -9,717,378
INFORME OPERACIONAL
-
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
DATOS OPERACIONALES $ 65,661.00 $ 73,185.50 $ 75,678.00 $ - $ - $ -
78% 90% 96%1.19 1.13 1.00
$ 194.75 $ 218.82 $ 231.14 $ 194.26 $ 21,174.00 $ 230.80 $ - $ - $ - $ 223.00 $ 216.00 $ 209.00 $ - $ - $ -
0.00 0.00 0.000.00 0.00 0.00
-
BALANCE GENERALPERIODO
P-17 P-18 P-19 $ 101,000.00 $ 97,500.00 $ 94,500.00 $ - $ - $ - $ 800,000.00 $ 800,000.00 $ 800,000.00 $ 3,415,537.00 $ 3,398,798.00 $ 3,534,462.00 $ 1,100,000.00 $ 1,100,000.00 $ 1,100,000.00 $ 5,416,537 $ 5,396,298 $ 5,528,962 $ 9,580,377.00 $ 6,513,870.00 $ 8,208,845.00 $ 1,079,885.00 $ 1,181,506.00 $ 1,418,621.00 $ 10,660,262 $ 7,695,376 $ 9,627,466 $ -5,243,736.00 $ -2,299,078.00 $ -4,098,505.00 $ 5,416,526 $ 5,396,298 $ 5,528,961 $ 11 $ - $ 1
ESTADO DE RESULTADOS $ 14,625,030.00 $ 18,432,500.00 $ 18,861,380.00 $ - $ - $ - $ 14,625,030 $ 18,432,500 $ 18,861,380 $ 19,811,150.00 $ 21,506,980.00 $ 22,803,440.00 $ - $ - $ - $ 2,244,812.00 $ 3,289,298.00 $ 3,487,581.00 $ - $ - $ - $ - $ - $ - $ 2,012,560.00 $ - $ 597,789.00 $ 24,068,522 $ 24,796,278 $ 26,888,810 $ -9,443,492 $ -6,363,778 $ -8,027,430
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ - $ 140,385.00 $ 153,596.00 $ 184,421.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 118,360.00 $ 118,360.00 $ 101,452.00 $ 258,745 $ 271,956 $ 285,873 $ -258,745 $ -271,956 $ -285,873 $ -9,702,237 $ -6,635,734 $ -8,313,303
INFORME OPERACIONAL
-
$ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
DATOS OPERACIONALES $ 75,000.13 $ 73,730.00 $ 71,175.00 $ - $ 2,463.77 $ 6,024.55
98% 100% 100%0.94 0.92 0.91
$ 239.80 $ 265.33 $ 279.70 $ 251.57 $ 274.21 $ 298.89 $ - $ 101,620.70 $ 237,115.00 $ 202.00 $ 195.00 $ 189.00 $ - $ - $ -
0.00 0.00 10.000.00 10.00 0.00
-
BALANCE GENERALPONDERADOPERIODO
P-20 $ 96,000.00 $ 92,590.91 $ - $ - $ 800,000.00 $ 734,545.45 $ 3,591,238.00 $ 3,227,787.09 $ 1,100,000.00 $ 1,010,000.00 $ 5,587,238 $ 5,064,923 $ 4,750,708.00 $ 29,721,672.00 $ 1,599,724.00 $ 913,567.45 $ 6,350,432 $ 30,635,239 $ -763,195.00 $ -19,474,402.00 $ 5,587,237 $ 11,160,837 $ 1 $ -6,095,914
ESTADO DE RESULTADOS $ 23,969,550.00 $ 13,977,722.20 $ 1,479,845.00 $ 189,835.18 $ 25,449,395 $ 12,896,855.36 $ 24,974,650.00 $ 16,731,012.33 $ 1,195,338.00 $ 148,748.18 $ 3,819,648.00 $ 1,260,741.09 $ - $ 3,366.93 $ - $ 580,552.73 $ - $ 5,105,945.93 $ 29,989,636 $ 21,844,883.09 $ -4,540,241 $ -8,948,027.73
$ - $ - $ - $ - $ - $ - $ - $ -
$ - $ - $ 207,964.00 $ 130,549.20 $ 1,000.00 $ 6,123,850.00 $ - $ - $ - $ 1,363.64 $ 124,328.00 $ 113,848.90 $ 333,292 $ 5,233,966.45 $ -333,292 $ -5,233,966.45 $ -4,873,533 $ -14,181,994.18
INFORME OPERACIONAL
-
$ - $ - $ - $ - $ - $ - $ - $ -
DATOS OPERACIONALES $ 72,635.00 $ 65,897.16 $ 10,001.25 $ 2,636.69
100% $ 0.88 0.93 $ 0.92
$ 318.89 $ 225.63 $ 325.79 $ 2,324.12 $ 181,103.40 $ 152,972.42 $ 192.00 $ 198.82 $ - $ -
0.00 $ 5.45 15.00 $ 6.82
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00
EFECTIVO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$1,000,000.00 $2,000,000.00 $3,000,000.00 $4,000,000.00 $5,000,000.00
EDIFICIOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $4,600,000 $4,800,000 $5,000,000 $5,200,000 $5,400,000 $5,600,000 $5,800,000 $6,000,000
ACTIVOS TOTALES
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $4,600,000 $4,800,000 $5,000,000 $5,200,000 $5,400,000 $5,600,000 $5,800,000 $6,000,000
ACTIVOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
SERVICIOS RUTINARIOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
GASTOS TURISTAS HOSPEDADOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000
GASTOS TOTALES
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000
GASTOS TOTALES
Periodos
Monto en $
$- $5,000,000.00
$10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
$- $50,000.00 $100,000.00 $150,000.00 $200,000.00 $250,000.00
Intereses de Prestamo e Hipoteca
INTERES DE PRESTAMO INTERES DE HIPOTECA
Periodos
Monto en $
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-30,000,000
$-20,000,000
$-10,000,000
$-
$10,000,000
$20,000,000
$30,000,000
OTROS INGRESOS TOTALES OTROS GASTOS TOTALES UTILIDAD NETA DE OTRAS FUENTES
Periodos
Monto en $
$- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 $80,000.00
$- $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00
DIAS TURISTA SERVIDOS DIAS TURISTA PERDIDOS
Periodos
Monto en $
-
$- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 $80,000.00
$- $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00
DIAS TURISTA SERVIDOS DIAS TURISTA PERDIDOS
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00
EFECTIVO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$200,000.00 $400,000.00 $600,000.00 $800,000.00
$1,000,000.00
TERRENO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$1,000,000.00 $2,000,000.00 $3,000,000.00 $4,000,000.00 $5,000,000.00
EDIFICIOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$200,000.00 $400,000.00 $600,000.00 $800,000.00
$1,000,000.00 $1,200,000.00
EQUIPO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $4,600,000 $4,800,000 $5,000,000 $5,200,000 $5,400,000 $5,600,000 $5,800,000 $6,000,000
ACTIVOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000,000 $40,000,000 $60,000,000 $80,000,000
$100,000,000 $120,000,000
PASIVOS TOTALES
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $4,600,000 $4,800,000 $5,000,000 $5,200,000 $5,400,000 $5,600,000 $5,800,000 $6,000,000
ACTIVOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000,000 $40,000,000 $60,000,000 $80,000,000
$100,000,000 $120,000,000
PASIVOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
SERVICIOS RUTINARIOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000
INGRESOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
GASTOS TURISTAS HOSPEDADOS
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
GASTOS CONTRATAR Y DESPEDIR
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000
GASTOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-20,000,000
$- $20,000,000 $40,000,000 $60,000,000
INGRESOS TOTALES GASTOS TOTALES UTILIDAD OPERATIVA NETA
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000
GASTOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-20,000,000
$- $20,000,000 $40,000,000 $60,000,000
INGRESOS TOTALES GASTOS TOTALES UTILIDAD OPERATIVA NETA
Periodos
Monto en $
$- $5,000,000.00
$10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
$- $50,000.00 $100,000.00 $150,000.00 $200,000.00 $250,000.00
Intereses de Prestamo e Hipoteca
INTERES DE PRESTAMO INTERES DE HIPOTECA
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00 $140,000.00 $160,000.00
DEPRECIACION
Periodos
Monto en $
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-30,000,000
$-20,000,000
$-10,000,000
$-
$10,000,000
$20,000,000
$30,000,000
OTROS INGRESOS TOTALES OTROS GASTOS TOTALES UTILIDAD NETA DE OTRAS FUENTES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-35,000,000 $-30,000,000 $-25,000,000 $-20,000,000 $-15,000,000 $-10,000,000 $-5,000,000
$- UTILIDAD OPERATIVA NETA UTILIDAD NETA DE OTRAS FUENTES
Periodos
Monto en $
$- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 $80,000.00
$- $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00
DIAS TURISTA SERVIDOS DIAS TURISTA PERDIDOS
Periodos
Monto en $
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-
$5,000.00
$10,000.00
$15,000.00
$20,000.00
$25,000.00
$- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00
COSTO DE CAMA ESTE AO PROMEDIO PONDERADO DE TARIFA CAMA
Periodos
Monto en $
-
$- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 $80,000.00
$- $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00
DIAS TURISTA SERVIDOS DIAS TURISTA PERDIDOS
Periodos
Monto en $
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-
$5,000.00
$10,000.00
$15,000.00
$20,000.00
$25,000.00
$- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00
COSTO DE CAMA ESTE AO PROMEDIO PONDERADO DE TARIFA CAMA
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$200,000.00 $400,000.00 $600,000.00 $800,000.00
$1,000,000.00
TERRENO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$200,000.00 $400,000.00 $600,000.00 $800,000.00
$1,000,000.00 $1,200,000.00
EQUIPO
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000,000 $40,000,000 $60,000,000 $80,000,000
$100,000,000 $120,000,000
PASIVOS TOTALES
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000,000 $40,000,000 $60,000,000 $80,000,000
$100,000,000 $120,000,000
PASIVOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000
INGRESOS TOTALES
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$5,000,000.00 $10,000,000.00 $15,000,000.00 $20,000,000.00 $25,000,000.00 $30,000,000.00
GASTOS CONTRATAR Y DESPEDIR
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-20,000,000
$- $20,000,000 $40,000,000 $60,000,000
INGRESOS TOTALES GASTOS TOTALES UTILIDAD OPERATIVA NETA
Periodos
Monto en $
-
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-20,000,000
$- $20,000,000 $40,000,000 $60,000,000
INGRESOS TOTALES GASTOS TOTALES UTILIDAD OPERATIVA NETA
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-
$20,000.00 $40,000.00 $60,000.00 $80,000.00
$100,000.00 $120,000.00 $140,000.00 $160,000.00
DEPRECIACION
Periodos
Monto en $
P-11 P-12 P-13 P-14 P-15 P-16 P-17 P-18 P-19 P-20 $-40,000,000 $-35,000,000 $-30,000,000 $-25,000,000 $-20,000,000 $-15,000,000 $-10,000,000 $-5,000,000
$- UTILIDAD OPERATIVA NETA UTILIDAD NETA DE OTRAS FUENTES
Periodos
Monto en $
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-
$5,000.00
$10,000.00
$15,000.00
$20,000.00
$25,000.00
$- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00
COSTO DE CAMA ESTE AO PROMEDIO PONDERADO DE TARIFA CAMA
Periodos
Monto en $
-
P-11P-12P-13P-14P-15P-16P-17P-18P-19P-20 $-
$5,000.00
$10,000.00
$15,000.00
$20,000.00
$25,000.00
$- $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00
COSTO DE CAMA ESTE AO PROMEDIO PONDERADO DE TARIFA CAMA
Periodos
Monto en $
HOJA DE DESICIONESPROYECCIN DE DEMANDAPROYECCIONES DEMOGRAFICASESTADOS FINANCIEROSGRAFICOS DESARROLLADOS