NOMINA 01 DE ABRIL 30 DE ABRIL
DIAS CANT EXTRA
CEDULA APELLIDOS NOMBRES CARGO SUELDO BASE TRABAJADOS DIURNA
100235598 AGUILAR DIAZ DIEGO ANDRÉS OPERARIO 1 $ 835,600 25 10
53896512 AGUILAR GARCIA DIANA MARCELA AUXILIAR $ 750,000 30 4
78946512 ASPRILLA SUAREZ ALBERTO JOSE GERENTE REGIONAL 1 $ 2,360,000 30 0
42158645 AVELLANEDA PEREZ PATRICIA ANDREA SUBGERENTE REGIONAL 1 $ 1,635,000 30 0
100426598 BERMUDES CALDERON JOSE DUQUERIO SUPERVISOR $ 950,000 25 0
51315145 CARDOSO ROJAS MARIA JOSE JEFE DPTO. 2 $ 1,235,600 30 0
74586523 CASTAÑO PERDOMO JORGE SUPERVISOR $ 950,000 30 0
88456923 DIAZ VASQUEZ ISAAC OPERARIO 2 $ 865,700 30 3
44422843 FLOREZ FERNANDEZ TATIANA ANDREA SUBGERENTE REGIONAL 2 $ 1,635,000 30 0
55648931 JORDAN GORDON MICHAEL JEFFRY JEFE NACIONAL $ 3,850,600 30 0
42567847 MIÑOZ SALCEDO PAULA JEFE DPTO. 4 $ 1,235,000 30 0
95863455 MOLANO TOVAR JOSE JOAQUIN SUPERVISOR $ 950,000 30 5
100348789 MUÑOZ PEREZ MARIO ESTEBAN JEFE DPTO. 3 $ 1,235,600 30 0
52948635 PERDOMO HERRERA ANDREA AUXILIAR $ 750,000 30 5
56894215 ROJAS IBARRA KAREN DAYANA COORDINADOR $ 1,115,200 30 6
75896523 TOVAR LUGO FABIAN MAURICIO OPERARIO 2 $ 865,700 15 2
100150285 URVANO GUZMAN DANIEL FELIPE AUXILIAR $ 750,000 16 6
74213698 VALDERRAMA PALACIOS CARLOS ALBERTO GERENTE REGIONAL 2 $ 2,360,000 30 0
58649137 ZAMBRANO SOLER MARIA CATALINA JEFE DPTO. 1 $ 1,235,600 30 0
84695235 ZAPATA HERNANDEZ ELDOR JOSE OPERARIO 1 $ 835,600 20 2
101902585 CASTILLO CARLOS GERENTE $ 2,300,000 27 0
89625898 TAMAYO MARIA SECRETARIA GERENCIA $ 1,800,000 23 5
58963521 GONZALEZ ALAN CONTADOR $ 1,700,000 29 8
23569789 JURADO ROCIO SERVICIOS GENERALES $ 828,116 30 0
79852415 ESTRADA ARMADNO MANTENIMIENTO $ 650,000 24 5
23568789 FERNANDEZ RENE PORTERO $ 828,116 27 0
1019852632 ZAMUDIO CAMILO OFICIOS VARIOS $ 828,116 29 0
1010265321 RICO MARIANA OFICIOS VARIOS $ 828,116 30 0
TOTALES NOMINA $ 36,162,664 0
RANGOS UVT
DESDE HASTA FORMU
0 95 0%
>95 150 (TOTAL UVT *95UVT
>150 300 (TOTAL UVT *150 UVT)*2
>100 NO APLI
ILUMINATA SA
NOMINA 01 DE ABRIL 30 DE ABR
CANT EXTRA AUX TOTAL
VR. DIA VR. HORA BASICO EXTRA DIURNA EXTRA NOCT TOTAL EXTRAS 4% PENSION
NOCT TRANSPORTE DEVENGADO
16 27,853 3,482 835,600 80,860 43,521 97,487 141,008 1,057,468 39,064
4 25,000 3,125 750,000 97,032 15,625 21,875 37,500 884,532 31,500
0 78,667 9,833 2,360,000 0 0 0 0 2,360,000 94,400
0 54,500 6,813 1,635,000 97,032 0 0 0 1,732,032 65,400
5 31,667 3,958 950,000 80,860 0 34,635 34,635 1,065,495 39,385
0 41,187 5,148 1,235,600 97,032 0 0 0 1,332,632 49,424
5 31,667 3,958 950,000 97,032 0 34,635 34,635 1,081,667 39,385
0 28,857 3,607 865,700 97,032 13,527 0 13,527 976,259 35,169
0 54,500 6,813 1,635,000 97,032 0 0 0 1,732,032 65,400
0 128,353 16,044 3,850,600 0 0 0 0 3,850,600 154,024
0 41,167 5,146 1,235,000 97,032 0 0 0 1,332,032 49,400
0 31,667 3,958 950,000 97,032 24,740 0 24,740 1,071,772 38,990
0 41,187 5,148 1,235,600 97,032 0 0 0 1,332,632 49,424
2 25,000 3,125 750,000 97,032 19,531 10,938 30,469 877,501 31,219
0 37,173 4,647 1,115,200 97,032 34,850 0 34,850 1,247,082 46,002
0 28,857 3,607 865,700 48,516 9,018 0 9,018 923,234 34,989
2 25,000 3,125 750,000 51,750 23,438 10,938 34,375 836,125 31,375
0 78,667 9,833 2,360,000 0 0 0 0 2,360,000 94,400
0 41,187 5,148 1,235,600 97,032 0 0 0 1,332,632 49,424
0 27,853 3,482 835,600 64,688 8,704 0 8,704 908,992 33,772
12 76,667 9,583 2,300,000 0 0 201,250 201,250 2,501,250 100,050
8 60,000 7,500 1,800,000 0 46,875 105,000 151,875 1,951,875 78,075
5 56,667 7,083 1,700,000 0 70,833 61,979 132,813 1,832,813 73,313
0 27,604 3,450 828,116 97,032 0 0 0 925,148 33,125
10 21,667 2,708 650,000 77,626 16,927 47,396 64,323 791,949 28,573
11 27,604 3,450 828,116 87,329 0 66,422 66,422 981,867 35,782
0 27,604 3,450 828,116 93,798 0 0 0 921,914 33,125
0 27,604 3,450 828,116 97,032 0 0 0 925,148 33,125
0 $ 36,162,664 $ 1,943,874 $ 327,588 $ 692,554 $ 1,020,142 $ 39,126,681 $ 1,487,312
FORMULA
0%
OTAL UVT *95UVT)*19%*[Link]
UVT *150 UVT)*28%*[Link])+10 UVT
NO APLICA
NATA SA
ABRIL 30 DE ABRIL
FONDO SALARIO RENTA BASE TABLA PORCENTAJE
4% SALUD AFP FSP EPS UVT
SOLIDARIDAD DEVENGADO EXENTA GRAVABLE CONVERSION 19%
39,064 0 976,608 78,129 224,620 751,988 34,270 22 0
31,500 0 787,500 63,000 181,125 606,375 34,270 18 0
94,400 0 2,360,000 188,800 542,800 1,817,200 34,270 53 0
65,400 0 1,635,000 130,800 376,050 1,258,950 34,270 37 0
39,385 0 984,635 78,771 226,466 758,169 34,270 22 0
49,424 0 1,235,600 98,848 284,188 951,412 34,270 28 0
39,385 0 984,635 78,771 226,466 758,169 34,270 22 0
35,169 0 879,227 70,338 202,222 677,004 34,270 20 0
65,400 0 1,635,000 130,800 376,050 1,258,950 34,270 37 0
154,024 38,506 3,850,600 346,554 876,012 2,974,589 34,270 87 0
49,400 0 1,235,000 98,800 284,050 950,950 34,270 28 0
38,990 0 974,740 77,979 224,190 750,549 34,270 22 0
49,424 0 1,235,600 98,848 284,188 951,412 34,270 28 0
31,219 0 780,469 62,438 179,508 600,961 34,270 18 0
46,002 0 1,150,050 92,004 264,512 885,539 34,270 26 0
34,989 0 874,718 69,977 201,185 673,533 34,270 20 0
31,375 0 784,375 62,750 180,406 603,969 34,270 18 0
94,400 0 2,360,000 188,800 542,800 1,817,200 34,270 53 0
49,424 0 1,235,600 98,848 284,188 951,412 34,270 28 0
33,772 0 844,304 67,544 194,190 650,114 34,270 19 0
100,050 0 2,501,250 200,100 575,288 1,925,963 34,270 56 0
78,075 0 1,951,875 156,150 448,931 1,502,944 34,270 44 0
73,313 0 1,832,813 146,625 421,547 1,411,266 34,270 41 0
33,125 0 828,116 66,249 190,467 637,649 34,270 19 0
28,573 0 714,323 57,146 164,294 550,029 34,270 16 0
35,782 0 894,538 71,563 205,744 688,794 34,270 20 0
33,125 0 828,116 66,249 190,467 637,649 34,270 19 0
33,125 0 828,116 66,249 190,467 637,649 34,270 19 0
$ 1,487,312 $ 38,506 $ 37,182,806
PORCENTAJE RETEFUENTE EMBARGO JUDICIAL PRESTAMO A
LIBRANZA TOTAL DEDUCC NETO PAGADO
28% LABORAL EMPLEADOS
0 0 0 0 0 78,129 979,339
0 0 0 0 0 63,000 821,532
0 0 0 0 0 188,800 2,171,200
0 0 0 0 0 130,800 1,601,232
0 0 0 0 0 78,771 986,725
0 0 0 0 0 98,848 1,233,784
0 0 0 0 0 78,771 1,002,897
0 0 0 0 0 70,338 905,920
0 0 0 0 0 130,800 1,601,232
0 0 0 0 0 346,554 3,504,046
0 0 0 0 0 98,800 1,233,232
0 0 0 0 0 77,979 993,792
0 0 0 0 0 98,848 1,233,784
0 0 0 0 0 62,438 815,063
0 0 0 0 0 92,004 1,155,078
0 0 0 0 0 69,977 853,256
0 0 0 0 0 62,750 773,375
0 0 0 0 0 188,800 2,171,200
0 0 0 0 0 98,848 1,233,784
0 0 0 0 0 67,544 841,448
0 0 200,000 345,000 0 745,100 1,756,150
0 0 180,000 0 0 336,150 1,615,725
0 0 0 0 250,000 396,625 1,436,188
0 0 100,000 0 41,406 207,655 717,493
0 0 0 0 0 57,146 734,803
0 0 50,000 0 0 121,563 860,304
0 0 0 0 0 66,249 855,664
0 0 0 0 0 66,249 858,899
TOTAL NOMINA $ 34,947,144
