Articulo Costo Unitario ($) Unidades Valor Total

1 $0.20 17000 $ 3,400.00

2 $0.05 50000 $ 2,500.00
3 $0.09 5000 $ 450.00
4 $0.07 4800 $ 336.00
5 $0.11 2000 $ 220.00
6 $0.15 1300 $ 195.00
7 $0.16 400 $ 64.00
8 $0.08 700 $ 56.00
9 $0.12 400 $ 48.00
10 $0.04 300 $ 12.00
Total $ 7,281.00

GRAFICO DE PARETO
60000

50000

40000

30000

20000

10000

0
1 2 3 4 5 6 7 8 9 10 1

Row 3 Row 4 Row 5 Row 6 Row 7

Row 8 Row 9 Row 10 Row 11 Row 12
 Porcentaje De Participaci Participacion Acumulada Clase Participacion Estimmada
46.6969% 46.6969% A 0-80%
34.3359% 81.0328% B 81%-95%
6.1805% 87.2133% B 96%-100%
4.6148% 91.8280% B
3.0216% 94.8496% B
2.6782% 97.5278% C
0.8790% 98.4068% C
0.7691% 99.1759% C
0.6593% 99.8352% C
0.1648% 100.0000% C
100%

RETO
1
0.9
0.8
0.7
0.6
0.5
0.4
0.3
0.2
0.1
0
8 9 10 11 12

Row 6 Row 7
Row 11 Row 12
 REGLA DE PARETO -ANALISIS ABC
Participacion Estimmada Clasificacion Numero De Productos % Categoria Sobre el Tota % Acumulado
0-80% A 1 10% 10%
81%-95% B 4 40% 50%
96%-100% C 5 50% 100%
Total 10 100%
-ANALISIS ABC
% Acumulado Ventas % Por Ventas % Acumulado
10% $ 3,400.00 47% 47%
50% $ 3,506.00 48% 95%
100% $ 375.00 5% 100%
$ 7,281.00
Articulo Costo Unitario ($) Unidades Valor Total
1 1000 150 $ 150,000
2 950 140 $ 133,000
3 850 130 $ 110,500
4 800 97 $ 77,600
5 480 96 $ 46,080
6 470 95 $ 44,650
7 460 94 $ 43,240
8 450 93 $ 41,850
9 440 92 $ 40,480
10 430 91 $ 39,130
11 420 90 $ 37,800
12 410 89 $ 36,490
13 400 88 $ 35,200
14 390 87 $ 33,930
15 380 86 $ 32,680
16 370 85 $ 31,450
19 340 90 $ 30,600
17 360 84 $ 30,240
20 330 89 $ 29,370
18 350 83 $ 29,050
Total $ 1,053,340

1200

1000

800

600

400

200

0
1 2 3 4 5 6

Column A Column B
Column G Column H
 Porcentaje De Participaci Participacion Acumulada Clase
14.2404% 14.2404% A Participacion Estimmada
12.6265% 26.8669% A 0-80%
10.4904% 37.3574% A 81%-95%
7.3670% 44.7244% A 96%-100%
4.3747% 49.0991% A
4.2389% 53.3380% A
4.1050% 57.4430% A
3.9731% 61.4161% A
3.8430% 65.2591% A
3.7148% 68.9739% A
3.5886% 72.5625% A
3.4642% 76.0267% A
3.3418% 79.3685% A
3.2212% 82.5897% B
3.1025% 85.6922% B
2.9857% 88.6779% B
2.9050% 91.5830% B
2.8709% 94.4538% B
2.7883% 97.2421% C
2.7579% 100.0000% C
100.0000%

GRAFICO DE PARETO
1200 $1

1000

800

600 $1

400

200

0 $-
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Column A Column B Column C Column D Column E Column F

Column G Column H Column I Column J Column K Column L
 REGLA DE PARETO -ANALISIS ABC
Participacion Estimmada Clasificacion Numero De Productos % Categoria Sobre el Tota % Acumulado
0-80% A 13 65% 65%
81%-95% B 5 25% 90%
96%-100% C 2 10% 100%
TOTAL 20 100%
-ANALISIS ABC
% Acumulado Ventas % Por Ventas % Acumulado
65% $ 836,020.00 79% 79%
90% $ 158,900.00 15% 94%
100% $ 58,420.00 6% 100%
$ 1,053,340.00
 Articulo Costo Unitario ($) Utilizacion anual o dema Valor Total
