excel

5
No SKU Number Ukuran Unit 24 53104 50 18 50206 250 4 50091 250 6 50102 250 20 50475 125 13 50170 100 22 51060 100 9 50131 100 8 50129 250 15 50174 500 10 50132 100 7 50122 250 19 50472 100 3 50084 50 17 50194 100 11 50138 100 12 50139 50 21 50694 100 14 50172 100 16 50190 25 1 50071 25 5 50100 25 25 57134 100 23 53006 50 2 50083 25 diketahui D 92 price A 66 B 60

Upload: rheza-tuszakka

Post on 03-Feb-2016

218 views

Category:

Documents


0 download

DESCRIPTION

sefsdf

TRANSCRIPT

Page 1: Excel

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

Page 2: Excel

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

Page 3: Excel

% 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%

Page 4: Excel

klasifikasi C EOQ EOA EOB

0.395932865331 1.96287790431561 10.9544511501033

0.48