Problem Solver

[Belinda7237]

I posted a week or so ago and have been successful based on the response I
got. I have a new but similar question that i am trying to solve for with
another layer of complexity:
I Know that it took 6980 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

based on the volume of each type, how long does each type take? can solver
do this?

ND - 1 ND - 2 ND - 3
Coll Complex 1 18 9 9
Coll Complex 2 9 5 5
Coll Complex 3 9 5 5
Coll Complex 4 15 7 7

RD 1 RD 2 RD 3
Coll Complex 1 30 15 15
Coll Complex 2 5 3 3
Coll Complex 3 10 5 5
Coll Complex 4 12 6 6

M 1 M 2 M 3
Coll Complex 1 37 19 19
Coll Complex 2 7 3 3
Coll Complex 3 12 6 6
Coll Complex 4 15 7 7

 

[Belinda7237]

thanks, i appreciate your thoroughness in explanation - how are you
determining the amount of interger solutions - i think i am using solver
inappropriately which is impairing my ability to solve these on my own?

 

[Dana DeLouis]

Hi. Feel free to send my your email address, and I'll send a workbook over to you.
You can look at it to get some general ideas.
Let me know what Excel version you have also.

--
Dana DeLouis

thanks, i appreciate your thoroughness in explanation - how are you
determining the amount of interger solutions - i think i am using solver
inappropriately which is impairing my ability to solve these on my own?

"Dana DeLouis" wrote:

<snip>

 

[Belinda7237]

thanks, its (e-mail address removed) and I have Excel 2003