Measuring AI ROI: A Worked Example and Worksheet

Hours saved are not value until they are redeployed. A copyable worksheet with illustrative numbers in Jordanian dinars, from baseline to payback.

Measuring AI ROI: A Worked Example and Worksheet

The finance director puts the renewal invoice on the table: "We paid for 40 AI licences last year. Show me what we got back, in dinars, or we cancel." If you are measuring AI ROI for that meeting, a count of hours saved will not be enough. Saved time becomes value only when the hours go somewhere the business can see: less overtime, a cleared backlog, more cases closed by the same team. Below is a worksheet you can copy, a worked example with illustrative numbers in Jordanian dinars (JOD), and the rule we recommend for every figure in it: say whether it was measured, estimated or assumed.

Why "we saved 2,000 hours" does not answer the finance director

Hours saved say people finished tasks faster, not what happened next. If a claims handler finishes each letter 9 minutes sooner and spends the time on email, the organisation pays for the licence and books nothing.

The UK Treasury's guidance on appraising spending, the Green Book (2026 edition, updated 5 February 2026), draws a line any finance director will recognise. It defines a cash-releasing benefit as one that affects the income or spending of a public body, with efficiency savings that reduce labour costs as the example, and it separates these from benefits that are real but release no cash. The same split works for a company in Amman or Dubai.

So when measuring AI ROI, we recommend two lines in every report: cash value, which goes into the payback calculation, and capacity value, which you report and track but leave out of payback. The trade-off: this understates the return early, and a sound project can look weak at its first review. We accept that, because a finance director who finds one inflated number stops trusting the rest.

Measuring AI ROI starts before the licences arrive

A baseline is a measurement of how the work runs today, taken before the change. Without it, every later figure is a guess. The Green Book asks for a "business as usual" option in every appraisal: the outcome expected if current arrangements continue, used as the benchmark for every other option. For an AI rollout, business as usual is the same team doing the same work without the tool.

For each workflow you plan to measure, record four things over two to four weeks:

  • Volume: items per month (files, tickets, reports), taken from the system of record, not from memory.
  • Time per item: timed on a sample of real items by the people who do the work. A sample of 30 to 60 items per workflow is a practical start; write down how you picked them.
  • Quality: the error or rework rate, from a log that already exists (returned letters, reopened tickets, audit findings).
  • Where extra hours go today: overtime, temporary staff, outsourced work or a growing backlog. This is the line that later turns time into cash.

If the licences are already live, time the same work in a group without the tool, or rebuild the baseline from system timestamps for the months before rollout, and label it estimated. Our article on the AI readiness assessment explains how to choose which workflows deserve this effort first.

The worksheet, filled in for a claims team (illustrative)

Illustrative example: a mid-sized insurer in Amman gives an AI assistant to a claims team of 12. The assistant summarises each claim file and drafts the letter to the customer; a handler checks and sends every letter. All numbers are invented. The label column shows how each figure would be obtained in a real worksheet; the hourly costs (JOD 7 loaded cost, JOD 8.75 for an overtime hour) are assumptions.

Sixteen lines, from baseline to payback

LineFigureLabelSource or calculation
1. Baseline volume1,100 files a monthMeasured3-month average from the claims system
2. Baseline time per file30 minutesMeasuredTimed sample of 60 files before rollout
3. Time per file with AI, including the handler's check21 minutesMeasuredTimed sample of 60 files after 6 weeks of use
4. Gross time saved165 hours a monthCalculated1,100 files x 9 minutes
5. Added review: team lead spot-checks 1 file in 10About 9 hours a monthEstimated110 files x 5 minutes
6. Net hours released156 hours a monthCalculatedLine 4 minus line 5
7. Redeployed: overtime no longer worked80 hours a monthMeasuredPayroll overtime, before and after, same volume
8. Redeployed: old claims backlog60 hours a monthMeasuredTeam lead's time log; backlog count tracked
9. Not traced16 hours a monthCalculatedLine 6 minus lines 7 and 8; counted as zero
10. Letters returned for correction6% before, 4% afterMeasuredQuality log
11. LicencesJOD 300 a monthAssumed12 seats x JOD 25; replace with your contract price
12. Champion and admin timeJOD 56 a monthEstimated8 hours x JOD 7
13. One-off: setup, training and staff time in trainingJOD 2,500AssumedExternal fees plus 72 staff hours
14. Cash valueJOD 700 a monthCalculatedLine 7 x JOD 8.75
15. Net monthly cashJOD 344CalculatedLine 14 minus lines 11 and 12
16. PaybackAbout 7.3 monthsCalculatedLine 13 divided by line 15

The version that goes wrong

Multiply all 165 gross hours by JOD 7 and you get JOD 1,155 a month and a payback of about 3 months. It is wrong twice: it ignores the added review time, and it books as cash 76 hours that went to the backlog or cannot be traced. Report the backlog work as capacity with its own measure, such as claims older than 30 days, and keep it out of payback.

Add one sensitivity line

Run one sensitivity line before you present. The Green Book asks for sensitivity analysis to test what happens if key assumptions do not hold, and warns against optimism bias, the tendency to be too hopeful about them. Here, if the time saved per file is 6 minutes instead of 9, gross time falls to 110 hours and net time to 101. The 80 overtime hours still fit inside that, so payback does not move; the backlog line shrinks instead. Tying value to redeployment makes the case depend less on the stopwatch.

