Excel Caro 1
Excel Caro 1
Excel Caro 1
No mover la ubicación de
esta columna
RAZÓN SOCIAL AÑO MODELO PLACA MOTOR
Miguel Villanueva 87 Camión AH2345 44587-23
Juan Cuadros 89 Auto BH3467 SDFF-RRWE123
Raúl Tapia 92 Trailer AD4512 SDF23412
Daniel Esquiagola 92 Camión JU4589 341R-4532
Alex Carbajal 65 Camión JF5698 WE23-2234
Billy Klauer 80 Camión GF3454 WE23-2245
Mauricio Sánchez 82 Auto SD3456 PO-53532234
Francisco Quezada 94 Camioneta UQ3454 PHL-435L245
Miguel Vásquez 95 Auto CV4332 MNF-TOYOTA
Es el factor(cuadro inferior)
AREQUIPA - PERU por el basico. FECHA 12/18/2004
El factor depende del tipo. Por
ejemplo para tipo B2 será 2.30
PLACA AH2345
MODELO Camión MULTA A PAGAR BASICO
TIPO A1 S/. 220
TIPO 1 2 3
A 1.10 1.30 2.00
B 2.10 2.30 2.50
C 3.00 3.40 3.60
NOTA: La MULTA A PAGAR es el resultado del básico por la intersección del tipo de la tabla
Página 1
Infracciones
TIPO
A1
C3
B2
B2
C3
C1
A3
C2
A2
S/. 200
e la tabla
Página 2
Enunciados para resolver la hoja PLANILLA-CUADRO
Parte I
La practica consta de un Modelo de Planilla de Sueldos de una empresa
los datos a calcularse son:
Para Ingresos
Realizar Codigo
-Cada trabajador recibirá los siguientes pagos por hora extra trabajada:
A
B
Para Descuentos
Categoria soles
A 40
B 35
Sueldo
S/ 1,000.00
S/ 900.00
S/ 27.50
S/ 24.60
Planilla de Sueldos
Total
Ingresos D
Sueldo Sueldo Sueldo Asignacion TOTAL Desc
Categoria Basico H.Extra Bonificacion por area INGRESOS Seccion
A 1000.00 0.00 50.00 30.00 1080.00 60.00
B 900.00 49.20 45.00 36.00 1030.20 54.00
B 900.00 24.60 40.50 27.00 992.10 49.50
A 1000.00 82.50 45.00 30.00 1157.50 55.00
A 1000.00 0.00 38.00 40.00 1078.00 45.00
B 900.00 49.20 34.20 27.00 1010.40 40.50
B 900.00 73.80 34.20 27.00 1035.00 40.50
A 1000.00 27.50 50.00 30.00 1107.50 60.00
A 1000.00 0.00 45.00 30.00 1075.00 55.00
B 900.00 49.20 34.20 27.00 1010.40 40.50
B 900.00 24.60 34.20 27.00 985.80 40.50
A 1000.00 55.00 38.00 40.00 1133.00 45.00
A 1000.00 82.50 38.00 30.00 1150.50 45.00
B 900.00 49.20 34.20 27.00 1010.40 40.50
B 900.00 0.00 34.20 36.00 970.20 40.50
A 1000.00 55.00 38.00 30.00 1123.00 45.00
A 1000.00 27.50 38.00 30.00 1095.50 45.00
B 900.00 73.80 34.20 27.00 1035.00 40.50
B 900.00 0.00 34.20 27.00 961.20 40.50
A 1000.00 55.00 38.00 30.00 1123.00 45.00
A 1000.00 82.50 38.00 30.00 1150.50 45.00
B 900.00 24.60 40.50 36.00 1001.10 49.50
B 900.00 0.00 34.20 36.00 970.20 40.50
A 1000.00 55.00 38.00 30.00 1123.00 45.00
A 1000.00 27.50 38.00 30.00 1095.50 45.00
B 900.00 49.20 34.20 36.00 1019.40 40.50
B 900.00 73.80 34.20 27.00 1035.00 40.50
A 1000.00 55.00 38.00 30.00 1123.00 45.00
A 1000.00 0.00 38.00 30.00 1068.00 45.00
B 900.00 49.20 45.00 27.00 1021.20 54.00
B 900.00 73.80 45.00 27.00 1045.80 54.00
A 1000.00 27.50 50.00 30.00 1107.50 60.00
A 1000.00 0.00 50.00 40.00 1090.00 60.00
B 900.00 49.20 45.00 27.00 1021.20 54.00
B 900.00 24.60 45.00 27.00 996.60 54.00
A 1000.00 55.00 50.00 40.00 1145.00 60.00
A 1000.00 82.50 50.00 30.00 1162.50 60.00
B 900.00 49.20 45.00 27.00 1021.20 54.00
B 900.00 0.00 45.00 27.00 972.00 54.00
A 1000.00 55.00 38.00 30.00 1123.00 45.00
B 900.00 24.60 36.00 960.60
B 900.00 49.20 27.00 976.20
A 1000.00 82.50 30.00 1112.50
A 1000.00 55.00 30.00 1085.00
B 900.00 0.00 27.00 927.00
B 900.00 49.20 27.00 976.20
A 1000.00 82.50 30.00 1112.50
Descuentos
Descuento Administradora TOTAL NETO A
Hora de Pensión AFP S.N.P. DESCUENTO PAGAR
80.00 Integra 70.00 120.00 330.00 750.00
105.00 Profuturo 63.00 108.00 330.00 700.20
140.00 SNP 63.00 108.00 360.50 631.60
200.00 Integra 70.00 120.00 445.00 712.50
40.00 Profuturo 70.00 120.00 275.00 803.00
70.00 SNP 63.00 108.00 281.50 728.90
105.00 Integra 63.00 108.00 316.50 718.50
200.00 Profuturo 70.00 120.00 450.00 657.50
240.00 SNP 70.00 120.00 485.00 590.00
245.00 Integra 63.00 108.00 456.50 553.90
105.00 Profuturo 63.00 108.00 316.50 669.30
120.00 SNP 70.00 120.00 355.00 778.00
120.00 Integra 70.00 120.00 355.00 795.50
105.00 Profuturo 63.00 108.00 316.50 693.90
105.00 SNP 63.00 108.00 316.50 653.70
80.00 Integra 70.00 120.00 315.00 808.00
80.00 Profuturo 70.00 120.00 315.00 780.50
70.00 SNP 63.00 108.00 281.50 753.50
70.00 Integra 63.00 108.00 281.50 679.70
80.00 Profuturo 70.00 120.00 315.00 808.00
80.00 SNP 70.00 120.00 315.00 835.50
70.00 Integra 63.00 108.00 290.50 710.60
35.00 Profuturo 63.00 108.00 246.50 723.70
40.00 SNP 70.00 120.00 275.00 848.00
40.00 Profuturo 70.00 120.00 275.00 820.50
35.00 SNP 63.00 108.00 246.50 772.90
105.00 Integra 63.00 108.00 316.50 718.50
120.00 Profuturo 70.00 120.00 355.00 768.00
120.00 SNP 70.00 120.00 355.00 713.00
105.00 Integra 63.00 108.00 330.00 691.20
105.00 Profuturo 63.00 108.00 330.00 715.80
80.00 SNP 70.00 120.00 330.00 777.50
80.00 Integra 70.00 120.00 330.00 760.00
70.00 Profuturo 63.00 108.00 295.00 726.20
70.00 SNP 63.00 108.00 295.00 701.60
80.00 Integra 70.00 120.00 330.00 815.00
80.00 Profuturo 70.00 120.00 330.00 832.50
70.00 SNP 63.00 108.00 295.00 726.20
35.00 Integra 63.00 108.00 260.00 712.00
40.00 Profuturo 70.00 120.00 275.00 848.00
105.00 63.00 108.00 276.00 684.60
105.00 63.00 108.00 276.00 700.20
120.00 70.00 120.00 310.00 802.50
120.00 70.00 120.00 310.00 775.00
70.00 63.00 108.00 241.00 686.00
70.00 63.00 108.00 241.00 735.20
80.00 70.00 120.00 270.00 842.50