Joint Cost & By-Product Allocation Calculator
Allocates a shared joint production cost across three products using all three standard methods — Physical Units, Relative Sales Value at Split-Off, and Net Realizable Value — side by side, and automatically flags which product's allocated cost swings the most depending on which method you choose. Built for cost accountants and manufacturing finance teams at companies that produce multiple products from one shared process — sawmills, oil refineries, dairies, food processors, mining operations, and any operation where one raw input splits into several distinct outputs.
Download This Calculator
Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.
All Three Methods, Side by Side
See Physical Units, Relative Sales Value at Split-Off, and Net Realizable Value allocations calculated simultaneously for the same joint cost — not just one method in isolation.
Automatic Sensitivity Flag
Automatically identifies which product's allocated cost swings the most depending on which method you choose, so you can judge whether a profitability conclusion is real or just an artifact of the method.
Ties Out Exactly
Every method's allocations sum precisely to your total joint cost, no matter which approach you use to split it between products.
Frequently Asked Questions
What is joint cost allocation, and why does the method you choose matter so much?
Joint costs are the shared costs incurred to produce two or more products from a single process before they become separately identifiable — the "split-off point." Because these costs can't be traced directly to any one product, they have to be allocated using some reasonable method, and different methods can produce meaningfully different results for the exact same total cost.
Using the calculator's defaults: a $1,000,000 joint cost split across three lumber products — high-volume Studs, low-volume Decorative Pieces, and mid-volume Posts — gets divided very differently depending on the method. Studs, which make up 75% of physical output but a much smaller share of total value, get allocated $750,000 under the Physical Units method but only about $436,000-$462,000 under the two value-based methods. That's a $313,636 difference in a single product's cost, purely from choosing a different (and equally defensible) allocation method.
How does the Physical Units method work, and what's its main weakness?
The Physical Units method allocates joint cost in proportion to each product's share of total physical output — weight, volume, or unit count. It's the simplest method to calculate and explain, but it has one significant blind spot: it completely ignores each product's actual value, which can badly distort the apparent cost (and therefore apparent profitability) of high-volume, low-value products.
Using the calculator's defaults, Studs represent 75,000 of 100,000 total units (75%) but sell for just $8/unit versus $60/unit for Decorative Pieces. Under Physical Units, Studs absorb 75% of the joint cost ($750,000) despite generating a much smaller share of total revenue — making Studs look artificially unprofitable and Decorative Pieces look artificially cheap to produce, neither of which reflects the products' actual economics.
How do the Relative Sales Value and Net Realizable Value methods differ from each other?
Both allocate joint cost based on each product's value rather than its physical quantity, which is why they tend to agree more closely with each other than either does with the Physical Units method — but they use different value measures. Relative Sales Value uses each product's price at the split-off point, before any further processing. Net Realizable Value uses each product's final sales price after further processing, minus whatever that further processing cost.
Using the calculator's defaults, Decorative Pieces get further processed (finished/upgraded) at a cost of $50,000, raising their sales price from $60 to $75 per unit. Relative Sales Value allocates based on the $60 split-off price ($230,769 allocated), while Net Realizable Value nets out the $50,000 processing cost against the higher $75 final price ($236,364 allocated) — a smaller difference between these two methods than either shows versus Physical Units, but still a real one. NRV is generally considered the more accurate method when products require different amounts of further processing, since it accounts for that cost directly rather than ignoring it.
Which joint cost allocation method should I actually use?
Net Realizable Value is generally preferred when your joint products require meaningfully different further processing before final sale, since it's the only method of the three that accounts for those different processing costs directly. Relative Sales Value works well when products can all be sold immediately at split-off with no further processing needed, since split-off price and NRV converge to the same thing in that case. Physical Units is the simplest but is best reserved for situations where your joint products have genuinely similar values per unit — otherwise it risks the kind of distortion shown in the calculator's own example.
That said, all three methods are individually defensible under GAAP, and total costs will always tie out to the same aggregate number regardless of which you choose — what changes is how that total gets divided between products, which matters enormously for per-product profitability analysis, pricing decisions, and inventory valuation, even though it changes nothing about the company's overall bottom line.
Does the allocation method I choose affect my company's total profit?
No — total profit across all products combined is identical regardless of which allocation method you use, since every method distributes the exact same total joint cost; only the split between individual products changes. This is worth understanding clearly, because it means the "right" choice isn't about finding a method that produces better numbers overall — there isn't one.
What the method choice does affect is which individual products look more or less profitable, which has real downstream consequences: pricing decisions, decisions about whether to discontinue a product line, sales team incentives tied to product-level margins, and inventory valuation on the balance sheet can all shift meaningfully based on a choice that has zero effect on the company's actual aggregate profitability. That's exactly why this calculator shows all three methods together rather than just one — seeing the spread helps you judge whether a product-level profitability conclusion is a real signal or an artifact of the allocation method chosen.
Transform Your Excel Models into Web Tools
Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.
Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.