Prepare the answers for the following questions. For graphs and calculations you can use any platform of your choice. Submit your answers in a word file by the deadline (specified above). QUESTIONS: 1. The values below belongs to the annual report of a small size manufacturer which produces machine parts for food packaging industry. Calculate the inventory management metrics (assets committed to Inventory, inventory turnover, weeks of supply ) for the following firm. (30 pts) Cost of goods sold 23,1 Mil.TL Inventory Raw material inventory 1,5 Mil.TL Work-in-process inventory 0,25 MilTL Finished goods inventory 0,75 Mil. TL Total average inventory investment Total worth of assets 2,5 Mil. TL 14,7 Mil. TL 2. Compare the performance of following two suppliers based on the SCOR model we covered in the class in terms of reliability, responsiveness and cost. (30 pts) Supplier1 Supplier2 Supplier3 Total perfect orders fulfilled 19 13 17 Sum of actual cycle times for all orders delivered 1 days 1,5 days 2 days Total number of orders 25 15 17 Total number of orders delivered 21 14 17 Unit Cost to plan and source 20 TL 20TL 19TL Unit Cost to deliver 5TL STL 5,2TL Unit Cost to return 4TL 4TL 4TL Monthly values of some metrics (obtained by averaging the values for last three months) 3. List at least three differences for adversary and partner type of relationship between supplier(s) and the sourcing department. (10 pts) 4. Draw the scatter plot for the trade-off data below. The first column represents the total weekly inventory cost for a certain product while the second column represents the corresponding total weekly transportation plus ordering cost that is spent in order to ship from the supplier. Mark the Pareto points in this list to form the Pareto front (30 pts) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Weekly Weekly Inventory Transportation Cost Cost 1500 250 1427 397 1369 570 1287 561 1140 647 1016 789 981 913 857 1061 716 1209 642 1413 524 1396 490 1409 364 1592 354 1572 282 1630 398 1755 148 1793