Production Receipts by Resource ID

[former_member602633]

Hello All,

Is there a way to display Production Receipts by Resource ID, in IBP TS Supply Planning?

The Base Planning Level for Production Receipts is WKPRODLOCSRC, where the Source ID is Product+Location+ProdVersionID. But we want to display the Production Receipts for each Resource ID within the recipe, similar to displaying the Operation Quantity in ECC?

Thanks in advance for your insights.

Thanks,

Mangesh

[former_member654033]

Hi Mangesh,

Please check if below calculation helps (You need to ensure to create the time periods for all the periods of WKRESPRODLOCSRC to display this new KF)

Thanks

Girish

[former_member602633]

Thanks Rahul for the detailed explanation.

I did try this calculation, but the Production Receipts for the Co-Product is not equal to the calculated Production Receipts based on the PCAPAUPSAGEALL. Essentially it is splitting the Primary Products Capacity Usage (PCAPAUSAGE) based on the Output Coefficient. We need to calculate the Co-Product Capacity Usage based on the Production Receipts and display it at the Resource ID level, but there is no way to calculate the same.

Any insights on how can we achieve this would be appreciated.

Thanks,

Mangesh

[rahulmohnot]

Mangesh,

You can achieve this. But the Co-products will have same consumption of the resource as the Primary Product.

With modeling assumptions that1) Every Primary product has one unique Source ID and 2) Co-products are associated with primary product's source id with type "C".

Step 1. Move PCAPAUSAGE to new planning level without product "WKRESLOCSRC" with SUM

Step 2. Create new attribute as KF for Output Coefficient at level "WKPRODLOCSRC", if time series for this doesn't exist.

Step 3. Create final KF PCAPAUSAGEALL at WKPRODLOCRESSRC with join/multiplication of above 2 KFs and condition that if Output coefficient exist then use 1 else "Null".

Hope this approach will pave the way for what you want to achieve.

Regards,

Rahul

[former_member602633]

Hello Matheus,

Yes we are using custom key figure to replicate PCAPAUSAGE to calculate the Production Receipts by Resource ID. We want to calculate the Production in LB's by Resource ID.

Custom Production Receipts KF = PCAPAUSAGE@WKRESPRODLOCSRC / PCAPACONSUMPTION@WKRESPRODLOCSRC

But the PCAPAUSAGE is not calculated for Co-Products (Source Type = C) and hence we are not able to calculate the Production Receipts by Resource ID for the Co-Product , which could be different than the Primary Product. Standard Production Receipts KF is available, but the base Planning Level is WKPRODLOCSRC, there is no Resource ID.

Is there a way to calculate the PCAPAUSAGE based on the Output Coefficient?

Thanks,

Mangesh

[mkorndoerfer]

Hello Mangesh,

By default, no. We have the Capacity Usage of Production Resource (PCAPAUSAGE) key figure, at base planning level WKRESPRODLOCSRC, available though that shows how much of a resource's capacity supply is consumed by the production of a product. It's calculated as follows:

Capacity Usage (t) = Production Receipts (t) * Capacity Consumption Rate of Production Resource (t)

This could be achieved however through some custom calculations on different levels.

Best regards,
Matheus