Business Rules

To correctly calculate Stock In Transit, and projected stock, a set of business rules are defined to guide how relevant OTTs are selected, and their contribution to the stock level is deducted. The approach is very simple, as each OTT in ROCK is iterated, and a contribution formula is applied. The result of this process is a total stock contribution for the final number. The process is illustrated below:

The latest version of the business rules used for Calculating Stock in Transit and Stock Projection:

Stock Logic - Formulas v1.vsdx

Stock Logic - Business Rules v4.3.xlsx 

15/5/19: please be mindful attached business rules includes few minor differences, compared to current implementation. stock projection currently being reworked