The manual-work audit: which tasks are worth automating
Most automation projects fail at the choosing, not in the code. A short audit that scores tasks by frequency, variance and the cost of a mistake, counts what manual work really costs, and turns the few that pass into a business case.
Most automation projects do not fail in the code. They fail in the choosing. A team picks a task that looked impressive in a demo, spends three months on it, and quietly goes back to doing the work by hand. The fix comes before any code: a short, honest audit of where the manual work actually is and what it costs.
Start from the work, not from the tool
"What should we automate?" invites an answer shaped like a tool. Someone has seen a slick agent demo, someone else wants to try a new platform, and the conversation drifts towards what the technology can do instead of what people spend their days on.
A better first question is narrower: where does the same person make the same decision over and over, and what does it cost when they get it wrong? That turns "we should use AI somewhere" into a list of specific tasks with numbers attached.
Three things decide whether automation pays
Frequency: how often the task runs. It multiplies every second you save, and it is the only thing that turns a small win per run into real money. A task done twice a quarter can be annoying and still not worth a line of code.
Variance: how much one instance differs from the next. Low-variance work follows the same steps with predictable inputs; high-variance work needs judgement and exceptions, and every exception is more to build, test and maintain. The tasks that bore people are usually the ones machines do best.
Cost of a mistake: what one wrong result costs. A newsletter signup filed in the wrong category is nothing. A wrongly approved payment is a very bad afternoon. This decides how much checking the automation needs, and sometimes that a person should stay in the loop whatever the savings.
What manual work really costs
Ask what a manual process costs and you usually get hours times rate: six hours a week at forty dollars an hour is $240 a week. That number is real, but it prices every week as if it were an average week. Three costs sit outside it:
Rework. A value entered wrong is found, traced, corrected, and everything that depended on it is redone. That path is often longer than the original task, and it arrives unplanned.
Interruptions. Manual processes run on interruptions, and every switch costs time to get back into the task. Careful reconciliation between three pings an hour is not careful reconciliation.
The tail. Most manual errors are small and get fixed on their own. A few are expensive, and you cannot choose in advance which ones.
An example shows how lopsided this can be. The numbers are assumptions to show the arithmetic, not measurements; put in your own. A sales team receives 800 inbound leads a week, and a coordinator assigns each to an owner by territory and segment. That takes about four hours a week, $160 at forty dollars an hour, which looks too small to bother with.
Now suppose 3% of leads go to the wrong owner: 24 a week. Most are small and cost nothing real. Suppose one in twelve of them, two a week, is a serious lead for a $40,000 deal, and that losing a day on first contact lowers the chance of winning it from 22% to 14%. Eight percentage points of $40,000 is $3,200 of expected revenue per lead, $6,400 a week, over $300,000 in a fifty-week year. With those assumptions, the four hours of labour were never the real cost. The cost was the two good leads a week that cooled in the wrong queue, and no budget line ever named them.
That is why automation is worth more than its speed. A machine that routes leads or reads invoices does not make fewer mistakes because it is clever. It makes the same mistakes every time, which means they can be found, tested and fixed at the source.
Run the audit
You cannot audit from a meeting room. People misjudge how long their work takes in both directions, and the tasks they complain about most are rarely the expensive ones. So spend a week close to the work.
Pick a role or a team and watch. Every time someone touches a repeating task (reading, sorting, copying between systems, deciding, routing), log one row: what triggered it, how many times it happened that week, and how many minutes it took, timed rather than guessed. Watch for the glue work nobody lists in their job description: retyping a value from one tab into another, checking a spreadsheet to decide which queue something goes in, formatting the same report every Monday.
Take ticket triage as a running example. A team receives about 600 support tickets a week. For each one, someone reads it, picks a category, sets a priority and routes it. Timed honestly, that is about 90 seconds a ticket: 600 × 90 seconds is 54,000 seconds, or 15 hours every week, nearly two working days of sorting before anyone has helped a customer.
Rank the candidates
Put every candidate on a simple grid, frequency on one axis and variance on the other:
frequent and predictable: the target, repetitive and expensive in total. Build here;
frequent and varied: assist, do not replace. Draft a suggestion for a person to approve;
rare and predictable: leave it. Cheap to do by hand, not worth the maintenance;
rare and varied: almost never worth it.
Then use the cost of a mistake as a veto rather than a fourth dimension: a task can sit in the best corner and still fail if one bad output is expensive and hard to catch. A rough score keeps the ranking open to argument:
score = (
(annual_minutes_saved / 60) * hourly_cost
* confidence_it_stays_predictable # 0.0 to 1.0
/ mistake_penalty # 1 = trivial, 5 = severe
)
# keep the top few; the grid should reject most candidatesMost candidates should fail. That is the point of the audit.
The impressive task versus the frequent one
Given a list, teams tend to reach for the impressive task over the frequent one. Contract review is the classic case: it sounds important, it demos well, and a manager can picture the headline. It is also rare and varied, since every contract is different, and a missed clause is expensive. It sits in the worst place on every axis, and it still gets picked. Meanwhile the ticket triage that eats 15 hours a week goes unnoticed because it is dull. Dull and frequent is exactly where automation pays.
When manual is the right answer
If a process is rare, cheap to get wrong, and its errors are caught before anyone acts on them, keeping it manual is the right engineering decision, and automating it would be the waste. Three questions settle it: how far can a bad run drift, what does it touch on the way, and would anyone notice before a decision is made on it? If the drift is small, the damage contained and the detection fast, leave it to people and spend the effort elsewhere.
Turn the top few into a business case
By now you have the numbers, so the case almost writes itself: one page per candidate.
Back to triage. Not all 600 tickets are predictable, but suppose about 75% are routine enough for a classifier. That is roughly 11 of the 15 hours a week. At a loaded cost of about $42 an hour, that is about $460 a week, or about $2,000 a month. Suppose the build, a category-and-priority classifier connected to your routing rules, takes a few weeks and costs $5,500. The payback is $5,500 ÷ $460, about twelve weeks. Add a yearly estimate for maintenance, because integrations break when the systems around them change, and state the 25% left for people. A case like that is conservative, and you can defend every line of it.
What to give the developer
The audit ends with a short spec: the exact trigger, the inputs and where they live, the decision rules including every known exception, and the part teams forget, a definition of a wrong answer and what the system should do when it is not sure. For invoices, a wrong answer is one whose numbers do not add up, as in Invoice extraction you can trust. For questions answered from a database, it is a number the user cannot check, which is why Text-to-SQL, safely shows the query.
In short: start from the work, measure frequency, variance and the cost of mistakes, count the hidden costs as well as the hours, let most candidates fail, and hand the developer a clear definition of wrong.
No. 08 · Playbook · 25 September 2026