Tea Blending Business: Cost Each Blend and Set Trade Prices With AI

To cost a loose-leaf tea blend, add each ingredient's grams times its landed price for a cost per kilo, divide by one minus your wastage rate, then add packaging, labour and overhead for each pack size. Trade price is cost divided by one minus your target margin. AI helps build and check the sheet; you supply the prices.

The most common error is costing the tea and forgetting everything around it. A blend that costs $18.95 a kilo in leaf can cost $27.60 a kilo once the pouch, label, filling time and a fair share of rent are in, and a trade price built on the first number loses money on every pouch sold. The example below runs one blend through three formats and shows the sums in full so that you can replace the numbers with your own.

Follow me on Instagram@sagnikteaches

The inputs that decide the answer

Costing needs five groups of numbers. Gather them before opening a spreadsheet, because the sheet is only as honest as what goes into it.

Connect on LinkedInSagnik Bhattacharya

• Landed price per kilo of every ingredient. "Landed" means everything it cost to get the ingredient to your door: the supplier's price, freight, any import charges and card fees, divided by the kilos received. A $14.00 list price with $1.10 a kilo of freight is a $15.10 ingredient.
• The recipe as a percentage or in grams per kilo. The blend's formula, written so that it adds up to 1,000 g.
• Wastage. What you lose between buying the ingredients and having sellable blend: dust at the bottom of the sack, sweepings from the mixing surface, samples you give away, spillage and any batch you throw out.
• Packaging per unit. Pouch, tin, label, seal or sticker, and shipping box share if you ship.
• Labour and overhead. Minutes to fill and label a unit, your hourly cost, and a monthly overhead (workspace, insurance, software, accountant) spread across the units you sell.

Put them on separate tabs: an Ingredients tab with price per kilo and supplier, a Packaging tab with cost per unit, a Rules tab for wastage, hourly cost, overhead per unit and target margins, and then one tab per blend. Everything on a blend tab is a formula pointing at those inputs, so a supplier price change is a one-cell edit.

Subscribe on YouTube@sagnikteaches

The worked example: one afternoon blend, three formats

An illustrative small business sells a black-tea afternoon blend: a malty black tea, a brighter black tea, cornflower petals for looks, and a bergamot flavouring. The recipe per 1,000 g of finished blend, with landed prices per kilo:

In a spreadsheet that cost is one formula, with grams in column B and the price per kilo in column C:

=SUMPRODUCT(B2:B5, C2:C5) / 1000

That is the leaf cost before any loss. The first mistake to avoid is stopping here.

Wastage: divide, don't just add a percentage

Suppose three batches showed that for every 100 kg bought you end up with 96 kg you can sell, so wastage is 4%. To end up with one sellable kilo you must buy 1 divided by 0.96, or 1.0417 kg, of ingredients. The cost of a sellable kilo is therefore $18.19 divided by 0.96, which is $18.95.

Adding 4% would give $18.92. The three-cent gap is trivial at 4% and grows as wastage grows. At 12% wastage, adding gives $20.37 while dividing gives $20.67, which across a 200 kg year is about $60. Dividing is the correct method because the loss is a share of what you bought, not of what you sold. This is also a typical place where a chat model's answer needs checking: ask it to show both methods and tell you which one applies, and you will see that it can do either.

Packaging, labour and overhead for three formats

The same $18.95 a kilo of leaf goes into three products. Each pack holds 100 g of tea except the bulk bag, which holds 1 kg. Costs per unit, illustrative:

Where do the labour and overhead numbers come from? Filling labour is the time per unit multiplied by the hourly cost: 100 pouches an hour at $18 an hour is $0.18 each; tins take longer, 72 an hour gives $0.25. Overhead per unit is monthly fixed costs divided by units sold: $1,200 across 3,000 units is $0.40, and a bulk bag carries a larger share because it moves a larger quantity of tea through the same shelf space and the same invoice. How you allocate overhead is a judgement; the discipline is to allocate it somewhere, because a business that gives overhead to nothing prices everything too low.

From cost to trade price

