Excel

Papeleria


Control de inventario
Mes: Enero

Codigo ArticuloExistencia inicial Entradas Salidas Existencia final Inventario fisico diferencias Stock max Stock min Estatus Cant. Req. p/Max Cant. Req. p/Min
001 LapizHB 100 200 150 150 150 0 300 150 --- 0
002 Lapiz B 150 150 165 135 134 -1 300 150 Req 166 16
003 Lapiz 2H 120 180 85 215 215 0 300 150 --- ------
004 Lapiz HB 130 170 100 200 195 -5 300 150 --- --- ---
005 Pluma Med 150 50 90 110 110 0 200 100 --- --- ---
006 Pluma Fino 125 75 96 104104 0 200 100 --- --- ---
007 Plumon med 130 70 60 140 142 2 200 100 --- --- ---
008 Plumon fino 160 40 30 170 170 0 200 100 --- --- ---
009Borrador dibujo 75 25 80 20 20 0 100 50 Req 80 30
010 Borrador lapiz 60 40 20 80 80 0 100 50 --- --- ---
011 Cuaderno Ita/ray 50 50 34 66 65 -1 10050 --- --- ---
012 Cuaderno ita/dib 60 40 33 67 67 0 100 50 --- --- ---
013 Cuaderno fren/ray 55 45 32 68 68 0 100 50 --- --- ---
014 Cuadernofran/dib 64 36 50 50 50 0 100 50 --- --- ---
015 Libreta prof/ray 62 38 60 40 39 -1 100 50 Req 61 11
016 libreta prof/dib 45 55 45 55 52 -3 100 50--- --- ---
017 Paq. Cd. Sony 25 30 70 68 32 32 0 100 50 Req 68 18
018 Paq. Cd. Sony 100 33 67 88 12 12 0 100 50 Req 88 38
019 Paq. Cd. Verbatin25 15 35 40 10 10 0 100 50 Req 90 40
020 Paq. Cd Verbatin 100 20 20 15 25 24 -1 100 50 Req 76 26
total de productos requeridos: 808