A Cellular Phone Company Wants to Locate Two New Communications

Essay

A cellular phone company wants to locate two new communications towers to cover 4 regions.The company wants to minimize the cost of installing the two towers.The regions that can be covered by each tower site are indicated by a 1 in the following table:
Tower Sites
$\begin{array}{rrrrr}\text { Region } & 1 & 2 & 3 & 4 \\\hline \text { A } & & 1 & & 1 \\\text { B } & 1 & & 1 & 1 \\\text { C } & 1 & 1 & 1 & \\\text { D } & 1 & & & 1\\\hline \text { COST } \$ 000 \text { s) } & 200 & 150 & 190 & 250\end{array}$
MIN: ^{200 X}₁ ^{+ 150 X}₂ ^{+ 190 X}₃ ^{+ 250 X}₄
Subject to: ^X₂ ^{+ X}₄ ^{? 1}
X₁ + X₃ + X₄ ? 1 X₁ + X₂ + X₃ ? 1 X₁ + X₄ ? 1
X₁ + X₂ + X₃ + X₄ = 2 X_i = 0,1
Based on this ILP formulation of the problem and the solution X₁,X₂,X₃,X₄)= 1,1,0,0)what values should go in cells B6:G14 of the following Excel spreadsheet?