Optical & Eye-Care Practice Economics: Appointment Capacity, Capture Rate, Frame & Lens Margins, Contact Lens Plans, Frame Stock & Break-Even

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn the clinic days, hours and slot lengths of four fictional practitioners into bookable slots per day and week, measure the booking rate and put a yearly price on no-shows.
• Count appointments and eyewear orders per appointment type, measure the capture rate, turn order values into revenue per appointment and average order value, and name the type that earns the most per appointment.
• Price ten fictional frames with a markup factor per collection, round them to shelf prices that end in 9, measure the margin of each shelf price and work out the price a frame needs for the target margin.
• Measure how often each fictional lens option is chosen, the margin each option earns, the option revenue per order and the average order value, and see how the option mix drives the margin of a spectacle order.
• Roll three fictional monthly contact lens plans forward by one month, with cancellations from churn and new subscribers, and turn the subscribers into monthly recurring revenue, gross margin, annual recurring revenue and a lifetime margin per subscriber.
• Age twelve fictional frame lines with DAYS, sort them into buckets with IFS, value the stock, cost a markdown on the oldest frames and measure stock turns and days of stock.
• Build the cost of one remake from its fictional cost items, measure the monthly remake rate and remake cost, and compare the margin before and after remakes and returns for half a year.
• Add up the fictional practice's fixed costs, work out the contribution per spectacle order and the break-even orders per month, build a six-month P&L and chart the monthly profit.