Safety Stock and Reorder Plan · October 2026

Harnley Electrical Supplies Ltd

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.

Worked example. Harnley Electrical Supplies is a fictional business; every name and figure is invented. All figures come from the worked-example spreadsheet: ALL CHECKS PASSED (with 5 notes): dead stock, erratic lines, a line with no reorder point, A lines running short, and stock above its maximum.
The headline

Less stock overall, more of the right stock

Stock now
£413,510
at cost, 97% of the accounts figure
Average stock, regular lines
£262,258
recommended, against £309,312 at today’s settings
Cash released
£47,054
as stock runs down to the new settings; holding cost £9,411 a year less
Above the maximum now
£97,424
once, counting stock on order; £33,365 of it dead stock. It overlaps the cash released, so don’t add them.

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.

By class

Where the money sits

ClassLinesValue a yearAverage stock nowRecommendedChangeBelow target now
A25£1,816,016£260,439£228,233−£32,2067
B18£326,236£36,871£24,516−£12,3555
C15£107,062£10,871£8,378−£2,4936

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.

Raise first

Running short

LineNowNewService now
GU10 lamp warm white
HE1026 · class A · lead time 10–12 weeks
30954714%
Emergency bulkhead
HE1028 · class A · lead time 8–12 weeks
37264146%
Garden spike light
HE1030 · class A · lead time 4–9 weeks
23429190%
Fish tape 30m
HE1060 · class A · lead time 3–4 weeks
7810091%
PIR floodlight
HE1025 · class A · lead time 4–7 weeks
34840893%
2.5mm twin and earth 100m
HE1001 · class A · lead time 2–9 weeks
37345994%
SWA 3-core 4mm 50m
HE1005 · class A · lead time 3–8 weeks
24226596%
Track light head
HE1029 · class B · lead time 10–15 weeks
5511429%

Every line whose current setting gives less than its target service. Long or unreliable deliveries need more cover than two months of sales gives.

Then lower

Holding too much

LineNowNewCash
6mm twin and earth 50m
HE1003 · class A
275165−£11,792
RCBO 32A
HE1034 · class A
10662−£6,256
2-gang switch white
HE1012 · class A
1851780−£4,476
Junction box 30A
HE1017 · class A
18991003−£4,455
Plasterboard fixings (100)
HE1038 · class A
1700828−£4,292
Wood screws 4x40 (200)
HE1039 · class A
17161082−£3,247
Cooker switch
HE1014 · class A
16111054−£3,180
Single socket white
HE1010 · class A
1391831−£3,056

Steady lines that arrive within a week or two need far less.

Run down once

Stock above its maximum today, counting stock on order

LineStock nowAbove the maximumAction
SWA 3-core 6mm 25m
HE1006 · no sales
£31,753£31,753Clear or return
16-way high-integrity unit
HE1032 · regular
£29,014£23,054Lower
Back box 25mm
HE1015 · regular
£28,535£22,334Lower
Plasterboard fixings (100)
HE1038 · regular
£12,015£7,942Lower
Outdoor socket IP66
HE1020 · regular
£4,812£2,783Lower
10mm twin and earth 50m
HE1004 · regular
£19,619£2,262Keep

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.

What changes

The plan

ActionOwnerBy when
Set the new reorder points in the stock system for all A itemsPurchasing managerNovember 2026
Agree a delivery-time guarantee with the two cable suppliers whose deliveries vary mostOperations directorDecember 2026
Clear the dead stock: return to supplier or sell at costBranch managerJanuary 2027
Recalculate reorder points every quarter from the last 12 months' salesPurchasing managerJanuary 2027
How confident are we?

What this rests on

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.

The months after

What the agent flagged, and what was decided

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.

Monthly runs
6
November 2026 to April 2027
Flags raised
4
the other runs sent the monthly note only
Slipping supplier flagged
7 Dec
the RCD unit raised before it ran short
Reorder points changed by the agent
0
every change was made by a person
DateWhat the agent foundFlag?What people decided
2 Nov 2026Monthly 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 onlyNothing needed. The purchasing manager read the monthly note.
7 Dec 2026Supplier 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.FlagThe 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 2027The 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.FlagThe purchasing manager re-ran the report for both trade counters. Checks passed the same morning.
1 Feb 2027The 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.FlagThe branch manager asked Supplier E to take the 2 units back. The line is now held to order only.
1 Mar 2027Stock 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.FlagThe operations director kept the floodlights for the spring season and paused the next order until stock falls below the maximum.
5 Apr 2027Nothing crossed a line. Stock above the maximum fell £9,100 to £59,600 as orders were held back.Note onlyNothing 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.