About Services Tools Blog Contact us

Sell-through and Reorder Desk

Projects when each product code will sell out from recent demand, lead time and stock on hand. It also lists dead stock, recent sell-outs and how fast full sheets sell.

  • Stock & Inventory
  • Specialist sheet materials
  • Dashboard feature
  • Productised
  • Hybrid
  • 2026

The problem

Reorders happened after a line had already sold out, or so early that cash sat in stock. Cut pieces and full sheets were mixed in one forecast, so buyers misjudged how fast master sheets turn. Lines that had not moved were hard to see in Brightpearl, and fast sellers that sold out stayed invisible until a customer asked.

What it does

The desk projects a sell-out date from recent demand, supplier lead time and stock on hand, and flags what to reorder. Separate views list stock that has not sold, products that recently hit zero, and full-size sheets only, so offcuts do not distort the sales rate for full sheets. Lead times are set by product code group.

Outcomes

  • Buyers see a reorder list before a line hits zero.
  • Dead stock and recent sell-outs are listed apart from the forecast.
  • Full sheets are rated without cut pieces mixed in.
  • Changing the lead time for a product code group changes the urgency straight away.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Sell-through forecast

Cover inside lead time
Lines in window
15
Full sheets and cuts
Reorder now
4
Before the lead time runs out
Idle over 180 days
6
See exceptions
Hit zero recently
5
Fastest was yesterday
Urgency by family Days inside the lead time
How cover is worked out

Days of cover = stock on hand ÷ weekly rate × 7. A line is flagged when cover is inside the prefix lead time.

Acrylic is on a 7-day lead. White 3 mm (13 days) and smoke 5 mm (15 days) are safe until that lead moves to 21.

Cut pieces are in this rate. The full-sheet tab drops them out.

Forecast lines
SheetWeeklyStockCoverFlag
Clear acrylic 3 mmACR-CL-3 · 2440 × 1220 6.245 Reorder
Clear polycarbonate 4 mmPC-CL-4 · 3050 × 2050 3.548 Reorder
White composite 3 mmCMP-WH-3 · 3050 × 1500 2.8513 Reorder
Grey laminate 8 mmLAM-GY-8 · 2800 × 2070 1.2318 Reorder
White acrylic 3 mmACR-WH-3 · 2440 × 1220 2.6513
Smoke acrylic 5 mmACR-SM-5 · 3050 × 2050 1.4315
White foam board 10 mmFOM-WH-10 · 2440 × 1220 1.62088
Black foam board 5 mmFOM-BK-5 · 2440 × 1220 0.814123
Bronze polycarbonate 6 mmPC-BR-6 · 3050 × 2050 0.59126
Black composite 3 mmCMP-BK-3 · 3050 × 1500 0.711110
Oak-grain laminate 10 mmLAM-OK-10 · 3050 × 1320 0.47123
Clear acrylic 3 mm cutACR-CL-3-C · 600 × 400 11.03623
Clear acrylic 3 mm cutACR-CL-3-D · 1200 × 600 2.4823
White foam board 5 mm cutFOM-WH-5-C · 1000 × 500 7.21818
White composite 3 mm cutCMP-WH-3-C · 600 × 300 5.52228

Dead stock and sell-outs

Idle or zero
Idle lines
0
Sheets sitting
0
Cost tied up
0
On hand, last movement before 13 April 2026
SheetOn handLast saleDays idleCost
Blue laminate 8 mmLAM-BU-8 · 2800 × 2070224 Aug 2025412£140
Green foam board 5 mmFOM-GN-5 · 2440 × 12201113 Dec 2025301£198
Copper-tone composite 3 mmCMP-CU-3 · 2440 × 1220327 Jan 2026256£162
Red acrylic 3 mmACR-RD-3 · 2440 × 1220611 Mar 2026213£252
Yellow acrylic 5 mmACR-YL-5 · 1830 × 122083 Apr 2026190£304
Opal polycarbonate 3 mmPC-OP-3 · 3050 × 205045 Apr 2026188£384

Ranked by last goods-out. These are not in the forecast, because a zero balance has no cover to project.

Recently sold out Zero on hand
SheetLast saleDays agoWas / weekAsk
Clear acrylic 5 mmACR-CL-5 · 2440 × 12209 Oct 202615.4Yesterday
Silver composite 3 mmCMP-SV-3 · 3050 × 15007 Oct 202632.1Chase
White foam board 3 mmFOM-WH-3 · 2440 × 12204 Oct 202664.0Chase
Clear polycarbonate 6 mmPC-CL-6 · 3050 × 20501 Oct 202691.6Watch
White laminate 10 mmLAM-WH-10 · 3050 × 132026 Sep 2026140.9Watch

Full-sheet churn

Cuts excluded

Same masters as the forecast, rated on full-sheet sales only. Cover lengthens because offcuts and cut-to-size jobs are not mixed into the master rate.

Master sheets
0
Cut lines hidden
0
Clear 3 mm cover
10 days
Was 5 days with cuts in
Full size only · slower weekly rate
Master sheetFull / weekMixed / weekStockFull cover
Clear acrylic 3 mm2440 × 12202.96.2410
Clear polycarbonate 4 mm3050 × 20502.13.5413
White acrylic 3 mm2440 × 12201.82.6519
White composite 3 mm3050 × 15001.52.8523
Smoke acrylic 5 mm3050 × 20501.01.4321
White foam board 10 mm2440 × 12201.41.620100
Grey laminate 8 mm2800 × 20700.81.2326
Black foam board 5 mm2440 × 12200.60.814163
Black composite 3 mm3050 × 15000.50.711154
Bronze polycarbonate 6 mm3050 × 20500.40.59158
Oak-grain laminate 10 mm3050 × 13200.30.47163

Lead time by prefix

Supplier days
PrefixFamilyDays
ACRCast acrylic
PCPolycarbonate
FOMFoam board
CMPComposite panel
LAMLaminate
What 21 days does to acrylic

These two masters sit between 7 and 21 days of cover. They stay off the list at the current lead, and join it when acrylic moves to 21.

SheetCoverAt this lead
White acrylic 3 mm13Still covered
Smoke acrylic 5 mm15Still covered
Apply
Change a prefix, then apply

How it works

  1. Read the saved stock, the stock movements and the lead time in days for each product code group.
  2. Work out a weekly sales rate over the recent period and a projected sell-out.
  3. Flag lines that should be ordered before the lead time runs out.
  4. List stock on hand with no recent sale, and zero-stock lines ranked by last sale.
  5. Repeat the sales rate for full-size sheets only, using the original sheet sizes.

Pipeline

flowchart LR
  A[Movements] --> B[Weekly rate]
  C[Stock on hand] --> D[Sell-out date]
  B --> D
  E[Lead time] --> F[Reorder list]
  D --> F
  C --> G[Dead stock]
  C --> H[Full sheets]