Create a spreadsheet using the data provided

Application Exercises Note: The existing data files referenced in these exercises are available on the book'swebsite: www.pearsonhighered.comivalcih. Spreadsheet Application: Valuing Information Systems 2-36. The cost of maintaining information systems is high for Campus Travel. You have been assigned to evaluate the total cost of ownership (TCO) of a few systems that are currently in use by Campus Travel employees. Take a look at the TCO.csv file to obtain the list of systems that are in use and the costs associated with maintaining the software, hardware, and the associated personnel for each type of system. Calculate the following for your operations manager: The costs for server hardware by adding a new row to include web servers. This includes US$4,500 for the main campus and US$2,200 for the other campuses. The TCO for the entire information system used at Campus Travel. Hint: Sum all the values for all the systems together The TCO for servers and network components of the information system Make sure that you format the table, including using the currency format, in a professional manner Main camp Spokane C TriCities Walla Stati Prosser Sti TOTAL Cable trays 12000 12000 6000 2000 2000 Edge serv 16000 16000 16000 16000 16000 File server 150000 75000 30000 8000 8000 Mail server 200000 Personnel 750000 275000 275000 70000 Security/F 10000 10000 10000 10000 10000 Switches / 40000 25000 20000 5000 5000 UPS 40000 35000 35000 2000 1500 Wiring 18000 6000 20000 500 1000 TOTAL