This preview shows page 1. Sign up to view the full content.
Unformatted text preview: appropriate for this problem. b) Solve it using Excel. Mathematical Formulation Suppose Lauren Moore purchases X units of condominium and Y acres of land. Then the return that can be expected is Z = 8000 X + 6000 Y The constraint on the budget is 65000 X + 28000 Y 720000 (2000 X + 1500 Y) 67000 X + 29500 Y 720000 Constraint on maintenance cost is 2000 X + 1500 Y 14000 Thus the problem becomes: Find a nonnegative integer X and nonnegative real number Y so as to Maximize Z = 8000 X + 6000 Y Subject to 67000 X + 29500 Y 720000 And 2000 X + 1500 Y 14000 Solution X Y 7 CONSTRAINT 1 469000 CONSTRAINT 2 14000 MAX. RETURN 56000...
View
Full
Document
 Spring '08
 STAFF

Click to edit the document details