Entering content frameFunction documentation Calculation of the Interunit Profit/Loss for Elimination Locate the document in its SAP Library structure

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:

This graphic is explained in the accompanying text 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:

  1. Typically, IU profit/loss is calculated as follows:
  2. inventory book value - group COGM

  3. In exceptional cases:

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.

This graphic is explained in the accompanying text 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

 

 

 

 

Leaving content frame