Pastry order calculator for a cafe
Four of one weekday in, each pastry's sell-through, the cost of what was left and a suggested standing order out.
Nothing on this page needs an account, and it never will.
Suggested pastry standing order
Over 28 days. Every suggestion assumes the same days sell the same again. It is a suggested standing order to try, not a forecast. Change one or two at a time, tell the bakery before its notice window closes, and read the next four the same way.
What did not sell
Example$516.95left over
268 of 1,776 pastries over 28 days, 84.9% sold through.
- Standing order now, a day
- 63
- Suggested standing order, a day
- 63
- Left over at the suggested order
- $508.35
0 to cut, 2 that may be selling out.
If the same days sold the same again.
A pastry that sells out before close hides its demand: the customer who wanted one after it ran out never shows up as a sale. So a pastry near 100 percent sold through has a sold number that is a floor, and nobody knows the true demand.
Every suggestion assumes the same days sell the same again. It is a suggested standing order to try, not a forecast. Change one or two at a time, tell the bakery before its notice window closes, and read the next four the same way.
Free for 14 days, no card. Then $59 a month for one cafe.
Parly lays each morning's delivery against your standing order and reads what sold in Square, for every pastry. You decide the order and tell the bakery.
The days you are reading
The example is Cafe Parly, our example cafe, over the four weeks of every day in the post on the Saturday pastry order: 28 days. For your Saturday, read four Saturdays and put 4.
Each pastry
6 of 30What the bakery delivered, what Square says sold, and the sell-through line you can live with. Parly's suggestions start from 75 percent. Run your best seller lower and an impulse buy higher. Example pastries, counts and prices.
74.0% sold through64 left, $131.208.8 a day now
KeepKeep 9 a day. It is within one pastry a day of its line.
One fewer a day, if the same sold: 83.5% sold through, $73.80 left.
78.3% sold through66 left, $155.1010.9 a day now
KeepKeep 11 a day. It sells through at or above its line.
One fewer a day, if the same sold: 86.2% sold through, $89.30 left.
83.5% sold through84 left, $155.4018.1 a day now
KeepKeep 18 a day. It sells through at or above its line.
One fewer a day, if the same sold: 88.3% sold through, $103.60 left.
85.3% sold through43 left, $53.7510.4 a day now
KeepKeep 10 a day. It sells through at or above its line.
One fewer a day, if the same sold: 94.3% sold through, $18.75 left.
97.0% sold through7 left, $14.708.4 a day now
May be selling outKeep 8 a day. It may be selling out, so the true demand is unknown: if it ran out before close, try one more on that day.
97.9% sold through4 left, $6.806.9 a day now
May be selling outKeep 7 a day. It may be selling out, so the true demand is unknown: if it ran out before close, try one more on that day.
| Pastry | Came in | Sold | Sold through | Left, cost | Now a day | Suggested a day |
|---|---|---|---|---|---|---|
| Morning bunKeep 9 a day. It is within one pastry a day of its line. | 246 | 182 | 74.0% | $131.20 | 8.8 | 9 |
| Almond croissantKeep 11 a day. It sells through at or above its line. | 304 | 238 | 78.3% | $155.10 | 10.9 | 11 |
| CroissantKeep 18 a day. It sells through at or above its line. | 508 | 424 | 83.5% | $155.40 | 18.1 | 18 |
| Chocolate chip cookieKeep 10 a day. It sells through at or above its line. | 292 | 249 | 85.3% | $53.75 | 10.4 | 10 |
| Pain au chocolatKeep 8 a day. It may be selling out, so the true demand is unknown: if it ran out before close, try one more on that day. | 234 | 227 | 97.0% | $14.70 | 8.4 | 8 |
| Blueberry muffinKeep 7 a day. It may be selling out, so the true demand is unknown: if it ran out before close, try one more on that day. | 192 | 188 | 97.9% | $6.80 | 6.9 | 7 |
A pastry that sells out before close hides its demand: the customer who wanted one after it ran out never shows up as a sale. So a pastry near 100 percent sold through has a sold number that is a floor, and nobody knows the true demand.
Made with Parly. Free cafe tools at getparly.com/tools
How do you work out a pastry standing order?
Take four of one weekday, write down what the bakery delivered and what Square says sold, and divide. That is sell-through. Pick the sell-through line you can live with for each pastry, and a pastry under its line is ordered too deep.
sell-through = sold / received x 100
left over = received - sold
cost of it = left over x what one costs
order at line = sold a day / (line / 100), rounded up
suggested order = order at line, only when sell-through is under
the line, and at most 2 a day fewer than nowThe same sum with the seeded numbers in it, so you can check the calculator against your own arithmetic:
sell-through 182 / 246 x 100 = 74 percent
left over 246 - 182 = 64
cost of it 64 x $2.05 = $131.20
order at line 182 / 28 days = 6.5 a day
6.5 / 0.75 = 8.67, rounded up = 9
suggested order about 9 a day now, so keep 9Use four of the same weekday, not one. One Saturday can be rain, a street fair or a closed road. Four start to show you the day, and Saturday gets its own order apart from Tuesday.
The suggestion only ever cuts. A pastry that already has some left at close would only leave more if you ordered more of it. So a pastry at or above its line keeps its order, and a cut moves at most two a day at a time, so you can read the next four before you move again.
A pastry that sells out before close hides its demand: the customer who wanted one after it ran out is in no report. The page treats 95 percent sold through or more as a pastry that may be selling out, keeps its order and says the true demand is unknown. If it ran out early, try one more on that day and watch.
There is no right line. Parly's suggestions start from 75 percent, which is a starting point, not a number cafes are known to hit. Your best seller can run lower, because selling out of it costs more than one in the bin, and a pastry people only buy on impulse can run higher.
A worked example, four weeks
The calculator opens on Cafe Parly, our example cafe, over the four weeks of every day in the post on the Saturday pastry order: six pastries from one bakery, $517 left over in all, $311 of it in the two croissants. Its deliveries come from the standing order, so what came in is what was ordered.
The morning bun sold 182 of 246, 74 percent. At a 75 percent line that is within one bun a day, so the suggestion keeps its order. The page also shows the post's test: one fewer a day, if it still sold 182, takes sell-through to 83 percent and the leftover cost to about $74. Set the bun's line to 85 and the suggestion becomes one fewer a day.
The blueberry muffin sold 188 of 192, 98 percent, and the pain au chocolat 97. The page keeps both orders and flags them, because a pastry that sells out before close shows you a sales number below its real demand.
Then put in your own: the last four Saturdays from Square, what the bakery delivered on each, and 4 in the days box. Print the sheet, and send any change before the bakery's notice window closes.
The four weeks this opens on, and how to choose the line, are in how to decide your cafe's Saturday pastry order.
Frequently asked questions about pastry orders
- What is a good sell-through for cafe pastries?
- There is no right one. It is a choice between two costs you can name: what you bin, and the sale you never made because the case was empty. Parly's suggestions start from a 75 percent line as a starting point. Run your best seller lower and an impulse pastry higher, and write the line down for each pastry.
- How do you work out pastry sell-through?
- Divide what sold by what came in, over the same days. Cafe Parly's morning bun sold 182 of 246 over four weeks, which is 74 percent. Use four of one weekday rather than a single day, so one rainy Saturday does not set the order.
- Why does the calculator not suggest more of a pastry that sells out?
- Because nobody knows how many more would sell. When a pastry runs out before close, the customer who wanted one is in no report, so its sold number is a floor and the true demand is unknown. The page flags it and keeps the order. If it ran out early, try one more on that day and read the next four the same way.
- Should my Saturday pastry order be different from my Tuesday one?
- Almost always. Cafe Parly orders 50 pastries on a Tuesday and 89 on a Saturday. A quick test for your own grid: divide Saturday's order by Tuesday's. If it is close to 1 and your Saturday sales are not, the standing order was set for a weekday and never moved.
You just read one weekday by hand. Parly lays every morning's delivery against what sold.
Parly reads what sold in Square and lays each morning's delivery against your standing order, for every pastry, with the cost of what was left. It suggests a standing order. You decide it and tell the bakery.
Start freeFree for 14 days, no card. Then $59 a month for one cafe. Nothing on this page needs an account, and it never will.
More free tools
- Count sheet builderWhat is on the shelf this morning?
- Par level calculatorHow much should each item have on hand?
- Milk order calculatorHow many cartons of each milk to order?
- Price checkWhat does the invoice come to per unit?
- Drink cost calculatorWhat does one drink cost to make?
- Modifier upcharge calculatorWhat should oat milk or an extra shot add?
- Menu price calculatorWhat should this drink sell for now?
- Labor cost calculatorWhat share of sales goes to the team?
- Tip pool calculatorWhat is each person's share of the tips?
- Weekly take-home calculatorWhat did last week leave after costs?
- Square fee calculatorWhat did card fees take from the week?
- Break-even calculatorHow many cups a day cover the month?