Developing and Acquiring Information Systems

Spreadsheet Application: Outsourcing Information Systems at Campus Travel

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.

- Set the print areas to only the calculated items. Format the printout in landscape orientation.

- Place the course name, your name, and the current date in the header.

- Print the spreadsheet as a PDF file. Submit a PDF file of the XLS spreadsheet with the formulas showing and without the formula showing.