Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 1C
Summary Introduction
To provide: The relevant information for the questions.
Case summary:
Company E is a large energy company. The diverse nature of the company is always keeping the manager of project development Person CE. Person CE is currently about to meet the relevant parties regarding the different proposals present for the next three years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use excel for this problem
A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return.
Bond
Annual Return
Maturity
Risk
Tax
Free
A
9.5%
Long
High
Yes
B
8.0%
Short
Low
Yes
C
9.0%
Long
Low
No
D
9.0%
Long
High
Yes
E
9.0%
Short
High
No
The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues. At least 25% of the funds should go in tax-free investments, and at least 45% of the total annual return should be tax free.
Formulate the LP model for this problem.
Create the spreadsheet model and use Solver to solve the problem.
Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of clients. A particular portfolio consists of U shares of U.S. Oil and H shares of Huber Steel. The annual return for U.S. Oil is $3 per share and the annual return for Huber Steel is $5 per share. U.S. Oil sells for $25 per share and Huber Steel sells for $50 per share. The portfolio has $80,000 to be invested. The portfolio risk index (0.50 per share of U.S. Oil and 0.25 per share for Huber Steel) has a maximum of 700. In addition, the portfolio is limited to a maximum of 1000 shares of U.S. Oil. The linear programming formulation that will maximize the total annual return of the portfolio is as follows:
Max 3U + 5H Maximize total annual return
s.t.
25U + 50H <= 80,000 Funds available
0.5U + 0.25H <= 700 Risk maximum
1U <= 1000 U.S. oil Maximum
U, H >= 0
The computer solution is shown in…
“Good Intentions” (GI) company produces two products, which it sells on both a cash and credit basis. Revenues from credit sales will not have been received but are included in determining profit earned during the current six-month period. Sales during the next six months can be made either from units produced during the next six months or from the beginning inventory. Relevant information about products one and two is as follows.
During the next six months, at most 150 units of product type 1 can be sold on a cash basis, and at most 100 units of product 1 can be sold on a credit basis. It costs £35 to produce each unit of product type 1, and each sells for £40. A credit sale of a unit of product 1 yields £0.50 less profit than a cash sale (because of delays in receiving payment). Two hours of production time are needed to produce each unit of product 1. At the beginning of the six-month period, 60 units of product 1 are in the inventory.
During the next six months, at most 175 units…
Chapter 2 Solutions
Practical Management Science
Ch. 2.4 - Prob. 1PCh. 2.4 - Prob. 2PCh. 2.4 - Prob. 3PCh. 2.4 - Prob. 4PCh. 2.5 - Prob. 5PCh. 2.5 - Prob. 6PCh. 2.5 - Prob. 7PCh. 2.5 - Prob. 8PCh. 2.5 - Prob. 9PCh. 2.6 - Prob. 10P
Ch. 2.6 - Prob. 11PCh. 2.6 - Prob. 12PCh. 2.6 - Prob. 13PCh. 2.7 - Prob. 14PCh. 2.7 - Prob. 15PCh. 2.7 - Prob. 16PCh. 2.7 - Prob. 17PCh. 2.7 - Prob. 18PCh. 2.7 - Prob. 19PCh. 2 - Julie James is opening a lemonade stand. She...Ch. 2 - Prob. 21PCh. 2 - Prob. 22PCh. 2 - Prob. 23PCh. 2 - Prob. 24PCh. 2 - Prob. 25PCh. 2 - The file P02_26.xlsx lists sales (in millions of...Ch. 2 - Prob. 27PCh. 2 - The file P02_28.xlsx gives the annual sales for...Ch. 2 - Prob. 29PCh. 2 - A company manufacturers a product in the United...Ch. 2 - Prob. 31PCh. 2 - Prob. 32PCh. 2 - Assume the demand for a companys drug Wozac during...Ch. 2 - Prob. 34PCh. 2 - Prob. 35PCh. 2 - Prob. 36PCh. 2 - Prob. 37PCh. 2 - Suppose you are borrowing 25,000 and making...Ch. 2 - You are thinking of starting Peaco, which will...Ch. 2 - Prob. 40PCh. 2 - The file P02_41.xlsx contains the cumulative...Ch. 2 - Prob. 42PCh. 2 - Prob. 43PCh. 2 - The IRR is the discount rate r that makes a...Ch. 2 - A project does not necessarily have a unique IRR....Ch. 2 - Prob. 46PCh. 2 - Prob. 1CCh. 2 - The eTech Company is a fairly recent entry in the...
Knowledge Booster
Similar questions
- 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?arrow_forwardSuppose 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?arrow_forwardWhere a financial institution makes a loan commitment, the borrower, in drawing down on their loan commitment, causes increased cash flow needs by the DI to fund the loan commitments. There are three ways a DI can offset the effect of Asset-side liquidity risk such as drawing down of a loan commitment in all of the following sitiuations Except: a. Reduce excess cash reserves to minimum levels required to meet reserve requirements based on the decision made by management independant of regulatory requirements. b. Reduce balance sheet items such as retain earnings to the meet the minimum required capital levels. c. Taking offsetting measures such as borrowing funds or even purchasing funds on the money market. d. Reducing liquid type assets on their balance sheet such at T-bills by selling them.arrow_forward
- The purchased and installation costs of some pieces of equipment are given as a function of weight rather than capacity. An example of this is the installed costs of large tanks. The 1980 cost for an installed aluminum tank weighing 100,000 lb was $390,000. For a size range from 200,000 to 1,000,000 lb, the installed cost-weight exponent for aluminum tanks is 0.93. If an aluminum tank weighing 700,000 lb is required, what is capital investment needed in 2002? Notice: If you can't find exponent (x), you can use the value 0.6arrow_forwardYou are the finance manager of the firm Sunderland Plastics Limited, which produces two products (X1 and X2) using two different machines (M1 and M2). Each unit of X1 requires 4 hours of processing time on M1 and 2 hours of processing time on M2. Each unit of X2 that gets produced requires a 1 hour processing time on M1 and 1.5-hour processing time on M2.The firm has an available processing time of 40 hours of M1 and 30 hours of M2 available this week. The firm also meets the non-negativity constraints. Your task is the following:The firms makes a net profit of 400 USD from 1 unit of product X1 and 100 USD from 1 unit of product X21) Formulate a linear programming problem in the standard form for Sunderland Plastics Limited.2) Solve the problem graphically and show what combination of the products X1 and X2 the firm should produce to maximise its profit while satisfying the constraints it is facing. How much profit will the firm make?arrow_forwardBilbo Baggins wants to save money to meet threeobjectives. First, he would like to be able to retire 30 years from now with a retirementincome of $23,000 per month for 20 years, with the first payment received 30 yearsand 1 month from now. Second, he would like to purchase a cabin in Rivendell in10 years at an estimated cost of $320,000. Third, after he passes on at the end of the20 years of withdrawals, he would like to leave an inheritance of $1,000,000 to hisnephew Frodo. He can afford to save $2,100 per month for the next 10 years. If hecan earn an 11 percent EAR before he retires and an 8 percent EAR after he retires,how much will he have to save each month in Years 11 through 30?arrow_forward
- Show cells in excel with step by step using solver and the sum product function show how to calculate weighted risk Wall Street firms commonly use linear programming models to select their bond portfolios. A firm is considering the following 5 bonds: Bond Annual Return rate (%) Risk measure Bond 9.2 5 Bond 5 3 Bond 6.1 2 Bond 3.5 4 Bond 1.2 1 In the table above, “risk measure” has a value between 1 and 5 with 5 indicating the riskiest bond and 1 the least risky bond. The firm has a budget of 1 million dollars for this investment. The firm wants to decide its investments in the 5 bonds to maximize the expected return of the portfolio, subject to constraints listed below: The weighted average risk of the portfolio should not exceed 4. At least 30% of the total investment can be invested in bond 3. To diversify the portfolio, the investment on each bond should be at least 10% of the total investment. The sum of investments made in…arrow_forwardI need help with everything, please. Formulate the problem and submit formulation - no need to solve. 1. An investment advisor at Shore Financial Services wants to develop a model that can be used to allocate investment funds among four alternatives: stocks, bonds, mutual funds, and cash. For the coming investment period, the company developed estimates of the annual rate of return and the associated risk for each alternative. Risk is measured using an index between 0 and 1, with higher risk values denoting more volatility and thus more uncertainty. Because cash is held in a money market fund, the annual return is lower, but it carries essentially no risk. The objective is to determine the portion of funds allocated to each investment alternative in order to maximize the total annual return for the portfolio subject to the risk level the client is willing to tolerate. Total risk is the sum of the risk for all investment alternatives. For instance, if 40% of a client’s funds are…arrow_forwardThe original campaign cost for the last quarter of December 31, 2023 was $ 1,448.395. However, for the upcoming campaign for the first quarter of March 31, 2024, the CFO is only recommending a total Budget max of $1,000 for the 15 campaigns listed in the Historical data due to recent additional expenses.Thus, the objective is to maximize the recommended Budget of $1,000, using Excel Solver, allocating $ 62.000 to each campaign to determine the Optimal Budget and make arelevant buiness decision for how the remaining budget is allocated. Also, what effect does the Budget have on the overall clicks and Conversions result?arrow_forward
- Dataware is trying to determine whether to give a $10 rebate, cut the price $6, or have no price change on a software product. Currently, 40,000 units of the product are sold each week for $45 apiece. The variable cost of the product is $5. The most likely case appears to be that a $10 rebate will increase sales 30%, and half of all people will claim the rebate. For the price cut, the most likely case is that sales will increase 20%.a. Given all other assumptions, what increase in sales from the rebate would make the rebate and price cut equally desirable?b. Dataware does not really know the increase in sales that will result from a rebate or price cut. However, the company is sure that the rebate will increase sales by between 15% and 40% and that the price cut will increase sales by between 10% and 30%. Perform a sensitivity analysis (two-way data table) that could be used to help determine Dataware’s best decision.arrow_forwardJJ is the financial manager in charge of the company pension fund at Arm Inc. JJ knows that the fund must be sufficient to make the payments listed in Table. Each payment must be made on the first day of each year. JJ is going to finance these payments by purchasing bonds. It is currently January 1 of year 1, and three bonds are available for immediate purchase. The prices and coupons for the bonds are as follows. (We assume that all coupon payments are received on January 1 and arrive in time to meet cash demands for the year on which they arrive.) ■ Bond 1 costs $980 and yields a $60 coupon in the years 2 through 5 and a $1060 payment on maturity in the year 6.■ Bond 2 costs $970 and yields a $65 coupon in the years 2 through 11 and a $1065 payment on maturity in the year 12.■ Bond 3 costs $1050 and yields a $75 coupon in the years 2 through 14 and a $1075payment on maturity in the year 15.JJ must decide how much cash to allocate (from company coffers) to meet the initial $11,000…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,