Label each figure: measured, estimated or assumed

  • Measured: counted from a system or timed on real work, with the method and dates written down.
  • Estimated: calculated from measured inputs plus a stated rule, such as a spot-check rate.
  • Assumed: a number you chose, such as a price before the contract is signed. Each assumption gets a named person and a date by which a measurement replaces it.

Vendor dashboards need the same labels. Microsoft's Copilot Business Impact report in Viva Insights (Microsoft Learn page dated August 2026) calculates "Copilot assisted hours" from users' Copilot actions and multipliers taken from Microsoft's research, then converts them to money at a default average wage of USD 72 an hour, which analysts can change. Microsoft calls the hours a general estimate and notes that differences between user groups have not been tested for statistical significance. In your worksheet, that figure is estimated, and the wage is assumed until you replace it with your own.

When the first number to fix is unused licences

Illustrative example: a family-owned retailer in Riyadh bought 40 Microsoft 365 Copilot licences for its head office. The finance director's first question is simpler: who uses them?

The Microsoft Copilot usage report in the Microsoft 365 admin center answers that. According to Microsoft Learn (page dated July 2026), it shows enabled users (people holding a licence), active users (enabled users who tried a user-initiated Copilot feature) and the active users rate, over the last 7, 28, 90 or 180 days, with a per-user last activity date you can export. Suppose it shows 14 active users out of 40 over 28 days. Then 26 seats cost money and showed no use in that period, and no time study changes that. Note that "active" means someone tried a feature: a high rate shows use, not value.

In this case we recommend fixing use before measuring value. Find out why 26 people stopped (no clear task, no training on their own work, documents the tool cannot reach), move or cancel the seats with no workflow behind them, and only then baseline the workflows of the people who use the tool. Our Microsoft Copilot rollout plan shows how to tie seats to named workflows from the start, and our page on AI licences bought but not used covers the recovery.

What to show the finance director each quarter

  1. The worksheet for each workflow, labels filled in.
  2. Cash value and capacity value on separate lines; only cash in payback.
  3. Full costs: licences, training and support time, added review time.
  4. Quality before and after. Faster work with more errors is not a saving.
  5. Active users against seats paid for.
  6. One sensitivity line, and which assumptions get measured next quarter.
  7. At renewal, look forward. Setup money already spent is a sunk cost, and the Green Book says sunk costs should not affect decisions.

How to start

If the licences are bought and use is low, start with the 30-Day Adoption Rescue: it measures real use, fixes what blocks it, and sets champions and adoption metrics. If you are still deciding where AI should go, the AI Readiness & Workflow Diagnostic ranks use cases and ends in an investment case; baseline the chosen workflows before rollout. See also our Enablement Lab. If you are unsure which fits, the free AI Exposure Scan is a 45-minute conversation that ends in a written next step.

Frequently asked questions

How do you measure AI ROI?

Measure the workflow before the tool arrives: volume, time per item, error rate and where extra hours go today. After rollout, measure the same things again, subtract the review time the tool adds, and count as cash only the hours that replace a cost such as overtime or outsourced work. Divide one-off costs by net monthly cash to get the payback period, and label every figure as measured, estimated or assumed.

Is time saved by AI a real saving?

Not on its own. Time saved becomes a saving when it replaces a cost the business pays, such as overtime, temporary staff or outsourced work. Time used to clear a backlog or answer customers faster is real value too, but it does not pay a licence invoice, so report it as capacity with its own measure and keep it out of the payback line.

What should an AI ROI baseline include?

For each workflow: monthly volume from the system of record, time per item from a timed sample of real work, the current error or rework rate, and where extra hours go today, such as overtime or a backlog. Write down the dates, the sample and the method, so the same measurement can be repeated after rollout and compared fairly.

What costs belong in an AI ROI calculation?

Licences at your contract price, one-off setup and training fees, staff time spent in training, ongoing champion and admin time, and the review time the tool adds, such as spot-checks of AI drafts. Count each cost once. At renewal, leave out setup money already spent and compare next year's costs with next year's expected value.

Are vendor dashboards enough to prove AI ROI?

They help measure use, but they do not prove value. Usage reports show who holds a licence and who tried a feature. Value estimates such as Microsoft's Copilot assisted hours are calculated from actions and research multipliers, so treat them as estimated figures and check them against your own baseline and payroll or system data.

Share this article

Get new insights by email

One email when we publish something useful. No spam; leave any time.

Services in this article

EB230-Day Adoption RescueFor licences bought but barely used: measure real use, fix what blocks it, and set champions and adoption metrics.GB2AI Readiness & Workflow DiagnosticA fixed-scope diagnostic that scores maturity, ranks use cases and ends in an investment case and 12–24 month roadmap.

Related lab: Enablement Lab ↗

Send an enquiry

Want to talk to us about this topic?

Fill in this short form. Our team reads every enquiry and replies by email.

About Measuring AI ROI: A Worked Example and Worksheet

  1. We read your message and pass it to the right team.
  2. We reply by email to agree on next steps, such as a short call.

Not sure which service fits? Find your starting point · See all six labs

We’ll use your details to respond to this enquiry (Privacy notice). Please don’t include passwords or confidential client data.

Start a conversation

Tell us what you need.

A little context helps us direct your enquiry to the right person.

Checking enquiry availability…

We’ll use your details to respond to this enquiry (Privacy notice). Please don’t include passwords or confidential client data.