Read the full picture, or click a day to drill in. The day view is built for the kitchen: what sold, what was wasted, what to prep today.
Channel
Day
Week
Month
No live data loaded
This dashboard is set up to read the live Google Sheet, but the last attempt failed, so nothing is shown. No numbers is better than wrong numbers.
If the address bar starts with file:// (the page was opened straight from Finder or Dropbox), the browser may block web requests from local files. Host the dashboard like the FeedMe checklist, or use Load file below with the Sheet downloaded as .xlsx.
Kitchen view
Product
Sold
On shelf
Wasted
Usual
Pre-orders today
Suggest today
Sorted by units sold, top sellers first. Highlighted columns are the chef's action numbers.
Prep forecast
Product
Usual
Range
From
Make
Why
Week ahead
Product
Revenue and profit by day
Solid: revenue and profit. Dashed: wastage cost.
By product
Revenue and wastage cost per SKU.
Revenue (£)Wastage (£)
Margins per product
Planned cost from the kitchen costings; real cost re-priced from supplier invoices. Target margin band 65 to 75%.
Product
Price
Planned cost
Real cost
Checked
Margin
vs 65-75% target
SKU performance ranking
Score = sell-through × margin, minus wastage rate. Higher is better. Calculated across all recorded days regardless of the filters.
Top 5
Bottom 5
When things sell
Units sold by hour of day and day of week. Darker means more units. Hover for the exact count. Always covers all recorded days, useful for pattern-spotting alongside the day view.
Menu health
Where the menu needs work, from the kitchen's nutrition reports.
Every issue on a live dish, heaviest seller first, so effort follows what people actually buy.
Dish
Units sold
Issue
Detail
Fat and saturates as a share of each dish's own energy, so portion size does not distort the picture. Salt is per portion. The marker is the guideline.
Dish
kcal
Saturates (max 11% of energy)
Fat (max 35% of energy)
Salt per portion (max 1.8g)
A dish may be labelled "source of protein" at 12% of energy from protein, and "high protein" at 20%.
Dish
Protein per portion
% of energy
Claim allowed
Gap to next claim
The statutory colours, with every red explained. A composition red means the recipe is high per 100g. A portion red means the recipe is within band and only the per-portion cap for servings over 100g is breached.
Dish
Fat
Sat
Sug
Salt
Why any red
Allergen spread and dietary coverage across live dishes, from the ingredient declarations.
Supplier spend and price moves
What was bought from each supplier per month, and how invoice prices compare with the Mabel Ingredient Price List. Red means worth a look: an unusually heavy month, or a price a long way off the list.