Floral Department Turn & Freshness Calculator

Stems In, Bouquets Out

Floral runs on a different unit than the rest of the grocery store. Inventory arrives as bunches and ships as bouquets, with every stem moving through a recipe in between. A four-bunch rose receipt at 25 stems per bunch is 100 stems, and that 100 stems might roll into eight dozen-rose bouquets, or two dozen-rose and twelve mixed-garden arrangements, or thirty stems pulled for a wedding side order with the rest still on the shelf. This tool keeps the math on a stem basis — receipts in, recipe ingredients out — so the buyer can see at a glance which variety is feeding which bouquets and how much of the order is actually clearing the case before vase life runs out.

Vase Life and the Markdown Window

Cut flowers don’t have a sell-by date stamped on the carton, but they have a window. The Society of American Florists publishes general care-and-handling guides that put the typical retail vase life at around 5 to 10 days for the common varieties — roses on the shorter end, carnations on the longer end — assuming clean water, cool storage, and a fresh cut on arrival. The starter values shipped with this tool sit in that range and are meant to be edited against the holding conditions of your operation. The recommended markdown date is the receipt date plus the vase life minus two days, leaving enough time for the discount to actually move stems before they hit the bin.

Turn Rate as the Buyer’s Signal

Stems-sold-last-7-days divided by stems-on-hand gives turns per week. A variety running over one full turn per week is keeping up with demand; one well under is over-ordered or under-merchandised. The tool flags any variety whose weeks of supply exceeds twice its vase life — that’s the threshold past which the next order should almost certainly shrink. The stem-flow chart visualizes the same data on a 14-day window: green bars are stems received, red bars are stems consumed by sales. Variety-level imbalances are usually obvious within one or two weeks of logging.

Bouquet Recipes and Cost

Recipe cost is the sum of per-stem cost across each ingredient variety (weighted by the receipt-average per-stem cost) plus packaging. Retail minus cost is margin, expressed as a percentage. Feasible-units pegs each recipe to its limiting variety — the bouquet you can build the fewest of given current inventory — so the case can be planned around what’s actually in the cooler rather than what the recipe card calls for in isolation. When a recipe’s limiting variety is the same one running short on turns, that’s the bouquet to push.

Automating Floral

This calculator runs in the browser against numbers you type. The step that actually changes the loss number is wiring the wholesale order portal and the POS into a nightly process that updates receipts and sales without anyone re-keying them. I build production and ordering systems for floral and prepared-foods departments. Companion tools: Produce Shrink & Rotation Calculator, Margin & Markup Calculator, and Reorder Point Dashboard.