Florist: Stem Bunches To Order

All versions

A floral recipe is written in stems and the wholesaler sells in bunches, and somewhere between the two a percentage of every order arrives bent, blown, or short. Order to the recipe alone and you finish the last centerpiece one rose short.

Quick formula: Stems needed with shrink, divided by the bunch count, rounded up:

=ROUNDUP(B2*C2*(1+D2)/E2,0)

24 centerpieces at 5 stems of eucalyptus, plus 10% shrink, is 132 stems — 14 bunches of 10.

Functions used (tap for the full reference guide):

ROUNDUP PRODUCT

The example

Three stems in one wedding recipe, each with the count per arrangement, a shrink allowance, and the bunch size the wholesaler ships.

	A	B	C	D	E	F
1	Stem	Arrangements	Stems each	Shrink	Stems/bunch	Bunches
2	Garden rose	24	12	10%	25	13
3	Eucalyptus	24	5	10%	10	14
4	Spray rose	24	3	10%	10	8

The formula

Recipe, then allowance, then bunches:

=ROUNDUP(B2*C2*(1+D2)/E2,0) // arrangements x stems each x (1 + shrink), / bunch size, rounded up

How it works

Four inputs and one multiplier that people forget:

B2*C2 is the recipe: arrangements times stems each. This is the number on the design sheet.
*(1+D2) is the shrink allowance. Ten percent covers normal loss on hardy stems; delicate garden roses and ranunculus want fifteen or twenty.
/E2 converts stems to bunches. Bunch counts vary wildly by stem — roses at 25, greenery often at 10 — so it belongs in a cell, never in the formula.
ROUNDUP(...,0) because the wholesaler will not split a bunch.

Multiply bunches by the wholesale price for a flower cost, and compare it to the design fee to see whether the recipe still works at this season's market.

Try it: interactive demo

Interactive

Enter the recipe, your shrink allowance, and the bunch size.

Arrangements

Stems each

Shrink (%)

Stems per bunch

Variations

Flower cost

Multiply bunches by the wholesale price per bunch.

=ROUNDUP(B2*C2*(1+D2)/E2,0)*32

Stems left over

See how many spare stems the rounding buys you.

=ROUNDUP(B2*C2*(1+D2)/E2,0)*E2-B2*C2

Pitfalls & errors

Shrink is not one number for the whole order. Hardy greenery loses almost nothing; a box of open garden roses in July can lose a fifth. Give each stem row its own allowance.

The leftover-stems variation is worth keeping on the sheet. Rounding up on a 10-stem bunch usually leaves enough for a boutonniere or a bud vase, which is free product if you plan for it.

Do not enter shrink as 1.1 in the shrink column while the formula already says (1+D2). That compounds to a 110% allowance and doubles the order.

Practice workbook

📊

Download the free Florist: Stem Bunches To Order practice workbook

Edit the yellow recipe, shrink, and bunch-size cells; the bunch count recalculates.

Frequently asked questions

What shrink allowance is realistic?

Ten percent is a workable default for a mixed order. Push it to fifteen or twenty for delicate or fully open blooms, and drop it to five for hardy greenery and chrysanthemums.

Should I order to the bunch or to the stem?

Order to the bunch, because that is what ships. Building the sheet in stems and converting at the end keeps the design recipe readable while the purchase order stays buyable.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: ROUNDUP PRODUCT