The aim of this workbook is to validate the quality of the data reported in imep for the sites in PF1.
It can be used when you start working with iMEP queries and confirm that there is no specificity in your production site / GBU that is not taken into account in the imep program.
Access the workbook
The workbook to be used is BW_WBK_CO_0024 - BW - IMEP - PF1 Check of data consistency (Core Workbook)
=> Go to Analysis for Office in excel
=> Click "Open Data Source"
Go to the tab "Role" and open the folder IMEP - Integrated Manufacturing & Energy Performance => Manufacturing
Double-click on the workbook BW_WBK_CO_0024 - BW - IMEP - PF1 Check of data consistency (Core Workbook) to open it
Open the workbook
It is mandatory to enter the period (2) : MMM.YYYY
It is also recommended to enter at least a company code (6) or a plant code (11)
It is also possible to enter:
- a target currency (3) however it is recommended to perform the test with the local currency
- a Unit of Measure for the quantity conversion (ex: TO for Tons) (4)
- a GBU (5)
- a Cost object (8)
- an Index 1 (9)
- a material code (10)
Click "OK"
The workbook in detail
There are 7 sheets in the workbook:
1. DS_6
The aim of the report iMEP is to provide a detail of actual production costs by material/plant. In PF1, the actual production costs by material is calculated with Material Ledger and the total by material/plant can be displayed with the transaction CKM3 - Material Price Analysis.
The purpose of the control (DS_6) is to compare the calculation done by Material Ledger (3) and the one done in iMEP (2) material code by material code (1)
Ex: The actual production costs calculated with Material Ledger (3) gives the same result as iMEP (2). It confirms that the report iMEP is accurate.
(2) = (3)
=> In case of discrepancies, a ticket should be created to get the support of the IS team
2. DS_2
Produced quantity (2) should be equal to Actual quantity (3)
(1) = (2) - (3)
=> In case of discrepancies, a ticket should be created to get the support of the IS team
3. DS_1
The aim of this control is to ensure that the total productions costs (2) calculated by iMEP is equal to variable costs (3) + fixed costs (4) + depreciation (5).
(1) = (2) - ((3) + (4) + (5))
=> In case of discrepancies, a ticket should be created to get the support of the IS team
4. DS_3
The aim of this control is to ensure that the total productions costs (Index 1 = 1 & 2) (2)(3) calculated by iMEP is equal to the sum of Raw materials (Index 1 = 3) (4) and activities (Index 1 = 5 & 7) (5)(6) costs.
(1) = (2) - ((3) + (4) + (5) + (6))
=> In case of discrepancies, a ticket should be created to get the support of the IS team
5. DS_4
The aim of this control is to ensure that the total activities costs (Index 1 = 5 & 7) (1)(2) calculated by iMEP is equal to the production costs recorded in a cost center (Index 1 = 9) (4)
(3) = ((1) + (2)) - (4)
=> The control is only true when a production cost center is dedicated to the production of a single material.
In the case of multi-materials cost centers, it is not possible to report the index 1 = 9 per material and therefore the control does not work.
6. DS_5
TO BE COMPLETED
7. Data loading
In this sheet you can find some information regarding the loading of data in 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.
The best way to get IT support is to use the new
Service One Platform.