Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 19QP
a)
Summary Introduction
To formulate: An linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Your 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…
Aventura Savings and Loan requires 15% down payment on a mortgage loan. What is the down payment needed to finance a $148,500 home?
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
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 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%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_forwardLorna owns a home that is worth $385,000. She has a mortgage with a balance of $112,000. Calculate her equity in the home. $497,000 $76,000 $273,000 $245,000arrow_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_forwardFormulate but do not solve the problem.The management of a private investment club has a fund of $200,000 earmarked for investment in stocks. To arrive at an acceptable overall level of risk, the stocks that management is considering have been classified into three categories: high-risk, medium-risk, and low-risk. Management estimates that high-risk stocks will have a rate of return of 16%/year; medium-risk stocks, 8%/year; and low-risk stocks, 6%/year. The investment in low-risk stocks is to be twice the sum of the investments in stocks of the other two categories. If the investment goal is to have an average rate of return of 9%/year on the total investment, determine how much the club should invest in each type of stock. (Assume that all the money available for investment is invested. Let x, y, and z denote the amount, in dollars, invested in high-, medium-, and low-risk stocks, respectively.) _____= 200,000 _____= z _____ = .09(200,000)arrow_forwardA UCLA student saved $100,000 for the down payment on a $1,000,000 one-bedroom, two-bathroom home in Encino, California. She can qualify for either a $900,000 fully amortizing 30-year first mortgage loan at a 4.75% annual interest rate from Wells Fargo Bank, or she can qualify for a $790,000 fully amortizing 30-year first mortgage loan at a 4.25% annual interest rate with a $110,000 fully amortizing 30-year second mortgage loan at an 8.00% annual interest rate from Citibank. Should the student prefer the single $900,000 mortgage loan from Wells Fargo Bank or should she prefer the $790,000 first mortgage loan and $110,000 second mortgage loan package from Citibank? Single loan from Wells Fargo Bank No difference Depends on all the terms and conditions in the loan documents from Wells Fargo Bank as compared to those from Citibank Loan package from Citibankarrow_forward
- A young computer engineer has $12,000 to invest and three different investment options (funds) to choose from. Type 1 guaranteed investment funds offer an expected rate of return of 7%, Type 2 mixed funds (part is guaranteed capital) have an expected rate of return of 8%, while an investment on the Stock Exchange involves an expected rate of return of 12%, but without guaranteed investment capital. Computer engineer has decided not to invest more than $2,000 on the Stock Exchange in order to minimize the risk. Moreover for tax reasons, she needs to invest at least three times more in guaranteed investment funds than in mixed funds. Assume that at the end of the year the returns are those expected; she is trying to determine the optimum investment amounts. (a) Express this problem as a linear programming model with two decision variables.(b) Solve the problem with the graphical solution procedure and define the optimum solution.arrow_forwardWhat is the future worth (in Year 10) of $23,000 deposited at the end of Year 3 plus $28,000 deposited at the end of Year 5, and $20,000 deposited at the end of Year 8 at an interest rate of 5% per year?arrow_forwardAt age 25, Anthony establishes an Individual Retirement Account (IRA). If he invests P10,000 per year for 30 years in an ordinary annuity, the account earns 7.75% per year, how much will he have in the account at age 55?arrow_forward
- A rich person passes away, leaving the following legacy: 1- A Caillebotte picture: 25000$2- A bust of Diocletian: 5000$3- A Yuan dinasty chinese vase: 20000$4- A 911 Porsche: 40000$5- Three diamonds: 12000$ each6- A Louis XV sofa: 3000$7- Two very precious Jack Russell race dogs: 3000$ each (the will asserts that they may not be separated)8- A sculpture dated 200 A.D.: 10000$9- A sailing boat: 15000$10- A Harley Davidson motorbike: 10000$11- A piece of furniture that once belonged to Cavour: 13.000$. These items must be shared between the two sons. Write an optimization model to find a partition of these items that minimizes the difference between the values of the two parts? Carefully explain all of the decision variables, constraints, objective function, and an appropriate solving method that you would choose. You *do not* need to solve your optimization model.arrow_forwardThe following information describes the accounting procedures at Soufian Sdn. Bhd. Soufian Sdn. Bhd. is a small construction company which processes its daily transactions manually. Soufian, a senior account executive is spending more money than he can afford. He is the authorized signatory on the company’s bank account and write cheques for himself, his accomplices and his creditors. Here, no one is reviewing the supporting documents or reconciling the bank statements. In addition, he has a complete control over the company’s computerized accounting system. Accordingly, because there was no oversight of his work, Soufian is brave enough to do absolutely nothing to conceal the irregularities on the records. An account clerk assists Soufian, but the clerk job is not requiring much attention, for example, only does filing and retrieving documents, answering phones, responding to emails and running errands. On the other hand, Soufian is occupying too much time with his work by not telling…arrow_forwardM-REITs, or mortgage REITs, primarily invest in real estate loans and mortgage-backed securities that are often below investment grade. When a mortgage REIT decided some years ago to re-securitize a substantial portion of its CMBS "BB" and "B" securities, it received surprisingly high investment grade ratings of "A" and "BBB" from Standard & Poor's on the new securities that were created from the cash flows of the underlying portfolio of non-investment grade rated securities. But when the financial markets began to fall a few months later, that mortgage REIT quickly went bankrupt and the value of its "A" and "BBB" investment grade rated re-securities fell substantially. The intended purpose of the ratings agencies is: To produce substantial profits for the rating agencies from the fees paid to them for giving higher ratings on investments than might otherwise be appropriate To help businesses and governments raise needed capital by providing them with the ratings they need to…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,