Zoho Sheet - Nomina (informatica II)

MUEBLES RÚSTICOS ACME, S.A. DE C.V.


		Pago por hora	$20.00
											PERCEPCIONES							Deducciones
			HrsTrabajadas											Num. Horas Extras
Num	Clave	Nombre	L	M	Mi	J	V	retardos	TOTALHT	TOTAL $SEMANAL	PREMIO PUTUALIDAD 2.5%	Bono despensa 2.7%	Incentivo a la Productividad 1.62% a los que trabajaron mas de 35 hrs	dobles	Triples	Pago hrs. Extras	Total Precepciones	Sindicato 1.5%	Fondo Jubilación 4.5%	Retardos 1.6%	Total deducciones	Sueldo Neto
1	200518936	AVILA LUNA ITANDEHUI	8	8	8	8	8	si	40	$800.00	$0.00	$21.60	$12.96	2		$40.00	$874.56	$13.12	$39.36	$13.99	$66.47	$808.09
2	200529202	CASTAÑEDA MELO GUADALUPE	8	7	8	8	8	no	39	$780.00	$19.50	$21.06	$12.48	1		$20.00	$853.04	$12.80	$38.39	$13.65	$64.83	$788.21
3	200513529	CID ROJAS FRANCISCO	8	8	5	8	5	si	34	$680.00	$0.00	$18.36	$0.00	2		$40.00	$738.36	$11.08	$33.23	$11.81	$56.12	$682.24
4	200505959	CRUZ SANTIAGO JORGE LUIS	8	4	4	7	4	no	27	$540.00	$13.50	$14.58	$0.00	1		$20.00	$588.08	$8.82	$26.46	$9.41	$44.69	$543.39
5	200507329	DOMINGUEZ HERNANDEZ ZAHEL JUAN	7	6	4	4	4	no	25	$500.00	$12.50	$13.50	$0.00	2		$40.00	$566.00	$8.49	$25.47	$9.06	$43.02	$522.98
6	200505147	GARCÍA MORALES GIOVANNY MANUEL	6	8	6	4	6	si	30	$600.00	$0.00	$16.20	$0.00	1		$20.00	$636.20	$9.54	$28.63	$10.18	$48.35	$587.85
7	200513752	GONZALEZ ESPINDOLA GERARDO	7	6	7	4	7	no	31	$620.00	$15.50	$16.74	$0.00	2		$40.00	$692.24	$10.38	$31.15	$11.08	$52.61	$639.63
8	200402887	HERNÁNDEZ EDUARDO KARLA IVETT	4	4	8	5	8	no	29	$580.00	$14.50	$15.66	$0.00	1		$20.00	$630.16	$9.45	$28.36	$10.08	$47.89	$582.27
9	200500599	JIMÈNEZ ROMERO CRISTAL DANIELA	4	8	8	6	8	si	34	$680.00	$0.00	$18.36	$0.00	4		$80.00	$778.36	$11.68	$35.03	$12.45	$59.16	$719.20
10	200513894	LOAIZA TOSCUENTO RICARDO	8	7	4	8	4	no	31	$620.00	$15.50	$16.74	$0.00	2		$40.00	$692.24	$10.38	$31.15	$11.08	$52.61	$639.63
11	200510192	MARTÍNEZ ILAGORRE MIGUEL ALEJANDRO	8	5	4	8	4	no	29	$580.00	$14.50	$15.66	$0.00	3		$60.00	$670.16	$10.05	$30.16	$10.72	$50.93	$619.23
12	200530743	MEDINA PEREZ YAIR	8	8	8	8	8	si	40	$800.00	$0.00	$21.60	$12.96	1		$20.00	$854.56	$12.82	$38.46	$13.67	$64.95	$789.61
13	200506518	MEJIA LOPEZ ALETHIA	8	7	8	8	8	no	39	$780.00	$19.50	$21.06	$12.48	0		$-	$833.04	$12.50	$37.49	$13.33	$63.31	$769.73
14	200509903	MENDOZA MENDOZA MARIANA	8	8	5	8	5	no	34	$680.00	$17.00	$18.36	$0.00	0		$-	$715.36	$10.73	$32.19	$11.45	$54.37	$660.99
15	200509330	MONTEJO VAZQUEZ JESÚS ALBERTO	8	4	4	7	4	si	27	$540.00	$0.00	$14.58	$0.00	2		$40.00	$594.58	$8.92	$26.76	$9.51	$45.19	$549.39
16	200504963	MORALES LOPEZ ANDREA GUADALUPE	7	6	4	4	4	no	25	$500.00	$12.50	$13.50	$0.00	1		$20.00	$546.00	$8.19	$24.57	$8.74	$41.50	$504.50
17	200523418	MORALES ORTEGA ALBERTO	6	8	6	4	6	no	30	$600.00	$15.00	$16.20	$0.00	2		$40.00	$671.20	$10.07	$30.20	$10.74	$51.01	$620.19
18	200508795	NAPOLEÓN AGUILAR SERAFÍN	7	6	7	4	7	si	31	$620.00	$0.00	$16.74	$0.00	1		$20.00	$656.74	$9.85	$29.55	$10.51	$49.91	$606.83
19	200512208	ORTIZ MEDEL JOSE LUIS	4	4	8	5	8	no	29	$580.00	$14.50	$15.66	$0.00	2		$40.00	$650.16	$9.75	$29.26	$10.40	$49.41	$600.75
20	200523912	PEREZ AVILA ANA KAREN	4	8	8	6	8	no	34	$680.00	$17.00	$18.36	$0.00	3		$60.00	$775.36	$11.63	$34.89	$12.41	$58.93	$716.43
21	200528070	PERÉZ ROJAS DIANA MITZI	8	7	4	8	4	si	31	$620.00	$0.00	$16.74	$0.00	1		$20.00	$656.74	$9.85	$29.55	$10.51	$49.91	$606.83
22	200500999	RAMOS MÉNDEZ ANA LAURA	8	5	4	8	4	no	29	$580.00	$14.50	$15.66	$0.00	0		$-	$610.16	$9.15	$27.46	$9.76	$46.37	$563.79
23	200510891	RIVERA GÒMEZ OSVALDO	8	5	4	8	4	no	29	$580.00	$14.50	$15.66	$0.00	0		$-	$610.16	$9.15	$27.46	$9.76	$46.37	$563.79
24	200503387	ROMERO PEREZ FABIOLA	8	8	8	8	8	si	40	$800.00	$0.00	$21.60	$12.80	2		$40.00	$874.40	$13.12	$39.35	$13.99	$66.45	$807.95
25	200408209	RUIZ CERVANTES ADRIANA YARAMI	8	7	8	8	8	no	39	$780.00	$19.50	$21.06	$12.48	1		$20.00	$853.04	$12.80	$38.39	$13.65	$64.83	$788.21
26	200528582	SALAS CARBENTE MONICA	8	8	5	8	5	no	34	$680.00	$17.00	$18.36	$0.00	2		$40.00	$755.36	$11.33	$33.99	$12.09	$57.41	$697.95
27	200507198	SANTOS AGUILAR ABRIL	8	4	4	7	4	si	27	$540.00	$0.00	$14.58	$0.00	1		$20.00	$574.58	$8.62	$25.86	$9.19	$43.67	$530.91
28	200510058	SOLANO MERCADO IXHEL	7	6	4	4	4	no	25	$500.00	$12.50	$13.50	$0.00	1		$20.00	$546.00	$8.19	$24.57	$8.74	$41.50	$504.50
29	200504000	SOLIS HERNANDEZ ALEJANDRA	6	8	6	4	6	no	30	$600.00	$15.00	$16.20	$0.00	2		$40.00	$671.20	$10.07	$30.20	$10.74	$51.01	$620.19
30	200530880	SORIANO CRUZ ISABEL	7	6	7	4	7	si	31	$620.00	$0.00	$16.74	$0.00	1		$20.00	$656.74	$9.85	$29.55	$10.51	$49.91	$606.83

Nomina (informatica II)

Salarios

Hoja2

Hoja3