Lavender Grill — Dashboard

Q1 2026 — Key Metrics

Total Revenue

$464,424

Q1 · Jan–Mar

Growing MoM

↓ Drill down

Net Profit

$169,948

36.6% margin

Strong Q1

↓ Monthly trend

Total Expenses

$294,476

Declining monthly

Trending Down

↓ Breakdown

Labour

$150,736

32.5% avg · Jan ⚠

Jan Over Target

↓ Trend

COGS

$85,377

18.4% avg

Verify Entries

↓ Food cost %

Prime Cost

50.9%

Target: below 65%

Excellent

↓ Details

Revenue Monthly

January

$145,979

February

$157,359+7.8%

March

$161,086+2.4%

Feb spike: Valentine's Day ($25K+ single day). March sustained growth heading into Q2.

Net Profit Monthly

January

$22,72815.6%

February

$63,92240.6%↑

March

$83,29851.7%*↑

*March inflated — rent $0 in QB. Confirm with accountant.

Expense Breakdown

Category	Jan	Feb	Mar
COGS	$38,675	$27,217	$19,484
Payroll	$52,720	$48,830	$49,186
Rent	$17,699	$8,850	$0 ⚠
Insurance	$1,735	$1,841	$1,313
Marketing	$544	$630	$200
Other	$10,525	$6,852	$7,121
Total	$83,898	$66,220	$58,304

Labour % of Revenue

January

$52,72036.1%⚠

February

$48,83031.0%✓

March

$49,18630.5%✓

Food Cost %

January

$38,67526.5%

February

$27,21717.3%

March

$19,48412.1%?

14-point swing likely reflects QB invoice timing errors.

Prime Cost Detail

COGS Q1 avg18.4%

Labour Q1 avg32.5%

Prime Cost Q1 avg50.9%

TargetBelow 65%

Status14.1pts below target ✓

Monthly Snapshot

January 2026

$145,979

Net: $22,728 (15.6%)

COGS: 26.5% · Labour: 36.1%
Prime Cost: 62.6%

Weakest

February 2026

$157,359

Net: $63,922 (40.6%)

COGS: 17.3% · Labour: 31.0%
Prime Cost: 48.3%

Strong

March 2026

$161,086

Net: $83,298 (51.7%)*

COGS: 12.1%* · Labour: 30.5%
Prime Cost: 42.6%*

*Rent $0

Profit & Loss Statement — Q1 2026

Total Revenue

$464,424

Total Expenses

$294,476

Net Profit

$169,948

Account	January	February	March	Q1 Total	% of Rev
INCOME
Dine-In Sales	$87,587	$94,415	$96,652	$278,654	60.0%
Bar / Alcohol	$29,196	$31,472	$32,217	$92,885	20.0%
Private Events	$14,598	$15,736	$16,109	$46,443	10.0%
Online / Delivery	$14,598	$15,736	$16,108	$46,442	10.0%
Total Revenue	$145,979	$157,359	$161,086	$464,424	100%
COST OF GOODS SOLD
Food Cost	$29,006	$20,413	$14,613	$64,032	13.8%
Beverage Cost	$9,669	$6,804	$4,871	$21,344	4.6%
Total COGS	$38,675	$27,217	$19,484	$85,377	18.4%
GROSS PROFIT
Gross Profit	$107,304	$130,142	$141,602	$379,048	81.6%
OPERATING EXPENSES
Payroll & Wages	$52,720	$48,830	$49,186	$150,736	32.5%
Rent / Lease	$17,699	$8,850	$0 ⚠	$26,549	5.7%
Insurance	$1,735	$1,841	$1,313	$4,889	1.1%
Marketing	$544	$630	$200	$1,374	0.3%
Other Operating	$10,525	$6,852	$7,121	$24,498	5.3%
Total OpEx	$83,223	$67,003	$57,820	$208,046	44.8%
NET PROFIT
Net Profit	$22,728	$63,922	$83,298	$169,948	36.6%

*March rent $0 in QB — net profit and margins unconfirmed until rent is reconciled.

Balance Sheet — Month-by-Month

January Assets

Cash$42,300

Accounts Rec.$8,200

Inventory$12,400

Total Assets$62,900

January Liabilities

Accounts Pay.$18,500

Accrued Exp.$6,200

Deferred Rev.$2,100

Total Liabilities$26,800

February Assets

Cash$78,400

Accounts Rec.$9,100

Inventory$11,200

Total Assets$98,700

February Liabilities

Accounts Pay.$14,200

Accrued Exp.$5,800

Deferred Rev.$3,400

Total Liabilities$23,400

March Balance Sheet

March Assets

Cash$142,100

Accounts Rec.$7,800

Inventory$10,600

Total Assets$160,500

March Liabilities

Accounts Pay.$12,100

Accrued Exp.$24,200 ⚠

Deferred Rev.$2,800

Total Liabilities$39,100

Owner's Equity

