A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time. The city is divided into 4 zones. The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2. The number of tall buildings in each zone and the travel time between zones is listed below.
Based on this ILP formulation of the problem what formulas should go in cells B13:B16, B20:E20, F20, and F23:F24 of the following Excel spreadsheet?
Let X_i = 1 if truck located in zone i, 0 otherwise

Question

A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time. The city is divided into 4 zones. The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2. The number of tall buildings in each zone and the travel time between zones is listed below.

Based on this ILP formulation of the problem what formulas should go in cells B13:B16, B20:E20, F20, and F23:F24 of the following Excel spreadsheet?
Let X_i = 1 if truck located in zone i, 0 otherwise

Quizplus · Accepted Answer

The Answer of A city wants to locate 2 new fire fighting ladder trucks to maximize the number of tall buildings which they can cover within a 3 minute response time. The city is divided into 4 zones. The fire chief wants to locate no more than one of the trucks in either Zone 1 or Zone 2. The number of tall buildings in each zone and the travel time between zones is listed below. Based on this ILP formulation of the problem what formulas should go in cells B13:B16, B20:E20, F20, and F23:F24 of the following Excel spreadsheet? Let X_i = 1 if truck located in zone i, 0 otherwise

A City Wants to Locate 2 New Fire Fighting Ladder