System Overview
5-location performance summary · Operations Oil Change
Total System Revenue
$1.92M
↑ 5 locations generating
Total Franchise Fees Paid
$157K
8.2% of gross revenue
System EBITDA
$163K
↑ 8.5% blended margin
Avg Ticket (system)
$73.40
⚠ $0.60 below $74 target
Annual Tickets (system)
26,460
↑ 490 avg/mo per location
Locations Needing Attention
2
Pinecrest · Riverside
Revenue by Location
EBITDA Margin by Location vs. System Avg
Labor % vs. System Average (32.5%)
Franchise Fee Burden by Location
Cross-Location Benchmarking
How does each location compare to the system and top performers?
Revenue & Volume
| Store | Annual Revenue | Tickets/Yr | Avg Ticket | Rev/Bay | vs. Target |
|---|---|---|---|---|---|
| Store 1 – Northgate | $433,590 | 5,820 | $74.50 | $72,265 | On target |
| Store 2 – Riverside | $299,752 | 4,210 | $71.20 | $59,950 | ⚠ Low ticket |
| Store 3 – Oakwood ★ | $649,572 | 8,140 | $79.80 | $81,197 | Top performer |
| Store 4 – Pinecrest | $203,832 | 2,980 | $68.40 | $50,958 | ⚠ Below target |
| Store 5 – Lakeview | $388,161 | 5,310 | $73.10 | $64,694 | Near target |
| System Avg | $394,981 | 5,292 | $73.40 | $65,813 | $74 target |
Margin Comparison vs. System Benchmarks
| Store | COGS % | Labor % | Fees % | EBITDA % | EBITDA ($) | Status |
|---|---|---|---|---|---|---|
| Store 1 – Northgate | 29.8% | 31.8% | 8.2% | 9.3% | $40,324 | Healthy |
| Store 2 – Riverside | 31.2% | 34.1% | 8.3% | 6.4% | $19,184 | Watch list |
| Store 3 – Oakwood ★ | 27.1% | 29.8% | 8.1% | 14.1% | $91,590 | Star ★ |
| Store 4 – Pinecrest | 33.8% | 38.7% | 8.4% | -1.2% | ($2,446) | Critical ⚠ |
| Store 5 – Lakeview | 30.5% | 32.8% | 8.2% | 8.0% | $31,053 | On track |
| System Avg | 30.5% | 33.4% | 8.2% | 8.5% | $35,941 | Benchmark |
| Franchisor target | ≤ 30.0% | ≤ 32.5% | ≈ 8.2% | ≥ 8.2% | — | — |
P&L by Location
Full income statement with franchise fee breakdown
Franchise Fee Breakdown — The Cost of the License
| Store | Gross Revenue | Royalty (6%) | Mktg Fund (2%) | Tech Fee | Total Fees | Fees % Rev | Net Revenue |
|---|---|---|---|---|---|---|---|
| Store 1 – Northgate | $433,590 | $26,015 | $8,672 | $4,740 | $39,427 | 9.1% | $394,163 |
| Store 2 – Riverside | $299,752 | $17,985 | $5,995 | $4,740 | $28,720 | 9.6% | $271,032 |
| Store 3 – Oakwood ★ | $649,572 | $38,974 | $12,991 | $4,740 | $56,705 | 8.7% | $592,867 |
| Store 4 – Pinecrest | $203,832 | $12,230 | $4,077 | $4,740 | $21,047 | 10.3% | $182,785 |
| Store 5 – Lakeview | $388,161 | $23,290 | $7,763 | $4,740 | $35,793 | 9.2% | $352,368 |
| TOTAL SYSTEM | $1,974,907 | $118,494 | $39,498 | $23,700 | $181,692 | 9.2% | $1,793,215 |
Full P&L Summary
| Line Item | Northgate | Riverside | Oakwood ★ | Pinecrest | Lakeview | System Total |
|---|---|---|---|---|---|---|
| Gross Revenue | $433,590 | $299,752 | $649,572 | $203,832 | $388,161 | $1,974,907 |
| – Franchise Fees | ($39,427) | ($28,720) | ($56,705) | ($21,047) | ($35,793) | ($181,692) |
| – COGS (Parts & Fluids) | ($129,210) | ($93,523) | ($176,034) | ($68,895) | ($118,389) | ($586,051) |
| – Labor & Payroll | ($137,882) | ($102,215) | ($193,572) | ($78,883) | ($127,317) | ($639,869) |
| – Rent & Occupancy | ($38,400) | ($32,400) | ($52,800) | ($28,800) | ($36,000) | ($188,400) |
| – Other Operating | ($21,500) | ($18,300) | ($28,300) | ($17,300) | ($20,400) | ($105,800) |
| EBITDA | $67,171 | $24,594 | $142,161 | ($10,093) | $50,262 | $274,095 |
| EBITDA Margin | 15.5% | 8.2% | 21.9% | -5.0% | 12.9% | 13.9% |
Cash Flow Forecast
12-month rolling cash position with seasonal adjustments
Monthly Net Cash Flow
Cumulative Cash Position (Year)
Break-Even Analysis
How many tickets does each location need to cover all costs?
Northgate
3,614
BE tickets/yr
✅ +2,206 buffer
Riverside
3,549
BE tickets/yr
⚠ +661 buffer
Oakwood ★
3,921
BE tickets/yr
✅ +4,219 buffer
Pinecrest
3,108
BE tickets/yr
⚠ -128 below BE!
Lakeview
3,416
BE tickets/yr
✅ +1,894 buffer
Break-Even vs. Actual Performance
Break-Even Detail Table
| Store | Avg Ticket | Var Cost % | Contribution/Ticket | Fixed Costs | BE Tickets/Yr | BE Tickets/Mo | Actual Tickets | Margin of Safety |
|---|---|---|---|---|---|---|---|---|
| Northgate | $74.50 | 69.0% | $23.10 | $83,500 | 3,614 | 301 | 5,820 | 61.0% |
| Riverside | $71.20 | 71.5% | $20.29 | $72,040 | 3,549 | 296 | 4,210 | 15.7% |
| Oakwood ★ | $79.80 | 65.9% | $27.22 | $106,700 | 3,921 | 327 | 8,140 | 51.8% |
| Pinecrest | $68.40 | 74.9% | $17.18 | $53,440 | 3,108 | 259 | 2,980 | -4.1% ⚠ |
| Lakeview | $73.10 | 70.5% | $21.55 | $73,600 | 3,416 | 285 | 5,310 | 35.7% |
KPI Heatmap
At-a-glance health check across all locations and metrics
Performance Heatmap — Green = at target · Amber = within 10% · Red = off target
KPI
Northgate
Riverside
Oakwood ★
Pinecrest
Lakeview
Sys Avg
Avg Ticket ($74+ target)
$74.50
$71.20
$79.80
$68.40
$73.10
$73.40
COGS % (≤30% target)
29.8%
31.2%
27.1%
33.8%
30.5%
30.5%
Labor % (≤32.5% target)
31.8%
34.1%
29.8%
38.7%
32.8%
33.4%
EBITDA Margin (≥8.2% target)
15.5%
8.2%
21.9%
-5.0%
12.9%
13.9%
Franchise Fees % Rev
9.1%
9.6%
8.7%
10.3%
9.2%
9.2%
Rev per Bay ($60K+ target)
$72,265
$59,950
$81,197
$50,958
$64,694
$65,813
Monthly Tickets (350+ target)
485
351
678
248
443
441
Alerts & Performance Flags
Automated insights — what OperatorIQ surfaces proactively
Store 3 – Oakwood ★
Top Performer
Highest revenue ($649K), best EBITDA margin (21.9%), lowest COGS at 27.1%. This is your model location. Benchmark all others against Oakwood's operating practices. Revenue per bay is $81K — 24% above system average.
Store 4 – Pinecrest ⚠
Critical Attention
Currently operating below break-even (-128 tickets/yr). Labor at 38.7% vs 32.5% target — estimated $18,400 annual overspend. Newest location (1 yr). Immediate action needed: staffing model review and ticket volume plan. Monthly monitoring recommended.
Store 2 – Riverside ⚠
Watch List
Average ticket at $71.20 vs $74 system target — $2.80 gap × 4,210 tickets = $11,788 annual revenue opportunity. Add premium service upsells (cabin air filter, wiper blades, tire rotation). Low margin of safety at 15.7% means a slow month becomes a cash issue.
System-Wide Alerts
| Priority | Location | Alert | Est. Annual Impact | Action |
|---|---|---|---|---|
| Critical | Pinecrest | Operating below break-even — EBITDA negative at -$10,093 | $10,093 loss | Staffing audit + volume plan |
| High | Pinecrest | Labor % at 38.7% — 6.2 points above target | $12,638 excess | Review scheduling & overtime |
| Medium | Riverside | Avg ticket $2.80 below system — upsell opportunity | $11,788 upside | Upsell training program |
| Medium | Riverside | Margin of safety at 15.7% — thin cash buffer | Risk exposure | Build cash reserve 60 days |
| Info | All Locations | Franchise fees consuming 9.2% of revenue — above 8.2% internal target | $19,800 delta | Review tech fee allocation |
| Positive | Oakwood | COGS at 27.1% — best in system, 2.9 pts below target | $18,838 savings | Share vendor practices system-wide |
Performance Forecast
System-wide revenue, cash, and KPI projections — Base, Upside & Risk scenarios
Horizon:
FY 2025–2026
Base Case — 12 Mo Revenue
$2.01M
↑ Current trajectory · +4.8% growth
Upside Case — KPIs Fixed
$2.24M
↑ Labor + ticket improvements · +16.7%
Risk Case — Problems Compound
$1.87M
↓ Pinecrest + Riverside deteriorate · -2.6%
Revenue Forecast — Three Scenarios
Includes seasonal adjustment · Dashed = projected
Projected Cash Position
⚠ Shaded weeks indicate royalty payment compression
EBITDA Margin Trajectory
System blended margin vs. 8.2% target
KPI Improvement Impact — What Fixing Each Issue Is Worth
| Issue | Location | Current | Target | Gap | Annual $ Impact | 12-Mo Forecast Uplift | Priority |
|---|---|---|---|---|---|---|---|
| Labor % above target | Pinecrest | 38.7% | 32.5% | +6.2 pts | ($12,638) | +$12,638 | Critical |
| Below break-even volume | Pinecrest | 2,980 tix | 3,108 tix | -128 tix | ($2,200) | +$2,200 | Critical |
| Avg ticket below system | Riverside | $71.20 | $74.00 | -$2.80 | ($11,788) | +$11,788 | High |
| Labor % above target | Riverside | 34.1% | 32.5% | +1.6 pts | ($4,796) | +$4,796 | Medium |
| COGS above target | Pinecrest | 33.8% | 30.0% | +3.8 pts | ($7,745) | +$7,745 | Medium |
| Total Recoverable Value if All Issues Fixed | +$39,167 | Upside | |||||
Pinecrest Break-Even Trajectory — Months to Profitability
At current trajectory, Pinecrest reaches break-even in:
Base Case
Month 7
With seasonal revenue lift
Upside Case — Fix Labor + Volume
Month 3
With staffing model correction
Risk Case — No Action Taken
Never
Loss compounds without intervention