This workbook gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in PF1.




Access the workbook

The workbook to be used is BW_WBK_CO_0021 - BW - IMEP - PF1 Manuf. Local database (Core Workbook) 

=> Go to Analysis for Office in excel 

=> Click "Open Data Source"


image2021-2-26_19-41-29.png



Go to the tab "Role" and open the folder IMEP - Integrated Manufacturing & Energy Performance => Manufacturing 

Double-click on the workbook BW_WBK_CO_0021 - BW - IMEP - PF1 Manuf. Local database (Core Workbook) to open it



Open the workbook

It is mandatory to enter the period (1) : MMM.YYYY

It is also recommended to enter at least a GBU (5), a company code (6) or a plant code (11)

It is also possible to enter:

  • a target currency (2) to have all values converted with the same currency
  • a Unit of Measure for the quantity conversion (ex: TO for Tons) (3)
  • a Unit of Measure for Active ingredients (4)
  • a Cost center (7)
  • a Cost object (8)
  • an Index 1 (9) 
  • a material code (10)

Click "OK" 



Set-up a basic report

When you start working with iMEP, you can simplify the lay-out that is proposed by default.

  1. Click the button "display" to show the "Design Panel"
  2. Remove "CE Grp XCS-ALL Lev2", Cost Element, Origin from the report. (drag this values from the box "Rows")
  3. You can also hide the value "Source Syst." & "CO Area" (Click the dimension and select "no display")


There are 6 columns in the report: 

  1. The plant code
  2. The code of the material produced and its description
  3. The Index 1
  4. The actual quantity 
  5. The actual costs

How to understand the report

In this example the material 157142 SD CS1250 4SMVSH was produced during the period in plant TOSA:

  1. 49 210 Tons were produced and the total production costs is 5 091 065,04 EUR
  2. 26 710 M3 of co-products were also produced and the total production costs is 7 919,39 EUR
  3. The production of the finished product & the co-product was done with 49 210 Tons of Raw materials. And the total cost of these raw materials was 4 696 549,05 EUR
  4. Activities (Labour, energy, fixed costs) were also allocated to the production costs of these products with a total costs of 443 377,61 EUR (Standard costs) - 40 942,28 EUR (Variances) = 402 435,33 EUR
  5. Detailed of costs posted on cost centers = 402 435,33 EUR. It provides the detail of the activities costs and the total amount is the same as (4).
  6. The total should be zero as the total production costs corresponds to the cost of raw material & activities. However in this example the cost of activities is double-counted (4) & (5). It is recommended to exclude the Index 1 = 9 of your reports except if you have a specific need. 



When you exclude the Index 1 = 9 of your report then the total Mat. Ledger Costs by material code is close to zero. 

=> You can use the workbook IMEP - PF1 Check of data consistency to validate that it is true for all the materials of a plant, company or GBU. 


Set-up a detailed report

when you have a good understanding of the report, you can add additional information in the report. You can refer to the list IMEP - Characteristics to have a definition of each dimension available in iMEP reports. 

For instance you can add:

  1. the field "Origin" to have additional details by raw material & activities
  2. the measures "ML VC", "ML FX" & "ML DP" to have the split of costs by variables costs, fixed costs and depreciation

=> You can also add the QUR, QUS, CUR, CUS (actual and standard unit quantity & cost)