Estate developer is planning to build apartment building

Assignment Help Operation Management

Reference no: EM132227439

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?

Reference no: EM132227439

Questions Cloud

Discuss about ongoing immigration issues and controversies : To stimulate your thinking about ongoing immigration issues and controversies. Please copy 2 sentences from that article; write a 5 sentences reaction.

Should anyone who observed behavior feel obligated to report : Should anyone who observed the behavior feel obligated to report it? Why do you think only female members reported the behavior?

What would you do if faced with a legal or ethical dilemma : Describe the ethical and legal considerations of a professional strategic financial management function in an organization. What would you do if faced with.

Define amazon business-level strategy for the kindle : Define Amazon’s business-level strategy for the Kindle – now branded as Fire. Based on the analysis, what, if any changes would be appropriate?

Estate developer is planning to build apartment building : 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.

Discuss about the competitive marketing analysis : Conduct an evaluation of the organization based on strategic planning analysis, which includes the strengths and/or weaknesses that are internal.

Using electronic data interchange to automate order placing : Suppose that actual demand is 60 pairs but that ordering costs are cut to only $6 by using electronic data interchange to automate order placing.

Numerous factors related to managing team leadership : We have considered numerous factors related to managing team leadership during this course.

Explain the role of social workers in supporting clients : Post an explanation of why our society has marginalized those with varying abilities historically. Then, explain the role of social workers in supporting client

User Account

All Pages