how do you calculate the supplier performance index

1 Managing supplies Answer 3.1 4 For doing comparison we will have to Remove the cast for each suppliers and check which is more suitable 5 6 1 Remove peractivity cast for eact activity 7 8 Activity Total Cost No Of activities Per Activity cost Place purchase order $ 25,000.00 100 IS 250.00 10 Receive and inspect $ 84,000.00 400 $ 210.00 11 store iventory S 8,000.00 200 $ 40.00 12 Rework Product $ 25,000.00 500 S 50.00 13 production down time S 5,000.00 100 S 50.00 14 Receive and inspect late S 17,500.00 50 $ 350.00 25 16 2 Remove cost for each supplies 17 18 Activity Per Activity cost Safeplus Itd Brushfinish itd 19 activity activity cost activity 20 Place purchase order S 250.00 20 S 5,000.00 21 Receive and inspect S 210.00 200S 42,000.00 22 store iventory $ 40.00 70 $ 2.800.00 23 Rework Product S 50.00 200 $ 10,000.00 S 50.00 48 S 24 production down time 2.400.00 350.00 S 40 S 14,000.00 25 Receive and inspect late 70,200.00 26 Total activity Cost 7420 30000 $ 216,000.00 27. ADD:Handling cost(Purchas $ 2000.00 28 Total cost 29 10 SO 16 10 activity cost S 2.500.00 S 10,500.00 S 640.00 500,00 $ 200.00 S 1.250.00 S 15. 5000 S 34,000.00 S 50,000.00 4 5 6.8 30 1 Managing supplies Answer 3.1 4 For doing comparison we will have to Remove the cast for each suppliers and check which is more suitable 5 6 1 Remove peractivity cast for eact activity 7 8 Activity Total Cost No Of activities Per Activity cost Place purchase order $ 25,000.00 100 IS 250.00 10 Receive and inspect $ 84,000.00 400 $ 210.00 11 store iventory S 8,000.00 200 $ 40.00 12 Rework Product $ 25,000.00 500 S 50.00 13 production down time S 5,000.00 100 S 50.00 14 Receive and inspect late S 17,500.00 50 $ 350.00 25 16 2 Remove cost for each supplies 17 18 Activity Per Activity cost Safeplus Itd Brushfinish itd 19 activity activity cost activity 20 Place purchase order S 250.00 20 S 5,000.00 21 Receive and inspect S 210.00 200S 42,000.00 22 store iventory $ 40.00 70 $ 2.800.00 23 Rework Product S 50.00 200 $ 10,000.00 S 50.00 48 S 24 production down time 2.400.00 350.00 S 40 S 14,000.00 25 Receive and inspect late 70,200.00 26 Total activity Cost 7420 30000 $ 216,000.00 27. ADD:Handling cost(Purchas $ 2000.00 28 Total cost 29 10 SO 16 10 activity cost S 2.500.00 S 10,500.00 S 640.00 500,00 $ 200.00 S 1.250.00 S 15. 5000 S 34,000.00 S 50,000.00 4 5 6.8 30