Now create a table with weeks along the top and projects along the side. Each entry in

Question:

Now create a table with weeks along the top and projects along the side. Each entry in the table should indicate how many hours are spent on each project each week. IF functions work here. Finally, create one more table with weeks along the top and managers along the side and use SUMIF functions, based on the data in the previous table, to calculate the number of hours each manager is working each week.

As you can probably guess, you will need to use Evolutionary Solver if you set it up this way. Also, you might have to let Evolutionary Solver run for a long time. This is not an easy problem.)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science

ISBN: 9781111531317

4th Edition

Authors: Wayne L. Winston, S. Christian Albright

Question Posted: