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:
FAB
An acronym for Features, Advantages, and Benefits, a sales and marketing strategy focusing on the product's aspects and their value to the customer.
SELL Sequence
A structured approach in sales that typically includes steps such as Show features, Explain advantages, Lead into benefits, and Let the customer talk.
Business Proposition
An offer or plan proposed by a business to provide certain products or services with the aim of generating value or profit.
Marketing Plan
A comprehensive document outlining a company's strategy for promoting and selling its products or services to its target market.
Q8: A farmer is planning his spring planting.
Q12: Refer to Exhibit 9.1. Predict the mean
Q18: The straight line (Euclidean) distance between two
Q22: A research director must pick a subset
Q24: A formulation has 20 variables and 8
Q58: An oil company wants to create lube
Q64: Refer to Exhibit 11.5. What formula should
Q85: The Fisher classification scores can be converted
Q85: A financial planner wants to design a
Q114: Suppose that the correlation coefficient between X<sub>1</sub>