Business financial model file
Flower Shop Financial Model
Budget floral cold storage, fresh stock and labor, then test bouquet contribution against both stem loss and production time.
Opening investment and working cash
The original small-shop case keeps fresh opening stock separate from the cold room and worktables.$4,500 of inventory is a working input that can expire; it is not permanent capital. Obtain seasonal stem quotes and minimum delivery terms before assuming the same bouquet mix all year.
| Cash use | $ |
|---|---|
| CAPEX: Floral cold storage | 12,000 |
| CAPEX: Worktables/display and fit-out | 18,000 |
| CAPEX: POS/tools and delivery equipment | 6,000 |
| Pre-opening: Lease/setup/professional costs | 3,000 |
| Pre-opening: Pre-opening training and launch | 4,000 |
| Refundable deposit / tied-up cash | 5,000 |
| Opening stock / initial working inputs | 4,500 |
| Reserve: 2 selected fixed-cost months | 34,700 |
| Selected opening cash total | 87,200 |
CAPEX totals $36,000, pre-opening expense $7,000 and working cash $44,200. The deposit and opening stock tie up cash; they are not added again as monthly rent or consumed inputs. The reserve is a chosen fixed-cost buffer, not proof of full funding. Obtain actual installed/tax-inclusive quotes and dated opening payments.
Monthly fixed and variable OPEX
Loaded monthly staff cash is budgeted at$12,500. The variable flower line already includes selected stem wastage, while cold-room base energy and delivery commitments are fixed below. A wedding installation or urgent route needs a separate crew/vehicle step.
| Commitment | $ per month |
|---|---|
| Florist and counter/manager: loaded budget | 12,500 |
| Rent/common charges | 2,500 |
| Base refrigeration/utilities | 550 |
| Insurance | 250 |
| Software/POS | 200 |
| Standing delivery commitment | 500 |
| Marketing | 400 |
| Cleaning/waste/admin | 450 |
| Total selected fixed cash | 17,350 |
| Item | $ per unit |
|---|---|
| Net collected selling value | 55 |
| Flowers/greenery including selected wastage | 20 |
| Wrap/vase and consumables | 4 |
| Incremental delivery allocation | 2 |
| Percentage-only fee allocation (3%) | 1.65 |
| Contribution before scheduled payroll/fixed OPEX | 27.35 |
The percentage fee is an aggregate allocation, with no fixed per-payment charge assumed. Unit contribution is not owner income: the full listed monthly roster and overhead still need coverage.
Capacity, break-even and a lower-sales case
Two hundred productive florist hours at 0.2 hours per standard bouquet allow 1,000 bouquets, but fresh-stem availability supports 960 in the selected mix. Plan 900. A premium arrangement or an event setup does not have the same unit hours or stem requirements.
For this fixed mix and commitment, whole-unit cash break-even is 635 paid standard bouquets per month: ($17,350) ÷ $27.35, rounded up. The aggregate capacity is 960 units; it does not establish customer demand or a workable daily sequence.
| Paid units | Net sales $ | Selected result $ |
|---|---|---|
| 650 | 35,750 | 427.50 |
| 635 | 34,925 | 17.25 |
| 900 (planned) | 49,500 | 7,265 |
| 960 | 52,800 | 8,906 |
At 650 bouquets the lease and loaded roster remain; fresh-stock purchases also need to be cut early enough to prevent a larger discard. The retained guide case below isolates a different order-window decision.
Practical KPI definitions
Track saleable-stem yield from received stems after rejects, flowers consumed per sold bouquet and discarded-stem cost separately. Use bouquet contribution after delivery costs, and measure florist hours by arrangement type rather than using the retail selling price as labor productivity.
All prices exclude sales tax; purchases replenish the opening stock within the month. Special-event deposits, refunds, card timing, debt and income tax are outside this selected month.
Method context: SBA business planning. All case prices, wages, cost ratios, reserve and capacity inputs above are original planning assumptions.
What the model covers
The official FinModelsLab listing describes an editable five-year Excel workbook for bouquets, arrangements, event florals, subscriptions and gifts. Weekday visits convert to buyers; repeat cohorts add orders, which become units and category revenue. Stated outputs include profit and loss, monthly and annual cash forecasts, break-even/startup planning and dashboard charts.
Use the preparation ceiling before setting sales
Our original batch needs 74 completed orders to recover selected payments, but the assumed preparation window fits only 75. Full use leaves $50; two missed orders produce a $34 shortfall. Materials bought for 100 do not make 100 orders deliverable.
Cap the order forecast with complete preparation and delivery windows. Record paid reservations and remaining balances once, and price leftovers from observed condition. The Flower Shop planning guide develops the original worked case.
Planning guide