Days of Cover
Sample Sprint report

What you receive after the Sprint.

A fictional Sprint for Ridgeway Industrial Supply, the same business as the sample week. This is not a live client account. It shows the shape of the report, the clearance plan and the settings worksheet you receive at the end of the Sprint.

A$596k of excess stock found. About A$280k of it is cash you can release.

Every Sprint report shows two numbers: the excess stock at cost, which is what the guarantee is measured on, and what each line is expected to return by its best route, net of costs. A$3.4m of stock at cost, 6,200 active items, on Business Central since 2023.

A$596kexcess stock at cost, 17.5% of holdings
A$280kcash you can release, best route, net of costs
214lines carrying excess
412planning settings corrected

Guarantee check: the threshold is A$100,000 of excess stock, and this Sprint found A$596k.

Start at the top. Most cash for least effort.

Every excess line is routed to its best way out. Routes are ranked by cash recovered per hour of your team's effort, so the first hours spent go where they return the most.

RouteAt costCash you can releaseTeam effortCash per hour
Return to supplier for creditA$164kA$131k14 hrsA$9.4k
Trade offers and bundlesA$198kA$109k22 hrsA$5.0k
Clearance price or auctionA$142kA$40k30 hrsA$1.3k
Write off before stocktakeA$92kA$02 hrsn/a
TotalA$596kA$280k68 hrsA$4.1k

8 of 214 lines. A$132k at cost, A$83k you can release.

The full report lists every line. These eight carry 22% of the excess, each with its own route.

ItemCoverAt costRouteCash you can release
HY-4410 Hydraulic Coupling Kit296dA$31.2kReturn to supplier, unopened and inside the return windowA$24.9k
TP-5200 Transfer Pump 2in184dA$23.4kBundle with spare parts kits for the two largest trade accountsA$14.0k
GC-7702 Galvanised Pipe Clamp 100mm212dA$18.9kReturn to supplier, mostly unopened cartonsA$15.1k
VL-3380 Gate Valve 80mm241dA$17.6kTrade offer to the top 20 accountsA$9.7k
FT-2210 Flange Gasket Set330dA$14.3kReturn what's eligible, clear the balanceA$9.3k
HS-0915 Hose Clamp Assortment400d+A$12.8kBundle into site-pack ordersA$6.4k
EL-5520 Cable Gland M20, box 100280dA$9.6kAuction lotA$2.9k
PP-9030 Hi-Vis Vest, superseded colour400d+A$4.2kSite-pack bundle, write off the balance before stocktakeA$1.0k
Top 8 linesA$132.0kA$83.3k

Stop buying what you're clearing.

Lines on the clearance plan that the planning worksheet still wants to buy. Handed over with the plan, so the stock you're clearing isn't being reordered at the same time.

ItemWorksheet suggestsCall
TP-5200 Transfer Pump 2in24Do not reorder
GC-7702 Galvanised Pipe Clamp 100mm150Do not reorder
HY-4410 Hydraulic Coupling Kit10Do not reorder
VL-3380 Gate Valve 80mm20Do not reorder

38 items will run out before a new order lands.

Fast movers where cover is shorter than the supplier's lead time. The first four, from the same business as the sample week:

ItemCoverLead timeCall
SS-0816 Hex Bolt M16 Stainless, box 503d28dBUY now
PP-1120 Nitrile Gloves L, carton12d14dBUY now
PV-2250 Ball Valve, PVC 50mm18d35dBUY now
HY-3310 Hydraulic Hose 3/8in, 50m30d42dBUY now

The cause, fixed.

Delivered as an import worksheet your team can load, or hand to your Business Central partner. You decide what gets loaded, and I never write to your system. 412 items in this Sprint, four examples:

ItemFieldNowCorrectedWhy
SS-0816 Hex Bolt M16Policy, reorder point, maximumOrder, 0, 0Maximum Qty., 45, 85Set up when it sold 2 boxes a month. Now about 40.
PU-5100 Diaphragm Pump 1inReorder point, maximum60, 15024, 40Set for 20 a month. Now sells about 8.
PV-2250 Ball Valve 50mmLead time calculationBlank35DImported line with no lead time entered.
FE-2201 Filter Element 10 micronSafety stock8030Buffer set for volumes it no longer sells.

That's the report. Yours would use your data.

Start with the free 20-minute stock review. No data access, nothing to prepare.