Solutions · Food and beverage

Yesterday’s sales at every outlet, before today’s service begins

Owners and operations leaders of restaurant, bakery and café groups may ask about outlets, menu items and waste in Thai or English, answered from their own point-of-sale data with a chart and the basis of each figure.

The problem

Where food and beverage decisions are usually delayed

01

Sales are known per outlet, not across the group

Each outlet’s point of sale reports on its own. Seeing the whole group on one page means exporting and combining files every morning.

02

Production is planned on habit

Without yesterday’s sell-through by item and hour, an outlet bakes too much of one item and runs out of another.

03

Outlets abroad report in another currency

Revenue recorded in different currencies is added together by mistake, or converted by hand at a rate nobody wrote down.

Sample questions

Questions a food and beverage leader can ask today

Typed in Thai or English, with no SQL and no dashboard prepared beforehand.

›What was yesterday’s revenue at each outlet?›Which ten menu items sold the most this month?›Which items were discarded most often last week?›How does lunchtime revenue compare with the evening, by outlet?›Which outlets fell short of the same day last week?
›What was the average bill per customer this month?›Which new menu items sold fewer than expected since launch?›What share of sales came from delivery channels?›What was total group revenue this quarter in the reporting currency?›Which outlets had the most voided bills last month?
By role

The same data, asked from each seat

Owners and executives

The group as a whole each morning, in one reporting currency, with any conversion stated.

What was total revenue yesterday across all outlets?
Which outlets grew fastest this quarter?
How did this month compare with the same month last year?

Operations and outlet management

Items, hours and waste, at the level where production and staffing are adjusted.

Which items sold out before closing yesterday?
At which hours is each outlet busiest?
How much waste did each outlet record last week?

Finance and purchasing

Margin, discount and cost of goods on definitions the organization has certified.

What was the gross margin by menu category this month?
How much discount was given under each promotion?
Which ingredients rose most in cost this quarter?
Your vocabulary

The platform learns the words your kitchen uses

A glossary maintained per organization maps your own vocabulary to the right tables, so that “outlet”, “bill” and “waste” mean what your team means.

GLOSSARY · FOOD AND BEVERAGE
outlet→pos.outlets
bill→pos.sales
menu item→pos.sale_items
waste→pos.waste_records
Data connected

Data a food and beverage deployment typically connects

01

Point-of-sale transactions

Bills and bill lines by outlet, date and hour, with voids and discounts.

02

Menu and recipes

Menu items, categories, prices and the cost of each recipe.

03

Outlets and channels

Outlets, their country and currency, and dine-in, take-away and delivery channels.

04

Production and waste

Quantities produced, sold and discarded per item and day.

05

Purchasing and stock

Ingredient purchases, supplier prices and stock on hand.

Questions

Questions from food and beverage teams

Does the platform work with the point-of-sale data we already have?

The platform connects read-only to the database in which your point-of-sale data is kept, directly or through a gateway. Facgure sets up the connection and the data catalog with you.

We operate in more than one country. How are currencies handled?

A reporting currency is set for the organization, with the rates you provide. Totals are converted to it, and each answer states that a conversion was applied and at which rate.

Can an outlet manager receive figures without asking each day?

Yes. A chart may be pinned and scheduled to arrive by email daily or weekly, and each member may set personal alerts where the organization permits them.

Does “yesterday” follow our local time?

Yes. The time zone is set per organization, and per connection where regions differ, so that relative periods such as yesterday and this month follow local time.

Answer your most demanding question

Request a 30-minute session. We will connect a sample of your data and put genuine decision questions to it, in Thai or English.