Skip to content

Inventory

Inventory margins: know what you make on every product

InventoryBy 4 min read
Published Updated
Coffee bags, beans, a shipping carton and a worksheet illustrating the costs behind a product.
Review materials, packaging and other production costs before comparing product margins. Conceptual illustration.

Ask a business owner their overall margin and most can answer. Ask what they make on one specific product and the room goes quiet. That silence is expensive: a blended margin is an average, and averages hide exactly the thing you need to see — which products carry the business and which ones quietly ride along for free.

COGS in one sentence

Under an inventory-based accrual approach, inventory costs are generally recognized in cost of goods sold as the related items are sold. Buying stock can reduce cash before it reduces profit. The federal tax treatment can differ, including exceptions for eligible small businesses; use the accounting method and cost-allocation rules that apply to your business.

The roaster: what a $16 bag actually costs

Consider a fictional coffee roaster selling a 12 oz retail bag and a 5 lb wholesale bag. For this simplified example, assume green beans cost $4.20 a pound and roasting loses 15% of their weight. The figures below cover materials, packaging, and inbound freight only; production labor and overhead still need to be considered.

  • Roast loss. Roasting drives off moisture — about 15% of the weight. A pound of roasted coffee therefore costs $4.20 ÷ 0.85 = $4.94, before anything else happens to it.
  • The coffee in the bag. A 12 oz bag holds 0.75 lb of roasted coffee: $4.94 × 0.75 = $3.71.
  • Packaging. Bag, label, and one-way valve: $0.62.
  • Freight in. The shipping you paid to get green beans to the roastery is part of the cost of the beans. Spread across the order it adds $0.17 a bag.

The included costs total about $4.50 per retail bag. At a $16 selling price, that leaves about $11.50 before production labor and overhead, or roughly 72% of sales. For the wholesale bag, $24.71 of coffee plus $1.10 of packaging and $0.55 of freight totals $26.36. At $52, about $25.64 remains before those additional costs, or roughly 49%. These are illustrative partial-cost margins, not final accounting gross margins.

Production labor and allocable overhead are not simply optional categories. IRS Publication 334 explains that manufacturing cost of goods sold can include direct and indirect labor and other production costs. Determine the treatment required by your reporting and tax methods with your accountant, and apply it consistently. A management estimate that omits those costs should be labeled accordingly.

The example shows why the sales mix matters, but the decision needs the remaining production and selling costs too. Wholesale may bring steadier orders and lower selling costs per bag; it may also need more working capital. Compare consistently calculated product margins before choosing where to grow.

When costs move: the average does the remembering

For an inventory item configured to use moving weighted average, a posted purchase changes its average cost by combining the remaining stock value with the new purchase cost. Posted sales then use the applicable calculated cost. This works at the tracked-item level: buying more expensive green beans does not automatically update the cost of a different finished-bag item. A roaster still needs a separate production-cost calculation and appropriate accounting entries for the finished goods.

What to do with per-product margins

  • Reprice the outliers. A product 20 points below its siblings either earns a higher price, a cheaper input, or a reason — strategic loss-leaders are fine, accidental ones aren’t.
  • Chase freight, not just unit price. Freight-in is part of COGS and it’s invisible until you allocate it. Consolidating two shipments into one is a margin improvement no customer ever notices.
  • Watch the drift, not just the level. A margin sliding from 72% to 66% over three months is a supplier increase or a discounting habit — and it’s the earliest warning you’ll get.
  • Kill or bundle the losers. A product that can’t earn its margin after repricing can still earn its keep in a bundle — or it can stop consuming shelf space and attention.

For tracked inventory, posted item sales use the configured FIFO or moving weighted average cost. That does not automatically allocate a roaster’s ingredients, production labor or overhead to finished bags: Bokeping has no recipe or production-costing engine. The illustrative $11.50 above is what remains before those additional production costs, not the bag’s final gross profit. Review the complete cost with your accountant before using it to set prices.

Sources & further reading

Sources checked

These references explain the concepts above. Tax guidance and financial reporting standards serve different purposes; each source’s scope is shown below.

General guidance, not accounting or tax advice. Rules differ by state and by business, and they change — check your own state’s published rules, and talk to your accountant about your situation before you act on anything here.

Keep reading

More from the blog

Ready to know your money?

Free plan, no card needed. Bring your QuickBooks or spreadsheet history, invite your accountant, and start reading your own books today.