traba 011traba 011.xlsx

4
NOMBRE S. BASE VENTAS ALCALDE GOMEZ miguel ### S/. 236.50 CARRILLO FRY Alexandra ### S/. 1,025.00 CORRALES CARRASCO Ana ### S/. 850.50 ESPINO SIVINCHA Silvia ### S/. 180.50 GOMEZ LEIVA Nicol ### S/. 1,350.00 HUAMAN LUYO Paul ### S/. 625.50 MALTA TAMPERO Jesus ### S/. 506.00 MUÑOZ GONZALES Vanesa ### S/. 150.00 VASQUEZ SUI Paola ### S/. 1,050.00 VERA LINARES Rodrigo ### S/. 301.00 YAURI ARCE Alonso ### S/. 350.00 TOTALES ### S/. 6,625.00 MINIMO ### S/. 150.00 MAXIMO ### S/. 1,350.00 PROMEDIO ### S/. 602.27 NRO EMPLEADOS CARGO 1 aaa Administrador 2 bbbb Gestor 3 cccc Sectorista 4 dddd Recepcionista 5 eeee Sectorista 6 ffff Abogado 7 gggg Abogado 8 hhh Abogado 9 iiii Abogado 10 jjjj Contador 11 kkkk Gestor EDAD MAXIMA 45 EDAD MINIMA 20 SUELDO MAXIMO ### SUELDO MINIMO ### ORDEN CLIENTE TARJETA C001 aaaa S C002 bbbb N C003 cccc S C004 dddd S C005 eeee N C006 ffff N

Upload: yofrey-pinto

Post on 16-Feb-2016

220 views

Category:

Documents


0 download

DESCRIPTION

TRABA 011.xlsx

TRANSCRIPT

Page 1: TRABA 011TRABA 011.xlsx

SUELDOS Y SALARIOSNOMBRE S. BASE VENTAS COMISIONALCALDE GOMEZ miguel S/. 215.00 S/. 236.50 S/. 23.65 CARRILLO FRY Alexandra S/. 150.00 S/. 1,025.00 S/. 102.50 CORRALES CARRASCO Ana S/. 135.00 S/. 850.50 S/. 85.05 ESPINO SIVINCHA Silvia S/. 211.00 S/. 180.50 S/. 18.05 GOMEZ LEIVA Nicol S/. 145.00 S/. 1,350.00 S/. 135.00 HUAMAN LUYO Paul S/. 200.00 S/. 625.50 S/. 62.55 MALTA TAMPERO Jesus S/. 125.00 S/. 506.00 S/. 50.60 MUÑOZ GONZALES Vanesa S/. 250.00 S/. 150.00 S/. 15.00 VASQUEZ SUI Paola S/. 125.00 S/. 1,050.00 S/. 105.00 VERA LINARES Rodrigo S/. 185.00 S/. 301.00 S/. 30.10 YAURI ARCE Alonso S/. 120.00 S/. 350.00 S/. 35.00

TOTALES S/. 1,861.00 S/. 6,625.00 S/. 662.50 MINIMO S/. 120.00 S/. 150.00 S/. 15.00 MAXIMO S/. 250.00 S/. 1,350.00 S/. 135.00 PROMEDIO S/. 169.00 S/. 602.27 S/. 60.23

NRO EMPLEADOS CARGO EDAD1 aaa Administrador 352 bbbb Gestor 203 cccc Sectorista 254 dddd Recepcionista 205 eeee Sectorista 266 ffff Abogado 367 gggg Abogado 428 hhh Abogado 409 iiii Abogado 45

10 jjjj Contador 3711 kkkk Gestor 24

EDAD MAXIMA 45 MASCULINOSEDAD MINIMA 20 FEMENINOS

SUELDO MAXIMO S/. 1,600.00 GESTORSUELDO MINIMO S/. 500.00 SECTORISTAS

ORDEN CLIENTE TARJETA MONTOC001 aaaa S S/. 1,200.00 C002 bbbb N S/. 3,500.00 C003 cccc S S/. 2,500.00 C004 dddd S S/. 7,400.00 C005 eeee N S/. 1,200.00 C006 ffff N S/. 500.00

Page 2: TRABA 011TRABA 011.xlsx

C007 gggg S S/. 650.00 C008 hhhh S S/. 2,300.00 C009 iiii N S/. 800.00 C010 jjjj S S/. 900.00 C011 kkkk S S/. 705.00

TOTAL CLIENTES 11 TOT. MONTOCON TARJETA 4 MAXIMOSIN TARJETA 7 MINIMO

B61
Flavisur:
Page 3: TRABA 011TRABA 011.xlsx

SUELDOS Y SALARIOSSALARIO S/. 238.65 S/. 252.50 S/. 220.05 S/. 229.05 S/. 280.00 S/. 262.55 S/. 175.60 S/. 265.00 S/. 230.00 S/. 215.10 S/. 155.00

S/. 2,523.50 S/. 155.00 S/. 280.00 S/. 229.41

SEXO S. BASICOM S/. 1,500.00 F S/. 500.00 M S/. 800.00 F S/. 500.00 M S/. 900.00 M S/. 1,200.00 F S/. 1,200.00 M S/. 1,350.00 M S/. 1,600.00 F S/. 1,000.00 M S/. 500.00

74

22

Page 4: TRABA 011TRABA 011.xlsx

S/. 21,655.00 S/. 7,400.00 S/. 500.00