Tubo Petroleo $288,000.00 1603 $461,664,000.00
Acrilico 8 mn $294,200.00 1330 $391,286,000.00
Lamina galv $105,000.00 446 $46,830,000.00
Tubo Rectang $63,891.00 480 $30,667,680.00
Tubo Redondo $110,250.00 276 $30,429,000.00
Tripex Calibre $70,600.00 425 $30,005,000.00
Tubo Redondo $17,700.00 1670 $29,559,000.00
Lona Trans luc $18,500.00 1589 $29,396,500.00
Soldadura $124,828.00 111 $13,855,908.00
Tuerca Hexa $320.00 1258 $402,560.00
Papel Lija $700.00 563 $394,100.00
Alambre $1,370.00 279 $382,230.00
Madero De 2 $1,000.00 378 $378,000.00
Hebilla Acen $468.00 792 $370,656.00
Tuerca Hexa $905.00 398 $360,190.00
Perno De Ex $250.00 1431 $357,750.00
Total $1,066,338,574.00

Grafi
500000000
400000000
300000000
200000000
100000000
0
o n v ng do re
l e m al b
tro 8 a g ecta don ali d
e o n e C
P li c i R R x Re
ubo Acri Lam ubo ubo ripe ubo
T T T T T Lo

Column B Col
Column F Col
Column J Col
 Porcentaje De Participaci Participacion Acumulada Clase
43.2943% 43.2943% A Participacion Estimmada
36.6943% 79.9887% A 0-80%
4.3917% 84.3803% B 81%-95%
2.8760% 87.2563% B 96%-100%
2.8536% 90.1099% B
2.8138% 92.9237% B
2.7720% 95.6957% C
2.7568% 98.4525% C
1.2994% 99.7519% C
0.0378% 99.7897% C
0.0370% 99.8266% C
0.0358% 99.8625% C
0.0354% 99.8979% C
0.0348% 99.9327% C
0.0338% 99.9665% C
0.0335% 100.0000% C
100.0000%

Grafico De Pareto
00000000 1
00000000 0.8
00000000 0.6
00000000 0.4
00000000 0.2
0 0
o n v ng do re do uc ra xa ija re 2 en xa Ex
l e m al b l u b e
tro 8 a g ecta don ali don ns ad a He el L am o D a Ac a He De
Pe lico in R Re x C Re Tra Sold erc Pap Al der bill erc rno
ubo Acri Lam ubo ubo ripe ubo na Tu a
M H
e Tu Pe
T T T T T Lo

Column B Column C Column D Column E

Column F Column G Column H Column I
Column J Column K Column L
 REGLA DE PARETO -ANALISIS ABC
Participacion Estimmada Clasificacion Numero De Productos % Categoria Sobre el Tota % Acumulado
0-80% A 2 13% 13%
81%-95% B 4 25% 38%
96%-100% C 10 63% 100%
TOTAL 16 100%
-ANALISIS ABC
% Acumulado Ventas % Por Ventas % Acumulado
13% $ 852,950,000.00 80% 80%
38% $ 137,931,680.00 13% 93%
100% $ 75,456,894.00 7% 100%
$ 1,066,338,574.00
N° Nombre Del Articulo Cantidad De Unidades V Costo Unitario
1 Lavodora tipo 1400 1400000
2 Lavodora tipo 1230 1300000
3 Lavodora tipo 1230 1150000
4 Lavodora tipo 1200 1200000
5 Lavodora tipo 1150 1450000
6 Lavodora tipo 950 1600000
7 Lavodora tipo 900 1500000
8 Lavodora tipo 630 8900000
9 Lavodora tipo 600 1050000
10 Lavodora tipo 500 900000
11 Lavodora tipo 450 950000
12 Lavodora tipo 420 780000
13 Lavodora tipo 400 860000
14 Lavodora tipo 380 840000
15 Lavodora tipo 350 800000
16 Lavodora tipo 300 750000
Total

Grafico De Pareto
6000000000
5000000000
4000000000
3000000000
2000000000
1000000000
0
Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo
1 2 3 4 5 6 7 8 9 10

Column D Column E Column F Column G

Column J Column K Column L Column M
 Valor Total Porcentaje De Participaci Participacion Acumulada Clase
$ 1,960,000,000 10.0198% 10.0198% A
$ 1,599,000,000 8.1743% 18.1941% A
$ 1,414,500,000 7.2311% 25.4252% A
$ 1,440,000,000 7.3615% 32.7867% A
$ 1,667,500,000 8.5245% 41.3112% A
$ 1,520,000,000 7.7704% 49.0816% A
$ 1,350,000,000 6.9014% 55.9830% A
$ 5,607,000,000 28.6637% 84.6467% B
$ 630,000,000 3.2206% 87.8674% B
$ 450,000,000 2.3005% 90.1678% B
$ 427,500,000 2.1854% 92.3533% B
$ 327,600,000 1.6747% 94.0280% B
$ 344,000,000 1.7586% 95.7866% C
$ 319,200,000 1.6318% 97.4184% C
$ 280,000,000 1.4314% 98.8498% C
$ 225,000,000 1.1502% 100.0000% C
$ 19,561,300,000 100.0000%

Grafico De Pareto
$1

$1

