The optical is a retail business bolted onto a clinic, and like any retail business it lives or dies on margin. A designer frame that sells for more can carry a thinner margin than a house-brand frame, and a premium progressive with anti-reflective can be the most profitable line item in the store. But most practices price by feel and buy by relationship, because the margin numbers — by category, by brand tier, by supplier — are buried in the POS at the line-item level. This dashboard surfaces the retail economics behind every dispensed pair.
What this dashboard answers
The Margin by Category page answers the buyer's core question: where does the margin actually come from? It shows total margin dollars and rate alongside sales and cost, then breaks margin rate down by product category (frame vs lens vs contacts), margin dollars by frame brand tier, and margin rate by lens type — so the high-margin lines and the thin ones are obvious. The Supplier & Frame Board page turns to purchasing: margin rate by supplier, units by frame brand tier, and a per-supplier table with units, sales, cost, margin dollars, and margin rate, plus a frame-board turn metric that flags slow-moving inventory.
The metrics that matter
Gross margin rate is total margin dollars over total sales — a sum over a sum — so a few high-ticket pairs don't distort the blended rate. Margin dollars and margin rate tell different stories: a designer tier can drive the most dollars at the lowest rate, while a house brand drives the best rate on fewer dollars, and a healthy optical needs both. Frame-board turn (units per frame slot) is the inventory-velocity proxy that tells you whether the boards are working or just sitting.
Why the data is trapped across the systems
Line-item sales and cost live in the optical POS (Edge by GPN) and the dispensing tables of Eyefinity/OfficeMate, My Vision Express, or Acuitas (Ocuco); lab cost may sit in a lab-order feed; supplier and brand-tier attributes are often inconsistent free-text. Computing margin by category and supplier means joining sales to cost at the line level and standardizing the product attributes — work that no single screen in the POS does. So owners know their total optical sales but rarely their margin by tier, which is exactly the number that should drive buying and pricing.
How to read it
Read margin rate by category and lens type to see where the profit concentrates, then read margin dollars by frame brand tier to balance volume against rate — the goal is a board that drives both. Margin rate by supplier is your negotiation and consolidation lens: a low-margin, high-volume vendor is a conversation waiting to happen. Frame-board turn flags the slots that aren't earning their space. The sample uses fully synthetic line-item data with no real brand or supplier names, so there's nothing identifying in the report.
Metrics it tracks
| Metric | What it means |
|---|---|
| Gross Margin Dollars | Sale amount minus cost across all dispensing line items. |
| Gross Margin Rate | Total margin dollars divided by total sales dollars (a SUM-over-SUM ratio). |
| Optical Sales (COGS-bearing) | Frame, lens, and contact line-item sales. |
| Cost of Goods | Wholesale and lab cost across line items. |
| Units Sold | Total units across all line items. |
| Frame-Board Turn (Units per Frame Slot) | Units sold divided by the frame-board slots represented — a turnover proxy (SUM over SUM). |
Used by: Owner-ODs and optical buyers analyzing gross margin
Frequently asked questions
What's a healthy gross margin rate on optical?
Independent opticals generally aim for a strong blended margin across frames and lenses, but the rate varies sharply by tier — house-brand frames and AR lenses tend to carry the best margin, designer frames the thinnest. The point of the report is to see the spread by category, tier, and supplier rather than chase one number.
Why look at margin dollars and margin rate separately?
Because they can point in opposite directions. A designer tier can produce the most margin dollars at the lowest rate, while a house brand produces the best rate on far fewer dollars. A healthy board needs both, and seeing them side by side is how you balance the mix.
Can I build this on my own POS data?
Yes. Export your dispensing line items with sale and cost from your optical POS and use this as a template — we model it into a Power BI report. The sample uses synthetic data with no real brand or supplier names.
Build this report on your own data
Clone this Optometry & optical template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →