Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Working File

    Uploaded by

    vianputra405

    Copyright:

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

    Working File

    Uploaded by

    vianputra405
    16 views2 pages

    Original Title

    working file

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Working File

    Uploaded by

    vianputra405

    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 2

    ABC Analysis

    C4*D4 E4/$E$19

    No. Nama Item Jumlah Harga Total Value


    Presentase (%)
    1 Belt 008 1 100,000,000 100,000,000 31.39%
    2 sensor ABCD 2 50,000,000 100,000,000 31.39%
    3 Motor + Gerbox 2 27,000,000 54,000,000 16.95%
    4 Bearing BB 20 1,300,000 26,000,000 8.16%
    5 Bearing AA 10 2,000,000 20,000,000 6.28%
    6 Pulley 50 150,000 7,500,000 2.35%
    7 cat 50 100,000 5,000,000 1.57%
    8 Thiner 50 50,000 2,500,000 0.78%
    9 Lampu 30 60,000 1,800,000 0.57%
    10 Batu Gerinda 400 3,000 1,200,000 0.38%
    11 Kunci Pas 10 20,000 200,000 0.06%
    12 Kaos Tangan 480 250 120,000 0.04%
    13 Baut 500 200 100,000 0.03%
    14 Kuas 30 2,500 75,000 0.02%
    15 Mur 500 100 50,000 0.02%
    318,545,000 100.0%
    4

    Kategori Jumlah Item Value


    80% A 3.00 254,000,000.00
    15% B 2.00 46,000,000.00
    5% C 10.00 18,545,000.00
    318,545,000.00
    G4+F5
    Presentase
    Cummulatif
    (%)
    31.39% A
    62.79% A
    79.74% A
    87.90% B
    94.18% B
    96.53% C
    98.10% C
    98.89% C
    99.45% C
    99.83% C
    99.89% C
    99.93% C
    99.96% C
    99.98% C
    100.00% C

    79.7%
    14.4%
    5.8%

    You might also like