Hi
I am looking for a formula to do the below in Excel
For Eg:
I have 10 Apples in the business
8 stores
Each store minimum Qty is varies from 2 to 4
so I want to allocate 10 apples to stores based on the ranking ( already arranged in such a way )
if store A has min of 4 , B has 3 and C &D has 2 each and E , F G and H has 1 each - in total I need 15 pcs. but i have only 10.
So of course store A will get 4 , B will get 3 and C will get 2 - I need to allocate balance 1 to D and rest all stores will be zero.
attached the workbook.
Column C5 - Total Available
D5 to K 5 - Allcoation Qty needed here
D3 to K3 - Min to allocate.
Bookmarks