Essay
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 values would you enter in the Risk Solver Platform (RSP) task pane for the above Excel spreadsheet?
Objective Cell:
Variables Cells:
Constraints Cells:
Correct Answer:

Verified
Correct Answer:
Verified
Q1: A company has collected the following inventory
Q2: Find the maximum solution on this graph
Q5: Which point or points are local optima
Q6: How much are additional units of Labor
Q8: The optimal solution to a LP problem
Q9: An investor is developing a portfolio
Q10: How many local maximum solutions are there
Q11: An investor is developing a portfolio of
Q52: The total annual cost for the economic
Q78: The Lagrange Multiplier is similar to which