Clasifique los siguientes

inventarios aplicando la
metodología ABC

Item Materias primas Unidades Costo Uni. Consumo

7 mmpp 007 Metros S/. 22.00 147.00

6 mmpp 006 Metros S/. 13.00 138.00
1 mmpp 001 Pies S/. 2.50 480.00
15 mmpp 015 Unidades S/. 80.00 14.00
24 mmpp 024 Kilos S/. 10.80 100.00
14 mmpp 014 Unidades S/. 44.50 18.00
16 mmpp 016 Unidades S/. 13.00 42.00
5 mmpp 005 Galones S/. 16.00 16.00
18 mmpp 018 Galones S/. 34.00 7.00
21 mmpp 021 Unidades S/. 17.50 10.00
22 mmpp 022 Unidades S/. 17.50 10.00
13 mmpp 013 Unidades S/. 22.50 6.00
11 mmpp 011 Unidades S/. 11.20 12.00
10 mmpp 010 Unidades S/. 10.20 12.00
8 mmpp 008 Unidades S/. 3.40 24.00
25 mmpp 025 Kilos S/. 12.00 6.00
12 mmpp 012 Unidades S/. 5.70 12.00
4 mmpp 004 Baldes S/. 18.50 3.00
9 mmpp 009 Unidades S/. 6.80 6.00
19 mmpp 019 Unidades S/. 6.50 6.00
17 mmpp 017 Galones S/. 12.00 3.00
3 mmpp 003 Kilos S/. 4.00 7.00
26 mmpp 026 Metros S/. 0.50 42.00
23 mmpp 023 Metros S/. 6.00 3.00
2 mmpp 002 Kilos S/. 3.50 5.00
20 mmpp 020 Cajas S/. 5.00 3.00
Valor Vendido Participacion participacion acumulada Clasificacion
Valor Vendido
S/. 3,234.00 28.11% 28.1% A S/.3,234.00
S/. 1,794.00 15.60% 43.7% A S/.1,794.00
S/. 1,200.00 10.43% 54.1% A S/.1,200.00
S/. 1,120.00 9.74% 63.9% A S/.1,120.00
S/. 1,080.00 9.39% 73.3% A S/.1,080.00
S/. 801.00 6.96% 80.2% B S/.801.00
S/. 546.00 4.75% 85.0% B S/.546.00
S/. 256.00 2.23% 87.2% B S/.256.00
S/. 238.00 2.07% 89.3% B S/.238.00
S/. 175.00 1.52% 90.8% B S/.175.00
S/. 175.00 1.52% 92.3% B S/.175.00
S/. 135.00 1.17% 93.5% B S/.135.00
S/. 134.40 1.17% 94.7% B S/.134.40
S/. 122.40 1.06% 95.7% C S/.122.40
S/. 81.60 0.71% 96.4% C S/.81.60
S/. 72.00 0.63% 97.1% C S/.72.00
S/. 68.40 0.59% 97.6% C S/.68.40
S/. 55.50 0.48% 98.1% C S/.55.50
S/. 40.80 0.35% 98.5% C S/.40.80
S/. 39.00 0.34% 98.8% C S/.39.00
S/. 36.00 0.31% 99.1% C S/.36.00
S/. 28.00 0.24% 99.4% C S/.28.00
S/. 21.00 0.18% 99.6% C S/.21.00
S/. 18.00 0.16% 99.7% C S/.18.00
S/. 17.50 0.15% 99.9% C S/.17.50
S/. 15.00 0.13% 100.0% C S/.15.00
S/. 11,503.60
participacion
acumulada
28%
44%
54%
64%
73%
80%
85%
87%
89%
91%
92%
93%
95% Chart Title
96% 120% S/.3,500.00
96% S/.3,000.00
100%
97%
S/.2,500.00
98% 80%
98% S/.2,000.00
60%
98% S/.1,500.00
99% 40%
S/.1,000.00
99%
20%
99% S/.500.00
100% 0% S/.0.00
100% 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

100% Valor Vendido participacion acumulada

100%
 S/.3,500.00

S/.3,000.00

S/.2,500.00

S/.2,000.00

S/.1,500.00

S/.1,000.00

S/.500.00

S/.0.00
22 23 24 25 26

ulada
 Cant.
Item Materias pri Unidades Precio UnitExistente

1 MP-01 Metros S/.22.00 147

2 MP-02 Metros S/.13.00 138
3 MP-03 Pies S/.2.50 480
4 MP-04 Unidades S/.80.00 14
5 MP-05 Kilos S/.10.80 100
6 MP-06 Unidades S/.44.50 18
7 MP-07 Unidades S/.13.00 42
8 MP-08 Galones S/.16.00 16
9 MP-09 Galones S/.34.00 7
10 MP-10 Unidades S/.17.50 10
11 MP-11 Unidades S/.17.50 10
12 MP-12 Unidades S/.22.50 6
13 MP-13 Unidades S/.11.20 12
14 MP-14 Unidades S/.10.20 12
15 MP-15 Unidades S/.3.40 24
16 MP-16 Kilos S/.12.00 6
17 MP-17 Unidades S/.5.70 12
18 MP-18 Baldes S/.18.50 3
19 MP-19 Unidades S/.6.80 6
20 MP-20 Unidades S/.6.50 6
21 MP-21 Galones S/.12.00 3
22 MP-22 Kilos S/.4.00 7
23 MP-23 Metros S/.0.50 42
24 MP-24 Metros S/.6.00 3
25 MP-25 Kilos S/.3.50 5
26 MP-26 Cajas S/.5.00 3
S/.80.00
S/.398.60

