Inputs
Example data table
Use the “Load example” button to copy these figures into the form.
| Product | Units | Sales @ split-off | Further cost | Final sales |
|---|---|---|---|---|
| A | 1,000 | 32,000 | 5,000 | 42,000 |
| B | 800 | 24,000 | 4,500 | 33,000 |
| C | 600 | 18,000 | 3,000 | 25,500 |
Formula used
- Allocation share = Allocation base for product ÷ Total allocation base.
- Allocated joint cost = Allocation share × Total joint cost.
- NRV base = Final sales value − Further processing cost.
- Joint cost per unit = Allocated joint cost ÷ Units (if units > 0).
- Profit (final) = Final sales − (Allocated joint cost + Further cost).
How to use this calculator
- Enter the total joint cost incurred before the split-off point.
- Add each joint product with units and values you know.
- Select an allocation method: physical units, sales at split-off, or NRV.
- If you choose NRV, provide final sales and further costs for all products.
- Press Submit to see allocated costs above the form.
- Download results as CSV or PDF for reporting and review.
Joint cost drivers and split-off visibility
Joint process costing starts with a shared cost pool up to the split-off point. In many plants, 70–95% of conversion effort occurs before products become separately identifiable. Typical joint costs include raw materials, energy, labor, and overhead for common processing. This tool captures that pool as total joint cost and allocates it across outputs, keeping split-off assumptions visible for review and audit consistently.
Choosing an allocation base
Physical units work best when outputs are comparable, such as liters, kilograms, or standard packages. Sales value at split-off is preferred when reliable split-off prices exist, because it links cost to earning potential. If A represents 40% of total split-off value, it receives about 40% of the joint cost.
NRV insights for further processing
When products require extra work after split-off, net realizable value (NRV) avoids loading joint cost onto items with heavy downstream spending. NRV equals final sales minus further processing cost. Example: final sales 42,000 less further cost 5,000 gives an NRV base of 37,000 for allocation. If NRV becomes negative, treat the base as zero and investigate pricing or processing losses.
Unit cost and inventory valuation impact
Allocated joint cost per unit supports inventory measurement and pricing analysis. If 20,000 of joint cost is assigned to 1,000 units, joint cost per unit is 20.00. Adding further processing cost gives a cost-to-sell view, while profit and margin columns show how allocation changes product-level performance.
Sensitivity checks and audit trail
Professional costing relies on repeatable assumptions. Compare methods side by side: physical units emphasizes volume, sales value emphasizes market strength, and NRV emphasizes post split-off economics. Small rounding drift is corrected so the total allocated equals the joint cost, improving reconciliation at month-end. Save the exported table with the period, cost pool source, and split-off quantities to support future reviews.
Reporting and export-ready outputs
Results summarize totals, show product allocations, and chart both allocated joint cost and joint cost per unit. CSV exports support spreadsheet tie-outs, while PDF exports provide a clean attachment for reporting packs. Use the example dataset to validate workflow, then replace figures with actual quantities and values. Re-run allocations when sales prices change materially so product profitability dashboards stay comparable across periods.
FAQs
1) Which allocation method is most common?
Sales value at split-off is widely used when reliable split-off prices exist. Physical units suit comparable outputs. NRV is useful when significant further processing happens after split-off.
2) What is NRV in this calculator?
NRV is final sales value minus further processing cost for each product. The calculator uses NRV as the allocation base to distribute the joint cost pool proportionally.
3) Can I allocate joint cost using units only?
Yes. Select the Physical units method and enter units for each joint product. The tool will allocate joint cost based on each product’s share of total units.
4) Why does product profit change across methods?
Allocation changes how the joint cost pool is split between products, shifting product-level profit and margin. Total profit across all products remains driven by total sales and total costs.
5) How do exports work?
After you submit, use Download CSV for spreadsheet analysis and Download PDF for a shareable report. Exports are generated from the on-page results table.
6) What inputs matter most for accuracy?
Verify the total joint cost includes only pre split-off costs, units are consistent, and values match the selected method. For NRV, confirm further processing costs and final sales.