The workbook is used to validate the quality of the data reported in imep for the sites in PF1. |
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 (2) and the one done in iMEP (3) material code by material code (1)
Ex: The actual production costs calculated with Material Ledger (2) gives the same result as iMEP (3). 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
7. Data loading
In this sheet you can find some information regarding the loading of data in iMEP
