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.
| Measure | Sample 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?
- 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.
- Reconcile movements per lot and location. Match production and branch returns to their respective issues. Investigate the records and locations behind open balances.
- 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.
- 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