Ejercicios Formulas 2

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 3

PLANILLA DEL MES

Codigo Apellido Nombre Año de Ingreso Basico Boni1


1996 Acosta Alberto Acosta Alberto 1996 S/ 750.00 S/ 75.00
1990 Arevalo Carlos Arevalo Carlos 1990 S/ 1,200.00 S/ 120.00
1998 Bendezu Yesica Bendezu Yesica 1998 S/ 820.00 S/ 82.00
1995 Torres Marco Torres Marco 1995 S/ 1,320.00 S/ 132.00
1994 Ruiz Maria Ruiz Maria 1994 S/ 1,500.00 S/ 150.00
1990 Morales Juana Morales Juana 1990 S/ 1,800.00 S/ 180.00
1999 Mendoza Ricardo Mendoza Ricardo 1999 S/ 1,600.00 S/ 160.00
1990 Peña Karla Peña Karla 1990 S/ 1,250.00 S/ 125.00
1988 Lopez Julio Lopez Julio 1988 S/ 800.00 S/ 80.00
1989 Quiroz Sara Quiroz Sara 1989 S/ 920.00 S/ 92.00
1999 Lavarte Ricardo Lavarte Ricardo 1999 S/ 850.00 S/ 85.00
1990 Lopez Guisella Lopez Guisella 1990 S/ 1,000.00 S/ 100.00
1998 Liñan Luis Liñan Luis 1998 S/ 820.00 S/ 82.00
1991 Bernuy Mónica Bernuy Mónica 1991 S/ 1,000.00 S/ 100.00
1997 Brañez Blanca Brañez Blanca 1997 S/ 1,500.00 S/ 150.00
1988 Casiano Victor Casiano Victor 1988 S/ 2,000.00 S/ 200.00
DEL MES
Bonif2 Total Bonf Sueldo Aporte - Pensión Neto a Cobrar
S/ 517.50 S/ 592.50 S/ 1,342.50 S/ 174.53 S/ 1,167.98
S/ 660.00 S/ 780.00 S/ 1,980.00 S/ 257.40 S/ 1,722.60
S/ 481.00 S/ 563.00 S/ 1,383.00 S/ 179.79 S/ 1,203.21
S/ 566.00 S/ 698.00 S/ 2,018.00 S/ 262.34 S/ 1,755.66
S/ 595.00 S/ 745.00 S/ 2,245.00 S/ 291.85 S/ 1,953.15
S/ 690.00 S/ 870.00 S/ 2,670.00 S/ 347.10 S/ 2,322.90
S/ 500.00 S/ 660.00 S/ 2,260.00 S/ 293.80 S/ 1,966.20
S/ 662.50 S/ 787.50 S/ 2,037.50 S/ 264.88 S/ 1,772.63
S/ 680.00 S/ 760.00 S/ 1,560.00 S/ 202.80 S/ 1,357.20
S/ 666.00 S/ 758.00 S/ 1,678.00 S/ 218.14 S/ 1,459.86
S/ 462.50 S/ 547.50 S/ 1,397.50 S/ 181.68 S/ 1,215.83
S/ 650.00 S/ 750.00 S/ 1,750.00 S/ 227.50 S/ 1,522.50
S/ 481.00 S/ 563.00 S/ 1,383.00 S/ 179.79 S/ 1,203.21
S/ 630.00 S/ 730.00 S/ 1,730.00 S/ 224.90 S/ 1,505.10
S/ 535.00 S/ 685.00 S/ 2,185.00 S/ 284.05 S/ 1,900.95
S/ 740.00 S/ 10,489.50 S/ 12,489.50 S/ 1,623.64 S/ 10,865.87
CONTROL DE EXISTENCIAS
PRODUCTO XYZ CODIGO PROD1001
DIMENSIONES STOCK_MIN
UBICACIÓN MES-AÑO

FECHA INGRESO EGRESO SALDO OBSERVACIONES


1/1/2004 100 50
1/2/2004 100 50
1/3/2004
1/4/2004
1/5/2004
1/6/2004
1/7/2004
1/8/2004
1/9/2004
1/10/2004
1/11/2004
1/12/2004
1/13/2004
1/14/2004
1/15/2004
1/16/2004
1/17/2004
1/18/2004
1/19/2004
1/20/2004
1/21/2004
1/22/2004
1/23/2004
1/24/2004
1/25/2004
1/26/2004
1/27/2004
1/28/2004
1/29/2004
1/30/2004
1/31/2004

You might also like