Inventory forecasting for tile stores — without a data team

The three numbers

Velocity: how much a product sells per week, from your sales history — a 12-week average smooths out lumpy contractor buys. Lead time: how long the vendor takes from PO to your dock, honestly measured, not the promise. Safety stock: the buffer for a bad week — for most lines, one or two weeks of velocity.

Your reorder point is then: (velocity × lead time) + safety stock. A tile selling 20 boxes/week from a vendor with a 3-week lead time, plus 2 weeks of buffer, reorders at 100 boxes. When stock touches 100, a PO goes out — before the shelf is empty, not after.

Order quantity: think in turns, not truckloads

Order enough to cover the lead time plus your review cycle, weighed against freight breaks and storage. Over-ordering a winner is how winners become dead stock when the trend moves — in tile, fashion risk is real. Better to turn stock six times a year at a slightly worse freight rate than twice at the best one; turns beat markup.

Respect the seasons and the projects

Renovation demand swells in spring and fall and dips over holidays — compare against the same weeks last year, not last month. And in project-driven retail one contractor can distort a 12-week average; when a big job inflates velocity, mark it and judge the line on its underlying run rate.

Watch the tail, not just the leaders

Forecasting isn't only about never running out of best-sellers — it's noticing that a line's velocity fell to zero eight weeks ago. A monthly slow-mover report tells you what to stop reordering and what to mark down while it still sells at a discount.

Let the system carry the discipline

All of this is arithmetic on data your POS already has. In TilesPOS, sales history, live stock and low-stock alerts live together, and purchase orders generate automatically from reorder points — so forecasting becomes a monthly review of suggestions rather than a spreadsheet ritual.