General presentation

Objective of the application

Manufacturing VC query (QV_BW_QRY_CPCOPC04_0001) is one of the components to calculate the FL-ICM (Forward-Looking Integrated Contribution Margin).

The Variable Cost (VC) of a product is the sum of Raw Materials + Packaging + Tolling + Utilities costs.

We bring the detailed costs from SAP from the BOM (Bill of Material).

The BOM brings, for a given Finished Product/Plant/Month, the detailed list of components (raw material/activity type) with the corresponding quantities and costs.

In the query, we calculate the FL Variable Cost for projected months, using the forecasted prices for Raw Material and Energy (input by the users in IP workbooks) and multiply them by the quantities from the BOM. If no forecast is found, then we extrapolate last Actual price to the future months.

Tool Leader + IT leader of the application: 

Usage information

History

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Authorization variables

List of authorization variables mandatory for the application.

Dataflow overview

Manufacturing Cost is available in Composite Provider CPCOPC04

ADSOs ABCOPC06 (WP1) and ABCOP06B (PF1) stage the data, which combines BOM (Actuals) + Forecast data.

BOM data flow

First step to calculate Manufacturing Cost is to load the BOM.

It is loaded from WP1 and PF1 in different data flows.

Then BOM data from both ERPs is harmonized in CV_FMCO_BOM 

There are 2 different BOM queries (not used directly in Pricing dashboard, but can be used to check the BOM data with all the available granularity)

• QV_BW_QRY_CPCOBOM1_0001 - for WP1  
• QV_BW_QRY_CPCOBOM2_0001 - for PF1 

You can find the dimensions of each query here:

Buy & Sell products

These are products that the GBU buy and re-sell, and they have no BOM in SAP.

They are identified via Critical Raw Material Master Data C_FLRMAT, where “Critical flag” (C_FLRMATF) =  “B” (No BOM)

We create a "virtual" BOM in BW assigning the same material code as both Finished Product and Raw Material, and the quantity is 100% of the lot size (1000 KG).

The forecast price for these materials is collected in the workbook and saved in ABCOPC01 as the other critical raw materials.

The actual price in this case comes from P&L. query QVSBS_QRY_MVCOPA06_0001. (technically we take data directly from ODS_PCP9 field C_MVR_CP).

Forecast data

It comes from the following ADSOs:

• ABCOPC01 - FL - Raw Mat - Planification
• ABCOPC10 - FL - Energy - Planification

The prices are saved by the users in the corresponding BW-IP workbooks.

You can find FL-ICM overall architecture here:

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Novecare (in WP1) works with Standard Cost.

Beginning of month M, we have the cost for month M.

Specialty Polymers (in PF1) works with Actual Cost.

Beginning of month M, we have the cost for month M-1 (last closed month).

In order to have a common view, for a unique Running Period, this is the way we generate data in Manufacturing Cost query.

Note that for Novecare (WP1), there is a month lag in the Forecast price for the projected months (for example Forecast for April uses price from March).

In Manufacturing Cost calculation view, BOM (Actuals) is combined with Forecast data.

2 different calculation views were created as we can only filter a single period to read BOM data, so in each CV, Run Period is calculated differently:

CV_FMCO_MAN_COST_RCS (WP1)

RUNPER is equal to FISCPER from DTP (used to extract BOM)

CV_FMCO_MAN_COST (PF1)

RUNPER = FISCPER from DTP +1

For example: to generate RUNPER 03/2022

DTP from WP1 with  FISCPER = 03/2022 (to extract BOM data from 03/2022)

CV will generate RUNPER 03/2022.

DTP from PF1 with FISCPER = 02/2022 (to extract BOM data from 02/2022)

CV will generate RUNPER 03/2022.

Dependencies with other applications

Data loadings

Info providers and objects loaded

Process chain PC_COPC_10 scheduled monthly on CD7

Loading frequency

Monthly on Day + 7

Average performance

Record Keeping

Reporting

Main queries

Manufacturing Unit Cost query : QV_BW_QRY_CPCOPC04_0001

Main functionalities

It combines BOM (Bill of Material) data for Actuals + Raw Material Forecast.

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Characteristics

Broadcast