Calcular Salario EXCEL

Embed Size (px)

Citation preview

EMPRESA NACIONAL DE GRANOS BSICOS (ENGB)No. 1 2 3 4 5 6 7 8 9 10 11 12 13 Nombre y Apellido Martha Uribe Lorenzo Guerrero Norma Tellez Ruth Caldern Olga Centeno Lorena Ortz Darling Meza Julio Gonzlez Martn Castillo Karla Rodrguez Luis Silva Rger Lpez Mara Cano Fecha de Inbgreso 3/10/2008 4/5/2005 5/23/2006 7/2/2005 5/23/2006 6/27/2005 8/23/2006 5/13/2007 5/26/2006 3/1/2004 5/25/2003 6/2/2007 6/24/2008 Horas TRB. 36 40 35 40 37 40 35 40 33 40 40 35 40 H. Entra Sal * Hr. Salario Bruto INSS Total 0 $78.85 $2,838.60 $283.86 $2,554.74 15 $50.50 $2,031.36 $203.14 $1,828.23 0 $108.79 $3,807.65 $380.77 $3,426.89 10 $85.79 $3,444.47 $344.45 $3,100.02 0 $78.85 $2,917.45 $291.75 $2,625.71 12 $50.50 $2,029.09 $202.91 $1,826.18 0 $90.05 $3,151.75 $315.18 $2,836.58 10 $85.00 $3,412.75 $341.28 $3,071.48 0 $50.50 $1,666.50 $166.65 $1,499.85 15 $100.00 $4,022.50 $402.25 $3,620.25 12 $100.00 $4,018.00 $401.80 $3,616.20 0 $55.00 $1,925.00 $192.50 $1,732.50 10 $90.05 $3,615.51 $361.55 $3,253.96 Salario Mayor de C$ 3,000.00 $4,022.50 Salario Menor de C$ 3,000.00 $1,666.50 Total a pagar la empresa $40,681.57