Question: This is the Excel sheet without additional constraints. How do I incorporate the constraint for this question on Excel? My Excel formula for the cell

This is the Excel sheet without additional constraints. How do I incorporate the constraint for this question on Excel? My Excel formula for the cell G3 is =SUMIF($A$3:$A$16,F3,$D$3:$D$16)-SUMIF($B$3:$B$16,F3,$D$3:$D$16) and I tried =G4+G6>=1 for the problem but it failed to find a route that connects (Solver chose 2->5->8, without considering 1->2 even though I made sure to add the constraint for node 1=1)
This is the Excel sheet without additional

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!