Automation testing ROI estimation tool

dzmitry yashyn
2 min readJul 31, 2020

--

In this article I’ve described the approach that will help you to estimate very quick return of investment period for automating functional testing scope and how it can accelerate time-to-market based on statistical data of your project. The data and charts are interactive (in order to use the file, please, make a copy of the document below: follow the link -> File-> make a copy).

https://docs.google.com/spreadsheets/d/1ju1j_IWQpr4Nv8Irl0ozwixGPFqqavr5f9jx3pTJ1oY/edit#gid=1597151519

Main assumptions:

  • Support time depends on autotests number
  • All planned number of tests will be automated during the 1st month
  • Time for environment set-up is not taken into account
  • The calculation are made in hours only, not in money

How to use the document:

You need to set the following input data in the highlighted cells, all calculations will be performed automatically:

  • Number of test-cases that you plan to automate
  • Tests runs (cycles) per month: i.e. how many times the functionality will be delivered to testing environment in order to perform further automated testing. This delivery times limits the number of automated test-runs that can be considered as effective (you cannot run autotests 10 times after 1 delivery of functionality (build) to the testing environment and consider all these 10 runs as effective, only 1 does count in this case).
  • 1 manual test-case run time: i.e. how much time does it take for manual functional tester to perform test-case testing manually
  • 1 test-case automation time: i.e. how much time does it take for automation tester to develop
  • Autotests run and support

--

--