DISTRIBUIDORA EL ROSAL

LISTADO DE EMPLEADOS
IDENTIFICACIÓN NOMBRES
1,143,388,657 ANA MARTINEZ
548,987,445 CARLOS ORDOÑEZ
564,544,949 DAIRYS DIAZ
654,454,564 DIANA GOMEZ
564,545,454 DIEGO ANDRADE
65,454,944 ELIAN GUTIERREZ
5,456,456,456 JOHANA GONZALES
5,449,494,654 JUAN PEREZ
6,448,445,456 LAURA DIAZ
5,449,478,454 LIA PASCUALES
214,654,954 LILIANA POLO
8,756,454,544 PEDRO ESCORCIA
8,545,454,154 RICARDO CARRANZA
6,154,454,541 SANDRA OLIVO
544,989,787 TATIAN GARCES
DISTRIBUIDORA EL ROSAL
LISTADO DE EMPLEADOS
FECHA DE NACIMIENTO TELEFONO CARGO
Tuesday, May 1, 1990 6546598 DIGITADOR
Sunday, January 24, 1999 5468962 SUPERVISOR
Sunday, July 4, 1993 3015624896 SUPERVISOR
Thursday, September 17, 1992 3124567895 SECRETARIO
Tuesday, November 21, 1995 52587963 SUBGERENTE
Wednesday, April 20, 1994 5612489 JEFE DEPARTAMENTO
Friday, September 6, 1996 6235874 DIGITADOR
Friday, February 15, 1991 5642843 SECRETARIO
Monday, December 2, 1991 5624895 DIGITADOR
Saturday, August 26, 2000 5620534 DIGITADOR
Tuesday, June 12, 2001 5248961 JEFE DEPARTAMENTO
Monday, June 23, 1997 3152356874 DIGITADOR
Thursday, April 9, 1998 3124567890 SECRETARIO
Saturday, February 4, 1995 5465645 GERENTE
Wednesday, November 10, 1999 6527852 DIGITADOR
SUELDO
$1,600,000.00
$3,000,000.00
$3,000,000.00
$2,000,000.00
$6,000,000.00
$4,500,000.00
$1,600,000.00
$2,000,000.00
$1,600,000.00
$2,700,000,000.00
$4,500,000.00
$3,500,000,000.00
$2,000,000.00
$8,000,000.00
$4,000,000.00
 INSTITUCIÓN EDUCATIVA RAFAEL NUÑES
IDENTIFICACIÓN NOMBRES MATEMATICAS LENGUAJE INGLES
1,143,388,657 ANA MARTINEZ 4.00 4.00 3.10
548,987,445 CARLOS ORDOÑEZ 3.80 4.00 3.00
564,544,949 DAIRYS DIAZ 2.50 4.00 4.00
654,454,564 DIANA GOMEZ 2.80 3.00 5.00
564,545,454 DIEGO ANDRADE 3.10 3.00 3.50
65,454,944 ELIAN GUTIERREZ 3.00 3.50 3.60
5,456,456,456 JOHANA GONZALES 4.00 3.80 3.75
5,449,494,654 JUAN PEREZ 5.00 5.00 2.85
6,448,445,456 LAURA DIAZ 3.50 5.00 2.00
5,449,478,454 LIA PASCUALES 3.60 3.50 4.00
214,654,954 LILIANA POLO 3.75 3.70 3.80
8,756,454,544 PEDRO ESCORCIA 2.85 4.00 2.50
8,545,454,154 RICARDO CARRANZA 2.00 4.20 2.80
6,154,454,541 SANDRA OLIVO 2.70 3.90 3.10
544,989,787 TATIAN GARCES 4.00 3.00 3.00
CANTIDAD ESTUDIANTE 15 15 15
PROMEDIO ASIGNATURA 3.37 3.84 3.33
MAYOR NOTA 5.00 5.00 5.00
MENOR NOTA 2.00 3.00 2.00
FAEL NUÑES
SOCIALES BIOLOGÍA PROMEDIO ESTUDIANTE
3.00 4.00 3.62
3.50 4.00 3.66
3.80 3.80 3.62
5.00 3.50 3.86
5.00 2.00 3.32
3.50 2.00 3.12
3.70 2.50 3.55
4.00 3.50 4.07
4.20 3.60 3.66
4.00 3.70 3.76
4.00 4.10 3.87
4.00 3.30 3.33
3.00 2.50 2.9
3.00 4.00 3.34
3.50 5.00 3.70
15 15 15
3.81 3.43 3.56
5.00 5.00 4.07
3.00 2.00 2.90
 DISTRIBUIDORA LA G
