Copy of Module 7_ERP Systems

Ratings (Out of 10) Module Weight Vendor A Vendor B Vendor C Vendor D Vendor E Human Resources Management 0.2 9 7 10 8 10 Supply Chain Management 0.1 7 7 9 8 9 Purchasing 0.15 8 8 10 9 8 Supply Chain Management 0.2 7 7 10 9 10 Customer Relationship Management 0.2 9 7 9 8 8 Financials 0.15 7 9 5 8 7 Overall Ratings Per Product (Column Chart) 1 2 3 4 5 0 1 2 3 4 5 6 7 8 9 10 Ratings_By_Product

Overall Rating 3) Module with Highest Overall Rating Human Resources Management 8.8 4) Module with Lowest Overall Rating Supply Chain Management 4 6.45 8.6 8.2 5.4 Module 7: Spreadsheet Application: Choosing an ERP System at Campus Tra Campus Travel is interested in integrating its business processes to streamline pro purchasing, sales, human resource management, and customer relationship mana your success in implementing the e-commerce infrastructure, the general manager on what to do to streamline operations at Campus Travel. Use the data provided in this spreadsheet to make a recommendation about which This file includes ratings of the different modules of the systems and the weights a ratings. Update this spreadsheet to include the following: 1) Update the Overall Rating column (column H) to show the overall rating of ea You should calculate the overall rating by adding together each rating for the and multiplying that total by the weight shown in Column B. 2) Insert a bar graph in the gray area beginning in cell A13 comparing the overa each module. Name this bar graph "Ratings_By_Product" and format it profe 3) In cell K2, type the name of the module with the highest overall rating 4) In cell K3, type the name of the module with the lowest overall rating 6

81007