You have been tasked with reviewing Investment Report 2. Can you please let us know what the new return would be if the maximum possible investment in Banking Funds decreased by $10,000? Please use the Investments Output to answer this question. O $40,000 O $24,145 O $207.50 O $23,730 O None of the above
You have been tasked with reviewing Investment Report 2. Can you please let us know what the new return would be if the maximum possible investment in Banking Funds decreased by $10,000? Please use the Investments Output to answer this question. O $40,000 O $24,145 O $207.50 O $23,730 O None of the above
Foundations of Business - Standalone book (MindTap Course List)
4th Edition
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Chapter15: Using Management And Accounting Information
Section: Chapter Questions
Problem 5DQ
Related questions
Question
E1
![Parameters
Stocks
Agriculture
Health Care
Banking
Manufacturing
Real Estate
Model
Agriculture
Health Care
Banking
Manufacturing
Real Estate
Total Investment
$
$
100% +
Investment Report 2
Max Total Return S
2/3
Return
11%
6%
9%
12%
9%
Minimum Investment Funds Invested Maximum Investment
$ 100,000.00 $
100,000.00
S
$
5,000.00
$ 50,000.00 $
$ 22,500.00 $
50,000.00
22,500.00
10,000.00 $ 67,500.00
23,937.50
0
$ 240,000.00 $
MacRosli D
&
Variable Cells
Name
Cell
11 Apriuture Funds Invested
SCSS Health Care Funds invested
18 Banking Funds Invested
3017 Manfacturing Funds invested
SCS18 Real Estate Funds invested
Constraints
Cell
Name
50514 Agriculture Funds Invested
3515 Health Care Funds Invested
1514 Fanking Funds Invested
17 Manufacturing Funds invested
SS18 Real Estate Funds Invested
S319 Total investment Funds invested
240,000.00
Let X₁
X₂
Final
Value
100000
0000525
0
0
O
10000
22500
67500
Final
Value
$100,000.00
$0.00
$50,000.00
$27,500.00
147.500.00
$240,000.00
Reduced Objective
Coefficient
Cost
18-30
011
0
0.00925
0.06
1+30
0.09
0.12 0020555556
Shadow Constraint
Price
0025
0
002075
0.015
0
Does
Allowable
Increase
0085 0014310345 0.00637931
240000
Allowable
Increase
RH. Side
O
0
0 34048.4848S
0
0
X4≤100000
X₂ ≤ 50000
X3 ≤ 50000
X4 ≤0.45(X₂ +X3)
X5≥0.20(X₂ + X3)
X1, X2, X3, X4, X5 20
57500
16.30
$7500
$7500
1+30
amount invested in Agriculture
amount invested in Health Care
Allowable
Decrease
Xs amount invested in Real Estate
=
X3- amount invested in Banking
X4 amount invested in Manufacturing
-
0.025
10+30
002075
0.015
Allowable
Decrease
100000
5000
50000
22500
1E+30
57500
Max: 0.11X₁ +0.065X₂ +0.09X3 +0.12X4+0.085)
s.t.
X₁ + X₂ + X3 + X₁ + Xs=240,000
X₁ ≤ 100000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fea36a997-e774-4130-9a2a-0861d0514ec2%2F38d28790-4fe7-4abb-86ef-1529b2ac07d1%2Fgopj11j_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Parameters
Stocks
Agriculture
Health Care
Banking
Manufacturing
Real Estate
Model
Agriculture
Health Care
Banking
Manufacturing
Real Estate
Total Investment
$
$
100% +
Investment Report 2
Max Total Return S
2/3
Return
11%
6%
9%
12%
9%
Minimum Investment Funds Invested Maximum Investment
$ 100,000.00 $
100,000.00
S
$
5,000.00
$ 50,000.00 $
$ 22,500.00 $
50,000.00
22,500.00
10,000.00 $ 67,500.00
23,937.50
0
$ 240,000.00 $
MacRosli D
&
Variable Cells
Name
Cell
11 Apriuture Funds Invested
SCSS Health Care Funds invested
18 Banking Funds Invested
3017 Manfacturing Funds invested
SCS18 Real Estate Funds invested
Constraints
Cell
Name
50514 Agriculture Funds Invested
3515 Health Care Funds Invested
1514 Fanking Funds Invested
17 Manufacturing Funds invested
SS18 Real Estate Funds Invested
S319 Total investment Funds invested
240,000.00
Let X₁
X₂
Final
Value
100000
0000525
0
0
O
10000
22500
67500
Final
Value
$100,000.00
$0.00
$50,000.00
$27,500.00
147.500.00
$240,000.00
Reduced Objective
Coefficient
Cost
18-30
011
0
0.00925
0.06
1+30
0.09
0.12 0020555556
Shadow Constraint
Price
0025
0
002075
0.015
0
Does
Allowable
Increase
0085 0014310345 0.00637931
240000
Allowable
Increase
RH. Side
O
0
0 34048.4848S
0
0
X4≤100000
X₂ ≤ 50000
X3 ≤ 50000
X4 ≤0.45(X₂ +X3)
X5≥0.20(X₂ + X3)
X1, X2, X3, X4, X5 20
57500
16.30
$7500
$7500
1+30
amount invested in Agriculture
amount invested in Health Care
Allowable
Decrease
Xs amount invested in Real Estate
=
X3- amount invested in Banking
X4 amount invested in Manufacturing
-
0.025
10+30
002075
0.015
Allowable
Decrease
100000
5000
50000
22500
1E+30
57500
Max: 0.11X₁ +0.065X₂ +0.09X3 +0.12X4+0.085)
s.t.
X₁ + X₂ + X3 + X₁ + Xs=240,000
X₁ ≤ 100000
![You have been tasked with reviewing Investment Report 2. Can you please let us know what the new return would be if the maximum possible investment in
Banking Funds decreased by $10,000? Please use the Investments Output to answer this question.
O $40,000
$24,145
O $207.50
$23,730
None of the above](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fea36a997-e774-4130-9a2a-0861d0514ec2%2F38d28790-4fe7-4abb-86ef-1529b2ac07d1%2Fdaypej_processed.jpeg&w=3840&q=75)
Transcribed Image Text:You have been tasked with reviewing Investment Report 2. Can you please let us know what the new return would be if the maximum possible investment in
Banking Funds decreased by $10,000? Please use the Investments Output to answer this question.
O $40,000
$24,145
O $207.50
$23,730
None of the above
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Foundations of Business - Standalone book (MindTa…](https://www.bartleby.com/isbn_cover_images/9781285193946/9781285193946_smallCoverImage.gif)
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
![Foundations of Business - Standalone book (MindTa…](https://www.bartleby.com/isbn_cover_images/9781285193946/9781285193946_smallCoverImage.gif)
Foundations of Business - Standalone book (MindTa…
Marketing
ISBN:
9781285193946
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
![Foundations of Business (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337386920/9781337386920_smallCoverImage.gif)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning