How to calculate optical inventory turnover and act on slow stock

Article at a Glance

• Annual frame unit turn = frames sold in 12 months ÷ average frames on hand for that period.
• Read the ratio with stock age and availability; a high or low turn alone does not tell you what to order.
• For slow lines, check demand, assortment, margin, and vendor return terms before the next order.

A frame board can look full and still leave an optician without the styles patients ask for. Meanwhile, a collection that rarely sells can occupy space and cash that could support a better mix. Optical inventory turnover helps you see how quickly frames move, but the useful decision starts after you calculate the number.

You do not need a complicated model to begin. Start with a consistent 12-month sales window, a matching measure of frames on hand, and a frame line or category you can act on. Then read the result alongside the age of the stock and the availability patients actually experience.

What optical inventory turnover measures

Frame turnover estimates how many times a practice sells through its average frame stock during a defined period. It is a measure of movement, not a grade for the whole optical. A low turn may mean a line is overstocked, but it can also reflect a recently introduced collection or a deliberate premium assortment. A high turn can show strong demand, or a board that runs short too often.

Calculate the measure for a useful group, such as a frame line, brand, or price band, rather than relying only on one practice-wide ratio. Keep the group and location consistent in both the sales count and the inventory count. Frames, contact lenses, and lenses should not share one denominator when the decision is which frames to buy.

Calculate annual frame turns from units sold

Gather sales and stock for the same period

Pull frames sold over the last 12 months and remove returned or canceled units if your sales count includes them. Match the same frame line and location in the stock data. Count saleable display and backstock in on-hand inventory, treat transfers as stock movements rather than sales, and review consigned frames separately from owned frames. Keep sales and stock counts drawn from the same pool. Average beginning and ending frames on hand; if purchases or seasonality changed the board substantially, use monthly counts for a more representative average.

Annual frame unit turn = frames sold over 12 months ÷ average frames on hand. With a beginning and ending count, average frames on hand = (beginning frames + ending frames) ÷ 2. Use units on both sides; do not divide sales dollars by frame units.

Work through a frame-line example

Suppose Line A sold 360 frames in 12 months. It began with 140 frames and ended with 100, so its average on-hand stock was 120. Its annual unit turn is 360 ÷ 120, or 3.0. Line B sold 90 frames and averaged 90 on hand, for 1.0 turn. These are illustrative figures, not target rates.

Read the ratio beside age and availability

A turn rate does not show when individual frames arrived. Review the age of unsold styles, the date of the last sale, and the number of units still on the board or in backstock. A line with one sale every few months may have an acceptable aggregate ratio while particular colors or sizes remain untouched. That matters when you decide what to reorder.

Availability matters just as much. If a fast line is often out of stock, its high turn may represent missed sales rather than an ideal inventory level. If a slow line has substantial stock in a price range patients seldom choose, more purchasing will extend the problem. Compare like with like: premium and value frames, sunwear, and patient mix can behave differently.

Make a line-level purchasing decision

Start with the question the ratio raises. For a fast-selling line, check current stock, recent stockouts, supplier lead time, and whether the model is still available before increasing the order.

For a slow line, pause automatic replenishment and look at display placement, frame fit, color and size mix, price, and how long the units have been held. If the line no longer fits your assortment, ask the supplier whether an exchange or return is allowed under your agreement.

A measured promotion may make sense when return is unavailable, but compare the likely cash recovered with the margin you would give up. Retire a line when it no longer serves patient demand. Keep enough variety for patients who need a different fit or price point; reducing stock only to improve a ratio can create a worse shopping experience.

Record the action and revisit the same measure after a set interval. If the turn rises because you cleared old frames once, that is different from a line that now sells steadily at a sustainable stock level.

Keep unit turns separate from the financial ratio

The standard accounting inventory turnover ratio uses frame cost of goods sold divided by average frame inventory value at cost. That can help an owner review capital tied up in frames. The unit measure above answers a more immediate assortment question: how many frames sold relative to the frames carried. Both are useful, but they are not interchangeable. Keep the numerator and denominator in the same units and use matching time periods.

Conclusion

Frame turnover gives your team a starting point for better buying: calculate it consistently, look at what has aged or sold out, and choose the next order line by line. The goal is a frame board that serves patients without tying up more stock than the practice needs. RevolutionEHR supports optical inventory reporting, including review of best sellers and aging stock, alongside connected optical sales workflows. See how those tools can support your dispensary’s review and ordering process by requesting a RevolutionEHR demo.