Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 8QP
Summary Introduction
To determine: The sensitivity report using solver.
a)
Summary Introduction
To determine: The change in the optimal solution when the profit of Bike R decreased to $35.
b)
Summary Introduction
To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.
c)
Summary Introduction
To interpret: The shadow price for the supply of polymer.
d)
Summary Introduction
To determine: The justification for the given statement.
e)
Summary Introduction
To determine: The new optimal level of profit for the given condition.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Suppose the equilibrium price for good quality used cars is $20,000. And the equilibrium price for poor quality used cars is $10,000. Assume a potential used car buyer has imperfect information as to the condition of any given used car. Assume this potential buyer believes the probability a given used car is good quality is .60 and the probability a given used car is low quality is .40. Assume the seller has perfect information on all cars in inventory.
What policy or mechanism could solve any informational imbalances and restore the market to an efficient allocation of used cars?
a. Third-party provided information on the history of the car (ex: maintenance records, accident records, verified millage and verify repairs).
b. Legal remedies and laws restricting fraudulent sales of used cars.
c. Obtainablepublications discussing quality, price and possible repairs of all cars --used and new.
d. All of the above.
Combined-cycle power plants use two combustion turbines to produce electricity. Heat from the first turbine’s exhaust is captured to heat waterand produce steam sent to a second steam turbine that generates additional electricity. A 968-megawatt combined-cycle gas fired plant can be purchased for $450 million, has no salvage value, and produces a net cash flow(revenues less expenses) of $50 million per year over its expected 30-year life. Solve, a. If the hurdle rate (MARR) is 12% per year, how profitable an investment is this power plant? b. What is the simple payback period for the plant? Is this investment acceptable?
A home improvement store sells hydrangea plants during the spring planting season. The hydrangeas cost the store $15 per unit, and sell to customers for $45, but any leftovers at the end of the season are salvaged to a local landscaper for $7/unit. A competitor has advertised that it guarantees 99% of customers find the product they’re looking for in stock. The competitor’s posted price for hydrangeas is $50, and they salvage to the same local landscaper for $7/ hydrangea plant. If the competitor’s advertised service level is correct for hydrangeas and they follow an optimal stocking policy, what does it imply their cost per hydrangea is?
Chapter 4 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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
- Can you please answer a and b to this questionarrow_forwardSolve for the future worth of each of the given series of payments: (a) $12,000 at the end of each six-month period for 12 years at 8% compounded semiannually. (b) $8,000 at the end of each quarter for 6 years at 12% compounded quarterly. (c) $6,000 at the end of each month for 5 years at 6% compounded monthly.arrow_forwardPlease answer all parts A Rhino cement company owns two production plants. Plant 1 costs 20977 per day to operate, and it can produce 330 bags of high-grade cement, 475 bags of medium-grade cement , and 508 bags of low-grade cement each day. Plant 2 is newer and more modern. It costs 22570 per day to operate, and it can produce 435 bags of high-grade cement,271 bags of medium-grade cement, and 274 bags of low-grade cement each day. The company has orders totaling 24539 bags of high-grade cement, 25248 bags of medium-grade cement, and 33749 bags of low-grade cement. How many days should it run each plant to minimize its costs and still produce enough cement to meet its orders? What is the value of the first dual variable? What is the value of the second dual variable? What is the value of the third dual variable? What is the value of dual optimal solution z?arrow_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_forwardManagement of the Toys R4U Company needs to decide whether to introduce a certain new novelty toy for the upcoming Christmas season, after which it would be discontinued. The total cost required to produce and market this toy would be $500,000 plus $15 per toy produced. The company would receive revenue of $35 for each toy sold. Assuming that every unit of this toy that is produced is sold, write an expression for the profit in terms of the number produced and sold. Then find the break-even point that this number must exceed to make it worthwhile to introduce this toy. Now assume that the number that can be sold might be less than the number produced. Write an expression for the profit in terms of these two numbers. Formulate a spreadsheet that will give the profit in part b for any values of the two numbers. Write a mathematical expression for the constraint that the number produced should not exceed the number that can be sold.arrow_forwardKevin’s friend, Sam, runs a septic tank repair business. Your research shows that the following price and demand for servicing a tank: Current Price: $300New Price: $375 Current demand: 450 tanksNew demand 425 tanks What is the coefficient of elasticity for Sam’s business? Here is the formula for calculating elasticity: Ed = {(Q1-Q2) / [1/2 (Q1+Q2)] } / {(P1-P2) / [1/2 (P1 + P2)]}arrow_forward
- Please solvearrow_forwardSeas 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_forwardPorter five forces model, developed by Michael E. Porter of Harvard University in 1979, holds the purpose to analyse the industry in order to determine the level of intensity regarding the competition and attractiveness of the industry. The attractiveness of an industry is measured in terms of profit; more profitability means a more attractive industry and low profitability means a low attractive industry. Porter’s Five Forces model is a powerful management tool for analysing the current industry profitability and attractiveness by using the outside-in perspective. Within the last decades, the model has attracted some criticism because of the developing Internet economy. Due to an increasing significance of Digitalization,Globalization and Deregulation, the industry structure of the ‘Old Economy’ changed fundamentally. The ‘New Economy’ is not comparable with the ‘Old Economy’, which is the basis of the Five Forces model. Moreover, the last decades have shown that Information…arrow_forward
- A bakery must decide how many pies to prepare for the upcoming weekend. The bakery has the option to make 50, 100, or 150 pies. Assume that demand for the pies can be 50, 100, or 150. Each pie costs $5 to make and sells for $7. Unsold pies are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Refer to the information above. Assume that the bakery has obtained the following probability information regarding demand for the pies: P(50) = 0.3, P(100) = 0.5, and P(150) = 0.2. What is the expected value under certainty? Question 5 options: 0 190 280 90arrow_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_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. 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_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,