Optical & Eye-Care Practice Economics: Appointment Capacity, Capture Rate, Frame & Lens Margins, Contact Lens Plans, Frame Stock & Break-Even
Run the numbers of an eye-care practice and optical shop. You will plan appointment capacity, measure how many appointments lead to eyewear sales, price frames and lens options for margin, run monthly contact-lens plans, manage frame stock and ageing, and find the break-even, all with fictional data and every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course covers the business side of a fictional eye-care practice with an optical shop, with no clinical or vision content. You turn clinic hours into bookable slots with INT and price no-shows, measure the capture rate and revenue per appointment with COUNTIFS and SUMIFS, and price frames with a markup table, XLOOKUP and MROUND shelf prices while keeping markup and margin apart. You work out lens option take rates and average order value with SUMPRODUCT, roll contact lens plans forward with churn and recurring revenue, age frame stock with DAYS and IFS, cost remakes and returns, and finish with break-even orders and a monthly profit chart.
Lessons
- Appointment Capacity: Slots per Day & Week, Booking Rate and No-Show Losses Pro
- Capture Rate: From Appointments to Eyewear Orders, by Appointment Type Pro
- Frame Pricing: Markup by Collection, Shelf Prices with MROUND & Margin % Pro
- Lens Options: Take Rates, Option Margins & Average Order Value with SUMPRODUCT Pro
- Contact Lens Plans: Subscribers, Churn, Monthly Recurring Revenue & Lifetime Margin Pro
- Frame Stock: Age in Days, Ageing Buckets with IFS, Markdowns & Stock Turns Pro
- Remakes & Returns: Remake Rate, Cost per Remake and the Effect on Margin Pro
- Practice P&L & Break-Even: Contribution per Order, Break-Even Orders & a Profit Chart Pro