Codigo Nombres y Apellidos Seccion Est_Civil

99N0043A Alva Fernandez, Roberto Administración D

98N0101A Alvarez Gonzales, Luis Administración C
01M0091C Blas Gutierrez, Miguel Almacen S
01T0013C Casafranca Lobaton, Erika Caja S
02N0255D Casas Caceres, Rocio Administración S
96E0105U Castañeda Juarez, Julio Cesar Almacen V
02T0054P Galarza Pinedo, Juan Carlos Caja V
99N0133B Garcia Calderon, Fernando Administración C
99L0075H Huaman Ramirez, Luis Angel Almacen D
02T0109B Juarez Velez, Jose Caja C
97N0286D Lopez Malasquez, Milagros Administración S
00M0210A Lozano Castillo, Enrique Almacen D
97T0222D Macedo Cordova, Jesus Caja S
99T0163C Marquez Huaman, Raul Administración C
01N0045R Medina Novoa, Rosa Sarita Almacen D
01M0147B Mendoza Davila, Diego Caja V
01R0112Q Quiroz Salvatierra, Carmen Rosa Administración D
01T0225A Silva Castillo, Rosa Almacen S
01T0018A Tapia Guizasola, Norma Caja D
98N0065B Trujillo Paredes, Manuel Administración S
02T0088C Valderrama Suarez, Marlene Almacen D

TODOS LOS CALCULOS SE EFECTUARAN CONSIDERANDO EL HABER BÁSICO

Seccion Bonif_Extra
Administración 3.50%
Desarrollo 2.80%
Caja 4.20%
Almacen 2.60%

Turno Bonif
1 8.00%
2 6.00%

Aportes Dscto
AFP 13.30%
SNP 12.90%
 Planilla de Pagos de Palacio Real SA

Aportes Turno Haber Básico Bonif Extra

SNP 1 S/. 2,600.00 S/. 91.00
AFP 2 S/. 2,500.00 S/. 87.50
AFP 1 S/. 2,700.00 S/. 70.20
AFP 2 S/. 2,800.00 S/. 117.60
AFP 2 S/. 2,900.00 S/. 101.50
SNP 1 S/. 2,900.00 S/. 75.40
SNP 2 S/. 2,000.00 S/. 84.00
AFP 1 S/. 2,900.00 S/. 101.50
AFP 2 S/. 2,000.00 S/. 52.00
SNP 1 S/. 3,000.00 S/. 126.00
SNP 1 S/. 2,400.00 S/. 84.00
SNP 1 S/. 2,600.00 S/. 67.60
AFP 1 S/. 3,400.00 S/. 142.80
SNP 1 S/. 2,000.00 S/. 70.00
AFP 2 S/. 2,900.00 S/. 75.40
AFP 2 S/. 3,200.00 S/. 134.40
AFP 1 S/. 2,600.00 S/. 91.00
SNP 2 S/. 2,000.00 S/. 52.00
SNP 2 S/. 2,800.00 S/. 117.60
SNP 2 S/. 2,400.00 S/. 84.00
SNP 1 S/. 2,300.00 S/. 59.80

ERANDO EL HABER BÁSICO

Adelanto Quincena
Administrativos el 45%, para los demás el 40% del Haber Básico

Bonificación
5.25% del Haber Básico

Tipo Cambio $US --- 3.35

Pagos de Palacio Real SA

Bonif Est_Civil Bonif Turno Ingresos Dscto_AFP

S/. 136.50 S/. 208.00 S/. 3,035.50 S/. 335.40
S/. 131.25 S/. 150.00 S/. 2,868.75 S/. 332.50
S/. 141.75 S/. 216.00 S/. 3,127.95 S/. 359.10
S/. 147.00 S/. 168.00 S/. 3,232.60 S/. 372.40
S/. 152.25 S/. 174.00 S/. 3,327.75 S/. 385.70
S/. 152.25 S/. 232.00 S/. 3,359.65 S/. 374.10
S/. 105.00 S/. 120.00 S/. 2,309.00 S/. 258.00
S/. 152.25 S/. 232.00 S/. 3,385.75 S/. 385.70
S/. 105.00 S/. 120.00 S/. 2,277.00 S/. 266.00
S/. 157.50 S/. 240.00 S/. 3,523.50 S/. 387.00
S/. 126.00 S/. 192.00 S/. 2,802.00 S/. 309.60
S/. 136.50 S/. 208.00 S/. 3,012.10 S/. 335.40
S/. 178.50 S/. 272.00 S/. 3,993.30 S/. 452.20
S/. 105.00 S/. 160.00 S/. 2,335.00 S/. 258.00
S/. 152.25 S/. 174.00 S/. 3,301.65 S/. 385.70
S/. 168.00 S/. 192.00 S/. 3,694.40 S/. 425.60
S/. 136.50 S/. 208.00 S/. 3,035.50 S/. 345.80
S/. 105.00 S/. 120.00 S/. 2,277.00 S/. 258.00
S/. 147.00 S/. 168.00 S/. 3,232.60 S/. 361.20
S/. 126.00 S/. 144.00 S/. 2,754.00 S/. 309.60
S/. 120.75 S/. 184.00 S/. 2,664.55 S/. 296.70
 Adelanto
Egresos Neto a Pagar Neto US$
Quincena
S/. 1,170.00 $ 1,530.10 S/. 1,505.40 S/. 449.37
S/. 1,125.00 $ 1,411.25 S/. 1,457.50 S/. 435.07
S/. 1,080.00 $ 1,688.85 S/. 1,439.10 S/. 429.58
S/. 1,120.00 $ 1,740.20 S/. 1,492.40 S/. 445.49
S/. 1,305.00 $ 1,637.05 S/. 1,690.70 S/. 504.69
S/. 1,160.00 $ 1,825.55 S/. 1,534.10 S/. 457.94
S/. 800.00 $ 1,251.00 S/. 1,058.00 S/. 315.82
S/. 1,305.00 $ 1,695.05 S/. 1,690.70 S/. 504.69
S/. 800.00 $ 1,211.00 S/. 1,066.00 S/. 318.21
S/. 1,200.00 $ 1,936.50 S/. 1,587.00 S/. 473.73
S/. 1,080.00 $ 1,412.40 S/. 1,389.60 S/. 414.81
S/. 1,040.00 $ 1,636.70 S/. 1,375.40 S/. 410.57
S/. 1,360.00 $ 2,181.10 S/. 1,812.20 S/. 540.96
S/. 900.00 $ 1,177.00 S/. 1,158.00 S/. 345.67
S/. 1,160.00 $ 1,755.95 S/. 1,545.70 S/. 461.40
S/. 1,280.00 $ 1,988.80 S/. 1,705.60 S/. 509.13
S/. 1,170.00 $ 1,519.70 S/. 1,515.80 S/. 452.48
S/. 800.00 $ 1,219.00 S/. 1,058.00 S/. 315.82
S/. 1,120.00 $ 1,751.40 S/. 1,481.20 S/. 442.15
S/. 1,080.00 $ 1,364.40 S/. 1,389.60 S/. 414.81
S/. 920.00 $ 1,447.85 S/. 1,216.70 S/. 363.19
 RELACION DE CUOTAS PAGADAS Y NO PAGADAS

Calcular las columnas faltantes según los indicadores establecidos y luego edite una Tabla Dinamica
Determine la Suma y Promedios de los Ingresos, Intereses la Cantidad de Movimientos
(imagen de muestra)

Fecha Indicadores 1.350% 0.085% 0.005% 5.000%

Nº de Crédito Cliente Moneda Estado Monto a Pagar Interés Seg. Des. Seg. Bien Com. Adm. Total
10016419 ANICETO ESTRADA KARINA M.E Pagada 442.00 5.97 0.38 0.02 22.10 470.46
10016544 BURGA RAMOS SUSSAN NOHELY M.N Impaga 389.00 5.25 0.33 0.02 19.45 414.05
10016655 CAYCAY SAENZ GIANINA M.E Impaga 603.00 8.14 0.51 0.03 30.15 641.83
10016885 ESPINOZA VERDE IVES OMAR M.E Pagada 352.00 4.75 0.30 0.02 17.60 374.67
10016996 GAMBOA CHAPIAMA RENZO JOEL M.E Impaga 552.00 7.45 0.47 0.03 27.60 587.55
10017291 GLADYS MARIA BIONDI CORDOVA M.E Pagada 613.00 8.28 0.52 0.03 30.65 652.48
10022018 GUILLEN MORENO PERCY OMAR M.E Impaga 453.00 6.12 0.39 0.02 22.65 482.17
10027759 JOAQUIN HEREDIA JOHANNA SOLEDAD M.E Pagada 556.00 7.51 0.47 0.03 27.80 591.81
10047592 REYES LAZO GLORIA MARIA M.E Pagada 401.00 5.41 0.34 0.02 20.05 426.82
10051816 ROJAS RODRIGUEZ JASSON MANUEL M.E Pagada 479.00 6.47 0.41 0.02 23.95 509.85
10052953 SAMANIEGO REYES JEREMIE ANDRES M.N Pagada 597.00 8.06 0.51 0.03 29.85 635.45
10063759 SILVA DE LOS SANTOS DAVID ROMELIO M.N Impaga 411.00 5.55 0.35 0.02 20.55 437.47
10064250 UBILLUS RIVERA CLAVER DANIEL M.N Impaga 620.00 8.37 0.53 0.03 31.00 659.93
10067257 ZAMUDIO CAYCHO MAYRA ALEXANDRA M.E Pagada 459.00 6.20 0.39 0.02 22.95 488.56
10070450 ALIAGA MANRIQUE ROMMY ALEXANDRA M.N Impaga 389.00 5.25 0.33 0.02 19.45 414.05
10070952 BRAVO SEGUIN CATHERINE AMALIA M.N Pagada 445.00 6.01 0.38 0.02 22.25 473.66
10071542 CALLE SIHUAY MARJORIE MADELEINE M.E Impaga 505.00 6.82 0.43 0.03 25.25 537.52
10071789 CARDENAS SOTO SINDY BANEZA M.E Impaga 351.00 4.74 0.30 0.02 17.55 373.60
10072239 CARLOS MUGRUZA NATALI ALEXA M.E Impaga 448.00 6.05 0.38 0.02 22.40 476.85
10073141 CARRANZA VASQUEZ NELVA M.N Impaga 522.00 7.05 0.44 0.03 26.10 555.62
10073633 CAUSSO ZAMUDIO ALISSON MISHEL M.E Pagada 398.00 5.37 0.34 0.02 19.90 423.63
10077449 CCAHUAY ATOCCSA EDGAR M.E Pagada 489.00 6.60 0.42 0.02 24.45 520.49
10077821 CHIRINOS RUBIO DIANA CAROLINA M.N Pagada 510.00 6.89 0.43 0.03 25.50 542.84
10078022 DOMINGUEZ LOPEZ LUIS FELIPE M.N Impaga 548.00 7.40 0.47 0.03 27.40 583.29
10078662 GELLER SILVA MARCOS GIOVANNI M.E Pagada 552.00 7.45 0.47 0.03 27.60 587.55
10078742 GOMEZ RUIDIAS MERLY M.E Pagada 435.00 5.87 0.37 0.02 21.75 463.01
10078779 GUTIERREZ ANGULO CHRISTIAN EDUARDO M.E Pagada 372.00 5.02 0.32 0.02 18.60 395.96
10078963 HUAMAN CONGA JIMMY ALFREDO M.N Impaga 371.00 5.01 0.32 0.02 18.55 394.89
10079388 HUATANGARI PERALES ROSI M.E Impaga 390.00 5.27 0.33 0.02 19.50 415.12
10079535 LOARTE PACHAO CARLOS ALEXANDER M.E Impaga 530.00 7.16 0.45 0.03 26.50 564.13
10079711 MAMANI ALEGRIA CARMEN ROSA M.E Impaga 466.00 6.29 0.40 0.02 23.30 496.01
10079819 MATOS IBARRA NATHALY M.E Impaga 537.00 7.25 0.46 0.03 26.85 571.58
10080412 MENDOZA SANCHEZ ANETH GIANNINA M.E Pagada 491.00 6.63 0.42 0.02 24.55 522.62
10081064 MERA LAZO MARIA DEL PILAR M.N Impaga 590.00 7.97 0.50 0.03 29.50 628.00
10081607 ORDOÑEZ SOLANO DEYSI VANESSA M.N Pagada 523.00 7.06 0.44 0.03 26.15 556.68
10081629 ORIUNDO SANTOS EDUARDO JUNIOR M.N Pagada 394.00 5.32 0.33 0.02 19.70 419.37
10081961 PENKO DIEZ ANTONIO M.N Impaga 433.00 5.85 0.37 0.02 21.65 460.89
10082055 REYES MORALES ALMENDRA SOL MARIA M.N Impaga 427.00 5.76 0.36 0.02 21.35 454.50
10082443 SALINAS GALLARDO DENNIS OMAR M.E Impaga 441.00 5.95 0.37 0.02 22.05 469.40
10082669 SANCHEZ SALON MELISSA ALEXANDRA M.N Impaga 587.00 7.92 0.50 0.03 29.35 624.80
10082753 SEDANO BARRETO GABRIELA M.N Pagada 521.00 7.03 0.44 0.03 26.05 554.55
10083170 TUANAMA ISUIZA SAULO M.N Pagada 470.00 6.35 0.40 0.02 23.50 500.27
10083184 VARGAS MELENDEZ KEVIN M.N Pagada 472.00 6.37 0.40 0.02 23.60 502.40
10084075 ZAVALA GARCIA KARINA LISBETH M.N Impaga 386.00 5.21 0.33 0.02 19.30 410.86
10084101 ADANAQUE SOSA GUIDO GHINO PAOLI M.N Impaga 586.00 7.91 0.50 0.03 29.30 623.74
10084135 ARRIETA VARGAS YHAN PHOLL M.E Impaga 493.00 6.66 0.42 0.02 24.65 524.75
10084163 ATAMARI MARTINEZ SANDY FIORELA M.N Pagada 478.00 6.45 0.41 0.02 23.90 508.78
10084188 CABRERA HUAMANI NANCY M.N Pagada 510.00 6.89 0.43 0.03 25.50 542.84
10084342 CAMPOS DIAZ FANNY JACQUELINE M.N Pagada 523.00 7.06 0.44 0.03 26.15 556.68
10084777 CHAMORRO VALER ELVA M.N Impaga 486.00 6.56 0.41 0.02 24.30 517.30
10085054 FLORES BENAVIDES CYNTHIA VANESA M.N Pagada 561.00 7.57 0.48 0.03 28.05 597.13
10085181 HERNANDEZ RODRIGUEZ MARIA PAOLA M.N Impaga 610.00 8.24 0.52 0.03 30.50 649.28
10085341 LUCIANO GRANDE LIZBETH DEL PILAR M.E Pagada 465.00 6.28 0.40 0.02 23.25 494.95
10085506 MOTESINOS GIL GERALDINE ARIANA M.E Pagada 488.00 6.59 0.41 0.02 24.40 519.43
10085635 OVALLE APONTE PEDRO DAVID M.E Impaga 457.00 6.17 0.39 0.02 22.85 486.43
10086034 PALOMINO LOA KIMBERLY M.E Pagada 509.00 6.87 0.43 0.03 25.45 541.78
10086165 PISCOYA CALLE MAURICIO ALONSO M.N Pagada 430.00 5.81 0.37 0.02 21.50 457.69
10086266 PUCUAYLA CABRERA LESLIE BRIGITTE M.N Impaga 460.00 6.21 0.39 0.02 23.00 489.62
10086363 REQUENA CALDERÓN MILAGRITOS MORAYMA M.E Impaga 469.00 6.33 0.40 0.02 23.45 499.20
10086559 RÍOS HUAMANÍ JUDITH SANDRA M.N Pagada 554.00 7.48 0.47 0.03 27.70 589.68
10086716 SILVA LAMAS IVONNEY FATIMA M.N Impaga 605.00 8.17 0.51 0.03 30.25 643.96
10086834 SOLIS ZEVALLOS ANGIE MARIBEL M.E Pagada 594.00 8.02 0.50 0.03 29.70 632.25
10087182 TAPIA CHAVEZ ROSA ELVIRA M.E Impaga 384.00 5.18 0.33 0.02 19.20 408.73
10087269 TAPIA CHAVEZ JAZMIN M.N Impaga 560.00 7.56 0.48 0.03 28.00 596.06
10087315 VASQUEZ REATEGUI FRANCO PAOLO M.E Pagada 549.00 7.41 0.47 0.03 27.45 584.36
10087394 VERA NIETO JORGE LUIS M.E Pagada 568.00 7.67 0.48 0.03 28.40 604.58
10087458 ANGELES RODRIGUEZ DE SOUZA, ERICKA JOHANNA M.E Pagada 356.00 4.81 0.30 0.02 17.80 378.93
10087610 ASCUE TELLO, VANESSA CYNTHIA M.N Pagada 593.00 8.01 0.50 0.03 29.65 631.19
10087784 CAMPANA MESAHUANCA, PERCY M.N Pagada 591.00 7.98 0.50 0.03 29.55 629.06
10087904 CASTILLO BAES, FRANK ERICK M.N Impaga 387.00 5.22 0.33 0.02 19.35 411.92
10088053 DIAZ MANRIQUE, AMY YRENE M.E Pagada 391.00 5.28 0.33 0.02 19.55 416.18
10088218 DURAND MAMANI, ELSA ANDREA M.N Impaga 470.00 6.35 0.40 0.02 23.50 500.27
Fecha: 12/15/2023 B9085 Página 5/14
 10088356 GALLEGOS , KARLO ANDREE M.N Impaga 500.00 6.75 0.43 0.03 25.00 532.20