Jan Equity$36,100

Feb Equity$75,300

Mar Equity$121,400

Q1 Growth+$85,300

Q1 Trend

Cash growth+236%

Liabilities+46% Mar⚠

Inventory↓ Efficient

Net PositionStrong ✓

⚠ March accrued expenses ($24,200) spike likely includes unrecorded rent (~$17,699). Verify with accountant before Q2 close.

Labour Analysis

Labour $ — Monthly

January

$52,720

February

$48,830

March

$49,186

Labour % vs 28–35% Target

January36.1%

Over

February31.0%

Good

March30.5%

Good

Q1 Avg32.5%

28–35%

Q2 patio season (May–Aug): set a weekly labour $ cap per server before May opens.

COGS & Food Cost

COGS $ — Monthly

January

$38,675

February

$27,217

March

$19,484

Food Cost % vs 28–32% Target

January26.5%

Check

February17.3%

Low

March12.1%

Verify

Q1 Avg18.4%

28–32%

14-point swing Jan→Mar is outside normal variance. Reconcile QB invoice entries before Q2 menu pricing decisions.

Advisory Analysis — Q1 2026

Strengths — Low Risk

Revenue Growing 3 Months Straight$145K → $157K → $161K. Consistent upward momentum heading into patio season. Valentine's Day event showed strong event-driven revenue capability.

Prime Cost Well Below Target50.9% vs 65% target — 14 points of buffer. Even if COGS is underreported in QB, prime cost would still be ~60.5% at 28% food cost. Healthy operational efficiency.

Labour Corrected After JanuaryFeb (31%) and Mar (30.5%) are both within the 28–35% target. The January spike appears to have been addressed operationally.

Weaknesses — Medium Risk

QuickBooks Entry InconsistenciesRent entries ($17,699 → $8,850 → $0) and COGS swing (26.5% → 12.1%) suggest invoice timing errors. Financial reports cannot be fully trusted until QB is reconciled with actuals.

Low Marketing Spend$1,374 total for Q1 (0.3% of revenue) is very low for a restaurant. February ($630) was the peak — aligned with Valentine's Day. Consider structured monthly marketing budget of $1,500–$2,500.

January Labour Spike Not Root-Caused36.1% in January hasn't been explained. Was it over-staffing, low revenue, a one-time event payout, or seasonal? Without identifying the cause, it may recur in slower Q2 months.

Risks — High Risk

March Rent = $0 in QBIf rent of ~$17,699 was not paid in March, this is a lease compliance risk. If it was paid but not entered, your Q1 books are materially incorrect. Either way, this must be resolved before Q2 closes.

Patio Labour Spike Risk (Q2)Adding patio staff without a firm revenue forecast could push labour above 35% if footfall is slower than expected. Set a weekly labour $-cap before May opens — recommend $12,000/week maximum.

Recommended Actions

This Week: Call Accountant on March RentConfirm whether rent was paid and not entered, deferred, or accrued. Get the correct Q1 closing figures before May.

Before May: Set Patio Labour CapDefine max weekly labour $ per server for the patio season. Review weekly — not monthly. This is where margins get lost.

Q2: Push Private EventsEvents are your highest-margin revenue stream. Target 2 private events per month May–August. Each event at $5K+ adds ~$3.5K net profit at current margins.

Q2: Renegotiate InsuranceInsurance varied $1,313–$1,841/month. A single annual policy would stabilize this and likely save $800–$1,200/year. Get 2 quotes before renewal.

Auto-Detected Flags

⛔

March Rent = $0 — CriticalJan $17,699 · Feb $8,850 · Mar $0. Contact accountant this week.

⛔

January Labour = 36.1%Exceeds 35% target. Root cause unidentified — risk of recurrence.

⚠

COGS Swing 26.5% → 12.1%14-point drop over Q1 is outside normal range. Likely QB invoice entry timing. Reconcile before planning.

⚠

February Rent = $8,850 (Half of Jan)Inconsistent rent entries distort monthly expense analysis.

✓

Prime Cost Q1 = 50.9%Well below 65% target. Even adjusted for real COGS, still ~60.5%.

✓

Revenue Growing 3 Months Straight$145K → $157K → $161K. Strong momentum into Q2.

Benchmark Summary

Metric	Q1 Actual	Target	Status
Food Cost %	18.4%	28–32%	⚠ Verify QB
Labour Cost %	32.5%	28–35%	✓ On target
Prime Cost %	50.9%	<65%	✓ Excellent
Net Margin	36.6%*	15–25%	✓ Above avg

Year Comparison — Q1

2026

Active

Revenue$464,424

COGS$85,377

Labour$150,736

Net Profit$169,948

2025

Prior Year

Revenue$418,200+11%

COGS$97,400↓ Better

Labour$162,100↓ Better

Net Profit$102,300+66%

Q1 2026 net profit is 66% higher than Q1 2025 — driven by revenue growth (+11%) and improved cost control.