The trade price is the price you charge a shop or café that resells your product. To reach a target gross margin on the trade price, divide the cost by one minus the margin. A 50% target means dividing by 0.5, which is the same as doubling.

The last-but-one row is the one that exposes weaknesses. The tin's price per kilo is more than twice the bulk bag's, which is fine if the tin is a gift item and the market accepts it, but you should know that a café buying the bulk bag pays $34.95 for a kilo and a shop buying tins pays $75.50 for the same leaf. Both prices must be defensible. If a café can open a bulk bag and decant it into its own jars at less than half your tin price, expect shops to notice too.

Margin on price and markup are different, and the confusion is expensive. A 50% margin is a 100% markup (price is cost times two). A 40% margin is a 67% markup (cost times 1.67). If a supplier or a book says "mark up by 50%", that is price equals cost times 1.5, which gives a margin of only 33%. Write "margin on price" in the column headings to stop the two mixing.

Where AI earns its place in the process

The arithmetic is simple enough to do by hand. AI helps with the work around it: setting up the sheet, catching mistakes and speeding up repeats. Four useful jobs, each with a prompt.

Job 1: Build the sheet structure and formulas

I blend loose-leaf tea and sell it in pouches, tins and bulk bags. I want a
costing spreadsheet with these tabs: Ingredients (name, supplier, landed
price per kg), Packaging (item, cost per unit), Rules (wastage %, hourly
labour cost, monthly overhead, units per month, target margins), and one tab
per blend that lists grams per kg, calculates leaf cost per kg, applies
wastage by dividing by (1 minus wastage), then calculates full cost and trade
price for 100 g pouch, 100 g tin and 1 kg bag. Give me the column layout and
the exact Excel formulas, using SUMPRODUCT and CEILING where useful, and tell
me which cells are inputs and which are calculated.

Illustrative output: a layout with inputs shaded and the formulas for leaf cost, wastage and price rounding, such as =CEILING(G12/(1-Rules!$B$6),0.05) for a price rounded up to the next five cents. You check by typing the example above and confirming that you get $5.55 for the pouch. If the sheet's answer differs from the table in this tutorial, find which formula is wrong before you use it with real prices.

Job 2: Check your own arithmetic

After you have built your own sheet, paste a single blend's inputs and your results (not the whole workbook) and ask for an independent recalculation.

Here are the inputs and results for one tea blend. Recalculate each figure
step by step and tell me where your result differs from mine. Inputs:
ingredients and grams per kg [list], landed prices per kg [list], wastage 4%,
pouch costs [list], labour and overhead per unit [values], target margin 50%.
My results: leaf cost $18.19, with wastage $18.95, full pouch cost $2.76,
trade price $5.55. Show the working. If a difference is under 2 cents, say it
is rounding.

This works well because the model compares two answers instead of producing one from nothing. Illustrative output: "All figures agree; the leaf cost with wastage is $18.948, which rounds to $18.95." If it disagrees, don't just accept either answer: find the step that differs. Sometimes the AI is wrong; sometimes it has spotted that you divided in the wrong place.

Job 3: Stress-test the blend against price changes

Ask what happens to the margin if one ingredient changes. Using the same blend, the cornflower petals rise from $38.00 to $52.00 a kilo. Cost in a kilo of blend rises from $3.04 to $4.16 (80 g times $52.00 per kilo), an extra $1.12, so leaf with wastage goes up $1.17 to $20.12. Pouch cost becomes $2.87 and the margin at the old $5.55 trade price falls from 50.3% to 48.3%. Seeing that figure tells you whether to absorb a rise or to change the formula (60 g of petals, 20 g more of the bright black tea) or the price.

Job 4: Write the trade price list and the explanation

When the numbers are settled, the AI can turn them into a clean price list and a short note for new stockists. It needs only the final prices and your terms, not your costs. Keep costs out of anything you send to customers.

Write a one-page trade price list for a tea blender. Products: Afternoon
Blend in a 100 g pouch ($5.55 trade, minimum order 12), 100 g tin ($7.55,
minimum 6), 1 kg bulk bag ($34.95, minimum 2). Add a short ordering section:
payment terms 14 days, free delivery over $150. Keep it plain and friendly,
no marketing claims about health.

