Information Systems Today (8th Edition)

Chapter 9, Problem 34AE

Having problem solving this question. Please help with Excel.

Spreadsheet Application: Outsourcing Information Systems at Campus Travel

1. 9-34. Campus Travel wants to increase its customer focus and wants to be able to better serve its most valued customers. Many members of the frequent-flier program have requested the ability to check on the status of their membership online; furthermore, the frequent fliers would welcome the opportunity to book reward flights online. As you know that there are a number of companies specializing in building such transactional systems, you have decided to outsource the development of such a system. The following weights are assigned to evaluate the different vendors systems:

   • Online booking capability: 20 percent

   • User friendliness: 25 percent

   • Maximum number of concurrent users: 20 percent

   • Integration with current systems: 10 percent

   • Vendor support: 10 percent

   • Price: 15 percent

   To evaluate the different offers, you need to calculate a weighted score for each vendor using the data provided in the Outsourcing.csv spreadsheet. To calculate the total points for each vendor, do the following:

   • Open the file Outsourcing.csv.

   • Use the SUMPRODUCT formula to multiply each vendors scores with the respective weights and add the weighted scores.

   • Use conditional formatting to highlight all vendors falling below a total of 60 percent and above a total of 85 percent to facilitate the vendor selection.