Distribution in excel

Hi 

I want to allocate Stock available (Column K) qty as per Sales order – Line item combination (basis first come first serve basis).

 

Sales order qty – 5169

Available stock qty – 3500

* Allocation should happen basis first Sales order and first line item combination.

 

Please guide solution to it…

By: Ayush

One thought on “Distribution in excel

  1. cheap jordans

    There are some fascinating points in time on this article however I don抰 know if I see all of them center to heart. There’s some validity but I’ll take hold opinion till I look into it further. Good article , thanks and we wish more! Added to FeedBurner as well

Leave a Reply

Your email address will not be published. Required fields are marked *