Most pet care facilities run three businesses under one roof — boarding, daycare and grooming — and they don't behave alike. Boarding is high-ticket and capacity-bound; daycare is steady recurring volume; grooming is appointment-driven and labor-intensive. This dashboard shows how revenue and margin split across the three, how the mix is trending, and how it differs site to site, so you know which line to grow and which is quietly carrying or dragging the others.
What this dashboard answers
The mix page shows total revenue with each service line's revenue share, a donut of the overall split, a trend of revenue by service line over time, and a clustered comparison of service mix by location. The margin page adds transaction count and gross margin rate, ranks margin by service line, compares revenue against direct cost per line, and shows a location-by-service matrix as a share of each location's total — so you can see, for example, that one site is overwhelmingly boarding while another leans on grooming.
The metrics that matter
Revenue share tells you where the dollars come from; gross margin rate tells you which of those dollars are worth most. The two often disagree — grooming can be a smaller revenue share but a higher-margin one, or boarding can dominate revenue while its margin is squeezed by labor and overhead. Watching share and margin together is how you decide where to add capacity, where to raise rates, and which line a given location should lean into.
Why the data is trapped
Booking systems record revenue per transaction, but service lines are often tangled together on a single stay ticket — a boarding stay with an exit-bath groom and a daycare day attached — so a clean boarding-vs-daycare-vs-grooming split takes deliberate categorization that the standard reports don't do. Direct cost almost never lives in the booking tool at all; it sits in payroll and a spreadsheet. Bringing revenue and cost together by service line and location is exactly the modeling step this report handles.
How to read it
Start with the revenue-share donut for the shape of the business, then jump to gross margin rate by service line to see which share is actually profitable. Read the location-by-service matrix to spot sites that are over-concentrated in one line — a concentration risk and a growth hint at once — and watch the trend to catch a line that's quietly shrinking before it shows up in the bank. The sample uses entirely synthetic data, so there are no real financial records in what you see here.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Revenue | All revenue across every service line and location in the period. |
| Boarding Revenue Share | Boarding revenue ÷ total revenue — boarding's share of the business. |
| Daycare Revenue Share | Daycare revenue ÷ total revenue — daycare's share of the business. |
| Grooming Revenue Share | Grooming revenue ÷ total revenue — grooming's share of the business. |
| Transactions | Count of revenue transactions across the period. |
| Gross Margin Rate | (Revenue − direct cost) ÷ revenue — the share of revenue left after direct service cost. |
Used by: Owners and operators; finance
Frequently asked questions
Why split revenue by service line instead of looking at one total?
Because boarding, daycare and grooming have different economics — different ticket sizes, capacity limits, labor intensity and margins. A single revenue total hides which line is growing, which is most profitable, and which a particular location should lean into. Splitting it turns one number into a set of decisions.
What's the difference between revenue share and gross margin rate?
Revenue share is each service line's portion of total revenue — where the dollars come from. Gross margin rate is revenue minus direct cost over revenue — how much of each line's dollars you keep. They frequently disagree, which is why a smaller, higher-margin line can matter more than a larger, thinner one.
Can I see how the service mix differs between my locations?
Yes. The report includes a location-by-service-line matrix shown as a share of each location's total, so you can see at a glance that one site is mostly boarding while another leans on grooming. That exposes concentration risk and shows where each site has room to grow an underweight line.
Build this report on your own data
Clone this Pet care facilities template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →