• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding Inventory Based on Lot Size

ggmkp

New Member
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.

60767

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:

60768

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

Attachments

vletm

Excel Ninja
ggmkp
Please, reread
 
Top