Not all SKUs are created equal—here’s how to separate revenue drivers from silent cost centers.
For glass, ceramic, and refractory distributors, managing inventory isn’t just a matter of how much you carry—it’s about how well your inventory performs. Traditional metrics like turns and stockouts don’t capture the full picture. What’s needed is a system that scores inventory health in a way that connects warehouse activity to strategic value. Enter inventory health scoring.
Inventory health scoring is a composite measurement that evaluates each SKU based on criteria such as sales velocity, margin contribution, order frequency, demand consistency, supplier reliability, and carrying cost. Think of it as a credit score for your products—but instead of predicting default, it predicts strategic value.
Distributors of technical ceramics or specialty glass panels can have thousands of SKUs. Some are custom-ordered for single-use applications (e.g., alumina tubes for a research lab or anti-reflective glass for museum cases), while others—like float glass or insulating firebricks—turn over monthly. But many sit in the middle: slow-moving, medium-margin SKUs that feel essential, but may be draining capital and space.
An inventory health score helps you assign numerical weight to these gray-zone items. For example:
Sales Velocity (25%) – How often does the item sell over a rolling 12-month period?
Gross Margin Return on Investment (GMROI) (20%) – Is the SKU profitable relative to its storage cost?
Customer Count (15%) – Is the SKU purchased by multiple clients or just one?
Stockout History (15%) – Is the item regularly unavailable when ordered?
Supplier Lead Time/Variability (15%) – Is replenishment dependable?
Carrying Cost Burden (10%) – How much warehouse and capital does the SKU consume?
Each SKU is then scored from 0–100. Scores below 40 indicate at-risk or underperforming inventory, while scores above 75 suggest strategic performers. This system helps glass distributors determine which tempered variants to stock deeply, which ceramic crucibles to keep lean, and which refractory mixes might be candidates for phased retirement or MOQ changes.
An Ontario-based refractory distributor used this model to reevaluate their dense firebrick portfolio. They found that nearly 20% of their SKUs had high carrying costs and low order frequency, primarily tied to small-volume clients. Post-analysis, they consolidated those SKUs into a “special order only” program—clearing 1,500 square feet of warehouse space and reallocating that capital into fast-moving, high-score insulating castables.
The real power of inventory scoring is when it’s layered into strategic planning:
Need to improve working capital? Retire or rationalize low-score SKUs.
Looking to boost service levels? Prioritize restocking of high-score items.
Planning for supplier renegotiations? Focus terms on SKUs with strong sales velocity and margin ratios.
:
Inventory health scoring turns data into action. It gives glass, ceramics, and refractory distributors a defensible framework for deciding what to stock, what to scale back, and what to sunset. In a sector where margins are tight and freight is costly, knowing your inventory’s health isn’t a luxury—it’s a competitive necessity.