LISTADO DE CL
IDENTIFICACIÓN NOMBRES TELEFONO
1,143,388,657 ANA MARTINEZ 6546598
548,987,445 CARLOS ORDOÑEZ 5468962
564,544,949 DAIRYS DIAZ 3015624896
654,454,564 DIANA GOMEZ 3124567895
564,545,454 DIEGO ANDRADE 52587963
65,454,944 ELIAN GUTIERREZ 5612489
5,456,456,456 JOHANA GONZALES 6235874
5,449,494,654 JUAN PEREZ 5642843
6,448,445,456 LAURA DIAZ 5624895
5,449,478,454 LIA PASCUALES 5620534
214,654,954 LILIANA POLO 524861
8,756,454,544 PEDRO ESCORCIA 3152356874
8,545,454,154 RICARDO CARRANZA 3124567890
6,154,454,541 SANDRA OLIVO 5465645
544,989,787 TATIAN GARCES 6527852
DISTRIBUIDORA LA GLORIA DE DIOS
LISTADO DE CLIENTES
CORREO TIPO DE CLIENTE CUPO TOTAL
anamartinez@gmail.com CLIENTE_BRONCE $5,000,000,000.00
carlosordoñez@hotmail.com CLIENTE_PLATA $10,000,000,000.00
dadi@gmail.com CLIENTE_BRONCE $5,000,000,000.00
digo@gmail.com CLIENTE_PLATA $10,000,000,000.00
diandrade@hotmail.com CLIENTE_PLATA $10,000,000,000.00
eliang@gmail.com CLIENTE_ORO $15,000,000,000.00
johanagon@hotmail.com CLIENTE_ORO $15,000,000,000.00
juanperez@hotmail.com CLIENTE_ORO $15,000,000,000.00
Id9iaz@gmail.com CLIENTE_PLATA $10,000,000,000.00
liapaz@gmail.com CLIENTE_PLATA $10,000,000,000.00
lili@gmail.com CLIENTE_DIAMANTE $20,000,000,000.00
peca@hotmail.com CLIENTE_DIAMANTE $20,000,000,000.00
ricardocarr@gmail.com CLIENTE_BRONCE $5,000,000,000.00
sandraolivo@hotmail.com CLIENTE_BRONCE $5,000,000,000.00
tatianag@yahoo.com CLIENTE_BRONCE $5,000,000,000.00
TOTALES $160,000,000,000.00
PROMEDIO $10,666,666,666.67
MAYORES $20,000,000,000.00
MENORES $5,000,000,000.00
CUPO UTILIZADO CUPO DIOSPONIBLE
$2,000,000,000.00 $3,000,000,000.00
$7,000,000,000.00 $3,000,000,000.00
$4,500,000,000.00 $500,000,000.00
$9,800,000,000.00 $200,000,000.00
$5,000,000,000.00 $5,000,000,000.00
$10,000,000,000.00 $5,000,000,000.00
$12,000,000,000.00 $3,000,000,000.00
$8,000,000,000.00 $7,000,000,000.00
$5,000,000,000.00 $5,000,000,000.00
$4,500,000,000.00 $5,500,000,000.00
$10,000,000,000.00 $10,000,000,000.00
$11,000,000,000.00 $9,000,000,000.00
$2,500,000,000.00 $2,500,000,000.00
$1,850,000,000.00 $3,150,000,000.00
$1,400,000,000.00 $3,600,000,000.00
$94,550,000,000.00 $6,600,000,000.00
$1,700,000,000.00 $3,300,000,000.00
$2,000,000,000.00 $3,600,000,000.00
$1,400,000,000.00 $3,000,000,000.00
TIPO DE CLIENTE CARGO
CLIENTE_BRONCE AUXILIAR
CLIENTE_PLATA CAJERO_A
CLIENTE_ORO SUPERVISOR_A
CLIENTE_DIAMANTE ADMINISTRADOR_A

