Varrowtail Pet Supply
Pet retail sales, loyalty, grooming, and weekly replenishment
About Varrowtail Pet Supply
Industry
Pet Specialty Retail
Modeled retail sales
about $8.1M in gross retail sales across the two-year window, about $674K per store per year
Company size
Small neighborhood chain
Modeled footprint
5 stores plus 1 online store
SKU range
60 limited pet-supply products
Loyalty members
about 900 modeled members
Grooming
in-store service at the 5 physical stores, used by about 48% of loyalty members
Net retail revenue
about $7.9M net of discounts, roughly $3.9M a year
Grooming revenue
about $1.0M modeled service revenue across the window, roughly $50K per grooming station a year
Trading density
about 24 transactions per store per day chain-wide, from a quiet 7 a day at the smallest store up to 42 at the flagship
Store pricing
each location prices off the national list price with its own multiplier, from 0.90 at the compact village store to 1.12 online, so average unit price runs $23.07 to $28.69 by store
Inventory cadence
complete weekly panel, all 360 product-store pairs across 104 weeks, with one-week and trailing-four-week velocity both tied to actual sales
Varrowtail Pet Supply is a fictional small pet specialty retailer built for BI teams that want credible neighborhood-chain retail data without enterprise-scale clutter. The company sells pet food and nutrition, treats and chews, toys and enrichment, habitat and bedding, grooming supplies, and health and wellness products through five physical stores and one online store, and runs an in-store grooming service for dogs and cats at its physical locations. It is a retail merchandising business: grooming is a booked retail service, not veterinary medical care, and the kit models no diagnoses, treatments, or clinical records.
Operating Profile
- Operates five physical pet supply stores and one online store across fictional metro, suburban, and lakeside markets.
- Carries a deliberately compact 60-SKU catalog so product mix, markdowns, and inventory decisions stay easy to inspect.
- Runs a loyalty program with about 900 low-PII members across four tiers, alongside walk-in guests; about 48% of members also use grooming.
- Offers in-store grooming at the physical stores and roughly two dozen seasonal promotions across the year.
- Tracks sales at transaction-line grain, grooming per appointment, and inventory as a gap-free weekly product-store panel.
- Uses low-PII loyalty data only, with no customer names, emails, addresses, payment records, or veterinary detail.
Recent Business Events
- 1Summer travel and outdoor demand lifted habitat, carrier, and hydration-style products and increased stockout pressure on bulky seasonal items.
- 2Holiday gifting raised toy and treat volume while reducing gross margin where promotion depth was highest.
- 3Loyalty members account for about 63% of net revenue, with baskets rising steadily by tier from walk-in through Platinum.
- 4The grooming service added a steady second revenue line, with visits climbing from about 11 per Bronze member to 32 per Platinum.
- 5Several discontinued or seasonal-closeout products remain useful for markdown and inventory-health analysis.
These are the operating questions this kit is optimized to answer first.
Net retail revenue, gross margin, discounts, and basket value by store and season
List price versus realized unit price, with each store's multiplier visible
Member share of net revenue, basket value by tier, and signup cohorts
Grooming volume, revenue, and duration by service, pet type, and member tier
On-hand units, weeks of supply, sell-through, stockout days, and 1- vs 4-week velocity
Embedded Analytical Stories
Seasonal demand curve
Steady consumables plus summer travel and holiday gifting cycles create visible monthly demand shifts.
Loyalty versus walk-in
Basket value climbs cleanly by tier from $68 walk-in to $85 Platinum, a spend story rather than an assortment story.
Grooming attach
About half the loyalty base books grooming, and among them appointment volume and retail spend move together at 0.55.
Promotion tradeoff
Each event discounts its featured department at full depth and the rest at a shallow halo, so effect is measurable.
Inventory pressure
An unbroken weekly panel shows which product-store slots are tight, healthy, overstocked, or at clearance risk, week over week.
Assortment lifecycle
Active, seasonal-closeout, and discontinued SKUs carry the excess cover, so clearance risk tracks lifecycle rather than the calendar.