Build a linear programming model to develop an investment portfolio that minimizes total risk under the above constraints. a) Define the decision making variables. b) Show the objective function. c) Show the constraints.
Q: Salalah Methanol company management is considering three competing investment Projects Option1:…
A: a) Payback period Declaration presentation cumulative cash flow Sohar
Q: Required: a. Solve the model formulated for Southern Sporting Goods Company using the computer. b.…
A: Linear programming is a method for determining the most optimal solution to a problem given…
Q: d. What is the rate of return for the portfolio? e. What is the dual value for the funds available…
A: (d) The rate of return is the annual income divided by the funds available. The final value for…
Q: Consider the following profit matrix 30 23 10 -3 a2 15 27 20 19 13 17 29 32 az 18 a4 31 21 13 No…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(a, b,…
Q: 11. The shadow price is calculated to be 5 for a less than or equal to constraint in a maximization…
A: Note:As per bartleyby guidelines i have answered first multiple choice question..pls post remainind…
Q: 1. Consider the following normal form game. a. Does either player have a dominant strategy? Explain.…
A: The given game has two players where each has four strategies. Strategies for player 1 are: A, B, C,…
Q: WHAT WLL HAPPEN IF THERE IS A CHANGE IS ONE OF THE OBJECTIVE FUNCTION COEFFICIENT? A. SLOPE OF THE…
A: Every change in the worth of a target work coefficient will lead to a changed optimal solution. When…
Q: (a) The CWD Brokerage firm has just been instructed that by one of its clients to invest $500,000…
A: Linear Programming model is as follows- Let, X1 = amount invested in Los Angeles Municipal Bonds X2…
Q: Q2. What is the optimal solution and what is the value of the objective function? Show the relevant…
A: As per your question we need to answer question number 2. For answering that I have provided the…
Q: a. How many decision variables will the linear programming model include? Number of decision…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: strategy that maximizes the department store chain's expected profit earned by purchasing and…
A: πij= Revenue from regular price +Revenue from closeoutprice-cost of purchase =…
Q: Q2. What is the optimal solution and what is the value of the objective function? Show the relevant…
A: Q2.To find the objective function value Let us define the objective function and decision variables…
Q: What special case in linear programming does the following graph depict? 10 X2 8 2 0 2x₁+x₂57 2 A)…
A: Ans) This graph has two constraints. 1 Constraint is less than type and other is greater than type.…
Q: An earthquake and a tsunami occurred, making it one of the most destructive and deadliest natural…
A: Natural hazard It is a natural occurrence, which hurts humans and other animals, or the environment.…
Q: Provide explanation and justification on the following: a. How to select the different functional…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: A company manufactures two products. If it charges price pi for product i, it can sell qi units of…
A: Given, q1 = 60 - 3p1 + p2 q2 = 80 - 2p2 + p1.
Q: Make a planning model for this question. A bank issues several financial products at the beginning…
A: Note: The model is planned based on several rough estimates. Values proposed are just for…
Q: The person says that 2173 is a prime number because it ends in the number 3, and since 3 is a prime…
A: No, 2173 is not a prime number. It is a multiplication of 41 and 53 which are two prime numbers. I…
Q: J&J has given you $12 million to spend on advertising Huggys diapers during the next 12 months.…
A: In the question, it's given that J&J has 12 million to spend on advertising during the next 12…
Q: A buyer for a large department store chain must place orders with an athletic shoe manufacturer six…
A: Given, Cost Price = $65 Selling Price = $85 Closeout sell price = $55 Demand (100s of pairs)…
Q: Suppose that the number of ounces of soda put into aPepsi can is normally distributed, with m 12.05…
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…
Q: Z = 2x1 + 10x2 b. Maximize Subject to Durability 10x1 + 4x2 ≥ 40 week Strength 1x1 + 6x2 = 24 psi…
A:
Q: The profits of the four major networks (CBS, NBC, ABC and Fox) depend significantly on the ratings…
A: 3. The nash equilibrium would be at when both having more prominent number of watchers…
Q: We have $1,000 to invest. All the money must be placedin one of three investments: gold, stock, or…
A:
Q: Drawthe budget constraint for a consumer with standard preferences.
A: For the First Part here is the solution: If the consumer had an income of $3,000 and the cost of…
Q: The price of each item in a store is nonnegative. The store manager is only interested in rules of…
A: According to the data mining, a monotonic function is either decreased or increased. But if any…
Q: Q2 An electronic company produces transistors, resistors, and computer chips. The material required…
A: Gauss-Seidel approach is an iterative process to answer a kit of linear equations & is very much…
Q: a) If he wants to maximize his profit, how many dozens of each kind should he bake if his profit for…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: 2(a) The tableau is not optimal for either maximization or a minimization problem. Thus, when a…
A: The given tableau - Basic x1 x2 x3 x4 x5 x6 x7 x8 Solution Z 0 -5 0 4 -1 -10 0 0 620 x8 0 3 0…
Q: a. How many decision variables are there? b. Give the names of the decision variables. c. How many…
A: There are three decision variables.
Q: Write the objective What is the objective function value at optimal point? Identify the sensitivity…
A: As per our policy we will be answering you the first three questions.Please post the remaining…
Q: Which of the following is true? a)The maximin criterion is an approach in Optimization under…
A: The Maximin criterion is an approach in optimization under uncertainty which finds a solution with…
Q: 1. An investment advisor at Shore Financial Services wants to develop a model that can be used to…
A: a) The optimal allocation of investment funds for a more aggressive client with risk O. 7
Q: A company has $10,000 to invest , to be divided into fixed interest, equities and property. For…
A: Here, the individual wants to make an investment decision. Let x = Amount invested in fixed interest…
Q: An investor is looking to invest R 250,000 with the intent of getting the highest possible return.…
A: Given data is Available amount to invest = R 250,000 Limit to invest in ASBA stock = less than or…
Q: What should be the production volume for that quarter?
A: Material requirement plan will helps the management to identify the timely ordering of items with…
Q: 21. The modeling technique to be employed in a situation involving a sequence of events with several…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: 2(a) The tableau is not optimal for either maximization or a minimization problem. Thus, when a…
A: The given tableau- Basic X1 X2 X3 X4 X5 X6 X7 X8 Solution Z 0 -5 0 4 -1 -10 0 0 620 X8 0 3 0…
Q: 10
A: The option (c ) represents the correct graphical solution. As the feasible area is bound by the…
Q: The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising…
A: Let y & be the sum spent on Paper Ad & Radio ad individually.
Q: An investment company manages portfolios of stocks, bonds, and other investment alternatives. One of…
A: AS PART ONE IS ALREADY SOLVED. I AM JUMPING DIRECTLY TO QUESTION 2. Now we solve the above problem…
Q: Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price…
A: Consider creating a $10 rebate for a $45 product. Alternatives to a rebate would be to reduce the…
Q: نن فم a. - Identify and describe the decision variables for this LP problem. -Mathematically state…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management…
A: Compose all the given information as information factors in blue cells. The screen capture is given…
Q: 1. A specific assignment of values to decision variables is called what? a. Constraint…
A: Decision Variables: These are the unknown quantities that the LPP solution is supposed to estimate…
Q: 6. Given a linear programming model: Маx 4x1 + 6x2 X1+ 2x2 0 Which of the following statement is…
A:
Q: 1. The marketing concept states that a firm must put consumer needs first, even if it means…
A: The first three questions are answered below. Kindly post the other questions separately.
Q: • Which cells contain the decision variable quantities? • Which cells contain the unit costs for…
A: Which cells contain the decision variable quantities? Cells ranging from B10 to D10 contain the…
Q: The LP relationships that follow were formulated by Richard Martin at the Long Beach Chemical…
A: Given that: Maximize 4X1+12X1X2+5X3 Subject to: 2X1X2+2X3≤70 (C1) 10.9X1−4X2≥15.6 (C2)…
Q1. Build a linear programming model to develop an investment portfolio that minimizes total risk under the above constraints.
- a) Define the decision making variables.
- b) Show the objective function.
- c) Show the constraints.
Q2. What is the optimal solution and what is the value of the objective function? Show the relevant portion of the Solver’s output. Fully interpret the results.
Q3. What are the objective coefficient ranges for the four stocks? Show the relevant portion of the Solver’s output. Fully interpret these ranges.
Q4. Suppose the investor decides that the annual
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
- When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
- You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)Suppose you begin year 1 with 5000. At the beginning of each year, you put half of your money under a mattress and invest the other half in Whitewater stock. During each year, there is a 40% chance that the Whitewater stock will double, and there is a 60% chance that you will lose half of your investment. To illustrate, if the stock doubles during the first year, you will have 3750 under the mattress and 3750 invested in Whitewater during year 2. You want to estimate your annual return over a 30-year period. If you end with F dollars, your annual return is (F/5000)1/30 1. For example, if you end with 100,000, your annual return is 201/30 1 = 0.105, or 10.5%. Run 1000 replications of an appropriate simulation. Based on the results, you can be 95% certain that your annual return will be between which two values?The stocks in Example 7.9 are all positively correlated. What happens when they are negatively correlated? Answer for each of the following scenarios. In each case, two of the three correlations are the negatives of their original values. Discuss the differences between the optimal portfolios in these three scenarios. a. Change the signs of the correlations between stocks 1 and 2 and between stocks 1 and 3. (Here, stock 1 tends to go in a different direction from stocks 2 and 3.) b. Change the signs of the correlations between stocks 1 and 2 and between stocks 2 and 3. (Here, stock 2 tends to go in a different direction from stocks 1 and 3.) c. Change the signs of the correlations between stocks 1 and 3 and between stocks 2 and 3. (Here, stock 3 tends to go in a different direction from stocks 1 and 2.) EXAMPLE 7.9 PORTFOLIO SELECTION AT PERLMAN BROTHERS Perlman Brothers, an investment company, intends to invest a given amount of money in three stocks. From past data, the means and standard deviations of annual returns have been estimated as shown in Table 7.2. The correlations among the annual returns on the stocks are listed in Table 7.3. The company wants to find a minimum-variance portfolio that yields a mean annual return of at least 0.12.