PRACTICAL TOOL

ROI worksheet: model the economics of one process

MIT examined 300 enterprise AI deployments: 95% of pilots produced no measurable impact on profit. The difference between them and the 6% that did create material value was not the model — it was what they measured. This file models one specific process, before and after.

The calculation stays open

This is not a teaser or a result hidden behind registration. It is the calculation itself, using the example data. For a records process with 300 operations per month, the model uses 30 → 6 minutes, 6 → 2 manual touches, errors at 12% → 4%, overdue work at 18% → 6%, and a 50% time-reuse factor.

Records office, 300 operations per month — four measurable levers
LeverBefore, KZT/yearAfter, KZT/yearImpact, KZT/year
Process time2,250,000450,0001,800,000
Manual touches900,000300,000600,000
Errors and rework1,728,000576,0001,152,000
Overdue work5,184,0001,728,0003,456,000
Total annual impact10,062,0003,054,0007,008,000
First-year ownership cost2,319,300
Net first-year impact4,688,700
Payback4.0 months

The fifth lever — manageability — is deliberately excluded from the sum. There is no honest universal formula for turning decision quality into cash.

Download the file (.xlsx, 15 KB)

Get the working ROI file

Enter your email. We will send a one-time link valid for seven days; no attachments.

What the file looks like

ROI worksheet inputs: the process before and after an AI agent
The “Process data” sheet: 15 inputs you fill in
ROI worksheet result: KZT 7,008,000 impact, KZT 4,688,700 net impact and 4.0-month payback
The “Calculation” sheet: impact, ownership cost and payback
Five impact levers: time, errors, SLA, operation cycle and manageability
The “Five levers” sheet: where the impact comes from

The five impact levers

  • Process time. Employee hours released from the operation. They turn into money through the hourly cost — and only with the time-reuse factor applied: released hours only become money when the business puts them to productive use.
  • Manual touches. Handoffs between people. Every touch is a queue, a context switch and a point of loss.
  • Errors and rework. The cost of redoing work: every error sends the task back and consumes time on both sides.
  • Overdue work. The cost of a missed deadline — penalties, escalations and lost enquiries.
  • Manageability. The fifth lever improves decision quality rather than producing a simple saving, which is why it is explained separately and excluded from the sum.