information systems today excel Spreadsheet applications


 

textbook ISBN # 9780133940305 

PG 84  Application Exercise 

problem #2-36

the require of maintaining knowledge classifications is violent for Campus Travel. You entertain been assigned to evaluate the aggregate require of holding (TCO) of a few classifications that are currently in use by Campus Travel employees.  Take a behold at the TCO.csv rasp to conquer the roll of classifications that are in use and the requires associated after a while maintaining the software, hardware, and the associated personnel for each cast of classification. Calculate the subjoined for your operations manager:

  1. The requires for server hardware by adding a new row to the understand Web servers. This understands US$4,500 for the main campus and US$2,200 for the other campuses.
  2. The TCO for the all knowledge classification in Campus Travel. Hint: Sum all the values for all the classifications coincidently.
  3. The TCO for servers and network components of the knowledge classification.

excel subterfuge fixed.    SHOW  FORMULA FOR EXCEL USE ADDITION, PROFESSOR NEED TO SEE WHERE THE ANSWERS CAME FROM