Re-ordering Inventory based on Use

I own an Ice Cream store that has 32 ice cream flavors and I am trying to create a worksheet that I can enter my ice cream order amounts for the quantity of 2.5 gal buckets I have delivered twice a week for each flavor, then take that information and use it to track the percentage of best selling flavors.

I've already done that work and am entering data into cells to create a database based on quantity ordered for each flavor to be delivered.

With that information I am able to create an inventory stock level for each flavor based on it's percentage of use. My maximum inventory can only be 76 buckets, so now what I am trying to do is create an "Ice Cream Order" list based on current inventory vs popularity of the flavor.

I've got almost all the work done, but I'm trying to figure out what to do, or rather how to calculate in the percenatges of buckets I need to order without exceeding my maximum of 76 buckets in inventory.

Chocolate for example is a good seller and I calculate based on the numbers that I should maintain an inventory level of 4.989 buckets. If I have 2 chocolate buckets in inventory , then I need to order 2.989 buckets...but in reality I need to order whole buckets, or 3 buckets.

Problem is, I ordered .011 more than I need, which is really 1 bucket, so I need to make sure I order 1 less of another flavor so as not to exceed my 76 buckets inventory requirement. Maybe a less popular flavor comes in at 1.222 buckets, so it's a canidate to order 1 bucket and me to be .222-.011 =.211 buckets under inventory. As long as I am less than 1 bucket under maximum inventory I'm fine, but I need to be within less than 1 bucket under when ordering.

So, whats the best way to automatically solve this in Excel? With a macro? or can it be done via lookup tables and conditional formulas?

Attached is what I've done so far.

To complicate things a bit, in those situations where I'd order more buckets than needed as in the Chocolate example above, I'd need to have the worksheet calculate the extra order based on popularity, so it wasn't selecting to order an extra bucket of a less popular flavor instead of a more popular flavor.