
Calculation of the Interunit Profit/Loss for Elimination
Use
This function automatically determines the amount of profit/loss that results from the transfer of inventory between group subsidiaries and that must be eliminated. The
calculation of the group cost of goods manufactured forms the basis for the calculation of the interunit (IU) profit/loss requiring elimination.Prerequisites
IU profit/loss has resulted from the sale of inventory between individual enterprises in the corporate group. From the point of view of the group as a single entity, no such profit/loss may occur. The amount of IU profit/loss calculated depends on the volume of inventory transferred and the profit percentages fixed within your group. Another factor influencing the profit/loss are the distribution costs and other incidental acquisition costs that arise at different stages in the supply chain. From the group’s point of view, these costs are considered part of the cost of goods manufactured as long as the goods for which they are incurred are not sold externally.
Features
The system calculates the IU profit/loss requiring elimination as follows:
Schema for the Calculation of IU Profit/Loss
Variable |
Formula |
Represents |
A |
(Net) book value in reporting period | |
B |
Valuation allowance (loss allowed) | |
C |
Valuation allowance (no loss allowed), in other words, a valuation allowance that must not change an interunit profit into a loss. | |
D |
A + B + C |
Value of goods supplied / inventory value from the goods transaction |
E |
Incidental acquisition costs (absolute or as a percentage); need to be capitalized from the point of view of the group | |
F |
D - E |
Sales revenue |
G |
Profit percentage; either a markup or a gross margin | |
H |
100 - G |
Cost of goods manufactured (%) |
I |
(F * H) + E
Or: F * (H + E) |
Group cost of goods manufactured
...if incidental acquisition costs are entered as a percentage |
J |
A - I |
Interunit profit/loss for elimination |
Note that incidental acquisition costs are considered to be part of the COGM for the purposes of calculation. This is because, from the group’s point of view, no incidental acquisition costs can be incurred for a good that was manufactured within the group and sold to a group subsidiary.
You have two options for calculating IU profit/loss:
Procedure 1
IU profit/loss is calculated using a profit percentage that you enter as part of the supplier data. The profit percentage can be interpreted in the following different ways:
Example
Profit percentage: 20 %
Invoiced amount: 2500
If the profit percentage is a markup, the following IU profit is calculated:
2500 * 20 / 120 = 417
If the profit percentage is a gross margin, the following IU profit is calculated:
2500 * 20 / 100 = 500
Procedure 2
The COGM for the supplier is calculated by multiplying the inventory quantity by the COGM that you enter per unit. With this procedure, variant J in the above schema is calculated differently, a follows:
Schema for the Calculation of the Group Cost of Goods Manufactured
Variable |
Formula |
Represents |
A |
Quantity | |
B |
Cost of goods manufactured per unit of measure | |
C |
Incidental acquisition costs | |
D |
A * B + C |
Group cost of goods manufactured |
Valuation Allowance (with no Loss Allowed)
The following situations can occur during the calculation of IU profit/loss:
inventory book value - group COGM
IU profit/loss = 0
This situation occurs if an IU loss is calculated and you have recorded a valuation allowance with no loss allowed.
A valuation allowance with no loss allowed must not change an IU profit into a loss. No loss can be posted in this case in order to respect the principles of prudence and minimum values.
The book value resulting in this case is the maximum value permitted from group’s the point of view.
Elimination of IU Profit/Loss
The system eliminates IU profit/loss for pairs of consolidation units, and lists the postings made in an audit trail. The sum of the group COGM and the IU profit/loss is the inventory book value.
Deferred income taxes are normally posted during the elimination because the IU profit/loss calculated must be allocated to the period in question. The profit/loss that is eliminated is realized in a later period on sale of the inventory to an external enterprise. Income taxes therefore become due at a later date (additional payments or refunds). Distribution costs are reclassified to COGM (if specified). Translation differences are posted separately if the exchange rate indicator used for translating the balance sheet differs from that used for the income statement and you specified a comparative exchange rate indicator in the elimination task.
If you do not want deferred income taxes to be posted, you need to specify this in the document type that you use for the elimination.
Example
Unit A |
Sale of goods to unit B |
Sales: USD 1,200 |
COGM: USD 1,000 |
Unit B |
Sale of 80% of the goods from A to an external company |
Sales: USD 1,300 |
COGM: USD 960 |
Unit B |
Inventory supplied by unit A |
USD 240 |
|
Currency translation |
Balance sheet and annual net income at current rate of 2.00 DEM/USD |
Income statement at average rate of 1.50 DEM/USD |
|
Unit A |
Unit B |
Elimination of sales revenue |
IPI |
Consolidated data | |
|
Reported data |
Reported data |
Total | |||
Inventory |
0 |
480 |
- 80 |
400 | |
Cash |
2400 |
200 |
2600 | ||
Annual net income |
-400 |
- 680 |
80 |
-1000 | |
Stockholders’ equity |
- 2000 |
- 2000 | |||
Sales revenue |
- 1800 |
- 1950 |
1800 |
- 1950 | |
Cost of goods manufactured |
1500 |
1440 |
- 1800 |
60 |
1200 |
Translation differences |
- 100 |
- 170 |
20 |
- 250 | |
Transfer to annual net income |
400 |
680 |
- 80 |
1000 |