Can I use solver for this?

[Belinda7237]

I am not sure the best way to solve my problem and am hoping someone can help.

I want to be able to determine approx how long each item takes to produce.
I have types of work new, renewal and mod - and then a complexity level.
I know that it took 6980 total hrs to produce all of these items.

Assumptions that i wanted to build in:
New items take twice as long as renewals and 4 times as long as mods.
Hard items take longer then medium items and medium take longer then easy.

Totals
NEW RENEWAL MOD
EASY 53 71 87
MEDIUM 18 19 24
HARD 29 24 29


Total Hrs 6980

Is this the type of problem solver can help with, or is there aneasier way?

 

[Belinda7237]

Dana -

Thanks for the explanation I validated it with a couple months of my data
sets and works perfectly - I have a few others of these that i can use the
same logic t odevelop an equation for so i wanted t obe able to understand
everything here... I have written it out for myself as you describe here and
completely understand it...with one exception - what numbers were multiplied
to get the 134 t1?

Thank you for steering me right with your brillant mind!!!

 

[Belinda7237]

thank you! that helped a great deal - i appeciate all your help...i actually
get it now!