problem solver question

[Belinda7237]

Hoping Dan is out there!

I needed to make a couple of changes to my data set, and cannot get my
equation to work correctly.

Know that it took 8116 hrs to produce the volume below.

ND take twice as long as R and R takes twice as long as M to do. (4T, 2T, T)
I also know that:
based on Coll Complex 1 takes less time then 2 and 2 takes less time then 3
and 3 takes less time then 4.
I also know that:
ND1 1 takes less time then ND 2 which takes less time then 3
same with R items and M items

My volume is:
ND 1 ND2 ND3
Coll Complex 1 18 16 2
Coll Complex 2 9 8 1
Coll Complex 3 9 8 1
Coll Complex 4 15 13 1

RD 1 RD2 RD3
Coll Complex 1 31 27 3
Coll Complex 2 5 4 1
Coll Complex 3 10 8 1
Coll Complex 4 12 11 1

M 1 M2 M3
Coll Complex 1 38 33 4
Coll Complex 2 7 6 1
Coll Complex 3 12 11 1
Coll Complex 4 15 13 1

Can you help me to figure out how long each takes.

 

[ShaneDevenshire]

Hi,

You know you can Google Excel Solver and find many examples of how to use
it. Also Microsoft has a file that demonstrates half a dozen uses.