Answer to Question #310574 in Excel for Geoffroy yawogan

Question

Choose one device that you own and use - a laptop, tablet or smartphone.

Calculate the total costs of ownership (TCO) for the selected device including:

Purchasing costs of hardware

Purchasing costs or software subscription fee

Operating costs (hours spent on managing IT, e.g. upgrades, fixes, troubleshooting, searching for new software, learning with new programs, providing IT support to others)

Downtime costs (lost hours due to inoperable or inaccessible computer, internet connection, viruses, etc.)

When convering amount of time to money, consider average hourly gross wage 200 CZK (around 7 EUR).

Calculate overall TCO and annual TCO.

Answer 1

The answer to your question is provided in the image: