J
jeffsmarketplace
I am trying to figure out some timing scenarios. The numbers will
change as the material moves through different steps. Here is what I
am looking at.
B C D E F G H
400 500 600 S2 QT S1 S2
150 10 30 40 60 4.5 3.2
The above is cut from a row of data. Columns B,C and D represent
different steps. Column E is the sum of columns C and D. This leads me
to believe I don't need to factor in columns C and D in my formula. By
the way each of those columns is a quantity of widgets at each step.
Column "F" is the total number of widgets needed for the week. Columns
"G" and "H" are the number of hours it take for one widget to process
at their perspective steps. Column "G's" time of 4.5 hours is the
amount of time is take to process one widget in column B. "C" is a
bake time, so I just count it with column "D" for the total in column
"E".
As an example if column "F"s 60 (weeks orders) were less then column
"E" I could just multiply 60*3.2 for 192 hours, but in the example
above I need 40 widgets from S2 (step 2) at 3.2 hours each and I need
20 of the 150 widgets available from S1 (step 1) at 4.5 hours each
plus they still need to go to S2 and process at 3.2 hours each.
So in essence I am saying how do I tell Excel to figure
40*3.2+20*4.5+20*3.2, but I need to do it when the number of widgets
in a given column changes as they advance through the process. So
there might be a point when I need 10 from S1 and 50 from S2. Also as
they finish S2 that number will decrease. It could end up becoming
21*3.2+15*4.5. I just want to be able to project how long it will take
to finish the process in real time.
Sorry so long - thanks,
Jeff
change as the material moves through different steps. Here is what I
am looking at.
B C D E F G H
400 500 600 S2 QT S1 S2
150 10 30 40 60 4.5 3.2
The above is cut from a row of data. Columns B,C and D represent
different steps. Column E is the sum of columns C and D. This leads me
to believe I don't need to factor in columns C and D in my formula. By
the way each of those columns is a quantity of widgets at each step.
Column "F" is the total number of widgets needed for the week. Columns
"G" and "H" are the number of hours it take for one widget to process
at their perspective steps. Column "G's" time of 4.5 hours is the
amount of time is take to process one widget in column B. "C" is a
bake time, so I just count it with column "D" for the total in column
"E".
As an example if column "F"s 60 (weeks orders) were less then column
"E" I could just multiply 60*3.2 for 192 hours, but in the example
above I need 40 widgets from S2 (step 2) at 3.2 hours each and I need
20 of the 150 widgets available from S1 (step 1) at 4.5 hours each
plus they still need to go to S2 and process at 3.2 hours each.
So in essence I am saying how do I tell Excel to figure
40*3.2+20*4.5+20*3.2, but I need to do it when the number of widgets
in a given column changes as they advance through the process. So
there might be a point when I need 10 from S1 and 50 from S2. Also as
they finish S2 that number will decrease. It could end up becoming
21*3.2+15*4.5. I just want to be able to project how long it will take
to finish the process in real time.
Sorry so long - thanks,
Jeff