Skip to the data

Bellwether HardwareReorder

As of Thu 6 Aug 2026, 14:20

Signed in Tobias Renn

Sample data

Friday’s truck

What goes on Friday’s truck, and which lines do we stop carrying altogether?

Hands-on · Change any quantity with the plus and minus, or type over it. Each line will tell you the cover it buys once it lands, and the order total below moves with you. Kept for this browser tab.

Every watched line · soonest to run out first

  1. cases

    Bypass pruner, 8 in.

    Order

    GRD-1180 · Vine & Verge · 6 to a case · $14.75 each · this order $354.00

    5.8 d of cover · runs out before the truck after next needs 28 d

    With 4 cases landed: 33.8 d of cover

    On hand
    5
    Sells
    6 a week
    Lead
    21 d
    Short by
    19 units
    Suggested
    4 cases
  2. cases

    Bird seed, black oil sunflower, 20 lb

    Order

    GRD-2264 · Vine & Verge · 5 to a case · $16.90 each · this order $422.50

    4 d of cover · runs out before the truck after next needs 15 d

    With 5 cases landed: 16.5 d of cover

    On hand
    8
    Sells
    14 a week
    Lead
    8 d
    Short by
    22 units
    Suggested
    5 cases
  3. cases

    12/2 NM-B cable, 250 ft

    Order

    ELE-2205 · Northline Electrical · 1 to a case · $118.00 each · this order $354.00

    10.5 d of cover · runs out before the truck after next needs 21 d

    With 3 cases landed: 21 d of cover

    On hand
    3
    Sells
    2 a week
    Lead
    14 d
    Short by
    3 units
    Suggested
    3 cases
  4. cases

    #8 × 1¼ in. deck screw, 5 lb

    Order

    FST-0910 · Ironbound Fasteners · 6 to a case · $18.40 each · this order $331.20

    5.7 d of cover · runs out before the truck after next needs 16 d

    With 3 cases landed: 17.2 d of cover

    On hand
    9
    Sells
    11 a week
    Lead
    9 d
    Short by
    17 units
    Suggested
    3 cases
  5. cases

    ½ in. copper coupling

    Order

    PLB-2214 · Cascade Plumbing Supply · 25 to a case · $0.82 each · this order $41.00

    5.8 d of cover · runs out before the truck after next needs 11 d

    With 2 cases landed: 14.3 d of cover

    On hand
    34
    Sells
    41 a week
    Lead
    4 d
    Short by
    31 units
    Suggested
    2 cases
  6. cases

    PEX crimp ring, ¾ in., bag of 50

    Enough

    PLB-3390 · Cascade Plumbing Supply · 10 to a case · $9.60 each

    12 d of cover · runs out before the truck after next needs 11 d

    On hand
    12
    Sells
    7 a week
    Lead
    4 d
    Suggested
    0 cases
  7. cases

    Exterior acrylic, deep base, gallon

    Enough

    PNT-3302 · Harbour Coatings · 4 to a case · $31.50 each

    12.4 d of cover · runs out before the truck after next needs 10 d

    On hand
    16
    Sells
    9 a week
    Lead
    3 d
    Suggested
    0 cases

    Buyer’s note · Suggests nothing, and four cases are going on anyway. Exterior season runs to October and a three-day lead does not help on the Saturday it runs out.

  8. cases

    Construction adhesive, 10 oz

    Enough

    ADH-7714 · Ironbound Fasteners · 12 to a case · $4.35 each

    15 d of cover · runs out before the truck after next needs 12 d

    On hand
    47
    Sells
    22 a week
    Lead
    5 d
    Suggested
    0 cases
  9. cases

    15 A tamper-resistant receptacle, ivory

    Enough

    ELE-4471 · Northline Electrical · 10 to a case · $2.15 each

    24.1 d of cover · runs out before the truck after next needs 13 d

    On hand
    22
    On order
    40
    Sells
    18 a week
    Lead
    6 d
    Suggested
    0 cases
  10. cases

    Utility knife blades, 100 pack

    Enough

    TLS-5518 · Cobb & Marlowe · 10 to a case · $11.20 each

    36.4 d of cover · runs out before the truck after next needs 13 d

    On hand
    26
    Sells
    5 a week
    Lead
    6 d
    Suggested
    0 cases
  11. cases

    Blue painter's tape, 1.88 in.

    Enough

    PNT-1145 · Harbour Coatings · 24 to a case · $5.40 each

    36.8 d of cover · runs out before the truck after next needs 10 d

    On hand
    63
    Sells
    12 a week
    Lead
    3 d
    Suggested
    0 cases
  12. cases

    Satin nickel lever, passage

    Enough

    HDW-6027 · Cobb & Marlowe · 8 to a case · $22.90 each

    54.3 d of cover · runs out before the truck after next needs 19 d · bar capped at 42 d

    On hand
    31
    Sells
    4 a week
    Lead
    12 d
    Suggested
    0 cases

Twelve of 9,400 SKUs. A line joins this list when it has sold in eight consecutive weeks and left the shelf empty at least once — the rest are counted quarterly and ordered on sight, which is honest about the fact that nobody is watching them.

Lines with something on them

5 of 12

7 are having nothing ordered and still appear, so their absence is a decision rather than an omission

A list that orders something on every line is a list nobody reads.

Order value

$1,503

against $2,140, the average of the last four Fridays

Low because two long-lead lines were caught early and are small.

First on the list

Bypass pruner

5.8 days of cover against a 21-day lead — 22 days short of the earliest a replacement could land

Not the shortest cover in the shop. The bird seed has four days and a supplier eight days away, which is a smaller hole.

How this list is ordered

  1. 1Days of cover: what is on hand and on order, divided by what it sells in a day.
  2. 2The reorder point is the supplier's lead time plus 7 days, because the next truck is the earliest anything can land.
  3. 3Rank is cover minus lead time. A line with six days of cover and a three-week lead is in more trouble than one with four days and a next-day supplier.
  4. 4The suggestion is the shortfall rounded up to whole cases. Nothing is sold in sevens.
  5. 5A line with cover past its reorder point is ordered nothing, and still appears, so its absence is a decision rather than an omission.

Nothing on this screen places an order. It is the argument for one — and where you disagree with it, the suggestion stays printed beside your figure, because a list that quietly forgets what it recommended cannot be audited in a month.

What this deliberately does not rank by

Units sold. The best-selling line in the shop is blue painter’s tape and it does not need ordering, because sixty-three rolls at twelve a week is five weeks of cover against a three-day lead. The line that will actually cost a sale on Saturday is the eight-inch pruner: six a week, five on the shelf, and twenty-one days from a supplier who ships once a fortnight.

Sorting by what moves puts the tape at the top of every list forever and the pruner near the bottom until the day it is gone. That is the failure this screen exists to stop, and it is why lead time is in the sort rather than in a column beside it.

All dashboards — back to the dashboard index