CODIGO APELLIDOS NOMBRE SEXO OCUPACION
11AB83MSC OJEDA AMAUT Scott Alexis M ABOGADO
11CO76FSE GIL STEFANO Lidia Alison F CONTADOR
11OP82MSE KOHIRA HIGO Renzo Kooji M OPERADOR
11PR65MCE LINGAN LEON Anibal Orlando M PROGRAMADOR
12AD68FSE ARATA VARELA Dalma Cristina F ADMINISTRADORA
12AN71FSE VIVES BERNAL Genesis Valena F ANALISTA
12EM77FSE ALVA FUERTES Maria Isabel Alexandra F EMPLEADO
12MA69FCC GONGORA RUIZ Elizabeth Andrea F MARKETING
12MA78FSE ACHA LINARES Nathali Elizabeth F MARKETING
12OB76MCC ARRIOLA RIOS Luis Santiago M OBRERO
12PR82MSE GALVEZ GOMEZ Ricardo Juan M PROGRAMADOR
13AL75MSC LEON ZEBALLOS Kennin Briam M ALMACEN
13CO74MCE RAMOS BURBANK Jahir Alonso M CONTADOR
13EM73FSE FLORES COELLO Ines F EMPLEADO
13MA76FCC SALINAS SOLIS Lorena Shirley F MARKETING
13OB75FSC URTECHO BRAVO Kenny Alessandra F OBRERO
13SE83FCC GALVEZ GUERRA Stepanhie F SECRETARIA
14AB84FCC GALVEZ SANCHEZ Tatiana Mariene F ABOGADO
14AL67MSC BASANTES SANTE Carlos Santiago M ALMACEN
14AN77MCE CASTAÑEDA POMA Manuel Fernando M ANALISTA
14EM83FCC MONCADA ARROYO Sthepanie Milagros F EMPLEADO
14OB68MSC FLORES RAMIREZ Diego Augusto M OBRERO
14OP82MCC MONCADA ARROYO Roberto Augusto M OPERADOR
14SE65MSC URRUTIA ZARATE Alvaro Emanuel M SERVICIOS
14SE82FCC FLORES RAMIREZ Rosa Celeste F SERVICIOS
15AL74MSC MERINO CABRASCO Jeanfranco Jafer M ALMACEN
15OB76MCC PACHECO PAJUELO Luis Felipe Tadeo M OBRERO
15SE71MCC CASTILLO CHAVEZ Gustabo Adolfo M SECRETARIA
15TE78MCC JURADO CARRASCO Neil Jesus M TECNICO
16EM67FSC TERRONES DELGADO Clara Isabel F EMPLEADO
16OB67MSC LLORENTE VILCHEZ Cesar Enrique M OBRERO
16SE65MSE CABREJOS QUEBEDO Angela Maria M SECRETARIA
17AB83MSC NAVARRO RODRIGUEZ Salvatore Roman M ABOGADO
17EM77FCE CHIRINOS CHIRINOS Mariangela F EMPLEADO
17PR75FSC DEL VALLE VELASCO Kiara Raiza F PROGRAMADOR
17SE74MCC PUMPILLO TARRILLO Jose Luis M SERVICIOS
18GE83FCE MARTTINI RODRUIGEZ Sthefany Joanet F GERENTE
19TE67MSC BUSTAMANTE GONZALES Christian M TECNICO
20TE65MSE PARRAGUEZ ECHEGARRAY Aroon Andre M TECNICO
9AN76MSC MEZA APUY Luis Angel M ANALISTA
EST. CIVIL NRO HIJOS CON LABORASALARIO AFP CODIGO AFP
S 0C 2000 S 4
S 0E 2000 S 2
S 0E 700 S 0
C 2E 1000 N 0
S 0E 3000 S 1
S 0E 2400 N 0
S 0E 600 N 0
C 3C 1200 N 0
S 0E 1400 N 0
C 1C 500 N 0
S 0E 1200 S 3
S 0C 700 N 0
C 0E 2000 N 0
S 0E 800 N 0
C 1C 1400 N 0
S 0C 500 N 0
C 0C 900 N 0
C 1C 1000 N 0
S 0C 500 N 0
C 1E 2400 S 4
C 1C 800 N 0
S 0C 500 N 0
C 0C 600 N 0
S 0C 500 N 0
C 0C 500 N 0
S 0C 500 N 0
C 0C 500 N 0
C 2C 1000 S 0
C 0C 700 N 0
S 0C 700 N 0
S 0C 500 N 0
S 0E 1000 N 0
S 0C 400 S 0
C 2E 800 S 0
S 0C 1000 N 0
C 0C 500 N 0
C 1E 4000 S 1
S 0C 700 N 0
S 0E 2000 N 0
S 0C 2000 N 0
TABLA DE PORCENTAJES Y VALORES
CODIGO DE CUENTA SEC. INVALID COMISION TOTAL
AFP EMPRESA INDIVIDUAL [Link] VARIABLE DESCUENTO
1 INTEGRA 10% 0.88% 1.80% 12.68%
2 PRIMA 10% 0.90% 1.50% 12.40%
3 HORIZONTE 10% 0.88% 1.95% 12.83%
4 PROFUTURO 10% 0.98% 1.98% 12.96%
PLA
DATOS PERSONALES
CODIGO APELLIDOS Y NOMBRES OCUPACION CODIGO AFP
11AB83MSC OJEDA AMAUT Scott Alexis ABOGADO 4
11CO76FSE GIL STEFANO Lidia Alison CONTADOR 2
11OP82MSE KOHIRA HIGO Renzo Kooji OPERADOR 0
11PR65MCE LINGAN LEON Anibal Orlando PROGRAMADOR 0
12AD68FSE ARATA VARELA Dalma Cristina ADMINISTRADORA 1
12AN71FSE VIVES BERNAL Genesis Valena ANALISTA 0
12EM77FSE ALVA FUERTES Maria Isabel Alexandra EMPLEADO 0
12MA69FCC GONGORA RUIZ Elizabeth Andrea MARKETING 0
12MA78FSE ACHA LINARES Nathali Elizabeth MARKETING 0
12OB76MCC ARRIOLA RIOS Luis Santiago OBRERO 0
12PR82MSE GALVEZ GOMEZ Ricardo Juan PROGRAMADOR 3
13AL75MSC LEON ZEBALLOS Kennin Briam ALMACEN 0
13CO74MCE RAMOS BURBANK Jahir Alonso CONTADOR 0
13EM73FSE FLORES COELLO Ines EMPLEADO 0
13MA76FCC SALINAS SOLIS Lorena Shirley MARKETING 0
13OB75FSC URTECHO BRAVO Kenny Alessandra OBRERO 0
13SE83FCC GALVEZ GUERRA Stepanhie SECRETARIA 0
14AB84FCC GALVEZ SANCHEZ Tatiana Mariene ABOGADO 0
14AL67MSC BASANTES SANTE Carlos Santiago ALMACEN 0
14AN77MCE CASTAÑEDA POMA Manuel Fernando ANALISTA 4
14EM83FCC MONCADA ARROYO Sthepanie Milagros EMPLEADO 0
14OB68MSC FLORES RAMIREZ Diego Augusto OBRERO 0
14OP82MCC MONCADA ARROYO Roberto Augusto OPERADOR 0
14SE65MSC URRUTIA ZARATE Alvaro Emanuel SERVICIOS 0
14SE82FCC FLORES RAMIREZ Rosa Celeste SERVICIOS 0
15AL74MSC MERINO CABRASCO Jeanfranco Jafer ALMACEN 0
15OB76MCC PACHECO PAJUELO Luis Felipe Tadeo OBRERO 0
15SE71MCC CASTILLO CHAVEZ Gustabo Adolfo SECRETARIA 0
15TE78MCC JURADO CARRASCO Neil Jesus TECNICO 0
16EM67FSC TERRONES DELGADO Clara Isabel EMPLEADO 0
16OB67MSC LLORENTE VILCHEZ Cesar Enrique OBRERO 0
16SE65MSE CABREJOS QUEBEDO Angela Maria SECRETARIA 0
17AB83MSC NAVARRO RODRIGUEZ Salvatore Roman ABOGADO 0
17EM77FCE CHIRINOS CHIRINOS Mariangela EMPLEADO 0
17PR75FSC DEL VALLE VELASCO Kiara Raiza PROGRAMADOR 0
17SE74MCC PUMPILLO TARRILLO Jose Luis SERVICIOS 0
18GE83FCE MARTTINI RODRUIGEZ Sthefany Joanet GERENTE 1
19TE67MSC BUSTAMANTE GONZALES Christian TECNICO 0
20TE65MSE PARRAGUEZ ECHEGARRAY Aroon Andre TECNICO 0
9AN76MSC MEZA APUY Luis Angel ANALISTA 0
PLANILLA DE PAGOS
INGRESOS DESCUENTO
HABER TOTAL
MENSUAL INCENTIVO ASIGN. FAMILIAR GRATIFICACION REMUNERACION SNP(13%)
S/. 2,000.00 S/. 100.00 0 0 S/. 2,100.00 S/. -
S/. 2,000.00 S/. 100.00 0 0 S/. 2,100.00 S/. -
S/. 700.00 S/. 35.00 0 0 S/. 735.00 S/. 95.55
S/. 1,000.00 S/. 50.00 50 0 S/. 1,100.00 S/. 143.00
S/. 3,000.00 S/. 150.00 0 0 S/. 3,150.00 S/. -
S/. 2,400.00 S/. 120.00 0 0 S/. 2,520.00 S/. 327.60
S/. 600.00 S/. 30.00 0 0 S/. 630.00 S/. 81.90
S/. 1,200.00 S/. 60.00 50 0 S/. 1,310.00 S/. 170.30
S/. 1,400.00 S/. 70.00 0 0 S/. 1,470.00 S/. 191.10
S/. 500.00 S/. 25.00 50 0 S/. 575.00 S/. 74.75
S/. 1,200.00 S/. 60.00 0 0 S/. 1,260.00 S/. -
S/. 700.00 S/. 35.00 0 0 S/. 735.00 S/. 95.55
S/. 2,000.00 S/. 100.00 0 0 S/. 2,100.00 S/. 273.00
S/. 800.00 S/. 40.00 0 0 S/. 840.00 S/. 109.20
S/. 1,400.00 S/. 70.00 50 0 S/. 1,520.00 S/. 197.60
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 900.00 S/. 45.00 0 0 S/. 945.00 S/. 122.85
S/. 1,000.00 S/. 50.00 50 0 S/. 1,100.00 S/. 143.00
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 2,400.00 S/. 120.00 50 0 S/. 2,570.00 S/. -
S/. 800.00 S/. 40.00 50 0 S/. 890.00 S/. 115.70
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 600.00 S/. 30.00 0 0 S/. 630.00 S/. 81.90
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 1,000.00 S/. 50.00 50 0 S/. 1,100.00 S/. 143.00
S/. 700.00 S/. 35.00 0 0 S/. 735.00 S/. 95.55
S/. 700.00 S/. 35.00 0 0 S/. 735.00 S/. 95.55
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 1,000.00 S/. 50.00 0 0 S/. 1,050.00 S/. 136.50
S/. 400.00 S/. 20.00 0 0 S/. 420.00 S/. 54.60
S/. 800.00 S/. 40.00 50 0 S/. 890.00 S/. 115.70
S/. 1,000.00 S/. 50.00 0 0 S/. 1,050.00 S/. 136.50
S/. 500.00 S/. 25.00 0 0 S/. 525.00 S/. 68.25
S/. 4,000.00 S/. 200.00 50 0 S/. 4,250.00 S/. -
S/. 700.00 S/. 35.00 0 0 S/. 735.00 S/. 95.55
S/. 2,000.00 S/. 100.00 0 0 S/. 2,100.00 S/. 273.00
S/. 2,000.00 S/. 100.00 0 0 S/. 2,100.00 S/. 273.00
DESCUENTO DEL EMPLEADO
5TA TOTAL NETO A
CATEGORIA AFP DESCUENTO PAGAR
S/. 65.63 S/. 272.16 S/. 337.79 S/. 1,762.22
S/. 367.50 S/. 260.40 S/. 627.90 S/. 1,472.10 UIT 3450
S/. - S/. - S/. 95.55 S/. 639.45
S/. - S/. - S/. 143.00 S/. 957.00 1/30/2018
S/. 551.25 S/. 399.42 S/. 950.67 S/. 2,199.33 1
S/. 441.00 S/. - S/. 768.60 S/. 1,751.40
S/. - S/. - S/. 81.90 S/. 548.10
S/. - S/. - S/. 170.30 S/. 1,139.70
S/. - S/. - S/. 191.10 S/. 1,278.90
S/. - S/. - S/. 74.75 S/. 500.25
S/. - S/. 161.66 S/. 161.66 S/. 1,098.34
S/. - S/. - S/. 95.55 S/. 639.45
S/. 367.50 S/. - S/. 640.50 S/. 1,459.50
S/. - S/. - S/. 109.20 S/. 730.80
S/. - S/. - S/. 197.60 S/. 1,322.40
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 122.85 S/. 822.15
S/. - S/. - S/. 143.00 S/. 957.00
S/. - S/. - S/. 68.25 S/. 456.75
S/. 449.75 S/. 333.07 S/. 782.82 S/. 1,787.18
S/. - S/. - S/. 115.70 S/. 774.30
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 81.90 S/. 548.10
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 143.00 S/. 957.00
S/. - S/. - S/. 95.55 S/. 639.45
S/. - S/. - S/. 95.55 S/. 639.45
S/. - S/. - S/. 68.25 S/. 456.75
S/. - S/. - S/. 136.50 S/. 913.50
S/. - S/. - S/. 54.60 S/. 365.40
S/. - S/. - S/. 115.70 S/. 774.30
S/. - S/. - S/. 136.50 S/. 913.50
S/. - S/. - S/. 68.25 S/. 456.75
S/. 743.75 S/. 538.90 S/. 1,282.65 S/. 2,967.35
S/. - S/. - S/. 95.55 S/. 639.45
S/. 367.50 S/. - S/. 640.50 S/. 1,459.50
S/. 367.50 S/. - S/. 640.50 S/. 1,459.50
Data 8000
Column A Sum - Data2 Sum - Column C
ABOGADO S/. 3,084.62 S/. 3,400.00 7000
ADMINISTRADORA S/. 2,199.33 S/. 3,000.00
6000
ALMACEN S/. 1,552.95 S/. 1,700.00
ANALISTA S/. 4,998.08 S/. 6,800.00 5000
CONTADOR S/. 2,931.60 S/. 4,000.00
EMPLEADO S/. 3,466.95 S/. 3,700.00 4000
GERENTE S/. 2,967.35 S/. 4,000.00
3000
MARKETING S/. 3,741.00 S/. 4,000.00
OBRERO S/. 2,327.25 S/. 2,500.00 2000
OCUPACION
OPERADOR S/. 1,187.55 S/. 1,300.00 1000
PROGRAMADOR S/. 2,968.84 S/. 3,200.00
0
SECRETARIA S/. 2,692.65 S/. 2,900.00
A A E
n DO R
SERVICIOS S/. 1,370.25 S/. 1,500.00 u m GA DO AC
l O A M
Total Result S/. 35,488.42 S/. 42,000.00 Co AB I STR AL
IN
D M
A
8000
7000
6000
5000
4000
3000 Data
Column C
2000
1000
0
n
A
DO R
A EN STA OR
DO TE NG O ON OR R I A OS
u m GA DO AC ALI TAD LEA REN ETI RER ACI AD ADO ETAR I CI
l O A M AN P GE RK OB UP R V
Co AB I STR AL N
CO EM A C O PE RAM SECR SER
IN M O G
D M PRO
A
CODIGO AFP - all -
Data
OCUPACION Sum - NETO A PAGAR Sum - HABER MENSUAL
ABOGADO S/. 3,084.62 S/. 3,400.00
ADMINISTRADORA S/. 2,199.33 S/. 3,000.00
ALMACEN S/. 1,552.95 S/. 1,700.00
ANALISTA S/. 4,998.08 S/. 6,800.00
CONTADOR S/. 2,931.60 S/. 4,000.00
EMPLEADO S/. 3,466.95 S/. 3,700.00
GERENTE S/. 2,967.35 S/. 4,000.00
MARKETING S/. 3,741.00 S/. 4,000.00
OBRERO S/. 2,327.25 S/. 2,500.00
OPERADOR S/. 1,187.55 S/. 1,300.00
PROGRAMADOR S/. 2,968.84 S/. 3,200.00
SECRETARIA S/. 2,692.65 S/. 2,900.00
SERVICIOS S/. 1,370.25 S/. 1,500.00
TECNICO S/. 2,738.40 S/. 3,400.00
Total Result S/. 38,226.82 S/. 45,400.00
