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 ft 2 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. The company wishes to have a relatively square building. Thus, they wish neither the building length nor the building width exceed the other by more than 25%. Add constraint(s) to enforce this design constraint.

Question

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 ft 2 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. The company wishes to have a relatively square building. Thus, they wish neither the building length nor the building width exceed the other by more than 25%. Add constraint(s) to enforce this design constraint.

Quizplus · Accepted Answer

The Answer of 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 ft 2 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. The company wishes to have a relatively square building. Thus, they wish neither the building length nor the building width exceed the other by more than 25%. Add constraint(s) to enforce this design constraint.

Exhibit 8.2 The Following Questions Pertain to the Problem and Spreadsheet Below