Industrial pump repair, servicing and installation from workshops in Wakefield and Middlesbrough. 74 staff.
Verdict: The register holds 28 KPIs for 5 goals; every goal has a leading and a lagging KPI on paper, but only 2 can be tracked with good data today. 12 are on the top page (limit 12), reviewed at “Weekly operations meeting” in 30 minutes. The main job is fixing the data: 18 KPIs are on the data-fix plan. Build first, from good data: Sales invoiced this month against plan, Debtor days, Cash in the bank. Of the 6 catalogue ROI products it feeds, 1 already possible (not counted), 2 unlocked once the dashboard is built and 3 only once the data is fixed or recorded. Report hours: 40 now; 12 target; 4 to refresh a month (an illustration of their worth, if the target is met, is on row 25). Measure the baselines again on 3 Jul 2027 (early read 4 Apr 2027).
| Goal | KPIs | Leading | Lagging | On paper | With usable data |
|---|---|---|---|---|---|
| G1 Grow sales to £9.0m (from £7.8m) Owner: Sales manager | 5 | 3 | 2 | Yes | No usable leading KPI |
| G2 Lift gross margin on jobs to 34% (from 30%) Owner: Operations director | 4 | 3 | 1 | Yes | On paper only |
| G3 Get paid faster: debtor days down to 45 (from 63) Owner: Finance manager | 4 | 2 | 2 | Yes | Usable now |
| G4 Grow service contract income to £2.4m a year (from £1.9m) Owner: Service manager | 4 | 2 | 2 | Yes | On paper only |
| G5 Keep good engineers: engineer leavers under 10% a year (from 18%) Owner: Operations director | 3 | 2 | 1 | Yes | Usable now |
Before this, the monthly pack arrived three weeks after the month end, and three people meant three different things by “turnover”. The pack’s lateness is now a KPI of its own: 15 working days now, 5 by the year end.
| KPI | Now | This quarter | Year end | Red if | Data |
|---|---|---|---|---|---|
| Sales invoiced this month against plan Must G1 · lagging · monthly · Finance manager | 94% | 95.5% | 100% | below 90.5% | Good |
| New enquiries a week G1 · leading · weekly · Sales manager | 19 | 20.5 | 25 | below 16.4 | Patchy |
| Value of quotations sent a week G1 · leading · weekly · Sales manager | £142,000 | £151,500 | £180,000 | below £128,775 | Patchy |
| Gross margin on completed jobs G2 · lagging · monthly · Operations director | 30% | 31% | 34% | below 29% | Patchy |
| Engineer utilisation G2 · leading · weekly · Service manager | 71% | 72.8% | 78% | below 69.8% | Patchy |
| Debtor days Must G3 · lagging · monthly · Finance manager | 63 days | 58.5 days | 45 days | above 64.3 days | Good |
| Jobs invoiced within two working days G3 · leading · weekly · Finance manager | – | 90% | 90% | below 85% | Missing |
| Debt more than 60 days old G3 · leading · weekly · Finance manager | £86,000 | £74,500 | £40,000 | above £93,125 | Good |
| Cash in the bank Must General · lagging · weekly · Finance manager | £184,000 | £200,500 | £250,000 | below £160,400 | Good |
| Planned maintenance visits on time G4 · leading · weekly · Service manager | 88% | 89.8% | 95% | below 86.8% | Patchy |
| Engineer leavers in the last 12 months G5 · lagging · monthly · Operations director | 18% | 16% | 10% | above 18% | Good |
| Working days to issue the monthly pack Must General · lagging · monthly · Finance manager | 15 days | 12.5 days | 5 days | above 15 days | Good |
Targets step evenly from today’s figure to the year-end goal; % tolerances are in percentage points. Team pages: Sales page (8 KPIs, sales manager, at the Monday sales huddle); Service and workshop page (8 KPIs, service manager, at the Weekly operations meeting); Money page (7 KPIs, finance manager, at the Monthly management meeting); People page (5 KPIs, operations director, at the Monthly management meeting).
Good data Patchy Missing
Most of the gaps are in the CRM (quotations aren’t dated by stage) and in job costing (hours are booked late). Cash and debtor figures are good already.
| # | KPI | Data | Who | By |
|---|---|---|---|---|
| 1 | One-to-ones held in the month | Missing | Operations director | 6 Nov |
| 2 | Sickness absence | Patchy | Operations director | 6 Nov |
| 3 | New enquiries a week Top page | Patchy | Sales manager | 13 Nov |
| 4 | Value of quotations sent a week Top page | Patchy | Sales manager | 13 Nov |
| 5 | Workshop repairs waiting over 10 days | Patchy | Workshop manager | 13 Nov |
| 6 | Engineer utilisation Top page | Patchy | Service manager | 20 Nov |
| 7 | Jobs invoiced within two working days Top page | Missing | Finance manager | 20 Nov |
| 8 | Annual value of live service contracts | Patchy | Service manager | 20 Nov |
| 9 | Renewals due with a quotation sent | Patchy | Service manager | 20 Nov |
| 10 | Planned maintenance visits on time Top page | Patchy | Service manager | 20 Nov |
| 11 | Contract value lost in the last 12 months | Patchy | Service manager | 20 Nov |
| 12 | Quotation win rate by value | Missing | Sales manager | 27 Nov |
| 13 | Open quotations by stage, dated | Missing | Sales manager | 27 Nov |
| 14 | Enquiries by source | Missing | Sales manager | 27 Nov |
| 15 | Quotations priced from the costing sheet | Missing | Sales manager | 27 Nov |
| 16 | Gross margin on completed jobs Top page | Patchy | Operations director | 4 Dec |
| 17 | Jobs over their estimated hours | Missing | Workshop manager | 4 Dec |
| 18 | First-time fix rate | Missing | Service manager | 4 Dec |
| # | KPI | Source | Effort | First step |
|---|---|---|---|---|
| 1 | Sales invoiced this month against plan Must | Accounting package | Low | Build now |
| 2 | Debtor days Must | Accounting package | Low | Build now |
| 3 | Cash in the bank Must | Bank account | Low | Build now |
| 4 | Working days to issue the monthly pack Must | Accounting package | Low | Build now |
| 5 | Engineer leavers in the last 12 months | Payroll | Low | Build now |
| 6 | Debt more than 60 days old | Accounting package | Low | Build now |
| 7 | Receipts from customers a week | Bank account | Low | Build now |
| 8 | Overtime hours per engineer a week | Timesheet app | Low | Build now |
| 9 | Website enquiries a month | Website analytics | Low | Build now |
| 10 | Lost-time accidents | Health and safety log | Low | Build now |
| KPI, definition, period and edge cases | Source and second source | Allowed breakdown |
|---|---|---|
| Sales invoiced this month against plan Sales invoiced in the month ex VAT, less credit notes ex VAT, ÷ the month's sales plan Period: Calendar month; invoice date. Edge cases: A credit note counts in the month it is raised, whatever the original invoice's month; the plan is the budget agreed in September, not revised | Accounting package checked against: Sales day book total for the month | By customer or job |
| New enquiries a week Enquiries logged in the CRM in the week from customers asking for a price or a visit, not repeat service calls Period: Monday 00:00 to Sunday 23:59; date logged. Edge cases: One enquiry per customer per need: a second call about the same pump is not a new enquiry | CRM checked against: Phone log for one sample week a quarter | By customer or job |
| Value of quotations sent a week Total value ex VAT of quotations issued in the week Period: Monday to Sunday; quotation issue date. Edge cases: A revised quotation replaces the earlier one (counted once, at its latest value); service contract renewals excluded | CRM checked against: Quotation numbers issued in the week, from the quotation register | By customer or job |
| Gross margin on completed jobs (Job sales ex VAT − labour at standard cost − materials − subcontract) ÷ job sales ex VAT, for jobs completed in the month Period: Calendar month; job completion date. Edge cases: Jobs spanning two months count in the month they complete; warranty returns are charged to the original job | Job management system checked against: Gross margin in the monthly management accounts | By customer or job |
| Engineer utilisation Hours booked to chargeable jobs ÷ hours paid, engineers only, for the week Period: Monday to Sunday; timesheet date. Edge cases: Training, travel between jobs and workshop cleaning are not chargeable; holiday and sickness hours are excluded from hours paid | Timesheet app checked against: Payroll hours paid | By team or site staff data |
| Debtor days Trade debtors at the month end ex VAT ÷ sales invoiced ex VAT in the last three months × 91 (ex VAT on both sides) Period: Last calendar day of the month. Edge cases: Retentions and disputed invoices included; unallocated cash deducted from debtors | Accounting package checked against: Aged debt report total at the same date | By customer or job |
| Jobs invoiced within two working days Jobs completed in the week invoiced within two working days of completion ÷ jobs completed in the week Period: Monday to Sunday; job completion date. Edge cases: Jobs held for a customer's order number count as late; bank holidays aren't working days | Job management system checked against: Invoice dates in the accounting package | By customer or job |
| Debt more than 60 days old Total including VAT of unpaid sales invoices more than 60 days past their invoice date (not their due date), at Friday close Period: At Friday close; invoice date. Edge cases: Disputed invoices included and listed separately; credit notes not yet allocated are deducted | Accounting package checked against: Aged debt report | By customer or job |
| Cash in the bank Cleared balance of all business bank accounts at Friday close, less any overdraft drawn Period: Friday close. Edge cases: Deposit accounts included; uncleared cheques and card payments excluded | Bank account checked against: Bank reconciliation in the accounting package | Whole business |
| Planned maintenance visits on time Planned maintenance visits completed by their due date in the week ÷ visits due in the week Period: Monday to Sunday; due date. Edge cases: A visit the customer postpones in writing is re-dated, not late; a part-completed visit is late | Job management system checked against: Visit reports signed by the customer | By team or site staff data |
| Engineer leavers in the last 12 months Engineers who left in the last 12 months ÷ average engineers employed over the 12 months Period: Rolling 12 months to the month end; leaving date. Edge cases: Retirements and dismissals included and shown separately; apprentices excluded | Payroll checked against: HR spreadsheet leavers list | By team or site staff data |
| Working days to issue the monthly pack Working days from the month end to the management pack reaching the directors Period: Calendar month end; date the pack is emailed. Edge cases: Bank holidays aren't working days; a pack sent after 5pm counts as the next working day | Accounting package checked against: Date of the email sending the pack | Whole business |
People data: 7 staff; 2 health; groups of at least 5; per-person figures not allowed. Sickness absence and lost-time accidents are health data (special category): shown as rates by team, never with reasons, and only once an appropriate policy document is in place.
| ROI product | KPIs it needs, and their status | Unlocked? |
|---|---|---|
| 13-Week Cash Flow Forecast | Receipts from customers a week Ready when built Debtor days Already possible Cash in the bank Already possible | Unlocked once the dashboard is built |
| Sales Forecast and Pipeline Review | Open quotations by stage, dated Record the data first Quotation win rate by value Record the data first | Unlocked once the data is recorded |
| Profit by Customer and Product | Gross margin on completed jobs Fix the data first | Unlocked once the data is fixed |
| Customer Retention Review | Annual value of live service contracts Fix the data first Contract value lost in the last 12 months Fix the data first | Unlocked once the data is fixed |
| Staff Turnover Cost Review | Engineer leavers in the last 12 months Ready when built | Unlocked once the dashboard is built |
| Working Capital Release Plan | Debt more than 60 days old Already possible | Already possible: not counted |
Measure later: 17 of 28 KPIs have a ‘Now’ figure with its source; they are measured again six months after go-live (3 Jul 2027), with an early read on 4 Apr 2027. Report hours a month: 40 now; 12 target; 4 to refresh. Illustration only, if the target is met (not a forecast): £8,640 a year after the build; £4,440 in the first year, after £4,200 to build it.
| Item | Time | What you look at |
|---|---|---|
| Top page: anything red or amber, and why | 10 min | 12 KPIs on the top page; discuss only those outside their tolerance (red or amber) against this quarter's target |
| Leading KPIs: what they say about the next four weeks | 8 min | 10 leading KPIs measured weekly or daily |
| Last week's actions: done or not | 5 min | Last week's action list |
| New actions: who does what, by when | 5 min | One owner and one date for each action |
| Data fixes: on track for their dates? | 2 min | 18 KPIs on the data-fix plan (Plan, part A): any due this week? |
The goals, KPIs, definitions, owners and targets are as agreed with the owner and the managers on 14 Oct 2026; the Now figures are from the sources named against each. Whether each KPI is measured now, how good its data is and the effort to automate it are the team’s judgement, not tested; duplicates are caught only where two definitions read the same. Quarterly targets step evenly from Now to the year-end target, and red and amber work off this quarter’s step (percentage points for % KPIs). The top-page limit (12) and the most one person should own (33%) are assumed. The value case is Unlocks: the dashboard makes the named ROI products possible, mostly once the data is fixed; it is not a forecast of profit. Report hours now are counted; the target (12 hours), refresh hours and build cost are estimates, so the £ line is an illustration if the target is met, not a forecast.
The specification is finished when it is handed over; building it is the next job. Check each built figure against its second source before the top page is used.
At handover the agent was set up in Ottersgill's own AI assistant account, with read-only access to the accounting package, the bank feed, the timesheet app, the job management system and the HR spreadsheet. Every Monday at 7:00, before the weekly operations meeting, it reads each KPI from the source named in the register, writes the latest figures into a new dated copy, runs the checks and sends the managing director a short note: what is red and amber against this quarter's target, and which data fixes are due. It uses the register's own targets and tolerances, and the rule on Inputs that four amber readings in a row are flagged. It reports people figures only by team, and the sickness rate not at all until an appropriate policy document is in place. Nothing left Ottersgill, and no decision changed, without one of its own people approving it. These events continue the fictional example; the dashboard itself goes live in January.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 19 Oct | The first run read the 10 KPIs with good data. Of the 12 on the top page, six had a figure: five amber, and Debt more than 60 days old red at £96,800. | Flag | The finance manager called the five oldest debts that week. |
| 2 Nov | Debt more than 60 days old back to amber, at £88,300. | Note only | Nothing new needed; the weekly calls continued. |
| 9 Nov | The data-fix date for One-to-ones held in the month passed with nothing recorded. | Flag | A column was added to the HR spreadsheet and the date moved to 30 November. |
| 9 Nov | Cash in the bank amber for the fourth reading running, falling from £191,000 to £176,500. | Flag | The managing director asked for a 13-week cash view before approving the van purchase. |
| 23 Nov | The data-fix date for Jobs invoiced within two working days passed: completion dates were blank on about 40% of jobs. | Flag | Completion date became a required field, and the fix date moved to 11 December. |
| 30 Nov | Cash in the bank red at £158,900, after the VAT quarter was paid. | Flag | The van purchase was held until December's receipts were in. |
At the 30-day check-in on 16 November, Geoff and the managing director read the log together. They kept four amber readings as the rule, and agreed the note should list the data fixes due in the coming fortnight.
What the agent added. The method is unchanged: same register, same targets and tolerances, same checks. The agent made sure the figures were read every week, before the dashboard was even built, and that the data-fix dates were followed up as they passed. The falling cash balance was flagged three weeks before it went red. The figures above are fictional, and no £ figure is claimed for the agent.
Fictional and labelled: these events continue the worked example. The same six events are the sample rows in the Agent log of the worked-example spreadsheet. The agent is part of the guided and done-for-you routes; the self-implement kit does not include it.