Linear Programming - Investment funds
Table of Contents Introduction Mathematical Model Solution Introduction Language used: Excel (Solver add-on) Task to solve: Money to be invested: $5.000.000 Investment type Earning to be achieved (per year) Investment limit (milions) Consumer credit 7% 1 Corporative bonds 11% 1.5 Gold deposits 19% 2.5 Housing loans 12% 1.7 Additional Limits: Investment type Investment out of all funds Consumer credit Maximum 15% Housing loans & Gold deposits Minimum 5% Mathematical Model Decision Variables:...