Forum Discussion
Solved
Calculate a capacity-adjusted demand allocation according to a ranking
In this scenario, only 6 suppliers of 7 will receive demand. The goal is for the adjusted demand allocations to be assigned, by a formula, to the highest ranked suppliers, up to their capacities, unt...
BDB1973 Not sure I understand but perhaps you should start by sorting by rank and then us a fairly straight-forward formula to allocate the total amount that I placed in B11. See attached.
=MAX(0,(MIN(C2,$B$11-SUM($C$1:C1))))
BDB1973 Not sure I understand but perhaps you should start by sorting by rank and then us a fairly straight-forward formula to allocate the total amount that I placed in B11. See attached.
=MAX(0,(MIN(C2,$B$11-SUM($C$1:C1))))
- Riny_van_Eekelen: This solved my issue. Many times, simpler is better. Thank you so much.
