PRESUPUESTO

31

description

presupuestos

Transcript of PRESUPUESTO

  • PRESUPUESTO

    DANNA GINNETH ABRIL HERNANDEZ PAULA ANDREA GONZALEZ PARRA LUIS FERNANDO MAJIN GALINDEZ

    FREDY OSTOS PARDO JAVIER ORLANDO RODRIGUEZ VALLEJO

    CAMILO ANDRES VEGA SIERRA

  • Cada producto Incluye sus conectores

    minimo en compras y ventas (Punto de Equilibrio) impuestos importacion Pagos Dian

    Producto / Servicio capacidad v/r Compra 50% de Utilidad v/r Venta v/r compras mes Utilidad Sin Importacion Estimado en ventas iva 16% descontable arancel 10% seguro 2% iva 16% Generado Dif. Iva a Pagar

    Pantallas lcd Hp 19" $ 94,000 $ 47,000 $ 141,000 $ 1,410,000 $ 705,000 $ 2,115,000 $ 225,600 $ 141,000 $ 28,200 $ 338,400 $ 112,800

    Pantallas lcd Hp 21" $ 150,000

    $ 75,000

    $ 225,000

    $ 2,250,000

    $ 1,125,000

    $ 3,375,000

    $ 360,000

    $ 225,000

    $ 45,000

    $ 540,000

    $ 180,000

    Pantallas lcd Dell 19" $ 121,000 $ 60,500 $ 181,500 $ 1,815,000 $ 907,500 $ 2,722,500 $ 290,400 $ 181,500 $ 36,300 $ 435,600 $ 145,200

    Pantallas lcd Dell 21" $ 158,000

    $ 79,000

    $ 237,000

    $ 2,370,000

    $ 1,185,000

    $ 3,555,000

    $ 379,200

    $ 237,000

    $ 47,400

    $ 568,800

    $ 189,600

    Pantallas lcd Lenovo 19" $ 102,000 $ 51,000 $ 153,000 $ 1,530,000 $ 765,000 $ 2,295,000 $ 244,800 $ 153,000 $ 30,600 $ 367,200 $ 122,400

    Pantallas lcd Lenovo 21" $ 149,000

    $ 74,500

    $ 223,500

    $ 2,235,000

    $ 1,117,500

    $ 3,352,500

    $ 357,600

    $ 223,500

    $ 44,700

    $ 536,400

    $ 178,800

    memoria ram de 2gb $ 25,000 $ 12,500 $ 37,500 $ 375,000 $ 187,500 $ 562,500 $ 60,000 $ - $ 7,500 $ 90,000 $ 30,000

    memoria ram de 4gb $ 65,000

    $ 32,500

    $ 97,500

    $ 975,000

    $ 487,500

    $ 1,462,500

    $ 156,000

    $ - $ 19,500

    $ 234,000

    $ 78,000

    memoria ram de 8gb $ 140,000 $ 70,000 $ 210,000 $ 2,100,000 $ 1,050,000 $ 3,150,000 $ 336,000 $ - $ 42,000 $ 504,000 $ 168,000

    Procesador Intel core i3 $ 320,000 $ 160,000 $ 480,000 $ 4,800,000 $ 2,400,000 $ 7,200,000 $ 768,000 $ - $ 96,000 $ 1,152,000 $ 384,000

    Procesador Intel core i5 $ 440,000

    $ 220,000

    $ 660,000

    $ 6,600,000

    $ 3,300,000

    $ 9,900,000

    $ 1,056,000

    $ - $ 132,000

    $ 1,584,000

    $ 528,000

    Procesador Intel core i7 $ 600,000 $ 300,000 $ 900,000 $ 9,000,000 $ 4,500,000 $ 13,500,000 $ 1,440,000 $ - $ 180,000 $ 2,160,000 $ 720,000

    Procesador Amd fx 8350 $ 330,000

    $ 165,000

    $ 495,000

    $ 4,950,000

    $ 2,475,000

    $ 7,425,000

    $ 792,000

    $ - $ 99,000

    $ 1,188,000

    $ 396,000

    Board Astroc G41c $ 135,000 $ 67,500 $ 202,500 $ 2,025,000 $ 1,012,500 $ 3,037,500 $ 324,000 $ - $ 40,500 $ 486,000 $ 162,000

    Board Intel 1150 $ 170,000

    $ 85,000

    $ 255,000

    $ 2,550,000

    $ 1,275,000

    $ 3,825,000

    $ 408,000

    $ - $ 51,000

    $ 612,000

    $ 204,000

    Board Asus M5a97 $ 180,000 $ 90,000 $ 270,000 $ 2,700,000 $ 1,350,000 $ 4,050,000 $ 432,000 $ - $ 54,000 $ 648,000 $ 216,000

    Board Asus Amd $ 148,000

    $ 74,000

    $ 222,000

    $ 2,220,000

    $ 1,110,000

    $ 3,330,000

    $ 355,200

    $ - $ 44,400

    $ 532,800

    $ 177,600

    Fuente de Poder Cooler Master Gx li 550w $ 153,000 $ 76,500 $ 229,500 $ 2,295,000 $ 1,147,500 $ 3,442,500 $ 367,200 $ - $ 45,900 $ 550,800 $ 183,600

    Fuente de Poder Corsair Cs 750m-80 $ 149,000 $ 74,500 $ 223,500 $ 2,235,000 $ 1,117,500 $ 3,352,500 $ 357,600 $ - $ 44,700 $ 536,400 $ 178,800

    Disco Duro 1 tera dell, lenovo, toshiba $ 105,000

    $ 52,500

    $ 157,500

    $ 1,575,000

    $ 787,500

    $ 2,362,500

    $ 252,000

    $ - $ 31,500

    $ 378,000

    $ 126,000

    Disco Duro 2 teras dell, lenovo, toshiba $ 160,000 $ 80,000 $ 240,000 $ 2,400,000 $ 1,200,000 $ 3,600,000 $ 384,000 $ - $ 48,000 $ 576,000 $ 192,000

    Disco Duro 3 teras dell, lenovo, toshiba $ 240,000

    $ 120,000

    $ 360,000

    $ 3,600,000

    $ 1,800,000

    $ 5,400,000

    $ 576,000

    $ - $ 72,000

    $ 864,000

    $ 288,000

    Disco Duro 4 teras dell, lenovo, toshiba $ 306,000 $ 153,000 $ 459,000 $ 4,590,000 $ 2,295,000 $ 6,885,000 $ 734,400 $ - $ 91,800 $ 1,101,600 $ 367,200

    Compu Portatil DELL Inspiron 15-5548 core I7 $ 1,750,000

    $ 875,000

    $ 2,625,000

    $ 26,250,000

    $ 13,125,000

    $ 39,375,000

    $ - $ - $ 525,000

    $ 6,300,000

    $ 6,300,000

    Compu Portatil DELL Inspiron 15 Tactil $ 940,000 $ 470,000 $ 1,410,000 $ 14,100,000 $ 7,050,000 $ 21,150,000 $ - $ - $ 282,000 $ 3,384,000 $ 3,384,000

    Compu Portatil DELL Ultrabook Core I7 $ 980,000

    $ 490,000

    $ 1,470,000

    $ 14,700,000

    $ 7,350,000

    $ 22,050,000

    $ - $ - $ 294,000

    $ 3,528,000

    $ 3,528,000

    Compu Portatil DELL Inspiron 14z Core I7 $ 909,000 $ 454,500 $ 1,363,500 $ 13,635,000 $ 6,817,500 $ 20,452,500 $ - $ - $ 272,700 $ 3,272,400 $ 3,272,400

    Compu Portatil LENOVO Core I7 $ 1,030,000 $ 515,000 $ 1,545,000 $ 15,450,000 $ 7,725,000 $ 23,175,000 $ - $ - $ 309,000 $ 3,708,000 $ 3,708,000

    Compu Portatil LENOVO Flex 2 Core I7 $ 1,152,000

    $ 576,000

    $ 1,728,000

    $ 17,280,000

    $ 8,640,000

    $ 25,920,000

    $ - $ - $ 345,600

    $ 4,147,200

    $ 4,147,200

    Compu Portatil LENOVO Notebook Core I5 $ 975,000 $ 487,500 $ 1,462,500 $ 14,625,000 $ 7,312,500 $ 21,937,500 $ - $ - $ 292,500 $ 3,510,000 $ 3,510,000

    Compu Portatil HP Envy Core I7 $ 1,200,000

    $ 600,000

    $ 1,800,000

    $ 18,000,000

    $ 9,000,000

    $ 27,000,000

    $ - $ - $ 360,000

    $ 4,320,000

    $ 4,320,000

    Compu Portatil HP Dv6 7048la Core I7 $ 964,000

    $ 482,000

    $ 1,446,000

    $ 14,460,000

    $ 7,230,000

    $ 21,690,000

    $ - $ - $ 289,200

    $ 3,470,400

    $ 3,470,400

    Compu Portatil HP intel Core I5 4ta Generacion $ 858,000 $ 429,000 $ 1,287,000 $ 12,870,000 $ 6,435,000 $ 19,305,000 $ - $ - $ 257,400 $ 3,088,800 $ 3,088,800

    Unidad Dvd Optica Sata $ 69,000 $ 34,500 $ 103,500 $ 1,035,000 $ 517,500 $ 1,552,500 $ 165,600 $ - $ 20,700 $ 248,400 $ 82,800

    Unidad Blueray Sata 3d $ 115,000

    $ 57,500

    $ 172,500

    $ 1,725,000

    $ 862,500

    $ 2,587,500

    $ 276,000

    $ - $ 34,500

    $ 414,000

    $ 138,000

    Mouse Vertical optico Usb $ 33,000 $ 16,500 $ 49,500 $ 495,000 $ 247,500 $ 742,500 $ 79,200 $ - $ 9,900 $ 118,800 $ 39,600

    Mouse Raton optico Usb $ 17,000

    $ 8,500 $ 25,500

    $ 255,000

    $ 127,500

    $ 382,500

    $ 40,800

    $ - $ 5,100 $ 61,200

    $ 20,400

    Mouse Vertical Inalambrico $ 59,500

    $ 29,750

    $ 89,250

    $ 892,500

    $ 446,250

    $ 1,338,750

    $ 142,800

    $ - $ 17,850

    $ 214,200

    $ 71,400

    Mouse Raton Inalambrico $ 20,000

    $ 10,000

    $ 30,000

    $ 300,000

    $ 150,000

    $ 450,000

    $ 48,000

    $ - $ 6,000 $ 72,000

    $ 24,000

    Teclado usb $ 15,000

    $ 7,500 $ 22,500

    $ 225,000

    $ 112,500

    $ 337,500

    $ 36,000

    $ - $ 4,500 $ 54,000

    $ 18,000

    Teclado Inalambrico $ 18,500

    $ 9,250 $ 27,750

    $ 277,500

    $ 138,750

    $ 416,250

    $ 44,400

    $ - $ 5,550 $ 66,600

    $ 22,200

    Mtto Por Garantia pc $ - $ 260,000 $ 7,800,000 $ 7,800,000 $ 1,248,000 $ 1,248,000

    Mtto Por Garantia Portatil $ - $ 350,000 $ 10,500,000 $ 10,500,000 $ 1,680,000 $ 1,680,000

    $ 233,175,000

    $ 134,887,500

    $ 349,762,500

    $ 11,488,800

    $ 1,161,000

    $ 4,663,500

    $ 55,962,000

    $ 44,473,200

  • Costos Fijos y Punto de Equilibrio

    Nomina Mensual $ 107,772,122

    Servicios $ 11,130,000

    Diversos $ 6,400,000

    arancel 10% $ 1,161,000

    Gravamen Movimientos Financieros $ 367,155

    seguro 2% $ 4,663,500

    Costos Fijos $ 131,493,777

    Punto de Equilibrio $ 134,887,500

    Gastos fijos por Area

    Area Mes

    Mes

    Admon

    $ 48,032,230

    $ 576,386,759

    Ventas $ 13,193,673 $ 158,324,080

    Operacin $ 70,267,874 $ 843,214,484

    Total $ 131,493,777 $ 1,577,925,323

  • Nomina

    $ 644,340 $

    1,288,680

    Cargo

    Sueldo por Cargo N Pers. X

    Cargo

    Auxilio de

    Transporte

    Base Salarial

    gerante $ 14,000,000 1 $ - $ 14,000,000

    dir. Admon $ 3,000,000 1 $ - $ 3,000,000

    siso $ 2,500,000 1 $ - $ 2,500,000

    Aux. Tlento Humano $ 800,000 1 $ 74,000 $ 726,000

    Contador general $ 3,000,000 1 $ - $ 3,000,000

    Asistente Contable $ 1,200,000 1 $ 74,000 $ 1,126,000

    aux. caontable $ 900,000 1 $ 74,000 $ 826,000

    Totales Area $ 25,400,000 7 $ 222,000 $ 25,178,000

    Contabilizaciones por la cuenta po Pagar

    Contabilizaciones por la cuenta del Gasto

    250506 261005 261010 261015 261020

    510527 510506 510530 510533 510539 510536

    sueldos

    Departamento de Ventas

    PROVISIONES APROPIACIONES

    Cargo

    Sueldo por Cargo N Pers. X

    Cargo

    Auxilio de

    Transporte Base Salarial CESANTIAS INTERESES/CESANTIA

    VACACIONES PRIMA SALUD Empleado SALUD Empleador PENSIN empleado PENSIN empleador ARL SENA ICBF CAJA DE

    Dotacion Total Mensual por

    Total Anual por Trabajador S COMPENSACIN Trabajador

    dir. Ventas $ 3,000,000 1 $ - $ 3,000,000 $ 249,900 $ 2,499 $ 125,100 $ 249,900 $ 120,000 $ 255,000 $ 120,000 $ 360,000 $ 15,660 $ 60,000 $ 90,000 $ 120,000 $ - $ 4,528,059 $ 54,336,708

    promotores de ventas $ 1,020,000 1 $ 74,000 $ 946,000 $ 78,802 $ 788 $ 36,362 $ 78,802 $ 34,880 $ 74,120 $ 34,880 $ 104,640 $ 4,552 $ 17,440 $ 26,160 $ 34,880 $ 25,000 $ 1,501,546 $ 18,018,550

    promotores de ventas $ 1,020,000 1 $ 74,000 $ 946,000 $ 78,802 $ 788 $ 36,362 $ 78,802 $ 34,880 $ 74,120 $ 34,880 $ 104,640 $ 4,552 $ 17,440 $ 26,160 $ 34,880 $ 25,000 $ 1,501,546 $ 18,018,550

    promotores de ventas $ 1,020,000 1 $ 74,000 $ 946,000 $ 78,802 $ 788 $ 36,362 $ 78,802 $ 34,880 $ 74,120 $ 34,880 $ 104,640 $ 4,552 $ 17,440 $ 26,160 $ 34,880 $ 25,000 $ 1,501,546 $ 18,018,550

    promotores de ventas $ 1,020,000 1 $ 74,000 $ 946,000 $ 78,802 $ 788 $ 36,362 $ 78,802 $ 34,880 $ 74,120 $ 34,880 $ 104,640 $ 4,552 $ 17,440 $ 26,160 $ 34,880 $ 25,000 $ 1,501,546 $ 18,018,550

    Totales Area $ 7,080,000 5 $ 296,000 $ 6,784,000 $ 565,107 $ 5,651 $ 270,550 $ 565,107 $ 259,520 $ 551,480 $ 259,520 $ 778,560 $ 33,867 $ 129,760 $ 194,640 $ 259,520 $ 100,000 $ 10,534,242 $ 126,410,909

    Departamento Administrativo

    PROVISIONES

    APROPIACIONES

    CESANTIAS INTERESES/CESANTIA S

    VACACIONES PRIMA SALUD Empleado SALUD Empleador PENSIN empleado PENSIN empleador ARL SENA ICBF

    CAJA DE

    COMPENSACIN Dotacion

    Total Mensual por

    Trabajador Total Anual por Trabajador

    $ 1,166,200 $ 11,662 $ 583,800 $ 1,166,200 $ 560,000 $ 1,190,000 $ 560,000 $ 1,680,000 $ 73,080 $ 280,000 $ 420,000 $ 560,000 $ - $ 21,130,942 $ 253,571,304

    $ 249,900 $ 2,499 $ 125,100 $ 249,900 $ 120,000 $ 255,000 $ 120,000 $ 360,000 $ 15,660 $ 60,000 $ 90,000 $ 120,000 $ - $ 4,528,059 $ 54,336,708

    $ 208,250 $ 2,083 $ 104,250 $ 208,250 $ 100,000 $ 212,500 $ 100,000 $ 300,000 $ 13,050 $ 50,000 $ 75,000 $ 100,000 $ - $ 3,773,383 $ 45,280,590

    $ 60,476 $ 605 $ 27,188 $ 60,476 $ 26,080 $ 55,420 $ 26,080 $ 78,240 $ 3,403 $ 13,040 $ 19,560 $ 26,080 $ 20,000 $ 1,164,488 $ 13,973,858

    $ 249,900 $ 2,499 $ 125,100 $ 249,900 $ 120,000 $ 255,000 $ 120,000 $ 360,000 $ 15,660 $ 60,000 $ 90,000 $ 120,000 $ - $ 4,528,059 $ 54,336,708

    $ 93,796 $ 938 $ 43,868 $ 93,796 $ 42,080 $ 89,420 $ 42,080 $ 126,240 $ 5,491 $ 21,040 $ 31,560 $ 42,080 $ 27,500 $ 1,775,729 $ 21,308,753

    $ 68,806 $ 688 $ 31,358 $ 68,806 $ 30,080 $ 63,920 $ 30,080 $ 90,240 $ 3,925 $ 15,040 $ 22,560 $ 30,080 $ 22,500 $ 1,317,923 $ 15,815,082

    $ 2,097,327 $ 20,973 $ 1,040,665 $ 2,097,327 $ 998,240 $ 2,121,260 $ 998,240 $ 2,994,720 $ 130,270 $ 499,120 $ 748,680 $ 998,240 $ 70,000 $ 38,218,584 $ 458,623,003

  • Cargo

    Sueldo por Cargo N Pers. X

    Cargo

    Auxilio de

    Transporte

    Base Salarial

    dir. Operacional $ 5,500,000 1 $ - $ 5,500,000

    Montacargista $ 1,100,000 1 $ 74,000 $ 1,026,000

    Montacargista $ 1,100,000 1 $ 74,000 $ 1,026,000

    Montacargista $ 1,100,000 1 $ 74,000 $ 1,026,000

    tec. Control de calidad $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Control de calidad $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Control de calidad $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Control de calidad $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Ensable $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Ensable $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Ensable $ 1,080,000 1 $ 74,000 $ 1,006,000

    tec. Ensable $ 1,080,000 1 $ 74,000 $ 1,006,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen empaque $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen inventarios $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    aux. almacen despacho $ 840,000 1 $ 74,000 $ 766,000

    Ing. De Sistemas $ 1,750,000 1 $ - $ 1,750,000

    servicios generales $ 700,000 1 $ 74,000 $ 626,000

    Totales Area $ 40,050,000 38 $ 2,664,000 $ 37,386,000

    Totales Empresa $ 72,530,000 50 $ 3,182,000 $ 69,348,000 $ 5,776,688 $ 57,767 $ 2,759,122 $ 5,776,688 $ 2,646,640 $ 5,624,110 $ 2,646,640 $ 7,939,920 $ 345,387 $ 1,323,320 $ 1,984,980 $ 2,646,640 $ 1,007,500 $ 107,772,122 $ 1,293,265,469

    Departamento Operativo

    PROVISIONES

    APROPIACIONES

    CESANTIAS INTERESES/CESANTIA VACACIONES S

    PRIMA SALUD Empleado SALUD Empleador PENSIN empleado PENSIN empleador ARL SENA ICBF CAJA DE

    COMPENSACIN Dotacion

    Total Mensual por

    Trabajador Total Anual por Trabajador

    $ 458,150 $ 4,582 $ 229,350 $ 458,150 $ 220,000 $ 467,500 $ 220,000 $ 660,000 $ 28,710 $ 110,000 $ 165,000 $ 220,000 $ - $ 8,301,442 $ 99,617,298

    $ 85,466 $ 855 $ 39,698 $ 85,466 $ 38,080 $ 80,920 $ 38,080 $ 114,240 $ 4,969 $ 19,040 $ 28,560 $ 38,080 $ 25,000 $ 1,622,294 $ 19,467,529

    $ 85,466 $ 855 $ 39,698 $ 85,466 $ 38,080 $ 80,920 $ 38,080 $ 114,240 $ 4,969 $ 19,040 $ 28,560 $ 38,080 $ 25,000 $ 1,622,294 $ 19,467,529

    $ 85,466 $ 855 $ 39,698 $ 85,466 $ 38,080 $ 80,920 $ 38,080 $ 114,240 $ 4,969 $ 19,040 $ 28,560 $ 38,080 $ 25,000 $ 1,622,294 $ 19,467,529

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 83,800 $ 838 $ 38,864 $ 83,800 $ 37,280 $ 79,220 $ 37,280 $ 111,840 $ 4,865 $ 18,640 $ 27,960 $ 37,280 $ 25,000 $ 1,592,107 $ 19,105,284

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 63,808 $ 638 $ 28,856 $ 63,808 $ 27,680 $ 58,820 $ 27,680 $ 83,040 $ 3,612 $ 13,840 $ 20,760 $ 27,680 $ 22,500 $ 1,227,362 $ 14,728,348

    $ 145,775 $ 1,458 $ 72,975 $ 145,775 $ 70,000 $ 148,750 $ 70,000 $ 210,000 $ 9,135 $ 35,000 $ 52,500 $ 70,000 $ - $ 2,641,368 $ 31,696,413

    $ 52,146 $ 521 $ 23,018 $ 52,146 $ 22,080 $ 46,920 $ 22,080 $ 66,240 $ 2,881 $ 11,040 $ 16,560 $ 22,080 $ 22,500 $ 1,016,053 $ 12,192,635

    $ 3,114,254 $ 31,143 $ 1,447,907 $ 3,114,254 $ 1,388,880 $ 2,951,370 $ 1,388,880 $ 4,166,640 $ 181,249 $ 694,440 $ 1,041,660 $ 1,388,880 $ 837,500 $ 59,019,296 $ 708,231,557

  • Servicios Admon ventas Operacin Total Mensual Total Anual Porcentajes de Dedicacion 30% 20% 50% Energia Electrica $ 2,500,000 $ 750,000 $ 500,000 $ 1,250,000 $ 2,500,000 $ 30,000,000

    Acueducto y Alcantarillado $ 550,000 $ 165,000 $ 110,000 $ 275,000 $ 550,000 $ 6,600,000

    internet $ 700,000 $ 210,000 $ 140,000 $ 350,000 $ 700,000 $ 8,400,000

    telefono $ 700,000 $ 210,000 $ 140,000 $ 350,000 $ 700,000 $ 8,400,000

    telefonia celular $ 480,000 $ 144,000 $ 96,000 $ 240,000 $ 480,000 $ 5,760,000

    vigilancia $ 4,200,000 $ 1,260,000 $ 840,000 $ 2,100,000 $ 4,200,000 $ 50,400,000

    Arrendamientos $ 2,000,000 $ 600,000 $ 400,000 $ 1,000,000 $ 2,000,000 $ 24,000,000

    Total Servicios $ 9,130,000 $ 3,339,000 $ 2,226,000 $ 5,565,000 $ 11,130,000 $ 133,560,000

    Diversos Admon ventas Operacin Total Mensual Total Anual Porcentajes de Dedicacion 30% 20% 50% combustibles $ 1,200,000 $ - $ - $ 1,200,000 $ 1,200,000 $ 14,400,000

    Mtto Vehiculos $ 400,000 $ - $ - $ 400,000 $ 400,000 $ 4,800,000

    Transportes Fletes y Acarreos $ 3,000,000 $ - $ - $ 3,000,000 $ 3,000,000 $ 36,000,000

    Utiles Papeleria y Fotocopias $ 1,200,000 $ 360,000 $ 240,000 $ 600,000 $ 1,200,000 $ 14,400,000

    Elementos de Aseo y Cafeteria $ 600,000 $ 180,000 $ 120,000 $ 300,000 $ 600,000 $ 7,200,000

    $ - $ - $ - $ - $ - Total Servicios $ 6,400,000 $ 540,000 $ 360,000 $ 5,500,000 $ 6,400,000 $ 76,800,000

    $ 15,530,000

    $ 3,879,000

    $ 2,586,000

    $ 11,065,000

    $ 17,530,000

    $ 210,360,000

    $ 186,360,000 $ 46,548,000 $ 31,032,000 $ 132,780,000 $ 210,360,000 $ 2,524,320,000

  • January 2015 February 2015

    DESCRIPCION PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC NMINA $ 106,764,622 $ 106,764,622 100.00% $ 106,764,622 $ 106,764,622 100.00%

    Sueldos $ 69,348,000 $ 69,348,000 100.00% $ 69,348,000 $ 69,348,000 100.00%

    Auxilio de Transporte $ 3,182,000 $ 3,182,000 100.00% $ 3,182,000 $ 3,182,000 100.00%

    Provision Cesantas $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00%

    Provision Intereses Sobre Cesantas $ 57,767 $ 57,767 100.00% $ 57,767 $ 57,767 100.00%

    Provision Prima de Servicios $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00%

    Provision Vacaciones $ 2,759,122 $ 2,759,122 100.00% $ 2,759,122 $ 2,759,122 100.00%

    Aportes A.R.L $ 345,387 $ 345,387 100.00% $ 345,387 $ 345,387 100.00%

    Aportes E.P.S. $ 5,624,110 $ 5,624,110 100.00% $ 5,624,110 $ 5,624,110 100.00%

    Aportes Fondo Pensiones $ 7,939,920 $ 7,939,920 100.00% $ 7,939,920 $ 7,939,920 100.00%

    Aportes Cajas de Compensacin Familiar $ 2,646,640 $ 2,646,640 100.00% $ 2,646,640 $ 2,646,640 100.00%

    Aportes I.C.B.F. $ 1,984,980 $ 1,984,980 100.00% $ 1,984,980 $ 1,984,980 100.00%

    Aportes SENA $ 1,323,320 $ 1,323,320 100.00% $ 1,323,320 $ 1,323,320 100.00%

    DOTACION $ 1,007,500 $ 1,007,500 100.00% $ 1,007,500 $ 1,007,500 100.00%

    IMPUESTOS $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00%

    Gravamen Movimiento Financiero $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00%

    Sobre Vehiculos $ - $ - #DIV/0! $ - $ - #DIV/0!

    SEGUROS-VEHICULOS $ - $ - #DIV/0! $ - $ - #DIV/0!

    INTERNET $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00%

    CELULARES $ 480,000 $ 480,000 100.00% $ 480,000 $ 480,000 100.00%

    ELEMENTOS DE ASEO Y CAFETERIA $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00%

    MANTENIMIENTO DE VEHICULOS $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00%

    UTILES PAPELERIA Y FOTOCOPIAS $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    COMBUSTIBLES $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    IMPUESTOS IMPORTACION $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00%

    Arancel 10% $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00% Seguro 2% $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00%

    BODEGA $ 9,950,000 $ 9,950,000 100.00% $ 9,950,000 $ 9,950,000 100.00%

    VIGILANCIA $ 4,200,000 $ 4,200,000 100.00% $ 4,200,000 $ 4,200,000 100.00%

    ARRENDAMIENTOS $ 2,000,000 $ 2,000,000 100.00% $ 2,000,000 $ 2,000,000 100.00%

    ACUEDUCTO Y ALCANTARILLADO $ 550,000 $ 550,000 100.00% $ 550,000 $ 550,000 100.00%

    ENERGIA ELECTRICA $ 2,500,000 $ 2,500,000 100.00% $ 2,500,000 $ 2,500,000 100.00%

    TELEFONIA FIJA $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00%

    CLIENTES $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    TRANSPORTES, FLETES Y ACARREOS $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    GRAN TOTAL $ 131,493,777 $ 131,493,777 100.00% $ 131,493,777 $ 131,493,777 100.00%

  • March 2015 April 2015 May 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 106,764,622 $ 106,764,622 100.00% $ 106,764,622 $ 106,764,622 100.00% $ 106,764,622 $ 106,764,622 100.00%

    $ 69,348,000 $ 69,348,000 100.00% $ 69,348,000 $ 69,348,000 100.00% $ 69,348,000 $ 69,348,000 100.00%

    $ 3,182,000 $ 3,182,000 100.00% $ 3,182,000 $ 3,182,000 100.00% $ 3,182,000 $ 3,182,000 100.00%

    $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00%

    $ 57,767 $ 57,767 100.00% $ 57,767 $ 57,767 100.00% $ 57,767 $ 57,767 100.00%

    $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00% $ 5,776,688 $ 5,776,688 100.00%

    $ 2,759,122 $ 2,759,122 100.00% $ 2,759,122 $ 2,759,122 100.00% $ 2,759,122 $ 2,759,122 100.00%

    $ 345,387 $ 345,387 100.00% $ 345,387 $ 345,387 100.00% $ 345,387 $ 345,387 100.00%

    $ 5,624,110 $ 5,624,110 100.00% $ 5,624,110 $ 5,624,110 100.00% $ 5,624,110 $ 5,624,110 100.00%

    $ 7,939,920 $ 7,939,920 100.00% $ 7,939,920 $ 7,939,920 100.00% $ 7,939,920 $ 7,939,920 100.00%

    $ 2,646,640 $ 2,646,640 100.00% $ 2,646,640 $ 2,646,640 100.00% $ 2,646,640 $ 2,646,640 100.00%

    $ 1,984,980 $ 1,984,980 100.00% $ 1,984,980 $ 1,984,980 100.00% $ 1,984,980 $ 1,984,980 100.00%

    $ 1,323,320 $ 1,323,320 100.00% $ 1,323,320 $ 1,323,320 100.00% $ 1,323,320 $ 1,323,320 100.00%

    $ 1,007,500 $ 1,007,500 100.00% $ 1,007,500 $ 1,007,500 100.00% $ 1,007,500 $ 1,007,500 100.00%

    $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00%

    $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00% $ 367,155 $ 367,155 100.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00%

    $ 480,000 $ 480,000 100.00% $ 480,000 $ 480,000 100.00% $ 480,000 $ 480,000 100.00%

    $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00%

    $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00%

    $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00%

    $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00%

    $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00%

    $ 9,950,000 $ 9,950,000 100.00% $ 9,950,000 $ 9,950,000 100.00% $ 9,950,000 $ 9,950,000 100.00%

    $ 4,200,000 $ 4,200,000 100.00% $ 4,200,000 $ 4,200,000 100.00% $ 4,200,000 $ 4,200,000 100.00%

    $ 2,000,000 $ 2,000,000 100.00% $ 2,000,000 $ 2,000,000 100.00% $ 2,000,000 $ 2,000,000 100.00%

    $ 550,000 $ 550,000 100.00% $ 550,000 $ 550,000 100.00% $ 550,000 $ 550,000 100.00%

    $ 2,500,000 $ 2,500,000 100.00% $ 2,500,000 $ 2,500,000 100.00% $ 2,500,000 $ 2,500,000 100.00%

    $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00% $ 700,000 $ 700,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 131,493,777 $ 131,493,777 100.00% $ 131,493,777 $ 131,493,777 100.00% $ 131,493,777 $ 131,493,777 100.00%

  • June 2015 July 2015 August 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 106,764,622 $ 53,382,311 50.00% $ 106,764,622 $ - 0.00% $ 106,764,622 $ - 0.00%

    $ 69,348,000 $ 34,674,000 50.00% $ 69,348,000 $ - 0.00% $ 69,348,000 $ - 0.00%

    $ 3,182,000 $ 1,591,000 50.00% $ 3,182,000 $ - 0.00% $ 3,182,000 $ - 0.00%

    $ 5,776,688 $ 2,888,344 50.00% $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00%

    $ 57,767 $ 28,883 50.00% $ 57,767 $ - 0.00% $ 57,767 $ - 0.00%

    $ 5,776,688 $ 2,888,344 50.00% $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00%

    $ 2,759,122 $ 1,379,561 50.00% $ 2,759,122 $ - 0.00% $ 2,759,122 $ - 0.00%

    $ 345,387 $ 172,693 50.00% $ 345,387 $ - 0.00% $ 345,387 $ - 0.00%

    $ 5,624,110 $ 2,812,055 50.00% $ 5,624,110 $ - 0.00% $ 5,624,110 $ - 0.00%

    $ 7,939,920 $ 3,969,960 50.00% $ 7,939,920 $ - 0.00% $ 7,939,920 $ - 0.00%

    $ 2,646,640 $ 1,323,320 50.00% $ 2,646,640 $ - 0.00% $ 2,646,640 $ - 0.00%

    $ 1,984,980 $ 992,490 50.00% $ 1,984,980 $ - 0.00% $ 1,984,980 $ - 0.00%

    $ 1,323,320 $ 661,660 50.00% $ 1,323,320 $ - 0.00% $ 1,323,320 $ - 0.00%

    $ 1,007,500 $ 503,750 50.00% $ 1,007,500 $ - 0.00% $ 1,007,500 $ - 0.00%

    $ 367,155 $ 183,577 50.00% $ 367,155 $ - 0.00% $ 367,155 $ - 0.00%

    $ 367,155 $ 183,577 50.00% $ 367,155 $ - 0.00% $ 367,155 $ - 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 700,000 $ 350,000 50.00% $ 700,000 $ - 0.00% $ 700,000 $ - 0.00%

    $ 480,000 $ 240,000 50.00% $ 480,000 $ - 0.00% $ 480,000 $ - 0.00%

    $ 600,000 $ 300,000 50.00% $ 600,000 $ - 0.00% $ 600,000 $ - 0.00%

    $ 400,000 $ 200,000 50.00% $ 400,000 $ - 0.00% $ 400,000 $ - 0.00%

    $ 1,200,000 $ 600,000 50.00% $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00%

    $ 1,200,000 $ 600,000 50.00% $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00%

    $ 5,824,500 $ 2,912,250 50.00% $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00%

    $ 1,161,000 $ 580,500 50.00% $ 1,161,000 $ - 0.00% $ 1,161,000 $ - 0.00%

    $ 4,663,500 $ 2,331,750 50.00% $ 4,663,500 $ - 0.00% $ 4,663,500 $ - 0.00%

    $ 9,950,000 $ 4,875,333 49.00% $ 9,950,000 $ - 0.00% $ 9,950,000 $ - 0.00%

    $ 4,200,000 $ 2,100,000 50.00% $ 4,200,000 $ - 0.00% $ 4,200,000 $ - 0.00%

    $ 2,000,000 $ 1,000,000 50.00% $ 2,000,000 $ - 0.00% $ 2,000,000 $ - 0.00%

    $ 550,000 $ 275,000 50.00% $ 550,000 $ - 0.00% $ 550,000 $ - 0.00%

    $ 2,500,000 $ 1,166,667 46.67% $ 2,500,000 $ - 0.00% $ 2,500,000 $ - 0.00%

    $ 700,000 $ 333,667 47.67% $ 700,000 $ - 0.00% $ 700,000 $ - 0.00%

    $ 3,000,000 $ 600,000 20.00% $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 3,000,000 $ 600,000 20.00% $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 131,493,777 $ 64,747,222 49.24% $ 131,493,777 $ - 0.00% $ 131,493,777 $ - 0.00%

  • September 2015 October 2015 November 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 106,764,622 $ - 0.00% $ 106,764,622 $ - 0.00% $ 106,764,622 $ - 0.00%

    $ 69,348,000 $ - 0.00% $ 69,348,000 $ - 0.00% $ 69,348,000 $ - 0.00%

    $ 3,182,000 $ - 0.00% $ 3,182,000 $ - 0.00% $ 3,182,000 $ - 0.00%

    $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00%

    $ 57,767 $ - 0.00% $ 57,767 $ - 0.00% $ 57,767 $ - 0.00%

    $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00% $ 5,776,688 $ - 0.00%

    $ 2,759,122 $ - 0.00% $ 2,759,122 $ - 0.00% $ 2,759,122 $ - 0.00%

    $ 345,387 $ - 0.00% $ 345,387 $ - 0.00% $ 345,387 $ - 0.00%

    $ 5,624,110 $ - 0.00% $ 5,624,110 $ - 0.00% $ 5,624,110 $ - 0.00%

    $ 7,939,920 $ - 0.00% $ 7,939,920 $ - 0.00% $ 7,939,920 $ - 0.00%

    $ 2,646,640 $ - 0.00% $ 2,646,640 $ - 0.00% $ 2,646,640 $ - 0.00%

    $ 1,984,980 $ - 0.00% $ 1,984,980 $ - 0.00% $ 1,984,980 $ - 0.00%

    $ 1,323,320 $ - 0.00% $ 1,323,320 $ - 0.00% $ 1,323,320 $ - 0.00%

    $ 1,007,500 $ - 0.00% $ 1,007,500 $ - 0.00% $ 1,007,500 $ - 0.00%

    $ 367,155 $ - 0.00% $ 367,155 $ - 0.00% $ 367,155 $ - 0.00%

    $ 367,155 $ - 0.00% $ 367,155 $ - 0.00% $ 367,155 $ - 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 700,000 $ - 0.00% $ 700,000 $ - 0.00% $ 700,000 $ - 0.00%

    $ 480,000 $ - 0.00% $ 480,000 $ - 0.00% $ 480,000 $ - 0.00%

    $ 600,000 $ - 0.00% $ 600,000 $ - 0.00% $ 600,000 $ - 0.00%

    $ 400,000 $ - 0.00% $ 400,000 $ - 0.00% $ 400,000 $ - 0.00%

    $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00%

    $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00% $ 1,200,000 $ - 0.00%

    $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00%

    $ 1,161,000 $ - 0.00% $ 1,161,000 $ - 0.00% $ 1,161,000 $ - 0.00%

    $ 4,663,500 $ - 0.00% $ 4,663,500 $ - 0.00% $ 4,663,500 $ - 0.00%

    $ 9,950,000 $ - 0.00% $ 9,950,000 $ - 0.00% $ 9,950,000 $ - 0.00%

    $ 4,200,000 $ - 0.00% $ 4,200,000 $ - 0.00% $ 4,200,000 $ - 0.00%

    $ 2,000,000 $ - 0.00% $ 2,000,000 $ - 0.00% $ 2,000,000 $ - 0.00%

    $ 550,000 $ - 0.00% $ 550,000 $ - 0.00% $ 550,000 $ - 0.00%

    $ 2,500,000 $ - 0.00% $ 2,500,000 $ - 0.00% $ 2,500,000 $ - 0.00%

    $ 700,000 $ - 0.00% $ 700,000 $ - 0.00% $ 700,000 $ - 0.00%

    $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 131,493,777 $ - 0.00% $ 131,493,777 $ - 0.00% $ 131,493,777 $ - 0.00%

  • December 2015 TOTAL 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 106,764,622 $ - 0.00% $ 1,281,175,469 $ 587,205,423 45.83%

    $ 69,348,000 $ - 0.00% $ 832,176,000 $ 381,414,000 45.83%

    $ 3,182,000 $ - 0.00% $ 38,184,000 $ 17,501,000 45.83%

    $ 5,776,688 $ - 0.00% $ 69,320,261 $ 31,771,786 45.83%

    $ 57,767 $ - 0.00% $ 693,203 $ 317,718 45.83%

    $ 5,776,688 $ - 0.00% $ 69,320,261 $ 31,771,786 45.83%

    $ 2,759,122 $ - 0.00% $ 33,109,466 $ 15,175,172 45.83%

    $ 345,387 $ - 0.00% $ 4,144,638 $ 1,899,626 45.83%

    $ 5,624,110 $ - 0.00% $ 67,489,320 $ 30,932,605 45.83%

    $ 7,939,920 $ - 0.00% $ 95,279,040 $ 43,669,560 45.83%

    $ 2,646,640 $ - 0.00% $ 31,759,680 $ 14,556,520 45.83%

    $ 1,984,980 $ - 0.00% $ 23,819,760 $ 10,917,390 45.83%

    $ 1,323,320 $ - 0.00% $ 15,879,840 $ 7,278,260 45.83%

    $ 1,007,500 $ - 0.00% $ 12,090,000 $ 5,541,250 45.83%

    $ 367,155 $ - 0.00% $ 4,405,855 $ 2,019,350 45.83%

    $ 367,155 $ - 0.00% $ 4,405,855 $ 2,019,350 45.83%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 700,000 $ - 0.00% $ 8,400,000 $ 3,850,000 45.83%

    $ 480,000 $ - 0.00% $ 5,760,000 $ 2,640,000 45.83%

    $ 600,000 $ - 0.00% $ 7,200,000 $ 3,300,000 45.83%

    $ 400,000 $ - 0.00% $ 4,800,000 $ 2,200,000 45.83%

    $ 1,200,000 $ - 0.00% $ 14,400,000 $ 6,600,000 45.83%

    $ 1,200,000 $ - 0.00% $ 14,400,000 $ 6,600,000 45.83%

    $ 5,824,500 $ - 0.00% $ 69,894,000 $ 32,034,750 45.83%

    $ 1,161,000 $ - 0.00% $ 13,932,000 $ 6,385,500 45.83%

    $ 4,663,500 $ - 0.00% $ 55,962,000 $ 25,649,250 45.83%

    $ 9,950,000 $ - 0.00% $ 119,400,000 $ 54,625,333 45.75%

    $ 4,200,000 $ - 0.00% $ 50,400,000 $ 23,100,000 45.83%

    $ 2,000,000 $ - 0.00% $ 24,000,000 $ 11,000,000 45.83%

    $ 550,000 $ - 0.00% $ 6,600,000 $ 3,025,000 45.83%

    $ 2,500,000 $ - 0.00% $ 30,000,000 $ 13,666,667 45.56%

    $ 700,000 $ - 0.00% $ 8,400,000 $ 3,833,667 45.64%

    $ 3,000,000 $ - 0.00% $ 36,000,000 $ 15,600,000 43.33%

    $ 3,000,000 $ - 0.00% $ 36,000,000 $ 15,600,000 43.33%

    $ 131,493,777 $ - 0.00% $ 1,577,925,323 $ 722,216,107 45.77%

  • PRESUPUESTO DE ADMINISTRACION (COMPRAS/GASTOS) January 2015 February 2015 March 2015

    DESCRIPCION PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC NMINA $ 38,148,584 $ 38,148,584 100.00% $ 38,148,584 $ 38,148,584 100.00% $ 38,148,584 $ 38,148,584 100.00%

    Sueldos $ 25,178,000 $ 25,178,000 100.00% $ 25,178,000 $ 25,178,000 100.00% $ 25,178,000 $ 25,178,000 100.00%

    Auxilio de Transporte $ 222,000 $ 222,000 100.00% $ 222,000 $ 222,000 100.00% $ 222,000 $ 222,000 100.00%

    Provision Cesantas $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00%

    Provision Intereses Sobre Cesantas $ 20,973 $ 20,973 100.00% $ 20,973 $ 20,973 100.00% $ 20,973 $ 20,973 100.00%

    Provision Prima de Servicios $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00%

    Provision Vacaciones $ 1,040,665 $ 1,040,665 100.00% $ 1,040,665 $ 1,040,665 100.00% $ 1,040,665 $ 1,040,665 100.00%

    Aportes A.R.L $ 130,270 $ 130,270 100.00% $ 130,270 $ 130,270 100.00% $ 130,270 $ 130,270 100.00%

    Aportes E.P.S. $ 2,121,260 $ 2,121,260 100.00% $ 2,121,260 $ 2,121,260 100.00% $ 2,121,260 $ 2,121,260 100.00%

    Aportes Fondo Pensiones $ 2,994,720 $ 2,994,720 100.00% $ 2,994,720 $ 2,994,720 100.00% $ 2,994,720 $ 2,994,720 100.00%

    Aportes Cajas de Compensacin Familiar $ 998,240 $ 998,240 100.00% $ 998,240 $ 998,240 100.00% $ 998,240 $ 998,240 100.00%

    Aportes I.C.B.F. $ 748,680 $ 748,680 100.00% $ 748,680 $ 748,680 100.00% $ 748,680 $ 748,680 100.00%

    Aportes SENA $ 499,120 $ 499,120 100.00% $ 499,120 $ 499,120 100.00% $ 499,120 $ 499,120 100.00%

    DOTACION $ 70,000 $ 70,000 100.00% $ 70,000 $ 70,000 100.00% $ 70,000 $ 70,000 100.00%

    IMPUESTOS $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00%

    Gravamen Movimiento Financiero $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00%

    Sobre Vehiculos $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    SEGUROS-VEHICULOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    INTERNET $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00%

    CELULARES $ 144,000 $ 144,000 100.00% $ 144,000 $ 144,000 100.00% $ 144,000 $ 144,000 100.00%

    ELEMENTOS DE ASEO Y CAFETERIA $ 180,000 $ 180,000 100.00% $ 180,000 $ 180,000 100.00% $ 180,000 $ 180,000 100.00%

    MANTENIMIENTO DE VEHICULOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    UTILES PAPELERIA Y FOTOCOPIAS $ 360,000 $ 360,000 100.00% $ 360,000 $ 360,000 100.00% $ 360,000 $ 360,000 100.00%

    COMBUSTIBLES $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    IMPUESTOS IMPORTACION $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00%

    Arancel 10% $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00% Seguro 2% $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00%

    BODEGA $ 2,985,000 $ 2,985,000 100.00% $ 2,985,000 $ 2,985,000 100.00% $ 2,985,000 $ 2,985,000 100.00%

    VIGILANCIA $ 1,260,000 $ 1,260,000 100.00% $ 1,260,000 $ 1,260,000 100.00% $ 1,260,000 $ 1,260,000 100.00%

    ARRENDAMIENTOS $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00%

    ACUEDUCTO Y ALCANTARILLADO $ 165,000 $ 165,000 100.00% $ 165,000 $ 165,000 100.00% $ 165,000 $ 165,000 100.00%

    ENERGIA ELECTRICA $ 750,000 $ 750,000 100.00% $ 750,000 $ 750,000 100.00% $ 750,000 $ 750,000 100.00%

    TELEFONIA FIJA $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00%

    CLIENTES $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    TRANSPORTES, FLETES Y ACARREOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    GRAN TOTAL $ 48,056,265 $ 48,056,265 100.00% $ 48,056,265 $ 48,056,265 100.00% $ 48,056,265 $ 48,056,265 100.00%

  • April 2015 May 2015 June 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 38,148,584 $ 38,148,584 100.00% $ 38,148,584 $ 38,148,584 100.00% $ 38,148,584 $ 19,074,292 50.00% $ 25,178,000 $ 25,178,000 100.00% $ 25,178,000 $ 25,178,000 100.00% $ 25,178,000 $ 12,589,000 50.00%

    $ 222,000 $ 222,000 100.00% $ 222,000 $ 222,000 100.00% $ 222,000 $ 111,000 50.00%

    $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 1,048,664 50.00%

    $ 20,973 $ 20,973 100.00% $ 20,973 $ 20,973 100.00% $ 20,973 $ 10,487 50.00%

    $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 2,097,327 100.00% $ 2,097,327 $ 1,048,664 50.00%

    $ 1,040,665 $ 1,040,665 100.00% $ 1,040,665 $ 1,040,665 100.00% $ 1,040,665 $ 520,333 50.00%

    $ 130,270 $ 130,270 100.00% $ 130,270 $ 130,270 100.00% $ 130,270 $ 65,135 50.00%

    $ 2,121,260 $ 2,121,260 100.00% $ 2,121,260 $ 2,121,260 100.00% $ 2,121,260 $ 1,060,630 50.00%

    $ 2,994,720 $ 2,994,720 100.00% $ 2,994,720 $ 2,994,720 100.00% $ 2,994,720 $ 1,497,360 50.00%

    $ 998,240 $ 998,240 100.00% $ 998,240 $ 998,240 100.00% $ 998,240 $ 499,120 50.00%

    $ 748,680 $ 748,680 100.00% $ 748,680 $ 748,680 100.00% $ 748,680 $ 374,340 50.00%

    $ 499,120 $ 499,120 100.00% $ 499,120 $ 499,120 100.00% $ 499,120 $ 249,560 50.00%

    $ 70,000 $ 70,000 100.00% $ 70,000 $ 70,000 100.00% $ 70,000 $ 35,000 50.00% $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00% $ 134,182 $ 67,091 50.00%

    $ 134,182 $ 134,182 100.00% $ 134,182 $ 134,182 100.00% $ 134,182 $ 67,091 50.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00% $ 210,000 $ 105,000 50.00% $ 144,000 $ 144,000 100.00% $ 144,000 $ 144,000 100.00% $ 144,000 $ 72,000 50.00%

    $ 180,000 $ 180,000 100.00% $ 180,000 $ 180,000 100.00% $ 180,000 $ 90,000 50.00% $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 360,000 $ 360,000 100.00% $ 360,000 $ 360,000 100.00% $ 360,000 $ 180,000 50.00% $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 5,824,500 100.00% $ 5,824,500 $ 2,912,250 50.00%

    $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 1,161,000 100.00% $ 1,161,000 $ 580,500 50.00%

    $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 4,663,500 100.00% $ 4,663,500 $ 2,331,750 50.00%

    $ 2,985,000 $ 2,985,000 100.00% $ 2,985,000 $ 2,985,000 100.00% $ 2,985,000 $ 1,492,500 50.00%

    $ 1,260,000 $ 1,260,000 100.00% $ 1,260,000 $ 1,260,000 100.00% $ 1,260,000 $ 630,000 50.00%

    $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00% $ 600,000 $ 300,000 50.00%

    $ 165,000 $ 165,000 100.00% $ 165,000 $ 165,000 100.00% $ 165,000 $ 82,500 50.00%

    $ 750,000 $ 750,000 100.00% $ 750,000 $ 750,000 100.00% $ 750,000 $ 375,000 50.00%

    $ 210,000 $ 210,000 100.00% $ 210,000 $ 210,000 100.00% $ 210,000 $ 105,000 50.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 48,056,265 $ 48,056,265 100.00% $ 48,056,265 $ 48,056,265 100.00% $ 48,056,265 $ 24,028,133 50.00%

  • July 2015 August 2015 September 2015 October 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 38,148,584 $ - 0.00% $38,148,584 $ - 0.00% $ 38,148,584 $ - 0.00% $ 38,148,584 $ - 0.00%

    $ 25,178,000 0.00% $25,178,000 0.00% $25,178,000 0.00% $25,178,000 0.00%

    $ 222,000 0.00% $ 222,000 0.00% $ 222,000 0.00% $ 222,000 0.00%

    $ 2,097,327 0.00% $ 2,097,327 0.00% $ 2,097,327 0.00% $ 2,097,327 0.00%

    $ 20,973 0.00% $ 20,973 0.00% $ 20,973 0.00% $ 20,973 0.00%

    $ 2,097,327 0.00% $ 2,097,327 0.00% $ 2,097,327 0.00% $ 2,097,327 0.00%

    $ 1,040,665 0.00% $ 1,040,665 0.00% $ 1,040,665 0.00% $ 1,040,665 0.00%

    $ 130,270 0.00% $ 130,270 0.00% $ 130,270 0.00% $ 130,270 0.00%

    $ 2,121,260 0.00% $ 2,121,260 0.00% $ 2,121,260 0.00% $ 2,121,260 0.00%

    $ 2,994,720 0.00% $ 2,994,720 0.00% $ 2,994,720 0.00% $ 2,994,720 0.00%

    $ 998,240 0.00% $ 998,240 0.00% $ 998,240 0.00% $ 998,240 0.00%

    $ 748,680 0.00% $ 748,680 0.00% $ 748,680 0.00% $ 748,680 0.00%

    $ 499,120 0.00% $ 499,120 0.00% $ 499,120 0.00% $ 499,120 0.00%

    $ 70,000 0.00% $ 70,000 0.00% $ 70,000 0.00% $ 70,000 0.00%

    $ 134,182 $ - 0.00% $ 134,182 $ - 0.00% $ 134,182 $ - 0.00% $ 134,182 $ - 0.00%

    $ 134,182 0.00% $ 134,182 0.00% $ 134,182 0.00% $ 134,182 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 210,000 0.00% $ 210,000 0.00% $ 210,000 0.00% $ 210,000 0.00%

    $ 144,000 0.00% $ 144,000 0.00% $ 144,000 0.00% $ 144,000 0.00%

    $ 180,000 0.00% $ 180,000 0.00% $ 180,000 0.00% $ 180,000 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 360,000 0.00% $ 360,000 0.00% $ 360,000 0.00% $ 360,000 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00%

    $ 1,161,000 0.00% $ 1,161,000 0.00% $ 1,161,000 0.00% $ 1,161,000 0.00%

    $ 4,663,500 0.00% $ 4,663,500 0.00% $ 4,663,500 0.00% $ 4,663,500 0.00%

    $ 2,985,000 $ - 0.00% $ 2,985,000 $ - 0.00% $ 2,985,000 $ - 0.00% $ 2,985,000 $ - 0.00%

    $ 1,260,000 0.00% $ 1,260,000 0.00% $ 1,260,000 0.00% $ 1,260,000 0.00%

    $ 600,000 0.00% $ 600,000 0.00% $ 600,000 0.00% $ 600,000 0.00%

    $ 165,000 0.00% $ 165,000 0.00% $ 165,000 0.00% $ 165,000 0.00%

    $ 750,000 0.00% $ 750,000 0.00% $ 750,000 0.00% $ 750,000 0.00%

    $ 210,000 0.00% $ 210,000 0.00% $ 210,000 0.00% $ 210,000 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 48,056,265 $ - 0.00% $ 48,056,265 $ - 0.00% $ 48,056,265 $ - 0.00% $ 48,056,265 $ - 0.00%

  • November 2015 December 2015 TOTAL 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 38,148,584 $ - 0.00% $ 38,148,584 $ - 0.00% $ 457,783,003 $ 209,817,210 45.83%

    $ 25,178,000 0.00% $ 25,178,000 0.00% $ 302,136,000 $ 138,479,000 45.83%

    $ 222,000 0.00% $ 222,000 0.00% $ 2,664,000 $ 1,221,000 45.83%

    $ 2,097,327 0.00% $ 2,097,327 0.00% $ 25,167,929 $ 11,535,301 45.83%

    $ 20,973 0.00% $ 20,973 0.00% $ 251,679 $ 115,353 45.83%

    $ 2,097,327 0.00% $ 2,097,327 0.00% $ 25,167,929 $ 11,535,301 45.83%

    $ 1,040,665 0.00% $ 1,040,665 0.00% $ 12,487,982 $ 5,723,659 45.83%

    $ 130,270 0.00% $ 130,270 0.00% $ 1,563,244 $ 716,487 45.83%

    $ 2,121,260 0.00% $ 2,121,260 0.00% $ 25,455,120 $ 11,666,930 45.83%

    $ 2,994,720 0.00% $ 2,994,720 0.00% $ 35,936,640 $ 16,470,960 45.83%

    $ 998,240 0.00% $ 998,240 0.00% $ 11,978,880 $ 5,490,320 45.83%

    $ 748,680 0.00% $ 748,680 0.00% $ 8,984,160 $ 4,117,740 45.83%

    $ 499,120 0.00% $ 499,120 0.00% $ 5,989,440 $ 2,745,160 45.83%

    $ 70,000 0.00% $ 70,000 0.00% $ 840,000 $ 385,000 45.83%

    $ 134,182 $ - 0.00% $ 134,182 $ - 0.00% $ 1,610,182 $ 738,000 45.83%

    $ 134,182 0.00% $ 134,182 0.00% $ 1,610,182 $ 738,000 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 210,000 0.00% $ 210,000 0.00% $ 2,520,000 $ 1,155,000 45.83%

    $ 144,000 0.00% $ 144,000 0.00% $ 1,728,000 $ 792,000 45.83%

    $ 180,000 0.00% $ 180,000 0.00% $ 2,160,000 $ 990,000 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 360,000 0.00% $ 360,000 0.00% $ 4,320,000 $ 1,980,000 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 5,824,500 $ - 0.00% $ 5,824,500 $ - 0.00% $ 69,894,000 $ 32,034,750 45.83%

    $ 1,161,000 0.00% $ 1,161,000 0.00% $ 13,932,000 $ 6,385,500 45.83%

    $ 4,663,500 0.00% $ 4,663,500 0.00% $ 55,962,000 $ 25,649,250 45.83%

    $ 2,985,000 $ - 0.00% $ 2,985,000 $ - 0.00% $ 35,820,000 $ 16,417,500 45.83%

    $ 1,260,000 0.00% $ 1,260,000 0.00% $ 15,120,000 $ 6,930,000 45.83%

    $ 600,000 0.00% $ 600,000 0.00% $ 7,200,000 $ 3,300,000 45.83%

    $ 165,000 0.00% $ 165,000 0.00% $ 1,980,000 $ 907,500 45.83%

    $ 750,000 0.00% $ 750,000 0.00% $ 9,000,000 $ 4,125,000 45.83%

    $ 210,000 0.00% $ 210,000 0.00% $ 2,520,000 $ 1,155,000 45.83%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 48,056,265 $ - 0.00% $ 48,056,265 $ - 0.00% $ 576,675,185 $ 264,309,460 45.83%

  • PRESUPUESTO DE VENTAS (COMPRAS/GASTOS)

    January 2015 February 2015 March 2015

    DESCRIPCION PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    NMINA $ 10,434,242 $ 10,434,242 100.00% $ 10,434,242 $ 10,434,242 100.00% $ 10,434,242 $ 10,434,242 100.00%

    Sueldos $ 6,784,000 $ 6,784,000 100.00% $ 6,784,000 $ 6,784,000 100.00% $ 6,784,000 $ 6,784,000 100.00%

    Auxilio de Transporte $ 296,000 $ 296,000 100.00% $ 296,000 $ 296,000 100.00% $ 296,000 $ 296,000 100.00%

    Provision Cesantas $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00%

    Provision Intereses Sobre Cesantas $ 5,651 $ 5,651 100.00% $ 5,651 $ 5,651 100.00% $ 5,651 $ 5,651 100.00%

    Provision Prima de Servicios $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00%

    Provision Vacaciones $ 270,550 $ 270,550 100.00% $ 270,550 $ 270,550 100.00% $ 270,550 $ 270,550 100.00%

    Aportes A.R.L $ 33,867 $ 33,867 100.00% $ 33,867 $ 33,867 100.00% $ 33,867 $ 33,867 100.00%

    Aportes E.P.S. $ 551,480 $ 551,480 100.00% $ 551,480 $ 551,480 100.00% $ 551,480 $ 551,480 100.00%

    Aportes Fondo Pensiones $ 778,560 $ 778,560 100.00% $ 778,560 $ 778,560 100.00% $ 778,560 $ 778,560 100.00%

    Aportes Cajas de Compensacin Familiar $ 259,520 $ 259,520 100.00% $ 259,520 $ 259,520 100.00% $ 259,520 $ 259,520 100.00%

    Aportes I.C.B.F. $ 194,640 $ 194,640 100.00% $ 194,640 $ 194,640 100.00% $ 194,640 $ 194,640 100.00%

    Aportes SENA $ 129,760 $ 129,760 100.00% $ 129,760 $ 129,760 100.00% $ 129,760 $ 129,760 100.00%

    DOTACION $ 100,000 $ 100,000 100.00% $ 100,000 $ 100,000 100.00% $ 100,000 $ 100,000 100.00%

    IMPUESTOS $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00%

    Gravamen Movimiento Financiero $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00%

    Sobre Vehiculos $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    SEGUROS-VEHICULOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    INTERNET $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00%

    CELULARES $ 96,000 $ 96,000 100.00% $ 96,000 $ 96,000 100.00% $ 96,000 $ 96,000 100.00%

    ELEMENTOS DE ASEO Y CAFETERIA $ 120,000 $ 120,000 100.00% $ 120,000 $ 120,000 100.00% $ 120,000 $ 120,000 100.00%

    MANTENIMIENTO DE VEHICULOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    UTILES PAPELERIA Y FOTOCOPIAS $ 240,000 $ 240,000 100.00% $ 240,000 $ 240,000 100.00% $ 240,000 $ 240,000 100.00%

    COMBUSTIBLES $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    IMPUESTOS IMPORTACION $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! Arancel 10% $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    Seguro 2% $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    BODEGA $ 1,990,000 $ 1,990,000 100.00% $ 1,990,000 $ 1,990,000 100.00% $ 1,990,000 $ 1,990,000 100.00%

    VIGILANCIA $ 840,000 $ 840,000 100.00% $ 840,000 $ 840,000 100.00% $ 840,000 $ 840,000 100.00%

    ARRENDAMIENTOS $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00%

    ACUEDUCTO Y ALCANTARILLADO $ 110,000 $ 110,000 100.00% $ 110,000 $ 110,000 100.00% $ 110,000 $ 110,000 100.00%

    ENERGIA ELECTRICA $ 500,000 $ 500,000 100.00% $ 500,000 $ 500,000 100.00% $ 500,000 $ 500,000 100.00%

    TELEFONIA FIJA $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00%

    CLIENTES $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    TRANSPORTES, FLETES Y ACARREOS $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! GRAN TOTAL $ 13,156,979 $ 13,156,979 100.00% $ 13,156,979 $ 13,156,979 100.00% $ 13,156,979 $ 13,156,979 100.00%

  • April 2015 May 2015 June 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 10,434,242 $ 10,434,242 100.00% $ 10,434,242 $ 10,434,242 100.00% $ 10,434,242 $ 5,217,121 50.00%

    $ 6,784,000 $ 6,784,000 100.00% $ 6,784,000 $ 6,784,000 100.00% $ 6,784,000 $ 3,392,000 50.00%

    $ 296,000 $ 296,000 100.00% $ 296,000 $ 296,000 100.00% $ 296,000 $ 148,000 50.00%

    $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00% $ 565,107 $ 282,554 50.00%

    $ 5,651 $ 5,651 100.00% $ 5,651 $ 5,651 100.00% $ 5,651 $ 2,826 50.00%

    $ 565,107 $ 565,107 100.00% $ 565,107 $ 565,107 100.00% $ 565,107 $ 282,554 50.00%

    $ 270,550 $ 270,550 100.00% $ 270,550 $ 270,550 100.00% $ 270,550 $ 135,275 50.00%

    $ 33,867 $ 33,867 100.00% $ 33,867 $ 33,867 100.00% $ 33,867 $ 16,934 50.00%

    $ 551,480 $ 551,480 100.00% $ 551,480 $ 551,480 100.00% $ 551,480 $ 275,740 50.00%

    $ 778,560 $ 778,560 100.00% $ 778,560 $ 778,560 100.00% $ 778,560 $ 389,280 50.00%

    $ 259,520 $ 259,520 100.00% $ 259,520 $ 259,520 100.00% $ 259,520 $ 129,760 50.00%

    $ 194,640 $ 194,640 100.00% $ 194,640 $ 194,640 100.00% $ 194,640 $ 97,320 50.00%

    $ 129,760 $ 129,760 100.00% $ 129,760 $ 129,760 100.00% $ 129,760 $ 64,880 50.00%

    $ 100,000 $ 100,000 100.00% $ 100,000 $ 100,000 100.00% $ 100,000 $ 50,000 50.00%

    $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00% $ 36,737 $ 18,368 50.00%

    $ 36,737 $ 36,737 100.00% $ 36,737 $ 36,737 100.00% $ 36,737 $ 18,368 50.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00% $ 140,000 $ 70,000 50.00%

    $ 96,000 $ 96,000 100.00% $ 96,000 $ 96,000 100.00% $ 96,000 $ 48,000 50.00%

    $ 120,000 $ 120,000 100.00% $ 120,000 $ 120,000 100.00% $ 120,000 $ 60,000 50.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 240,000 $ 240,000 100.00% $ 240,000 $ 240,000 100.00% $ 240,000 $ 120,000 50.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 1,990,000 $ 1,990,000 100.00% $ 1,990,000 $ 1,990,000 100.00% $ 1,990,000 $ 953,667 47.92%

    $ 840,000 $ 840,000 100.00% $ 840,000 $ 840,000 100.00% $ 840,000 $ 420,000 50.00%

    $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00% $ 400,000 $ 200,000 50.00%

    $ 110,000 $ 110,000 100.00% $ 110,000 $ 110,000 100.00% $ 110,000 $ 55,000 50.00%

    $ 500,000 $ 500,000 100.00% $ 500,000 $ 500,000 100.00% $ 500,000 $ 166,667 33.33%

    $ 140,000 $ 140,000 100.00% $ 140,000 $ 140,000 100.00% $ 140,000 $ 112,000 80.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 13,156,979 $ 13,156,979 100.00% $ 13,156,979 $ 13,156,979 100.00% $ 13,156,979 $ 6,537,156 49.69%

  • July 2015 August 2015 September 2015 October 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 10,434,242 $ - 0.00% $ 10,434,242 $ - 0.00% $ 10,434,242 $ - 0.00% $ 10,434,242 $ - 0.00%

    $ 6,784,000 0.00% $ 6,784,000 0.00% $ 6,784,000 0.00% $ 6,784,000 0.00%

    $ 296,000 0.00% $ 296,000 0.00% $ 296,000 0.00% $ 296,000 0.00%

    $ 565,107 0.00% $ 565,107 0.00% $ 565,107 0.00% $ 565,107 0.00%

    $ 5,651 0.00% $ 5,651 0.00% $ 5,651 0.00% $ 5,651 0.00%

    $ 565,107 0.00% $ 565,107 0.00% $ 565,107 0.00% $ 565,107 0.00%

    $ 270,550 0.00% $ 270,550 0.00% $ 270,550 0.00% $ 270,550 0.00%

    $ 33,867 0.00% $ 33,867 0.00% $ 33,867 0.00% $ 33,867 0.00%

    $ 551,480 0.00% $ 551,480 0.00% $ 551,480 0.00% $ 551,480 0.00%

    $ 778,560 0.00% $ 778,560 0.00% $ 778,560 0.00% $ 778,560 0.00%

    $ 259,520 0.00% $ 259,520 0.00% $ 259,520 0.00% $ 259,520 0.00%

    $ 194,640 0.00% $ 194,640 0.00% $ 194,640 0.00% $ 194,640 0.00%

    $ 129,760 0.00% $ 129,760 0.00% $ 129,760 0.00% $ 129,760 0.00%

    $ 100,000 0.00% $ 100,000 0.00% $ 100,000 0.00% $ 100,000 0.00%

    $ 36,737 $ - 0.00% $ 36,737 $ - 0.00% $ 36,737 $ - 0.00% $ 36,737 $ - 0.00%

    $ 36,737 0.00% $ 36,737 0.00% $ 36,737 0.00% $ 36,737 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 140,000 0.00% $ 140,000 0.00% $ 140,000 0.00% $ 140,000 0.00%

    $ 96,000 0.00% $ 96,000 0.00% $ 96,000 0.00% $ 96,000 0.00%

    $ 120,000 0.00% $ 120,000 0.00% $ 120,000 0.00% $ 120,000 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 240,000 0.00% $ 240,000 0.00% $ 240,000 0.00% $ 240,000 0.00%

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 1,990,000 $ - 0.00% $ 1,990,000 $ - 0.00% $ 1,990,000 $ - 0.00% $ 1,990,000 $ - 0.00%

    $ 840,000 0.00% $ 840,000 0.00% $ 840,000 0.00% $ 840,000 0.00%

    $ 400,000 0.00% $ 400,000 0.00% $ 400,000 0.00% $ 400,000 0.00%

    $ 110,000 0.00% $ 110,000 0.00% $ 110,000 0.00% $ 110,000 0.00%

    $ 500,000 0.00% $ 500,000 0.00% $ 500,000 0.00% $ 500,000 0.00%

    $ 140,000 0.00% $ 140,000 0.00% $ 140,000 0.00% $ 140,000 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - #DIV/0! $ - #DIV/0!

    $ 13,156,979 $ - 0.00% $ 13,156,979 $ - 0.00% $ 13,156,979 $ - 0.00% $ 13,156,979 $ - 0.00%

  • November 2015 December 2015 TOTAL 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 10,434,242 $ - 0.00% $ 10,434,242 $ - 0.00% $ 125,210,909 $ 57,388,333 45.83%

    $ 6,784,000 0.00% $ 6,784,000 0.00% $ 81,408,000 $ 37,312,000 45.83%

    $ 296,000 0.00% $ 296,000 0.00% $ 3,552,000 $ 1,628,000 45.83%

    $ 565,107 0.00% $ 565,107 0.00% $ 6,781,286 $ 3,108,090 45.83%

    $ 5,651 0.00% $ 5,651 0.00% $ 67,813 $ 31,081 45.83%

    $ 565,107 0.00% $ 565,107 0.00% $ 6,781,286 $ 3,108,090 45.83%

    $ 270,550 0.00% $ 270,550 0.00% $ 3,246,595 $ 1,488,023 45.83%

    $ 33,867 0.00% $ 33,867 0.00% $ 406,408 $ 186,270 45.83%

    $ 551,480 0.00% $ 551,480 0.00% $ 6,617,760 $ 3,033,140 45.83%

    $ 778,560 0.00% $ 778,560 0.00% $ 9,342,720 $ 4,282,080 45.83%

    $ 259,520 0.00% $ 259,520 0.00% $ 3,114,240 $ 1,427,360 45.83%

    $ 194,640 0.00% $ 194,640 0.00% $ 2,335,680 $ 1,070,520 45.83%

    $ 129,760 0.00% $ 129,760 0.00% $ 1,557,120 $ 713,680 45.83%

    $ 100,000 0.00% $ 100,000 0.00% $ 1,200,000 $ 550,000 45.83%

    $ 36,737 $ - 0.00% $ 36,737 $ - 0.00% $ 440,840 $ 202,052 45.83%

    $ 36,737 0.00% $ 36,737 0.00% $ 440,840 $ 202,052 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 140,000 0.00% $ 140,000 0.00% $ 1,680,000 $ 770,000 45.83%

    $ 96,000 0.00% $ 96,000 0.00% $ 1,152,000 $ 528,000 45.83%

    $ 120,000 0.00% $ 120,000 0.00% $ 1,440,000 $ 660,000 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 240,000 0.00% $ 240,000 0.00% $ 2,880,000 $ 1,320,000 45.83%

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 1,990,000 $ - 0.00% $ 1,990,000 $ - 0.00% $ 23,880,000 $ 10,903,667 45.66%

    $ 840,000 0.00% $ 840,000 0.00% $ 10,080,000 $ 4,620,000 45.83%

    $ 400,000 0.00% $ 400,000 0.00% $ 4,800,000 $ 2,200,000 45.83%

    $ 110,000 0.00% $ 110,000 0.00% $ 1,320,000 $ 605,000 45.83%

    $ 500,000 0.00% $ 500,000 0.00% $ 6,000,000 $ 2,666,667 44.44%

    $ 140,000 0.00% $ 140,000 0.00% $ 1,680,000 $ 812,000 48.33%

    $ - $ - #DIV/0! $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0! $ - $ - #DIV/0!

    $ 13,156,979 $ - 0.00% $ 13,156,979 $ - 0.00% $ 157,883,749 $ 72,322,052 45.81%

  • PRESUPUESTO DE OPERACION (COMPRAS/GASTOS)

    January 2015

    DESCRIPCION PROGRAMADO EJECUTADO % EJEC

    NMINA $ 58,181,796 $ 58,181,796 100.00%

    Sueldos $ 37,386,000 $ 37,386,000 100.00%

    Auxilio de Transporte $ 2,664,000 $ 2,664,000 100.00%

    Provision Cesantas $ 3,114,254 $ 3,114,254 100.00%

    Provision Intereses Sobre Cesantas $ 31,143 $ 31,143 100.00%

    Provision Prima de Servicios $ 3,114,254 $ 3,114,254 100.00%

    Provision Vacaciones $ 1,447,907 $ 1,447,907 100.00%

    Aportes A.R.L $ 181,249 $ 181,249 100.00%

    Aportes E.P.S. $ 2,951,370 $ 2,951,370 100.00%

    Aportes Fondo Pensiones $ 4,166,640 $ 4,166,640 100.00%

    Aportes Cajas de Compensacin Familiar $ 1,388,880 $ 1,388,880 100.00%

    Aportes I.C.B.F. $ 1,041,660 $ 1,041,660 100.00%

    Aportes SENA $ 694,440 $ 694,440 100.00%

    DOTACION $ 837,500 $ 837,500 100.00% IMPUESTOS $ 196,236 $ 196,236 100.00%

    Gravamen Movimiento Financiero $ 196,236 $ 196,236 100.00% Sobre Vehiculos $ - $ - #DIV/0!

    SEGUROS-VEHICULOS $ - $ - #DIV/0! INTERNET $ 350,000 $ 350,000 100.00% CELULARES $ 240,000 $ 240,000 100.00% ELEMENTOS DE ASEO Y CAFETERIA $ 300,000 $ 300,000 100.00% MANTENIMIENTO DE VEHICULOS $ 400,000 $ 400,000 100.00% UTILES PAPELERIA Y FOTOCOPIAS $ 600,000 $ 600,000 100.00% COMBUSTIBLES $ 1,200,000 $ 1,200,000 100.00% IMPUESTOS IMPORTACION $ - $ - #DIV/0!

    Arancel 10% $ - $ - #DIV/0!

    Seguro 2% $ - $ - #DIV/0!

    BODEGA $ 4,975,000 $ 4,975,000 100.00%

    VIGILANCIA $ 2,100,000 $ 2,100,000 100.00%

    ARRENDAMIENTOS $ 1,000,000 $ 1,000,000 100.00%

    ACUEDUCTO Y ALCANTARILLADO $ 275,000 $ 275,000 100.00%

    ENERGIA ELECTRICA $ 1,250,000 $ 1,250,000 100.00%

    TELEFONIA FIJA $ 350,000 $ 350,000 100.00%

    CLIENTES $ 3,000,000 $ 3,000,000 100.00%

    TRANSPORTES, FLETES Y ACARREOS $ 3,000,000 $ 3,000,000 100.00% GRAN TOTAL $ 70,280,532 $ 70,280,532 100.00%

  • February 2015 March 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ 58,181,796 100.00% $ 58,181,796 $ 58,181,796 100.00%

    $ 37,386,000 $ 37,386,000 100.00% $ 37,386,000 $ 37,386,000 100.00%

    $ 2,664,000 $ 2,664,000 100.00% $ 2,664,000 $ 2,664,000 100.00%

    $ 3,114,254 $ 3,114,254 100.00% $ 3,114,254 $ 3,114,254 100.00%

    $ 31,143 $ 31,143 100.00% $ 31,143 $ 31,143 100.00%

    $ 3,114,254 $ 3,114,254 100.00% $ 3,114,254 $ 3,114,254 100.00%

    $ 1,447,907 $ 1,447,907 100.00% $ 1,447,907 $ 1,447,907 100.00%

    $ 181,249 $ 181,249 100.00% $ 181,249 $ 181,249 100.00%

    $ 2,951,370 $ 2,951,370 100.00% $ 2,951,370 $ 2,951,370 100.00%

    $ 4,166,640 $ 4,166,640 100.00% $ 4,166,640 $ 4,166,640 100.00%

    $ 1,388,880 $ 1,388,880 100.00% $ 1,388,880 $ 1,388,880 100.00%

    $ 1,041,660 $ 1,041,660 100.00% $ 1,041,660 $ 1,041,660 100.00%

    $ 694,440 $ 694,440 100.00% $ 694,440 $ 694,440 100.00%

    $ 837,500 $ 837,500 100.00% $ 837,500 $ 837,500 100.00%

    $ 196,236 $ 196,236 100.00% $ 196,236 $ 196,236 100.00%

    $ 196,236 $ 196,236 100.00% $ 196,236 $ 196,236 100.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 350,000 $ 350,000 100.00% $ 350,000 $ 350,000 100.00%

    $ 240,000 $ 240,000 100.00% $ 240,000 $ 240,000 100.00%

    $ 300,000 $ 300,000 100.00% $ 300,000 $ 300,000 100.00%

    $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00%

    $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00%

    $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 4,975,000 $ 4,975,000 100.00% $ 4,975,000 $ 4,975,000 100.00%

    $ 2,100,000 $ 2,100,000 100.00% $ 2,100,000 $ 2,100,000 100.00%

    $ 1,000,000 $ 1,000,000 100.00% $ 1,000,000 $ 1,000,000 100.00%

    $ 275,000 $ 275,000 100.00% $ 275,000 $ 275,000 100.00%

    $ 1,250,000 $ 1,250,000 100.00% $ 1,250,000 $ 1,250,000 100.00%

    $ 350,000 $ 350,000 100.00% $ 350,000 $ 350,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 70,280,532 $ 70,280,532 100.00% $ 70,280,532 $ 70,280,532 100.00%

  • April 2015 May 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ 58,181,796 100.00% $ 58,181,796 $ 58,181,796 100.00%

    $ 37,386,000 $ 37,386,000 100.00% $ 37,386,000 $ 37,386,000 100.00%

    $ 2,664,000 $ 2,664,000 100.00% $ 2,664,000 $ 2,664,000 100.00%

    $ 3,114,254 $ 3,114,254 100.00% $ 3,114,254 $ 3,114,254 100.00%

    $ 31,143 $ 31,143 100.00% $ 31,143 $ 31,143 100.00%

    $ 3,114,254 $ 3,114,254 100.00% $ 3,114,254 $ 3,114,254 100.00%

    $ 1,447,907 $ 1,447,907 100.00% $ 1,447,907 $ 1,447,907 100.00%

    $ 181,249 $ 181,249 100.00% $ 181,249 $ 181,249 100.00%

    $ 2,951,370 $ 2,951,370 100.00% $ 2,951,370 $ 2,951,370 100.00%

    $ 4,166,640 $ 4,166,640 100.00% $ 4,166,640 $ 4,166,640 100.00%

    $ 1,388,880 $ 1,388,880 100.00% $ 1,388,880 $ 1,388,880 100.00%

    $ 1,041,660 $ 1,041,660 100.00% $ 1,041,660 $ 1,041,660 100.00%

    $ 694,440 $ 694,440 100.00% $ 694,440 $ 694,440 100.00%

    $ 837,500 $ 837,500 100.00% $ 837,500 $ 837,500 100.00%

    $ 196,236 $ 196,236 100.00% $ 196,236 $ 196,236 100.00%

    $ 196,236 $ 196,236 100.00% $ 196,236 $ 196,236 100.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 350,000 $ 350,000 100.00% $ 350,000 $ 350,000 100.00%

    $ 240,000 $ 240,000 100.00% $ 240,000 $ 240,000 100.00%

    $ 300,000 $ 300,000 100.00% $ 300,000 $ 300,000 100.00%

    $ 400,000 $ 400,000 100.00% $ 400,000 $ 400,000 100.00%

    $ 600,000 $ 600,000 100.00% $ 600,000 $ 600,000 100.00%

    $ 1,200,000 $ 1,200,000 100.00% $ 1,200,000 $ 1,200,000 100.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ 4,975,000 $ 4,975,000 100.00% $ 4,975,000 $ 4,975,000 100.00%

    $ 2,100,000 $ 2,100,000 100.00% $ 2,100,000 $ 2,100,000 100.00%

    $ 1,000,000 $ 1,000,000 100.00% $ 1,000,000 $ 1,000,000 100.00%

    $ 275,000 $ 275,000 100.00% $ 275,000 $ 275,000 100.00%

    $ 1,250,000 $ 1,250,000 100.00% $ 1,250,000 $ 1,250,000 100.00%

    $ 350,000 $ 350,000 100.00% $ 350,000 $ 350,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 3,000,000 $ 3,000,000 100.00% $ 3,000,000 $ 3,000,000 100.00%

    $ 70,280,532 $ 70,280,532 100.00% $ 70,280,532 $ 70,280,532 100.00%

  • June 2015 July 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ 29,090,898 50.00% $ 58,181,796 $ - 0.00% $ 37,386,000 $ 18,693,000 50.00% $ 37,386,000 0.00%

    $ 2,664,000 $ 1,332,000 50.00% $ 2,664,000 0.00%

    $ 3,114,254 $ 1,557,127 50.00% $ 3,114,254 0.00%

    $ 31,143 $ 15,571 50.00% $ 31,143 0.00%

    $ 3,114,254 $ 1,557,127 50.00% $ 3,114,254 0.00%

    $ 1,447,907 $ 723,954 50.00% $ 1,447,907 0.00%

    $ 181,249 $ 90,624 50.00% $ 181,249 0.00%

    $ 2,951,370 $ 1,475,685 50.00% $ 2,951,370 0.00%

    $ 4,166,640 $ 2,083,320 50.00% $ 4,166,640 0.00%

    $ 1,388,880 $ 694,440 50.00% $ 1,388,880 0.00%

    $ 1,041,660 $ 520,830 50.00% $ 1,041,660 0.00%

    $ 694,440 $ 347,220 50.00% $ 694,440 0.00%

    $ 837,500 $ 418,750 50.00% $ 837,500 0.00%

    $ 196,236 $ 98,118 50.00% $ 196,236 $ - 0.00%

    $ 196,236 $ 98,118 50.00% $ 196,236 0.00%

    $ - $ - #DIV/0! $ - #DIV/0!

    $ - $ - #DIV/0! $ - #DIV/0! $ 350,000 $ 175,000 50.00% $ 350,000 0.00%

    $ 240,000 $ 120,000 50.00% $ 240,000 0.00%

    $ 300,000 $ 150,000 50.00% $ 300,000 0.00%

    $ 400,000 $ 200,000 50.00% $ 400,000 0.00%

    $ 600,000 $ 300,000 50.00% $ 600,000 0.00%

    $ 1,200,000 $ 600,000 50.00% $ 1,200,000 0.00% $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - $ - #DIV/0! $ - #DIV/0!

    $ - $ - #DIV/0! $ - #DIV/0!

    $ 4,975,000 $ 2,429,167 48.83% $ 4,975,000 $ - 0.00%

    $ 2,100,000 $ 1,050,000 50.00% $ 2,100,000 0.00%

    $ 1,000,000 $ 500,000 50.00% $ 1,000,000 0.00%

    $ 275,000 $ 137,500 50.00% $ 275,000 0.00%

    $ 1,250,000 $ 625,000 50.00% $ 1,250,000 0.00%

    $ 350,000 $ 116,667 33.33% $ 350,000 0.00%

    $ 3,000,000 $ 600,000 20.00% $ 3,000,000 $ - 0.00%

    $ 3,000,000 $ 600,000 20.00% $ 3,000,000 0.00%

    $ 70,280,532 $ 34,181,933 48.64% $ 70,280,532 $ - 0.00%

  • August 2015 September 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ - 0.00% $ 58,181,796 $ - 0.00%

    $ 37,386,000 0.00% $ 37,386,000 0.00%

    $ 2,664,000 0.00% $ 2,664,000 0.00%

    $ 3,114,254 0.00% $ 3,114,254 0.00%

    $ 31,143 0.00% $ 31,143 0.00%

    $ 3,114,254 0.00% $ 3,114,254 0.00%

    $ 1,447,907 0.00% $ 1,447,907 0.00%

    $ 181,249 0.00% $ 181,249 0.00%

    $ 2,951,370 0.00% $ 2,951,370 0.00%

    $ 4,166,640 0.00% $ 4,166,640 0.00%

    $ 1,388,880 0.00% $ 1,388,880 0.00%

    $ 1,041,660 0.00% $ 1,041,660 0.00%

    $ 694,440 0.00% $ 694,440 0.00%

    $ 837,500 0.00% $ 837,500 0.00%

    $ 196,236 $ - 0.00% $ 196,236 $ - 0.00%

    $ 196,236 0.00% $ 196,236 0.00%

    $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ 350,000 0.00% $ 350,000 0.00%

    $ 240,000 0.00% $ 240,000 0.00%

    $ 300,000 0.00% $ 300,000 0.00%

    $ 400,000 0.00% $ 400,000 0.00%

    $ 600,000 0.00% $ 600,000 0.00%

    $ 1,200,000 0.00% $ 1,200,000 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ 4,975,000 $ - 0.00% $ 4,975,000 $ - 0.00%

    $ 2,100,000 0.00% $ 2,100,000 0.00%

    $ 1,000,000 0.00% $ 1,000,000 0.00%

    $ 275,000 0.00% $ 275,000 0.00%

    $ 1,250,000 0.00% $ 1,250,000 0.00%

    $ 350,000 0.00% $ 350,000 0.00%

    $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 3,000,000 0.00% $ 3,000,000 0.00%

    $ 70,280,532 $ - 0.00% $ 70,280,532 $ - 0.00%

  • October 2015 November 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ - 0.00% $ 58,181,796 $ - 0.00%

    $ 37,386,000 0.00% $ 37,386,000 0.00%

    $ 2,664,000 0.00% $ 2,664,000 0.00%

    $ 3,114,254 0.00% $ 3,114,254 0.00%

    $ 31,143 0.00% $ 31,143 0.00%

    $ 3,114,254 0.00% $ 3,114,254 0.00%

    $ 1,447,907 0.00% $ 1,447,907 0.00%

    $ 181,249 0.00% $ 181,249 0.00%

    $ 2,951,370 0.00% $ 2,951,370 0.00%

    $ 4,166,640 0.00% $ 4,166,640 0.00%

    $ 1,388,880 0.00% $ 1,388,880 0.00%

    $ 1,041,660 0.00% $ 1,041,660 0.00%

    $ 694,440 0.00% $ 694,440 0.00%

    $ 837,500 0.00% $ 837,500 0.00%

    $ 196,236 $ - 0.00% $ 196,236 $ - 0.00%

    $ 196,236 0.00% $ 196,236 0.00%

    $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ 350,000 0.00% $ 350,000 0.00%

    $ 240,000 0.00% $ 240,000 0.00%

    $ 300,000 0.00% $ 300,000 0.00%

    $ 400,000 0.00% $ 400,000 0.00%

    $ 600,000 0.00% $ 600,000 0.00%

    $ 1,200,000 0.00% $ 1,200,000 0.00%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ - #DIV/0! $ - #DIV/0!

    $ 4,975,000 $ - 0.00% $ 4,975,000 $ - 0.00%

    $ 2,100,000 0.00% $ 2,100,000 0.00%

    $ 1,000,000 0.00% $ 1,000,000 0.00%

    $ 275,000 0.00% $ 275,000 0.00%

    $ 1,250,000 0.00% $ 1,250,000 0.00%

    $ 350,000 0.00% $ 350,000 0.00%

    $ 3,000,000 $ - 0.00% $ 3,000,000 $ - 0.00%

    $ 3,000,000 0.00% $ 3,000,000 0.00%

    $ 70,280,532 $ - 0.00% $ 70,280,532 $ - 0.00%

  • December 2015 TOTAL 2015

    PROGRAMADO EJECUTADO % EJEC PROGRAMADO EJECUTADO % EJEC

    $ 58,181,796 $ - 0.00% $ 698,181,557 $ 319,999,880 45.83%

    $ 37,386,000 0.00% $ 448,632,000 $ 205,623,000 45.83%

    $ 2,664,000 0.00% $ 31,968,000 $ 14,652,000 45.83%

    $ 3,114,254 0.00% $ 37,371,046 $ 17,128,396 45.83%

    $ 31,143 0.00% $ 373,710 $ 171,284 45.83%

    $ 3,114,254 0.00% $ 37,371,046 $ 17,128,396 45.83%

    $ 1,447,907 0.00% $ 17,374,889 $ 7,963,491 45.83%

    $ 181,249 0.00% $ 2,174,986 $ 996,869 45.83%

    $ 2,951,370 0.00% $ 35,416,440 $ 16,232,535 45.83%

    $ 4,166,640 0.00% $ 49,999,680 $ 22,916,520 45.83%

    $ 1,388,880 0.00% $ 16,666,560 $ 7,638,840 45.83%

    $ 1,041,660 0.00% $ 12,499,920 $ 5,729,130 45.83%

    $ 694,440 0.00% $ 8,333,280 $ 3,819,420 45.83%

    $ 837,500 0.00% $ 10,050,000 $ 4,606,250 45.83%

    $ 196,236 $ - 0.00% $ 2,354,832 $ 1,079,298 45.83%

    $ 196,236 0.00% $ 2,354,832 $ 1,079,298 45.83%

    $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - $ - #DIV/0!

    $ 350,000 0.00% $ 4,200,000 $ 1,925,000 45.83%

    $ 240,000 0.00% $ 2,880,000 $ 1,320,000 45.83%

    $ 300,000 0.00% $ 3,600,000 $ 1,650,000 45.83%

    $ 400,000 0.00% $ 4,800,000 $ 2,200,000 45.83%

    $ 600,000 0.00% $ 7,200,000 $ 3,300,000 45.83%

    $ 1,200,000 0.00% $ 14,400,000 $ 6,600,000 45.83%

    $ - $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - $ - #DIV/0!

    $ - #DIV/0! $ - $ - #DIV/0!

    $ 4,975,000 $ - 0.00% $ 59,700,000 $ 27,304,167 45.74%

    $ 2,100,000 0.00% $ 25,200,000 $ 11,550,000 45.83%

    $ 1,000,000 0.00% $ 12,000,000 $ 5,500,000 45.83%

    $ 275,000 0.00% $ 3,300,000 $ 1,512,500 45.83%

    $ 1,250,000 0.00% $ 15,000,000 $ 6,875,000 45.83%

    $ 350,000 0.00% $ 4,200,000 $ 1,866,667 44.44%

    $ 3,000,000 $ - 0.00% $ 36,000,000 $ 15,600,000 43.33%

    $ 3,000,000 0.00% $ 36,000,000 $ 15,600,000 43.33%

    $ 70,280,532 $ - 0.00% $ 843,366,389 $ 385,584,595 45.72%

  • EJECUTADO DE Ao 2014

    COMPRAS Mensual Anual

    Producto / Servicio

    capacidad

    v/r Producto

    unidades Comp. V/r Compras

    Mensual

    iva 16%

    descontable

    V/r Total Compra

    unidades Comp.

    V/r Compras Anual iva 16%

    descontable

    V/r Total Compra

    Pantallas lcd Hp 19" $ 89,676 35 $ 3,138,660 $ 502,186 $ 3,640,846 420 $ 37,663,920 $ 6,026,227 $ 43,690,147 Pantallas lcd Hp 21" $ 143,100 35 $ 5,008,500 $ 801,360 $ 5,809,860 420 $ 60,102,000 $ 9,616,320 $ 69,718,320

    Pantallas lcd Dell 19" $ 115,434 35 $ 4,040,190 $ 646,430 $ 4,686,620 420 $ 48,482,280 $ 7,757,165 $ 56,239,445

    Pantallas lcd Dell 21" $ 150,732 35 $ 5,275,620 $ 844,099 $ 6,119,719 420 $ 63,307,440 $ 10,129,190 $ 73,436,630

    Pantallas lcd Lenovo 19" $ 97,308 35 $ 3,405,780 $ 544,925 $ 3,950,705 420 $ 40,869,360 $ 6,539,098 $ 47,408,458 Pantallas lcd Lenovo 21" $ 142,146 35 $ 4,975,110 $ 796,018 $ 5,771,128 420 $ 59,701,320 $ 9,552,211 $ 69,253,531

    memoria ram de 2gb $ 23,850 35 $ 834,750 $ 133,560 $ 968,310 420 $ 10,017,000 $ 1,602,720 $ 11,619,720

    memoria ram de 4gb $ 62,010 35 $ 2,170,350 $ 347,256 $ 2,517,606 420 $ 26,044,200 $ 4,167,072 $ 30,211,272

    memoria ram de 8gb $ 133,560 35 $ 4,674,600 $ 747,936 $ 5,422,536 420 $ 56,095,200 $ 8,975,232 $ 65,070,432 Procesador Intel core i3 $ 305,280 35 $ 10,684,800 $ 1,709,568 $ 12,394,368 420 $ 128,217,600 $ 20,514,816 $ 148,732,416

    Procesador Intel core i5 $ 419,760 35 $ 14,691,600 $ 2,350,656 $ 17,042,256 420 $ 176,299,200 $ 28,207,872 $ 204,507,072

    Procesador Intel core i7 $ 572,400 35 $ 20,034,000 $ 3,205,440 $ 23,239,440 420 $ 240,408,000 $ 38,465,280 $ 278,873,280

    Procesador Amd fx 8350 $ 314,820 35 $ 11,018,700 $ 1,762,992 $ 12,781,692 420 $ 132,224,400 $ 21,155,904 $ 153,380,304 Board Astroc G41c $ 128,790 35 $ 4,507,650 $ 721,224 $ 5,228,874 420 $ 54,091,800 $ 8,654,688 $ 62,746,488

    Board Intel 1150 $ 162,180 35 $ 5,676,300 $ 908,208 $ 6,584,508 420 $ 68,115,600 $ 10,898,496 $ 79,014,096

    Board Asus M5a97 $ 171,720 35 $ 6,010,200 $ 961,632 $ 6,971,832 420 $ 72,122,400 $ 11,539,584 $ 83,661,984

    Board Asus Amd $ 141,192 35 $ 4,941,720 $ 790,675 $ 5,732,395 420 $ 59,300,640 $ 9,488,102 $ 68,788,742 Fuente de Poder Cooler Master Gx li 550w $ 145,962 35 $ 5,108,670 $ 817,387 $ 5,926,057 420 $ 61,304,040 $ 9,808,646 $ 71,112,686

    Fuente de Poder Corsair Cs 750m-80 $ 142,146 35 $ 4,975,110 $ 796,018 $ 5,771,128 420 $ 59,701,320 $ 9,552,211 $ 69,253,531

    Disco Duro 1 tera dell, lenovo, toshiba $ 100,170 35 $ 3,505,950 $ 560,952 $ 4,066,902 420 $ 42,071,400 $ 6,731,424 $ 48,802,824

    Disco Duro 2 teras dell, lenovo, toshiba $ 152,640 35 $ 5,342,400 $ 854,784 $ 6,197,184 420 $ 64,108,800 $ 10,257,408 $ 74,366,208 Disco Duro 3 teras dell, lenovo, toshiba $ 228,960 35 $ 8,013,600 $ 1,282,176 $ 9,295,776 420 $ 96,163,200 $ 15,386,112 $ 111,549,312

    Disco Duro 4 teras dell, lenovo, toshiba $ 291,924 35 $ 10,217,340 $ 1,634,774 $ 11,852,114 420 $ 122,608,080 $ 19,617,293 $ 142,225,373

    Compu Portatil DELL Inspiron 15-5548 core I7 $ 1,669,500 35 $ 58,432,500 $ 9,349,200 $ 67,781,700 420 $ 701,190,000 $ 112,190,400 $ 813,380,400

    Compu Portatil DELL Inspiron 15 Tactil $ 896,760 35 $ 31,386,600 $ - $ 31,386,600 420 $ 376,639,200 $ - $ 376,639,200 Compu Portatil DELL Ultrabook Core I7 $ 934,920 35 $ 32,722,200 $ - $ 32,722,200 420 $ 392,666,400 $ - $ 392,666,400

    Compu Portatil DELL Inspiron 14z Core I7 $ 867,186 35 $ 30,351,510 $ - $ 30,351,510 420 $ 364,218,120 $ - $ 364,218,120

    Compu Portatil LENOVO Core I7 $ 982,620 35 $ 34,391,700 $ - $ 34,391,700 420 $ 412,700,400 $ - $ 412,700,400

    Compu Portatil LENOVO Flex 2 Core I7 $ 1,099,008 35 $ 38,465,280 $ - $ 38,465,280 420 $ 461,583,360 $ - $ 461,583,360 Compu Portatil LENOVO Notebook Core I5 $ 930,150 35 $ 32,555,250 $ - $ 32,555,250 420 $ 390,663,000 $ - $ 390,663,000

    Compu Portatil HP Envy Core I7 $ 1,144,800 35 $ 40,068,000 $ - $ 40,068,000 420 $ 480,816,000 $ - $ 480,816,000

    Compu Portatil HP Dv6 7048la Core I7 $ 919,656 35 $ 32,187,960 $ - $ 32,187,960 420 $ 386,255,520 $ - $ 386,255,520

    Compu Portatil HP intel Core I5 4ta Generacion $ 818,532 35 $ 28,648,620 $ - $ 28,648,620 420 $ 343,783,440 $ - $ 343,783,440 Unidad Dvd Optica Sata $ 65,826 35 $ 2,303,910 $ 368,626 $ 2,672,536 420 $ 27,646,920 $ 4,423,507 $ 32,070,427

    Unidad Blueray Sata 3d $ 109,710 35 $ 3,839,850 $ 614,376 $ 4,454,226 420 $ 46,078,200 $ 7,372,512 $ 53,450,712

    Mouse Vertical optico Usb $ 31,482 35 $ 1,101,870 $ 176,299 $ 1,278,169 420 $ 13,222,440 $ 2,115,590 $ 15,338,030

    Mouse Raton optico Usb $ 16,218 35 $ 567,630 $ 90,821 $ 658,451 420 $ 6,811,560 $ 1,089,850 $ 7,901,410 Mouse Vertical Inalambrico $ 56,763 35 $ 1,986,705 $ 317,873 $ 2,304,578 420 $ 23,840,460 $ 3,814,474 $ 27,654,934

    Mouse Raton Inalambrico $ 19,080 35 $ 667,800 $ 106,848 $ 774,648 420 $ 8,013,600 $ 1,282,176 $ 9,295,776

    Teclado usb $ 14,310 35 $ 500,850 $ 80,136 $ 580,986 420 $ 6,010,200 $ 961,632 $ 6,971,832

    Teclado Inalambrico $ 17,649 35 $ 617,715 $ 98,834 $ 716,549 420 $ 7,412,580 $ 1,186,013 $ 8,598,593 Mtto Por Garantia pc $ 133,500

    Mtto Por Garantia Portatil $ 140,000

    TOTALES 1,435 $ 519,047,550 $ 34,923,269 $ 553,970,819 17,220 $ 6,228,570,600 $ 419,079,226 $ 6,647,649,826

  • COMPRAS Y VENTAS AO 2014

    Ao 2014 VENTAS Mensual Anual

    v/r Producto

    Utilidad 50%

    unidades Comp.

    V/r Ventas Mensual

    iva 16% Generado V/r Total de la

    Venta

    unidades Comp.

    V/r Ventas Anual

    iva 16% Generado

    V/r Total de la Venta

    $ 104,024 $ 52,012 33 $ 5,133,592 $ 821,375 $ 5,954,967 395 $ 61,603,108 $ 9,856,497 $ 71,459,605 $ 165,996 $ 82,998 33 $ 8,191,903 $ 1,310,704 $ 9,502,607 395 $ 65,535,221 $ 10,485,635 $ 76,020,856 $ 133,903 $ 66,952 33 $ 6,608,135 $ 1,057,302 $ 7,665,436 395 $ 52,865,078 $ 8,458,412 $ 61,323,491 $ 174,849 $ 87,425 33 $ 8,628,804 $ 1,380,609 $ 10,009,413 395 $ 69,030,433 $ 11,044,869 $ 80,075,302 $ 112,877 $ 56,439 33 $ 5,570,494 $ 891,279 $ 6,461,773 395 $ 44,563,950 $ 7,130,232 $ 51,694,182 $ 164,889 $ 82,445 33 $ 8,137,290 $ 1,301,966 $ 9,439,256 395 $ 65,098,319 $ 10,415,731 $ 75,514,050 $ 27,666 $ 13,833 33 $ 1,365,317 $ 218,451 $ 1,583,768 395 $ 10,922,537 $ 1,747,606 $ 12,670,143 $ 71,932 $ 35,966 33 $ 3,549,824 $ 567,972 $ 4,117,796 395 $ 28,398,596 $ 4,543,775 $ 32,942,371 $ 154,930 $ 77,465 33 $ 7,645,776 $ 1,223,324 $ 8,869,100 395 $ 61,166,206 $ 9,786,593 $ 70,952,799 $ 354,125 $ 177,062 33 $ 17,476,059 $ 2,796,169 $ 20,272,228 395 $ 139,808,471 $ 22,369,355 $ 162,177,826 $ 486,922 $ 243,461 33 $ 24,029,581 $ 3,844,733 $ 27,874,314 395 $ 192,236,648 $ 30,757,864 $ 222,994,511 $ 663,984 $ 331,992 33 $ 32,767,610 $ 5,242,818 $ 38,010,428 395 $ 262,140,883 $ 41,942,541 $ 304,083,425 $ 365,191 $ 182,596 33 $ 18,022,186 $ 2,883,550 $ 20,905,735 395 $ 144,177,486 $ 23,068,398 $ 167,245,883 $ 149,396 $ 74,698 33 $ 7,372,712 $ 1,179,634 $ 8,552,346 395 $ 58,981,699 $ 9,437,072 $ 68,418,771 $ 188,129 $ 94,064 33 $ 9,284,156 $ 1,485,465 $ 10,769,621 395 $ 74,273,250 $ 11,883,720 $ 86,156,970 $ 199,195 $ 99,598 33 $ 9,830,283 $ 1,572,845 $ 11,403,128 395 $ 78,642,265 $ 12,582,762 $ 91,225,027 $ 163,783 $ 81,891 33 $ 8,082,677 $ 1,293,228 $ 9,375,906 395 $ 64,661,418 $ 10,345,827 $ 75,007,245 $ 169,316 $ 84,658 33 $ 8,355,741 $ 1,336,919 $ 9,692,659 395 $ 66,845,925 $ 10,695,348 $ 77,541,273 $ 164,889 $ 82,445 33 $ 8,137,290 $ 1,301,966 $ 9,439,256 395 $ 65,098,319 $ 10,415,731 $ 75,514,050 $ 116,197 $ 58,099 33 $ 5,734,332 $ 917,493 $ 6,651,825 395 $ 45,874,655 $ 7,339,945 $ 53,214,599 $ 177,062 $ 88,531 33 $ 8,738,029 $ 1,398,085 $ 10,136,114 395 $ 69,904,236 $ 11,184,678 $ 81,088,913 $ 265,594 $ 132,797 33 $ 13,107,044 $ 2,097,127 $ 15,204,171 395 $ 104,856,353 $ 16,777,017 $ 121,633,370 $ 338,632 $ 169,316 33 $ 16,711,481 $ 2,673,837 $ 19,385,318 395 $ 133,691,850 $ 21,390,696 $ 155,082,547 $ 1,936,620 $ 968,310 33 $ 95,572,197 $ 15,291,552 $ 110,863,749 395 $ 764,577,576 $ 122,332,412 $ 886,909,988 $ 1,040,242 $ 520,121 33 $ 51,335,923 $ - $ 51,335,923 395 $ 410,687,384 $ - $ 410,687,384 $ 1,084,507 $ 542,254 33 $ 53,520,430 $ - $ 53,520,430 395 $ 428,163,443 $ - $ 428,163,443 $ 1,005,936 $ 502,968 33 $ 49,642,930 $ - $ 49,642,930 395 $ 397,143,438 $ - $ 397,143,438 $ 1,139,839 $ 569,920 33 $ 56,251,065 $ - $ 56,251,065 395 $ 450,008,516 $ - $ 450,008,516 $ 1,274,849 $ 637,425 33 $ 62,913,812 $ - $ 62,913,812 395 $ 503,310,496 $ - $ 503,310,496 $ 1,078,974 $ 539,487 33 $ 53,247,367 $ - $ 53,247,367 395 $ 425,978,935 $ - $ 425,978,935 $ 1,327,968 $ 663,984 33 $ 65,535,221 $ - $ 65,535,221 395 $ 524,281,766 $ - $ 524,281,766 $ 1,066,801 $ 533,400 33 $ 52,646,627 $ - $ 52,646,627 395 $ 421,173,019 $ - $ 421,173,019 $ 949,497 $ 474,749 33 $ 46,857,683 $ - $ 46,857,683 395 $ 374,861,463 $ - $ 374,861,463 $ 76,358 $ 38,179 33 $ 3,768,275 $ 602,924 $ 4,371,199 395 $ 30,146,202 $ 4,823,392 $ 34,969,594 $ 127,264 $ 63,632 33 $ 6,280,459 $ 1,004,873 $ 7,285,332 395 $ 50,243,669 $ 8,038,987 $ 58,282,656 $ 36,519 $ 18,260 33 $ 1,802,219 $ 288,355 $ 2,090,574 395 $ 14,417,749 $ 2,306,840 $ 16,724,588 $ 18,813 $ 9,406 33 $ 928,416 $ 148,547 $ 1,076,962 395 $ 7,427,325 $ 1,188,372 $ 8,615,697 $ 65,845 $ 32,923 33 $ 3,249,455 $ 519,913 $ 3,769,367 395 $ 25,995,638 $ 4,159,302 $ 30,154,940 $ 22,133 $ 11,066 33 $ 1,092,254 $ 174,761 $ 1,267,014 395 $ 8,738,029 $ 1,398,085 $ 10,136,114 $ 16,600 $ 8,300 33 $ 819,190 $ 131,070 $ 950,261 395 $ 6,553,522 $ 1,048,564 $ 7,602,086 $ 20,473 $ 10,236 33 $ 1,010,335 $ 161,654 $ 1,171,988 395 $ 8,082,677 $ 1,293,228 $ 9,375,906 $ 133,500 100 $ 13,350,000 $ 2,136,000 $ 15,486,000 1,200 $ 160,200,000 $ 25,632,000 $ 185,832,000 $ 140,000 100 $ 14,000,000 $ 2,240,000 $ 16,240,000 1,200 $ 168,000,000 $ 26,880,000 $ 194,880,000

    $ 8,601,359 1,549 $ 876,304,173 $ 61,496,498 $ 937,800,671 18,587 $ 7,140,367,751 $ 512,761,487 $ 7,653,129,238

  • PROYECTADO DE C Ao 2015

    COMPRAS Mensual Anual

    IPC 4,6%

    v/r Producto

    unidades Comp. V/r Compras

    Mensual

    iva 16%

    descontable

    V/r Total Compra

    unidades Comp.

    V/r Compras Anual iva 16%

    descontable

    V/r Total Compra

    $ 4,125 $ 93,801 37 $ 3,447,190 $ 551,550 $ 3,998,741 441 $ 41,366,283 $ 6,618,605 $ 47,984,889 $ 6,583 $ 149,683 37 $ 5,500,836 $ 880,134 $ 6,380,969 441 $ 66,010,027 $ 10,561,604 $ 76,571,631 $ 5,310 $ 120,744 37 $ 4,437,341 $ 709,975 $ 5,147,315 441 $ 53,248,088 $ 8,519,694 $ 61,767,782 $ 6,934 $ 157,666 37 $ 5,794,213 $ 927,074 $ 6,721,288 441 $ 69,530,561 $ 11,124,890 $ 80,655,451 $ 4,476 $ 101,784 37 $ 3,740,568 $ 598,491 $ 4,339,059 441 $ 44,886,818 $ 7,181,891 $ 52,068,709 $ 6,539 $ 148,685 37 $ 5,464,163 $ 874,266 $ 6,338,429 441 $ 65,569,960 $ 10,491,194 $ 76,061,153 $ 1,097 $ 24,947 37 $ 916,806 $ 146,689 $ 1,063,495 441 $ 11,001,671 $ 1,760,267 $ 12,761,938 $ 2,852 $ 64,862 37 $ 2,383,695 $ 381,391 $ 2,765,087 441 $ 28,604,345 $ 4,576,695 $ 33,181,040 $ 6,144 $ 139,704 37 $ 5,134,113 $ 821,458 $ 5,955,571 441 $ 61,609,358 $ 9,857,497 $ 71,466,855 $ 14,043 $ 319,323 37 $ 11,735,116 $ 1,877,619 $ 13,612,734 441 $ 140,821,390 $ 22