Nothing Special   »   [go: up one dir, main page]

Sistema de Inventario ABC

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 6

A 20%

B 30%
C 50%

CODIGO DE PRODUCTO COSTO UNITARIO EN $ CANTIDAD PRECIO UNITARIO

28 11500 2000 16330


5 10800 4050 15336
24 7700 2020 10934
29 6600 5800 9372
15 5400 4000 7668
1 5000 6000 7100
6 4500 1400 6390
30 3000 1600 4260
16 2310 1900 3280.2
13 1880 4140 2669.6
23 1700 4000 2414
10 1580 1916 2243.6
20 1560 1900 2215.2
4 1475 1500 2094.5
18 1395 1700 1980.9
33 1280 1650 1817.6
12 1110 1980 1576.2
27 900 2000 1278
3 860 2400 1221.2
34 792 2500 1124.64
19 680 2860 965.6
32 575 3120 816.5
8 505 0 732.25
11 400 714 580
26 356 3300 505.52
21 320 3200 454.4
9 300 3400 426
7 245 2400 347.9
17 179 2700 254.18
31 163 3490 231.46
25 150 3800 213
14 120 3100 170.4
22 105 5000 149.1
2 50 7600 71
107222.95
Estos valores se toman en cuenta cuando en el problema no nos dan porcentajes

PRECIO UNITARIO Y
% PARTICIPACION PARTICIPACION ACUMULADA CLASIFICACION
CLASIFICACION
15.23% 15.23%
14.30% 29.53% A (10%) 42,600.00
10.20% 39.73%
8.74% 48.47%
7.15% 55.62%
6.62% 62.24%
5.96% 68.20% B (20%) 40,739.80
3.97% 72.18%
3.06% 75.24%
2.49% 77.73%
2.25% 79.98%
2.09% 82.07%
2.07% 84.14%
1.95% 86.09%
1.85% 87.94%
1.70% 89.63%
1.47% 91.10%
1.19% 92.29%
1.14% 93.43%
1.05% 94.48%
0.90% 95.38%
0.76% 96.14%
C (70%) 23,883.15
0.68% 96.83%
0.54% 97.37%
0.47% 97.84%
0.42% 98.26%
0.40% 98.66%
0.32% 98.98%
0.24% 99.22%
0.22% 99.44%
0.20% 99.64%
0.16% 99.79%
0.14% 99.93%
0.07% 100.00%
100.00% 107,222.95
PARTICIPACION POR
PRECIO UNITARIO

40%

38%
34*10% 3.4 3
34*20% 6.8 6
34*70% 23.8 RESTO

22%
m COSTO UNITARIO EN $ CANTIDAD COSTO TOTAL

5 10800 4050 43740000


29 6600 5800 38280000
1 5000 6000 30000000
28 11500 2000 23000000
15 5400 4000 21600000
24 7700 2020 15554000
13 1880 4140 7783200
23 1700 4000 6800000
6 4500 1400 6300000
30 3000 1600 4800000
16 2310 1900 4389000
10 1580 1916 3027280
20 1560 1900 2964000
18 1395 1700 2371500
4 1475 1500 2212500
12 1110 1980 2197800
33 1280 1650 2112000
3 860 2400 2064000
34 792 2500 1980000
19 680 2860 1944800
27 900 2000 1800000
32 575 3120 1794000
26 356 3300 1174800
21 320 3200 1024000
9 300 3400 1020000
7 245 2400 588000
25 150 3800 570000
31 163 3490 568870
22 105 5000 525000
17 179 2700 483300
2 50 7600 380000
14 120 3100 372000
11 400 714 285600
8 505 0 0
PRECIO UNITARIO VALOR TOTAL % PARTICIPACION PARTICIPACION ACUMULADA

15336 62110800 18.72% 18.72%


9372 54357600 16.38% 35.09%
7100 42600000 12.84% 47.93%
16330 32660000 9.84% 57.77%
7668 30672000 9.24% 67.01%
10934 22086680 6.66% 73.67%
2669.6 11052144 3.33% 77.00%
2414 9656000 2.91% 79.91%
6390 8946000 2.70% 82.60%
4260 6816000 2.05% 84.66%
3280.2 6232380 1.88% 86.54%
2243.6 4298737.6 1.30% 87.83%
2215.2 4208880 1.27% 89.10%
1980.9 3367530 1.01% 90.11%
2094.5 3141750 0.95% 91.06%
1576.2 3120876 0.94% 92.00%
1817.6 2999040 0.90% 92.91%
1221.2 2930880 0.88% 93.79%
1124.64 2811600 0.85% 94.64%
965.6 2761616 0.83% 95.47%
1278 2556000 0.77% 96.24%
816.5 2547480 0.77% 97.01%
505.52 1668216 0.50% 97.51%
454.4 1454080 0.44% 97.95%
426 1448400 0.44% 98.38%
347.9 834960 0.25% 98.63%
213 809400 0.24% 98.88%
231.46 807795.4 0.24% 99.12%
149.1 745500 0.22% 99.35%
254.18 686286 0.21% 99.55%
71 539600 0.16% 99.72%
170.4 528240 0.16% 99.88%
580 414120 0.12% 100.00%
732.25 0 0.00% 100.00%
107222.95 331870591 100.00%
CLASIFICACION VALOR POR %PARTICIPACION
CLASIFICACION

A (10%) 159068400 48%

B (20%) 121888824 37%

C (70%) 50913367 15%

331870591

También podría gustarte