I have the sales and stock in hand quantities for company branches'.
All I need is to find a formula that help me to distribute the stock in hand from the branches' that has lowest salesto the branches that have the highest sales quantities.
Example:

Branch name Sales qty Stock qty

A 9 1
B 4 6
C 3 2
D 0 3
E 0 5