Optimization and Efficiency

l'm working on an optimization/efficiency spreadsheet for roasting coffee.

I think the following sums up my issue:

(A1)/x = y

Where "A1" is the given value, "x" is any real number from 10 to 10.8, and "y" is any whole integer. The formula should give preference to keeping "y" as low as possible.

If the real world example helps, here is what is going on:

"A1" is a quantity of coffee to be roasted in pounds.
"x" is the amount of coffee that can be roasted in each batch (anywhere from 10-10.8 pounds)
"y" is the number of batches to roast (thus why it must be a whole number)

I have run solver, but cannot get solver to return y as a whole integer. I imagine that there is an easier way to solve this without using solver, but my Excel skills are limited.

Thanks in advance for any help

Thanks for the quick response.

What I am trying to do is to have Excel determine the best value for "x" in order to optimize "y"

So, the way I understand the formula that you wrote, I have to determine the value of "x"

Does that make sense?

That is closer to what I am looking for, but does not work on the following example:

If you use the value of "41" for A1 in your attached file, ideally A2 would pull the F1 and F2 combo instead of K1 and K2 because the result of F1 and F2 would be less waste (.2 pounds) than K1 and K2 (2.2 pounds)

Thanks