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?

Question

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?

Quizplus · Accepted Answer

The Answer of 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?

A Cellular Phone Company Wants to Locate Two New Communications