The Village Dashboard

Daily Ops
Tue, Aug 4 · updated 7:42 AM
All locations V1 · Estevan V2 · Royal Oak V3 · Torquay
Today Money Food & Suppliers Guests & Phone People Equipment Compliance Receipts Integrations Notifications

Food & Suppliers · Royal Oak

Invoices coded to Aug 3 · recipe costs refreshed Aug 1

Food % by location, trailing 8 weeks All locations

32%31%30% 28%27% target 29% Jun 8Jun 15Jun 22 Jun 29Jul 6Jul 13 Jul 20Jul 27
Estevan Royal Oak Torquay Target 29%
Royal Oak has climbed every week since Jun 15 while the other two houses sit flat on target. Menu mix is unchanged, so this is not a guest-choice story.

This month by house → prime cost

Estevan
29.1%
Royal Oak
30.9%
Torquay
29.5%
Supplies, consolidated
Kept split from food so packaging never hides a kitchen problem
4.6%
Cost per cover
Blended across the three houses, MTD
$8.51
Royal Oak drill-down
Drop 3 portions on the hot side run 18% over spec on two plates

What the 1.9 point gap is made of All locations · Aug MTD

30%29%28%27% 27.9+0.7+0.6 +0.5+0.3−0.2 29.8 TheoreticalWastePortioning Price driftCompsCredits Actual waste sheetsportion audit invoicesToastmemos
Every step traces to a record already in the pipeline: the photographed waste sheet, the portion audit, the invoice line, the Toast comp. Nothing here is an estimate dropped in to make the bridge close.

Waste by category $1,340 MTD

$1.2k$900$600$300 ProteinProducePrepared DairyBakery
Protein trim, Royal Oak
Tue and Wed close, both weeks · 4.1% of protein spend vs 2.5% standard
$640
Produce spoilage, Torquay
Over-ordered against a slow Sunday
$310
Prepared items, all houses
Soup and braise batches past hold time
$500
Waste sheets logged
26 of 31 closes photographed at end of shift

Unit price drift, 90 days 7 alerts open

ItemSupplier90 daysChangeBest alternative
Canola oil, 16L
3rd increase this year → invoice
Sysco +9% B&C −$4.10
Bacon, side
Drifting since June
Sysco +6% B&C −$2.30
Avocado, case
Market driven, watch only
Sysco +11% No second source
10" clamshells
Supplies, not food
Sysco +4% Pak West −$0.02/ea
Produce basket
Seasonal dip, as expected
Islands West −3% Holding
Coffee, 5lb
Contract price, 9 months flat
Roaster flat Locked to Mar
Switching the two dual-sourced items
Canola and bacon at B&C prices, at current volumes: $412 a month across the group
Every price on this table came off a scanned invoice. The → invoice link opens the document, the extracted lines, and the checks that ran before it asked for you.

Where the spend goes 12 months

Sysco 70% $978k total food and supplies purchasing · all other suppliers $48k Sysco $684k B&C $128k Islands West $76k Irene's $42k
Concentration risk
70% of purchasing with one supplier, and the annual conversation is in October
Watch
Negotiation pack
Spend by category, drift per item, cross-supplier comparison, all from invoices already processed
Canola oil, Sysco vs B&C
The gap opened in July and has not closed
$4.10/unit
$46$42$38 MarAprMay JunJulAug
Sysco $44.90 B&C $40.80

Delivery schedule Next 7 days

SupplierDropsNextOrder duePAR check
Sysco
All three houses
Tue, FriAug 5, 6–9 AMTonight 8 PM4 items low
B&C Foods
Estevan, Royal Oak
WedAug 5, 7–10 AMPlacedClear
Islands West
Produce
Mon, ThuAug 6, 6–8 AMAug 5, 6 PMClear
Irene's Bakery
Standing order
DailyAug 5, 5 AMStandingn/a
Coffee roasterBiweeklyAug 12Aug 8Clear
PAR suggestion, tonight's Sysco order
Built from the last four weeks of usage and Wednesday's forecast covers. Yours to edit, then send.

Invoice pipeline 71 this month

Auto-coded
89%
Hand-coded
11%
6 exceptions waiting on you
Invoice price differs from the order guide by more than 3%, so nothing was coded silently
2 credit memos outstanding
Sysco June shortage $284 · B&C damaged case $96 · both chased twice
Chasing
PST split applied per line
Supplies carry PST, food does not. The split feeds the Money page filing figure.
→ remittances
Order guide refreshed Aug 1
412 items priced from the last 90 days of invoices, not from a supplier catalogue
Current
Mockup with illustrative numbers · The Village Dashboard (BIZ-00) · Gray box: nothing files, pays, or posts by itself.