I am sure it is ... but a lot more detail is required to devise a formula(s).

"Christy" wrote:

I need a execl formula that will tell me how many egg breaking machines I
need to set to seperate in order to complete my load demand for the week. I
have three breaking options 1 machine 1.5 manchines and 2 machines we sell
three products Whole Egg, Whites and Yolks. Taking into account beginning
inventory, load schedule, and product produced for each breaking option. I
want excell to tell me how many machines I have to use to seperate:

Sunday 1 machine, Monday 1.5 machine, Tuesday 1 machine, ect for 1 week.

Is this possible?