Short Answer
Exhibit 8.2
The following questions pertain to the problem and spreadsheet below.
A construction company just purchased a 300 × 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft2 of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars).
The following is the NLP formulation for the problem. The spreadsheet implementation of this formulation applies to the following questions.
-Refer to Exhibit 8.2. What formula would you place in cell B6 to calculate Total Lot Area?
Correct Answer:

Verified
Correct Answer:
Verified
Q17: The GRG and Simplex algorithms are similar
Q18: The straight line (Euclidean) distance between two
Q19: An investor is developing a portfolio of
Q20: How many local minimum solutions are there
Q21: Which point or points are local optima
Q23: A company makes products A and B
Q24: Exhibit 8.1<br>The following questions pertain to the
Q25: An office supply company is attempting to
Q26: A company wants to locate a new
Q27: The main difference between linear (LP) and