Meme 384 CHAPTER 9 DEVELOPING AND ACQUIRING INFORMATION SYSTEMS Application Exercises Note: The existing data files referenced in these exercises are available on the book's website: www.pearsonhighered.com/valacich. Spreadsheet Application: Outsourcing Informa- tion Systems at Campus Travel 9- I 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 pro- gram 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 develop- ment 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 pro- vided 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 vendor's 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, Team Work Exercise Net Stats: Moore's Law and the Laggards In th more Meme 384 CHAPTER 9 DEVELOPING AND ACQUIRING INFORMATION SYSTEMS Application Exercises Note: The existing data files referenced in these exercises are available on the book's website: www.pearsonhighered.com/valacich. Spreadsheet Application: Outsourcing Informa- tion Systems at Campus Travel 9- I 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 pro- gram 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 develop- ment 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 pro- vided 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 vendor's 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, Team Work Exercise Net Stats: Moore's Law and the Laggards In th more