Electrical wholesaler supplying contractors and installers across Gloucestershire and South Wales from two trade counters. 38 staff. 60 stock lines, 12 months of sales, and the delivery times from each supplier.
Today every minimum is about two months of sales. That holds too much of the steady, quick-delivery lines and too little of the lines with long or unreliable deliveries: 7 of the 25 A lines would run short more often than the 98% target.
| Class | Lines | Value a year | Average stock now | Recommended | Change | Below target now |
|---|---|---|---|---|---|---|
| A | 25 | £1,816,016 | £260,439 | £228,233 | −£32,206 | 7 |
| B | 18 | £326,236 | £36,871 | £24,516 | −£12,355 | 5 |
| C | 15 | £107,062 | £10,871 | £8,378 | −£2,493 | 6 |
A lines carry 80% of the value and get a 98% service level; B 95%; C 90%. Regular lines with a current setting only: dead and erratic lines are handled separately.
| Line | Now | New | Service now |
|---|---|---|---|
| GU10 lamp warm white HE1026 · class A · lead time 10–12 weeks | 309 | 547 | 14% |
| Emergency bulkhead HE1028 · class A · lead time 8–12 weeks | 372 | 641 | 46% |
| Garden spike light HE1030 · class A · lead time 4–9 weeks | 234 | 291 | 90% |
| Fish tape 30m HE1060 · class A · lead time 3–4 weeks | 78 | 100 | 91% |
| PIR floodlight HE1025 · class A · lead time 4–7 weeks | 348 | 408 | 93% |
| 2.5mm twin and earth 100m HE1001 · class A · lead time 2–9 weeks | 373 | 459 | 94% |
| SWA 3-core 4mm 50m HE1005 · class A · lead time 3–8 weeks | 242 | 265 | 96% |
| Track light head HE1029 · class B · lead time 10–15 weeks | 55 | 114 | 29% |
Every line whose current setting gives less than its target service. Long or unreliable deliveries need more cover than two months of sales gives.
| Line | Now | New | Cash |
|---|---|---|---|
| 6mm twin and earth 50m HE1003 · class A | 275 | 165 | −£11,792 |
| RCBO 32A HE1034 · class A | 106 | 62 | −£6,256 |
| 2-gang switch white HE1012 · class A | 1851 | 780 | −£4,476 |
| Junction box 30A HE1017 · class A | 1899 | 1003 | −£4,455 |
| Plasterboard fixings (100) HE1038 · class A | 1700 | 828 | −£4,292 |
| Wood screws 4x40 (200) HE1039 · class A | 1716 | 1082 | −£3,247 |
| Cooker switch HE1014 · class A | 1611 | 1054 | −£3,180 |
| Single socket white HE1010 · class A | 1391 | 831 | −£3,056 |
Steady lines that arrive within a week or two need far less.
| Line | Stock now | Above the maximum | Action |
|---|---|---|---|
| SWA 3-core 6mm 25m HE1006 · no sales | £31,753 | £31,753 | Clear or return |
| 16-way high-integrity unit HE1032 · regular | £29,014 | £23,054 | Lower |
| Back box 25mm HE1015 · regular | £28,535 | £22,334 | Lower |
| Plasterboard fixings (100) HE1038 · regular | £12,015 | £7,942 | Lower |
| Outdoor socket IP66 HE1020 · regular | £4,812 | £2,783 | Lower |
| 10mm twin and earth 50m HE1004 · regular | £19,619 | £2,262 | Keep |
The maximum is the new reorder point plus one order; stock on order counts, so some of this is fixed by cancelling or delaying orders. 9 lines sell too erratically for the formula (7kW home charger tethered, 7kW home charger untethered, 22kW commercial charger, EV charger isolator and others): set those by judgement, or hold them to order.
| Action | Owner | By when |
|---|---|---|
| Set the new reorder points in the stock system for all A items | Purchasing manager | November 2026 |
| Agree a delivery-time guarantee with the two cable suppliers whose deliveries vary most | Operations director | December 2026 |
| Clear the dead stock: return to supplier or sell at cost | Branch manager | January 2027 |
| Recalculate reorder points every quarter from the last 12 months' sales | Purchasing manager | January 2027 |
Safety stock assumes demand varies roughly evenly around its average, from 12 months of sales, and that the longest delivery in a year is about 2.0 spreads above the average. Service levels (98%, 95% and 90% for A, B and C lines) were set before looking at results. Average stock = safety stock plus half the usual order; the change counts regular lines only, against their current settings, and overlaps the stock above its maximum. Erratic lines are flagged for judgement. Cash is released only as stock is run down by ordering less, over the months it takes.
At handover, the purchasing manager loaded the new reorder points for the lines marked Raise, and Harnley began running down the stock above its maximum. The agent was then set up in Harnley's own AI assistant account, with read-only access to the stock system. On the first Monday of each month it loads the latest 12 months of sales, stock, stock on order and delivery times into a new dated copy of the plan, runs the checks and sends the purchasing manager a short note. It uses the decisions on Inputs: service levels of 98%, 95% and 90% for A, B and C lines, and a £5,000 rise in stock above the maximum before it flags one. Nothing left Harnley, and no reorder point changed, without one of its own people approving it. These events continue the fictional example.
| Date | What the agent found | Flag? | What people decided |
|---|---|---|---|
| 2 Nov 2026 | Monthly rerun. The 12 lines marked Raise had their new reorder points in the stock system, so none of the 25 A lines was below its 98% target any more. | Note only | Nothing needed. The purchasing manager read the monthly note. |
| 7 Dec 2026 | Supplier D took 9 and 10 weeks on two orders of the 10-way dual RCD unit (HE1031), against a longest delivery of 5 weeks in the year before. The recommended reorder point rose from 57 to 82; at the current setting of 60, service fell to 87% against the 98% target. The line moved from Keep to Raise. | Flag | The purchasing manager raised the reorder point to 82. The operations director asked Supplier D why deliveries had slowed and when they would return to 4 weeks. |
| 4 Jan 2027 | The December stock report covered the first trade counter only, so stock on hand came to 86% of the accounts figure. Checks showed CHECK, so the note said the plan could not be relied on that month. | Flag | The purchasing manager re-ran the report for both trade counters. Checks passed the same morning. |
| 1 Feb 2027 | The 22kW commercial charger (HE1053) had no sales in the 12 months to January: 2 units, £812 at cost. It moved from set by judgement to Clear or return. | Flag | The branch manager asked Supplier E to take the 2 units back. The line is now held to order only. |
| 1 Mar 2027 | Stock above the maximum rose £7,400 in a month, more than the £5,000 set on Inputs: Supplier A had delivered 400 PIR floodlights (HE1025) on one order, ahead of the season. | Flag | The operations director kept the floodlights for the spring season and paused the next order until stock falls below the maximum. |
| 5 Apr 2027 | Nothing crossed a line. Stock above the maximum fell £9,100 to £59,600 as orders were held back. | Note only | Nothing needed. The purchasing manager read the monthly note. |
At the check-in after the first monthly run, on 30 November (about six weeks after handover), Geoff, the operations director and the purchasing manager read the first month's log together, and Geoff's upkeep of the set-up ended there. No rule needed changing.
What the agent added. The method is unchanged: same spreadsheet, same checks, same service levels. The agent made sure the plan was rerun every month, where the routine had been once a year, and that a slipping supplier showed up within a month. The flag on 7 December raised the RCD unit's reorder point before it ran short. The benefit here is time to act; no £ figure is claimed for it.
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.