Restaurant Management

Sales show in revenue, raw materials get counted in the store room; waste is a month-end surprise

Stock and Recipe Management ties every item to its recipe; raw materials are drawn from stock as items sell. Critical-level alerts, cost by item and waste reports come from the same module.

Stock and recipe management
In short

Stock and Recipe Management is the Panda Restoran module that ties every menu item to a raw-material recipe and deducts stock by recipe at the moment of sale. It raises alerts for raw materials nearing critical level, calculates cost and margin by item, and reports waste and loss records. The gap between the store room count and recipe consumption is listed daily.

How is this work done today?

  • Nobody knows how much raw material went

    The register knows what sold, the store knows what is left; the consumption in between is not calculated. The cost of meat, cheese and oil is learned from accounting at month end.

    1 head chef × 30 minutes / day
  • Critical stock is noticed once it runs out

    An item runs out during evening service and the waiter tells the table 'we are out'. The morning order goes to the wholesaler by phone; delivery is next day.

    1 restaurant manager × 20 minutes / day
  • Waste is in a notebook or nowhere

    Spoiled product, plates sent back and wrongly prepared orders go in the bin with no record. Waste does not show up in profitability figures.

    1 person × 1 hour / week

How does Stock and recipe management work?

  1. 1

    Raw materials and recipes are defined

    Raw material cards are opened with unit and purchase price; every menu item gets a recipe in grams. Recipes for portions and extras are defined separately.

  2. 2

    Sales draw down the recipe

    The moment an item sells at the register, the raw materials in its recipe are deducted from stock. On goods receipt, the purchase invoice raises stock; the warehouse balance updates with every movement.

  3. 3

    Critical level and counts

    A critical level is set for each raw material, and an alert arrives as it approaches. Periodic counts are entered and the gap between recipe consumption and the count is listed.

  4. 4

    Cost, profit and waste report

    Cost by item is calculated from purchase prices and margin is compared with the sale price. Waste is entered with a reason code; the report is available as Excel and PDF.

See how Stock and recipe management would work in your business

Tell us briefly about your process and we will walk through the screens with your own example.

  • Reply the same business day
  • 15+ years of experience
  • 90 client businesses

Stock and recipe management features

Stock and recipe management: Recipe-based stock deduction
  • Recipe-based stock deduction

    Raw materials in the recipe of every item sold are deducted from stock in grams and units; semi-finished recipes can be nested.

  • Critical level alert

    An on-screen and notification alert as stock nears the level set on the raw material card; the order list goes to the Supplier module as a draft.

  • Cost and profit analysis by item

    Recipe cost of each item is calculated from the current purchase price; margin against the sale price and a profitability report by category follow.

Stock and recipe management: Waste and loss tracking
  • Waste and loss tracking

    Spoilage, returns, wrong preparation and complimentary items are recorded with a reason code; the waste amount flows into the Income and Expense module as an expense.

  • Counts and variance list

    Counts are entered on a handheld terminal or tablet; the difference between count and recipe consumption is listed by item and corrected with approval.

  • Goods receipt and purchase invoice

    Products from suppliers enter stock by waybill or invoice; the purchase price updates recipe cost automatically.

  • Multi-warehouse and branch stock

    Main store, kitchen and bar stock are tracked separately; transfers between branches are posted as records, and head office sees every warehouse in one list.

  • Stock reports

    Consumption by raw material, period-end stock value, items with the most waste and the critical stock list are available for any date range.

What does Panda AI add to Stock and recipe management?

The Production and Planning Agent is the Panda AI agent that answers, in a single question, an order’s delivery date, whether work orders have the materials they need and where there is a risk of delay.

  1. Today The plan is kept in Excel and the ERP is updated afterwards With the agent The delivery date of any order with one question
  2. Today A material shortage is discovered when the line stops With the agent Material availability check for work orders
  3. Today Three people are asked for one delivery date With the agent Orders at risk of delay are flagged in advance

Jobs it takes on

  • Work order and delivery date queries
  • Material availability check
  • Scrap and efficiency reports
  • Delay risk alerts
  • End-of-shift summaries
  • Compiling quality records

The agent prepares, a person approves. Anything that posts a record or sends something outside the company goes through your approval.

Explore Panda AI agents

Frequently asked questions about Stock and recipe management

How much work is it to define recipes?

During setup, a recipe in grams is written for every item on the menu; the head chef provides the weights and the setup team enters them. If you have a recipe Excel, it is imported. Semi-finished items (sauces, dough, marinated meat) get their own recipes and are used as lines in item recipes.

How is cost updated when a raw material price changes?

When a purchase invoice or goods receipt is entered, the current price of the raw material changes and the cost of every item tied to it is recalculated. Last purchase price or average price is chosen during setup. Items whose margin falls below the threshold are flagged in the list.

How is the gap between the count and the system found?

A count is entered from a tablet or handheld terminal; the system compares it with the balance expected from recipe consumption and lists the difference by item. The difference is classified as waste, loss or recipe error; the head chef or store keeper approves the correction.

Who enters waste records?

The kitchen team enters waste from a tablet or the kitchen screen by selecting the item, quantity and reason code; complimentary items and returns are marked at the register. The record reduces stock and appears as an expense line in the Income and Expense module. A daily waste summary is added to the end-of-day report.

Who receives the critical stock alert?

When stock nears the level set on the raw material card, a notification goes to the head chef and the purchasing lead. At the same time an order draft is created in the Supplier and Purchasing module. Whether to send the draft is purchasing's decision.

Are bar stock and kitchen stock tracked separately?

Yes. Kitchen, bar and main store are defined as separate warehouses; drink recipes draw from bar stock and food recipes from kitchen stock. Transfers between warehouses are recorded; head office sees every warehouse in one list with values per warehouse.

Can head office see the stock of several branches?

Each branch's warehouse is tracked separately, and head office sees the stock value and critical list of all branches on one screen. In central-kitchen setups, semi-finished items produced there go to branches by transfer, and branch stock rises with the transfer record.

What does the agent do in stock and recipes?

Panda AI compares recipe consumption deducted by sales with the warehouse count every day; the variance and critical stock list is ready in the morning. The head chef approves waste records and stock corrections; the agent does not correct stock on its own. Scenario: stock variance.

See Stock and recipe management with your own data

Describe your process in a few sentences and we will show you the modules that fit.

  • 15+ years of enterprise software experience
  • In the cloud or on your own server
  • Processes compliant with KVKK (Turkey's data protection law)

Last reviewed: · Panda Yazılım product team