Business requirement:
- For historical periods, Projected Inventory should be equal to the Ending Inventory for that period.
- For current and future periods, Projected Inventory should be derived using the previous period's projected inventory plus shipment forecast minus POS forecast and other consumption adjustments.
Calculation Formula:
Projected Inventory (Current Period)=Previous Period Projected Inventory + Shipment Forecast - POS Forecast - Other consumption adjustments
Calculation must be performed sequentially across forecast periods.
Challenge:
- Calculation requires period-by-period propagation of inventory values, where each future period depends on inventory values derived from prior periods.
- Past records runtime value must update current and future records.
- Despite additional nodes and aggregation logic, the final projected inventory values do not match expected sequential projections.
#Manufacturing Cloud
