Question: Below are the Answer Report and Sensitivity Report for the Inside Traders Problem. Target Cell (Max) Cell Name $H$3 T. Interest= Original Value Final Value

Below are the Answer Report and Sensitivity Report for the Inside Traders Problem. Target Cell (Max) Cell Name $H$3 T. Interest= Original Value Final Value 0 0.51 Adjustable Cells Cell Name $B$2 Million $ Bonds $C$2 Million $ Stocks $D$2 Million $ Gold $E$2 Million $ Land Original Value Final Value 0 0 0 2 0 2 0 1 Constraints Cell Name $F$6 Funds Used $F$7 Bond&Stock Used $F$8 Real estate Used $B$2 Million $ Bonds $C$2 Million $ Stocks $D$2 Million $ Gold $E$2 Million $ Land Cell Value Formula Status 5 $F$6=5 Binding 2 $F$7>=$H$7 Binding 1 $F$8=0 Binding 2 $C$2>=0 Not Binding 2 $D$2>=0 Not Binding 1 $E$2>=0 Not Binding Slack 0 0 0 0 2 2 Below is the Sensitivity Report SILVI Adjustable Cells Cell Name $B$2 Million $ Bonds $C$2 Million $ Stocks $D$2 Million $ Gold $E$2 Million $ Land Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -0.005 0.085 0.005 1E+30 2 0 0.09 0.01 0.005 2 0 0.1 0.03 0.01 1 0 0.13 1E+30 0.03 Constraints Cell Name $F$6 Funds Used $F$7 Bond&Stock Used $F$8 Real estate Used Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 5 0.1 5 1E+30 2 2 -0.01 2 2 2 1 0.03 1 2 1 I investments are made which maximize the overall return on the $5 million, how many millions of dollars should be invested in Gold? Answer: Check If investments are made which maximize the overall return on the $5 million, how many millions of dollars should be invested in Gold? Answer: Check If Insider Trader were to invest an additional million dollars in the portfolio, what would be the expected return on that additional million dollars? Round answer to closest percent Answer: Check If Insider Traders only has to invest 1 million dollars in corporate bonds and common stock instead of 2 million, what would be the percent increase in the return on that million? ot Answer: Check 17 I before Insider Traders invests the return on corporate stocks increased from 9% to 11%, should Insider Traders shift its asset allocation? out of Select one: If before Insider Traders invests the return on corporate stocks increased from 9% to 11%, should Insider Traders shift its asset allocation? Select one: a no b. yes Check Insider Traders restriction on investing in real state was changed and Insider Traders was allowed to invest 2 million in real estate instead of 1 million, what would be the percent increase in the roturn on the portfolio? Answer: Check

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

If the profit per foot of pipe processed on touting 1 increased from $60 to $70, all other conditions remain the same, will this change the current optimal solution? Just answer yes or no. The plant...

If the profit per foot of pipe processed on touting 2 decreased from $80 to $70, all other conditions remain the same, will this change the current optimal solution? Just answer yes or no. The plant...

If you could sell melting capacity for $61 per hour, how many hours of melting capacity would you be willing to sell? The plant manager of a plastic pipe manufacturer has the opportunity to use two...

What is the maximum amount of money youd be willing to pay for an additional hour of Extruder B The plant manager of a plastic pipe manufacturer has the opportunity to use two different routings for...

The plant manager of a plastic pipe manufacturer has the opportunity to use two different routings for a particular type of plastic pipe. Routing 1 uses extruder A, and routing 2 uses extruder B....

In order to maximize profit, what should be the amount of piping produced on routing 1 and 2? The plant manager of a plastic pipe manufacturer has the opportunity to use two different routings for a...

The plant manager of a plastic pipe manufacturer has the opportunity to use two different routings for a particular type of plastic pipe. Routing 1 uses extruder A, and routing 2 uses extruder B....

Target Cell (Max) Cell Name $G$3 Total Profit= Original Value 450 Final Value 640 Adjustable Cells Cell Name $B$2 Units Skirt $C$2 Units Dress $D$2 Units Coat Original Value 0 0 15 Final Value 0 20...

Consider the following linear program, which maximizes profit for two products-pen (P) and notebook (N). You are producing these two items, pen and notebook. Your manufacturing environment has three...

Let X 1 and X 2 constitute a random sample from a normal population with 2 = 1. If the null hypothesis = 0 is to be rejected in favor of the alternative hypothesis = 1 > 0 when > 0 + 1, what...

Describe the shift that took place in Federal Reserve policy in 1979. Explain the reasons for this shift?

How should intangible assets be reported on the balance sheet? 1 ) As a reduction of stockholders equity 2 ) At cost in the current assets section 3 ) At the estimated market value at the balance...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...