An investor has 500000 to invest and wants to maximize the

Assignment Help Operation Management

Reference no: EM13382512

An investor has $500,000 to invest and wants to maximize the money they will receive at the end of one year. They can invest in condos, apartments and houses. The profit after one year, the cost and the number of units available are shown below.

Variable	Investment	Profit ($1,000)	Cost ($1,000)	Number Available
X₁	Condos	6	50	10
X₂	Apartments	12	90	5
X₃	Houses	9	100	7

a) Word-process the linear programming model below.

Variables

X₁ = Number of condos purchased

X₂ = Number of apartments purchased

X₃= Nummber of houses purchased

Objective Function

Constraints

b) Set up the spreadsheet for Excel Solver. Copy and paste the spreadsheet below.

c) Copy and paste the Answer report below.

d) Write the Optimal Solution below. Note: The Optimal Solutions should include the optimal values for the non-zero variables as well as the objective function.

Reference no: EM13382512

Questions Cloud

Compare and contrast the mis in place in two distinctly : compare and contrast the mis in place in two distinctly different organizations.compare each organizations use of

A railroad needs to move the maximum amount of material : a railroad needs to move the maximum amount of material through its rail network. the numbers given on the arcs are

A company needs to ship 100 units from seattle to denver at : a company needs to ship 100 units from seattle to denver at the lowest possible cost. the costs associated with

Finnish furniture manufactures tables in facilities located : finnish furniture manufactures tables in facilities located in three cities-reno denver and pittsburgh. the tables are

An investor has 500000 to invest and wants to maximize the : an investor has 500000 to invest and wants to maximize the money they will receive at the end of one year. they can

Problem a cellular phone company wants to locate two new : problem a cellular phone company wants to locate two new communications towers to cover 4 regions. the company wants to

The need for a centralized management structure that will : the need for a centralized management structure that will coordinate projects for organizations in the face of mounting

A project has an expected duration of 34 weeks with a : a project has an expected duration of 34 weeks with a critical path variance of 6. suppose the project network is given

You are required to submit an individual report of 3000 : you are required to submit an individual report of 3000 plusmn10 words which can be based on an organization or idea of

User Account

All Pages