Sources & calculation rules
The numbers follow a published method. Your flower recipes, supplier pack sizes and prices remain your inputs.
Calculation contract
- For each shared variety, sum stems per arrangement multiplied by arrangement count.
- Multiply that sum by the chosen integer contingency percentage, then round the reserve up to a whole stem.
- Subtract usable stock from recipe stems plus reserve. Clamp net need at zero.
- For each supplier, divide net need by its pack size and round up to a whole pack.
- Purchased stems equal packs times pack size. Pack surplus equals purchased stems minus net need.
- Round an entered two-decimal price to integer minor units, multiply by packs and sum the variety subtotals. No delivery, tax, labour, supplies or exchange conversion is included.
The ceiling operations are applied per variety, after combining recipes. IDs preserve shared variety identity; names alone do not merge rows. A plan can contain 100 varieties and 50 arrangements with up to 100 recipe lines each. Each variety is limited to 1,000,000 recipe stems.
Primary references
- Blooms By The Box: wholesale flower FAQ. Supports checking product-specific bunch units, approximate counts for weight-based products and supplier substitution terms. It does not validate the sample's pack sizes or prices.
- Iowa State Extension: creating a floral arrangement. Context for testing flower size, stem length, foliage and container proportions rather than relying on one universal recipe.
- Royal Horticultural Society: cutting and conditioning. Preparation and care guidance relevant to deciding whether existing stock is usable.
- Iowa State Extension: harvesting, conditioning and care. Additional guidance on clean vessels, water and cut-flower care.
Limits and commercial status
Source review: October 31, 2026. Sources explain units and handling; the worksheet's worked numbers are original synthetic examples. No source endorses this product. A reserve percentage is an operator choice, not a published loss prediction.
There are no live quotes, sponsored supplier rankings, affiliate tracking links, ad scripts, paid exports or claims of guaranteed flower suitability. No merchant relationship or commission rate is represented. See the publisher disclosures.