Hot Sauce Profit Margins: A Per-Bottle Cost Example

Define the cost boundary first

Give each subtotal a name before entering prices. In this worksheet, production cost means ingredients, packaging and production labor. Selling expenses sit outside that subtotal. Contribution is the amount left after the modeled variable costs; it helps pay fixed expenses. The remainder after our chosen overhead allowance is a narrower result than a complete business profit report.

Use a separate line for every item you intend to include. Write “excluded” beside anything you have not estimated, instead of leaving a blank that could look like zero. For this exercise, taxes, interest, shipping, returns and equipment purchases are excluded. The example cannot tell you what you can withdraw from the business.

Keep the reporting period visible beside the totals. A balance sheet records assets and obligations alongside net worth; it does not replace the period calculation used here. If you want a monthly planning worksheet, put that month's sales and relevant costs together. Do not compare a single market day's receipts with a full year's overhead without explaining the allocation. Save the assumptions beside the answer so a later revision remains understandable.

Set up a hypothetical batch

Assume we make 100 sellable bottles and sell every bottle during the same modeled period. The realized selling price is $8.00 per bottle. The $8.00 price, $4.30 variable total and $3.70 contribution arithmetic are adapted from Penn State's educational example. Our batch size, component costs, labor allowances and overhead are illustrative additions, not observed business data. No bottles remain in inventory, and the example contains no discounts, samples or shipping reimbursements.

Our hypothetical per-bottle allowances are $0.85 for ingredients, $1.25 for packaging, $0.80 for production labor, $0.40 for payment and selling fees, and $1.00 for selling labor. Packaging combines the bottle, cap and label. Do not add another bottle charge beneath that combined allowance.

The production labor allowance comes from four hours at an assumed $20 per hour, divided across the 100 bottles. Selling labor comes from five hours at the same assumed rate, divided across the same sold quantity. The rate is an example input, not a wage recommendation. Record both kinds of work even if the owner performs them.

Start a copy of this worksheet before replacing the assumptions. Keep actual invoice amounts and measured hours distinguishable from estimates. When a cost is unknown, leave it explicitly unresolved rather than choosing a small number to make the result attractive.

Add the per-bottle costs

Penn State's pricing guidance includes ingredients, labor, packaging and sales commissions among variable costs. Our amounts are hypothetical allocations to those kinds of expenses. Keep the arithmetic visible in short lines so another person can check what was counted.

Ingredients $0.85 + packaging $1.25 + production labor $0.80 = $2.90 production subtotal per bottle.

Payment and selling fees $0.40 + selling labor $1.00 = $1.40 selling subtotal per bottle.

Production $2.90 + selling $1.40 = $4.30 total modeled variable cost per bottle.

The separate production subtotal is useful when comparing changes to the recipe or container. The combined total answers a different question: how much this model assigns to producing and selling each bottle. Neither subtotal includes the fixed overhead allowance introduced below.

For your own version, list what each combined entry contains. Does packaging include a reducer or shrink band? Does production time include cleaning? Does selling time include setup and travel? Decide where those belong and enter them once. If an invoice covers supplies for several batches, record the allocation you used; do not silently charge the entire purchase to one bottle run.

Calculate contribution and the period remainder

Using the adapted hypothetical $8.00 selling price, subtract the $4.30 variable cost: $8.00 − $4.30 = $3.70 contribution per bottle. Divide by the selling price to express it as a share of revenue: $3.70 ÷ $8.00 × 100 = 46.25%. Dividing by cost would answer a different percentage question.

With all 100 bottles sold, modeled revenue is $800. Modeled variable costs are $430, leaving $370 contribution. Assume another $150 of fixed overhead for that same period. The calculation becomes $370 − $150 = $220 remaining before the excluded costs.

Call that $220 the modeled period remainder. It is not verified net profit, owner take-home pay or a cash balance. The labor allowances are already included in the cost stack, but excluded expenses could still change the result. Our fully sold assumption also matters: this example does not model cash tied up in unsold bottles.

When checking your own result, put the bottle count next to both revenue and variable expense totals. Then check whether the overhead amount belongs to the same period. A correct subtraction can still describe the wrong business question when its inputs refer to different batches or dates.

Read break-even within the stated assumptions

The SBA's unit break-even formula divides fixed costs by sales price per unit minus variable cost per unit. Applying that formula to our hypothetical model gives $150 ÷ $3.70 = about 40.54 bottles. Round up to 41 whole bottles.

At 40 bottles, contribution would be $148, leaving a $2 gap against the overhead allowance. At 41, contribution would be $151.70, or $1.70 above that allowance. These figures assume the selling price and every per-unit variable allowance remain unchanged as quantity changes.

That last condition is essential. Our original labor hours were allocated across a fully sold batch. The break-even calculation treats the resulting per-bottle labor costs as if they continue to scale with units. If you must pay for a whole kitchen booking or a fixed market shift, build those commitments into a different model. Some costs combine fixed and variable components.

Do not interpret “41 bottles” as recovering every dollar already spent on a prepaid batch of 100. Cash recovery from committed inventory requires tracking the cash already paid, future payments and receipts separately. The unit formula alone does not provide that answer.

Change assumptions before changing the plan

Try a lower realized price while leaving the other hypothetical inputs unchanged. At $7.00 per bottle and $4.30 variable cost, contribution becomes $2.70. Selling 100 bottles would leave $270 contribution and $120 after the same $150 overhead allowance. Whole-unit break-even rises to 56 bottles under the constant unit-cost model.

That scenario holds fees at $0.40 only by assumption. If your actual payment fee depends on the transaction amount, recalculate it when the price changes. Also enter any discount before calculating realized revenue; a displayed shelf price is not automatically the amount collected.

For a separate scenario, return to the $8.00 price and increase packaging by $0.25 per bottle. Variable cost becomes $4.55, contribution becomes $3.45, and the period remainder becomes $195 at 100 sold. Whole-unit break-even becomes 44 bottles, subject to the same scaling assumptions.

Keep these scenarios in separate copies. Changing price, packaging and volume simultaneously makes it harder to explain which assumption caused the difference. None of these results forecasts sales. Before treating a new container or sales channel as an improvement, replace the assumptions with its complete costs and write down how many bottles you expect to sell.

Build your worksheet from actual inputs

Use the linked batch cost calculator for initial recipe and packaging estimates. It accepts ingredient prices for jalapenos, celery, onion, garlic, coriander and salt, plus label and shrink-band costs. Bottle pricing comes from fixed catalog tiers; those values are neither editable quotes nor a way to enter our combined hypothetical packaging allowance.

The calculator excludes production labor, selling labor, payment fees and overhead. Its yield control is an adjustable modeling assumption, not a verified typical result for every recipe. Replace it with your own usable yield when available. Move the relevant totals into a separate worksheet and add the missing categories there. Avoid counting bottles or labels again if they are already included in a carried-over subtotal.

Use the bottles and caps guide to check exactly which components a supplier includes. Record actual purchase quantities and costs alongside that configuration. Recipe scaling helps plan quantities; it does not establish a complete profit figure.

After the next batch, compare planned and recorded usable yield, bottles sold, realized prices, packaging consumed, production hours and selling hours. Keep the original estimates visible. Replace them with recorded values where you have evidence, and leave the remaining uncertainties labeled.