Question
Can you please help? I have an excel file created but the values aren't calculating properly. A mortgage company owns the following 10 mortgages. Investors
Can you please help? I have an excel file created but the values aren't calculating properly.
A mortgage company owns the following 10 mortgages. Investors will purchase packages of mortgages worth at least $1 million. What is the maximum number of such packages that can be created from this set of mortgages?
| Mortgage | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
| Amount (in $1000s) | $900 | $860 | $780 | $525 | $240 | $185 | $165 | $164 | $135 | $125 |
-
Create a spreadsheet model for this problem and use Solvers evolutionary algorithm to solve it.
-
What is the optimal solution?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Operational Review Maximum Results At Efficient Costs
Authors: Rob Reider
3rd Edition
0471228109, 978-0471228103
