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

question 22

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 ft² 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?

---

Definitions:

Common Stock

A form of corporate equity ownership, a type of security representing an ownership share in a corporation, where holders benefit from company profits and voting rights.

Convertible Preferred Stock

A type of preferred stock that holders can convert into a predetermined amount of the company's common stock, usually at specific times.

Common Stock

A type of security that signifies ownership in a corporation and represents a claim on part of the corporation's profits and assets.

Par Value

The nominal or face value of a stock or bond as stated by the issuer, which does not necessarily reflect its market value.