CLIENTE_BRONCE CLIENTE_PLATA
$ 3,000,000,000.00 $ 8,000,000,000.00
$ 4,000,000,000.00 $ 9,000,000,000.00
$ 5,000,000,000.00 $ 10,000,000,000.00

AUXILIAR CAJERO_A
$ 1,800,000,000.00 $ 2,300,000,000.00
$ 1,900,000,000.00 $ 2,400,000,000.00
$ 2,000,000,000.00 $ 2,500,000,000.00
CLIENTE_ORO CLIENTE_DIAMANTE
$ 13,000,000,000.00 $ 18,000,000,000.00
$ 14,000,000,000.00 $ 19,000,000,000.00
$ 15,000,000,000.00 $ 20,000,000,000.00

SUPERVISOR_A ADMINISTRADOR_A
$ 3,800,000,000.00 $ 8,000,000,000.00
$ 3,900,000,000.00 $ 9,000,000,000.00
$ 4,000,000,000.00 $ 10,000,000,000.00
 ALMACEN NACIONAL
IDENTIFICACIÓN NOMBRES CARGO SUELDO BASICO
1,143,388,657 ANA MARTINEZ CAJERO_A $ 2,400,000,000
548,987,445 CARLOS ORDOÑEZ AUXILIAR $ 1,900,000,000
564,544,949 DAIRYS DIAZ ADMINISTRADOR_A $ 9,000,000,000
654,454,564 DIANA GOMEZ CAJERO_A $ 2,400,000,000
564,545,454 DIEGO ANDRADE CAJERO_A $ 2,400,000,000
65,454,944 ELIAN GUTIERREZ AUXILIAR $ 1,900,000,000
5,456,456,456 JOHANA GONZALES AUXILIAR $ 1,900,000,000
5,449,494,654 JUAN PEREZ SUPERVISOR_A $ 3,900,000,000
6,448,445,456 LAURA DIAZ CAJERO_A $ 2,400,000,000
5,449,478,454 LIA PASCUALES CAJERO_A $ 2,400,000,000
214,654,954 LILIANA POLO CAJERO_A $ 2,400,000,000
8,756,454,544 PEDRO ESCORCIA CAJERO_A $ 2,400,000,000
8,545,454,154 RICARDO CARRANZA CAJERO_A $ 2,400,000,000
6,154,454,541 SANDRA OLIVO CAJERO_A $ 2,400,000,000
544,989,787 TATIAN GARCES AUXILIAR $ 1,900,000,000
TOTAL $ 42,100,000,000
PROMEDIO $ 2,400,000,000
MAYORES $ 9,000,000,000
MENORES $ 1,900,000,000
NAL
NHE VHE SUELDO NETO
10 $ 16,304,348 $ 2,563,043,478
38 $ 12,907,609 $ 2,390,489,130
10 $ 61,141,304 $ 9,611,413,043
58 $ 16,304,348 $ 3,345,652,174
13 $ 16,304,348 $ 2,611,956,522
12 $ 12,907,609 $ 2,054,891,304
15 $ 12,907,609 $ 2,093,614,130
50 $ 26,494,565 $ 5,224,728,261
50 $ 16,304,348 $ 3,215,217,391
11 $ 16,304,348 $ 2,579,347,826
12 $ 16,304,348 $ 2,595,652,174
15 $ 16,304,348 $ 2,644,565,217
45 $ 16,304,348 $ 3,133,695,652
48 $ 16,304,348 $ 3,182,608,696
10 $ 12,907,609 $ 2,029,076,087
397 $ 29,211,957 $ 4,592,119,565
10 $ 14,605,978 $ 2,296,059,783
58 $ 16,304,348 $ 2,563,043,478
10 $ 12,907,609 $ 2,029,076,087
 EMPRESA DARCOS SAS
