Skip to Content
1
Dec 04, 2019 at 08:57 AM

How to calculate total safety days demand in IBP?

259 Views

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