Daily Bake List from Orders and Sales History
Builds one clear bake list for a given day.
Before and after
Orchardhill Bakery, Quarrydale
Bake list for Saturday
Phone: 267-555-0110
Baker: Henrik Berg. Shop lead: Gwen Aiken.
Bake table
- Sourdough boule
- Pre-ordered: 2 (Gerald Yamada) + 3 (Imani Burns) = 5
- Sold on the last 3 Saturdays: 30, 27, 26. Average 27.7, rounded to 28.
- Leftovers: 0, 1, 4. The first Saturday sold out at 1pm, so 30 may understate demand.
- Walk-in: sold counts include pre-orders, and the pre-order total is already inside the 28, so we suggest 28 total demand and 23 walk-in (28 minus 5).
- Shelf minimum: you want at least 4 boules on the shelf at close. Baking 28 against average demand of 28 would leave about 0, so we suggest raising the walk-in by 4, from 23 to 27.
- Bake total: 5 + 27 = 32.
- Batches of 6: 32 rounds up to 36 (6 batches), 4 extra boules.
- Cinnamon rolls
- Pre-ordered: 12 (Gerald Yamada) + 24 (Hector Banks) + 12 (Ignacio Boyd) = 48
- Sold: 58, 60, 55. Average 57.7, rounded to 58.
- Leftovers: 2, 0, 17. The last Saturday had 17 left, so demand has been uneven.
- Walk-in: 58 minus 48 = 10
- Bake total: 48 + 10 = 58
- Pans of 12: 58 rounds up to 60 (5 pans), 2 extra rolls.
- Almond croissant
- Pre-ordered: 6 (Hector Banks)
- Sold: 24, 22, 20. Average 22.
- Leftovers: 0, 2, 4. The first Saturday sold all 24.
- Walk-in: 22 minus 6 = 16
- Bake total: 6 + 16 = 22
- Trays of 12: 22 rounds up to 24 (2 trays), 2 extra croissants.
- Plain croissant
- Pre-ordered: 0
- Sold: 19, 21, 18. Average 19.3, rounded to 19.
- Leftovers: 5, 3, 6. This item has had leftovers every Saturday.
- Walk-in: 19
- Bake total: 19
- Trays of 12: 19 rounds up to 24 (2 trays), 5 extra croissants. You may want to decide whether to bake 1 tray (12) or 2 trays (24), since 2 trays matches the amount you have been making.
Bake order: boules, then cinnamon rolls, then croissants.
Pre-orders by pickup time
- 8:00am, Gerald Yamada: 2 sourdough boules, 12 cinnamon rolls
- 9:30am, Imani Burns: 3 sourdough boules
- 10:00am, Hector Banks: 24 cinnamon rolls, 6 almond croissants
- 11:00am, Ignacio Boyd: 12 cinnamon rolls
Flags
- Allergy note on Hector Banks's order, word for word: "nut allergy in the family, ask Gwen". Almond croissants are on this order.
- Sourdough sold out at 1pm on the first of the three Saturdays, so the real demand may be higher than the sold count.
- Plain croissant has had leftovers all 3 Saturdays.
- Please confirm batch yields, oven capacity, and food safety timing against your own recipes and local rules.
Questions for the owner
- For plain croissants, do you want 1 tray (12) or 2 trays (24)?
- The note on Hector Banks's order says "ask Gwen". What would you like the counter staff to do about it before pickup?
- Do you want the 4 extra boules, 2 extra rolls, and 2 extra almond croissants from rounding up to go on the shelf, or should they be baked as a smaller last batch?
What it does
Builds one clear bake list for a given day. It combines the pre-orders already promised to customers with the quantities needed for the walk-in case, based on what the bakery actually sold on recent matching days.
Use it when: Use when a bakery owner or head baker needs a daily bake list built from customer orders and recent sales history, such as "what do I bake tomorrow," "make my bake list," "production list for Saturday," or "how many loaves do I need."