Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis' risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specified that at least $300,000 be invested in the money market fund. Refer to the computer solution shown below. Optimal Objective Value - 62000.00000 Variable S M Constraint 1 2 3 Variable S M Constraint 1 2 3 Value Reduced Cost 0.00000 0.00000 4000.00000 10000.00000 Slack/Surplus 0.00000 0.00000 7000.00000 Objective Allowable Allowable Coefficient Increase Decrease Infinite 4.25000 3.40000 Infinite 8.00000 3.00000 RHS Value Dual Value -0.05667 2.16667 0.00000 1200000.00000 60000.00000 3000.00000 Allowable Increase Allowable Decrease 300000.00000 420000.00000 42000.00000 12000.00000 7000.00000 Infinite

Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis' risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specified that at least $300,000 be invested in the money market fund. Refer to the computer solution shown below. Optimal Objective Value - 62000.00000 Variable S M Constraint 1 2 3 Variable S M Constraint 1 2 3 Value Reduced Cost 0.00000 0.00000 4000.00000 10000.00000 Slack/Surplus 0.00000 0.00000 7000.00000 Objective Allowable Allowable Coefficient Increase Decrease Infinite 4.25000 3.40000 Infinite 8.00000 3.00000 RHS Value Dual Value -0.05667 2.16667 0.00000 1200000.00000 60000.00000 3000.00000 Allowable Increase Allowable Decrease 300000.00000 420000.00000 42000.00000 12000.00000 7000.00000 Infinite

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
100%
Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis' risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specified that at least $300,000 be invested in the money market fund. Refer to the computer solution shown below. Optimal Objective Value = 62000.00000 Variable S M Constraint 1 2 3 Variable S M Constraint 1 IN 3 2 Value 4000.00000 10000.00000 Reduced Cost 0.00000 0.00000 Slack/Surplus 0.00000 0.00000 7000.00000 8.00000 3.00000 Objective Allowable Coefficient Increase Infinite 3.40000 RHS Value Dual Value -0.05667 2.16667 0.00000 1200000.00000 60000.00000 3000.00000 Allowable Decrease 4.25000 Infinite Allowable Increase 300000.00000 42000.00000 7000.00000 Allowable Decrease 420000.00000 12000.00000 Infinite
Transcribed Image Text:Innis Investments manages funds for a number of companies and wealthy clients. The investment strategy is tailored to each client's needs. For a new client, Innis has been authorized to invest up to $1.2 million in two investment funds: a stock fund and a money market fund. Each unit of the stock fund costs $50 and provides an annual rate of return of 10%; each unit of the money market fund costs $100 and provides an annual rate of return of 4%. The client wants to minimize risk subject to the requirement that the annual income from the investment be at least $60,000. According to Innis' risk measurement system, each unit invested in the stock fund has a risk index of 8, and each unit invested in the money market fund has a risk index of 3. The higher risk index associated with the stock fund simply indicates that it is the riskier investment. Innis's client also specified that at least $300,000 be invested in the money market fund. Refer to the computer solution shown below. Optimal Objective Value = 62000.00000 Variable S M Constraint 1 2 3 Variable S M Constraint 1 IN 3 2 Value 4000.00000 10000.00000 Reduced Cost 0.00000 0.00000 Slack/Surplus 0.00000 0.00000 7000.00000 8.00000 3.00000 Objective Allowable Coefficient Increase Infinite 3.40000 RHS Value Dual Value -0.05667 2.16667 0.00000 1200000.00000 60000.00000 3000.00000 Allowable Decrease 4.25000 Infinite Allowable Increase 300000.00000 42000.00000 7000.00000 Allowable Decrease 420000.00000 12000.00000 Infinite
(a) Suppose the risk index for the stock fund (the value of C) increases from its current value of 8 to 10. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change. (b) Suppose the risk index for the money market fund (the value of CM) increases from its current value of 3 to 4.5. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change. (c) Suppose C increases to 10 and CM increases to 4.5. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change.
Transcribed Image Text:(a) Suppose the risk index for the stock fund (the value of C) increases from its current value of 8 to 10. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change. (b) Suppose the risk index for the money market fund (the value of CM) increases from its current value of 3 to 4.5. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change. (c) Suppose C increases to 10 and CM increases to 4.5. How does the optimal solution change, if at all? The optimal solution becomes (9600, 3000). The optimal solution does not change.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS