Question: Solve the question on the picture with linear optimalization in Excel?A project is composed of 7 activities labeled as A , B , C ,
Solve the question on the picture with linear optimalization in Excel?A project is composed of activities labeled as A B C D E F and G The durations in
days and precedence constraints of the activities are given in the following figure.
For example, activity E that takes days, can only start after activities and have been
finished.
a Solve a linear optimization model to determine the earliest project finish time.
b Activities D and E now use the same resource and cannot be executed at the same
time. What is the optimal schedule and finish time? Give a convincing argument.
c Integrate part b in one integer linear optimization model to find the optimal
schedule and finish time. Hint: Use a binary variable indicating which one goes first
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
