Adding Inventory Based on Lot Size

[ggmkp]

I'm trying to add qty to Inventory (B5:G7) so that Supply meets Demand by first looking at the Storage with the lowest fruit count and adding the qty based on the lot size.



Demand is manual input
Supply is Sum(B5:B7), Sum(C5:C7)+B3 and on (cumulative)
Total is Supply-Demand
The result should look like this:



Storage table is used only to find the fruit with the lowest count. Then adding the qty based on the lot size.

 

[AlanSidman]

crossposted: https://www.excelforum.com/excel-fo...79704-adding-inventory-based-on-lot-size.html

https://www.mrexcel.com/forum/excel-questions/1101321-adding-inventory-based-lot-size.html

 

[pecoflyer]

Also cross posted at stackoverflow

 

[vletm]

ggmkp
Please, reread

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[Fluff13]

Also on ExcelGuru

 

[ggmkp]

Please delete my post, I will repost with more clarity with explanation. thanks

 

[vletm]

ggmkp
Did You reread that my sent link?
Why to delete 'Your post'? You can continue using this opened thread.