A Real Estate Developer Is Planning to Build an Office

question 31

Essay

A real estate developer is planning to build an office complex.Currently,there are three office sizes under consideration: small,medium,and large.Small offices can be rented for $600 per month,medium offices can be rented for $750 per month,and large offices can be rented for $1000 per month.Each small office requires 600 square feet,each medium office requires 800 square feet,and each large office requires 1000 square feet.The current plot of land available to the developer is 100,000 square feet.The developer wants to ensure that the office complex has at least 3 units of each office size.Use Excel to formulate and solve this problem to maximize total revenue.

---

Definitions:

Workforce Size

The total number of employees, both full time and part time, engaged in an organization or available in the market.

Equipment Used

Equipment used refers to the tools, machinery, and devices employed in the execution of a specific task or operation.

Productivity

The measure of how efficiently production inputs, such as labor and materials, are converted into outputs, or goods and services.

Demand

The quantity of a product or service that consumers are willing and able to purchase at various prices during a given period of time.