10088514 GARCIA MENDOZA, MARINA M.N Pagada 448.00 6.05 0.38 0.02 22.40 476.85
10088648 JUAREZ CASTAÑEDA, RONALD BRIAN M.N Impaga 509.00 6.87 0.43 0.03 25.45 541.78
10088722 JUAREZ PEREZ, FRANZ RONALD M.E Pagada 372.00 5.02 0.32 0.02 18.60 395.96
10088787 OLIVARES HUAMANCHA, LUIS ENRIQUE M.E Pagada 367.00 4.95 0.31 0.02 18.35 390.63
10088882 PADILLA SAMAMÉ, TANI ROSI M.N Impaga 394.00 5.32 0.33 0.02 19.70 419.37
10089293 PEREZ MARCELO, ANA MARIA M.N Impaga 539.00 7.28 0.46 0.03 26.95 573.71
10089451 RAMIREZ CUETO, JHOSELYN DEBORA M.N Pagada 607.00 8.19 0.52 0.03 30.35 646.09
10089668 VARGAS ORDOÑEZ, ANA MARIA M.N Impaga 500.00 6.75 0.43 0.03 25.00 532.20
10090060 VILLAR CANALES, STEFANO RODRIGO M.E Impaga 370.00 5.00 0.31 0.02 18.50 393.83
10090189 VITTERY LOPEZ, LUZ ANGELICA M.N Impaga 478.00 6.45 0.41 0.02 23.90 508.78
10090384 ZAPATA RODRIGUEZ, RENATO M.N Impaga 581.00 7.84 0.49 0.03 29.05 618.42
10090422 AQUINO BARJA, MARIA ESTHER M.E Impaga 443.00 5.98 0.38 0.02 22.15 471.53
10090574 CARRASCAL TAYSCO, FRANSISCO M.N Pagada 363.00 4.90 0.31 0.02 18.15 386.38
10090610 CARRION CACERES, DANIEL M.E Pagada 394.00 5.32 0.33 0.02 19.70 419.37
10090702 COLLAN MOSCOSO, JACKELINE LOREAN M.N Impaga 547.00 7.38 0.46 0.03 27.35 582.23
10090709 CUZCANO HINOJO, RICHARD M.E Impaga 378.00 5.10 0.32 0.02 18.90 402.34
10090714 DAVILA SILVA, VALERIA M.N Pagada 387.00 5.22 0.33 0.02 19.35 411.92
10090795 ESPINOZA MUÑOZ, MIGUEL ANGEL M.N Pagada 485.00 6.55 0.41 0.02 24.25 516.23
10091108 GIBAJA ALVAREZ, DANIEL M.E Impaga 451.00 6.09 0.38 0.02 22.55 480.04
10091117 NAJARRO LIZARBE, SHEYLA M.N Pagada 607.00 8.19 0.52 0.03 30.35 646.09
10091123 NEYRA VASQUEZ JHOSMIL M.N Pagada 530.00 7.16 0.45 0.03 26.50 564.13
10091502 PAZ CUROTTO, MARVIN JESUS M.N Pagada 555.00 7.49 0.47 0.03 27.75 590.74
10091551 PORRAS LLANTO, SAAHONY GIANELLA M.N Impaga 424.00 5.72 0.36 0.02 21.20 451.31
10091587 QUEVEDO DELGADO, PIER M.N Impaga 387.00 5.22 0.33 0.02 19.35 411.92
10091659 RAMIREZ QUISPE, ELIZABETH M.E Pagada 411.00 5.55 0.35 0.02 20.55 437.47
10091779 REYNOSO LOA, KATHERINE VICTORIA M.N Pagada 496.00 6.70 0.42 0.02 24.80 527.94
10091949 ROJAS CHOQUE, PAMELA SAM M.N Pagada 509.00 6.87 0.43 0.03 25.45 541.78
10092014 RONDÓN CÉSPEDES, ESTELA GUADALUPE M.N Pagada 376.00 5.08 0.32 0.02 18.80 400.21
10092041 SANTOS ALANIA, MARYLIN KETTY M.E Impaga 386.00 5.21 0.33 0.02 19.30 410.86
10092067 VALLADARES HILARIO, SAUL M.N Pagada 550.00 7.43 0.47 0.03 27.50 585.42
10092070 VELIZ CARDENAS, HARRY M.E Impaga 501.00 6.76 0.43 0.03 25.05 533.26
10092154 ABANTO HERRERA, NORMA GLADIS M.E Pagada 416.00 5.62 0.35 0.02 20.80 442.79
10092270 ABARCA ROSAS, LISETTE SUSAN M.N Pagada 492.00 6.64 0.42 0.02 24.60 523.68
10092271 ALVAREZ CUADROS, JEFFERSON MARCELO M.N Impaga 414.00 5.59 0.35 0.02 20.70 440.66
10092282 ANDONAIRE FARIAS, BRUNO SEBASTIAN M.N Pagada 580.00 7.83 0.49 0.03 29.00 617.35
10092557 ANICAMA VARGAS, ALEXIS EUGENIO M.E Impaga 572.00 7.72 0.49 0.03 28.60 608.84
10092561 BEINGOLEA ALEXANDRINO, ALBERTO RAI M.N Pagada 416.00 5.62 0.35 0.02 20.80 442.79
10092598 CACERES CUELLAR, CAROL MARILYN M.N Pagada 596.00 8.05 0.51 0.03 29.80 634.38
10092777 CAFFERATA CALDERON, GIAN CARLO M.E Impaga 596.00 8.05 0.51 0.03 29.80 634.38
10092808 CUTIPA FLORES, VICTORIA MARIALUZ M.E Impaga 513.00 6.93 0.44 0.03 25.65 546.04
10092914 DAVILA MARTINEZ, ALAN JOEL M.N Pagada 462.00 6.24 0.39 0.02 23.10 491.75
10093054 DEL CARPIO SIFUENTES, OSCAR DANIEL M.N Pagada 603.00 8.14 0.51 0.03 30.15 641.83
10093098 GUZMAN BOBADILLA, MONICA PATRICIA M.N Pagada 590.00 7.97 0.50 0.03 29.50 628.00
10093104 LARA CABRERA, LETICIA RUTH M.E Pagada 581.00 7.84 0.49 0.03 29.05 618.42
10093108 MACINES SANCHEZ, ALEJANDRO PHILLIPS M.E Pagada 431.00 5.82 0.37 0.02 21.55 458.76
10093206 OREJON AGUILAR, LUIS EDWIN M.E Pagada 563.00 7.60 0.48 0.03 28.15 599.26
10093381 PARIONA OSCCO, RICARDO M.N Pagada 492.00 6.64 0.42 0.02 24.60 523.68
10093396 RAFAEL YAURI, JORDAN MARTIN M.E Pagada 391.00 5.28 0.33 0.02 19.55 416.18
10093404 RAMOS UCHUYA, EMILIO MARCELO M.N Pagada 574.00 7.75 0.49 0.03 28.70 610.97
10093467 RIVAS ROMERO, RICARDO ANDRE M.E Pagada 461.00 6.22 0.39 0.02 23.05 490.69
10093510 VARGAS BENITO, ERICK ALEXANDER M.N Impaga 619.00 8.36 0.53 0.03 30.95 658.86
10093554 VIZCARRA VELASQUEZ, HECTOR HAROLD M.N Impaga 549.00 7.41 0.47 0.03 27.45 584.36
10093559 ABURTO REAL, KATHERINE M.N Impaga 612.00 8.26 0.52 0.03 30.60 651.41
10093560 ARAUJO MAMANI , MARILYN ESTHER M.E Impaga 610.00 8.24 0.52 0.03 30.50 649.28
10093564 AREVALO SANTE, ROSITA IVETTE M.E Impaga 563.00 7.60 0.48 0.03 28.15 599.26
10093576 ARRUNATEGUI SAAVEDRA, FRANCISCO JESUS M.N Impaga 612.00 8.26 0.52 0.03 30.60 651.41
10093674 CABALLERO QUISPE, FARAH DIMELZA M.E Impaga 453.00 6.12 0.39 0.02 22.65 482.17
10093682 CALDERON QUISPE , PAMELA ESTEFANY M.N Pagada 464.00 6.26 0.39 0.02 23.20 493.88
10093704 CAMPOS TAIPE, MARIA ISABEL M.N Pagada 592.00 7.99 0.50 0.03 29.60 630.12
10093708 CARDENAS QUISPE, BEQUER SAMUEL M.E Impaga 452.00 6.10 0.38 0.02 22.60 481.11
10093739 CARHUATANTA GALVAN CINTHYA M.E Pagada 398.00 5.37 0.34 0.02 19.90 423.63
10093748 CERRON CONDOR, YOHANA GRACIELA M.E Impaga 468.00 6.32 0.40 0.02 23.40 498.14
10093751 CHALCO EVANGELISTA, AYLIN CAROLYN M.N Impaga 585.00 7.90 0.50 0.03 29.25 622.67
10093752 COLAN PEREZ ALBERT JOSEPH M.E Impaga 551.00 7.44 0.47 0.03 27.55 586.48
10093754 COLOMA ACOSTA, ISABEL M.E Impaga 452.00 6.10 0.38 0.02 22.60 481.11
10093959 CUSI RENGIFO, KETTY JANET M.E Pagada 533.00 7.20 0.45 0.03 26.65 567.33
10094032 FELIX GAMARRA MARIO M.E Pagada 435.00 5.87 0.37 0.02 21.75 463.01
10094055 FLORES NARCIZO, SHARON EVELYN M.E Pagada 570.00 7.70 0.48 0.03 28.50 606.71
10094100 GUIDICHE PERONA, FABRIZIO JESUS M.E Pagada 557.00 7.52 0.47 0.03 27.85 592.87
10094118 HUAMANCHUMO PORRAS, YULISSA MARGARITA M.E Impaga 554.00 7.48 0.47 0.03 27.70 589.68
10094135 LAVADO APOLINARIO, MAYRA ROMINA M.E Pagada 518.00 6.99 0.44 0.03 25.90 551.36
10094136 MOSQUERA VELARDE, ANALY M.N Impaga 431.00 5.82 0.37 0.02 21.55 458.76
10094179 NOLASCO VILCAS , LUIS ANGEL M.N Impaga 602.00 8.13 0.51 0.03 30.10 640.77
10094189 ORTIZ VILLANTAY, JOSE RODOLFO M.N Pagada 508.00 6.86 0.43 0.03 25.40 540.72
10094197 PACHECO MELO, JULISSA ISABEL M.N Impaga 448.00 6.05 0.38 0.02 22.40 476.85
10094220 PARVINA YUPANQUI, KAROL KOWIN M.N Pagada 441.00 5.95 0.37 0.02 22.05 469.40
10094318 PEÑARES GUILLEN, JOSEPH ANTHONY M.E Impaga 524.00 7.07 0.45 0.03 26.20 557.75
10094328 PINTO DIAZ, LESLYE M.E Pagada 470.00 6.35 0.40 0.02 23.50 500.27
10094333 ROSAS RIVAS, JEANPIERR M.E Impaga 614.00 8.29 0.52 0.03 30.70 653.54
10094465 SANTOS LASTRA, RODRIGO JAÍR SAMUEl M.E Impaga 590.00 7.97 0.50 0.03 29.50 628.00
10094474 TABORI RIVAS, MARCELA RAQUEL M.N Impaga 413.00 5.58 0.35 0.02 20.65 439.60
10094476 URQUIAGA LLACSAHUANGA, MILAGROS M.E Pagada 540.00 7.29 0.46 0.03 27.00 574.78
10094507 VALDEZ DE LA CRUZ, CLAUDIA LISSETH M.E Pagada 584.00 7.88 0.50 0.03 29.20 621.61
10094632 VELAZQUE CARDENAS, LUIS ALBERTO M.E Pagada 544.00 7.34 0.46 0.03 27.20 579.03
10094640 ALCALDE ROCHA, CESAR ANTONIO M.N Pagada 450.00 6.08 0.38 0.02 22.50 478.98
10094645 APAZA AROTINCO, MARIANA LUCIA M.N Impaga 545.00 7.36 0.46 0.03 27.25 580.10
10094676 ARQUIÑEGO ZARATE, GINA NAYDU ARACELY M.E Pagada 561.00 7.57 0.48 0.03 28.05 597.13
10094740 BENDEZU ARAUCO, NAYELI DIANA M.E Pagada 566.00 7.64 0.48 0.03 28.30 602.45
10094747 CABELLO CANCHARI, VANESSA NATALIA M.E Impaga 463.00 6.25 0.39 0.02 23.15 492.82
10094770 CCOICCA LERNAQUE, NANCY MILAGROS M.E Impaga 352.00 4.75 0.30 0.02 17.60 374.67
10094801 CHANAMÉ LLONTOP, ALDAIR SEGUNDO M.E Pagada 552.00 7.45 0.47 0.03 27.60 587.55
10094883 CHAVESTA PAREDES, JASON JOEL M.N Impaga 440.00 5.94 0.37 0.02 22.00 468.34
10094931 GUILLEN CHIRIO, ANGEL ALBERTO M.E Impaga 386.00 5.21 0.33 0.02 19.30 410.86
10094935 HERNANDEZ MEDINA , MARÍA M.E Pagada 581.00 7.84 0.49 0.03 29.05 618.42
Fecha: 12/15/2023 B9085 Página 6/14
 10094953 HOSPINA FUSTER, CLAUDIA MARÍA M.E Impaga 372.00 5.02 0.32 0.02 18.60 395.96
