Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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

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

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
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
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
steps

Step by step

Solved in 4 steps with 6 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