Information systems today excel spreadsheet applications

textbook ISBN # 9780133940305 

PG 84  Application Exercise 

problem #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:

  1. 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.
  2. The TCO for the entire information system in Campus Travel. Hint: Sum all the values for all the systems together.
  3. 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

Thank you for your help

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply