One of the most effective projects our team worked on involved helping a multi-location optical retailer who struggled with uneven stock levels. Some stores carried slow-moving frames for months, while fast-moving styles ran out before the next shipment arrived. They had data, but it wasn't being used to guide decisions. We started by pulling two years of sales history, supplier lead times, return rates, and seasonality patterns. Once everything was cleaned and mapped properly, we built a simple model that showed which SKUs truly drove revenue and which ones only took up shelf space. The metric that changed everything was Sell-Through Rate. It sounds basic, but measuring how quickly each frame style moved compared to the quantity purchased revealed problems they never noticed: - Some "popular" styles only felt popular because staff liked recommending them, not because they sold fast. - A few lower-priced frames had the highest sell-through and were constantly out of stock. - High-end frames with low sell-through tied up too much cash for too long. - Lead-time variability showed which suppliers caused unexpected stockouts. Once this metric became part of their weekly routine, ordering decisions became far more objective. Slow movers were phased out, fast movers were reordered earlier, and they reduced total inventory by around 18% without hurting availability. For them, sell-through became the clearest signal of what to keep, what to phase out, and where cash was getting stuck. It was simple enough for the staff to adopt, but powerful enough to guide better buying decisions across all locations.
Inventory decisions become clearer when the numbers reflect real patient behavior instead of guesses, and at A S Medication Solution we have seen how data can steady a system that once felt unpredictable. An optometry clinic we support learned this after months of running short on certain frame styles while overstocking others. They began tracking a simple metric that changed everything: turnover rate by category rather than by individual SKU. Frames in the mid price range with flexible hinges were moving nearly twice as fast as the premium lines, even though staff assumed the opposite based on a few memorable sales. Once they shifted ordering to match that pattern, their stockouts dropped and their carrying costs lowered within a quarter. The clinic manager said it was the first time the inventory finally felt aligned with what patients actually chose, not what the team expected them to choose. A single metric revealed the rhythm of demand, and it gave them the confidence to order smarter, free up shelf space, and reduce waste. Data did not replace judgment. It grounded it, which is the same principle that guides our medication planning for patients every day.
I'm a retailer, and I have a significant business in the optical field. We rely a lot on available data and its analysis to improve the management of our inventory and make it more responsive. We do not order frames these days based on supplier tasks and our own assessment. We track down SKU-level sales in all our branches by brand, style, price of frame, and segment. We then use this data to make our purchase orders and decide on replenishing our inventory. The most valuable piece of information is the frame turn rate. It shows how many times a frame was sold from our inventory in a specific time. Once we started measuring this rate and made comparisons, we instantly came to know about all our items. It made us comfortable deciding which product actually sells and which products just hold our investment by staying on shelves. We then started setting targets for turn rates and reallocated display spaces to high performers. It slowly phased out slow performers. This simple step reduced dead stock and improved cashback. It also improved customer response, as they always see a fresh piece. Simply saying, this one metric helped us set our team goals. It also made our inventory our biggest advantage rather than it being a costly programme.
The biggest change happened when we stopped looking at frame sales on their own and started keeping track of sell-through by board position. In almost every dispensary I've worked with, the frame's performance is affected as much by where it sits as by the frame itself. We found that several slow-moving lines weren't weak products at all; they were just in the wrong visibility zones after we mapped sell-through to placement. We saw an immediate rise in categories that had been stuck for months when we changed the boards based on this metric. It also helped us cut down on reorders in areas that looked busy but weren't making sales. That one piece of information helped us get a better picture of real demand and kept us from stocking up on things we didn't need.