Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

Annabelle Invests in the Market

Annabelle Sizemore has cashed in some treasury bonds and a life insurance policy that her parents had accumulated over the years for her. She has also saved some money in certificates of deposit and savings bonds during the 10 years since she graduated from college. As a result, she has $120,000 available to invest. Given the recent rise in the stock market, she feels that she should invest all of this amount there. She has researched the market and has decided that she wants to invest in an index fund tied to S&P stocks and in an Internet stock fund. However, she is very concerned about the volatility of Internet stocks. Therefore, she wants to balance her risk to some degree.

She has decided to select an index fund from Shield Securities and an Internet stock fund from Madison Funds, Inc. She has also decided that the proportion of the dollar amount she invests in the index fund relative to the Internet fund should be at least one-third but that she should not invest more than twice the amount in the Internet fund that she invests in the index fund. The price per share of the index fund is $175, whereas the price per share of the Internet fund is $208. The average annual return during the last 3 years for the index fund has been 17%, and for the Internet stock fund it has been 28%. She anticipates that both mutual funds will realize the same average returns for the coming year that they have in the recent past; however, at the end of the year she is likely to reevaluate her investment strategy anyway. Thus, she wants to develop an investment strategy that will maximize her return for the coming year.

Formulate a linear programming model for Annabelle that will indicate how much money she should invest in each fund, and solve this model by using the graphical method.

Suppose Annabelle decides to change her risk balancing formula by eliminating the restriction that the proportion of the amount she invests in the index fund to the amount that she invests in the Internet fund must be at least one-third. What will the effect be on her solution? Suppose instead that she eliminates the restriction that the proportion of money she invests in the Internet fund relative to the stock fund not exceed a ratio of 2 to 1. How will this affect her solution?

If Annabelle can get $1 more to invest, how will that affect her solution? $2 more? $3 more? What can you say about her return on her investment strategy, given these successive changes?

For this case problem Annabelle Invests in the Market, perform the following:
(Label the last 4 paragraphs of this case problems as Task A, Task B, Task C, Tasks D1,
D2, D3, and Task E.)
Task A. Formulate a linear programming model using the 4-step procedure presented.
Solve the linear programming model.
Create an electronic file of the following output for your solution:
Linear Programming Results
Ranging
Solution list
Task B. Modify the linear programming model created in Task A, solve the linear programming
model, and answer the question.
Task C. Modify the linear programming model created in Task A, solve the linear programming
model, and answer the question
Task D1. Modify the linear programming model created in Task A, solve the linear
programming model and answer the question.
Task D2. Modify the linear programming model created in Task A, solve the linear
programming model and answer the question.
Task D3. Modify the linear programming model created in Task A, solve the linear
programming model and answer the question.
Task E. Perform the analysis and answer the question.
expand button
Transcribed Image Text:For this case problem Annabelle Invests in the Market, perform the following: (Label the last 4 paragraphs of this case problems as Task A, Task B, Task C, Tasks D1, D2, D3, and Task E.) Task A. Formulate a linear programming model using the 4-step procedure presented. Solve the linear programming model. Create an electronic file of the following output for your solution: Linear Programming Results Ranging Solution list Task B. Modify the linear programming model created in Task A, solve the linear programming model, and answer the question. Task C. Modify the linear programming model created in Task A, solve the linear programming model, and answer the question Task D1. Modify the linear programming model created in Task A, solve the linear programming model and answer the question. Task D2. Modify the linear programming model created in Task A, solve the linear programming model and answer the question. Task D3. Modify the linear programming model created in Task A, solve the linear programming model and answer the question. Task E. Perform the analysis and answer the question.
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education