Exam volume, eyewear capture, lab turnaround, and vision plans
Industry
Optical / Vision Retail
Company size
Small multi-office optical group
Modeled footprint
6 offices
Patients
About 9,000 low-PII patient records
Catalog
About 90 frames, lens packages, and coatings
Vision plans
14 plans plus self-pay
Modeled scale
About $5.5M gross eyewear sales over two years
Veltrowin Optical is a fictional small optical group built for BI teams that want credible vision-care retail data without enterprise or electronic-health-record clutter. The group runs eye exams, sells frames and lenses, fabricates lenses through an optical lab, and bills against vision-insurance plans across six fictional offices. All offices, brands, lens lines, vision plans, providers, and patients are invented for analytics demos and do not represent any real company, payer, or person.
These are the operating questions this kit is optimized to answer first.
Capture rate on completed exams tracks the order count office by office, and a larger refraction change lifts capture from 51% to 76%.
Back-to-school and benefit-expiry peaks ride on a rising base as new patients join, separating trend from season.
In-house labs beat the outsourced labs on turnaround, late deliveries, and remakes, putting the regional lab on the watchlist.
In-network, out-of-network, and self-pay paths change covered amounts, allowances, and out-of-pocket.
Frame, sunwear, lens, and coating lines compare on units, net revenue, and gross margin for merchandising.
Active, clearance, and end-of-life SKUs separate on demand and markdown, so assortment and pricing decisions are visible side by side.