Below is an example of different suppliers, you need to perform the following: Q1: Create a basic KPI Dashboard in Excel sheet such as the example below? Q2: Determine the KPIs for the below suppliers? Q3: Classify each KPIs into Acceptable (Green), Investigate (Yellow) and Unacceptable (red)? Q4: Choose what is the best KPI and mention the reason for your choice? Q5: Paste a screenshot of your work in the report? B D E F Key performance indicators (KPIs %) Quality Resources Efficiency Reliability A 1 2 Time Cost 3 Supplier 1 75 67 70 90 72 4 Supplier 2 80 75 85 90 92 5 Supplier 3 90 80 95 88 85 6 Supplier 4 90 95 95 85 82 7 Supplier 5 95 90 98 94 90 36688 80 80 90 90 95 KPI Dashboard example