Notice the last line of that prompt. Health claims about tea are regulated in many places, so leave them out of anything the AI drafts unless you have checked what you may say. For the wider question of how trade, volume and key-account prices fit together, the tiered wholesale pricing tutorial builds on exactly this sheet.

Working backwards: pricing a blend before you buy anything

The sheet also runs in reverse, which is the better way to design a new blend. Say a shop you want to supply will pay no more than $5.55 for a 100 g pouch, and you need the usual 50% margin. The most the pouch can cost you in total is $5.55 times 0.5, or $2.775. Take away the parts that don't depend on the tea (pouch $0.22, label $0.06, filling $0.18, overhead $0.40, which is $0.86 in all) and $1.915 is left for the tea in a pouch. That is $19.15 a kilo of sellable blend. With 4% wastage you can spend 96% of that on ingredients, which is $18.38 a kilo of recipe.

Now the creative work has a boundary. The afternoon blend costs $18.19 a kilo, so there is room for a slightly pricier petal or a second flavouring of about 20 cents a kilo, and no room for the $52.00 petals. A recipe that costs $22 a kilo needs a different format (a tin), a different customer (one who pays more) or a different margin target. AI is a useful partner in this phase: describe the flavour you want and the ceiling in dollars per kilo, ask for five alternative recipes in grams from a list of ingredients you already stock, and recalculate each one in your sheet rather than trusting its cost estimate.

I blend loose-leaf tea. My current ingredients (landed price per kg): malty
black tea $14.00, bright black tea $18.50, cornflower petals $38.00, bergamot
flavouring $60.00, dried orange peel $22.00, rose petals $44.00, vanilla pieces
$120.00. Propose three new blends of 1,000 g each that taste distinct from my
Afternoon Blend, each with a total ingredient cost under $18.38 per kg
(show the working per ingredient). Use only these ingredients, and
keep flavouring under 25 g per kg.

What you fix in the output: check each total on a calculator (a chat model can be a dollar out on a long sum), taste-test the blend before it goes near a price list, and note that a flavour description is a guess, not a tasting. The cost is the part you can verify; the taste is yours to judge.

A costing that looked fine and wasn't

Here is the shape of an error that catches blenders in their first year. A new business costs its flagship blend at $2.10 a pouch because it used a quote for the tea alone and a pouch price from a bulk invoice. Its trade price of $4.20 looks like a comfortable 50%. A year later, the accounts show the tea business earning less than it paid in staff time. The missing items: the flavouring was bought in 1 kg minimums and a third of each tub expired before use (wastage the sheet never recorded), the pouches were bought in 5,000s but the price used was the 10,000 price, and no overhead was allocated. Rerunning the sheet with the real figures gave a full cost of $3.05 and a true margin of 27%. The fix was not clever: it was one tab for ingredient prices with the pack size and minimum order next to each price, and a quarterly review.

Smaller details that move the answer

• Minimum purchase quantities. If a flavouring only comes in 1 kg and you use 20 g a kilo of blend, it covers 50 kg of blend. If you only blend 30 kg before it loses strength, the unused remainder is a cost. Add a "usable life" note to each ingredient and charge expired stock to wastage.
• Batch size. Mixing evenly needs a minimum batch, often 5 to 10 kg for hand blending. A small order of 2 kg still means a batch to clean up after. Cost the setup time as a fixed cost per batch, divided by batch size.
• Samples. Free samples to prospective stockists are marketing, and they belong in a line of their own so that you can see what winning an account costs.
• Seasonal prices. Leaf prices move between harvests and some ingredients such as petals and spices swing more. Keep the date next to each price and refresh them at least quarterly.
• Currency and freight. If you buy in another currency, the landed price moves with the exchange rate. A single "exchange rate" cell on the Rules tab lets you update every landed price at once.
• Labels. A flavouring or colouring change can alter the label. The supplier specification change check covers how to catch that before printing.

Applying the same method to other small makers

The structure is the same wherever a maker blends or assembles ingredients into a pack: ingredients with landed costs, loss, packaging, labour, overhead, then price. A dog groomer who makes and sells a shampoo bar, a bakery that sells packs of its granola mix, a café that bottles its own syrup and a driving school selling lesson bundles with a printed workbook can all use the same four tabs. Only the recipe tab changes, and the check of "what if one input rises" is useful in every case. For a chocolate start-up, this costing and labelling tutorial follows the same pattern with different packaging, and the product-by-product margin check is the next step once you have several blends.

How to check the sheet before you publish prices

• Recalculate one blend by hand on a calculator, including wastage and one packaging line.
• Check that the margin column on each blend equals (trade price minus full cost) divided by trade price, not divided by cost.
• Change one ingredient price by 50% and confirm that every blend that uses it moves, and the others do not.
• Compare the price per kilo of your pouch, tin and bulk bag, and decide whether the ratios make sense to a buyer.
• Sort all blends by margin. If one sits ten points under the rest, find out why before you take its next order.

When all five pass, publish the trade prices, save a dated copy of the workbook, and set a quarterly reminder to refresh the ingredients tab. If you'd rather talk through your own blends and formats, that is what a 1:1 call is for, but the sheet above is enough to start with, and most blenders find that the first honest costing changes at least one price.

Tea blend costing questions

What margin should a tea blender aim for on trade sales?

There is no fixed figure. The worked example uses 50% gross margin at the trade price for packs, 40% for bulk and a retail price of about twice trade, as illustrative targets; your own figure depends on overheads and volumes. Work backwards from what you must earn per hour, not from a rule of thumb, and test the result against a lower bulk-price margin.

How much wastage should I allow when blending tea?

Measure it rather than assume it. Weigh what you buy for a batch, weigh what you pack, and note the difference, including dust, sweepings, samples and spillage. Until you have data, use a placeholder such as the 4% in the worked example and replace it with your own measured figure after three batches.

Should I price per 100 g or per kilo?

Cost per kilo, then price per pack. Keep the per-kilo figure in the sheet because it lets you compare blends and formats fairly. Show customers the price per pack, and add a per-100 g price to the label or listing only where your selling rules call for unit pricing.

Can ChatGPT or Claude work out the cost of a blend for me?

They can build the sheet structure, explain the formulas and check your arithmetic, but you should type the prices and let the spreadsheet calculate. A chat model can slip on multi-step sums, and the whole result depends on correct inputs, which only you hold.

How often should I recalculate blend costs?

Whenever a supplier price changes, and at least quarterly. Keep a single ingredient price tab that every blend reads from, so one edit updates every blend. Then glance at the margin column once a month for any blend that has slipped below your floor.

Further reads

• AI Prompts for Bakers: Pricing, Captions and Customer Replies — See a similar pricing routine for a small food maker.
• Faire vs Ankorstore: Which Wholesale Marketplace Suits a Small Brand? — Compare marketplaces for selling your blends wholesale.
• Can AI Help a Small Shop Set Prices and Promotions? — Set retail prices and promotions for your own shop.
• Best AI Tool for Pricing Wholesale Goods: Chat Assistant or App? — Choose between a chat assistant and a pricing app.
• How Can a Coffee Shop Use AI? Start With Supplier Prices — Cost a drinks menu from supplier prices.
• Supplier Price Increases: Update a Wholesale Price List With AI — Update prices when a supplier raises its list.
• Tea Shop Marketing Ideas: Tasting Notes and Gift Sets Written With AI — Turn your own cupping notes into shelf cards and product pages, then price subscription tiers and gift sets by margin before AI writes a word of copy.
• Clothing Cost Sheet: AI Costs a Style From Its Tech Pack — A sweatshirt costed line by line from its tech pack, from fabric metres to wholesale margin, with the checks that stop AI under-costing a style.
• Sublimation Printing Business: Price Jobs and Proof Designs With AI — A worked 24-mug quote built from blank, ink, paper, press time and spoilage, plus the proof email and AI prompts that keep both honest.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Microsoft Excel function documentation (SUMPRODUCT, CEILING); all prices, weights and margins in the example are illustrative.