Multi-Site Center P&L Rollup Calculator

How do I use this with more than two sites?

Run pairwise comparisons or sum all sites into an 'A' bucket versus your best or worst performer as 'B' to isolate its impact on the blended average. For full multi-site tracking beyond two locations, this quick tool works best as a spot-check between your accounting system's proper consolidated reports.

What should count as 'operating cost' here?

Everything that hits the site P&L before corporate overhead allocation: staffing, facility, food program cost net of reimbursement, supplies, and site-level marketing. Leave out corporate-level costs like a shared marketing team salary or central admin, since those get allocated differently across a multi-site operator and would distort the site-level comparison.

A site with lower revenue but a higher margin % — is it actually doing better?

It depends on your goal. A smaller site running lean can post a higher margin percentage while contributing fewer total profit dollars than a larger site running a lower percentage on much bigger revenue. Look at both the percentage and the dollar contribution before deciding which site deserves more investment or attention.

How often should I run this kind of rollup?

Weekly or biweekly as a pulse check is common for multi-site operators, using estimated or flash numbers rather than waiting for a full month-end close. It won't be perfectly precise, but it surfaces a site drifting off plan two to three weeks earlier than a monthly closing cycle would.