cancel
Showing results for 
Search instead for 
Did you mean: 

IBP Time Series In-Transit Supply and In-Transit Receipts KF Aggregates Incorrectly

scott_githens
Explorer
0 Kudos
799

In time series (response and supply) we are presently looking at how to include in transit inventory in the supply plan. Just totalling projected stock KF across our business results in an inventory total that misses in transit stock. Doing some digging, it appears that the In-Transit Supply or In-Transit Receipts KF is were we find the in transit inventory levels. A quick calculation (previous period In-Transit Supply plus transport supply minus transport receipts) seems to tally with the In-Transit Supply KF such that it appears In-Transit Supply is the projected transit inventory.

What I find though is when I look at the data at any time level above the base planning level (TW), the In-Transit Supply and In-Transit Receipts KF aggregate by adding the totals of the lower level buckets. E.g. If TW 1-4 all have an In-Transit quantity of 25, it aggregates to 100. However the intransit quantity for that month (Jan) should be 25. However, I would have expected the In-Transit KF's to be treated in the same was as say the Projected Stock KF, were when you aggregate time buckets it takes the closing bucket rather than adding all child buckets together.

What have other people done in regards to getting the in-transit inventory to be accounted for in the supply plan inventory projections, and assuming my approach of looking at In-Transit Supply and In-Transit Receipts KF is correct did you encounter and resolve the time aggregation issue described above?

Accepted Solutions (0)

Answers (1)

Answers (1)

scott_githens
Explorer
0 Kudos

Updating my post:  It appears that I will need to create a version of these in transit KF's that include the LPA (last period aggregation) function.