Access the workbook

The workbook to be used is BW_WBK_CO_0019 - BW - IMEP - WP1 Manuf. Local database (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_0019 - BW - IMEP - WP1 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 (6), a company code (7) or a plant code (11)

It is also possible to enter:

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

Click "OK" 

How to understand the report

By default there are 11 columns in the report: 

1. The source system = WP1_400 
2. The Controlling Area 
3. The production plant
4. The material = The finished product
5. The Index 1
6. The Origin 
7. The Actual quantity produced
8. The Actual costs of production splited by 
   • Actual Variable costs (9)
   • Actual Fixed costs (10)
   • Actual Depreciation (11)

 It is recommended to keep these columns in your report to avoid that all master data start with "WP1_400/" or "Z006/" but you can hide them in the design panel. Click on the dimension you want to hide and select "No display"

In this example the material 11830 ZEOSIL 1165MP BULK was produced during the period in plant 0087:

1. 2 763 Tons were produced and the total production costs is 1 513 312,29 EUR
2. 49 Tons of co-products were also produced and the total production costs is 492,40 EUR
3. The production of the finished product & the co-product was done with 11 533 Tons of Raw materials. And the total cost of these raw materials was 824 265,21 EUR
4. Activities (Labour, energy, fixed costs) were also allocated to the production costs of these products with a total costs of 688 054,53 EUR
5. The variance between actual production costs & standard costs (=process order variance) is 1 484,95 EUR
6. The total should be zero as the total production costs (Index 1 = 1 & 2) corresponds to the cost of raw material & activities  + variances (Index 1 = 3, 5 & 6)

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 add:

1. the field "Origin" to have additional details by raw material & activity
2. the measures "Actual Costs VC", "Actual Costs FX" & "Actual Costs DP" (c) 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)