ExcelFlux
← Restaurant and café

Batch shelf life and FEFO priority

Track remaining shelf life, expected consumption and stock rotation by batch.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Partiye ayrılabilen talep (kg)
9.13
Bitmeden tüketilebilir (kg)
9.13
Riskte kalan (kg)
19.31

Who can use it, and for what?

Stockroom and kitchen leads

Track remaining shelf life, expected consumption and stock rotation by batch.

A worked example from the workbook

The first sample row in the baseline has the following results. Partiye ayrılabilen talep (kg) 9, Bitmeden tüketilebilir (kg) 9, Riskte kalan (kg) 19, Risk tutarı (TL) 3.135. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Partiye ayrılabilen talep (kg)9.13
Bitmeden tüketilebilir (kg)9.13
Riskte kalan (kg)19.31
Risk tutarı (TL)3,197.88

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 your own expiry records. Enter stock from earlier-expiring batches of the same item. Check segregation and usage priorities at shift opening.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Tüketim çarpanı”. The sample settings are 1 / 0,7 / 1,25. 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.

  • Parti bakiyesi (kg)
  • Günde tüketim (kg)
  • Kontrol anında kalan gün
  • Daha erken biten stok (kg)
  • Birim maliyet (TL)

Sample assumptions

Tüketim çarpanı
1