Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL SOLVER PLEASE. I NEED IT QUICKLY. THANK YOU. 2. A realtor is developing a rental housing and retail

PLEASE SOLVING MATHEMATICAL MODELS AND LP EXCELL SOLVER PLEASE. I NEED IT QUICKLY. THANK YOU.

image text in transcribed

2. A realtor is developing a rental housing and retail area. Tlle housing area consists of efficiency apartments, duplexes, and single-family homes. Maximum demand by potential renters is estimated to be 500 efficiency apartments, 300 duplexes, and 250 single-family homes, but the number of duplexes must equal at least 50% of the number of efficiency apartments and single homes. Retail space is proportionate to the number of home units at the rates of at least 10 ft, 15 ft and 18 ft for efficiency, duplex, and single family units, respectively. However, land availability limits retail space to no more than 10,000 ft. The monthly rental income is estimated at $600, $750, and $1200 for efficiency, duplex, and single- family units, respectively. The retail space rents for $100 / ft. Determine the optimal retail space area and the number of family residences. 2. A realtor is developing a rental housing and retail area. Tlle housing area consists of efficiency apartments, duplexes, and single-family homes. Maximum demand by potential renters is estimated to be 500 efficiency apartments, 300 duplexes, and 250 single-family homes, but the number of duplexes must equal at least 50% of the number of efficiency apartments and single homes. Retail space is proportionate to the number of home units at the rates of at least 10 ft, 15 ft and 18 ft for efficiency, duplex, and single family units, respectively. However, land availability limits retail space to no more than 10,000 ft. The monthly rental income is estimated at $600, $750, and $1200 for efficiency, duplex, and single- family units, respectively. The retail space rents for $100 / ft. Determine the optimal retail space area and the number of family residences

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions