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?

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?

What do I need?

"Toppers" wrote:

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?

Explain the logic of the calculations of your process - I know nothing about
breaking eggs !

"Christy" wrote:

What do I need?

"Toppers" wrote:

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?

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?

Certainly, start by writing down how you determine the machine schedule
now. THEN you put the math in Excel.