Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4.7, Problem 30P
Summary Introduction
To run: A one-way sensitivity analysis on
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Where 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.
Warren Buffy is an enormously wealthy investor who has built his fortune through his legendary busimen acumen. He currently has been offered three major investments and would like to choose one. The first one is a conservative investment that would perform well in an improving economy and only suffer a small loss in a worsening economy. The second is a speculative investment that would perform extremely well in an improving economy but would do very badly in a worsening economy. The third is a countercyclical investment that would lose some money in an improving economy but would perform well in a worsening economy. The respective payoffs (millions) and the associated probabilities as shown in the Table below.
Decision
alternatives Improving Stable Worsening
Conservative 30.00 5.00 -8.00
Speculative 40.00 10.50 -30.00
Countercyclical -5.0…
Bruin Properties is in escrow to buy a 175,000 square foot shopping center in Camarillo, California for $35,000,000. Bruin Properties can borrow $24,000,000 fixed rate fully amortizing over 30 years at a 6.0% annual interest rate with equal monthly payments of principal and interest or it can borrow $28,000,000 fixed rate fully amortizing over 30 years at a 7.0% annual interest rate with equal monthly payments of principal and interest. What is the incremental annual borrowing cost for the additional $4,000,000 loan amount if each loan would be outstanding for the full 30 year term?
a.13.0%
b.12.4%
c.11.5%
d. 7.0%
Chapter 4 Solutions
Practical Management Science, Loose-leaf Version
Ch. 4.2 - Prob. 1PCh. 4.2 - Prob. 2PCh. 4.2 - Prob. 3PCh. 4.2 - Prob. 4PCh. 4.2 - Prob. 5PCh. 4.2 - Prob. 6PCh. 4.3 - Prob. 7PCh. 4.3 - Prob. 8PCh. 4.3 - Prob. 9PCh. 4.3 - Prob. 10P
Ch. 4.3 - Prob. 11PCh. 4.3 - Prob. 12PCh. 4.4 - Prob. 13PCh. 4.4 - Prob. 14PCh. 4.4 - Prob. 15PCh. 4.4 - Prob. 16PCh. 4.4 - Prob. 17PCh. 4.4 - Prob. 18PCh. 4.4 - Prob. 19PCh. 4.5 - Prob. 20PCh. 4.5 - Prob. 21PCh. 4.5 - Prob. 22PCh. 4.5 - Prob. 23PCh. 4.5 - Prob. 24PCh. 4.5 - Prob. 25PCh. 4.6 - Prob. 26PCh. 4.6 - Prob. 27PCh. 4.6 - Prob. 28PCh. 4.6 - Prob. 29PCh. 4.7 - Prob. 30PCh. 4.7 - Prob. 31PCh. 4.7 - Prob. 32PCh. 4.7 - Prob. 33PCh. 4.7 - Prob. 34PCh. 4.7 - Prob. 35PCh. 4.7 - Prob. 36PCh. 4.7 - Prob. 37PCh. 4.7 - Prob. 38PCh. 4.7 - Prob. 39PCh. 4.7 - Prob. 40PCh. 4.8 - Prob. 41PCh. 4.8 - Prob. 42PCh. 4.8 - Prob. 43PCh. 4.8 - Prob. 44PCh. 4 - Prob. 45PCh. 4 - Prob. 46PCh. 4 - Prob. 47PCh. 4 - Prob. 48PCh. 4 - Prob. 49PCh. 4 - Prob. 50PCh. 4 - Prob. 51PCh. 4 - Prob. 52PCh. 4 - Prob. 53PCh. 4 - Prob. 54PCh. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Prob. 58PCh. 4 - Prob. 59PCh. 4 - Prob. 60PCh. 4 - Prob. 61PCh. 4 - Prob. 62PCh. 4 - Prob. 63PCh. 4 - Prob. 64PCh. 4 - Prob. 65PCh. 4 - Prob. 66PCh. 4 - Prob. 67PCh. 4 - Prob. 68PCh. 4 - Prob. 69PCh. 4 - Prob. 70PCh. 4 - Prob. 71PCh. 4 - Prob. 72PCh. 4 - Prob. 73PCh. 4 - Prob. 74PCh. 4 - Prob. 75PCh. 4 - Prob. 76PCh. 4 - Prob. 77PCh. 4 - Prob. 78PCh. 4 - Prob. 79PCh. 4 - Prob. 80PCh. 4 - Prob. 81PCh. 4 - Prob. 82PCh. 4 - Prob. 83PCh. 4 - Prob. 84PCh. 4 - Prob. 85PCh. 4 - Prob. 86PCh. 4 - Prob. 87PCh. 4 - Prob. 88PCh. 4 - Prob. 89PCh. 4 - Prob. 90PCh. 4 - Prob. 91PCh. 4 - Prob. 92PCh. 4 - Prob. 93PCh. 4 - Prob. 94PCh. 4 - Prob. 95PCh. 4 - Prob. 96PCh. 4 - Prob. 97PCh. 4 - Prob. 98PCh. 4 - Prob. 99PCh. 4 - Prob. 100PCh. 4 - Prob. 101PCh. 4 - Prob. 102PCh. 4 - Prob. 103PCh. 4 - Prob. 104PCh. 4 - Prob. 105PCh. 4 - Prob. 106PCh. 4 - Prob. 107PCh. 4 - Prob. 108PCh. 4 - Prob. 109PCh. 4 - Prob. 110PCh. 4 - Prob. 111PCh. 4 - Prob. 112PCh. 4 - Prob. 113PCh. 4 - Prob. 114PCh. 4 - Prob. 115PCh. 4 - Prob. 116PCh. 4 - Prob. 117PCh. 4 - Prob. 118PCh. 4 - Prob. 119PCh. 4 - Prob. 120PCh. 4 - Prob. 121PCh. 4 - Prob. 122PCh. 4 - Prob. 123PCh. 4 - Prob. 124PCh. 4 - Prob. 125PCh. 4 - Prob. 126PCh. 4 - Prob. 127PCh. 4 - Prob. 128PCh. 4 - Prob. 129PCh. 4 - Prob. 130PCh. 4 - Prob. 131PCh. 4 - Prob. 132PCh. 4 - Prob. 133PCh. 4 - Prob. 134PCh. 4 - Prob. 135P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- 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?arrow_forwardSuppose 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_forwardIn August of the current year, a car dealer is trying to determine how many cars of the next model year to order. Each car ordered in August costs 20,000. The demand for the dealers next year models has the probability distribution shown in the file P10_12.xlsx. Each car sells for 25,000. If demand for next years cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of 22,000 per car. Excess cars can be disposed of at 17,000 per car. Use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the expected profit.arrow_forward
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardA project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)arrow_forwardThere are three investments, B1, B2 and B3. All of them have the same expected value and each with two possible payoffs. The payoffs from investment B1 are independent from payoffs from B2 and B3. The payoffs from B2 and B3 are perfectly negatively correlated, which means that when B2 has a high payoff, B3 has a low payoff, and vice versa. An investor has only $800 to invest. Find the investment strategy that minimizes the risk. Hint: It may be easier to think of the following situation. Let events F and G be independent. The following is given: Payoff from investing $100 in either B2 or B3 В $100 $140 Cases B3 Probability event F happens event F does not happen $140 $100 0.5 0.5 and Payoff from investing $100 in BỊ Cases В Probability $100 event G happens event G does not happen $140 0.5 0.5arrow_forward
- The Schoch Museum (see Problem 30 in Chapter 11) is embarking on a five-year fundraising campaign. As a nonprofit institution, the museum finds it challenging to acquire new donors, as many donors do not contribute every year. Suppose that the museum has identified a pool of 8,000 potential donors. The actual number of donors in the first year of the campaign is estimated to be somewhere between 60% and 75% of this pool. For each subsequent year, the museum expects that a certain percentage of current donors will discontinue their contributions. This is expected to be between 10% and 60%, with a most likely value of 35%. In addition, the museum expects to attract some percentage of new donors. This is assumed to be between 5% and 40% of the current year’s donors, with a most likely value of 10%. The average contribution in the first year is assumed to be $50 and will increase at a rate between 0% and 8% each subsequent year, with the most likely increase of 2.5%. Develop and analyze a…arrow_forwardYour sister and her fiancé are planning on getting engaged (and later married) in the future. Wanting to start saving up for the wedding costs, they ask you having $60,000 saved four years from now. They also would like to withdraw $15,000 in a year to pay for the engagement rings. help them invest their money in the hopes of Besides their initial deposit, they also plan to make another deposit in three years as they are expected to receive an $8,000 settlement from a class-action lawsuit by then. There are one-year and two-year investments available for each year as well as a special three-year investment that becomes available in a year, shown in the diagram below. One-year investments return 2.5%, two-year investments return 6%, and the three-year investment return 10%. Formulate as a linear program using the variables that are listed on the diagram and solve to minimize the initial deposit your sister and her fiancé must make. Deposit (Xo) Present Хо1 Withdrawal Xo2 ($15,000) Year…arrow_forwardConsider a project with the following cash flows: year 1, 2$400; year 2, $200; year 3, $600; year 4, 2$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.a. Find the project’s NPV if cash flows occur at the ends of the respective years.b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.c. Find the project’s NPV if cash flows occur at the middles of the respective years.arrow_forward
- Donald Harris received a windfall and needs to invest it for tax reasons. He went to his brother-in-law, Joe Harris, who is a financial advisor. Joe prepared a matrix that illustrated the possible returns on investment for different investment strategies under different economic conditions. That matrix is given below. Donald Harris reads the Wall Drive Journal and came across an article that stated that the probability that there would be a major downturn would be 10%; the probability of a downturn would be 30%; the probability of an upturn would be 40%; and that the probability of a major upturn would be 20%. Based on these numbers, what investment strategy should Donald Harris adopt? Future Air Traffic Strategies Major Downturn Downturn Upturn Major Upturn Contrarian 20% 10% 5% -15% Risk Averse 2% 4% 7% 10% Growth -10% -8% 13% 20% Aggressive -25% -20% 11% 35% Group of answer choicesarrow_forwardMr. Johnnie B. Good has a furniture business which he operates as a sole proprietor. The business has been doing well for several years and now he wants to finance the expansion of his business by way of a loan and he is thinking of approaching BCN Bank accordingly. He is also planning to buy a great deal of raw material on credit from Miller’s Hardware in support of the business expansion. Mr. Good in looking at the potential risks to his personal assets and in an effort to safeguard himself from losing his personal assets if the business failed and was not able to repay the loan or pay for the material he got on credit, filed the relevant documents with the companies office and incorporated a private company, Good Furniture Ltd, with him as the sole shareholder and director and then went ahead and obtained a loan in the company’s name from the bank and bought the raw material on credit on behalf of the company. The bank in providing the loan ensured that Mr. Good signed a personal…arrow_forwardA bond has a face value of $1,000, an annual coupon rate of 3.70%, an yield to maturity of 7.4%, makes 2 (semi-annual) coupon payments per year, and 6 periods to maturity (or 3 years to maturity). Determine the duration of this bond. Notice that there is a function “Duration” in Excel, but you probably would like to check your answer with an analytical solution based on the specific duration formula. Note: This is an excel based assignment so please work it out on excel highlighting the formulas. thank youarrow_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,