Reconcile the physical outputs before applying values
Record actual quantities in consistent, meaningful units and identify their condition at the separation point. Distinguish accepted output, material awaiting testing, waste, and material returned to an earlier process. If one product is measured by volume and another by weight, a physical-quantity allocation needs a supported conversion or a different basis. Adding unlike units simply because the spreadsheet accepts them creates a meaningless denominator.
Investigate differences between planned and actual yield before treating them as a change in commercial value. A run that produces less of a high-value product and more of a lower-value product can change the allocation and total economics simultaneously. Preserve the planned and actual output records so a later reviewer can distinguish a process change from an update to selling assumptions.
Make sure every output is represented once. A secondary material might first appear in a production report and later in a separate receiving document. Those can describe the same quantity. Link the records rather than adding them. Similarly, an output transferred for further processing is not a second product merely because it receives another internal order number.
Keep system settings and analytical assumptions aligned
Microsoft documents a total cost allocation method for formula items and co-products that uses reported output quantities and cost information. This illustrates why an allocation can change when the actual outputs differ from the plan. If your application performs the calculation automatically, preserve the relevant formula version, cost inputs, output transactions, and resulting percentages. A final percentage without its inputs is difficult to review.
Distinguish a planned allocation used for quoting from the allocation used for a completed run. Planning may assume normal yields and expected prices; actual production may produce another mix. Show the bridge between the two before attributing a margin change to purchasing or factory efficiency. A change in allocation can move cost between products even when the total shared cost has not changed.
Handle incidental outputs under the approved policy rather than giving every residual material equal status. The classification and measurement of a by-product can differ from that of a significant joint product. Provide the reviewer with its economic significance, quantity, expected recovery, and further costs. Renaming an output in the system should not be used to achieve a preferred margin result.
References: Microsoft Learn: Cost allocation for co-products; External Reporting Board: NZ IAS 2 inventory requirements
Use allocated margins for the decisions they can support
Allocated product margins help explain reported costs, but they do not by themselves answer whether a product should receive more processing. For that decision, compare the additional revenue available after separation with the additional costs needed to earn it, alongside capacity and commercial constraints. Shared costs already incurred remain relevant to the whole process, even when they do not change with that incremental choice.
For example, if further processing would add $15,000 of revenue and require $11,000 of additional cash operating cost, the simple incremental contribution is $4,000 before other relevant constraints or costs. A large allocated joint cost does not change that subtraction. Keep the decision analysis separate from the inventory costing worksheet so neither is mistaken for the other.
Close the review with a reconciled shared pool, complete output quantities, a documented allocation basis, direct post-separation costs, and approval of material assumptions. When the next run changes, those records let finance explain whether the cause was cost, yield, market value, or methodology. That explanation is more useful than a product margin that moves without a visible reason.
References: Microsoft Learn: Cost allocation for co-products; External Reporting Board: NZ IAS 2 inventory requirements
Sources
Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.
Related reading
Need help with this work?
General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.