Scribd Logo
Upload

Welcome to Scribd!

  • 41 views

    Codigo Descripción Precio Unitario Demanda Anual Valor Anual de Ventas

    Uploaded by

    edwin rivera
    The document shows sales data for various office supply products including code, description, unit price, annual demand, and annual sales value. It then provides charts analyzing the sales data. The first chart shows that the top 3 products by annual sales value (CANUTILLO PLASTICO, POST-IT blocks, and LYRECO blocks) make up 74% of total annual sales value. The Pareto chart displays that the top 6 products represent over 80% of total annual sales value, following the 80/20 rule. Finally, a pie chart breaks down total annual sales value by top products, with the top product representing 60% of sales and the top 3 representing over 90% of sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Codigo Descripción Precio Unitario Demanda Anual Valor Anual de Ventas

    Uploaded by

    edwin rivera
    41 views6 pages
    The document shows sales data for various office supply products including code, description, unit price, annual demand, and annual sales value. It then provides charts analyzing the sales data. The first chart shows that the top 3 products by annual sales value (CANUTILLO PLASTICO, POST-IT blocks, and LYRECO blocks) make up 74% of total annual sales value. The Pareto chart displays that the top 6 products represent over 80% of total annual sales value, following the 80/20 rule. Finally, a pie chart breaks down total annual sales value by top products, with the top product representing 60% of sales and the top 3 representing over 90% of sales.

    Original Title

    Libro2.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows sales data for various office supply products including code, description, unit price, annual demand, and annual sales value. It then provides charts analyzing the sales data. The first chart shows that the top 3 products by annual sales value (CANUTILLO PLASTICO, POST-IT blocks, and LYRECO blocks) make up 74% of total annual sales value. The Pareto chart displays that the top 6 products represent over 80% of total annual sales value, following the 80/20 rule. Finally, a pie chart breaks down total annual sales value by top products, with the top product representing 60% of sales and the top 3 representing over 90% of sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    41 views6 pages

    Codigo Descripción Precio Unitario Demanda Anual Valor Anual de Ventas

    Uploaded by

    edwin rivera
    The document shows sales data for various office supply products including code, description, unit price, annual demand, and annual sales value. It then provides charts analyzing the sales data. The first chart shows that the top 3 products by annual sales value (CANUTILLO PLASTICO, POST-IT blocks, and LYRECO blocks) make up 74% of total annual sales value. The Pareto chart displays that the top 6 products represent over 80% of total annual sales value, following the 80/20 rule. Finally, a pie chart breaks down total annual sales value by top products, with the top product representing 60% of sales and the top 3 representing over 90% of sales.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 6

    Precio Demanda Valor anual

    Codigo Descripción unitario anual de ventas

    105183 PK100 CANUTILLO PLASTICO Ø 20MM NGO 119 17,663 2,101,897


    106164 BLOC 100H POST-IT 76X127 AMARILLO 655 * 112 13,399 1,500,688
    105308 BLOC LYRECO A6 100H CUAD.5 GRAPADO 101 14,108 1,424,908
    106368 LYRECO CUBO 400H. 76X76 92 14,738 1,355,896
    106186 12 BLOC 100H POST-IT 38X51 AMARILLO 653 103 11,243 1,158,029
    105605 BLOC LYRECO A4 100H CUAD.5 MICROPF 81 12,830 1,039,230
    105296 TONER LSR HP 4000 NGO C4127X EP52 94 10,325 970,550
    105194 PK100 CUB PVC A4 200 GR LYRECO TRSP 84 8,340 700,560
    107509 PK1625 ETQ INK 38,1X21,2 AVERY J8651-25 56 11,714 655,984
    105228 TONER LSR HP 4000 NGO C4127A 44 14,905 655,820
    Total 11,563,562

    100% Diagr

    90%

    80%

    70%

    60%
    55%

    50%

    43%
    40%

    2,101,897
    30% 31%
    1,500,688 1,424,908 1,355,896
    1,158,0

    20% 74%
    18%
    20% 6%
    10%

    0%
    0%
    Participación % Clase % Clase % Cantidad
    acomulada Acomulado
    2,101,897 18% A A 0-80% 6
    3,602,585 31% A B 81%-95% 3
    5,027,493 43% A C 96%-100% 1
    74%
    6,383,389 55% A Total 10
    7,541,418 65% A
    8,580,648 74% A
    9,551,198 83% B
    10,251,758 89% B 20%
    10,907,742 94% B
    11,563,562 100% C 6%
    100%

    Diagrama de Pareto 100% 11,563,562

    94%

    89%
    9,563,562
    83%

    74%
    7,563,562

    65%

    5,563,562
    55%

    Porcecentage
    43% 3,563,562

    1,424,908 1,355,896 1,563,562


    1,158,029 1,039,230 970,550
    700,560 655,984 655,820
    % 6%
    -436,438

    -2,436,438

    Axis Title
    -2,436,438

    Axis Title
    %
    Participación %
    Ventas Ventas

    60% 8,580,648 74%


    30% 2,327,094 20%
    10% 655,820 6%
    100% 11,563,562 100%

    1,563,562

    563,562

    563,562

    563,562
    Porcecentage

    563,562

    563,562

    436,438

    2,436,438
    2,436,438

    You might also like