Lens Options: Take Rates, Option Margins & Average Order Value with SUMPRODUCT
This lesson is part of the course
In this lesson
You 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.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Appointment Capacity: Slots per Day & Week, Booking Rate and No-Show Losses Locked
- Capture Rate: From Appointments to Eyewear Orders, by Appointment Type Locked
- Frame Pricing: Markup by Collection, Shelf Prices with MROUND & Margin % Locked
- Lens Options: Take Rates, Option Margins & Average Order Value with SUMPRODUCT Locked
- Contact Lens Plans: Subscribers, Churn, Monthly Recurring Revenue & Lifetime Margin Locked
- Frame Stock: Age in Days, Ageing Buckets with IFS, Markdowns & Stock Turns Locked
- Remakes & Returns: Remake Rate, Cost per Remake and the Effect on Margin Locked
- Practice P&L & Break-Even: Contribution per Order, Break-Even Orders & a Profit Chart Locked