Signo

REF |Beneficio |Ventas |REF

ORDENADAS |Volumen ventas |%vol. vtas. |% acum. Ventas |Beneficio |% BºENEFI |Clasificación | |4040 |410.000 |2.050.000 |4042 |550.000 |14.87 |14.87 |910000 |4.08 |4.08| |4041 |420.000 |1.850.000 |4044 |490000 |13.25 |28.12 |2200000 |9.86 |19.94 | |4042 |550.000 |910.000 |4049 |463000 |12.52 |40.64 |1250000 |5.6 |19.54 | |4043 |410.000 |4.150.000 |4041 |420000|11.35 |51.99 |1850000 |8.29 |27.83 | |4044 |490.000 |2.200.000 |4040 |410000 |11.08 |63.07 |2050000 |9.18 |37.01 | |4045 |195.000 |1.300.000 |4043 |410000 |11.08 |74.15 |4150000 |18.59 |55.06 | |4046|355.000 |4.000.000 |4046 |355000 |9.6 |83.75 |4000000 |17.92 |73.52 | |4047 |68.000 |575.000 |4050 |250000 |6.76 |90.51 |2300000 |10.30 |83.82 | |4048 |84.000 |285.000 |4045 |195000 |5.27 |98.78|1300000 |5.82 |89.64 | |4049 |463.000 |1.250.000 |4048 |84000 |2.27 |98.05 |285000 |1.28 |90.92 | |4050 |250.000 |2.300.000 |4047 |68000 |1.83 |99.88 |575000 |2.58 |93.5 | |4051 |4.500 |1.450.000 |4051|4500
|0.12 |100
|1450000 |6.5 |100 | |TOTALES 3699500 122320000

Reducimos el numero de referencias a 7 quedando losa sgrupos ordenados con suvolumen de ventas de mayor a menor

referencias |%referencias |%refacumula |Volumen ventas |%volumen
ventas |%volumen ventas
acumulado |Benefici |%Bene |%benefi
acumulado | |GRUPO
1 |14.3 |14.3|1040000 |28.11 |28.11 |3110000 |13.93 |13.93 | |G2 |14.3 |28.6 |883000 |23.86 |51.97 |3100000 |13.89 |27.82 | |G3 |14.3 |42.9 |820000 |22.17 |74.14 |6200000 |27.78 |55.6 | |G4 |14.3 |57.2 |605000|16.36 |90.50 |6300000 |28.23 |83.83 | |G5 |14.3 |71.5 |195000 |5.27 |95.78 |1300000 |5.82 |89.65 | |G6 |14.3 |85.8 |152000 |4.11 |99.83 |860000 |3.85 |93.5 | |G7 |14.3 |100 |4500 |0.12 |100 |1450000|6.5 |100
| |TOTALES 3699500 22320000

Clasificamos en ABC
|Porcentaje de
referencias |% referencias
acumuladas...