10095047 HUAMAN INOCENTE, SEIRA KATHERINE M.E Impaga 373.00 5.04 0.32 0.02 18.65 397.02
10095170 HUAMANI ANTONIO, JUDITH MANUELA M.N Pagada 567.00 7.65 0.48 0.03 28.35 603.51
10095181 LEIVA TORRES, EDISON M.E Impaga 360.00 4.86 0.31 0.02 18.00 383.18
10095187 MALON BAZAN, RONALD LEONARDO M.N Pagada 515.00 6.95 0.44 0.03 25.75 548.17
10095205 PILCO AYALA, GISSELA ELIZABETH M.N Impaga 598.00 8.07 0.51 0.03 29.90 636.51
10095243 PORTA ORIHUELA, DAVID OMAR M.E Pagada 608.00 8.21 0.52 0.03 30.40 647.16
10095246 ROJAS ROMAN, ROSA JULIA M.E Pagada 389.00 5.25 0.33 0.02 19.45 414.05
10095295 SANDOVAL BOLAÑOS, VICTOR HUBERT M.N Pagada 372.00 5.02 0.32 0.02 18.60 395.96
10095307 SUCA ALVARADO, YUREMA NOEMI M.E Pagada 542.00 7.32 0.46 0.03 27.10 576.90
10095312 VARGAS ABANTO LUZ MARILU M.N Pagada 617.00 8.33 0.52 0.03 30.85 656.73
10095473 YUPANQUI GARCIA, GLADYS CINZIA M.N Pagada 472.00 6.37 0.40 0.02 23.60 502.40
10095486 CASTILLO PAUCAR, LINDA M.N Impaga 369.00 4.98 0.31 0.02 18.45 392.76
10095549 CAYETANO MARTINEZ, MICHAEL M.E Pagada 481.00 6.49 0.41 0.02 24.05 511.98
10095610 CHILET PATIÑO PATRONI, LUCIANO M.N Impaga 360.00 4.86 0.31 0.02 18.00 383.18
10095650 CHOQUE ESCOBAR, MELANIE M.N Pagada 479.00 6.47 0.41 0.02 23.95 509.85
10095651 CUEVA HUILLCA, DANIEL M.N Pagada 560.00 7.56 0.48 0.03 28.00 596.06
10095664 DE LA CRUZ ECHEGARAY, LUIS M.N Impaga 586.00 7.91 0.50 0.03 29.30 623.74
10095668 ENERO BARZOLA. JASMIN M.E Impaga 410.00 5.54 0.35 0.02 20.50 436.40
10095685 ENRIQUEZ BARRERA, LADY M.N Impaga 353.00 4.77 0.30 0.02 17.65 375.73
10095694 FLORES NIETO, DENNIS M.E Impaga 525.00 7.09 0.45 0.03 26.25 558.81
10095746 GALLO BUENO, JAVIER M.E Pagada 615.00 8.30 0.52 0.03 30.75 654.61
10095747 GARCIA MICHER SANDRA M.E Pagada 469.00 6.33 0.40 0.02 23.45 499.20
10095783 GUERRERO FUENTES, VICTOR M.E Impaga 385.00 5.20 0.33 0.02 19.25 409.79
10095817 HOYOS ZEVALLOS, CARLOS M.E Pagada 483.00 6.52 0.41 0.02 24.15 514.11
10095847 LI GIRON, MARIAJOSE M.N Impaga 497.00 6.71 0.42 0.02 24.85 529.01
10095849 MAMANI URUCHI, WILSON M.N Impaga 381.00 5.14 0.32 0.02 19.05 405.54
10095868 MANZANARES CASTAÑEDA, ANTONIO M.N Impaga 443.00 5.98 0.38 0.02 22.15 471.53
10095886 Medina Luy, Karen Alejandra M.N Pagada 500.00 6.75 0.43 0.03 25.00 532.20
10095904 MELGAREJO RAMIREZ, MARITZA M.E Pagada 392.00 5.29 0.33 0.02 19.60 417.24
10095920 MIRANDA AYANZ, ELLDY M.E Pagada 444.00 5.99 0.38 0.02 22.20 472.59
10095929 MOSCOSO ALTAMIRANO, YASMIN M.E Pagada 536.00 7.24 0.46 0.03 26.80 570.52
10095932 PACHAS PACHAS, DEREK M.E Impaga 563.00 7.60 0.48 0.03 28.15 599.26
10095949 PINAZO PEREZ, ISABEL M.N Pagada 466.00 6.29 0.40 0.02 23.30 496.01
10095951 QUISPE FLORES, ELIZABETH M.E Impaga 491.00 6.63 0.42 0.02 24.55 522.62
10095994 QUISPE QUISPE, AARON M.N Pagada 365.00 4.93 0.31 0.02 18.25 388.51
10095999 REVES SALAZAR, OMAR M.N Impaga 396.00 5.35 0.34 0.02 19.80 421.50
10096000 ROMAN SOLIS, LUIS M.N Pagada 432.00 5.83 0.37 0.02 21.60 459.82
10096023 ROMERO VELAZCO, HUGO M.E Impaga 531.00 7.17 0.45 0.03 26.55 565.20
10096027 ROQUE ORIHUELA, JOSUE M.E Impaga 523.00 7.06 0.44 0.03 26.15 556.68
10096112 SANCHEZ ROJAS, JOSSELIN M.N Impaga 478.00 6.45 0.41 0.02 23.90 508.78
10096143 SANGUINETI AGUILAR, ANTONELLA M.N Impaga 406.00 5.48 0.35 0.02 20.30 432.15
10096145 TAJIRI CASTILLO, ANDY M.E Pagada 362.00 4.89 0.31 0.02 18.10 385.31
10096175 TORIBIO POMA, JHORDY M.N Impaga 611.00 8.25 0.52 0.03 30.55 650.35
10096241 TORRES MARIN, RAUL M.N Pagada 578.00 7.80 0.49 0.03 28.90 615.22
10096311 VALVERDE CERNA, SANDRA M.E Pagada 520.00 7.02 0.44 0.03 26.00 553.49
10096366 VEGA SULCA, HERNAN M.E Pagada 444.00 5.99 0.38 0.02 22.20 472.59
10096367 FARFAN CARRASCO PABLO M.N Pagada 618.00 8.34 0.53 0.03 30.90 657.80
10096369 ALEGRE GALARZA LUIS ALBERTO M.E Pagada 548.00 7.40 0.47 0.03 27.40 583.29
10096393 ANGELES CHUMBE SANDRA M.N Pagada 471.00 6.36 0.40 0.02 23.55 501.33
10096416 ARTEAGA HUAROTO LILIANA M.N Pagada 456.00 6.16 0.39 0.02 22.80 485.37
10096433 BALCAZAR IPURRE JACQUELINE M.E Impaga 497.00 6.71 0.42 0.02 24.85 529.01
10096447 BAZZOCHI COLLADO ORLANDO JOEL M.E Impaga 521.00 7.03 0.44 0.03 26.05 554.55
10096453 BENDEZU MAMANI KAYLA CAROL M.E Pagada 350.00 4.73 0.30 0.02 17.50 372.54
10096512 CACHAY BALDERA JOHN M.E Impaga 422.00 5.70 0.36 0.02 21.10 449.18
10096527 CANELO ROMANI JEINNER ERISON M.E Pagada 612.00 8.26 0.52 0.03 30.60 651.41
10096598 CASTILLO GARCIA NORMAN M.E Impaga 360.00 4.86 0.31 0.02 18.00 383.18
10096605 CUZCANO SÁNCHEZ JEISON TEOBALDO M.E Impaga 427.00 5.76 0.36 0.02 21.35 454.50
10096618 DE LA CRUZ HERNÁNDEZ VICTOR ARNALDO M.E Impaga 419.00 5.66 0.36 0.02 20.95 445.98
10096643 FLORES MUÑOZ MELISSA PAOLA M.N Impaga 380.00 5.13 0.32 0.02 19.00 404.47
10096658 GALLARDO RONDON KEVIN RONALD M.E Impaga 479.00 6.47 0.41 0.02 23.95 509.85
10096676 GARCIA RIVERA OSCAR EDUARDO DANIEL M.E Impaga 483.00 6.52 0.41 0.02 24.15 514.11
10096749 GENG SOLIS JULIO M.N Impaga 470.00 6.35 0.40 0.02 23.50 500.27
10096750 GONZALES GOMEZ LILIANA MILAGROS M.N Pagada 507.00 6.84 0.43 0.03 25.35 539.65
10096792 HUARACHI VARGAS DIANA STEPHANY M.N Pagada 547.00 7.38 0.46 0.03 27.35 582.23
10096804 JIMENEZ MORAN BRIAN FRANCISCO M.N Pagada 539.00 7.28 0.46 0.03 26.95 573.71
10096809 JURADO BERNA EDUARDO FRANCISCO M.N Impaga 419.00 5.66 0.36 0.02 20.95 445.98
10096838 NUÑEZ HERRERA MILDRED MELISSA M.N Impaga 419.00 5.66 0.36 0.02 20.95 445.98
10096842 PAREDES MUNASCA JENNY MARIA M.E Pagada 518.00 6.99 0.44 0.03 25.90 551.36
10096865 PEÑA VASQUEZ CHERELYN M.N Impaga 461.00 6.22 0.39 0.02 23.05 490.69
10096873 PFOCCO SAYRE GLADYS MÓNICA M.E Pagada 563.00 7.60 0.48 0.03 28.15 599.26
10096888 POMA RAMIREZ FERNANDO M.N Pagada 478.00 6.45 0.41 0.02 23.90 508.78
10096941 RAMOS HUAMAN DAYANA ESTHEFANI M.N Impaga 593.00 8.01 0.50 0.03 29.65 631.19
10096944 RISCO VERA TULA ROSA M.E Impaga 620.00 8.37 0.53 0.03 31.00 659.93
10096956 ROJAS DIEGO CYNTHIA ISABEL M.N Impaga 445.00 6.01 0.38 0.02 22.25 473.66
10096984 SANCHEZ PEÑA YRMA MARGARITA M.E Impaga 434.00 5.86 0.37 0.02 21.70 461.95
10096996 TAPIA IBARGUEN NICOLE GILLARI M.E Impaga 560.00 7.56 0.48 0.03 28.00 596.06
10096999 TEJADA MESIAS LUIS ISIDORO M.N Pagada 610.00 8.24 0.52 0.03 30.50 649.28
10097008 TURPO HINOSTROZA LIZETH ROSARIO M.N Impaga 586.00 7.91 0.50 0.03 29.30 623.74
10097017 VALERIANO GAVILAN LUIS MIGUEL M.E Pagada 470.00 6.35 0.40 0.02 23.50 500.27
10097025 VIGIL VILLANUEVA MAYRA M.E Impaga 375.00 5.06 0.32 0.02 18.75 399.15
10097032 VILLACORTA ARIAS SUSSY M.N Impaga 491.00 6.63 0.42 0.02 24.55 522.62
10097038 VILLARREAL ESPADA YUDI M.N Impaga 382.00 5.16 0.32 0.02 19.10 406.60
10097063 MIÑAN DE PALACIOS ISABEL PRISCILLA M.E Impaga 501.00 6.76 0.43 0.03 25.05 533.26
10097074 CENTENO SOTO JACINTO EMILIANO M.E Impaga 527.00 7.11 0.45 0.03 26.35 560.94
10097100 NORABUENA TOLEDO MARCO ANTONIO M.N Impaga 620.00 8.37 0.53 0.03 31.00 659.93
10097124 PECEROS OSCCO MARY ELSA M.E Impaga 396.00 5.35 0.34 0.02 19.80 421.50
10097139 PALMA ROLDAN LUIS ANTONIO M.E Impaga 404.00 5.45 0.34 0.02 20.20 430.02
10097169 AYALA QUIROZ MIGUEL ERNESTO M.N Pagada 433.00 5.85 0.37 0.02 21.65 460.89
10097360 VALENCIA HUACCHILLO AMABLE M.N Pagada 551.00 7.44 0.47 0.03 27.55 586.48
10097387 CONTRERAS BENITES EDGAR MARTIN M.E Impaga 467.00 6.30 0.40 0.02 23.35 497.07
10097397 CARHUAS YARANGA EFRAIN MARTIN M.E Impaga 381.00 5.14 0.32 0.02 19.05 405.54
10097407 PONSECA CCAHUIN FELIPE M.N Impaga 382.00 5.16 0.32 0.02 19.10 406.60
10097470 LECAROS VILLARREAL HELDA ELENA M.N Pagada 546.00 7.37 0.46 0.03 27.30 581.16
10097499 SAMANIEGO CASTRO AGUSTIN M.E Pagada 353.00 4.77 0.30 0.02 17.65 375.73
Fecha: 12/15/2023 B9085 Página 7/14
 10097511 TUANAMA ARELLANO ELIAS M.E Pagada 488.00 6.59 0.41 0.02 24.40 519.43
