A mortgage company owns the following ten mortgages. Investors will purchase packages of mortgages worth at least

Question:

A mortgage company owns the following ten 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?

a. Create a spreadsheet model for this problem and use Solverâ€™s evolutionary algorithm to solve it.
b. What is the optimalsolution?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

See More Books

Question Posted: Oct 22, 2012 06:34 AM

See More Questions

a. Create a spreadsheet model for this problem and solve it. What is the optimal solution? b. Of the constraints Tom placed on this problem, which are binding or preventing the objective function...
What is the maximum number of electrons in an atom that can have these quantum numbers? a. n = 4 b. n = 5, m = +1 c. n = 5, ms = + 1/2 d. n = 3, = 2 e. n = 2, = 1 f. n = 0, = 0, m = 0 g. n = 2, =...
What is the maximum number of electrons in an atom that can have the following quantum numbers? Specify the orbitals in which the electrons would be found. (a) n = 2, ms = + 1/2; (b) n = 4, m = 11;...
Data-2-Go manufactures and sells flash drives. The company produces only when it receives orders and, therefore, has no inventories. The following information is available for the current month:...
Use Gaussian Elimination to find the determinant of the following matrices: (a) (b) (c) (d) (e) (f) (g) (2 -3) 230 103 2 138 S-102 0 3-15 0 0-4 2 000 3 4059 102 2442 ]230 53251 43254 2100 21112 11252
Simplify the given expressions. Express results with positive exponents only. (aT 2 ) 30
Headspace is a mobile app that provides meditative and mindfulness lessons to people around the world. Founded in 2006 by Andy Puddi-combe, a former marketing executive and Buddhist monk, this firms...
The Polishing Department of Major Company has the following production and manufacturing cost data for September. Materials are entered at the beginning of the process. Production: Beginning...
1. Where cursor implementation can be used? 2. List down the applications of List. 3. What are the advantages of linked list? 4. Mention the demerits of linked list? 5. What are the operations...
1. In what ways did Blockbuster achieve better strategic fit than local stores? 2. How much implied uncertainty do Netflix and Redbox face? What levers do they use to deal with this uncertainty? 3....
Barbara Roberts recently received $30,000 as a small inheritance from a distant relative. She wants to invest the money so as to earn $900 to buy a notebook computer next year when she enters...
A small printing shop has ten jobs that it must schedule. The processing times and due dates for each job are summarized in the following table. a. Suppose the jobs are scheduled in ascending order...
Graph each function in the viewing window specified. Compare the graph to the one shown in the answer section of this text. Then use the graph to find (1.25). (x) = x 3 + 5x 2 - x - 5; window: [-6,...
Calculate the perihelion and aphelion velocities (km/s) of an object with an aphelion of 3.0 AU and perihelion of 1.0 AU.
SOLGO Based on the UML class diagram and specification given below, write a complete Java program conqa shivong s Shapes2D +calArea():double Shape -width: double -length: double ii. mush +setWidth()...
The income statement of Orange Company showed the following figures: Revenues Cost of Goods Sold Gross Margin Operating Expenses Operating Income Php750,000 250,000 500,000 200,000 300,000 Orange...
Preventing the need for social services as well as improving social services is a major goal of social workers. Social workers are on the front lines in a variety of social service entities, and many...
Tensile membrane structures represent an innovative and sustainable approach to architectural design, combining aesthetics with functionality. This case study focuses on the design and analysis of...
A capital growth process is well approximated by the Brownian motion with drift X t = u+ t +dw t from Section 2.3.2. The ruin probability for a certain choice of parameters occurs to be 1/16. How...
Derive Eq. (18.33) from Eq. (18.32).
When shortterm interest rates are very low, what is the slope of the yield curve? When shortterm rates are high? Why do these patterns exist?
Betsy Moore wants to invest in the stocks of companies A, B, C, and D, whose annual returns for the past thirteen years are as follows: a. Suppose that Betsy is completely risk-averse. What...
Sometimes, the historical data on returns and variances may be poor predictors of how investments will perform in the future. In this case, the scenario approach to portfolio optimization may be...
The Major Motors Corporation manufactures heavy trucks at a plant in Dublin, Virginia. The factorys stock of spare and custom parts is stored in a huge shelving system that is several stories high...
There are peer effects, but they differ for the two individuals, u_{1} = x_{1} - x_{1} ^ 2 + beta_{1}*x_{1}*x_{2} with B_{1} = 1 U_{2} = O - x_{2} ^ 2 + beta_{2}*x_{1}*x_{2} with B_{2} = 0 1) Find...
How do emerging technologies, such as AI and data analytics, impact the evolution of performance management practices ?
The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 38 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.26...

A mortgage company owns the following ten mortgages. Investors will purchase packages of mortgages worth at least

Question:

Mortgage 2 3 4 5 6 7 10 Amount (in $1000s) $900 $860 780 $525 $240 $185 $165 $164 $135 $125

Step by Step Answer:

a At least 1 M Mortgage Amount Group Group Amnt 1 yes 0 ...View the full answer

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

Students also viewed these Management Leadership questions