Frame Stock: Age in Days, Ageing Buckets with IFS, Markdowns & Stock Turns
This lesson is part of the course
In this lesson
You 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.
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