ExcelFlux
← Restaurant and café

Bakery batch production planning

Plan daily demand, batch yield, carryover, and oven capacity together.

Restaurant and Café Pack · Excel workbook in Turkish

Results from the sample workbook

İhtiyaç adet
133.19
Gerekli parti
6.13
Üretilebilir parti
4.75

Who can use it, and for what?

Bakeries and pastry production teams

Plan daily demand, batch yield, carryover, and oven capacity together.

A worked example from the workbook

The first sample row in the baseline has the following results. İhtiyaç adet 131, Gerekli parti 6, Üretilebilir parti 5, Eksik satış adedi 6. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.

MeasureSample result
İhtiyaç adet133.19
Gerekli parti6.13
Üretilebilir parti4.75
Eksik satış adedi24.13

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. Enter demand in sellable units. Use opening carryover and observed batch yield. Avoid overlapping oven allocations in the shared schedule.
  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,26. 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.

  • Tahmin adet
  • Başlangıç satışa hazır
  • Tepsi ham adet
  • Sağlam ürün payı
  • Parti dakika
  • Kullanılabilir dakika
  • Fire maliyeti (TL/adet)

Sample assumptions

Talep çarpanı
1