Based upon the figures provided in the excel document, develop a pareto analysis per category then build a Kraljic matrix and position helmet and clothing category
A B D E F G H J 1 Supplier supplier's location frequency of orders type of agreement duration of relationship 15 years 20 5 2 Product Category 2 3 snap hook accessories 4 clothing 5 clothing 6 cycle accessories 7 bike 8 helmet 9 trekking pole 10 camping accessories 11 magnesia 12 climbing shoes 13 helmet 14 winch 15 climbing rope 16 climbing rope 17 bike trailer 18 snap hook accessories 19 clothing 20 camping accessories 21 bike trailer 22 23 24 Alpha Beta Charlie Delta Echo Fox trot Golf Hotel Indian Juliet Kilo Lima Mike November Oscar Papa Quebec Romeo Sierra manufacturer's location Italy Germany Allemagne UK China China Austria Germany Spain Poland Austria Sweden China Germany USA USA Austria Germany Germany Italy Germany Allemagne UK UK Germany Austria Germany Spain Poland Austria Sweden UK Germany USA USA Austria Germany Germany cost of purchases 2017 132 317 420 000 1 027 000 53 506 83 189 92 232 82 379 25 606 15468 41 854 202 845 53 790 38 345 191 272 47 550 >10 >10 >10 cost of purchases 2018 95 299 530 000 1 286 000 141 980 76 304 38 656 84 482 25 140 12 320 13 412 90 290 197 774 26 395 172 094 29 453 6 084 181 345 12 360 cost of purchases 2019 77 394 550 000 1 803 023 135 526 76 324 42 880 85 766 25 451 12 125 22 383 130 093 234 889 47 131 134 313 59 843 15618 180 567 12 598 46 605 15 days 15 days 15 days monthly 3-4 containers /year 3-4 containers /year monthly trimester semester semester monthly monthly monthly 15 days semester semester 15 days monthly semester Distribution F/Belg Agent F Agent F Distribution F Distribution F Distribution F Distribution F/Belg Distribution F Distribution F/Belg Distribution F/Belg Distribution F Distribution F Distribution F agent distribution Europe Distribution Distribution F Distribution F Distribution F 6 3 6 8 15 2 109 974 14 047 2 2,5 >10 1 2631 374 3 019 388 3 692 529 A B D E F G H J 1 Supplier supplier's location frequency of orders type of agreement duration of relationship 15 years 20 5 2 Product Category 2 3 snap hook accessories 4 clothing 5 clothing 6 cycle accessories 7 bike 8 helmet 9 trekking pole 10 camping accessories 11 magnesia 12 climbing shoes 13 helmet 14 winch 15 climbing rope 16 climbing rope 17 bike trailer 18 snap hook accessories 19 clothing 20 camping accessories 21 bike trailer 22 23 24 Alpha Beta Charlie Delta Echo Fox trot Golf Hotel Indian Juliet Kilo Lima Mike November Oscar Papa Quebec Romeo Sierra manufacturer's location Italy Germany Allemagne UK China China Austria Germany Spain Poland Austria Sweden China Germany USA USA Austria Germany Germany Italy Germany Allemagne UK UK Germany Austria Germany Spain Poland Austria Sweden UK Germany USA USA Austria Germany Germany cost of purchases 2017 132 317 420 000 1 027 000 53 506 83 189 92 232 82 379 25 606 15468 41 854 202 845 53 790 38 345 191 272 47 550 >10 >10 >10 cost of purchases 2018 95 299 530 000 1 286 000 141 980 76 304 38 656 84 482 25 140 12 320 13 412 90 290 197 774 26 395 172 094 29 453 6 084 181 345 12 360 cost of purchases 2019 77 394 550 000 1 803 023 135 526 76 324 42 880 85 766 25 451 12 125 22 383 130 093 234 889 47 131 134 313 59 843 15618 180 567 12 598 46 605 15 days 15 days 15 days monthly 3-4 containers /year 3-4 containers /year monthly trimester semester semester monthly monthly monthly 15 days semester semester 15 days monthly semester Distribution F/Belg Agent F Agent F Distribution F Distribution F Distribution F Distribution F/Belg Distribution F Distribution F/Belg Distribution F/Belg Distribution F Distribution F Distribution F agent distribution Europe Distribution Distribution F Distribution F Distribution F 6 3 6 8 15 2 109 974 14 047 2 2,5 >10 1 2631 374 3 019 388 3 692 529
