Packaging use and replenishment
Plan packaging from order mix, case size, safety stock, and available stock.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Günlük tüketim (adet)
- 129.99
- Hedef stok (adet)
- 1,047.71
- Sipariş koli
- 3
Who can use it, and for what?
Takeout operators and purchasing
Plan packaging from order mix, case size, safety stock, and available stock.
A worked example from the workbook
The first sample row in the baseline has the following results. Günlük tüketim (adet) 129,5, Hedef stok (adet) 1.036, Sipariş koli 3, Eldeki stok günü 3,47. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Günlük tüketim (adet) | 129.99 |
| Hedef stok (adet) | 1,047.71 |
| Sipariş koli | 3 |
| Eldeki stok günü | 3.51 |
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.
- Use a row per packaging SKU. Include incoming units only when their receipt falls within the stated lead time.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Günlük talep çarpanı”. The sample settings are 1 / 0,78 / 1,31. 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.
- Günlük paket
- Ambalaj gerektiren pay
- Siparişte ambalaj
- Kalan ambalaj
- Gelen ambalaj
- Temin günü
- Güvenlik günü
- Koli adet
Sample assumptions
- Günlük talep çarpanı
- 1