Ingredient substitution and recipe yield
Compare alternatives when purchase price, usable yield, and serving weight change together.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Mevcut maliyet (TL)
- 3,957.51
- Alternatif alış (kg)
- 38.59
- Alternatif maliyet (TL)
- 4,241.02
Who can use it, and for what?
Chefs and purchasing leads
Compare alternatives when purchase price, usable yield, and serving weight change together.
A worked example from the workbook
The first sample row in the baseline has the following results. Mevcut maliyet (TL) 3.883,17, Alternatif alış (kg) 38,38, Alternatif maliyet (TL) 4.068,53, Tasarruf (TL) -185,36. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Mevcut maliyet (TL) | 3,957.51 |
| Alternatif alış (kg) | 38.59 |
| Alternatif maliyet (TL) | 4,241.02 |
| Tasarruf (TL) | -283.51 |
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.
- Pair interchangeable ingredients on each row. Measure edible yield in a test and use comparable prices per kilogram. Check required purchase quantity before testing the substitute.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Alternatif fiyat çarpanı”. The sample settings are 1 / 0,9 / 1,15. 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.
- Mevcut fiyat (TL/kg)
- Alternatif (TL/kg)
- Mevcut yenilebilir pay
- Alternatif yenilebilir pay
- Porsiyon gramajı
- Hedef porsiyon
Sample assumptions
- Alternatif fiyat çarpanı
- 1