So here's the deal. The Word Count and Number of Days will be given per project. The changing variables will be the Translators, Editors, and Proofers.
Contraints are:
X= 2000, where X is the maximum number of words a SINGLE translator can do in a day
Y=5000, where Y is the maximum number of words a SINGLE editor can do in a day
Z=10000, where Z is the maximum number of words a SINGLE editor can do in a day.
I think the equation would be: No. of days= Word Count/2000X+Word Count/5000Y+Word Count/10000Z
We have to determine what the optimal mix of x,y,z based upon the constraints, word count and number days available to complete project.
Example:
Word Count: 100,000
Days: 10 days
we cannot simply divide 100,000/2000 (translators) because it would take ONE translator 50 days. BUT...if we had (10) translators then we could complete the translations in 5 days and higher 5 editors to complete in 4 days and then etc etc.
I can't figure out how to use solver to set this up. Anyone?
Contraints are:
X= 2000, where X is the maximum number of words a SINGLE translator can do in a day
Y=5000, where Y is the maximum number of words a SINGLE editor can do in a day
Z=10000, where Z is the maximum number of words a SINGLE editor can do in a day.
I think the equation would be: No. of days= Word Count/2000X+Word Count/5000Y+Word Count/10000Z
We have to determine what the optimal mix of x,y,z based upon the constraints, word count and number days available to complete project.
Example:
Word Count: 100,000
Days: 10 days
we cannot simply divide 100,000/2000 (translators) because it would take ONE translator 50 days. BUT...if we had (10) translators then we could complete the translations in 5 days and higher 5 editors to complete in 4 days and then etc etc.
I can't figure out how to use solver to set this up. Anyone?
