Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all formulas in excel how you get the answer : the cost of maintaining information systems is high for Campus Travel. You have

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What was the positive value of Max Weber's model of "bureaucracy?"

Answered: 1 week ago