Pastry and Food Order Calculator

Turns your recent sales and leftover counts into a suggested order for each pastry or food item, rounded up to your supplier's pack sizes, with the math shown and a ready-to-send order message.

CafeFood and Drink✓ Checkedv1.0

Before and after

BEFORE · what the owner typed

Hi its Esther Ramsey from Maplehill Cafe, 4535 Juniperhill St, Pinedale, phone 267-555-0108. I need my Saturday order from Mosshill Bakery. Felix Ueda counted for the last 4 Saturdays. Croissants: ordered 48, 48, 54, 54. Left over 0, 4, 0, 4. Sold out early the 1st and 3rd Saturdays. Blueberry muffins: ordered 36 every time. Left over 6, 2, 7, 5. Never sold out. Cinnamon rolls: ordered 24 every time. Left over 0, 0, 2, 0. Sold out early the 1st, 2nd and 4th Saturdays. Mosshill sells croissants in packs of 6 at $13.50, muffins in packs of 6 at $10.20, cinnamon rolls in packs of 4 at $9.00. If we sell out on half or more of the days add 10%. There is a farmers market on our street this Saturday so add 15% to everything. Order is due Thursday at 2pm and it comes Friday morning.

AFTER · what the skill produced

Saturday order for Maplehill Cafe, due to Mosshill Bakery Thursday at 2pm, delivery Friday morning.

Croissants: order 66 (11 packs of 6)

Sold: 48, 44, 54, 50. Average 49.
Sold out 2 of 4 Saturdays, so add 10%. Farmers market, add 15%. Total 25%.
49 x 1.25 = 61.25, rounded up to full packs = 66.
Cost: 11 x $13.50 = $148.50

Blueberry muffins: order 36 (6 packs of 6)

Sold: 30, 34, 29, 31. Average 31.
Never sold out, so no sellout percentage. Farmers market, add 15%.
31 x 1.15 = 35.65, rounded up to full packs = 36.
Cost: 6 x $10.20 = $61.20

Cinnamon rolls: order 32 (8 packs of 4)

Sold: 24, 24, 22, 24. Average 23.5.
Sold out 3 of 4 Saturdays, so add 10%. Farmers market, add 15%. Total 25%.
23.5 x 1.25 = 29.375, rounded up to full packs = 32.
Cost: 8 x $9.00 = $72.00

Totals: 134 items, 25 packs, $281.70

Flags

Blueberry muffins had leftovers all 4 Saturdays, averaging 5 per Saturday. The suggested 36 is the same as your usual order. If you would like fewer leftovers, tell us and we will lower it.
Croissants and cinnamon rolls sold out early on several Saturdays, so the real demand may be higher than the sold counts show.

Order message to Mosshill Bakery:
Hello, this is Esther Ramsey at Maplehill Cafe, 4535 Juniperhill St, Pinedale. Our Saturday order for Friday morning delivery: 11 packs of croissants (6 per pack), 6 packs of blueberry muffins (6 per pack), and 8 packs of cinnamon rolls (4 per pack). Please call us at 267-555-0108 with any questions. Thank you.

Questions for the owner

Do you want to lower the muffin order because of the leftovers, and if so, to how many?
How do you handle leftover pastries? We did not include any leftover plan in the numbers.

What it does

Turns your recent sales and leftover counts into a suggested order for each pastry or food item, rounded up to your supplier's pack sizes, with the math shown and a ready-to-send order message.

Use it when: Use when a cafe owner wants to work out how many pastries or baked goods to order from recent sales, such as: how many croissants should I order, figure out my Saturday bakery order, or use last weeks sales to set my pastry order.