10097544 TOMAYLLA QUISPE NILDA GUMERCINDA M.E Pagada 481.00 6.49 0.41 0.02 24.05 511.98
10097556 CHIRITO QUINECHE PEDRO ANTONIO M.E Impaga 552.00 7.45 0.47 0.03 27.60 587.55
10097575 HUALLPA SUPA MARTHA M.N Pagada 506.00 6.83 0.43 0.03 25.30 538.59
10097614 PUENTE MORA JULIAN M.E Impaga 605.00 8.17 0.51 0.03 30.25 643.96
10097629 QUIROZ ARRUNATEGUI KAREEN JULLIANA M.E Impaga 421.00 5.68 0.36 0.02 21.05 448.11
10097697 HUAMAN ESPINOZA ROSA M.E Pagada 571.00 7.71 0.49 0.03 28.55 607.77
10097728 EVANGELISTA MINAYA INES EPIFANIA M.N Impaga 548.00 7.40 0.47 0.03 27.40 583.29
10097888 HUAMAN MERINO ESIQUEL M.N Pagada 578.00 7.80 0.49 0.03 28.90 615.22
10097895 CARDENAS SATURNINO SATURNINO M.N Impaga 593.00 8.01 0.50 0.03 29.65 631.19
10097959 CLEMENTE CUEVA EVA FLORA M.E Impaga 570.00 7.70 0.48 0.03 28.50 606.71
10097990 AUCCACUSI CHOQUE JULIA M.E Impaga 359.00 4.85 0.31 0.02 17.95 382.12
10098005 PACHECO CHAVEZ SERAPIO FILOMENO M.E Impaga 501.00 6.76 0.43 0.03 25.05 533.26
10098035 LEON ARZAPALO CESAR M.E Pagada 408.00 5.51 0.35 0.02 20.40 434.28
10098046 MACASSI SANTIAGO ROMULO OMAR M.N Impaga 428.00 5.78 0.36 0.02 21.40 455.56
10098113 IPURRE SACCATOMA ROGELIO M.N Impaga 454.00 6.13 0.39 0.02 22.70 483.24
10098174 ALVAREZ VALCARCEL EDISON M.E Pagada 514.00 6.94 0.44 0.03 25.70 547.10
10098182 CAVIEDES CONTOL REINA M.N Impaga 377.00 5.09 0.32 0.02 18.85 401.28
10098198 ESTRADA CUNYAS ZENAIDA M.N Pagada 540.00 7.29 0.46 0.03 27.00 574.78
10098218 YOVERA GONZALES MARIA ARACELI M.E Impaga 483.00 6.52 0.41 0.02 24.15 514.11
10098224 RUNACHAHUA ORIHUELA SANTIAGO M.E Impaga 556.00 7.51 0.47 0.03 27.80 591.81
10098240 MAMANI BASURCO JAVIER M.E Impaga 437.00 5.90 0.37 0.02 21.85 465.14
10098260 VICTORIA CHALCO ADELAIDA M.E Pagada 587.00 7.92 0.50 0.03 29.35 624.80
10098320 HUAMAN COCA MARGARITA M.E Impaga 554.00 7.48 0.47 0.03 27.70 589.68
10098344 DAMIAN QUIÑONEZ CLOTILDE M.E Impaga 370.00 5.00 0.31 0.02 18.50 393.83
10098362 ROJAS FAUSTOR NICOLAS M.N Pagada 591.00 7.98 0.50 0.03 29.55 629.06
10098404 PEREZ RAZHUAMAN DESIDERIO M.E Pagada 497.00 6.71 0.42 0.02 24.85 529.01
10098525 SALAZAR ARCE LUCY INEV M.N Pagada 608.00 8.21 0.52 0.03 30.40 647.16
10098529 SANTIVAÑEZ ALE SANDRA ELIZABETH M.E Impaga 570.00 7.70 0.48 0.03 28.50 606.71
10098580 CHAVEZ BURGOS CARLOS MIGUEL M.N Pagada 501.00 6.76 0.43 0.03 25.05 533.26
10098597 ALZAMORA SAAVEDRA GREGORIO ANGEL M.N Pagada 397.00 5.36 0.34 0.02 19.85 422.57
10098611 SUEROS LLAMOCA HIPOLITO ALONZO M.E Pagada 596.00 8.05 0.51 0.03 29.80 634.38
10098676 TORRES DE QUISPE JULIA SABINA M.E Pagada 481.00 6.49 0.41 0.02 24.05 511.98
10098736 CHOQUI MENDOZA ALFREDO JULIAN M.N Pagada 466.00 6.29 0.40 0.02 23.30 496.01
10098807 SUAREZ BURGA ANGELICA ROSANA M.N Pagada 414.00 5.59 0.35 0.02 20.70 440.66
10098849 OLAZABAL RIVERO TOMAS ATILIO M.E Impaga 595.00 8.03 0.51 0.03 29.75 633.32
10098997 VASQUEZ VALDERRAMA TITO JOSELITO M.N Impaga 413.00 5.58 0.35 0.02 20.65 439.60
10099008 ALONSO RONQUILLO GENRY LUIS M.N Impaga 443.00 5.98 0.38 0.02 22.15 471.53
10099046 VALDERRAMA VASQUEZ SILVIA PILAR M.N Impaga 418.00 5.64 0.36 0.02 20.90 444.92
10099064 TAFUR LOPEZ EDGAR ANTONIO M.N Impaga 563.00 7.60 0.48 0.03 28.15 599.26
10099077 DAMIAN QUIÑONES HONORATA M.E Pagada 607.00 8.19 0.52 0.03 30.35 646.09
10099080 CENTENO HUAMANI RUBEN M.E Impaga 390.00 5.27 0.33 0.02 19.50 415.12
10099093 BENITES ROMANI OSCAR M.N Pagada 366.00 4.94 0.31 0.02 18.30 389.57
10099106 GOMEZ ACUÑA ELSA CLAUDIA M.E Impaga 398.00 5.37 0.34 0.02 19.90 423.63
10099178 DIAZ ROJAS DE SALAZAR LEYLA M.E Impaga 533.00 7.20 0.45 0.03 26.65 567.33
10099193 JESUS BARZOLA KETTY JANNET M.N Impaga 573.00 7.74 0.49 0.03 28.65 609.90
10099248 HUARHUA HUAMAN SONIA M.N Impaga 538.00 7.26 0.46 0.03 26.90 572.65
10099311 GARAY SANCHEZ TEOFILO M.N Pagada 391.00 5.28 0.33 0.02 19.55 416.18
10099321 LIZARASO CANDIA ALFREDO M.N Impaga 434.00 5.86 0.37 0.02 21.70 461.95
10099393 SOSA LEON DE BRUNO IRMA FLORINDA M.N Impaga 543.00 7.33 0.46 0.03 27.15 577.97
10099413 TINOCO CASTRO FIORELLA DIANA M.N Pagada 562.00 7.59 0.48 0.03 28.10 598.19
10099440 VALDEZ OLIVERA MIGUEL ANGEL M.E Pagada 567.00 7.65 0.48 0.03 28.35 603.51
10099454 ECHEVARRIA ARELLANO ROSA LOLA M.N Pagada 527.00 7.11 0.45 0.03 26.35 560.94
10099547 LOPEZ YARINGAÑO ROCIO JENET M.N Impaga 575.00 7.76 0.49 0.03 28.75 612.03
10099569 ABRAMONTE SALVADOR FRANCISCO M.E Impaga 432.00 5.83 0.37 0.02 21.60 459.82
10099593 CHAVEZ SUNCION RICARDO GERALD M.N Pagada 444.00 5.99 0.38 0.02 22.20 472.59
10099606 ROJAS HILARIO RAUL INOCENTE M.N Impaga 494.00 6.67 0.42 0.02 24.70 525.81
10099613 CHINO ROSELLO DAVID GONZALO M.N Impaga 549.00 7.41 0.47 0.03 27.45 584.36
10099636 AVENIO MELENDREZ YOEL CHAYAN M.N Impaga 577.00 7.79 0.49 0.03 28.85 614.16
10099640 HUILLCA BERNA FELIPA M.E Pagada 416.00 5.62 0.35 0.02 20.80 442.79
10099670 DE LA TORRE REVOLLAR EBER M.E Impaga 486.00 6.56 0.41 0.02 24.30 517.30
10099686 QUILLAHUAMAN HUARHUA LEONIDAS M.E Pagada 588.00 7.94 0.50 0.03 29.40 625.87
10099738 LAZARO ESPINOZA PEDRO ESTEBAN M.E Pagada 555.00 7.49 0.47 0.03 27.75 590.74
10099764 PAUCAR OSCO MARUJA ELENA M.N Pagada 414.00 5.59 0.35 0.02 20.70 440.66
10099814 MOLLAPAZA QUISPE NELIDA M.E Impaga 382.00 5.16 0.32 0.02 19.10 406.60
10099872 YANCE GONZALES VDA DE CAPC YOLANDA NARCI M.N Impaga 524.00 7.07 0.45 0.03 26.20 557.75
10100053 HUARIPATA SOLIER EDWINA GLADYS M.N Pagada 509.00 6.87 0.43 0.03 25.45 541.78
10100139 MARQUEZ PALACIOS LUIS ALBERTO M.N Pagada 427.00 5.76 0.36 0.02 21.35 454.50
10100256 VERGARA PAREDES DIANA MARISOL M.E Impaga 554.00 7.48 0.47 0.03 27.70 589.68
10100262 LEDEZMA VILA LOURDES BACELISA M.E Pagada 428.00 5.78 0.36 0.02 21.40 455.56
10100293 CAQUI RODRIGUEZ MARITZA EDUARDA M.E Pagada 421.00 5.68 0.36 0.02 21.05 448.11
10100407 VERGARA MARQUINA CARMELO M.N Pagada 538.00 7.26 0.46 0.03 26.90 572.65
10100413 PALOMINO SOLANO ANGELA M.E Pagada 495.00 6.68 0.42 0.02 24.75 526.88
10100444 PEREZ CORTEZ BETHY VIOLETA M.E Impaga 537.00 7.25 0.46 0.03 26.85 571.58
10100452 RAMOS ENCARNACION WINSISLAO HUMBERTO M.N Impaga 432.00 5.83 0.37 0.02 21.60 459.82
10100514 BELLOTA ARENAS WILBERT M.N Pagada 502.00 6.78 0.43 0.03 25.10 534.33
10100520 CABREJOS JARA SERGIO M.N Impaga 509.00 6.87 0.43 0.03 25.45 541.78
10100529 MARTINEZ BARRANTES SEBASTIANA M.E Impaga 533.00 7.20 0.45 0.03 26.65 567.33
10100541 LIMA CORDOVA ERMITAÑA M.E Pagada 427.00 5.76 0.36 0.02 21.35 454.50
10100569 QUIROZ NOVOA AZUCENA DEL MILAGRO M.N Pagada 393.00 5.31 0.33 0.02 19.65 418.31
10100610 RAMOS FERNANDEZ FRANCISCA EMMA M.E Pagada 385.00 5.20 0.33 0.02 19.25 409.79
10100663 HILARIO VILLAR EDITH MARLENI M.N Pagada 383.00 5.17 0.33 0.02 19.15 407.67
10100730 SARAZU GAMARRA HONORATO ROLANDO M.N Impaga 382.00 5.16 0.32 0.02 19.10 406.60
10100793 DEL CARMEN DE LA TORRE RICARDO LEONIDAS M.N Pagada 440.00 5.94 0.37 0.02 22.00 468.34
10100844 CORNEJO PEÑA GIOVANNA MARIBEL M.E Pagada 431.00 5.82 0.37 0.02 21.55 458.76
10100887 PERALTA GAPA JULIA M.E Impaga 562.00 7.59 0.48 0.03 28.10 598.19
10100901 CUTIPA HUAHUACHAMBI JULIO ANTONIO M.N Pagada 388.00 5.24 0.33 0.02 19.40 412.99
10100947 SUAREZ BERNARDO PABLO M.E Impaga 427.00 5.76 0.36 0.02 21.35 454.50
10100995 SUASNABAR ASTETE ELISABETH CELINA M.E Pagada 547.00 7.38 0.46 0.03 27.35 582.23
10101056 FELIX FERNANDEZ MANUEL HORLANDO M.N Impaga 407.00 5.49 0.35 0.02 20.35 433.21
10101101 BELLOTA CHAVEZ ANDRES M.N Pagada 413.00 5.58 0.35 0.02 20.65 439.60
10101111 QUISPE ARAPA MARTICIANA M.N Pagada 479.00 6.47 0.41 0.02 23.95 509.85
10101113 VICHAYO RESTOBAR EIRL M.E Pagada 503.00 6.79 0.43 0.03 25.15 535.39
10101147 LOZA DE ORDOÑEZ TANIA GRACIELA M.N Impaga 536.00 7.24 0.46 0.03 26.80 570.52
10101231 SAIRE ESPINOZA WILFREDO LEOPOLDO M.E Impaga 467.00 6.30 0.40 0.02 23.35 497.07
Fecha: 12/15/2023 B9085 Página 8/14
 10101333 MELENDEZ CHOQUECOTA JULIANA M.E Pagada 376.00 5.08 0.32 0.02 18.80 400.21
