Theoretical versus actual ingredient usage
Derive recipe usage from POS quantities and isolate unexplained variance after waste and transfers.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Teorik brüt sarf (kg)
- 75.58
- Fiili sarf (kg)
- 73.5
- Açıklanamayan (kg)
- -2.08
Who can use it, and for what?
Kitchen control and costing teams
Derive recipe usage from POS quantities and isolate unexplained variance after waste and transfers.
A worked example from the workbook
The first sample row in the baseline has the following results. Teorik brüt sarf (kg) 72,44, Fiili sarf (kg) 74, Açıklanamayan (kg) 1,56, Parasal etki (TL) 241,95. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Teorik brüt sarf (kg) | 75.58 |
| Fiili sarf (kg) | 73.5 |
| Açıklanamayan (kg) | -2.08 |
| Parasal etki (TL) | -200.57 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Use gross kilograms for stock and receipts. Include documented transfers and non-recipe waste in net issues. Recipe yield already includes trim losses.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Reçete gramajı çarpanı”. The sample settings are 1 / 0,94 / 1,06. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Satılan adet
- Reçete net gram
- Ayıklama verimi
- Açılış (kg)
- Alım (kg)
- Kapanış (kg)
- Belgeli net çıkış (kg)
- Alım (TL/kg)
Sample assumptions
- Reçete gramajı çarpanı
- 1