Executive Overview · Q3 Close
The Ledger, Illuminated
Consolidated profit, margin and loss across every location, updated to the close of Q3.
Revenue by Segment
02 · Trend
Performance Trend
Revenue, net profit and margin across the trailing twelve months, with the two months that moved the ledger most.
Nov: Holiday staffing gap
Jan: Supply cost spike
03 · Comparison
Location Radar
A six-axis comparison across the top locations. Toggle a location to isolate its shape on the instrument.
04 · Structure
Cost Structure
Every dollar of revenue, accounted for. Labor carries the second-largest share, so its internal breakdown gets its own instrument alongside.
Every Revenue Dollar
Labor Cost by Role
Overtime premium is the smallest slice by share, but it is the fastest-growing labor line across the group. See Bottlenecks below for the root cause.
05 · Risk & Loss
Bottlenecks & Loss Analysis
Ranked by cost impact across the trailing 30 days. Click any reason to open its root-cause breakdown.
Total Identified Loss
−$1,085,850
Potential Recovery
+$452,000
Root Causes
Detail
Excess inventory preparation and inaccurate demand forecasting are driving high spoilage, particularly in perishables. Inconsistent portioning and poor stock rotation compound the loss.
Trend (Cost Impact)
Root Causes
Detail
Weekend prime-time tables held without deposit convert to no-shows at nearly 3x the weekday rate, holding capacity that could otherwise be walked-in or waitlisted.
Trend (Cost Impact)
Root Causes
Detail
Peak-hour understaffing forces premium overtime coverage across the group, concentrated at three locations with the least scheduling automation.
Trend (Cost Impact)
Root Causes
Detail
Discount authority is not tiered by role, allowing shift leads to apply comp-level discounts without a secondary approval step.
Trend (Cost Impact)
Root Causes
Detail
Service-recovery comps are trending upward at locations with longer average ticket times, suggesting the root cause is upstream in kitchen throughput, not guest relations.
Trend (Cost Impact)
Root Causes
Detail
Line-level portion drift above spec on high-COGS proteins is the smallest line item but the most directly fixable with a recipe-card audit.
Trend (Cost Impact)
06 · Locations
Location Leaderboard
Every location, ranked by revenue. Click a row to open its full financial and operational drill-down.
| Location | Revenue | Net Profit | Margin | Covers | Status |
|---|---|---|---|---|---|
| Marina DistrictWest Coast | $3,842,560 | $1,274,850 | 33.2% | 18,732 | Healthy |
| Uptown FlagshipNortheast | $4,956,210 | $1,642,770 | 33.1% | 21,894 | Healthy |
| Riverside TerraceMidwest | $2,716,450 | $872,310 | 32.1% | 13,482 | Healthy |
| Old Town BistroSoutheast | $1,237,890 | $192,340 | 15.6% | 7,891 | At Risk |
| Harbor ViewWest Coast | $1,985,540 | $612,880 | 30.9% | 11,203 | Healthy |
| Garden CourtSoutheast | $985,120 | $78,410 | 8.0% | 5,312 | At Risk |
