PLEASE show formulas used for 4a-4b. Use an Excel worksheet to show your findings.

Northeast Airlines is interested in integrating an ERP software system to streamline processes such as purchasing, sales, human resource management, and customer relationship management. Because of your success in implementing the e-commerce infrastructure, the general manager asks you for advice on what to do to streamline operations at Northeast Airlines. Access the data in the workbook on the worksheet labeled ERP System. The file includes ratings of the different modules of the systems and the weights assigned to these ratings. Module Human Resources Management Supply Chain Management Accounting Analytics Customer Relationship Management Manufacturing Ratings (Out of 10) Weight Vendor A Vendor B Vendor C Vendor D Vendor E Vendor F Vendor G Vendor H 0.3 9 7 4 8 10 6 9 7 0.05 7 6 9 8 9 8 10 10 0.15 8 7 6 9 8 10 10 6 0.15 7 8 10 9 10 8 6 6 0.2 9 10 9 8 8 8 7 7 0.15 7 7 5 8 7 6 10 8 # Item 4a Determine the vendor with the highest overall rating. (SUMPRODUCT and MAX) 4b Prepare 3 graphs to compare the vendors on different dimensions and the overall score. (CHARTS/GRAPHS) 4c Provide insight on your findings and make recommendations