The concept of the order book business view with the contribution is to provide the contribution margin (integrated or standard) for the invoiced part, for the shipped not billed part and for the open order.
- For the invoiced part we used the realized contribution. This information is coming from P&L. The definition is done at material/customer level.
- For the shipped not billed and for the open order, an estimation of the contribution margin is calculated. The information to compute the estimation is coming from P&L and from the CCR. The definition is done at the same level than the order book.
In the report the contribution is displayed using the figures below:
- Total Invoiced ICM.
- Invoiced ICM.
- Invoiced unallocated ICM.
- Total Shipped not billed ICM.
- Shipped not billed ICM.
- Shipped not billed ICM (not integrated).
- Shipped not billed ICM (trading plant).
- Total Open order ICM.
- Open order ICM.
- Open order ICM (not integrated).
- Open order ICM (trading plant).
TOTAL ICM = Total invoiced ICM + Total Shipped not billed ICM + Total ICM Open order.
Important:
- For the contribution realized, the contribution can be allocated to a customer or unallocated. The contribution is not allocated when the customer is NOT complete (payer, sold-to, ship-to).
- The order book with contribution is only available for WP1’s data.
- The contribution coming from P&L is based on the posting date.
- The estimated contribution is just available from day 4.
- The contribution is only available for the order book to be invoiced.
Rules applied:
Contribution margin -invoiced part:
From P&L:
- Standard contribution: TOT- Contribution Margin Trade (RCS_CKF_MVCOPA01_0026).
- Integrated contribution: TOT- Contribution Margin Trade (IM) (RCS_CKF_MVCOPA01_0028).
Estimated contribution (standard) -Shipped not billed/Open order:
For the Estimated Contribution, we use the Turnover to Be Invoiced (-) Unit Costs * Quantity to Be Invoiced. |
- The Unit Costs are the sum of Proportional Unit Cost (Unit CP) + Unit VSE, and are defined:
|
- Proportional Unit Cost (CP): |
Regular Rule: |
Extraction from the CCR (VC) for the current month (material/plant) in the unit measure (extraction from BW). If not found, we look for the CCR (VC) of the previous month. |
Exception Rule: |
when the ship to the country is different from the plant country, the Unit VC will be derived from: |
- If there is already sales in the current month, the Unit VC will be the Actual VC Month M (material/plant) from P&L R15400 - Variable costs of sales
- If there is no sales in the current month, but sales in the previous month, so the Unit VC will be the Actual CP Month -1 (material/plant) from P&L R15400 - Variable costs of sales
- If there is no sales in the current or previous months, in this case, the unit VC will be the Unit VC coming from the CCR extraction of the current month. (material/plant)
|
In the report you can find the different VC's just in the Open Order detail: - Std VC Unit Current Month - Actual Unit CP for the current month
- Std VC Unit Previous Month - Actual Unit CP for the previous month
- Std VC Unit Estimated (CCR Month M) - Unit CP coming from the Current CCR (Month M)
- Std Reference VC Unit Estimated - The Unit CP, reference to have the Estimated Contribution (after applying the exception above).
|
- Variable Sales Expenses (VSE): |
Average of the Unit VSE in the current month/M-1/M-2, in the detail of material and ship to. If no value retrieved, the VSE will be = 0. (Extraction from P&L). Line STOT-R120 Variable selling expenses |
No exception for the VSE. THE RECORDS WITHOUT SOLD QTY MUST NOT BE CONSIDERED. |
Estimated contribution (integrated) -Shipped not billed/Open order:
We use the information from the CCR integrated, in order to have:
- Unit cost of Production.
- Unit cost of Duties.
- Unit cost of Transportation.
By default we use the CCR integrated of the current month. If it’s not available we used the CCR integrated of the current month - 1, if it’s not available we use the CCR integrated of the current month - 2.
Formulas:
Estimated integrated contribution (shipped not billed) =
turnover shipped not billed (-) ( (unit cost of production + unit cost of duties + unit cost of transport ) * Shipped not billed QTY ).
Estimated integrated contribution (open order) =
turnover open order (-) ( (unit cost of production + unit cost of duties + unit cost of transport ) * Open order QTY ).
A plant is a production plant if the search term 2 of the plant is “NDIR”.
THE RECORDS WITHOUT SOLD QTY MUST NOT BE CONSIDERED.