{"product_id":"florist-flower-order-cost-calculator","title":"Florist Flower Order and Cost Calculator","description":"\u003cp\u003eThis florist business calculator costs your flowers stem by stem before you send the quote, not after the event. It is for wedding florists and flower shops who want to see the cost and margin of every arrangement in a job, and to catch the one that is losing money while there is still time to change it.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eStems, costed before you quote\u003c\/h2\u003e\u003cp\u003eThe Stem Count tab works like a recipe cost sheet for floral design. It holds 120 lines, each tagged to an arrangement.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eThe flower, how many stems, the unit and the unit cost\u003c\/li\u003e\n\u003cli\u003eFive units: stem, bunch, yard, each and gram\u003c\/li\u003e\n\u003cli\u003eLine cost calculated, then summed into a cost per arrangement\u003c\/li\u003e\n\u003cli\u003eWhat you sold the arrangement for, right beside its cost\u003c\/li\u003e\n\u003cli\u003eStems counted for each arrangement\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eMargin against the trade rule of thumb\u003c\/h2\u003e\u003cp\u003eA common guide in floristry is that flowers should be about a third of the price, which is a profit margin of around 67%. Any arrangement under 65% turns red. That does not mean the job is wrong. It means a lower margin is something you chose rather than something you found out later.\u003c\/p\u003e\u003ch2\u003eOne margin per arrangement\u003c\/h2\u003e\u003cp\u003eA wedding is not one number. The bridal bouquet, the posies, the buttonholes, the centerpieces and the arch are kept as separate arrangements, each with its own margin. That mirrors how a wedding quote actually breaks down and shows you which single line is dragging the job down.\u003c\/p\u003e\u003ch2\u003eThe ledger behind it\u003c\/h2\u003e\u003cp\u003eA flower business is still a business, so the bookkeeping sits in the same file.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eClients:\u003c\/strong\u003e who you work for\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome and Expenses:\u003c\/strong\u003e both registers\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly, Quarterly and Profit and Loss:\u003c\/strong\u003e totals by period\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBalances and Dashboard:\u003c\/strong\u003e the full picture\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you copy, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: a worked example of a full wedding with bouquet, posies, buttonholes, centerpieces and an arch, and a blank copy\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready the moment payment clears. The calculator is for personal and business use on your own devices, so please do not share or resell the files. Questions? Reach us through our contact page.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I cost foliage and ribbon that are not sold by the stem?\u003c\/h3\u003e\u003cp\u003eYes. Each line can use one of five units: stem, bunch, yard, each or gram.\u003c\/p\u003e\u003ch3\u003eWhy does an arrangement turn red?\u003c\/h3\u003e\u003cp\u003eMargin is checked against the rule of thumb that flowers are about a third of the price. Any arrangement with a margin under 65% turns red.\u003c\/p\u003e\u003ch3\u003eCan I see the margin on each part of a wedding?\u003c\/h3\u003e\u003cp\u003eYes. The bouquet, posies, buttonholes, centerpieces and arch are separate arrangements, each with its own cost and margin.\u003c\/p\u003e\u003ch3\u003eHow many stem lines does it hold?\u003c\/h3\u003e\u003cp\u003eThe Stem Count tab has 120 lines across your arrangements.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866696798,"sku":"OPX-123","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/florist-flower-order-cost-calculator-01.jpg?v=1790832628","url":"https:\/\/opxviashop.com\/products\/florist-flower-order-cost-calculator","provider":"OPXVIA","version":"1.0","type":"link"}