Norrelva Veterinary Group
Vet visits, vaccinations, boarding, and clinic inventory
About Norrelva Veterinary Group
Industry
Veterinary Care
Company size
Fictional regional clinic group with 16 companion-animal clinics, 80 veterinarians, technicians, and assistants, and 34,000 registered pet patients, about 31,200 of them still active.
Service catalog
60 clinical services across exams, vaccinations, diagnostics, dentistry, surgery, treatment, and nursing care, priced from a $26 nail trim to $2,450 orthopedic surgery, plus 140 retail and pharmacy products.
Packaged scale
About 429,000 rows across 11 Standard-tier tables, including 150,000 visits, 70,000 vaccinations, 30,000 boarding stays, 90,000 retail sale lines, and a complete 53,760-row monthly inventory panel.
Revenue range
The two-year window carries roughly $32M to $36M in total visit revenue, about $17M per year, with a further $6.4M of boarding, $5.8M of gross retail ($5.7M net of discounts and returns), and $3.2M of vaccination revenue alongside it. Cancelled visits, cancelled and reserved stays, and cancelled or still-scheduled vaccinations all realize $0.
Operating footprint
Five fictional reporting regions covering metro, coastal, valley, and foothills areas.
Customer mix
Dog and cat households dominate, with a smaller share of rabbits, birds, small mammals, and reptiles. Around half the panel is on a wellness plan and a quarter carries pet insurance, with take-up highest on the youngest pets.
Norrelva Veterinary Group is a fictional companion-animal clinic group used for synthetic BI analysis. The company story is built around a regional network of neighborhood and full-service clinics, the providers who staff them, the pets and owners they care for, and the day-to-day mix of exams, vaccinations, boarding stays, retail sales, and stocked inventory. Everything here is invented for analytics practice. No real clinic, owner, pet, or staff member is represented.
Operating Profile
- Runs general practice, wellness, urgent care, dentistry and surgery, closing on the major federal holidays and running a reduced day on the minor ones.
- Case mix follows the patient: exotics to urgent care, cats and rabbits to dentistry, seniors to sick visits, with surgery always booked in clinic.
- Boards cats and small pets in the condo ward and dogs in runs and suites, with flagship sites carrying more exam rooms and kennels.
- Each site's lead veterinarian is credentialed for that clinic's focus, and part-time and relief staff carry a lighter caseload than full-timers.
- Billing follows the client record: only insured pets bill insurance, only enrolled pets settle on a plan, and returns post as reversing lines.
- Excludes patient charts, lab result detail, controlled-substance logs, rebate contracts, payroll, and full financial ledger.
Recent Business Events
- 1One flagship clinic has become the executive focus because its visit revenue is strong but its boarding kennels are running near capacity in summer.
- 2A push on wellness plans and vaccination reminders is changing the visit mix, raising questions about provider scheduling and recheck volume.
- 3Panel growth has been steered toward the larger sites, so exam-room density now sits in a tight band across the group.
- 4A client-retention review is under way after a cohort of long-standing owners stopped booking part-way through the window.
- 5Leadership wants one view connecting visit revenue, vaccination cadence, boarding demand, retail sales, and inventory health.
These are the operating questions this kit is optimized to answer first.
Visit volume, revenue, type mix, and visits per exam room by clinic, species, and life stage
Vaccination volume, doses, vaccine type mix, and upcoming due dates
Boarding stays, nights, kennel-class mix, and boarding revenue
Retail unit sales, gross and net line revenue, discounts, returns, and category mix
On-hand units, reorder signals, structural stock position, and stock status by clinic
Payment and plan mix, new-patient acquisition, and active versus lapsed clients
Embedded Analytical Stories
Visit revenue rises through spring and eases in winter and midsummer, and clinics close on the major federal holidays.
Visit revenue rises through spring and eases in winter and midsummer, and clinics close on the major federal holidays.
Boarding demand peaks in summer and the holidays, a clear contrast with the spring visit peak.
Boarding demand peaks in summer and the holidays, a clear contrast with the spring visit peak.
Life stage drives care
puppies run a vaccine series and wellness visits, seniors tilt to dentistry and sick visits.
Lapsed clients stop booking part-way through the window, so retention and win-back analysis has something to find.
Lapsed clients stop booking part-way through the window, so retention and win-back analysis has something to find.
Inventory sell-through and retail sales share one clinic-product-month key, so stock and sales questions stay in step.
Inventory sell-through and retail sales share one clinic-product-month key, so stock and sales questions stay in step.
Stock position belongs to the clinic-product pair, not the month
Flagship sites run tight on a third of snapshots, Satellites a tenth.