Sample: Automation Opportunity Audit report

The report you get a week after we visit. Two pages.

This is a sample, for a made-up food wholesaler. Linda and Sandra are not real and neither is any number below. The layout, the sums and the promise are what you get.

Count your own first line
Better Systems Co.Assessment report, page 1 of 2 Sample

Prepared for Linda, owner of a food wholesaler with 40 staff

Half a day on site, beside the order desk and accounts. One week of work counted and timed.

1,960hours a year go on five jobs done by hand
£39,200what those hours cost you a year
£27,440a year of that time software could take over
Job done by hand, and what changesA weekMins eachHours a yearCost a yearHours backWorth a year
Typing emailed and PDF orders into Sage 50 Sandra, order deskOrders arrive read, matched and checked against the 2pm cut-off and the minimum order. Sandra approves each one.3004960£19,200672£13,440
Typing in supplier invoices and matching them to purchase orders AccountsInvoices arrive read and matched. Accounts approve them, and look closely at the ones that differ.1205480£9,600336£6,720
Answering "where is my order?" from three systems Order deskOne screen shows where each order is. The customer is told when it leaves.754240£4,800168£3,360
Putting right orders that went in wrong Order desk and driversA wrong code or a missed cut-off is caught before the order goes in.825160£3,200112£2,240
Building the Friday report from three exports Office managerThe report builds itself overnight and is waiting on Friday morning.1150120£2,40084£1,680
All five jobs1,960£39,2001,372£27,440

Do this first

Emailed and PDF orders, read and checked, waiting for Sandra to approve into Sage 50.

£5,000 fixed

Less the £750 assessment fee already paid. Running costs £2,400 a year. It gives back 672 hours worth £13,440 a year, so it pays for itself in about 5 months.

Left alone

Telephone orders, about 60 a week. A person on the phone is part of the service. Nothing changes.

Chasing late payers. That is judgement, and it stays with accounts.

The promise, checked

The assessment cost £750. It found time worth £27,440 a year that software could take over. That is more than the fee, so the fee stands and comes off the build.

Had it found less than £750, there would be no charge.

How the figures are worked out. Hours a year are the number a week, times the minutes each, across 48 working weeks. Cost is hours at £20 an hour all in, for every role. Hours back assume software takes 70% of the handling and a person does the rest, including every approval. These are hours and what they cost, not cash in the bank. They become cash when overtime stops, a vacancy no longer needs filling, or the time wins more orders.

This is a sample. Linda, Sandra, their firm and every figure are made up. A real report uses your own counts, each person's real cost and a share set job by job from what we watched. Better Systems Co., hello@bettersystems.co.

Better Systems Co.Assessment report, page 2 of 2 Sample

What your figures already show

Five questions, answered from three years of orders, invoices and payments exported from Sage 50 and the purchasing spreadsheet. Nothing new was bought or installed.

The question, and what we foundHow manyWorth looking atWho acts
Which customers have gone quiet?Eleven customers ordered at least once a month last year and have not ordered for 60 days. The three largest are a café group, a school caterer and a care home.11 customers£48,600what they spent last yearSales
Who is ordering less than they did?Seven customers are ordering at least 30% less than in the same quarter last year. None has complained or closed an account.7 customers£31,200a year, if it carries onSales
Who pays late every time?Six customers paid more than 30 days late on every invoice this year. Two of them are also on the best price list.6 customers£22,500owed by them on a typical dayAccounts
Where did the margin go?Margin by customer runs from 9% to 31%. The four lowest are all on price lists last changed in 2023.4 customers£14,300a year, against the average marginLinda
Which supplier prices have crept up?Fourteen product lines were invoiced this year at more than the price on the purchase order. Nobody had compared the two.14 lines£3,870paid above the ordered price so far this yearPurchasing

With this page you get

The lists themselves. Every customer and product line behind each figure, by name, with the amounts and dates, as a spreadsheet you keep.

We go through them with you for 45 minutes and agree who rings whom.

Could not be answered yet

Margin by product. Sales are in Sage 50 and costs are in the purchasing spreadsheet under different product codes. Until the two are joined, this is a guess, so we have not made one.

Not part of the promise

Nothing on this page counts towards the money-back promise. That is checked on page one, from hours only.

These amounts are what is worth looking at. They are not savings until somebody acts.

How the figures are worked out. Gone quiet means at least one order a month last year and none for 60 days. Ordering less compares this quarter with the same quarter last year. Late means paid more than 30 days after the due date. Margin is sales less the cost of goods on the invoice. Price creep compares each purchase order line with the supplier invoice that followed it.

This is a sample. The firm, its customers and every figure are made up. A real report uses your own records. Better Systems Co., hello@bettersystems.co.

In short: an automation assessment report lists each office job done by hand, how often it happens and how long it takes, the hours and cost of a year of it, what software would take over and what would be left alone, and a fixed price for the first build with how long it takes to pay for itself. A second page answers five questions from the figures the firm already holds, such as which customers have gone quiet. It fits on two pages.

How to read it

  1. The three numbers at the top

    What the manual work takes in hours, what those hours cost, and how much of that software could take over. The third is the one the promise is checked against.

  2. One row for each job

    The left half is what we counted. The shaded right half is what changes. The line in italics says what the job looks like afterwards for the person who does it.

  3. Do this first

    One job, one fixed price, and how long until it has paid for itself. You can stop there. Nothing else on the sheet has to be bought.

  4. Left alone

    Every report says what should not be automated. If nothing is worth doing, the report says that, and you are not charged for it.

  5. Page two

    Five questions answered from records you already keep. You get the names behind every figure. Where two systems would have to be joined to answer one, the page says so and does not guess.

To see where your own first line would start, count it in a minute. To see how the visit works, read about the Automation Opportunity Audit.

Questions people ask

Are these real figures?

No. Linda and Sandra are made up and so is every number on the sheet. The layout, the sums and the promise are exactly what a real report contains. Yours is built from a week of your own work, counted and timed in your office.

What if the report finds nothing worth fixing?

Then it says so, and you do not pay for it. If the assessment does not find yearly savings worth more than its fee, there is no charge, and you keep the report.

How long until we have one?

About a week after the visit. The visit is half a day beside the people who do the work. The assessment costs £500 to £1,250, fixed before we start, and the fee comes off the build if you go ahead.

Want yours?

A 20-minute call first. You tell us which job in your office you would count. We tell you honestly whether an assessment is worth your half day.