Embed Size (px)
DESCRIPTION
analisis de inventarios abc
Citation preview
Inventario de análisis ABC
1 15000 $5.00 $75,000.002 6450 $20.00 $129,000.003 5000 $45.00 $225,000.004 200 $12.50 $2,500.005 20000 $35.00 $700,000.006 84 $250.00 $21,000.007 800 $80.00 $64,000.008 300 $5.00 $1,500.009 10000 $35.00 $350,000.0010 2000 $65.00 $130,000.0011 5000 $25.00 $125,000.0012 3250 $125.00 $406,250.0013 9000 $0.50 $4,500.0014 2900 $10.00 $29,000.0015 800 $15.00 $12,000.0016 675 $200.00 $135,000.0017 1470 $100.00 $147,000.0018 8200 $15.00 $123,000.0019 1250 $0.16 $200.0020 2500 $0.20 $500.00
Número de artículo
Utilización anual
proyectadaCosto
Unitario
Utilización anual
proyectada en dinero
A 5 20000 $35.00 $700,000.00 $700,000.00 26.12%A 12 3250 $125.00 $406,250.00 $1,106,250.00 15.16%A 9 10000 $35.00 $350,000.00 $1,456,250.00 13.06%A 3 5000 $45.00 $225,000.00 $1,681,250.00 8.39%A 17 1470 $100.00 $147,000.00 $1,828,250.00 5.48%B 16 675 $200.00 $135,000.00 $1,963,250.00 5.04%B 10 2000 $65.00 $130,000.00 $2,093,250.00 4.85%B 2 6450 $20.00 $129,000.00 $2,222,250.00 4.81%B 11 5000 $25.00 $125,000.00 $2,347,250.00 4.66%B 18 8200 $15.00 $123,000.00 $2,470,250.00 4.59%C 1 15000 $5.00 $75,000.00 $2,545,250.00 2.80%C 7 800 $80.00 $64,000.00 $2,609,250.00 2.39%C 14 2900 $10.00 $29,000.00 $2,638,250.00 1.08%C 6 84 $250.00 $21,000.00 $2,659,250.00 0.78%C 15 800 $15.00 $12,000.00 $2,671,250.00 0.45%C 13 9000 $0.50 $4,500.00 $2,675,750.00 0.17%C 4 200 $12.50 $2,500.00 $2,678,250.00 0.09%C 8 300 $5.00 $1,500.00 $2,679,750.00 0.06%C 20 2500 $0.20 $500.00 $2,680,250.00 0.02%C 19 1250 $0.16 $200.00 $2,680,450.00 0.01%
Total $2,680,450.00 100.00%
CATEGORIA ARTICULOS % articulos % Valor Valor en $A 5 25.00% 68.21% $1,828,250.00B 5 25.00% 23.95% $642,000.00C 10 50.00% 7.84% $210,200.00
TOTAL 20 100.00% 100.00% $2,680,450.00
Categoria ABC
Número de artículo
Utilización anual
proyectadaCosto
Unitario
Utilización anual
proyectada en dinero
Utilización acumulada en
dineroFrecuencia
relativa
25.00% 25.00% 50.00%0.00%
25.00%
50.00%
75.00%
100.00%
68.21%
23.95%7.84%
Histograma ABC
Porcentaje de artículos totales de inventario (20 artículos)
Porc
enta
je d
e uti
lizac
ione
s tot
ales
de
in-
vent
ario
(val
or e
n di
nero
)
% Artículo26.12% 5.00% 5.00%41.27% 5.00% 10.00%54.33% 5.00% 15.00%62.72% 5.00% 20.00%68.21% 5.00% 25.00% 68.21%73.24% 5.00% 30.00%78.09% 5.00% 35.00%82.91% 5.00% 40.00%87.57% 5.00% 45.00%92.16% 5.00% 50.00% 23.95%94.96% 5.00% 55.00%97.34% 5.00% 60.00%98.43% 5.00% 65.00%99.21% 5.00% 70.00%99.66% 5.00% 75.00%99.82% 5.00% 80.00%99.92% 5.00% 85.00%99.97% 5.00% 90.00%99.99% 5.00% 95.00%
100.00% 5.00% 100.00% 7.84%
Porcentaje acumulado
del total
Porcentaje acumulado de artículos
25.00% 25.00% 50.00%0.00%
25.00%
50.00%
75.00%
100.00%
68.21%
23.95%7.84%
Histograma ABC
Porcentaje de artículos totales de inventario (20 artículos)
Porc
enta
je d
e uti
lizac
ione
s tot
ales
de
in-
vent
ario
(val
or e
n di
nero
)
