Math Homework Help

home / study / math / advanced math / advanced math questions and answers / solve the problem using excel solver, please post the formulas

we want to isolate the infected cities A B C in region 1 from the uninfected L M N in region 2 with the lowest possible number of testing units:

write a model to find out how many units are needed in the optimal solution.

From To Test 

A k 4 

A d 9 

B d 8 

B e 20 

C f 14 

d h 10

 d g 5 

e g 8

 e j 12

 e f 5

 f N 6 

g h 15

 h k 11

 h i 13

 i j 7 

i M 22

 j N 3 

k L 12 

k M 5