Optical / Vision Retail
Starter

Veltrowin Optical

Exam volume, eyewear capture, lab turnaround, and vision plans

50% OFF
$6.00
$3.00USD, plus applicable tax
Buy Now
8 tables88K rowsParquet + CSV

About Veltrowin Optical

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.

Operating Profile

  • Generates roughly $5.0M to $6.0M gross eyewear sales alongside about $2.4M in eye-exam fees across six offices.
  • Carries roughly 90 products across frames, sunwear, lenses, and coatings, split into active, clearance, and end-of-life SKUs on their own demand curves.
  • Dispenses each eyewear order as a frame plus its lens work, with lab jobs joined back to the exact order line each fabricates.
  • Fabricates through two in-house labs and two outsourced labs, with the in-house labs about a day faster at a lower remake rate.
  • Turnaround and on-time measures count only completed lab jobs, so unfinished work never inflates them.
  • Bills 14 fictional vision plans plus self-pay on low-PII patient records with no names, addresses, or clinical history.

Recent Business Events

  • 1Back-to-school demand lifts exam volume and eyewear capture each year, especially for everyday frames and progressive lenses.
  • 2Year-end benefit expiry drives a second eyewear surge as patients use remaining vision-plan allowances before reset.
  • 3Sunwear sales peak in the late-spring and summer months and fall back in winter.
  • 4The optical lab sees turnaround pressure during peak periods, with rush and remake jobs running longer than standard single-vision work.
  • 5A newer office ramps from its mid-window opening while steady new-patient acquisition lifts exams, orders, and revenue by about a third.
KPI Focus Areas

These are the operating questions this kit is optimized to answer first.

01Focus

Exam volume, exam fees, covered amount, out-of-pocket, and refraction change by age band

02Focus

Eyewear capture rate, units sold, net revenue, gross margin amount, and gross margin rate

03Focus

Product-line and brand ranking, coating attach rate, and discount depth by catalog status

04Focus

Lab turnaround days, on-time rate, and remake rate by facility and job type

05Focus

Vision-plan mix, network status, allowance usage, and self-pay share

06Focus

Office and region comparison across exams, eyewear revenue, and lab load

Embedded Analytical Stories

Exam-to-eyewear capture

Capture rate on completed exams tracks the order count office by office, and a larger refraction change lifts capture from 51% to 76%.

Growth and seasonality

Back-to-school and benefit-expiry peaks ride on a rising base as new patients join, separating trend from season.

Lab operations tension

In-house labs beat the outsourced labs on turnaround, late deliveries, and remakes, putting the regional lab on the watchlist.

Vision-plan economics

In-network, out-of-network, and self-pay paths change covered amounts, allowances, and out-of-pocket.

Product-line margin

Frame, sunwear, lens, and coating lines compare on units, net revenue, and gross margin for merchandising.

Catalog lifecycle

Active, clearance, and end-of-life SKUs separate on demand and markdown, so assortment and pricing decisions are visible side by side.

Veltrowin Optical
$3.00USD, plus applicable tax
Buy Now