The Sunday-Night Stem Math: How Flower Farmers Stop Overcommitting Their Blooms

Every flower farmer knows the Sunday-night feeling. The week ahead has a wedding, a market, a stack of CSA shares, and two florists who texted asking what you've got. Somewhere — in a spreadsheet, a notebook, or just your head — is the answer to one nerve-wracking question: can my field actually cover all of this?

Get it right and the week runs like clockwork. Get it wrong and you're either apologizing to a bride or composting $300 of blooms you couldn't sell.

Here's the thing almost no software helps with: the gap between what you grow and what you sell. Crop planners (Tend, Farmbrite) are great at planning beds, but they don't know who you've sold flowers to. Florist tools (Curate, Details) are great at proposals, but they assume you buy every stem wholesale. The farmer-florist lives in the gap between them — and that gap is exactly where the Sunday-night math happens.

The 4-step weekly reconcile (do this every Sunday)

1. List the week's demand. Every order, by variety, in stems: wedding pieces, wholesale, market bunches. Add your CSA: shares × stems per share.
2. Total stems-needed per variety. Your wedding wants 180 Café au Lait; market wants 100 zinnias; etc. Sum them up.
3. Estimate your realistic cut per variety this week. Not your dream harvest — what you'll actually get from rows that are blooming now.
4. Subtract. Needed minus cut. Negatives are your buy-in list — source those before you promise them. Positives are your surplus — that's what fills CSA bouquets and goes to market.

A real example

Say it's late July. You've booked the Garcia–Lee wedding (180 Café au Lait, 60 Cornel, 40 zinnias), a wholesale order, a market table, and 40 CSA shares. Run the reconcile and you find: you're 60 Café au Lait short (buy those in), but you've got 120 surplus zinnias (market special), and after building 40 CSA bouquets from surplus you still have 105 stems to spare. No surprises. No 2am panic.

Why a spreadsheet eventually breaks

A spreadsheet can do steps 1–3 if you're disciplined. Where it falls apart: it can't connect your bloom windows to your orders automatically, so every new order means re-doing the math by hand, and one fat-fingered cell quietly promises a bride flowers you aren't growing.

That's the exact problem we built Stemwise to solve — it runs this reconcile for you, every week, by variety.

Either way: do the reconcile. Your Sunday nights will thank you.