Data Optimization using Solver Real Estate Development - Management Assignment Help

Assignment Task:

TASK:

Data Optimization using SolverReal Estate Development

A real estate developer is planning to build an apartment complex for graduate students on a parcel of land adjacent to a major university. Four types of apartments can be included in the building: studios, and one-, two-, or three-bedroom units. Each studio unit requires 500 square feet; each one-bedroom apartment requires 700 square feet; each two-bedroom apartment requires 890 square feet; and each three-bedroom unit requires 1000 square feet.
The developer wants the building to include no more than 15 one-bedroom units, 22 two-bedroom units, and 10 three-bedroom units. The local zoning ordinances do not allow the developer to build more than 40 units in this location, and they restrict the building to a maximum of 40,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 project. Market data indicate that studios can be rented for $950 per month, one-bedrooms for $1200/month, two-bedrooms for $1400/month, and three-bedrooms for $1800/month.
a) Build an optimization model to determine a plan that maximizes the potential rental income from the building. Clearly indicate the decision variables, the objective function, and the constraints of your model, and any other Solver settings that you declared.
b) What is the optimal solution?
c) If the zoning board allowed the developer to build 8 more units in the apartment complex, how would the total rental income change? Explain how you obtained your answer.
Instructions. Show all your work in a single worksheet. Clearly identify your answers by question number, so that I do not have to guess where to find them in your Excel sheet. To explain your answers, you can type text in cells or text boxes if needed.

This Management Assignment has been solved by our Management experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.