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 42QP
a)
Summary Introduction
To formulate: A 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
Trending nowThis is a popular solution!
Students have asked these similar questions
Mono Industries has a project with the following projected cash flows:
Initial Cost, Year 0: P200,000
Cash flow year one: P25,000
Cash flow year two: P75,000
Cash flow year three: P150,000
Cash flow year four: P150,000
Using a 10% discount rate for this project and the NPV model, should this project
be accepted or rejected?
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 choices
An investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profits, in Kwacha, of each investment under each economic condition are indicated in the following payoff table:
Â
Event
Investment selection
A
B
C
Economy declines
500
-2000
-7000
No charge
1000
2000
-1000
Economy Expand
2000
5000
20,000
Â
Based on his own past experience, the investor assigns the following probabilities to each economic condition:
P (Economy declines) = 0.30
    P (No Change) = 0.50
  P (Economy expands) = 0.20
i. Compute the coefficient of variation for each investment.
ii. Compute the return-to-risk ratio (RTRR) for each investment.
iii. Based on (i) and (ii), what investment would you choose? Why?
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
- 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_forwardDonald 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. Given these values, what type of investment strategy would be selected by the Equally Likelycriterion? Â 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_forwardDonald 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. Given these values, what type of investment strategy would be selected by the Maximincriterion? Â 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_forward
- Formulate 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_forwardAn investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profit in Kwacha of each investment under each economic condition are indicated in the following payoff table: Event Investment Selection A B C Economy declines 500 -2000 -7000 No charge 1000 2000 -1000 Economy Expand 2000 5000 20,000 Based on his own past experience, the investor assigns the following probabilities to each economic condition: ( ) ( ) ( ) Economy declines 0.30 No change 0.50 Economy expands 0.20PPP=== i. Determine the optimal action based on the maximax criterion ii. Determine the optimal action based on the maximin criterion iii. Compute the expected monetary value (EMV) for each investmentarrow_forwardAn investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profit in Kwacha of each investment under each economic condition are indicated in the following payoff table: Event Investment Selection A B C Economy declines 500 -2000 -7000 No charge 1000 2000 -1000 Economy Expand 2000 5000 20,000 Based on his own past experience, the investor assigns the following probabilities to each economic condition: ( ) ( ) ( ) Economy declines 0.30 No change 0.50 Economy expands 0.20PPP=== iv. Compute the expected opportunity loss (EOL) for each investment v. Explain the meaning of the expected value of perfect information (EVPI) in this problem vi. Based on the results of (iii) and (iv), which investment would you choose? Why?arrow_forward
- During the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month                    Number of Months           0                                                3           1                                                2           2                                                4           3                                                3                                                           12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…arrow_forwardWarren 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…arrow_forwardA local real estate investor in Kingston is considering three alternative investments: a motel, a restaurant, or a theater. Profits from the motel or restaurant will be affected by the availability of gasoline and the number of tourists; profits from the theater will be relatively stable under any conditions. The following payoff table shows the profit or loss that could result from each investment:                                                            Real Estate Investor Payoff Table   Payoffs are Profits    States of Nature (Gasoline Availability)  Decision Alternatives Shortage Stable Supply Surplus Motel $–8,000 $15,000 $22,000 Restaurant $2,000 $8,000 $6,000 Theater $6,000 $6,000 $5,000        Which option should the real estate investor choose if he uses the LaPlace criterion?                                                          Using…arrow_forward
- Steve Johnson believes that this winter is going to be extremely rainy, and he is trying to decide whether he should repair or replace his roof. Steve can install a new roof for $7000 or have it repaired for $1000. While the repair work will probably mean that the house will not have any leaks during the upcoming year, Steve believes that he will definitely need a new roof next year and would have to pay $7000 at that time if he does not get the roof replaced this year.  There is a 60% chance that Steve will be transferred during the upcoming year and will have to put his house on the market. Steve feels that a new roof will enable him to get $4000 more if he sells his house. If he does not repair or replace the roof, Steve believes there is a 70% change that there will be rain damage to his home. He estimates the likelihood that the damage will be $500 is 10%, $1000 is 20%, $1500 is 30%, and $2000 is 40%. Using a decision tree analysis, determine Steve’s optimal strategy for dealing…arrow_forwardSachs Brands's defined benefit pension plan specifies annual retirement benefits equal to 1.5% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2007 and is expected to retire at the end of 2041 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $83,000 at the end of 2021 and the company's actuary projects her salary to be $245,000 at retirement. The actuary's discount rate is 9%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) At the beginning of 2022, the pension formula was amended to: 1.60% × Service years × Final year's salary The amendment was made retroactive to apply the increased benefits to prior service years. Required: 1. What is the company's prior service cost at the beginning of 2022 with respect to Davenport after the amendment described above?2. Since the amendment occurred at…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. What is the approximate effective annual interest rate on the combined first and second mortgage loan package from Citibank? a. 8.00% b. 4.25% c. 4.75% d. 6.15%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,