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