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 | WP1 | PF1 |
|---|---|---|---|---|
| 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€
The best way to get IT support is to use the new
Service One Platform.