SEGUIR INSTRUCCIONES DE LAS CELDAS Y LAS SEÑALES ROJAS DE NOTIFICACIÓN
% DE ORDENAR H ORDENAR F ORDENAR F
% DE % DE
CxD C x (D-E) G/TOTAL MAYOR A MAYOR A MAYOR A % PRODUCTOS
F/TOTAL F C/TOTAL C
G MENOR MENOR MENOR
A B C D E F G H I J K N Q R
CANTIDAD
PRECIO DE COSTO DE VENTA MARGEN %
VENDIDAS % VENTA / % UNIDAD / NO
VENTA VENTA TOTAL TOTAL MARGEN / % /TV
No. NOMBRE EN EL AÑO, VENTA UNIDADES ABC/VENTA PRIORIDAD SELECCIONAR
POR POR ANUAL EN ANUAL EN MARGEN ACUMULADO
EN TOTAL TOTAL NO ORDENAR
UNIDAD UNIDAD VALORES VALORES TOTAL
UNIDADES
1 AGUA PURA BOLSA 1/2 LT. 6,167,517 2.31 1.27 14,251,590 6,418,843 21.32% 19.73% 26.55% 21.32% A. 5%
2 LECHE BOLSA 1/2 LITRO 6,996,172 1.86 0.925 12,992,941 6,518,683 19.43% 20.04% 30.12% 40.75% A. 11%
10 BEBIDA DE NARANJA GALON 402,103 15.07 6.897 6,058,982 3,285,681 9.06% 10.10% 1.73% 49.81% A. 53%
3 BEBIDA NARANJA BOTELLA 0.5 1,723,894 3.38 1.75 5,818,144 2,801,329 8.70% 8.61% 7.42% 58.52% A. 16%
4 BEBIDA NARANJA BOTELLA 250 1,719,998 3.38 1.78 5,804,993 2,743,397 8.68% 8.43% 7.40% 67.20% A. 21%
7 LECHE BOLSA LITRO 1,183,428 3.57 1.787 4,224,395 2,110,200 6.32% 6.49% 5.09% 73.52% A. 37%
14 LECHE GALON ENVASE PLASTICO 185,063 17.69 8.860 3,272,832 1,633,178 4.90% 5.02% 0.80% 78.41% A. 74%
8 QUESO CREMA VASO 4 ONZAS 885,469 2.89 1.384 2,557,125 1,332,078 3.82% 4.10% 3.81% 82.24% B 42%
15 QUESO SUPER PEQUENO 178,965 11.64 7.173 2,082,859 799,214 3.12% 2.46% 0.77% 85.35% B 79%
20 BEBIDA DE NARANJA 1/2 GALON 121,420 8.04 4.572 975,852 420,720 1.46% 1.29% 0.52% 86.81% B 105%
5 CREMA COMERCIAL 1/8 LIBRA 1,271,542 0.72 0.321 916,941 509,412 1.37% 1.57% 5.47% 88.19% B 26%
24 CREMA PURA PARA BATIR 61,221 14.81 7.582 906,591 442,441 1.36% 1.36% 0.26% 89.54% B 126%
9 LECHE CHOCOLATADA 1/4 LITRO 529,753 1.61 0.714 851,525 473,069 1.27% 1.45% 2.28% 90.81% B 47%
22 QUESO CREMA LIBRA A GRANEL 87,076 9.60 4.665 835,666 429,428 1.25% 1.32% 0.37% 92.06% B 116%
21 AGUA PURA BOT. 600 ML 120,513 6.25 3.78 753,809 298,270 1.13% 0.92% 0.52% 93.19% B 111%
17 LECHE LITRO ENVASE CARTON 164,242 4.39 2.053 721,572 384,449 1.08% 1.18% 0.71% 94.27% B 89%
27 QUESO CAPAS 20 ONZAS 34,991 20.32 10.033 711,187 360,113 1.06% 1.11% 0.15% 95.34% C 142%
26 BEBIDA NARANJA GALON PET 48,877 13.73 7.1 670,830 323,807 1.00% 1.00% 0.21% 96.34% C 137%
13 QUESO CREMA 4 ONZAS(CAJA) 224,225 2.95 1.313 662,316 367,953 0.99% 1.13% 0.97% 99.33% C 68%
29 CREMA PURA 1/2 LITRO 30,761 10.64 5.731 327,419 151,139 0.49% 0.46% 0.13% 97.82% C 153%
18 LECHE 1/2 LITRO CARTON 132,778 2.40 1.067 318,619 177,010 0.48% 0.54% 0.57% 98.30% C 95%
25 CREMA COMERCIAL LITRO 54,277 5.65 3.512 306,713 116,119 0.46% 0.36% 0.23% 98.75% C 132%
23 YOGURT DE MANGO 8 ONZAS 66,189 2.92 1.300 193,529 107,516 0.29% 0.33% 0.28% 99.04% C 121%
11 REFRESCO ROSA JAMAICA 1/4 LT. 259,447 0.58 0.256 149,441 83,023 0.22% 0.26% 1.12% 99.27% C 58%
12 REFRESCO DE MANZANA 1/4 LITRO 231,678 0.58 0.356 133,446 50,969 0.20% 0.16% 1.00% 99.47% C 63%
16 REFRESCO DE PIÑA 1/4 LITRO 172,675 0.58 0.256 99,461 55,256 0.15% 0.17% 0.74% 99.62% C 84%
28 YOGURT DE MORA 8 ONZAS 33,423 2.88 1.380 96,259 50,135 0.14% 0.15% 0.14% 99.76% C 147%
30 QUESO CREMA 8 ONZAS 15,409 5.69 2.829 87,694 44,096 0.13% 0.14% 0.07% 99.89% C 158%
19 REFRESCO DE LIMON 1/4 LITRO 126,550 0.58 0.256 72,893 40,496 0.11% 0.12% 0.54% 100.00% C 100%
TOTALES 23,229,656 66,855,624 32,528,024 100.00% 100.00% 100.00%
SEGUIR INSTRUCCIONES DE LAS CELDAS Y LAS SEÑALES ROJAS DE NOTIFICACIÓN
% DE ORDENAR I ORDENAR ORDENAR F
% DE % DE
CxD C x (D-E) G/TOTAL MAYOR A G MAYOR MAYOR A % PRODUCTOS
F/TOTAL F C/TOTAL C
G MENOR A MENOR MENOR
A B C D E F G H I J L O Q R
CANTIDAD
PRECIO DE COSTO DE VENTA MARGEN %
VENDIDAS % VENTA / % UNIDAD / NO
VENTA VENTA TOTAL TOTAL MARGEN / % M/MV XYZ/
No. NOMBRE EN EL AÑO, VENTA UNIDADES PRIORIDAD SELECCIONAR
POR POR ANUAL EN ANUAL EN MARGEN ACUMULADO MARGEN
EN TOTAL TOTAL NO ORDENAR
UNIDAD UNIDAD VALORES VALORES TOTAL
UNIDADES
2 LECHE BOLSA 1/2 LITRO 6,996,172 1.86 0.925 12,992,941 6,518,683 19.43% 20.04% 30.12% 20.04% Z 11%
1 AGUA PURA BOLSA 1/2 LT. 6,167,517 2.31 1.27 14,251,590 6,418,843 21.32% 19.73% 26.55% 39.77% Z 5%
10 BEBIDA DE NARANJA GALON 402,103 15.07 6.897 6,058,982 3,285,681 9.06% 10.10% 1.73% 29.83% Z 53%
3 BEBIDA NARANJA BOTELLA 0.5 1,723,894 3.38 1.75 5,818,144 2,801,329 8.70% 8.61% 7.42% 18.71% Z 16%
4 BEBIDA NARANJA BOTELLA 250 1,719,998 3.38 1.78 5,804,993 2,743,397 8.68% 8.43% 7.40% 17.05% Z 21%
7 LECHE BOLSA LITRO 1,183,428 3.57 1.787 4,224,395 2,110,200 6.32% 6.49% 5.09% 14.92% Z 37%
14 LECHE GALON ENVASE PLASTICO 185,063 17.69 8.860 3,272,832 1,633,178 4.90% 5.02% 0.80% 11.51% Z 74%
8 QUESO CREMA VASO 4 ONZAS 885,469 2.89 1.384 2,557,125 1,332,078 3.82% 4.10% 3.81% 9.12% Z 42%
15 QUESO SUPER PEQUENO 178,965 11.64 7.173 2,082,859 799,214 3.12% 2.46% 0.77% 6.55% Z 79%
5 CREMA COMERCIAL 1/8 LIBRA 1,271,542 0.72 0.321 916,941 509,412 1.37% 1.57% 5.47% 4.02% Z 26%
9 LECHE CHOCOLATADA 1/4 LITRO 529,753 1.61 0.714 851,525 473,069 1.27% 1.45% 2.28% 3.02% Z 47%
24 CREMA PURA PARA BATIR 61,221 14.81 7.582 906,591 442,441 1.36% 1.36% 0.26% 2.81% Z 126%
22 QUESO CREMA LIBRA A GRANEL 87,076 9.60 4.665 835,666 429,428 1.25% 1.32% 0.37% 2.68% Z 116%
20 BEBIDA DE NARANJA 1/2 GALON 121,420 8.04 4.572 975,852 420,720 1.46% 1.29% 0.52% 2.61% Z 105%
17 LECHE LITRO ENVASE CARTON 164,242 4.39 2.053 721,572 384,449 1.08% 1.18% 0.71% 2.48% Z 89%
13 QUESO CREMA 4 ONZAS(CAJA) 224,225 2.95 1.313 662,316 367,953 0.99% 1.13% 0.97% 2.31% Z 68%
27 QUESO CAPAS 20 ONZAS 34,991 20.32 10.033 711,187 360,113 1.06% 1.11% 0.15% 2.24% Z 142%
26 BEBIDA NARANJA GALON PET 48,877 13.73 7.1 670,830 323,807 1.00% 1.00% 0.21% 2.10% Z 137%
21 AGUA PURA BOT. 600 ML 120,513 6.25 3.78 753,809 298,270 1.13% 0.92% 0.52% 1.91% Z 111%
18 LECHE 1/2 LITRO CARTON 132,778 2.40 1.067 318,619 177,010 0.48% 0.54% 0.57% 1.46% Z 95%
29 CREMA PURA 1/2 LITRO 30,761 10.64 5.731 327,419 151,139 0.49% 0.46% 0.13% 1.01% Z 153%
25 CREMA COMERCIAL LITRO 54,277 5.65 3.512 306,713 116,119 0.46% 0.36% 0.23% 0.82% Z 132%
23 YOGURT DE MANGO 8 ONZAS 66,189 2.92 1.300 193,529 107,516 0.29% 0.33% 0.28% 0.69% Z 121%
11 REFRESCO ROSA JAMAICA 1/4 LT. 259,447 0.58 0.256 149,441 83,023 0.22% 0.26% 1.12% 0.59% Z 58%
16 REFRESCO DE PIÑA 1/4 LITRO 172,675 0.58 0.256 99,461 55,256 0.15% 0.17% 0.74% 0.43% Z 84%
12 REFRESCO DE MANZANA 1/4 LITRO 231,678 0.58 0.356 133,446 50,969 0.20% 0.16% 1.00% 0.33% Z 63%
28 YOGURT DE MORA 8 ONZAS 33,423 2.88 1.380 96,259 50,135 0.14% 0.15% 0.14% 0.31% Z 147%
30 QUESO CREMA 8 ONZAS 15,409 5.69 2.829 87,694 44,096 0.13% 0.14% 0.07% 0.29% Z 158%
19 REFRESCO DE LIMON 1/4 LITRO 126,550 0.58 0.256 72,893 40,496 0.11% 0.12% 0.54% 0.26% Z 100%
TOTALES 23,229,656 66,855,624 32,528,024 100.00% 100.00% 100.00% 100.00%
SEGUIR INSTRUCCIONES DE LAS CELDAS Y LAS SEÑALES ROJAS DE NOTIFICACIÓN
% DE ORDENAR J ORDENAR ORDENAR F
% DE % DE
CxD C x (D-E) G/TOTAL MAYOR A C MAYOR MAYOR A % PRODUCTOS
F/TOTAL F C/TOTAL C
G MENOR A MENOR MENOR
A B C D E F G H I J M P Q R
CANTIDAD
PRECIO DE COSTO DE VENTA MARGEN %
VENDIDAS % VENTA / % UNIDAD / NO
VENTA VENTA TOTAL TOTAL MARGEN / % U/UV DEF/
No. NOMBRE EN EL AÑO, VENTA UNIDADES PRIORIDAD SELECCIONAR
POR POR ANUAL EN ANUAL EN MARGEN ACUMULADO UNIDADES
EN TOTAL TOTAL NO ORDENAR
UNIDAD UNIDAD VALORES VALORES TOTAL
UNIDADES
2 LECHE BOLSA 1/2 LITRO 6,996,172 1.86 0.925 12,992,941 6,518,683 19.43% 20.04% 30.12% 30.12% E 7%
1 AGUA PURA BOLSA 1/2 LT. 6,167,517 2.31 1.27 14,251,590 6,418,843 21.32% 19.73% 26.55% 56.67% F 3%
3 BEBIDA NARANJA BOTELLA 0.5 1,723,894 3.38 1.75 5,818,144 2,801,329 8.70% 8.61% 7.42% 64.09% F 10%
4 BEBIDA NARANJA BOTELLA 250 1,719,998 3.38 1.78 5,804,993 2,743,397 8.68% 8.43% 7.40% 71.49% F 13%
5 CREMA COMERCIAL 1/8 LIBRA 1,271,542 0.72 0.321 916,941 509,412 1.37% 1.57% 5.47% 76.97% F 17%
7 LECHE BOLSA LITRO 1,183,428 3.57 1.787 4,224,395 2,110,200 6.32% 6.49% 5.09% 82.06% F 23%
8 QUESO CREMA VASO 4 ONZAS 885,469 2.89 1.384 2,557,125 1,332,078 3.82% 4.10% 3.81% 85.87% F 27%
9 LECHE CHOCOLATADA 1/4 LITRO 529,753 1.61 0.714 851,525 473,069 1.27% 1.45% 2.28% 88.15% F 30%
10 BEBIDA DE NARANJA GALON 402,103 15.07 6.897 6,058,982 3,285,681 9.06% 10.10% 1.73% 89.88% F 33%
11 REFRESCO ROSA JAMAICA 1/4 LT. 259,447 0.58 0.256 149,441 83,023 0.22% 0.26% 1.12% 91.00% F 37%
12 REFRESCO DE MANZANA 1/4 LITRO 231,678 0.58 0.356 133,446 50,969 0.20% 0.16% 1.00% 92.00% F 40%
13 QUESO CREMA 4 ONZAS(CAJA) 224,225 2.95 1.313 662,316 367,953 0.99% 1.13% 0.97% 92.96% F 43%
14 LECHE GALON ENVASE PLASTICO 185,063 17.69 8.860 3,272,832 1,633,178 4.90% 5.02% 0.80% 93.76% F 47%
15 QUESO SUPER PEQUENO 178,965 11.64 7.173 2,082,859 799,214 3.12% 2.46% 0.77% 94.53% F 50%
16 REFRESCO DE PIÑA 1/4 LITRO 172,675 0.58 0.256 99,461 55,256 0.15% 0.17% 0.74% 95.27% F 53%
17 LECHE LITRO ENVASE CARTON 164,242 4.39 2.053 721,572 384,449 1.08% 1.18% 0.71% 95.98% F 57%
18 LECHE 1/2 LITRO CARTON 132,778 2.40 1.067 318,619 177,010 0.48% 0.54% 0.57% 96.55% F 60%
19 REFRESCO DE LIMON 1/4 LITRO 126,550 0.58 0.256 72,893 40,496 0.11% 0.12% 0.54% 97.10% F 63%
20 BEBIDA DE NARANJA 1/2 GALON 121,420 8.04 4.572 975,852 420,720 1.46% 1.29% 0.52% 97.62% F 67%
21 AGUA PURA BOT. 600 ML 120,513 6.25 3.78 753,809 298,270 1.13% 0.92% 0.52% 98.14% F 70%
22 QUESO CREMA LIBRA A GRANEL 87,076 9.60 4.665 835,666 429,428 1.25% 1.32% 0.37% 98.51% F 73%
23 YOGURT DE MANGO 8 ONZAS 66,189 2.92 1.300 193,529 107,516 0.29% 0.33% 0.28% 98.80% F 77%
24 CREMA PURA PARA BATIR 61,221 14.81 7.582 906,591 442,441 1.36% 1.36% 0.26% 99.06% F 80%
25 CREMA COMERCIAL LITRO 54,277 5.65 3.512 306,713 116,119 0.46% 0.36% 0.23% 99.30% F 83%
26 BEBIDA NARANJA GALON PET 48,877 13.73 7.1 670,830 323,807 1.00% 1.00% 0.21% 99.51% F 87%
27 QUESO CAPAS 20 ONZAS 34,991 20.32 10.033 711,187 360,113 1.06% 1.11% 0.15% 99.66% F 90%
28 YOGURT DE MORA 8 ONZAS 33,423 2.88 1.380 96,259 50,135 0.14% 0.15% 0.14% 99.80% F 93%
29 CREMA PURA 1/2 LITRO 30,761 10.64 5.731 327,419 151,139 0.49% 0.46% 0.13% 99.93% F 97%
30 QUESO CREMA 8 ONZAS 15,409 5.69 2.829 87,694 44,096 0.13% 0.14% 0.07% 100.00% F 100%
TOTALES 23,229,656 66,855,624 32,528,024 100.00% 100.00% 100.00%