$-
Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

Lavodora tipo

6 7 8 9 10 11 12 13 14 15 16

E Column F Column G Column H Column I

K Column L Column M Column N
 REGLA DE PARETO -ANA
Participacion Estimmada Clasificacion Numero De Productos % Categoria Sobre el Tota
0-80% A 7 44%
81%-95% B 5 31%
96%-100% C 4 25%
TOTAL 16 100%
 REGLA DE PARETO -ANALISIS ABC
% Categoria Sobre el Tota % Acumulado Ventas % Por Ventas % Acumulado
44% 44% $ 10,951,000,000.00 56% 56%
31% 75% $ 7,442,100,000.00 38% 94%
25% 100% $ 1,168,200,000.00 6% 100%
100% $ 19,561,300,000.00
% Acumulado
56%
94%
100%
Articulo Costo Unitario Utilizacion anual o dema Valor Total
16 15,050.00 3450 $51,922,500.00
11 8,200.00 3550 $29,110,000.00
13 8,450.00 2830 $23,913,500.00
9 19,850.00 970 $19,254,500.00
22 7,150.00 1930 $13,799,500.00
14 9,100.00 960 $8,736,000.00
25 12,320.00 621 $7,650,720.00
27 6,100.00 657 $4,007,700.00
19 4,080.00 952 $3,884,160.00
34 4,750.00 480 $2,280,000.00
21 635.00 2975 $1,889,125.00
3 2,350.00 690 $1,621,500.00
33 3,800.00 370 $1,406,000.00
35 9,110.00 150 $1,366,500.00
12 2,100.00 600 $1,260,000.00
15 3,850.00 280 $1,078,000.00
32 2,550.00 420 $1,071,000.00
8 3,500.00 265 $927,500.00
30 1,300.00 700 $910,000.00
1 2,700.00 285 $769,500.00
10 1,750.00 415 $726,250.00
5 3,700.00 180 $666,000.00
7 959.00 622 $596,498.00
28 1,200.00 489 $586,800.00
6 195.00 2790 $544,050.00
17 965.00 559 $539,435.00
26 1,150.00 459 $527,850.00
24 950.00 426 $404,700.00
18 645.00 612 $394,740.00
31 1,190.00 289 $343,910.00
29 450.00 742 $333,900.00
23 650.00 450 $292,500.00
2 1,800.00 150 $270,000.00
20 1,110.00 221 $245,310.00
4 450.00 255 $114,750.00
Total $183,444,398.00

Grafico De Pareto
25000

20000

15000

10000

5000
20000

15000

10000

5000

0
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

Column A Column B Column C Column D Column

Column G Column H Column I Column J Column
 Porcentaje De Participaci Participacion Acumulada Clase
28.3042% 28.3042% A
15.8686% 44.1728% A
13.0358% 57.2086% A
10.4961% 67.7047% A Participacion Estimmada
7.5224% 75.2272% A 0-80%
4.7622% 79.9894% A 81%-95%
4.1706% 84.1600% B 96%-100%
2.1847% 86.3446% B
2.1174% 88.4620% B
1.2429% 89.7049% B
1.0298% 90.7347% B
0.8839% 91.6186% B
0.7664% 92.3851% B
0.7449% 93.1300% B
0.6869% 93.8168% B
0.5876% 94.4045% B
0.5838% 94.9883% B
0.5056% 95.4939% C
0.4961% 95.9900% C
0.4195% 96.4094% C
0.3959% 96.8053% C
0.3631% 97.1684% C
0.3252% 97.4935% C
0.3199% 97.8134% C
0.2966% 98.1100% C
0.2941% 98.4041% C
0.2877% 98.6918% C
0.2206% 98.9124% C
0.2152% 99.1276% C
0.1875% 99.3151% C
0.1820% 99.4971% C
0.1594% 99.6565% C
0.1472% 99.8037% C
0.1337% 99.9374% C
0.0626% 100.0000% C
100.0000%

o De Pareto
$1.00
$0.90
$0.80
$0.70
$0.60
$0.50
$0.40
$0.30
$0.20
$0.10
 $0.90
$0.80
$0.70
$0.60
$0.50
$0.40
$0.30
$0.20
$0.10
$0.00
7 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

mn C Column D Column E Column F

mn I Column J Column K Column L
 REGLA DE PARETO -ANALISIS ABC
Participacion Estimmada Clasificacion Numero De Productos % Categoria Sobre el Tota % Acumulado
0-80% A 6 17% 17%
81%-95% B 11 31% 49%
96%-100% C 18 51% 100%
TOTAL 35 100%
-ANALISIS ABC
% Acumulado Ventas % Por Ventas % Acumulado
17% $ 146,736,000.00 80% 80%
49% $ 27,514,705.00 15% 95%
100% $ 9,193,693.00 5% 100%
$ 183,444,398.00