Pyg 2019.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Pyg 2019.xlsx as PDF for free.
More details
- Words: 2,564
- Pages: 12
0 CODIGO
510506 510515 510516 510517 510518 510524 510527
020301 September de 2019 MANTENIMIENTO
%
PRESUPUE ST MES
INGRESO TOTAL HOTEL
264,665,666
Sueldos Horas Extras Recargos Nocturnos Dominicales y Festivos Comisiones Incapacidades Auxilio de Transporte TOTAL SALARIOS BASE
1,831,242 0 0 0 0 0 176,422 2,007,664
91.21% 0.00% 0.00% 0.00% 0.00% 0.00% 8.79% 100.00%
1,947,250 70,000 0 80,000 0 0 88,000 1,288,000
167,305 14,665
8.33% 0.73%
107,290 12,900
167,305 76,302 0 0 10,000 0 105,799 19,200 0 219,700 73,300 0 0 0 353,046 0 0 1,206,622 3,214,286
8.33% 4.17% 0.00% 0.00% 0.55% 0.00% 5.78% 1.05% 0.00% 12.00% 4.00% 0.00% 0.00% 0.00% 17.58% 0.00% 0.00% 60.10% 1.21%
107,290 53,700 0 130,000 125,000 0 97,290 11,823 0 135,900 45,300 0 0 300,000 662,013 97,290 0 1,885,796 3,173,796
0 0 0 0 0 0 0 21,961 44,192 0 61,651
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.02% 0.00% 0.02%
17,000 0 0 0 0 0 0 29,000 48,000 150,000 387,204
510530 Cesantías 510533 Intereses Sobre Cesantía 510536 Prima de Servicios 510539 Vacaciones 510545 Auxilios 510548 Bonificaciones 510551 Dotación y Suministro a Trabajadores 510560 Indemnizaciones Laborales 510563 Capacitación al Personal 510568 Aportes a Admin.Riesgo Profesionales 510569 Aportes E.P.S. 510570 Aportes Fondos de Pensiones 510572 Aportes Cajas de Compensación 510575 Aportes al I.C.B.F. 510578 Sena 51059501 Temporales 51059502 Casino y Restaurante 51059503 Fondo Mutuo de Inversion 51059595 Carga Social - Distribucion TOTAL CONEXOS TOTAL SALARIOS y CONEXOS 512025 512035 513505 513507 512095 513510 513515 513535 513581 51451001 51451002
EJECUTADO MES
Equipo de Computacion Alquiler de Equipos Contratos de Aseo Contratos de Fumigación Otros al quileres Temporales Asistencia Técnica Teléfonos Servicio de Internet Manto. y Reparaciones Manto. Pintura y Decoración
100.00% 304,000,000
51451003 51451004 51451005 51451006 51451007 51451008 51451009 51451501 51451502 51451503 51451504 51451505 51451506 51451507 51451508 51451509 51451510 51452001
Manto. Instalaciones Hidráulicas y Sa Manto. Chapas y Cerraduras Manto. Jardines Manto. Vidrios y Espejos Manto. Alfombras y Cortinas Manto. Bombillos Manto. Instalaciones Electricas Manto. Equipo Electromecánico Manto. Equipo Electrónico Manto. Equipo de Incendio Manto. Equipo de Seguridad Manto. Equipo de Lavandería Manto. Equipo de Cocina Manto. Ascensores Manto. Caldera Manto. Planta Eléctrica Manto. Motobombas Equipo de Oficina
51,259 45,000 0 0 0 123,529 0 0 0 0 0 0 75,837 0 0 0 0 0
0.02% 0.02% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00%
350,000 80,000 0 50,000 100,000 350,000 350,000 0 0 0 0 160,000 350,000 0 0 0 0 0
51452501 51452502 519535 51452503 51453501 51453502 51453503 515005 515010 515015 515095 519510 529530 519531 519532 519530 519545 519560 519561 51959501 51959505 51959504 529531 51959506 51959507 51959515
Manto. Equipo Telefónico y Conmutado Manto Equipo Radiotransmisores Combustibles y lubricantes Manto. Equipos de Computo Manto. Sistema de Televisión Manto. Muebles - Ebanistería y Tapic Manto. Suministros Instalaciones Eléctricas Arreglos Ornamentales Reparaciones Locativas Otras Adecuaciones Libros Suscripciones y Revistas Papelería y Útiles de Escritorio Formularios e Impresos Fotocopias Utiles de Papeleria y Fotocopias Taxis y Buses Casino y Restaurante Gerencias de Turno Suministro Aseo Cortesías Suministro al imentos y Bebidas Formularios e Impresos Decoración Activos de Operación Misceláneos TOTAL OTROS GASTOS
0 0 0 28,571 0 0 169,940 0 0 0 0 0 0 0 0 0 15,000 0 52,073 0 13,499 0 0 0 0 0 702,512
0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.27%
0 50,000 0 50,000 0 50,000 500,000 0 0 0 0 0 30,000 12,000 5,000 8,000 50,000 0 0 0 50,000 0 0 0 0 0 3,226,204
3,916,797
1.48%
6,400,000
TOTAL GASTOS
41 42 5105 5205
CIFRAS DE CONTROL Total Ingresos Operacionales Total Ingresos No Operacionale Total Sueldos y Gastos Conexos Total Sueldos y Gastos Conexos
61
Total Costo de Ventas
51 52
Total Gastos - Cta 51 Total Gastos - Cta 52
53
Total Gastos No Operacionales Total Utilidad
DIFERENCIAS Ingresos Operacionales Ingresos No Operacionales Costo de Ventas Total Gastos Operacionales Total Gastos No Operacionales Utilidad GASTOS PARA EL 2019 bombilleria general mto maquinaria pinturas y decoracion hidraulicos Cortineria y accesorios TOTAL SIN SUELDO
0 0 3,214,286 0
0 0 3,173,796 100,000
0
0
3,916,797 0
6,370,000 130,000
0
0
(3,916,797)
(6,500,000)
0 0 0 0 0
0 0 0 100,000 0
0
(100,000)
1800000 10000000 10000000 4000000 5000000 30800000
%
ACUMULADO 2019
%
ACUMULADO PPTO 2018
%
100.00%
2,749,696,318
100.00%
3,095,344,397
100.00%
81.52% 5.43% 0.00% 6.21% 0.00% 0.00% 6.83% 100.00%
14,010,578 110,379 39,397 40,756 0 52,083 1,464,303 15,717,496
89.14% 0.70% 0.25% 0.26% 0.00% 0.33% 9.32% 100.00%
15,720,530 630,000 0 720,000 0 0 1,408,000 18,478,530
85.07% 3.41% 0.00% 3.90% 0.00% 0.00% 7.62% 100.00%
8.33% 1.00%
1,381,463 91,978
8.79% 0.59%
1,543,509 185,337
8.35% 1.00%
8.33% 4.48% 0.00% 10.83% 10.42% 0.00% 9.27% 0.92% 0.00% 10.55% 3.52% 0.00% 0.00% 340.91% 51.40% 9.27% 0.00% 146.41% 0.82%
1,381,462 818,065 0 2,040,000 296,956 0 373,196 149,400 100 1,800,200 629,100 16,700 11,200 946,000 4,050,934 0 0 13,986,754 29,704,250
8.79% 5.74% 0.00% 14.31% 2.08% 0.00% 2.66% 1.05% 0.00% 12.63% 4.41% 0.12% 0.08% 64.60% 25.77% 0.00% 0.00% 88.99% 1.08%
1,543,509 721,286 0 1,170,000 1,125,000 0 875,610 177,324 0 2,038,390 679,461 0 0 600,000 3,546,062 875,610 0 15,081,098 33,559,628
8.35% 4.23% 0.00% 6.85% 6.59% 0.00% 5.57% 0.96% 0.00% 11.03% 3.68% 0.00% 0.00% 42.61% 19.19% 5.57% 0.00% 81.61% 1.08%
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.01% 0.04% 0.10%
0 0 0 582,343 0 0 0 214,033 396,260 0 936,567
0.00% 0.00% 0.00% 0.02% 0.00% 0.00% 0.00% 0.01% 0.01% 0.00% 0.03%
153,000 0 0 770,000 0 0 0 259,000 432,000 900,000 1,437,204
0.00% #DIV/0! 0.00% 0.02% 0.00% 0.00% 0.00% 0.01% 0.01% 0.03% 0.05%
PROMEDIO 2019 9 305,521,813 0 1,556,731 12,264 4,377 4,528 0 5,787 162,700 1,746,388 0 153,496 10,220 153,496 90,896 0 226,667 32,995 0 41,466 16,600 11 200,022 69,900 1,856 1,244 105,111 450,104 0 0 1,554,084 3,300,472 0 0 0 0 64,705 0 0 0 23,781 44,029 0 104,063
0.09% 0.02% 0.00% 0.01% 0.03% 0.09% 0.09% 0.00% 0.00% 0.00% 0.00% 0.04% 0.09% 0.00% 0.00% 0.00% 0.00% 0.00%
627,143 220,716 0 590,000 27,226 1,007,977 298,992 0 0 78,000 0 0 1,525,122 0 0 0 0 0
0.02% 0.01% 0.00% 0.02% 0.00% 0.04% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00%
1,380,000 760,000 0 350,000 470,000 1,300,000 1,230,000 117,000 0 0 0 1,080,000 2,320,000 0 0 0 0 0
0.04% 0.02% 0.00% 0.01% 0.02% 0.04% 0.04% 0.00% 0.00% 0.00% 0.00% 0.03% 0.07% 0.00% 0.00% 0.00% 0.00% 0.00%
69,683 24,524 0 65,556 3,025 111,997 33,221 0 0 8,667 0 0 169,458 0 0 0 0 0
0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.83%
0 0 0 73,571 0 0 1,319,534 0 0 0 0 0 0 0 0 124,590 96,350 0 104,988 0 24,993 0 0 0 0 0 8,248,404
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.30%
0 450,000 0 400,000 0 450,000 2,630,000 0 0 0 0 0 30,000 94,000 45,000 48,000 155,000 0 190,000 0 130,900 0 0 0 0 0 17,581,104
0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.57%
0 0 0 8,175 0 0 146,615 0 0 0 0 0 0 0 0 13,843 10,706 0 11,665 0 2,777 0 0 0 0 0 916,489 0
1.65%
37,952,654
1.38%
51,140,732
1.65%
4,216,962
0 0 29,704,250 0
0
0 0 33,559,628 100,000 51,240,732 0 51,240,732 51,110,732 130,000 51,240,732 0
(37,952,654)
(51,240,732)
0 0 0 0 0
0 0 0 100,000 0
0 0 0
0
(100,000)
0
0 37,952,654 0
0 0 0 0 0
0
CODIGO
510506 510515 510516 510517 510518 510524 510527
510575 51059501 51059502 51059503 51059595
512025 512035 513505 513507 512095 513510
020301
Sep / 2018 MANTENIMIENTO
EJECUTADO MES
%
PRESUPUEST MES
%
INGRESO TOTAL HOTEL
264,665,666
100.00%
387,898,000
100.00%
Sueldos Horas Extras Recargos Nocturnos Dominicales y Festivos Comisiones Incapacidades Auxilio de Transporte TOTAL SALARIOS BASE
1,831,242 0 0 0 0 0 176,422 2,007,664
91.21% 0.00% 0.00% 0.00% 0.00% 0.00% 8.79% 100.00%
1,050,000 70,000 0 80,000 0 0 88,000 1,288,000
81.52% 5.43% 0.00% 6.21% 0.00% 0.00% 6.83% 100.00%
167,305 14,665 167,305 76,302 0 0 10,000 0 105,799 19,200 0 219,700 73,300 0 0 0 353,046 0 0 1,206,622 3,214,286
8.33% 0.73% 8.33% 4.17% 0.00% 0.00% 0.55% 0.00% 5.78% 1.05% 0.00% 12.00% 4.00% 0.00% 0.00% 0.00% 17.58% 0.00% 0.00% 60.10% 1.21%
107,290 12,900 107,290 53,700 0 130,000 125,000 0 97,290 11,823 0 135,900 45,300 0 0 300,000 662,013 97,290 0 1,885,796 3,173,796
8.33% 1.00% 8.33% 4.48% 0.00% 10.83% 10.42% 0.00% 9.27% 0.92% 0.00% 10.55% 3.52% 0.00% 0.00% 340.91% 51.40% 9.27% 0.00% 146.41% 0.82%
0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
17,000 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
510530 Cesantías 510533 Intereses Sobre Cesantía 510536 Prima de Servicios 510539 Vacaciones 510545 Auxilios 510548 Bonificaciones 510551 Dotación y Suministro a Trab 510560 Indemnizaciones Laborales 510563 Capacitación al Personal 510568 Aportes a Admin.Riesgo Profe 510569 Aportes E.P.S. 510570 Aportes Fondos de Pensiones 510572 Aportes Cajas de Compensació Aportes al I.C.B.F. 510578 Sena Temporales Casino y Restaurante Fondo Mutuo de Inversion Carga Social - Distribucion TOTAL CONEXOS TOTAL SALARIOS y CON Equipo de Computacion Alquiler de Equipos Contratos de Aseo Contratos de Fumigación Otros al quileres Temporales
513515 513535 513581 51451001 51451002 51451003 51451004 51451005 51451006 51451007 51451008 51451009 51451501 51451502 51451503
Asistencia Técnica Teléfonos Servicio de Internet Manto. y Reparaciones Manto. Pintura y Decoración Manto. Instalaciones Hidrául Manto. Chapas y Cerraduras Manto. Jardines Manto. Vidrios y Espejos Manto. Alfombras y Cortinas Manto. Bombillos Manto. Instalaciones Electri Manto. Equipo Electromecánico Manto. Equipo Electrónico Manto. Equipo de Incendio
0 21,961 44,192 0 61,651 51,259 45,000 0 0 0 123,529 0 0 0 0
0.00% 0.01% 0.02% 0.00% 0.02% 0.02% 0.02% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00%
0 29,000 48,000 150,000 387,204 350,000 80,000 0 50,000 100,000 350,000 350,000 0 0 0
0.00% 0.01% 0.01% 0.04% 0.10% 0.09% 0.02% 0.00% 0.01% 0.03% 0.09% 0.09% 0.00% 0.00% 0.00%
51451504 51451505 51451506 51451507 51451508 51451509 51451510 51452001 51452501 51452502 519535 51452503 51453501 51453502 51453503 515005 515010 515015 515095 519510 529530 519531 519532 519530 519545 519560 519561 51959501 51959505 51959504
Manto. Equipo de Seguridad Manto. Equipo de Lavandería Manto. Equipo de Cocina Manto. Ascensores Manto. Caldera Manto. Planta Eléctrica Manto. Motobombas Equipo de Oficina Manto. Equipo Telefónico y Manto Equipo Radiotransmi Combustibles y lubricantes Manto. Equipos de Computo Manto. Sistema de Televisión Manto. Muebles - Ebanistería Manto. Suministros Instalaciones Eléctricas Arreglos Ornamentales Reparaciones Locativas Otras Adecuaciones Libros Suscripciones y Revi Papelería y Útiles de Escritori Formularios e Impresos Fotocopias Utiles de Papeleria y Fotoco Taxis y Buses Casino y Restaurante Gerencias de Turno Suministro Aseo Cortesías Suministro al imentos y Bebida
0 0 75,837 0 0 0 0 0 0 0 0 28,571 0 0 169,940 0 0 0 0 0 0 0 0 0 15,000 0 52,073 0 13,499 0
0.00% 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00%
0 160,000 350,000 0 0 0 0 0 0 50,000 0 50,000 0 50,000 500,000 0 0 0 0 0 30,000 12,000 5,000 8,000 50,000 0 0 0 50,000 0
0.00% 0.04% 0.09% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00%
529531 51959506 51959507 51959515
41 42 5105 5205
Formularios e Impresos Decoración Activos de Operación Misceláneos TOTAL OTROS GASTOS
0 0 0 0 702,512
0.00% 0.00% 0.00% 0.00% 0.27%
0 0 0 0 3,226,204
0.00% 0.00% 0.00% 0.00% 0.83%
TOTAL GASTOS
3,916,797
1.48%
6,400,000
1.65%
CIFRAS DE CONTROL Total Ingresos Operaci Total Ingresos No Ope Total Sueldos y Gastos Total Sueldos y Gastos
0 0 3,214,286 0
0 0 3,173,796 100,000
0
0
3,916,797 0
6,370,000 130,000
0
0
(3,916,797)
(6,500,000)
0 0 0 0 0 0
0 0 0 100,000 0 (100,000)
61
Total Costo de Ventas
51 52
Total Gastos - Cta 51 Total Gastos - Cta 52
53
Total Gastos No Operaci Total Utilidad
DIFERENCIAS Ingresos Operacionale Ingresos No Operacio Costo de Ventas Total Gastos Operacio Total Gastos No Opera Utilidad
ACUMULADO 2018
%
ACUMULADO PPTO 2018
%
2,749,696,318
100.00%
3,095,344,397
100.00%
14,010,578 110,379 39,397 40,756 0 52,083 1,464,303 15,717,496
89.14% 0.70% 0.25% 0.26% 0.00% 0.33% 9.32% 100.00%
15,720,530 630,000 0 720,000 0 0 1,408,000 18,478,530
85.07% 3.41% 0.00% 3.90% 0.00% 0.00% 7.62% 100.00%
1,381,463 91,978 1,381,462 818,065 0 2,040,000 296,956 0 373,196 149,400 100 1,800,200 629,100 16,700 11,200 946,000 4,050,934 0 0 13,986,754 29,704,250
8.79% 0.59% 8.79% 5.74% 0.00% 14.31% 2.08% 0.00% 2.66% 1.05% 0.00% 12.63% 4.41% 0.12% 0.08% 64.60% 25.77% 0.00% 0.00% 88.99% 1.08%
1,543,509 185,337 1,543,509 721,286 0 1,170,000 1,125,000 0 875,610 177,324 0 2,038,390 679,461 0 0 600,000 3,546,062 875,610 0 15,081,098 33,559,628
8.35% 1.00% 8.35% 4.23% 0.00% 6.85% 6.59% 0.00% 5.57% 0.96% 0.00% 11.03% 3.68% 0.00% 0.00% 42.61% 19.19% 5.57% 0.00% 81.61% 1.08%
0 0 0 582,343 0 0
0.00% 0.00% 0.00% 0.02% 0.00% 0.00%
153,000 0 0 770,000 0 0
0.00% #DIV/0! 0.00% 0.02% 0.00% 0.00%
PROMEDIO 2018
9 305,521,813 0 1,556,731 12,264 4,377 4,528 0 5,787 162,700 1,746,388 0 153,496 10,220 153,496 90,896 0 226,667 32,995 0 41,466 16,600 11 200,022 69,900 1,856 1,244 105,111 450,104 0 0 1,554,084 3,300,472 0 0 0 0 64,705 0 0
0 214,033 396,260 0 936,567 627,143 220,716 0 590,000 27,226 1,007,977 298,992 0 0 78,000
0.00% 0.01% 0.01% 0.00% 0.03% 0.02% 0.01% 0.00% 0.02% 0.00% 0.04% 0.01% 0.00% 0.00% 0.00%
0 259,000 432,000 900,000 1,437,204 1,380,000 760,000 0 350,000 470,000 1,300,000 1,230,000 117,000 0 0
0.00% 0.01% 0.01% 0.03% 0.05% 0.04% 0.02% 0.00% 0.01% 0.02% 0.04% 0.04% 0.00% 0.00% 0.00%
0 23,781 44,029 0 104,063 69,683 24,524 0 65,556 3,025 111,997 33,221 0 0 8,667
0 0 1,525,122 0 0 0 0 0 0 0 0 73,571 0 0 1,319,534 0 0 0 0 0 0 0 0 124,590 96,350 0 104,988 0 24,993 0
0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00%
0 1,080,000 2,320,000 0 0 0 0 0 0 450,000 0 400,000 0 450,000 2,630,000 0 0 0 0 0 30,000 94,000 45,000 48,000 155,000 0 190,000 0 130,900 0
0.00% 0.03% 0.07% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.00% 0.00%
0 0 169,458 0 0 0 0 0 0 0 0 8,175 0 0 146,615 0 0 0 0 0 0 0 0 13,843 10,706 0 11,665 0 2,777 0
0 0 0 0 8,248,404
0.00% 0.00% 0.00% 0.00% 0.30%
0 0 0 0 17,581,104
0.00% 0.00% 0.00% 0.00% 0.57%
0 0 0 0 916,489 0
37,952,654
1.38%
51,140,732
1.65%
4,216,962
0 0 29,704,250 0
0 0 33,559,628 100,000 51,240,732
0
0
0 51,240,732 51,110,732 130,000 51,240,732 0
(37,952,654)
(51,240,732)
0 0 0 0 0 0
0 0 0 100,000 0 (100,000)
37,952,654 0
0 0 0 0 0 0 0 0 0
510506 510515 510516 510517 510518 510524 510527
020301 September de 2019 MANTENIMIENTO
%
PRESUPUE ST MES
INGRESO TOTAL HOTEL
264,665,666
Sueldos Horas Extras Recargos Nocturnos Dominicales y Festivos Comisiones Incapacidades Auxilio de Transporte TOTAL SALARIOS BASE
1,831,242 0 0 0 0 0 176,422 2,007,664
91.21% 0.00% 0.00% 0.00% 0.00% 0.00% 8.79% 100.00%
1,947,250 70,000 0 80,000 0 0 88,000 1,288,000
167,305 14,665
8.33% 0.73%
107,290 12,900
167,305 76,302 0 0 10,000 0 105,799 19,200 0 219,700 73,300 0 0 0 353,046 0 0 1,206,622 3,214,286
8.33% 4.17% 0.00% 0.00% 0.55% 0.00% 5.78% 1.05% 0.00% 12.00% 4.00% 0.00% 0.00% 0.00% 17.58% 0.00% 0.00% 60.10% 1.21%
107,290 53,700 0 130,000 125,000 0 97,290 11,823 0 135,900 45,300 0 0 300,000 662,013 97,290 0 1,885,796 3,173,796
0 0 0 0 0 0 0 21,961 44,192 0 61,651
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.02% 0.00% 0.02%
17,000 0 0 0 0 0 0 29,000 48,000 150,000 387,204
510530 Cesantías 510533 Intereses Sobre Cesantía 510536 Prima de Servicios 510539 Vacaciones 510545 Auxilios 510548 Bonificaciones 510551 Dotación y Suministro a Trabajadores 510560 Indemnizaciones Laborales 510563 Capacitación al Personal 510568 Aportes a Admin.Riesgo Profesionales 510569 Aportes E.P.S. 510570 Aportes Fondos de Pensiones 510572 Aportes Cajas de Compensación 510575 Aportes al I.C.B.F. 510578 Sena 51059501 Temporales 51059502 Casino y Restaurante 51059503 Fondo Mutuo de Inversion 51059595 Carga Social - Distribucion TOTAL CONEXOS TOTAL SALARIOS y CONEXOS 512025 512035 513505 513507 512095 513510 513515 513535 513581 51451001 51451002
EJECUTADO MES
Equipo de Computacion Alquiler de Equipos Contratos de Aseo Contratos de Fumigación Otros al quileres Temporales Asistencia Técnica Teléfonos Servicio de Internet Manto. y Reparaciones Manto. Pintura y Decoración
100.00% 304,000,000
51451003 51451004 51451005 51451006 51451007 51451008 51451009 51451501 51451502 51451503 51451504 51451505 51451506 51451507 51451508 51451509 51451510 51452001
Manto. Instalaciones Hidráulicas y Sa Manto. Chapas y Cerraduras Manto. Jardines Manto. Vidrios y Espejos Manto. Alfombras y Cortinas Manto. Bombillos Manto. Instalaciones Electricas Manto. Equipo Electromecánico Manto. Equipo Electrónico Manto. Equipo de Incendio Manto. Equipo de Seguridad Manto. Equipo de Lavandería Manto. Equipo de Cocina Manto. Ascensores Manto. Caldera Manto. Planta Eléctrica Manto. Motobombas Equipo de Oficina
51,259 45,000 0 0 0 123,529 0 0 0 0 0 0 75,837 0 0 0 0 0
0.02% 0.02% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00%
350,000 80,000 0 50,000 100,000 350,000 350,000 0 0 0 0 160,000 350,000 0 0 0 0 0
51452501 51452502 519535 51452503 51453501 51453502 51453503 515005 515010 515015 515095 519510 529530 519531 519532 519530 519545 519560 519561 51959501 51959505 51959504 529531 51959506 51959507 51959515
Manto. Equipo Telefónico y Conmutado Manto Equipo Radiotransmisores Combustibles y lubricantes Manto. Equipos de Computo Manto. Sistema de Televisión Manto. Muebles - Ebanistería y Tapic Manto. Suministros Instalaciones Eléctricas Arreglos Ornamentales Reparaciones Locativas Otras Adecuaciones Libros Suscripciones y Revistas Papelería y Útiles de Escritorio Formularios e Impresos Fotocopias Utiles de Papeleria y Fotocopias Taxis y Buses Casino y Restaurante Gerencias de Turno Suministro Aseo Cortesías Suministro al imentos y Bebidas Formularios e Impresos Decoración Activos de Operación Misceláneos TOTAL OTROS GASTOS
0 0 0 28,571 0 0 169,940 0 0 0 0 0 0 0 0 0 15,000 0 52,073 0 13,499 0 0 0 0 0 702,512
0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.27%
0 50,000 0 50,000 0 50,000 500,000 0 0 0 0 0 30,000 12,000 5,000 8,000 50,000 0 0 0 50,000 0 0 0 0 0 3,226,204
3,916,797
1.48%
6,400,000
TOTAL GASTOS
41 42 5105 5205
CIFRAS DE CONTROL Total Ingresos Operacionales Total Ingresos No Operacionale Total Sueldos y Gastos Conexos Total Sueldos y Gastos Conexos
61
Total Costo de Ventas
51 52
Total Gastos - Cta 51 Total Gastos - Cta 52
53
Total Gastos No Operacionales Total Utilidad
DIFERENCIAS Ingresos Operacionales Ingresos No Operacionales Costo de Ventas Total Gastos Operacionales Total Gastos No Operacionales Utilidad GASTOS PARA EL 2019 bombilleria general mto maquinaria pinturas y decoracion hidraulicos Cortineria y accesorios TOTAL SIN SUELDO
0 0 3,214,286 0
0 0 3,173,796 100,000
0
0
3,916,797 0
6,370,000 130,000
0
0
(3,916,797)
(6,500,000)
0 0 0 0 0
0 0 0 100,000 0
0
(100,000)
1800000 10000000 10000000 4000000 5000000 30800000
%
ACUMULADO 2019
%
ACUMULADO PPTO 2018
%
100.00%
2,749,696,318
100.00%
3,095,344,397
100.00%
81.52% 5.43% 0.00% 6.21% 0.00% 0.00% 6.83% 100.00%
14,010,578 110,379 39,397 40,756 0 52,083 1,464,303 15,717,496
89.14% 0.70% 0.25% 0.26% 0.00% 0.33% 9.32% 100.00%
15,720,530 630,000 0 720,000 0 0 1,408,000 18,478,530
85.07% 3.41% 0.00% 3.90% 0.00% 0.00% 7.62% 100.00%
8.33% 1.00%
1,381,463 91,978
8.79% 0.59%
1,543,509 185,337
8.35% 1.00%
8.33% 4.48% 0.00% 10.83% 10.42% 0.00% 9.27% 0.92% 0.00% 10.55% 3.52% 0.00% 0.00% 340.91% 51.40% 9.27% 0.00% 146.41% 0.82%
1,381,462 818,065 0 2,040,000 296,956 0 373,196 149,400 100 1,800,200 629,100 16,700 11,200 946,000 4,050,934 0 0 13,986,754 29,704,250
8.79% 5.74% 0.00% 14.31% 2.08% 0.00% 2.66% 1.05% 0.00% 12.63% 4.41% 0.12% 0.08% 64.60% 25.77% 0.00% 0.00% 88.99% 1.08%
1,543,509 721,286 0 1,170,000 1,125,000 0 875,610 177,324 0 2,038,390 679,461 0 0 600,000 3,546,062 875,610 0 15,081,098 33,559,628
8.35% 4.23% 0.00% 6.85% 6.59% 0.00% 5.57% 0.96% 0.00% 11.03% 3.68% 0.00% 0.00% 42.61% 19.19% 5.57% 0.00% 81.61% 1.08%
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.01% 0.04% 0.10%
0 0 0 582,343 0 0 0 214,033 396,260 0 936,567
0.00% 0.00% 0.00% 0.02% 0.00% 0.00% 0.00% 0.01% 0.01% 0.00% 0.03%
153,000 0 0 770,000 0 0 0 259,000 432,000 900,000 1,437,204
0.00% #DIV/0! 0.00% 0.02% 0.00% 0.00% 0.00% 0.01% 0.01% 0.03% 0.05%
PROMEDIO 2019 9 305,521,813 0 1,556,731 12,264 4,377 4,528 0 5,787 162,700 1,746,388 0 153,496 10,220 153,496 90,896 0 226,667 32,995 0 41,466 16,600 11 200,022 69,900 1,856 1,244 105,111 450,104 0 0 1,554,084 3,300,472 0 0 0 0 64,705 0 0 0 23,781 44,029 0 104,063
0.09% 0.02% 0.00% 0.01% 0.03% 0.09% 0.09% 0.00% 0.00% 0.00% 0.00% 0.04% 0.09% 0.00% 0.00% 0.00% 0.00% 0.00%
627,143 220,716 0 590,000 27,226 1,007,977 298,992 0 0 78,000 0 0 1,525,122 0 0 0 0 0
0.02% 0.01% 0.00% 0.02% 0.00% 0.04% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00%
1,380,000 760,000 0 350,000 470,000 1,300,000 1,230,000 117,000 0 0 0 1,080,000 2,320,000 0 0 0 0 0
0.04% 0.02% 0.00% 0.01% 0.02% 0.04% 0.04% 0.00% 0.00% 0.00% 0.00% 0.03% 0.07% 0.00% 0.00% 0.00% 0.00% 0.00%
69,683 24,524 0 65,556 3,025 111,997 33,221 0 0 8,667 0 0 169,458 0 0 0 0 0
0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00% 0.00% 0.00% 0.00% 0.00% 0.83%
0 0 0 73,571 0 0 1,319,534 0 0 0 0 0 0 0 0 124,590 96,350 0 104,988 0 24,993 0 0 0 0 0 8,248,404
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.30%
0 450,000 0 400,000 0 450,000 2,630,000 0 0 0 0 0 30,000 94,000 45,000 48,000 155,000 0 190,000 0 130,900 0 0 0 0 0 17,581,104
0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.57%
0 0 0 8,175 0 0 146,615 0 0 0 0 0 0 0 0 13,843 10,706 0 11,665 0 2,777 0 0 0 0 0 916,489 0
1.65%
37,952,654
1.38%
51,140,732
1.65%
4,216,962
0 0 29,704,250 0
0
0 0 33,559,628 100,000 51,240,732 0 51,240,732 51,110,732 130,000 51,240,732 0
(37,952,654)
(51,240,732)
0 0 0 0 0
0 0 0 100,000 0
0 0 0
0
(100,000)
0
0 37,952,654 0
0 0 0 0 0
0
CODIGO
510506 510515 510516 510517 510518 510524 510527
510575 51059501 51059502 51059503 51059595
512025 512035 513505 513507 512095 513510
020301
Sep / 2018 MANTENIMIENTO
EJECUTADO MES
%
PRESUPUEST MES
%
INGRESO TOTAL HOTEL
264,665,666
100.00%
387,898,000
100.00%
Sueldos Horas Extras Recargos Nocturnos Dominicales y Festivos Comisiones Incapacidades Auxilio de Transporte TOTAL SALARIOS BASE
1,831,242 0 0 0 0 0 176,422 2,007,664
91.21% 0.00% 0.00% 0.00% 0.00% 0.00% 8.79% 100.00%
1,050,000 70,000 0 80,000 0 0 88,000 1,288,000
81.52% 5.43% 0.00% 6.21% 0.00% 0.00% 6.83% 100.00%
167,305 14,665 167,305 76,302 0 0 10,000 0 105,799 19,200 0 219,700 73,300 0 0 0 353,046 0 0 1,206,622 3,214,286
8.33% 0.73% 8.33% 4.17% 0.00% 0.00% 0.55% 0.00% 5.78% 1.05% 0.00% 12.00% 4.00% 0.00% 0.00% 0.00% 17.58% 0.00% 0.00% 60.10% 1.21%
107,290 12,900 107,290 53,700 0 130,000 125,000 0 97,290 11,823 0 135,900 45,300 0 0 300,000 662,013 97,290 0 1,885,796 3,173,796
8.33% 1.00% 8.33% 4.48% 0.00% 10.83% 10.42% 0.00% 9.27% 0.92% 0.00% 10.55% 3.52% 0.00% 0.00% 340.91% 51.40% 9.27% 0.00% 146.41% 0.82%
0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
17,000 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
510530 Cesantías 510533 Intereses Sobre Cesantía 510536 Prima de Servicios 510539 Vacaciones 510545 Auxilios 510548 Bonificaciones 510551 Dotación y Suministro a Trab 510560 Indemnizaciones Laborales 510563 Capacitación al Personal 510568 Aportes a Admin.Riesgo Profe 510569 Aportes E.P.S. 510570 Aportes Fondos de Pensiones 510572 Aportes Cajas de Compensació Aportes al I.C.B.F. 510578 Sena Temporales Casino y Restaurante Fondo Mutuo de Inversion Carga Social - Distribucion TOTAL CONEXOS TOTAL SALARIOS y CON Equipo de Computacion Alquiler de Equipos Contratos de Aseo Contratos de Fumigación Otros al quileres Temporales
513515 513535 513581 51451001 51451002 51451003 51451004 51451005 51451006 51451007 51451008 51451009 51451501 51451502 51451503
Asistencia Técnica Teléfonos Servicio de Internet Manto. y Reparaciones Manto. Pintura y Decoración Manto. Instalaciones Hidrául Manto. Chapas y Cerraduras Manto. Jardines Manto. Vidrios y Espejos Manto. Alfombras y Cortinas Manto. Bombillos Manto. Instalaciones Electri Manto. Equipo Electromecánico Manto. Equipo Electrónico Manto. Equipo de Incendio
0 21,961 44,192 0 61,651 51,259 45,000 0 0 0 123,529 0 0 0 0
0.00% 0.01% 0.02% 0.00% 0.02% 0.02% 0.02% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00%
0 29,000 48,000 150,000 387,204 350,000 80,000 0 50,000 100,000 350,000 350,000 0 0 0
0.00% 0.01% 0.01% 0.04% 0.10% 0.09% 0.02% 0.00% 0.01% 0.03% 0.09% 0.09% 0.00% 0.00% 0.00%
51451504 51451505 51451506 51451507 51451508 51451509 51451510 51452001 51452501 51452502 519535 51452503 51453501 51453502 51453503 515005 515010 515015 515095 519510 529530 519531 519532 519530 519545 519560 519561 51959501 51959505 51959504
Manto. Equipo de Seguridad Manto. Equipo de Lavandería Manto. Equipo de Cocina Manto. Ascensores Manto. Caldera Manto. Planta Eléctrica Manto. Motobombas Equipo de Oficina Manto. Equipo Telefónico y Manto Equipo Radiotransmi Combustibles y lubricantes Manto. Equipos de Computo Manto. Sistema de Televisión Manto. Muebles - Ebanistería Manto. Suministros Instalaciones Eléctricas Arreglos Ornamentales Reparaciones Locativas Otras Adecuaciones Libros Suscripciones y Revi Papelería y Útiles de Escritori Formularios e Impresos Fotocopias Utiles de Papeleria y Fotoco Taxis y Buses Casino y Restaurante Gerencias de Turno Suministro Aseo Cortesías Suministro al imentos y Bebida
0 0 75,837 0 0 0 0 0 0 0 0 28,571 0 0 169,940 0 0 0 0 0 0 0 0 0 15,000 0 52,073 0 13,499 0
0.00% 0.00% 0.03% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00%
0 160,000 350,000 0 0 0 0 0 0 50,000 0 50,000 0 50,000 500,000 0 0 0 0 0 30,000 12,000 5,000 8,000 50,000 0 0 0 50,000 0
0.00% 0.04% 0.09% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.01% 0.00%
529531 51959506 51959507 51959515
41 42 5105 5205
Formularios e Impresos Decoración Activos de Operación Misceláneos TOTAL OTROS GASTOS
0 0 0 0 702,512
0.00% 0.00% 0.00% 0.00% 0.27%
0 0 0 0 3,226,204
0.00% 0.00% 0.00% 0.00% 0.83%
TOTAL GASTOS
3,916,797
1.48%
6,400,000
1.65%
CIFRAS DE CONTROL Total Ingresos Operaci Total Ingresos No Ope Total Sueldos y Gastos Total Sueldos y Gastos
0 0 3,214,286 0
0 0 3,173,796 100,000
0
0
3,916,797 0
6,370,000 130,000
0
0
(3,916,797)
(6,500,000)
0 0 0 0 0 0
0 0 0 100,000 0 (100,000)
61
Total Costo de Ventas
51 52
Total Gastos - Cta 51 Total Gastos - Cta 52
53
Total Gastos No Operaci Total Utilidad
DIFERENCIAS Ingresos Operacionale Ingresos No Operacio Costo de Ventas Total Gastos Operacio Total Gastos No Opera Utilidad
ACUMULADO 2018
%
ACUMULADO PPTO 2018
%
2,749,696,318
100.00%
3,095,344,397
100.00%
14,010,578 110,379 39,397 40,756 0 52,083 1,464,303 15,717,496
89.14% 0.70% 0.25% 0.26% 0.00% 0.33% 9.32% 100.00%
15,720,530 630,000 0 720,000 0 0 1,408,000 18,478,530
85.07% 3.41% 0.00% 3.90% 0.00% 0.00% 7.62% 100.00%
1,381,463 91,978 1,381,462 818,065 0 2,040,000 296,956 0 373,196 149,400 100 1,800,200 629,100 16,700 11,200 946,000 4,050,934 0 0 13,986,754 29,704,250
8.79% 0.59% 8.79% 5.74% 0.00% 14.31% 2.08% 0.00% 2.66% 1.05% 0.00% 12.63% 4.41% 0.12% 0.08% 64.60% 25.77% 0.00% 0.00% 88.99% 1.08%
1,543,509 185,337 1,543,509 721,286 0 1,170,000 1,125,000 0 875,610 177,324 0 2,038,390 679,461 0 0 600,000 3,546,062 875,610 0 15,081,098 33,559,628
8.35% 1.00% 8.35% 4.23% 0.00% 6.85% 6.59% 0.00% 5.57% 0.96% 0.00% 11.03% 3.68% 0.00% 0.00% 42.61% 19.19% 5.57% 0.00% 81.61% 1.08%
0 0 0 582,343 0 0
0.00% 0.00% 0.00% 0.02% 0.00% 0.00%
153,000 0 0 770,000 0 0
0.00% #DIV/0! 0.00% 0.02% 0.00% 0.00%
PROMEDIO 2018
9 305,521,813 0 1,556,731 12,264 4,377 4,528 0 5,787 162,700 1,746,388 0 153,496 10,220 153,496 90,896 0 226,667 32,995 0 41,466 16,600 11 200,022 69,900 1,856 1,244 105,111 450,104 0 0 1,554,084 3,300,472 0 0 0 0 64,705 0 0
0 214,033 396,260 0 936,567 627,143 220,716 0 590,000 27,226 1,007,977 298,992 0 0 78,000
0.00% 0.01% 0.01% 0.00% 0.03% 0.02% 0.01% 0.00% 0.02% 0.00% 0.04% 0.01% 0.00% 0.00% 0.00%
0 259,000 432,000 900,000 1,437,204 1,380,000 760,000 0 350,000 470,000 1,300,000 1,230,000 117,000 0 0
0.00% 0.01% 0.01% 0.03% 0.05% 0.04% 0.02% 0.00% 0.01% 0.02% 0.04% 0.04% 0.00% 0.00% 0.00%
0 23,781 44,029 0 104,063 69,683 24,524 0 65,556 3,025 111,997 33,221 0 0 8,667
0 0 1,525,122 0 0 0 0 0 0 0 0 73,571 0 0 1,319,534 0 0 0 0 0 0 0 0 124,590 96,350 0 104,988 0 24,993 0
0.00% 0.00% 0.06% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.05% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% #DIV/0! 0.00% 0.00% 0.00%
0 1,080,000 2,320,000 0 0 0 0 0 0 450,000 0 400,000 0 450,000 2,630,000 0 0 0 0 0 30,000 94,000 45,000 48,000 155,000 0 190,000 0 130,900 0
0.00% 0.03% 0.07% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% 0.01% 0.00% 0.01% 0.08% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.01% 0.00% #DIV/0! 0.00% 0.00% 0.00%
0 0 169,458 0 0 0 0 0 0 0 0 8,175 0 0 146,615 0 0 0 0 0 0 0 0 13,843 10,706 0 11,665 0 2,777 0
0 0 0 0 8,248,404
0.00% 0.00% 0.00% 0.00% 0.30%
0 0 0 0 17,581,104
0.00% 0.00% 0.00% 0.00% 0.57%
0 0 0 0 916,489 0
37,952,654
1.38%
51,140,732
1.65%
4,216,962
0 0 29,704,250 0
0 0 33,559,628 100,000 51,240,732
0
0
0 51,240,732 51,110,732 130,000 51,240,732 0
(37,952,654)
(51,240,732)
0 0 0 0 0 0
0 0 0 100,000 0 (100,000)
37,952,654 0
0 0 0 0 0 0 0 0 0
Related Documents
Pyg 2019.xlsx
May 2020 28More Documents from "german"
Sim.docx
April 2020 23
Claves Gta.docx
June 2020 22
Pyg 2019.xlsx
May 2020 28
Persona Bajo La Lluvia
November 2019 45