A company wants to build a new factory in either Atlanta or Columbia. It is also considering building a warehouse in whichever city is selected for the new factory. The following table shows the net present value (NPV) and cost of each facility. The company wants to maximize the net present value of its facilities, but it only has $16 million to invest. 
Based on this ILP formulation of the problem and the indicated optimal solution what formulas should go in cells F6:F14 of the following Excel spreadsheet? 
Definitions:
Q21: The problem of finding the optimal values
Q23: Any shortest path problem can be modeled
Q35: The first step in formulating an LP
Q42: The goal of the modeling approach to
Q61: A minimum or maximum flow restriction in
Q76: Linear programming problems cannot have multiple objectives
Q81: The Reduced Gradient is similar to which
Q95: Refer to Exhibit 11.1. If predicting the
Q97: The parameters of the logistic regression model<br>A)
Q121: Refer to Exhibit 10.2. What is the