Reference no: EM132229152
A real estate developer is planning to build an apartment building specifically for graduate students on a parcel of land adjacent to a major university. Four types of apartments can be included in the building: efficiencies, and one-, two-, and three-bedroom units. Each efficiency requires 550 square feet; each one-bedroom apartment requires 725 square feet; each two-bedroom apartment requires 850 square feet; and each three-bedroom unit requires 1,025 square feet. The developer believes that the building should include no more than 16 one-bedroom units, 20 two-bedroom units and 12 three-bedroom units. Local zoning ordinances do not allow the developer to build more than 40 units in this particular building location, and restrict the building to a maximum of 42,000 square feet. The developer has already agreed to lease 5 one-bedroom units and 8 two-bedroom units to a local rental agency that is a ‘silent partner” in this endeavor. Market studies indicate that efficiencies can be rented for $560 per month, one bedrooms for $675 per month, two-bedrooms for $750 per month and three-bedrooms for $970 per month. The developer wants to know how many units of each type should be included in the building plans in order to maximize the potential rental income from the building?
1. Explain this model in clear terms: what are the decision variables, what is the objective function, what are the constraints, etc? You can write out the algebraic formulation, but be sure to provide a contextual explanation as well, so that someone unfamiliar with optimization could still understand the model.
2. Build a spreadsheet model that implements the model you outlined in question 1. Find the optimal solution using Solver.
(A) Answer the following questions about your optimal solution.
How many of each type of housing unit should be included (fractions are allowed)?
What is the maximum total rental income possible?
Which constraint(s) are binding?
SHOW ALL FORMULAS USED IN EXCEL.
|
Calculate days sales in receivables
: Given - Net sales total $547500. Beginning and ending accounts receivable are $38000 and $46,000, respectively. Calculate days' sales in receivables
|
|
Target market that will benefit from your product
: How are you solving the problem or addressing the need you identified. Target market that will benefit from your product, service, or technology.
|
|
Interactions and inputs different between goods and services
: How are customer interactions and inputs different between goods and services?
|
|
Determine the dollar value of the interest expense
: On January 1, 2018, Baltimore Company issued $250,000 face value, 7%, 5-year bonds at 102. Determine the dollar value of the interest expense
|
|
Explain this model in clear terms-decision variables
: Explain this model in clear terms: what are the decision variables, what is the objective function, what are the constraints, etc?
|
|
Are you ready to escape the inner mental prison
: So how about you? Even if you believe that the "sky is falling," what are you going to do about it? Are you willing and committed to be a part of the solution.
|
|
What is the unrealized gain or loss on the investment
: What is the unrealized gain or loss on the investment that should be reported at year end by All Good Company
|
|
Appraisal of proposed construction as-if complete requires
: The operations manager’s job process does not include. The appraisal of proposed construction "as-if" complete requires a(n):
|
|
Recording the journal entry
: The note requires principal and interest at 12% to be paid on April 30, 2019. Please help with recording the journal entry
|