textbook ISBN # 9780133940305
PG 84 Application Exercise
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 the 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 in Campus Travel. Hint: Sum all the values for all the systems together.
- The TCO for servers and network components of the information system.
excel sheet attached. SHOW FORMULA FOR EXCEL USE ADDITION, PROFESSOR NEED TO SEE WHERE THE ANSWERS CAME FROM