What one more table does to a flower order
Work through a twelfth-to-thirteenth table-vase change. See shared stem demand, reserve rounding and supplier pack thresholds change the actual purchase.
One additional arrangement can trigger an entire extra pack. Recalculate the whole event before approving a revised order. Do not multiply the previous order cost by the percentage change in table count.
Start with the bundled example
The synthetic plan contains one bridal bouquet and twelve table vases. Each vase uses 5 blush roses, 3 white ranunculus and 4 eucalyptus stems. The bouquet uses 12, 8 and 6 respectively. Reserve is 10%, with 8 usable roses and 6 eucalyptus stems already available. Prices and pack sizes are hypothetical, not supplier offers.
Load the example in the worksheet, save its JSON if you want a before copy, then change only the Table vase quantity from 12 to 13. Leave recipes, reserve, stock and both suppliers unchanged.
Recalculate demand before buying
| Variety | Recipe stems before / after | Reserve before / after | Stock | Net need before / after |
|---|---|---|---|---|
| Rose - blush | 72 / 77 | 8 / 8 | 8 | 72 / 77 |
| Ranunculus - white | 44 / 47 | 5 / 5 | 0 | 49 / 52 |
| Eucalyptus | 54 / 58 | 6 / 6 | 6 | 54 / 58 |
The added vase needs 12 recipe stems. Whole-stem reserve stays at 8 roses, 5 ranunculus and 6 eucalyptus because each revised percentage still rounds to the same integer. Reserve is calculated once per shared variety, not once per vase.
Read each supplier's pack threshold
| Variety | A pack / price | A packs before / after | B pack / price | B packs before / after |
|---|---|---|---|---|
| Rose - blush | 25 stems / CAD 42 | 3 / 4 | 20 stems / CAD 36 | 4 / 4 |
| Ranunculus - white | 10 stems / CAD 24 | 5 / 6 | 10 stems / CAD 22 | 5 / 6 |
| Eucalyptus | 10 stems / CAD 16 | 6 / 6 | 20 stems / CAD 30 | 3 / 3 |
Supplier A's roses cross from 72 to 77 net stems, exceeding the 75 stems in three packs. The fourth pack adds 25 purchased stems for just five additional rose stems of demand. Supplier B already supplied 80 roses, so its rose pack count stays at four. Both suppliers need one more ten-stem ranunculus pack. Neither needs another eucalyptus pack.
Compare complete revised orders
| Whole supplier plan | Before | After | Increase |
|---|---|---|---|
| Supplier A | CAD 342 | CAD 408 | CAD 66 |
| Supplier B | CAD 344 | CAD 366 | CAD 22 |
A was CAD 2 cheaper before the change. B is CAD 42 cheaper afterward. These are two complete supplier plans; this comparison does not optimize a mixed-supplier basket. Prices exclude delivery, tax and labor, and the tool does not evaluate flower quality or supplier reliability.
Update the make list separately
Thirteen table vases allocate 65 roses, 39 ranunculus and 52 eucalyptus stems. The bouquet remains unchanged. Reserve and pack surplus are not assigned to the vases. Keep them available rather than increasing every recipe just to consume a whole bunch.
Download the revised JSON and CSV and print the updated make list. Reconcile any real order already placed with your supplier; changing this worksheet does not amend a purchase.
Blooms By The Box explains that bunch sizes vary, including weight-based products with approximate stem counts. Confirm the actual purchasable unit before applying this arithmetic to an order. Continue with supplier comparison or reserve and stock rules.
Reviewed October 31, 2026. Examples illustrate the calculation method; they are not supplier quotes or universal floral recipes.