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 $15 million to invest. 
Based on this ILP formulation of the problem and the indicated optimal solution what values should go in cells B6:G14 of the following Excel spreadsheet? 
Definitions:
Q7: The "Analyze Without Solving" tool in Analytic
Q11: A company will be able to obtain
Q20: Refer to Exhibit 4.1. Should the company
Q23: The objective function in regression analysis is<br>A)
Q40: Suppose that the observations are partitioned into
Q40: Transportation/assignment problems are sparse or not fully
Q48: A trucking company wants to find the
Q51: In discriminant analysis the averages for the
Q67: The actual value of a dependent variable
Q85: How are binary variables specified in the