Hola

Planeación y Organización
Instituto Tecnológico de Ensenada

García Gastelum Christian Allan

Administración

Indice
Contenido
2
Indice 2
Introducción 2
Nomina Semana 1 3
Tablas Semana 1 3
Grafica Sueldo 4
Grafica Faltas 5
Semana 2 5
Tabla semana 2 5
Grafica faltas 7
Semana 3 7
Tablas Semana 3 7
Graficas Sueldo 8
Semana 4 9
Tabla semana 4 9
Grafica sueldo10
Grafica Sueldo 11
Gastos Totales De la empresa 11

Introducción
En este documento se presentan las nominas de los empleados de una empresa. Los días que asistieron, las faltas ,descuentos y bonificaciones.

Nomina Semana 1
Tablas Semana 1

No. De empleados | Nombre Empleado | Dias trabajados | Salario diario | Salario diario integrado | Sueldo bruto |
| | | | | |
1 |Carlos Aguirre | 7 | $100.91 | $109.99 | $769.94 |
2 | Eustaquio Alares | 7 | $100.91 | $109.99 | $769.94 |
3 | Eutanasia Alvares | 7 | $100.91 | $109.99 | $769.94 |
4 | Paulo Carpio | 5 | $100.91 | $109.99 | $549.96 |
5 | Manchego Chavez | 7 | $100.91 | $109.99 | $769.94 |
6 | Masiosare Cruz | 5 | $100.91 | $109.99 | $549.96 |
7 | Carmelo Cueto | 7 | $100.91 | $109.99 | $769.94 |
8 |Solovino Diaz | 7 | $100.91 | $109.99 | $769.94 |
9 | Albaca Dueñas | 5 | $100.91 | $109.99 | $549.96 |
10 | Dell Espinoza | 7 | $100.91 | $109.99 | $769.94 |
| | | | | |

15.00% | 7.00% | 7.50% | 15.00% | 15.00% | |
ISPf | IMSS | Credito al salario | Bono de despenza | Bono de puntualidad | Sueldo Neto |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 |$53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$82.49 | $38.50 | $41.25 | $82.49 | $82.49 | $846.11 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$82.49 | $38.50 | $41.25 | $82.49 | $82.49 | $846.11 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 |$1,100.19 |
$82.49 | $38.50 | $41.25 | $82.49 | $82.49 | $846.11 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |

No. De empleados | Nombre Empleado | Numero de Faltas | Media de Faltas | Gastos de la empresa |
1 | Carlos Aguirre | 0 | 0.6 | $10,239.62 |
2 | Eustaquio Alares | 0 |   |   |
3 | Eutanasia Alvares | 0 |   |   |
4 | Paulo Carpio | 2 |   Gastos de la empresa|
$10,239.62 |
|   |
5 | Manchego Chavez | 0 |   |   |
6 | Masiosare Cruz | 2 |   |   |
7 | Carmelo Cueto | 0 |   |   |
8 | Solovino Diaz | 0 |   |   |
9 | Albaca Dueñas | 2 |   |   |
10 | Dell Espinoza | 0 |   |   |
| | | Grafica Sueldo | |

Grafica Faltas

Semana 2
Tabla semana 2
| | | | | |
No. De empleados | Nombre Empleado | Dias trabajados | Salariodiario | Salario diario integrado | Sueldo bruto |
1 | Carlos Aguirre | 6 | $100.91 | $109.99 | $659.95 |
2 | Eustaquio Alares | 5 | $100.91 | $109.99 | $549.96 |
3 | Eutanasia Alvares | 7 | $100.91 | $109.99 | $769.94 |
4 | Paulo Carpio | 7 | $100.91 | $109.99 | $769.94 |
5 | Manchego Chavez | 7 | $100.91 | $109.99 | $769.94 |
6 | Masiosare Cruz | 7 | $100.91 | $109.99 | $769.94 |
7 |Carmelo Cueto | 4 | $100.91 | $109.99 | $439.97 |
8 | Solovino Diaz | 5 | $100.91 | $109.99 | $549.96 |
9 | Albaca Dueñas | 5 | $100.91 | $109.99 | $549.96 |
10 | Dell Espinoza | 7 | $100.91 | $109.99 | $769.94 |
| | | | | |
15.00% | 7.00% | 7.50% | 15.00% | 15.00% | |
ISPf | IMSS | Credito al salario | Bono de despenza | Bono de puntualidad | Sueldo Neto |
$98.99 | $46.20 |$49.50 | $98.99 | $98.99 | $973.15 |
$82.49 | $38.50 | $41.25 | $82.49 | $82.49 | $846.11 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$115.49 | $53.90 | $57.75 | $115.49 | $115.49 | $1,100.19 |
$66.00 | $30.80 | $33.00 | $66.00 | $66.00 | $719.06 |...