Practica Calificada Brayan Jefferson Quispe Ramos

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 7

INCREMENTO Y REDUCC

Incremento 2% 13%
Reducción 7.50%

Nro. Vendedores Enero Febrero Marzo Abril


1 María Apaza S/ 15,000.00 S/ 13,875.00 S/ 15,300.00 S/ 15,678.75
2 Erika Flores S/ 20,000.00 S/ 18,500.00 S/ 20,400.00 S/ 2,600.00
3 Camila Chambi S/ 25,000.00 S/ 23,125.00 S/ 25,500.00 S/ 3,250.00
4 Roger Arias S/ 35,000.00 S/ 32,375.00 S/ 35,700.00 S/ 4,550.00
5 Yeny Mamani S/ 50,000.00 S/ 46,250.00 S/ 51,000.00 S/ 6,500.00
6 Rafael Flores S/ 10,000.00 S/ 9,250.00 S/ 10,200.00 S/ 1,300.00
7 Jennifer Pereyra S/ 5,000.00 S/ 4,625.00 S/ 5,100.00 S/ 650.00
8 Carlos Paredes S/ 100,000.00 S/ 92,500.00 S/ 102,000.00 S/ 13,000.00
9 Faviola Tévez S/ 40,000.00 S/ 37,000.00 S/ 40,800.00 S/ 5,200.00

Ventas Totales por Mes S/ 300,000.00 S/ 277,500.00 S/ 306,000.00 S/ 52,728.75


Promedio Ventas por Mes S/ 33,333.33 S/ 30,833.33 S/ 34,000.00 S/ 5,858.75
Venta Máxima por Mes S/ 100,000.00 S/ 92,500.00 S/ 102,000.00 S/ 15,678.75
Venta Mínima por Mes S/ 5,000.00 S/ 4,625.00 S/ 5,100.00 S/ 650.00

BRAYAN JEFFERSON QUISPE RAMOS ...


II SEMESTRE... TURNO NOCHE
REMENTO Y REDUCCION DE VENTAS POR MESES

2.50% 5%
5% 10%

Total Promedio
Mayo Junio Julio Agosto
Vendedor vendedor
S/ 14,535.00 S/ 14,221.88 S/ 13,770.00 S/ 16,065.00 S/ 118,445.63 S/ 14,805.70
S/ 19,380.00 S/ 18,962.50 S/ 18,360.00 S/ 21,420.00 S/ 139,622.50 S/ 17,452.81
S/ 24,225.00 S/ 23,703.13 S/ 22,950.00 S/ 26,775.00 S/ 174,528.13 S/ 21,816.02
S/ 33,915.00 S/ 33,184.38 S/ 32,130.00 S/ 37,485.00 S/ 244,339.38 S/ 30,542.42
S/ 48,450.00 S/ 47,406.25 S/ 45,900.00 S/ 53,550.00 S/ 349,056.25 S/ 43,632.03
S/ 9,690.00 S/ 9,481.25 S/ 9,180.00 S/ 10,710.00 S/ 69,811.25 S/ 8,726.41
S/ 4,845.00 S/ 4,740.63 S/ 4,590.00 S/ 5,355.00 S/ 34,905.63 S/ 4,363.20
S/ 96,900.00 S/ 94,812.50 S/ 91,800.00 S/ 107,100.00 S/ 698,112.50 S/ 87,264.06
S/ 38,760.00 S/ 37,925.00 S/ 36,720.00 S/ 42,840.00 S/ 279,245.00 S/ 34,905.63

S/ 290,700.00 S/ 284,437.50 S/ 275,400.00 S/ 321,300.00


S/ 32,300.00 S/ 31,604.17 S/ 30,600.00 S/ 35,700.00 Total del Total de Vendadores
S/ 96,900.00 S/ 94,812.50 S/ 91,800.00 S/ 107,100.00
S/ 4,845.00 S/ 4,740.63 S/ 4,590.00 S/ 5,355.00
Venta Venta
Máxima Mínima
S/ 16,065.00 S/ 13,770.00
S/ 21,420.00 S/ 2,600.00
S/ 26,775.00 S/ 3,250.00
S/ 37,485.00 S/ 4,550.00
S/ 53,550.00 S/ 6,500.00
S/ 10,710.00 S/ 1,300.00
S/ 5,355.00 S/ 650.00
S/ 107,100.00 S/ 13,000.00
S/ 42,840.00 S/ 5,200.00

