Homework Help.

How do I solve these questions step by step?

How can I solve them using excel spreadsheet?

1. Graph the supply chain structure of Kerneos SA.
2. Describe and graph the purchasing process at Kerneos, Inc.
3. Of the three vendors that Kerneos, Inc. currently uses, which vendor performed best? Which vendor should be replaced? Your recommendation should be supported by the average score, the weighted score, and the total weighted score of each vendor.
4. Are there any additional measures that you think should be considered in the decision process to keep or replace the current three vendors (other than the current scoring items)? Your suggestion(s) should be based on (a) the nature of the product, (b) the market and the supply chain structure of Kerneos, Inc., and (c) the supplier-buyer relationship management involved in supply chains.

Thank you