Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6, Problem 72P
Summary Introduction
To develop: A linear integer model.
Introduction: The variation between the present value of the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Yearly oil production in Mexico, and yearly oil imports of the US from Mexico
can be represented by the functions:
P(t) = 3.0 – 0.13t million barrels
I(t)
1.4 + 0.06t million barrels
in year t, where t is the time in years since the start of 2000.
a) What is represented by the functions P(t) – I(t) and I(t)/P(t)? What are the units for these functions?
b) Let q(t) = I(t)/P(t). Compute q'(t) and q'(3). Interpret in a complete sentence.
c) In marginal analysis, we would use q' (3) to estimate what quantity? Compute the actual value of that
quantity and compare it with q'(3).
money borrowed for personal reasons; to be repaid within
a specific time frame and with added interest
money borrowed for the purchase of real estate; to be
repaid within a specific time frame and with added interest
money borrowed for business reasons; to be repaid within
a specific time frame and with added interest
money borrowed for the purchase of a vehicle; to be
repaid within a specific time frame and with added interest
: Business Loan
:: Auto Loan
:: Mortgage Loan
:: Personal Loan
1
4
6.
8.
9.
Finish
Si
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.
Chapter 6 Solutions
Practical Management Science
Ch. 6.3 - Prob. 1PCh. 6.3 - Prob. 2PCh. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Prob. 4PCh. 6.3 - Prob. 5PCh. 6.3 - Prob. 6PCh. 6.3 - Prob. 7PCh. 6.3 - Prob. 8PCh. 6.3 - Prob. 9PCh. 6.3 - Prob. 10P
Ch. 6.4 - Prob. 11PCh. 6.4 - Prob. 12PCh. 6.4 - Prob. 13PCh. 6.4 - Prob. 14PCh. 6.4 - Prob. 15PCh. 6.4 - Prob. 16PCh. 6.4 - Prob. 17PCh. 6.4 - Prob. 18PCh. 6.4 - Prob. 19PCh. 6.4 - Prob. 20PCh. 6.4 - Prob. 21PCh. 6.4 - Prob. 22PCh. 6.4 - Prob. 23PCh. 6.5 - Prob. 24PCh. 6.5 - Prob. 25PCh. 6.5 - Prob. 26PCh. 6.5 - Prob. 28PCh. 6.5 - Prob. 29PCh. 6.5 - Prob. 30PCh. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - Prob. 32PCh. 6.5 - Prob. 33PCh. 6.5 - Prob. 34PCh. 6.5 - Prob. 35PCh. 6.6 - Prob. 36PCh. 6.6 - Prob. 37PCh. 6.6 - Prob. 38PCh. 6 - Prob. 39PCh. 6 - Prob. 40PCh. 6 - Prob. 41PCh. 6 - Prob. 42PCh. 6 - Prob. 43PCh. 6 - Prob. 44PCh. 6 - Prob. 45PCh. 6 - Prob. 46PCh. 6 - Prob. 47PCh. 6 - Prob. 48PCh. 6 - Prob. 49PCh. 6 - Prob. 50PCh. 6 - Prob. 51PCh. 6 - Prob. 52PCh. 6 - Prob. 53PCh. 6 - Prob. 54PCh. 6 - Prob. 55PCh. 6 - Prob. 56PCh. 6 - Prob. 57PCh. 6 - Prob. 58PCh. 6 - Prob. 59PCh. 6 - Prob. 60PCh. 6 - Prob. 61PCh. 6 - Prob. 62PCh. 6 - Prob. 63PCh. 6 - Prob. 64PCh. 6 - Prob. 65PCh. 6 - Prob. 66PCh. 6 - Prob. 67PCh. 6 - Prob. 68PCh. 6 - Prob. 69PCh. 6 - Prob. 70PCh. 6 - Prob. 71PCh. 6 - Prob. 72PCh. 6 - Prob. 73PCh. 6 - Prob. 74PCh. 6 - Prob. 75PCh. 6 - Prob. 76PCh. 6 - Prob. 77PCh. 6 - Prob. 78PCh. 6 - Prob. 79PCh. 6 - Prob. 80PCh. 6 - Prob. 81PCh. 6 - Prob. 82PCh. 6 - Prob. 83PCh. 6 - Prob. 84PCh. 6 - Prob. 85PCh. 6 - Prob. 86PCh. 6 - Prob. 87PCh. 6 - Prob. 88PCh. 6 - Prob. 89PCh. 6 - Prob. 90PCh. 6 - Prob. 91PCh. 6 - Prob. 92PCh. 6 - This problem is based on Motorolas online method...Ch. 6 - Prob. 94PCh. 6 - Prob. 95PCh. 6 - Prob. 96PCh. 6 - Prob. 97PCh. 6 - Prob. 98PCh. 6 - Prob. 99PCh. 6 - Prob. 100PCh. 6 - Prob. 1CCh. 6 - Prob. 2CCh. 6 - Prob. 3.1CCh. 6 - Prob. 3.2CCh. 6 - Prob. 3.3CCh. 6 - Prob. 3.4CCh. 6 - Prob. 3.5CCh. 6 - Prob. 3.6C
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
- 9) Today is your 20th birthday. Your parents just gave you $5,000 that you plan to use to open a stock brokerage account. Your plan is to add $500 to the account each year on your birthday. Your first $500 contribution will come one year from now on your 21st birthday. Your 45th and final $500 contribution will occur on your 65th birthday. You plan to withdraw $5,000 from the account five years from now on your 25th birthday to take a trip to Europe. You also anticipate that you will need to withdraw $10,000 from the account 10 years from now on your 30th birthday to take a trip to Asia. You expect that the account will have an average annual return of 12 percent. How much money do you anticipate that you will have in the account on your 65th birthday, following your final contribution?arrow_forwardWhich of the following types of loans is a term loan where the funds are used to build a home A) 203(b) loan B) 203(k) loan C) Construction loan D) Home equity loanarrow_forwardWhy is the RISKCORRMAT function necessary?How does @RISK generate random inputs by default,that is, when RISKCORRMAT is not used?arrow_forward
- A college student works in both the school cafeteria and library. She works no more than 12 hours per week at the cafeteria, and no more than 16 hours per week at the library. She must work at least 20 hours each week. Write a system of inequalities that describes all the given conditions. Write a system of inequalities letting x= number of hours worked at the cafeteria per week and y = number of hours worked at the library per week. x+yz x≤ ysarrow_forwardSuppose you want to have $700,000 for retirement in 30 years. Your account earns 8% interest. How much would you need to deposit in the account each month? %24arrow_forwardA trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the total annual return (before tax). 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 as least 50% of the money in short-term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total annual return should be tax free. Suppose the decision variable represents the amount of money invested in bond for . Formulate a linear programming (LP) model to solve the optimal strategy. 1. Write down the constraint using the defined decision variables requiring “invest as least 50% of the money in short-term issues”. 2. Write down the constraint using the defined decision…arrow_forward
- Suppose that $100 is invested at the beginning of a year. Which (if either) of the following methods of growing the investment results in a larger amount at the end of the year? (i) The investment grows at an interest rate of 4% per year, compounded continuously.(ii) The investment grows at an instantaneous growth rate of 4% per year. method (i) method (ii) Both methods produce the same amount.arrow_forwardMinimize Z= x1+2x2-3x3-2x4 subject to: x1+2x2-3x3+x4=4 x1+2x2+x3+2x4=4 x1, x2, x3,x4 are equal or greater then zeroarrow_forwardConsider the following game of ’divide the dollar.’ There is a dollar to be split between two players. Player 1 can make any offer to player 2 in increments of 25 cents; that is, player 1 can make offers of 0 cents, 25 cents, 50 cents, 75 cents, and $1. An offer is the amount of the original dollar that player 1 would like player 2 to have. After player 2 gets an offer, she has the option of either accepting or rejecting the offer. If she accepts, she gets the offered amount and player 1 keeps the remainder. If she rejects, neither player gets anything. Draw the game tree.Consider the following variant of the ’divide the dollar’ game. Players 1 and 2 move simultaneously; 1 makes an offer to 2 and 2 specifies what would be an acceptable offer. For instance, player 1 might make an offer of 50 cents and player 2 might simultaneously set 25 cents as an acceptable offer. If player 1’s offer is at least as large as what is acceptable to player 2, then we will say that there is an agreement…arrow_forward
- A few years ago, Michael purchased a home for $394,000. Today, the home is worth $520,000. His remaining mortgage balance is $166,000. Assuming Michael can borrow up to 80 percent of the market value of his home, what is the maximum amount he can borrow?arrow_forwardBruin 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%arrow_forwardA 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. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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,