10101342 MONTERO ORELLANA MARCIAL BASILIO M.E Pagada 513.00 6.93 0.44 0.03 25.65 546.04
10101373 SOTO RICRA MOISES ABEL M.N Pagada 351.00 4.74 0.30 0.02 17.55 373.60
10101411 ALDERETE CHAVEZ GLADYS ELEODORA M.E Impaga 441.00 5.95 0.37 0.02 22.05 469.40
10101486 CRUZ HUAMAN MARIA M.E Pagada 539.00 7.28 0.46 0.03 26.95 573.71
10101507 AÑASCO VDA DE LLAZA ILDEFONSA M.E Pagada 582.00 7.86 0.49 0.03 29.10 619.48
10101555 SEVILLANOS SANDOVAL EDITH NANCY M.N Impaga 447.00 6.03 0.38 0.02 22.35 475.79
10101583 ZUÑIGA ROJAS MARCELO GUMERCINDO M.E Pagada 379.00 5.12 0.32 0.02 18.95 403.41
10101596 QUISPE GAMARRA ELEODORO JULIO M.E Impaga 461.00 6.22 0.39 0.02 23.05 490.69
10101642 CORCINO PROLEON JOSE PABLO M.E Pagada 615.00 8.30 0.52 0.03 30.75 654.61
10101652 TABORI QUINTEROS ALDO FLORENCIO M.N Pagada 537.00 7.25 0.46 0.03 26.85 571.58
10101656 GARCIA HUAMAN MARIA SANTOS M.N Pagada 499.00 6.74 0.42 0.02 24.95 531.14
10101675 VILLALVA ROJAS IVY YELITA M.N Impaga 386.00 5.21 0.33 0.02 19.30 410.86
10101695 MISPIRETA SUAREZ ROLANDO JAVIER M.N Pagada 581.00 7.84 0.49 0.03 29.05 618.42
10101697 HEREDIA FIESTAS JUAN MERCEDES M.N Impaga 366.00 4.94 0.31 0.02 18.30 389.57
10101759 COLCAS TARAZONA CARLOS MIGUEL M.E Pagada 412.00 5.56 0.35 0.02 20.60 438.53
10101786 RAMIREZ PEREZ HUGO OTTO M.N Impaga 497.00 6.71 0.42 0.02 24.85 529.01
10101791 RIVERA DOMINGUEZ HILDA M.N Impaga 602.00 8.13 0.51 0.03 30.10 640.77
10101807 SAAVEDRA CELIS SHEILLA LOURDES M.N Impaga 535.00 7.22 0.45 0.03 26.75 569.45
10101834 TIBURCIO VERGARA LORENZO ARNULFO M.E Pagada 605.00 8.17 0.51 0.03 30.25 643.96
10101908 CASQUINO DE GUILLEN GLADYS MERY M.E Impaga 441.00 5.95 0.37 0.02 22.05 469.40
10101912 BURGA DE SANCHEZ RAQUEL CRISTINA M.N Impaga 558.00 7.53 0.47 0.03 27.90 593.94
10101918 PANTIGOZO GONGORA JIMMY M.N Impaga 404.00 5.45 0.34 0.02 20.20 430.02

