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