How to calculate total safety days demand in IBP?

[former_member607906]

We have a requirement to calculate only Total safety days demand (Independent Demand + Dependent Demand) based on number of days maintained in safety days of supply (SUBPERIODNUM KF). All calculations are at day/product/location level.

I tried below logic after TS heuristic run output and it gave correct results. But for location-product where lot sizes are maintained it is not working.

IF(ISNULL("SUBPERIODSOFSUPPLY@DAYPRODLOC") OR("SUBPERIODSOFSUPPLY@DAYPRODLOC" = 0), NULL, ("PROJECTEDINVENTORY@DAYPRODLOC" + ("NETDEMAND@DAYPRODLOC" - "TOTALRECEIPT@DAYPRODLOC")))

Is there any other way to calculate this as it is dynamic in nature

[former_member654033 · Accepted solution]

Hi Mayank,

If requires forward cover calculation so you cannot do without L Code (As it will require multiple time period demands to be read in the future).

Please explore the use of "ADDITIONALLOTSIZEDEMAND" Key figure, if this can meet your requirement.

The key figure Additional Lot-Sizing-Procedure Demand(ADDITIONALLOTSIZEDEMAND) shows you how many additional units of a product have to be kept in stock to satisfy the demand generated by using lot-sizing procedure.

Thanks

Girish

[former_member194529]

Hi Mayank,

Have you find a solution for your requirement? If yes, feel free to share it here.

Best,

Ivan