otal de Vendadores S/ 2,108,066.25


PROYECCION DE SUELDOS

es
o

ro
taj
pt

zo
o

ri l
re
er
e

Ab
nc

ce

Ma
b
En

Fe
Co

r
Po
Sueldo Basico S/ 180,000.00 S/ 198,000.00 S/ 217,800.00
Movilidad 7% S/ 12,600.00 S/ 13,860.00 S/ 15,246.00
Puntualidad 15% S/ 1,890.00 S/ 2,079.00 S/ 2,286.90
Encuesta 5% S/ 94.50 S/ 103.95 S/ 114.35

Sueldo Bruto S/ 194,584.50 S/ 214,042.95 S/ 235,447.25


Descuento 10% S/ 19,458.45 S/ 21,404.30 S/ 23,544.72

Sueldo Neto S/ 175,126.05 S/ 194,584.50 S/ 215,988.80


Empleados 30% S/ 52,537.82 S/ 58,375.35 S/ 64,796.64

Liquidez Total S/ 369,710.55 S/ 408,627.45 S/ 451,436.04

Incremento Mensual 10%


PROYECCION DE SUELDOS

to
zo

nio
o

lio
ril

os
y
r

Ab

Ma

Ju
Ma

Ju

Ag
S/ 239,580.00 S/ 263,538.00 S/ 289,891.80 S/ 318,880.98 S/ 350,769.08
S/ 16,770.60 S/ 18,447.66 S/ 20,292.43 S/ 22,321.67 S/ 24,553.84
S/ 2,515.59
S/ 125.78
S/ 2,767.15
S/ 138.36
S/ 3,043.86
S/ 152.19
S/ 3,348.25
S/ 167.41
S/ 3,683.08
S/ 184.15
P
S/ 258,991.97 S/ 284,891.17 S/ 313,380.28 S/ 344,718.31 S/ 379,190.14 u
S/ 25,899.20 S/ 28,489.12 S/ 31,338.03 S/ 34,471.83 S/ 37,919.01
n
S/ 239,533.52 S/ 265,432.72 S/ 293,921.83 S/ 325,259.86 S/ 359,731.69
S/ 71,860.06 S/ 79,629.81 S/ 88,176.55 S/ 97,577.96 S/ 107,919.51 o
S/ 498,525.49 S/ 550,323.88 S/ 607,302.12 S/ 669,978.17 S/ 738,921.84
Total Agosto S/ 1,652,103.26
RENDIMIENTO ESTUDIANTIL

NOMBRE Y APELLIDO NOTA 01 20% NOTA 01 NOTA 02 15% NOTA 02 NOTA 03

SAUL ESCALANTE 12 2.4 15 2.25 15


OSCAR BERMA 10 2 12 1.8 14
ANA PÉREZ 15 3 14 2.1 12
NANCY PEREZ 5 1 10 1.5 13
ELIANA JOSEC 12 2.4 10 1.5 18
ROSA CARDENAS 11 2.2 12 1.8 20
GONZALO VILLANUEVA 16 3.2 11 1.65 5
PEDRO QUISPE 14 2.8 18 2.7 2
JUAN MARAVI 10 2 20 3 4
FLOR CHURATA 13 2.6 5 0.75 6

TOTAL DE NOTAS 118 23.6 127 19.05 109


PROMEDIO DE NOTAS 11.8 2.36 12.7 1.905 10.9
NOTA MAS ALTA 16 3.2 20 3 20
NOTA MAS BAJA 5 1 5 0.75 2
CUANTOS ALUMNOS SON 10
NTO ESTUDIANTIL

10% NOTA 03 NOTA 04 5% NOTA 04 TOTAL DE % PROMEDIO RESULTADO

1.5 15 0.75 6.9 1.725 8.625


1.4 14 0.7 5.9 1.475 7.375
1.2 18 0.9 7.2 1.8 9
1.3 12 0.6 4.4 1.1 5.5
1.8 11 0.55 6.25 1.5625 7.8125
2 11 0.55 6.55 1.6375 8.1875
0.5 11 0.55 5.9 1.475 7.375
0.2 10 0.5 6.2 1.55 7.75
0.4 10 0.5 5.9 1.475 7.375
0.6 9 0.45 4.4 1.1 5.5

10.9 121 6.05 59.6 14.9


1.09 12.1 0.605 5.96 1.49
2 18 0.9 7.2 1.8
0.2 9 0.45 4.4 1.1

También podría gustarte