How to round flower stems to supplier bunches
Divide net stem need by confirmed stems per pack, round up to a whole pack, then calculate the surplus separately for each flower and supplier.
The pack formula
Once reserve and existing stock are accounted for, packs to buy equals the ceiling of net need divided by stems per pack. Ceiling means the next whole number whenever any fraction remains. Purchased stems equal packs multiplied by stems per pack.
For 72 net rose stems in 25-stem packs, 72 / 25 = 2.88, so buy 3 packs. These contain 75 stems and leave 3 stems beyond the net need. Buying 2 packs would leave a 22-stem shortfall.
| Net need | Stems / pack | Packs | Purchased | Pack surplus |
|---|---|---|---|---|
| 0 | 25 | 0 | 0 | 0 |
| 25 | 25 | 1 | 25 | 0 |
| 26 | 25 | 2 | 50 | 24 |
| 72 | 25 | 3 | 75 | 3 |
A bunch is not a universal unit
Use the exact product's confirmed stem count. Blooms By The Box's FAQ notes that bunch sizes vary and some greenery is sold by weight with an approximate stem count. The sample pack sizes in StemOrder are editable illustrations, not defaults for all roses or greenery.
If a product is sold by weight, ask the supplier for a dependable ordering unit. A calculator that treats an approximate ten stems as a guaranteed ten can understate risk. StemOrder requires a positive whole-number pack size. It does not model a weight-to-stem distribution, a mixed grower's bucket or guaranteed minimum yield from branching greenery.
Round after sharing the demand
Imagine two recipes needing 12 and 13 roses. If you buy one 25-stem pack for each recipe, you receive 50 stems. Combining demand first gives 25 stems and just one pack. The same purchased pack can serve several arrangements when their varieties and grades match.
This does not mean different colours are interchangeable. Separate purchasing lines remain separate even when both happen to use 25-stem packs. Do not combine varieties to avoid rounding unless you have explicitly redesigned the recipes.
What the pack result leaves out
A supplier may impose a minimum number of packs, case quantities, order thresholds or delivery charges. This first version models one fixed pack size per variety per supplier. If a product must be bought as a case, enter the case stem count and case price as the pack, rather than the smaller bunch that cannot be purchased independently.
The worksheet does not optimize a mixture of ten- and twenty-five-stem packs from one supplier. Use a single confirmed purchasable size for the comparison, then review any alternative with the supplier. Continue with a complete supplier cost comparison so a lower price per stem does not conceal a larger rounded order.
Reviewed October 31, 2026. Examples illustrate the calculation method; they are not supplier quotes or universal floral recipes.