PRESUPUESTO
-
Upload
daniel-ricardo-matamoros-suarez -
Category
Documents
-
view
18 -
download
2
description
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