ExcelFlux
← Restaurant and café

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.

MeasureSample 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?

  1. 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.
  2. 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.
  3. 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.
  4. 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