In the application iMEP, the caracteristic Index 1 is a key element to understand to set-up an accurate report to follow production quantities and costs.

Definition

For historical reasons, the data structure is not the same in our two source systems (WP1 & PF1). It explains why some indexes only exist in one of the two ERPs.

Code	Description	Definition
1	Produced material	Costs and quantities at finished product level
2	Co-product	Co-product
3	BOM conponent	Costs and quantities issued from component consumption
4	Subcontracting	Subcontracting costs
5	Activity type	Costs and quantities issued from activity consumption at standard costs
6	Settlement	Process Orders variances
7	Cost Collector Varia	Allocation of activity variances done by Material Ledger
9	SKF/direct Posting	Detailed origin of costs consumed on production cost centers by Activities

Example PF1

The aim is to have the detailed quantities and costs of production of the material 157142 in iMEP

There are 4 columns in the report:

Finished product code:
Index 1
Actual quantities
Mat. Ledger Costs = Actual costs

The detail of costs & quantities is:

	Index 1
a	1 - Produced material	70 000 KG of the finished product 157142 SD are produced and the total production cost is 6 840 €
b	3 - BOM conponent	206 000 KG of Raw Materials are used for the production of the finished product with a total cost of 2 650 €
c	5 - Activity type	The cost of activities used for the production is 4 440 €. It is based on the estimated costs of activities
d	7 - Cost Collector Varia	It is the difference between the standard cost of activities and actual costs (=4 190 € - 4 440 €)
e	9 - SKF/direct Posting	It is the detail of activity costs

The cost of production (a) = cost of raw materials (b) + cost of activities (standard (c) & variance(d)) = 6 840 € = 2 650 € + 4 440 € - 250 €
Index 1 = 9 (e) is the detail of activity costs. It is equal to Index 1 = 5 (c) and Index 1 = 7 (d) => 4 440 € - 250 € = 4 190 €

Control data accuracy

The workbook BW_WBK_CO_0024 is used to perform some consistency checks.

Example WP1

The aim is to have the detailed quantities and costs of production of the material 157142 in iMEP

There are 4 columns in the report:

Finished product code:
Index 1
Actual quantities
Actual Costs

The detail of costs & quantities is:

	Index 1
a	1 - Produced material	35 000 TO of the finished product 81016 SOD are produced and the total production cost is 2 700 k€
b	3 - BOM conponent	10 500 TO of Raw Materials are used for the production of the finished product with a total cost of 2 300 k€
c	5 - Activity type	The cost of activities used for the production is 350 k€.
d	6 - Settlement	It is the production variance. The amount is settled to the P&L to the value field D05/E05/F05

The cost of production (a) = cost of raw materials (b) + cost of activities (c) + variance (d) = 2 700 k€ = 2 300 k€ + 350 € + 50 k€

Going further with iMEP

IMEP - Characteristics — List of Characteristics & Measures available in the BW application iMEP with the link to more detailed documentation when it exists.
IMEP - Index 1 — In the application iMEP, the caracteristic Index 1 is a key element to understand to set-up an accurate report to follow production quantities and costs.
IMEP - PF1 Manuf. Local database — This workbook gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in PF1.
IMEP - WP1 Manuf. Local database — This workbook gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in WP1.
IMEP - PF1 Check of data consistency — The aim of this workbook is to validate the quality of the data reported in imep for the sites in PF1.
IMEP - PF1 ML synthesis — This report answers a specific need of GBUs operating in PF1 who wants to better understand the impact of the stock effects in their P&L. It can be used as the report Z1K_CONS_ESTO in PF1 but for a wider scope.

Page tree

IMEP - Index 1

Definition

Example PF1

Example WP1