excel
DESCRIPTION
sefsdfTRANSCRIPT
No SKU Number Ukuran Unit24 53104 5018 50206 2504 50091 2506 50102 250
20 50475 12513 50170 10022 51060 1009 50131 1008 50129 250
15 50174 50010 50132 1007 50122 250
19 50472 1003 50084 50
17 50194 10011 50138 10012 50139 5021 50694 10014 50172 10016 50190 251 50071 255 50100 25
25 57134 10023 53006 502 50083 25
diketahuiD 92priceA 66B 60
harga per unit dari supplier A Persediaan yg digunakan/th jumlah66 92 607211 279 306986 28 2408
793 3 2379551 4 2204
8 83 664102 6 612122 5 610177 3 531
62 8 49698 5 490
196 2 392192 2 384
18 14 252122 2 244
26 9 23421 10 21018 10 18044 4 1762 66 132
31 3 9322 4 8816 5 8017 4 6816 4 64
22132
% kumulatif klasifikasi A kalsifikasi B
27.4% 27.4%13.9% 41.3%10.9% 52.1% 0.16 0.3610.7% 62.9%10.0% 72.9% 10.0%3.0% 75.9% 13.0%2.8% 78.6% 15.7%2.8% 81.4% 18.5%2.4% 83.8% 20.9%2.2% 86.0% 23.1%2.2% 88.2% 25.3%1.8% 90.0% 27.1%1.7% 91.7% 28.8%1.1% 92.9% 30.0% 1.1%1.1% 94.0% 31.1% 2.2%1.1% 95.0% 32.1% 3.3%0.9% 96.0% 33.1% 4.2%0.8% 96.8% 33.9% 5.1%0.8% 97.6% 34.7% 5.9%0.6% 98.2% 35.3% 6.5%0.4% 98.6% 35.7% 6.9%0.4% 99.0% 36.1% 7.3%0.4% 99.4% 36.5% 7.6%0.3% 99.7% 36.8% 7.9%0.3% 100.0% 37.1% 8.2%
klasifikasi C EOQ EOA EOB
0.395932865331 1.96287790431561 10.9544511501033
0.48