The job of the system
Before accepting or preparing an order, a florist needs to answer three questions:
- What will this arrangement cost?
- What should we charge?
- What do we need to buy?
This blueprint suits a florist producing recurring bouquet designs alongside custom arrangements, where the owner currently estimates costs and prepares supplier orders manually.
A bouquet’s selling price has to cover more than its main flowers. Fillers, foliage, wrapping, ribbons, preparation time and delivery can all affect what the business earns. The proposed system connects each bouquet’s ingredients with current purchase costs and confirmed orders. It helps the owner spot an underpriced arrangement and prepare a consolidated shopping list.
1. Create a simple materials catalogue
The florist records the materials they regularly use:
| Material | What the system records |
|---|---|
| Flowers | Variety, supplier, purchase unit, stems per bunch and latest cost |
| Fillers and foliage | Purchase quantity, cost and usable quantity |
| Packaging | Wrapping sheets, ribbons, boxes, baskets and floral foam |
| Extras | Cards, chocolates, soft toys and other additions |
| Labour | Estimated preparation time and an owner-defined hourly cost |
Prices can be updated from supplier invoices. The system preserves the purchase-unit conversion, such as a bunch containing ten stems, so bouquet calculations use a consistent unit.
Detailed inventory tracking is optional. The first version can work with current costs and a manually entered usable-stock count.
2. Define a recipe for each standard bouquet
Each design has an editable recipe. For example:
- Six rose stems
- A defined quantity of filler and foliage
- Two wrapping sheets
- One ribbon and message card
- Twenty minutes of preparation
The florist can create small, medium and large versions. A custom arrangement starts from a recipe that staff adjust to the customer’s request.
Recipes remain planning estimates because actual materials used may differ.
3. Check the price before quoting
The system calculates an estimated direct cost and shows what remains at the proposed selling price.
The following figures are illustrative only:
| Item | Estimated cost |
|---|---|
| Flowers, fillers and foliage | RM48 |
| Packaging and card | RM10 |
| Preparation labour | RM12 |
| Wastage allowance | RM5 |
| Estimated direct cost | RM75 |
| Proposed selling price, excluding delivery | RM120 |
| Contribution before overhead and other costs | RM45 / 37.5% |
That RM45 is not net profit. Rent, marketing, payment charges and other expenses may still need covering.
If a supplier price increases, the system flags affected designs for review. The florist decides whether to adjust the selling price, change the recipe or accept a lower contribution.
4. Turn confirmed orders into a purchase plan
The owner selects a preparation period, such as Friday through Sunday. The system combines the materials required across confirmed orders, subtracts usable stock and rounds purchases to supplier pack sizes.
For example, if production requires 48 rose stems and 13 usable stems remain, the shortage is 35. If the supplier sells ten-stem bunches, the proposed purchase is four bunches.
The owner reviews the list before ordering. Unconfirmed enquiries stay separate so speculative demand does not automatically trigger purchases.
5. Record substitutions and actual usage
After preparation, staff records significant differences: extra stems used, flowers discarded or a more expensive substitution.
The system compares estimated and actual material costs. Over time, the florist can identify recipes that repeatedly underestimate usage and revise them.
Calculation boundaries
The planning result is only as useful as its inputs.
| Calculation | What it means |
|---|---|
| Unit cost | Current purchase cost converted into the recipe’s working unit |
| Estimated direct cost | Recipe materials, labour and the configured wastage allowance |
| Contribution | Proposed selling price less estimated direct cost, before overhead and other expenses |
| Purchase shortage | Confirmed recipe demand less usable stock |
| Proposed purchase | Shortage rounded up to the supplier’s purchase unit |
Delivery can be priced separately from the bouquet. Supplier orders remain manual, and the owner reviews both pricing changes and purchase quantities before acting.
What the first version includes
The first version consists of:
- Materials catalogue
- Editable bouquet recipes and size variants
- Costing and proposed-price screen
- Confirmed-order purchase list
- Short actual-usage adjustment form
Supplier ordering remains manual. Detailed perpetual inventory can wait until the simpler cost and usable-stock model proves useful.
How to demonstrate its value
The strongest demonstration increases one flower’s purchase price and shows which bouquet designs need a pricing review. It then generates the shopping list for the weekend’s confirmed orders, subtracting usable stock and rounding shortages to supplier pack sizes.
The system should also make its maintenance cost visible. If keeping supplier prices, recipes and usable stock current takes more effort than the planning saves, the florist should simplify the tracking before adding features.