RESUMEN EMPLEADOS
IDENTIFICACION NOMBRES SUELDO BASIESTRATO NHE VHEN SUB ESTRATO
1,143,388,657 ANA MARTIN $1,500,000 1 10 $14,266 $300,000
548,987,445 CARLOS ORD $1,600,000 2 8 $15,217 $320,000
564,544,949 DAIRYS DIAZ $1,700,000 3 9 $16,168 $340,000
654,454,564 DIANA GOME $1,800,000 4 12 $17,120 $0
564,545,454 DIEGO ANDR $1,900,000 5 15 $18,071 $0
65,454,944 ELIAN GUTIE $2,000,000 6 13 $19,022 $0
5,456,456,456 JOHANAGONZ $2,100,000 1 14 $19,973 $420,000
5,449,494,654 JUANPEREZ $2,200,000 2 12 $20,924 $440,000
6,448,445,456 LAURA DIAZ $2,300,000 4 16 $21,875 $0
5,449,478,454 LIA PASCUAL $2,400,000 3 20 $22,826 $480,000
214,654,954 LILIANA POLO $2,500,000 5 15 $23,777 $0
8,756,454,544 PEDRO ESCOR $2,600,000 1 10 $24,728 $520,000
8,545,454,154 RICARDO CA $2,700,000 1 5 $25,679 $540,000
6,154,454,541 SANDRA OLIV $2,800,000 2 10 $26,630 $560,000
544,989,787 TATIANA GAR $2,900,000 3 7 $27,582 $580,000
TOTALES $313,859 $4,500,000
PROMEDIOS $20,924 $300,000
MAYORES $27,582 $580,000
MENORES $14,266 $0
SUELDO NETO DESCRIPCION
$1,942,663 REGULAR
$2,041,739 REGULAR
$2,185,516 REGULAR
$2,005,435 REGULAR
$2,171,060 REGULAR
$2,247,283 REGULAR
$2,799,620 OPTIMO
$2,891,087 OPTIMO
$2,650,000 OPTIMO
$3,336,522 OPTIMO
$2,856,658 OPTIMO
$3,367,283 OPTIMO
$3,368,397 OPTIMO
$3,626,304 OPTIMO
$3,673,071 OPTIMO
$41,162,636
$2,744,176
$3,673,071
$1,942,663
 LISTADO COMPRAS
IDENTIFICACI FECHA
ON
1,143,388,6 NOMBRES
ANA COMPRA VALOR
$25,500,00
57 MARTINEZ
CARLOS 1/5/2020 $32,500,00
0
548,987,445 ORDOÑEZ 2/5/2020 $39,500,00
0
564,544,949 DAIRYS
DIANA DIAZ 2/20/2020 $46,500,00
0
654,454,564 GOMEZ 3/10/2020 0
DIEGO $53,500,00
564,545,454 ANDRADE 3/30/2020 0
ELIAN $60,500,00
65,454,944 GUTIERREZ 4/25/2020 0
5,456,456,4 JOHANAGON $67,500,00
56 ZALEZ
5,449,494,6 5/15/2020 $74,500,00
0
54 JUANPEREZ
6,448,445,4 0
5/30/2020 $81,500,00
56 LAURA DIAZ 6/20/2020 0
5,449,478,4 LIA $88,500,00
54 PASCUALES 7/18/2020 0
LILIANA $95,500,00
214,654,954 POLO 8/5/2020 0
8,756,454,5 PEDRO $102,500,0
44 ESCORCIA 8/27/2020 00
8,545,454,1 RICARDO $109,500,0
54 CARRANZA 9/20/2020 00
6,154,454,5 SANDRA $116,500,0
41 OLIVIO 10/18/2020 00
TATIANA $123,500,0
544,989,787 GARCES 11/25/2020 00
 $1,117,500
TOTALES ,000
$74,500,00
PROMEDIOS 0
$123,500,0
MAYORES 00
$25,500,00
MENORES 0
STADO COMPRAS Y PROVEEDORES

IVA DESCUENTO NETO

$4,335,000 $0 $29,835,000
$5,525,000 $0 $38,025,000
$6,715,000 $0 $46,215,000
$7,905,000 $0 $54,405,000

$9,095,000 $0 $62,595,000

$10,285,000 $0 $70,785,000