A= 15% 4
B=20% 5
C=65% 17
26
Valor Inventario Categoria %

S/.3,234.00 S/.3,234.00 28.11% A

S/.1,794.00 S/.5,028.00 43.71% A A
S/.1,200.00 S/.6,228.00 54.14% A
S/.1,120.00 S/.7,348.00 63.88% A Estos 5 productos representan el 73
S/.1,080.00 S/.8,428.00 73.26% A 73.26% S/.8,428.00
S/.801.00 S/.9,229.00 80.23% B
S/.546.00 S/.9,775.00 84.97% B
S/.256.00 S/.10,031.00 87.20% B
S/.238.00 S/.10,269.00 89.27% B B Los siguientes 8 productos pertenec
S/.175.00 S/.10,444.00 90.79% B a la categoria B representa el
S/.175.00 S/.10,619.00 92.31% B 21.39%
S/.135.00 S/.10,754.00 93.48% B
S/.134.40 S/.10,888.40 94.65% B 21.39% S/.2,460.40
S/.122.40 S/.11,010.80 95.72% C
S/.81.60 S/.11,092.40 96.43% C
S/.72.00 S/.11,164.40 97.05% C
S/.68.40 S/.11,232.80 97.65% C
S/.55.50 S/.11,288.30 98.13% C
S/.40.80 S/.11,329.10 98.48% C
C
S/.39.00 S/.11,368.10 98.82% C
S/.36.00 S/.11,404.10 99.14% C
S/.28.00 S/.11,432.10 99.38% C Los ultimos 13 productos de Catego
S/.21.00 S/.11,453.10 99.56% C 5.35%
S/.18.00 S/.11,471.10 99.72% C
S/.17.50 S/.11,488.60 99.87% C
S/.15.00 S/.11,503.60 100.00% C 5.35% S/.615.20
S/.11,503.60 100.00% 100%
 Intervalos Categoria
0-80% A
80%-95% B
stos 5 productos representan el 73.26% de los CT 95%-100% C

os siguientes 8 productos pertenecientes

la categoria B representa el Grafico 01 : Clasificacion
120.00%

100.00%

80.00% A

60.00%

40.00%
B
20.00%

0.00%

os ultimos 13 productos de Categoria C, representan unicamente un %CT %CT Acumulado

 N.elementos % Articulos % Acumulado %CT %CT Acumulado
5 19% 19% 73.26% 73.26%
8 31% 50% 21.39% 94.65%
13 50% 100% 5.35% 100.00%
26

01 : Clasificacion

%CT Acumulado
Codigo Demanda Costo Unitario Costo Total Ctacumulado
A-9 2779 S/.1,924.00 S/.5,346,796.00 S/.5,346,796.00
A-4 2527 S/.1,836.00 S/.4,639,572.00 S/.9,986,368.00
A-2 2405 S/.1,701.00 S/.4,090,905.00 S/.14,077,273.00
A-6 2693 S/.1,390.00 S/.3,743,270.00 S/.17,820,543.00
A-3 1988 S/.1,872.00 S/.3,721,536.00 S/.21,542,079.00
A-7 1733 S/.2,031.00 S/.3,519,723.00 S/.25,061,802.00
A-16 2104 S/.1,651.00 S/.3,473,704.00 S/.28,535,506.00
A-1 1852 S/.1,829.00 S/.3,387,308.00 S/.31,922,814.00
A-8 2178 S/.1,540.00 S/.3,354,120.00 S/.35,276,934.00
A-13 2003 S/.1,651.00 S/.3,306,953.00 S/.38,583,887.00
A-12 2061 S/.1,195.00 S/.2,462,895.00 S/.41,046,782.00
A-11 2879 S/.510.00 S/.1,468,290.00 S/.42,515,072.00
A-5 2288 S/.602.00 S/.1,377,376.00 S/.43,892,448.00
A-15 2888 S/.417.00 S/.1,204,296.00 S/.45,096,744.00
A-14 2885 S/.407.00 S/.1,174,195.00 S/.46,270,939.00
A-10 2662 S/.438.00 S/.1,165,956.00 S/.47,436,895.00
S/.47,436,895.00
Porcentaje CT
acumulado Zona %
11% A 0-80%
21% A 80%-95%
30% A 95%-100%
38% A
45% A
53% A
60% A
67% A
120%
74% A 74% S/.35,276,934.00
81% B
100%
87% B
90% B
80%
93% B 18% S/.8,615,514.00
95% C
60%
98% C
100% C 7% S/.3,544,447.00 40%
100%
20%

0%
 Zona N.elementos % Articulos % Acumulado %CT %CT Acumulado
A 9 56% 56% 74% 74%
B 4 25% 81% 18% 93%
C 3 19% 100% 7% 100%
16

120%

100%

80% A

60%

40%

B
20%
C

0%

%CT %CT Acumulado