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:
Q11: The hospital administrators at New Hope, County
Q20: Refer to Exhibit 3.1. What formula should
Q25: Refer to Exhibit 10.1. How many observations
Q29: Refer to Exhibit 3.1. Which cells should
Q32: What is the formula for total sum
Q65: Refer to Exhibit 3.1. Which of the
Q69: Consistently using a structured, model based process
Q73: The simplex method of linear programming (LP):<br>A)
Q90: You have been given the following linear
Q98: The ILP problems are computationally<br>A) more demanding