Purchase Solution

Designing a shaft support using decision tree

Not what you're looking for?

Ask Custom Question

Please help with the following problem. Provide the answer in an Excel sheet.

Designing a shaft support has two options: using a pair of single row ball (SRB) bearing with a purchasing cost of $25, or using a pair of cylindrical roller bearing (CRB) with a purchasing cost $70. If selecting SRB, it will fail (within a specified life) with a probability 25%, and when it fails, it can fail in three forms (failure modes): failure in mode 1 (m1) with a chance of 0.2, in mode 2 (m2) 0.5, and in mode 3 (m3) 0.3. The damaging cost depends on the failure mode: $40 for failure in m1, $50 in m2, and $30 in m3. Assuming that when using CRB, the chance of failure is zero. Develop a decision tree for the problem, calculate the expected cost of each decision option and identify the best option.

Purchase this Solution

Solution Summary

This solution helps design a shaft support using a decision tree. The explanation is given in an Excel spreadsheet along with a diagram.

Solution Preview

Please see the attached Excel for for the solution to the problem along with a diagram to ...

Solution provided by:
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution

Free BrainMass Quizzes
Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.