60.1K

Verified Solution

Link Copied!

Please show all formulas in excel how you get the answer :

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.

data is attached. SHOW FORMULA FOR EXCEL USE ADDITION, PROFESSOR NEED TO SEE WHERE THE ANSWERS CAME FROM

	Main campus	Spokane Campus	TriCities Campus	Walla Station	Prosser Station	TOTAL
Cable trays, racks	12000	12000	6000	2000	2000
Edge servers/VPN	16000	16000	16000	16000	16000
File servers	150000	75000	30000	8000	8000
Mail servers	200000
Personnel	750000	275000	275000	70000
Security/Firewall/Spam	10000	10000	10000	10000	10000
Switches / hubs	40000	25000	20000	5000	5000
UPS	40000	35000	35000	2000	1500
Wiring	18000	6000	20000	500	1000
TOTAL

Answer & Explanation Solved by verified expert

See Answer