Fecha: 12/15/2023 B9085 Página 9/14

 EMPRESA CAFETALERA
FLOR DE CAFÉ
PRODUCCION DE CAFÉ EN TONELADAS AÑO-2017

Crear un gráfico Circular para el 3er Bimestre

Crear un gráfico de Columnas 3D
considere solo los bimestres pares para los departamentos de Amazonas, San Martin, Ucayali, Cusco

DEPARTAMENTO Piura Cajamarca Amazonas San Martín Junín Pasco

Bim 01 1,298 978 1,043 1,336 1,267 1,206
Bim 02 1,274 1,331 1,633 1,439 1,034 1,487
Bim 03 1,009 1,375 1,591 1,356 1,583 1,428
Bim 04 1,420 1,346 1,352 1,202 953 1,491
Bim 05 1,186 1,127 1,498 1,209 1,197 1,208
Bim 06 986 1,292 1,427 1,565 1,637 1,201

TERCER BIMESTRE
1,068 976
6.85% 6.26% 1,009
1,039 6.47% 1,375
6.66% 8.81%
Piura
1,591
10.20% Cajamarca
Amazonas
1,531 San Martín
9.81% Junín
Pasco
Huánuco
1,356 Ucayali
8.69% Apurímac
Ayacucho
Cusco
1,581 Puno
10.13%
1,065 1,583
1,428 10.15%
6.83% 9.15%
 Huánuco Ucayali Apurímac Ayacucho Cusco Puno
1,594 1,484 1,426 1,382 1,289 1,301
1,635 1,201 1,326 1,601 1,573 1,119
1,065 1,581 1,531 1,039 1,068 976
1,027 1,587 1,436 1,290 1,179 1,397
1,436 1,154 1,029 1,250 961 1,257
1,340 1,537 1,057 1,607 1,489 1,549

Bim 02 Bim 04 Bim 06

bim es tr e DEPA R TA MENTO

Piura 1,800
91
20% Cajamarca 1,633
1,565 1,587 1,573
Amazonas 1,600 1,537
1,489
San Martín 1,427 1,439
1,400 1,352
Junín
Pasco 1,202 1,201 1,179
1,200
Huánuco
Ucayali 1,000
Apurímac
Ayacucho 800
Cusco
Puno 600

400

200

-
Amazonas San Martín Ucayali Cusco
INFORMACIÓN DE TRABAJADORES
N° APELLIDOS NOMBRES DISTRITO ESTADO CIVIL HIJOS BÁSICO COMISIÓN
1 LOPEZ ROJAS MARIA SAN MIGUEL S 0 3500 10.00%
2 RAMIREZ CRUZ JUANA SURCO S 2 4300 30.00%
3 SUAREZ ALARCON DAVID MAGDALENA C 2 2500 15.00%
4 IGNACIO PEREZ PABLO JESUS MARIA V 1 2200 12.00%
5 ALBUJAR CRUZ ROSARIO SAN MARTIN C 3 1500 10.00%
6 VILLAVICENCIA SUAREZ LUIS SAN MIGUEL C 2 2500 10.00%
7 VILCA POMA WALTER JESUS MARIA S 1 4400 8.20%
8 TORIBIO RIGUETE YSABELLA CALLAO C 1 5500 6.40%
9 CHAVEZ MUÑOZ JUAN PUEBLO LIBRE C 3 3300 4.60%
10 CHAFLOC CUMPA MANUEL JESUS MARIA C 4 2200 7.00%
11 OLANO NEYRA LEONEL JESUS MARIA C 1 3200 8.00%
12 MALCA TORRES JENIFER SAN MARTIN S 0 1500 10.00%
13 SIRLOPU ÑIQUEN MELONY LINCE S 0 1100 15.00%
14 VALLE PALOMINO JAIRO SURCO C 0 2400 20.00%
15 CHAVESTA ANGELES MARCOS SAN ISIDRO S 1 2000 12.00%
16 VILLARREAL YIN MATEO SURQUILLO C 2 1900 8.00%
17 ROBLES SALAZAR DANIEL SURCO S 1 1400 10.00%
18 ALBITES CUEVA SEBASTIAN MAGDALENA V 2 2100 15.00%
19 HUERTAS CANANI FERNANDA CALLAO S 0 2700 10.00%
20 MIO ARBULU NADYR LINCE C 0 -3400 30.00%
21 CORDOVA LOPEZ NICOLAS PUEBLO LIBRE S 1 4000 25.00%
22 MALDONADO ASENJO PIERO SAN MIGUEL C 3 4600 20.00%
23 FREITAS DIAZ ANGELA SURQUILLO D 0 5300 10.00%
24 ECHENIQUE PEREZ JESUS SAN ISIDRO C 1 5900 5.00%
25 ATAHUA DOMINGUEZ PIERINA SAN MARTIN S 1 2600 7.00%
26 CONDE DE LA CRUZ ANDRES MAGDALENA S 0 2700 10.00%
27 CONDORI RAMOS LUIS JESUS MARIA S 0 1600 17.00%
28 CORONADO CAMPOS ABEL SURCO D 1 4000 19.00%
29 ESPINOZA PAREDES JOSE SURQUILLO C 1 3000 15.00%
30 FLORES CAICEDO FLAVIA LINCE S 0 2000 12.00%
31 GAMARRA GARCIA PAUL SAN MARTIN S 1 2500 15.00%
32 GRANDEZ GRANDEZ DANIELA CALLAO C 2 4000 20.00%
33 GUTIERREZ ANTICONA VALENTIN CALLAO S 2 1800 30.00%
34 HUERTA MOGOLLON RAUL PUEBLO LIBRE C 0 2700 25.00%
35 SEGOVIA DELGADO JOHANA SAN ISIDRO S 0 3000 30.00%
FEC_NAC Consultas
6/16/1984 N° 1
10/17/1960 APELLIDOS LOPEZ ROJAS
4/7/1980 NOMBRES MARIA
1/11/1977 DISTRITO SAN MIGUEL
8/28/1989 ESTADO CIVIL S
3/12/1990 HIJOS 0
2/19/1989 BÁSICO 3500
4/16/1988 COMISIÓN 10.00%
2/14/1991 FEC_NAC 6/16/1984
2/23/1990 Monto Comisión 350
2/24/1988 Asig. Familiar 0
9/15/1990 Neto Recibido 3863
2/7/1991
6/16/1990
2/25/1989
2/22/1990
10/17/1980
12/23/1960
7/1/1967
8/14/1978
3/28/1968
8/25/1955
7/1/1967
8/14/1978
3/28/1968
8/25/1955
7/1/1967
8/14/1978
3/28/1968
8/25/1955
7/1/1967
8/14/1978
3/28/1968
8/25/1955
7/1/1967
Determine una VALIDACION DE DATOS tipo LISTA que muestre el Numero de Empleado
Utilizando las funciones de búsqueda complete el cuadro

Calcule el MONTO DE COMISION tomando como dato el Interes de la comision y el Básico

Asigne el monto de 95 en el caso q tenga hijos de lo contrario 0
Calcule el NETO RECIBIDo