ExcelFlux
← Restaurant and café

Lot traceability and recall reconciliation

Reconcile received, used, quarantined, and recovered quantities for affected lots.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

Depo farkı (kg)
4.88
Sahada kalan (kg)
46.63
Kontrol edilen (kg)
50.44

Who can use it, and for what?

Quality and stockroom teams

Reconcile received, used, quarantined, and recovered quantities for affected lots.

A worked example from the workbook

The first sample row in the baseline has the following results. Depo farkı (kg) 3, Sahada kalan (kg) 47, Kontrol edilen (kg) 50, Kontrol payı %50. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
Depo farkı (kg)4.88
Sahada kalan (kg)46.63
Kontrol edilen (kg)50.44
Kontrol payı50.37%

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. Reconcile movements per lot and location. Match production and branch returns to their respective issues. Investigate the records and locations behind open balances.
  3. Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Takip toleransı (kg)”. The sample settings are 0,1 / 0,01 / 0,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.

  • Gelen (kg)
  • Depoda ayrılan (kg)
  • Üretime çıkan (kg)
  • İmha (kg)
  • Üretimden dönen (kg)
  • Şubelere aktarılan (kg)
  • Şubeden dönen (kg)

Sample assumptions

Takip toleransı (kg)
0.1