Module $7$: Spreadsheet Application: Choosing an ERP System at Campus Travel

Campus Travel is interested in integrating its business processes 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 Campus Travel.

Use the data provided in this spreadsheet to make a recommendation about which system to purchase. This file includes ratings of the different modules of the systems and the weights assigned to these ratings.

Update this spreadsheet to include the following:

Update the Overall Rating row $($row $9)$ to show the overall rating of each vendor. You should calculate the overall rating by adding together each rating for the module and multiplying that total by the weight shown in Column B$.$

Insert a bar graph in the gray area beginning in cell A$13$ comparing the overall rating for each module. Name this bar graph "Ratings$\_$By$\_$Vendor" and format it professionally.

In cell K$2,$ type the name of the vendor with the highest overall rating

In cell K$3,$ type the name of the vendor with the lowest overall rating