$11,475,000 $0 $78,975,000
$10,430,000 $0 $84,930,000
$11,410,000 $0 $92,910,000

$12,390,000 $0 $100,890,000

$13,370,000 $0 $108,870,000

$14,350,000 $2,050,000 $114,800,000

$15,330,000 $2,190,000 $122,640,000

$16,310,000 $2,330,000 $130,480,000

$17,290,000 $2,470,000 $138,320,000

$166,215,000 $9,040,000 $1,274,675,000
$11,081,000 $ 602.67 $84,978,333

$17,290,000 $2,470,000 $138,320,000

$4,335,000 $0 $29,835,000
DESCRIPCION
NORMAL
NORMAL
NORMAL
NORMAL

NORMAL

NORMAL

NORMAL
NORMAL
NORMAL

ALTA

ALTA

ALTA

ALTA

ALTA

ALTA
No.compras normales
No.compra altas
No.compras normales
total compras altas
 EMPRESA TODO PARA EL
LISTADO DE EMPLEADO
IDENTIFICACIÓN NOMBRES CARGO SUELDO BASICO ESTRATO
1,143,388,657 ANA MARTINEZ NIVEL_1 $ 3,000,000.00 1
548,987,445 CARLOS ORDOÑEZ ADMINISTRATIVO_A $ 7,000,000.00 2
564,544,949 DAIRYS DIAZ GERENTE $ 10,000,000.00 6
654,454,564 DIANA GOMEZ NIVEL_1 $ 3,000,000.00 3
564,545,454 DIEGO ANDRADE NIVEL_1 $ 3,000,000.00 4
65,454,944 ELIAN GUTIERREZ NIVEL_2 $ 4,000,000.00 5
5,456,456,456 JOHANA GONZALES NIVEL_1 $ 3,000,000.00 2
5,449,494,654 JUAN PEREZ ADMINISTRATIVO_A $ 7,000,000.00 5
6,448,445,456 LAURA DIAZ ADMINISTRATIVO_A $ 7,000,000.00 5
5,449,478,454 LIA PASCUALES NIVEL_1 $ 3,000,000.00 1
214,654,954 LILIANA POLO NIVEL_2 $ 4,000,000.00 2
8,756,454,544 PEDRO ESCORCIA NIVEL_1 $ 3,000,000.00 3
8,545,454,154 RICARDO CARRANZA ADMINISTRATIVO_A $ 7,000,000.00 4
6,154,454,541 SANDRA OLIVO NIVEL_1 $ 3,000,000.00 2
544,989,787 TATIAN GARCES NIVEL_2 $ 4,000,000.00 3
TODO PARA EL HOGAR
DO DE EMPLEADOS
No HIJOS SUB ESTRATO SUBH HIJOS DESCUENTO SUELDO NETO DESCRIPCION
1 $600,000 $240,000 $ 150,000 $ 3,690,000 REGULAR
2 $1,050,000 $560,000 $ 350,000 $ 8,260,000 REGULAR
3 $0 $1,400,000 $ 250,000 $ 11,150,000 REGULAR
4 $300,000 $420,000 $ 150,000 $ 3,570,000 REGULAR
5 $0 $600,000 $ 75,000 $ 3,525,000 REGULAR
6 $0 $960,000 $ 100,000 $ 4,860,000 REGULAR
7 $450,000 $840,000 $ 150,000 $ 4,140,000 OPTIMO
1 $0 $560,000 $ 175,000 $ 7,385,000 REGULAR
0 $0 $0 $0 $ 7,000,000 REGULAR
15 $600,000 $1,200,000 $ 150,000 $ 4,650,000 OPTIMO
4 $600,000 $560,000 $ 200,000 $ 4,960,000 REGULAR
3 $300,000 $420,000 $ 150,000 $ 3,570,000 REGULAR
0 $0 $0 $0 $ 7,000,000 REGULAR
5 $450,000 $600,000 $ 150,000 $ 3,900,000 OPTIMO
3 $400,000 $560,000 $ 200,000 $ 4,760,000 REGULAR
CARGO ESTRATO
GERENTE 1
ADMINISTRATIVO_A 2
NIVEL_1 3
NIVEL_2 4
5
6