Scribd
Upload
14 views2 pages

Laboratorio #2 Excel

The document provides a payroll summary for JLMT Company, detailing monthly salaries, deductions, and net salaries for various employees. The total monthly salary amounts to 56,748.00, with total deductions of 2,539.75, resulting in a total net salary of 45,887.02. It also includes the maximum and minimum salaries, as well as the average salary for the employees listed.

Uploaded by

Jorge Martínez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views2 pages

Laboratorio #2 Excel

The document provides a payroll summary for JLMT Company, detailing monthly salaries, deductions, and net salaries for various employees. The total monthly salary amounts to 56,748.00, with total deductions of 2,539.75, resulting in a total net salary of 45,887.02. It also includes the maximum and minimum salaries, as well as the average salary for the employees listed.

Uploaded by

Jorge Martínez
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

JLMT COMPANY

Codigo Nombre Sueldo Mensual IHSS cooperativa


IA033-5 Axel Perez 15,850.00 554.75 300.00
IA033-8 Betina Castro 4,999.00 174.97 300.00
IA033-1 Carlos Prada 5,500.00 192.50 300.00
IA033-3 Elena Maldonado 1,000.00 35.00 300.00
IA033-6 Katherine Mojica 7,000.00 245.00 300.00
IA033-7 Miriam Varela 8,700.00 304.50 300.00
IA033-2 Pedro Martinez 10,699.00 374.47 300.00
IA033-4 Yency Baca 3,000.00 105.00 300.00
Totales 56,748.00 1,986.18 2,400.00
Valor Maximo 15,850.00 554.75 300.00
Valor Minimo 1,000.00 35.00 300.00
Promedio 7,093.50 248.27 300.00
JLMT COMPANY
bancotrab otras deducciones Total deducciones Sueldo Neto Nuevo Sueldo
1,585.00 100.00 2,539.75 13,310.25 17,435.00
499.90 100.00 1,074.87 3,924.14 5,248.95
550.00 100.00 1,142.50 4,357.50 5,775.00
100.00 100.00 535.00 465.00 1,050.00
700.00 100.00 1,345.00 5,655.00 7,350.00
870.00 100.00 1,574.50 7,125.50 9,135.00
1,069.90 100.00 1,844.37 8,854.64 11,768.90
300.00 100.00 805.00 2,195.00 3,150.00
5,674.80 100.00 10,860.98 45,887.02 60,912.85
1,585.00 100.00 2,539.75 13,310.25 17,435.00
100.00 100.00 535.00 465.00 1,050.00
709.35 100.00 1,357.62 5,735.88 7,614.11

You might also like