No SKU Number Ukuran Unit harga per unit dari supplier A Persediaan yg digunakan/th24 53104 50 66 9218 50206 250 11 2794 50091 250 86 286 50102 250 793 3

20 50475 125 551 413 50170 100 8 8322 51060 100 102 69 50131 100 122 58 50129 250 177 3

15 50174 500 62 810 50132 100 98 57 50122 250 196 2

19 50472 100 192 23 50084 50 18 14

17 50194 100 122 211 50138 100 26 912 50139 50 21 1021 50694 100 18 1014 50172 100 44 416 50190 25 2 661 50071 25 31 35 50100 25 22 4

25 57134 100 16 523 53006 50 17 42 50083 25 16 4

Tabel 3Data Biaya per supplier dan penggunaan persediaan Form SKU 53104

Penggunaan tahunan harapan

Biaya per unit

Supplier A

Supplier B

Carrying Cost Persediaan

Holding Cost

Biaya Bunga

Ordering Cost Persediaan

Supplier A

Supplier B

Delivery times/lag times

Supplier A

Supplier B

Penggunaan tahunan harapan

Biaya per unit

Supplier A

Supplier B

Carrying Cost Persediaan

Holding Cost

Biaya Bunga

Ordering Cost Persediaan

Supplier A

Supplier B

Delivery times/lag times

Supplier A

Supplier B

persediaan yang digunakan x harga6072 27.4% 27.4%3069 13.9% 41.3%2408 10.9% 52.2%2379 10.7% 62.9%2204 10.0% 72.9% 10.0%664 3.0% 75.9% 13.0%612 2.8% 78.7% 15.7%610 2.8% 81.4% 18.5%531 2.4% 83.8% 20.9%496 2.2% 86.1% 23.1%490 2.2% 88.3% 25.3%392 1.8% 90.0% 27.1%384 1.7% 91.8% 28.8%252 1.1% 92.9% 30.0%244 1.1% 94.0% 31.1% 1.1%234 1.1% 95.1% 32.1% 2.2%210 0.9% 96.0% 33.1% 3.1%180 0.8% 96.8% 33.9% 3.9%176 0.8% 97.6% 34.7% 4.7%132 0.6% 98.2% 35.3% 5.3%93 0.4% 98.6% 35.7% 5.7%88 0.4% 99.0% 36.1% 6.1%80 0.4% 99.4% 36.5% 6.5%68 0.3% 99.7% 36.8% 6.8%64 0.3% 100.0% 37.1% 7.1%

22132

Tabel 3Data Biaya per supplier dan penggunaan persediaan Form SKU 53104

92 92

$66 66 #VALUE!$60 66

#VALUE!

$17,10 17,10

6,60% 6,60

$50 50

$75 50

1 day 1 day

3 day 3 day

92

6660 15.44713

19.01671

17.1 15.447134495 EOQ0.066 19.016708972

5075

13

TC=PD+DQO+(HQ+ IP

Q2 )

TC=PD+DQO+(HQ+ IP

Q2 )