Overview

Monthly snapshot, trend lines, and anonymized demo source data.

Calendar year: 2025

Revenue & Profit Snapshot

Selected month
Gross sales basis
Current Month Revenue
-
-
YTD Revenue
-
-
Net Profit Margin
-
-

Current Month Actuals

Cost ratios for the selected month
Targets unavailable
Food Cost %
-
-
Labor Cost %
-
-
Prime Cost %
-
-

Revenue Trend

Current calendar year revenue with previous-year comparison.
Selected month
Gross sales over the available months. Dashed future segments are projected from the same month last year.

Profit Margin Trend

Gross and net profit margin over time.
Selected month
Margins are calculated from gross sales, COGS, and profit / loss rows from the workbook.

Financial Snapshot

Deep dive into profitability and financial health for the selected month.
Selected month
Gross Sales
-
-
Gross Profit Margin
-
-
Net Profit Margin
-
-
Prime Cost %
-
-

Revenue by Category

Food, beverage, and wine sales across the current calendar year.
Selected month
Monthly category mix uses workbook-backed actuals; missing future months are projected from the same month last year.

Expenses by Category

COGS, salary, marketing, building, and other expenses across available months.
Selected month
Expense categories use the top-level rows from the workbook's Monthly Data sheet.

Daily / Weekly Sales Heatmap

Average total amount by weekday for the current calendar year, with projected future months marked in-cell.
Selected month
Lower sales Higher sales
Projected from same month last year
Deep Dives

Food Deep Dive

Revenue, COGS, and ROI% by month.
Selected month

Beverage Deep Dive

Revenue, COGS, and ROI% by month.
Selected month

Wine Deep Dive

Revenue, COGS, and ROI% by month.
Selected month
Trends

Food Cost Percentage Trend

Monthly food cost % with benchmark line.
Selected month

Labor Cost Percentage Trend

Monthly labor cost %.
Selected month

Prime Cost Trend

Total COGS + labor cost as a share of revenue.
Selected month

Gross Profit Margin Trend

Gross profit margin across the full history.
Selected month

Net Profit Margin Trend

Net profit margin across the full history.
Selected month

Average Check Size Trend

Average customer spend over time, based on total amount divided by covers.
Selected month
This uses the daily sheet's total amount and covers columns, so the metric reflects the full bill per diner.

Expenses Snapshot

Top-level expense categories for the selected month.
Selected month
Total Expenses
-
-
Largest Category
-
-
Deductions
-
-

COGS

Monthly item breakdown and selected-month cost components.
Selected month

Salary

Monthly item breakdown and selected-month labor breakdown.
Selected month

Marketing

Monthly item breakdown and selected-month marketing components.
Selected month

Building

Monthly item breakdown and selected-month building-related costs.
Selected month

Other Expenses

Monthly item breakdown and selected-month operating expense details.
Selected month

Discounts & Deductions

Cash discounts and KOL FOC deducted from gross sales.
Selected month
Total Deduction
-
-
Discount Rate
-
Deduction / gross sales
Food Menu

Food Covers by Menu

Covers sold per menu type across the full demo-source period.
Selected month

Food Revenue Mix

Monthly food revenue stacked by menu item (₫M).
Selected month

Food Item Action Matrix

Selected-month covers vs average revenue per cover. Prioritize high-spend items that can be sold more often.
Selected month
Beverage Menu

Beverage Order Share vs Revenue Share

Selected-month order share compared with revenue share by beverage type.
Selected month
Example: Water & Soft Drink has high order share but low revenue share, making it the clearest upsell opportunity.

Beverage Share by Month

Order share and revenue share by beverage type for the selected month.
Selected month

Beverage Revenue per Order

Average revenue per beverage order for the selected month.
Selected month

Beverage Revenue per Order MoM

Average revenue per beverage order by month.
Selected month

Revenue Levers Summary

Fast read on where service can lift beverage revenue without increasing covers.
Action view
Beverage type Orders Order % Revenue % Avg / order Action