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 Xi = 1 if truck located in zone i, 0 otherwise 
Definitions:
Perseveration
The repetitive and continuous fixation on a specific thought, action, or emotion, despite attempts to change or divert it.
Delusions of Reference
A type of delusion where a person believes that mundane occurrences or casual remarks are specifically targeted at themselves.
Genetic Factors
Elements within an organism’s genes that can influence physical traits, behavior, and susceptibility to certain conditions.
Identical Twins
Twins that result from the splitting of a single fertilized egg, sharing the same genetic makeup.
Q2: Refer to Exhibit 7.4. What formulas should
Q16: The Simplex method uses which of the
Q36: What needs to be done to the
Q46: Binding constraints have<br>A) zero slack.<br>B) negative slack.<br>C)
Q50: Suppose you want to minimize an objective
Q59: Which of the following categories of modeling
Q63: The constraint X<sub>13</sub> + X<sub>23</sub> − X<sub>34</sub>
Q75: Based on the following regression output, what
Q82: Solve the following minimal spanning tree problem
Q92: Refer to Exhibit 10.4. What formulas should