information systems today excel Spreadsheet applications
textbook ISBN # 9780133940305
PG 84 Application Exercise
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:
- 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.
- The TCO for the all knowledge classification in Campus Travel. Hint: Sum all the values for all the classifications coincidently.
- 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