Senarios

C

Christy

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?
 
T

Toppers

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

Bob I

Christy said:
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?
Click to expand...

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