Die Hilfe ist vorerst auf Englisch

Abschnitte

Hilfe / Аналитика

Menu food cost (Себестоимость меню)

The screen is shown in Russian. Labels are given as they appear on screen, with an English translation in brackets.

Why#

See menu food cost for a period, by group and by dish, find dishes above target and ingredients without a price, export the report to PDF, Excel or by email.

Where to find it#

Menu «Аналитика» (Analytics) → «Себестоимость меню» (Menu food cost).

Screenshotleft menu, «Аналитика» group expanded, «Себестоимость меню» highlighted

The section is included in Food Cost Control, Food Cost Managed and the free trial. If the company's plan does not include it, the menu item is not shown.

What is on the screen#

  • Header, right side: «Кухня» (Kitchen) / «Бар» (Bar) - the section filters the whole screen, «Обновить данные» (Refresh data), period selector, PDF, Excel, email export and «Как считается» (How it is calculated).
  • Row of cards: menu food cost as a gauge with a 30% target, «Оборот нетто» (Net turnover), «Фудкост, €» (Food cost, €), «Продано» (Sold), «Оценены полностью» (Fully priced). When relevant - «С ценой Syrve» (With Syrve price) and «Без себестоимости» (No cost).
  • Left - the table «Блюда - по группам» (Dishes by group): a group row expands into its dishes.
  • Right - «Сверка данных» (Data check: till against sales acts) and «Группы вне диапазона» (Groups out of range: food cost above the 30% target).
Screenshot«Себестоимость меню» full screen, card row and group table highlighted

How to#

Choose a period#

  1. Open the period selector in the header.
  2. Choose «Месяц» (Month) and a month with the arrows, or «7 дней», «30 дней», «90 дней» (7, 30, 90 days), «Текущий + прошлый месяц» (current + last month), or «Свой период» (custom period).

By default the latest month with sales opens.

See dishes of a group#

  1. Click a group row in the table.
  2. Its dishes open with columns «Продано», «Прайс, €» (List price), «Без НДС, €» (Without VAT), «Фудкост / ед, €» (Food cost per unit), «Оборот брутто, €», «Оборот нетто, €» (Gross, net turnover), «Фудкост, €», «Фудкост, %», «% дохода» (Share of revenue) and change against the previous period.
  3. Click a column header to sort.
  4. Click the food cost change of a dish to see which purchases moved it.
Screenshotexpanded dish group, «Фудкост, %» column and change against previous period highlighted

Find dishes without a price#

  1. Click the «Оценены полностью» card.
  2. The table keeps only dishes where not all ingredients have a price. Click the card again to show all.
  3. Click the coverage mark of a dish (for example «3/5») - the list «Без цены закупки» (No purchase price) and «С ценой» (With price) opens.

See what moved food cost#

  1. Click the food cost gauge in the first card.
  2. The food cost analysis opens: a series by month and the items that raised or lowered the percentage.
Screenshotfood cost analysis window with the monthly series and item list

Set up Bar and Kitchen#

  1. Click «Секции и группы» (Sections and groups) above the table.
  2. For each store choose «Бар», «Кухня» or «Не назначено» (Not assigned).
  3. Save - you will see «Секции сохранены» (Sections saved).

Refresh data#

  1. Click «Обновить данные» in the header.
  2. RestoAudit pulls products, recipes, sales and stock movements from Syrve for the selected period.
  3. Then you see «Данные обновлены» (Data refreshed) or a list of what did not refresh.

Export or send the report#

  1. Click the PDF icon - a form with the current section filter downloads.
  2. Click the Excel icon - a workbook with the same numbers downloads.
  3. Click the email icon - «Отправить отчёт письмом» (Send report by email) opens. Choose addresses and click «Отправить» (Send). Two files, Excel and PDF, are sent once.

Regular delivery is set up in «Рассылки отчётов» (Report delivery).

What the numbers mean#

  • Sales, recipes and products come from Syrve. Purchase prices come from invoices in RestoAudit.
  • «Продано» - portions in paid orders. Items given without payment are not included, they are write-offs. An item with a 100% discount stays.
  • «Прайс, €» - price-list price, not the average check. «Без НДС, €» - list price without VAT by the item's tax category.
  • «Фудкост / ед, €» - sum of ingredient quantities × purchase price. The recipe is expanded down to end products. The recipe valid at the end of the period is used.
  • Purchase price - quantity-weighted average for the report month and the previous one. No invoices in two months - last known price, none - the product card's estimated price, none - zero. A price above 3 medians for the two months is ignored.
  • «Оборот брутто» and «Оборот нетто» - from the accounting system, with and without VAT. Discounts are already inside.
  • «Фудкост, €» - food cost per unit × sold, plus modifiers sold with the dish.
  • «Фудкост, %» - «Фудкост, €» / net turnover × 100.
  • «% дохода» - the dish's share of its group's turnover, the group's share of total turnover.
  • Top cards are for the whole period and do not change with table filters.
  • «Оценены полностью» - dishes where all ingredients have our price. «С ценой Syrve» - including dishes covered by a Syrve price.
  • «Без себестоимости» - turnover of dishes without cost, by reason: «Не блюдо (аванс)» (not a dish, advance), «Нет в отчёте меню» (not in the menu report), «Нет техкарты» (no recipe), «Продаётся без прихода» (sold without receipt), «Нет цены части ингредиентов» (some ingredients have no price).
  • «Сверка данных» - «Касса (Z-отчёты)» (till, Z-reports) against «Реализация» (sales acts). Both assign a shift to the day it opened.
  • Section «Бар» or «Кухня» comes from the write-off store in the sales line.
  • All formulas with examples - the «Как считается» button.

FAQ#

Why is the screen empty? There are no sales in the period. Check the period or click «Обновить данные». For a new company - «Проверить состояние подключения» (Check connection status).

Why is a dish's food cost too low? Not all ingredients have a price. Such dishes have a coverage mark, and the «Оценены полностью» card shows them.

Why do till and sales acts differ? If the till is higher - check that all sales acts are exported. If sales acts are higher - check cancelled checks and card payments.