ExcelFlux
← Restaurant and café

Interbranch inventory transfers

Balance receiving shortages against donor reserves, transport costs, and shelf life.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Alıcı açık (kg)
44.31
Transfer önerisi (kg)
26.5
Net tasarruf (TL)
595.63

Who can use it, and for what?

Multi-site operations and stockroom leads

Balance receiving shortages against donor reserves, transport costs, and shelf life.

A worked example from the workbook

The first sample row in the baseline has the following results. Alıcı açık (kg) 46, Transfer önerisi (kg) 28, Net tasarruf (TL) 641, Kalan açık (kg) 18. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Alıcı açık (kg)44.31
Transfer önerisi (kg)26.5
Net tasarruf (TL)595.63
Kalan açık (kg)17.81

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. Use one item and branch pair per row. Deduct recipient stock and check shelf life before moving inventory. Recheck shared donor stock before combining recommendations.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Talep çarpanı”. The sample settings are 1 / 0,8 / 1,2. 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.

  • Verici elde (kg)
  • Verici rezervi (kg)
  • Alıcı stok (kg)
  • Alıcı günlük talep (kg)
  • Ufuk (gün)
  • Raf ömrü (gün)
  • Dış alım farkı (TL/kg)
  • Transfer (TL)

Sample assumptions

Talep çarpanı
1