Calculating an ROI for a specific improvement initiative
Here is something that is rarely done effectively in preparing for traditional ERP – an Everything Replacement Project: our management team at the example company (see prior posts) now has everything it needs to calculate ROI for the specific warehouse and pick-ship initiative they have under consideration. Here is the formula they will apply:
ROI = (delta-T – delta-OE)/delta-I
Where T = Throughput
OE = Operating Expenses
I = Investment
Substituting into this formula the numbers calculate by the team (see prior post), we get:
ROI = $0 – (-$168,942)/$75,000 = 225.3% in the first year
"But," you say, "this company will not experience the full $168,942 in savings in the first year!" And, of course, you are correct. The management team recognizes this also. So, they quickly do some "napkin" calculations and estimate that, as revenues grow, they may reap about 40% of the calculated annual savings through deferred hiring of additional FTEs (full-time equivalents) in the first 12 months following the implementation. This means our first-year calculations need to be adjusted as follows:
ROI (first year) = (0.4 * $168,942)/$75,000 = 90.1% ROI in the first year
What these calculations tell the management team is this: "If we invest up to $75,000 in an initiative to improve processes highlighted by our Current Reality Tree (CRT) (see prior posts) in the areas of bar code printing, ASN (advanced shipping notice) processing, and picking-shipping operations; and our Throughput continues to grow; then we ought to see about 90% of the money invested in this initiative returned in savings to the organization within the first 12 months following deployment." (Note: The real firm upon which this scenario is predicated had been experiencing double-digit growth in sales for more than five consecutive years when I was introduced to them.)
This also tells the team that, in subsequent full years, since no additional investment is required (unless they should wish to capitalize some portion of the software maintenance), the company should continue to reap about $169,000 in annual savings as a reward for this effort. (Note: If anyone wishes to extrapolate further from these figures, it would be possible to calculate the Net Present Value [NPV] of the series of estimated cash flows resulting from this or any other particular Extended Readiness for Profit – the New ERP – initiative. While this is not generally required for initial decision-making, the true value of the initiative – and, indeed, the value of the firm as a whole – is best represented by the NPV of "the system.")
[To be continued]
