All Posts

Using a Cost Tracking Platform to Protect Your Margins

A product can sell well and still weaken the business. A supplier raises a price, batch yield slips, packaging gets heavier, or labor takes longer than expected. If the original cost remains unchanged in a pricing sheet, every sale appears healthier than it is.

Cost tracking is not only an accounting exercise at tax time. It helps a maker price products, compare channels, plan purchases, and decide which process problems deserve attention. The objective is a useful cost model and a routine that keeps it current.

Decide which cost question you are answering

Different decisions require different views.

Standard cost is the expected cost under defined assumptions. It supports pricing, planning, and variance checks. Actual cost reflects what a particular batch or period consumed. It reveals changes in supplier prices, usage, yield, and labor. Cost of goods sold is an accounting measure for the cost associated with goods sold during a period; inventory accounting and tax treatment should be reviewed with a qualified professional.

For an operational unit-cost model, start with:

Unit cost = direct materials + direct labor + production overhead per saleable unit

Then add channel-specific expenses when evaluating contribution: payment fees, marketplace commissions, pick-and-pack charges, shipping subsidies, discounts, returns, or wholesale commissions. Keeping production cost separate from selling costs makes it easier to see whether the product or the channel is causing pressure.

Build the cost from the work upward

Direct materials and packaging

List every ingredient, component, container, closure, label, insert, and shipping material consumed by the product. Use the purchase unit and production unit explicitly. If oil is bought by the gallon but used by the gram, document the conversion rather than typing a convenient decimal into a hidden cell.

Use landed cost where practical: purchase price plus incoming freight, duty, or other acquisition costs. A bottle advertised at $0.80 may cost $1.02 at the production bench after freight and breakage.

Record supplier, pack size, price, effective date, and expected waste.

Direct labor

Include the work required to create saleable units: setup, weighing, mixing, forming, curing or monitoring, filling, labeling, inspection, cleaning, and product-specific packing. Founder labor is not free. Even if the owner does not take an hourly wage today, the business must eventually pay someone or limit its output around that unpaid time.

Measure several normal runs rather than one unusually smooth batch. Separate hands-on work from unattended waiting so a four-hour cure does not automatically become four labor hours.

Production overhead

Rent, utilities, insurance, equipment depreciation, maintenance, sanitation supplies, software, and supervisory labor support production but may not attach neatly to one unit. Choose a consistent allocation driver such as direct labor hours, machine hours, batches, or normal production volume.

Document what is included and review the method when the production mix or capacity changes significantly.

Divide by saleable yield, not planned output

One of the fastest ways to understate unit cost is dividing batch inputs by the number of units you hoped to make.

Suppose a batch consumes $360 in materials, $150 in labor, and $90 in allocated overhead. Total batch cost is $600. The plan calls for 120 units, suggesting a $5 unit cost. If only 108 units pass inspection, actual cost per saleable unit is $5.56.

The missing units may represent spills, evaporation, trim, samples, breakage, underfills, or rejects. Track the reason separately. A realistic yield allowance belongs in the standard cost, but recurring avoidable loss should remain visible as a process problem.

For products that create useful by-products or require rework, define a consistent treatment with your accountant. Do not quietly assign every loss to “normal waste” simply to make the variance disappear.

Track price, usage, and yield variance separately

A total cost increase tells you that margin moved; a variance explains where to act.

Purchase price variance shows the effect of paying a different material price than expected. Usage variance shows whether the batch consumed more or less than the standard quantity. Yield variance shows whether acceptable output differed from plan. Labor variance can separate a changed hourly rate from additional production time.

Imagine fragrance cost rises $18 while a filling error creates $42 of scrap. Negotiating with the fragrance supplier cannot recover the larger operational loss. Separate signals lead to better priorities.

Review variances by dollars and percentage. Set thresholds that trigger review, then record the explanation and action rather than merely highlighting cells red.

Connect costs to margin and channel decisions

Gross margin is commonly calculated as:

Gross margin % = (net sales − cost of goods sold) ÷ net sales × 100

For product decisions, also calculate contribution after variable selling costs. A $32 direct-to-consumer sale with a $12 production cost may look strong, but payment fees, fulfillment, discounts, and shipping support can materially reduce what remains. A $16 wholesale price may produce less contribution per unit but lower customer acquisition and fulfillment work.

Create a channel view for each important SKU. Use net revenue after discounts and refunds, current production cost, and channel-specific variable expenses. This makes minimum order quantities, free-shipping thresholds, marketplace participation, and promotions easier to evaluate.

Margin percentage does not show cash timing. Pair it with inventory on hand, committed purchases, and expected collection dates.

Set triggers for cost updates

Waiting for an annual price review allows small changes to accumulate. Recalculate a product when:

  • a supplier changes price, pack size, freight, or minimum order;
  • a formula, component, package, or production method changes;
  • measured labor time or saleable yield moves beyond its threshold;
  • a new sales channel or fulfillment arrangement is introduced;
  • a major currency, duty, or energy cost changes;
  • actual margin differs materially from the plan.

Assign one owner, preserve effective dates, and retain prior cost versions.

Know when a platform is useful

A spreadsheet can be sufficient for a small catalog with stable inputs and one person maintaining it. It becomes fragile when the same material appears in many products, conversions are duplicated, supplier prices change often, or production results live elsewhere.

A product cost tracking platform should connect purchase units to usage units, roll current material costs into formulas, capture actual batch consumption and yield, preserve cost versions, and show why a cost changed.

Kerno can help makers link materials, formulas, production runs, and product costing so that changes are easier to trace. The tool should support judgment, not replace it: the team still decides labor policy, overhead method, acceptable variance, margin targets, and pricing position.

Test any system with one representative product and reconcile its result to purchase records and a completed production run.

Complete a one-product margin check

Choose a high-volume product and rebuild its cost using current invoices, measured labor, actual packaging, documented overhead, and average saleable yield from recent runs. Compare that result with the cost used in pricing.

Next, calculate contribution for each sales channel and identify the largest unfavorable variance. Set one action: update a purchase price, correct a conversion, improve a process step, adjust a channel rule, or review the selling price.

Repeat the check monthly for volatile products and quarterly for stable ones. Accurate product cost tracking will not remove every surprise, but it shortens the time between a change and a decision. That protects margin before a busy sales month turns into a cash problem.

Research sources

Your Story Starts Here

Ready to write your own Kerno story?

Join the launch list and be first to see how Kerno helps product creators manage inventory, production, costs, and quality with more clarity.

View Guided Demo

Continue Learning

Keep exploring how Kerno helps product creators move from formulas and inventory to completed, well-tracked batches.