Planilla Regimen Comun (2) - Hojas de Cálculo de Google
Planilla Regimen Comun (2) - Hojas de Cálculo de Google
Planilla Regimen Comun (2) - Hojas de Cálculo de Google
DIAS TRABA BASICO ASIG FAM DM SUBSIDIO PRESTA ALIM MOVILIDAD HR EXTA 25%
30 S/. 1.500,00 S/. -
28 S/. 1.866,67 S/. - S/. 133,33 S/. 100,00
30 S/. 2.000,00 S/. - S/. 100,00
INGRESOS
E DE LA ASISTENCIA CALCULO INTERNO DEL SISTEMA PAGO DE HORAS EXTRAS
HR EXTA 35%HR EXTA 100%HR EXTA 25% HR EXTA 35%HR EXTA 100%HR EXTA 25% HR EXTA 35%HR EXTA 100%
S/. - S/. - S/. - S/. - S/. - S/. -
S/. - S/. - S/. - S/. - S/. - S/. -
S/. - S/. - S/. - S/. - S/. - S/. -
DESCUENTOS
AFP
TOT INGR BAIM FONDO COMISION SEGURO ONP 5TA CAT RETE.JUDI
S/. 1.500,00 S/. 1.500,00 S/. 150,00 S/. 24,00 S/. 27,60 S/. - S/. - S/. -
S/. 2.100,00 S/. 2.000,00 S/. - S/. - S/. - S/. 260,00 S/. - S/. -
S/. 2.100,00 S/. 2.000,00 S/. - S/. - S/. - S/. 260,00 S/. - S/. -
APORTES
NETO
TOT DCTOS ESSALUD SCTR VLEY SENATI TOT APOR VACACION
S/. 201,60 S/. 1.298,40 S/. 135,00 S/. 37,50 S/. 7,95 S/. - S/. 180,45 S/. 125,00
S/. 260,00 S/. 1.840,00 S/. 180,00 S/. 50,00 S/. 10,60 S/. - S/. 240,60 S/. 166,67
S/. 260,00 S/. 1.840,00 S/. 180,00 S/. 50,00 S/. 10,60 S/. - S/. 240,60 S/. 166,67
BENEFICIOS COSTO
GRATI BON GRAT CTS TOT BENEF COS MO %
S/. 250,00 S/. 22,50 S/. 145,83 S/. 543,33 S/. 2.223,78 48,3%
S/. 333,33 S/. 30,00 S/. 194,44 S/. 724,44 S/. 3.065,04 46,0%
S/. 333,33 S/. 30,00 S/. 194,44 S/. 724,44 S/. 3.065,04 46,0%
CTS
1500
1 NOVIEMBRE 1500
2 DICIEMBRE 1500 1500
3 ENERO 1500
4 FEBRERO 1500
5 MARZO 1500
6 ABRIL 1500
MONTO MONTO
250 145,83
250 145,83
250 145,83
250 145,83
250 145,83 875,00
250 1500 145,83
250 145,83
250 145,83
250 145,83
250 145,83
250 145,83 875,00
250 1500 145,83
3000 1.750,00
CALCULO DE HORAS EXTRAS
emplados
SUELDO O
VIENE DE LA ASISTENCIA CALCULO INTERNO DEL SISTEMA
SALARIO
HR EXTA 25% HR EXTA 35% HR EXTA 100% HR EXTA 25% HR EXTA 35% HR EXTA 100%
1.025,00 5 - - 42,71
obreros
SUELDO O VIENE DE LA ASISTENCIA CALCULO INTERNO DEL SISTEMA
SALARIO HR EXTA 25% HR EXTA 35% HR EXTA 100% HR EXTA 25% HR EXTA 35% HR EXTA 100%
34,17 4 - - 34,17
domingo
8:00 17:00 9:00
42,71
TOTAL HRS
EXTRA
34,17
1:00 12:00
6:00 16:00
4:00 15:00
50
HORARIO INGRESO SALIDA HRS TRABAJ
lunes 8:30 18:00 9:30 50
martes 8:30 18:00 9:30 50
miercoles 8:30 18:00 9:30 50
jueves 8:30 18:00 9:30 50
viernes 8:30 18:30 10:00 50
sabado 50
domingo 50
lunes 8:30 18:00 9:30 50
martes 8:30 18:00 9:30 50
miercoles 8:30 18:00 9:30 50
jueves 8:30 18:00 9:30 50
viernes 8:30 18:30 10:00 50
sabado 50
domingo 50
lunes 8:30 18:00 9:30 50
martes 8:30 18:00 9:30 50
miercoles 8:30 18:00 9:30 50
jueves 8:30 18:00 9:30 50
viernes 8:30 18:30 10:00 50
sabado 50
domingo 50
lunes 8:30 18:00 9:30 50
martes 8:30 18:00 9:30 50
miercoles 8:30 18:00 9:30 50
jueves 8:30 18:00 9:30 50
viernes 8:30 18:30 10:00 50
sabado 50
domingo 50
lunes 8:30 17:00 8:30 50
martes 8:30 17:00 8:30 50
1500
2475
S/. 24.750,00
S/. 74.250,00
S/ 36.100,00
IMPU ANUAL IMP MES
S/. -420,00 S/. -35,00
RENTA NETA IMPU ANNUAL IMP PAGADO SALDO IMPU IMP MES
S/. 350,00 S/. 28,00 S/. - S/. 28,00 S/. 2,33 12
S/. 350,00 S/. 28,00 S/. 2,33 S/. 25,67 S/. 2,33 12
S/. 350,00 S/. 28,00 S/. 4,67 S/. 23,33 S/. 2,33 12
S/. 350,00 S/. 28,00 S/. 7,00 S/. 21,00 S/. 2,33 9
S/. 350,00 S/. 28,00 S/. 9,33 S/. 18,67 S/. 2,33 8
S/. 350,00 S/. 28,00 S/. 11,67 S/. 16,33 S/. 2,33 8
S/. 350,00 S/. 28,00 S/. 14,00 S/. 14,00 S/. 2,33 8
S/. 350,00 S/. 28,00 S/. 16,33 S/. 11,67 S/. 2,33 5
S/. 350,00 S/. 28,00 S/. 18,67 S/. 9,33 S/. 2,33 4
S/. 350,00 S/. 28,00 S/. 21,00 S/. 7,00 S/. 2,33 4
S/. 350,00 S/. 28,00 S/. 23,33 S/. 4,67 S/. 2,33 4
S/. 350,00 S/. 28,00 S/. 25,67 S/. 2,33 S/. 2,33 1
RENTA NETA IMPU ANNUAL IMP PAGADO SALDO IMPU IMP MES
S/. 63.350,00 S/. 7.384,00 S/. - S/. 7.384,00 S/. 615,33 12
S/. 63.350,00 S/. 7.384,00 S/. 615,33 S/. 6.768,67 S/. 615,33 12
S/. 63.350,00 S/. 7.384,00 S/. 1.230,67 S/. 6.153,33 S/. 615,33 12
S/. 63.350,00 S/. 7.384,00 S/. 1.846,00 S/. 5.538,00 S/. 615,33 9
S/. 63.350,00 S/. 7.384,00 S/. 2.461,33 S/. 4.922,67 S/. 615,33 8
S/. 63.350,00 S/. 7.384,00 S/. 3.076,67 S/. 4.307,33 S/. 615,33 8
S/. 63.980,00 S/. 7.560,40 S/. 3.692,00 S/. 3.868,40 S/. 615,33 8
S/. 63.980,00 S/. 7.560,40 S/. 4.307,33 S/. 3.253,07 S/. 650,61 5
S/. 63.980,00 S/. 7.560,40 S/. 4.957,95 S/. 2.602,45 S/. 650,61 4
S/. 63.980,00 S/. 7.560,40 S/. 5.608,56 S/. 1.951,84 S/. 650,61 4
S/. 63.980,00 S/. 7.560,40 S/. 6.259,17 S/. 1.301,23 S/. 650,61 4
S/. 64.610,00 S/. 7.560,40 S/. 6.909,79 S/. 650,61 S/. 650,61 1
RENTA NETA IMPU ANNUAL IMP PAGADO SALDO IMPU IMP MES
S/. 105.350,00 S/. 17.769,50 S/. - S/. 17.769,50 S/. 1.480,79 12
S/. 105.350,00 S/. 17.769,50 S/. 1.480,79 S/. 16.288,71 S/. 1.480,79 12
S/. 110.350,00 S/. 17.769,50 S/. 2.961,58 S/. 14.807,92 S/. 1.480,79 12
S/. 110.350,00 S/. 17.769,50 S/. 4.442,38 S/. 13.327,13 S/. 1.480,79 9
S/. 110.350,00 S/. 17.769,50 S/. 5.923,17 S/. 11.846,33 S/. 1.480,79 8
S/. 110.350,00 S/. 17.769,50 S/. 7.403,96 S/. 10.365,54 S/. 1.480,79 8
S/. 110.350,00 S/. 17.769,50 S/. 8.884,75 S/. 8.884,75 S/. 1.480,79 8
S/. 110.350,00 S/. 17.769,50 S/. 10.365,54 S/. 7.403,96 S/. 1.480,79 5
S/. 110.350,00 S/. 17.769,50 S/. 11.846,33 S/. 5.923,17 S/. 1.480,79 4
S/. 110.350,00 S/. 17.769,50 S/. 13.327,13 S/. 4.442,38 S/. 1.480,79 4
S/. 110.350,00 S/. 17.769,50 S/. 14.807,92 S/. 2.961,58 S/. 1.480,79 4
S/. 110.350,00 S/. 17.769,50 S/. 16.288,71 S/. 1.480,79 S/. 1.480,79 1