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: 
Based on this ILP formulation of the problem what formulas should go in cells F6:F14 of the following Excel spreadsheet? 
Definitions:
McCarran-Ferguson Act
A United States federal law that exempts insurance businesses from most federal regulation, allowing states to regulate the insurance industry.
Antitrust Legislation
Laws designed to promote fair competition and prevent monopolies, conspiracies, and other situations that restrain trade.
Judicial Law
Laws created by judges through court decisions and interpretations rather than those enacted by legislative bodies.
Statutory Law
Laws that are written and enacted by legislative bodies, distinguishing them from common law or regulations enacted by executive agencies.
Q4: A dietitian wants to formulate a low
Q4: Which of the following is true of
Q16: Which of the following is not a
Q17: What are binary integer variables?<br>A) Variables with
Q44: How many binary variables are required to
Q62: Mathematical programming is referred to as<br>A) optimization.<br>B)
Q75: When do alternate optimal solutions occur in
Q81: Refer to Exhibit 11.4. What formula should
Q84: In regression analysis, the total variation is:<br>A)
Q86: A maximal flow problem differs from other