Ejemplo Inventario A B C

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

CONSTO PORCENTAJE

REFERENCIA CANTIDAD COSTO TOTAL CLASE


UNITARIO ACUMULADO
E 1,916 498,066 954,294,456 12.12% A
H 2,214 429,192 950,231,088 24.18% A
C 2,337 393,670 920,006,790 35.86% A
J 2,398 334,015 800,967,970 46.03% A
T 2,464 272,361 671,097,504 54.55% A
Q 1,136 494,706 561,986,016 61.68% A
M 923 406,259 374,977,057 66.44% A
S 1,118 324,136 362,384,048 71.04% A
R 1,635 209,641 342,763,035 75.40% A
U 1,488 215,688 320,943,744 79.47% A
B 2,415 123,940 299,315,100 83.27% A
L 892 302,397 269,738,124 86.69% A
A 614 381,304 234,120,656 89.67% A
Y 883 219,611 193,916,513 92.13% A
V 1,207 105,135 126,897,945 93.74% B
O 1,202 102,810 123,577,620 95.31% B
D 254 293,577 74,568,558 96.26% B
X 141 400,428 56,460,348 96.97% B
N 361 146,262 52,800,582 97.64% B
P 202 232,750 47,015,500 98.24% C
I 115 321,324 36,952,260 98.71% C
K 577 63,822 36,825,294 99.18% C
G 345 101,002 34,845,690 99.62% C
Z 189 87,708 16,576,812 99.83% C
F 219 42,914 9,398,166 99.95% C
W 124 32,657 4,049,468 100.00% C
TOTALES 7,876,710,344
% de
Consumo anual Costo Consumo ($)
Art N° Art N° participacion de
(unidades) unitario ($) c/art valorizacion

1 5000 1.50 1 5 7500


2 1500 8.00 2 5 12000
3 10000 10.50 3 5 105000
4 6000 2.00 4 5 12000
5 3500 0.50 5 5 1750
6 6000 13.60 6 5 81600
7 5000 0.75 7 5 3750
8 4500 1.25 8 5 5625
9 7000 5.00 9 5 35000
10 3000 2.00 10 5 6000
11 6000 10.00 11 5 60000
12 2000 15.00 12 5 30000
13 6500 28.00 13 5 182000
14 9300 31.00 14 5 288300
15 3060 14.00 15 5 42840
16 3177 4.00 16 5 12708
17 1500 1.20 17 5 1800
18 1962 8.00 18 5 15696
19 7000 30.00 19 5 210000
20 1246 15.00 20 5 18690
Totales 100 1132259
%del consumo % %partic. % valor
Art N° %valorizacion
total ($) participacion Acum acum

0.66% 2 5 0.66%
1.06% 12 5 1.06%
9.27% 8 5 9.27%
1.06% 17 5 1.06%
0.15% 15 5 0.15%
7.21% 1 5 7.21%
0.33% 3 5 0.33%
0.50% 20 5 0.50%
3.09% 5 5 3.09%
0.53% 18 5 0.53%
5.30% 14 5 5.30%
2.65% 6 5 2.65%
16.07% 9 5 16.07%
25.46% 19 5 25.46%
3.78% 13 5 3.78%
1.12% 11 5 1.12%
0.16% 10 5 0.16%
1.39% 4 5 1.39%
18.55% 16 5 18.55%
1.65% 7 5 1.65%
100.00%
Clase

You might also like