Determine the optimal configuration for the building

Assignment Help Supply Chain Management

Reference no: EM133412005

Question: Metro Real Estate recently acquired a building site to develop rental apartments. The complex will consist of a mix of studio apartments and duplexes. The site is zoned for a maximum building size of 20,000 square feet and Metro has budgeted $8M dollars for construction. Studio apartments are 800 square feet and cost $300,000 to build. Duplex apartments are 1,200 square feet and cost $700,000 to build. The architects can design a building with any mix of studio and duplex apartments. Metro estimates that the monthly income on studio apartments will be $2,000 while the monthly income on duplex apartments will be $3,800.

To aid in their project planning, management at Metro developed an optimization model using Solver in Excel to help determine the optimal configuration for the building.

Reference no: EM133412005

Questions Cloud

Apple inc - global supply chain management : Apple inc - Global supply chain management I want some help to know about the alternatives to solve the problem of case study

Identify six key areas of diversity : Identify six key areas of diversity from the following list and for each selected, give a brief description of what it means:

Make use of rain forecasts : How can Rachel make use of the rain forecasts to improve her forecasts of total sales each day?

How to guide identifying the main stages of filing : Identify, gain access to, read and understand your company's documentation on record-keeping. Drawing on the key information, 'how to' guide identifying

Determine the optimal configuration for the building : To aid in their project planning, management at Metro developed an optimization model using Solver in Excel to help determine the optimal configuration

Common licensing deals between distributor and exhibitor : Which is the most common licensing deals between a distributor and an exhibitor? Which of the following best describes the duration of a trademark?

How can you use balance sheets of these customers to help : How can you use balance sheets of these customers to help you decide which ones are worthy of credit

Describe three modifications to policies and procedures : Describe three modifications to policies and procedures that Lucas could implement to ensure all team members understand the risk of coming to work

What actions to be taken with the research information : What actions to be taken with the research information The main reason Multisolar is looking into ways to grow its business is so that more homes can use solar

User Account

All Pages