Purchase Solution

Decision Tree

Not what you're looking for?

Ask Custom Question

I would like to have someone explain to me how to set up formulas and solve my first problem. With my second problem I need to understand how to evaluate the data given and construct a decision tree accordingly.

Here's the problem I need to understand how to construct the formula to solve.
The materials manager for K-Flex Corportion is analyzing how to produce a new part that will be needed for the next few years. K-Flex has manufacturing plants in Japan, China, and South Africa that could produce the part. The forecast calls for 20,000 units of the part each year. The materials manager has developed the following estimates for the three alternative locations:

see attachements 1 and 2

Here's the problem I need to understand how to construct the formula to solve. The materials manager for K-Flex Corportion is analyzing how to produce a new part that will be needed for the next few years. K-Flex has manufacturing plants in Japan, China, and South Africa that could produce the part. The forecast calls for 20,000 units of the part each year. The materials manager has developed the following estimates for the three alternative locations:

Plant Type of Cost Annual Fixed Cost Annual Variable Cost
Japan Annuat Tooling $130,000 $1.30
Inspection and rework shipping $3.20

Production Cost $4,500 $23.50
China Annual Tooling $45,000 $2.55
Inspection and rework shipping $3.90
Production Cost $9,500 $26.20
South Africa Annuat Tooling $65,000 $1.90
Inspection and rework shipping $2.90
Production Cost $7,000 $25.10

Help with understanding how to read problem and construct a decision tree to analyze. A home products discount store is considering expanding its capacity to meet a growing demand for its products. The alternatives are to build a new store at a site nearby, expand and refurbish the old store, or do nothing. Economists have projected the regional economic outlook: a 50 percent probability that the economy will remain unchanged, a 20 percent probability of an economic upturn and a 30 percent probability of an economic downturn. The following estimates of annual returns have been prepared in millions:

Market Downturn Stable Market Market Upturn
Build new Store ($0.8) $0.5 $2.1
Expand Old Store ($0.4) $0.8 $1.4
Do Nothing ($0.1) $0.2 $0.5

Show how to set up formula to show what return will acccure to the company after recommendation is followed

Attachments
Purchase this Solution
Solution Summary

The solution explains the use of decision tree in making decisions.

Solution Preview

1. To set up the formula, the first thing you should do is to put up a total row for the fixed costs and the variable costs - Row 13, 17 and 21 in the file. Put up a colums for number of units produced column H. In colun I put the formula for calculating the total cost. The formula is Total variable cost*units+total fixed cost. The number of units for Japan are to be entered and the units in China and South Africa are linked. If you change the Japan units, the rest also change to give you an idea of the changes in total cost. If we have to find out the least cost producer ...

Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Introduction to Finance

This quiz test introductory finance topics.

View More Free Quizzes
Related BrainMass Solutions

  • Decision Analysis : Benefits of a Decision Tree Plan that Displays Decision Alternatives

    133203 Decision Analysis : Benefits of a Decision Tree Plan that Displays Decision Alternatives In your own words, what are the benefits of a decision tree plan that displays decision alternatives?

  • Explain the parts of a decision tree and benefits for using it

    347602 Explain the parts of a decision tree and benefits for using it Explain the parts of a decision tree. What are some benefits of using decision trees? In what ways can decision trees be used for business decisions?

  • How to create a decision tree

    This solution shows how to create a decision tree.

  • Decision Analysis for Production with Uncertain Demand

    Describe a decision tree and tell me how a tool such as this can be utilized to improve decision making. Problem: Describe a decision tree and tell me how a tool such as this can be utilized to improve decision making.

  • Decision Tree

    242873 Contingency plan by using a decision tree Create a contingency plan by using a decision tree. The contingency plan will focus on Raising money for charity for a wildlife sanctuary.

  • decision tree

    Describe a decision tree and discuss how such a tool can be utilized to improve decision making.

  • Calculating expected payoff for a decision tree

    81075 Decison tree: Expected payoff What is the expected value for the follwoing decision tree? Graph is attached A 84.5 B 70 C 100 D -50 Hi The attached excel file contains calculations of Expected payoffs for given decision tree.

  • Vroom-Yetton-Jago Decision tree

    580985 Vroom-Yetton-Jago Decision Tree The Vroom-Yetton-Jago Decision Tree is a powerful tool for analyzing the characteristics of a decision situation. However, it does have limitations. What are the strengths and weakness of the VYJ Tree?

  • Draw a decision tree and solve the problem

    Draw a decision tree to represent the problem. Solve the problem by rolling back the decision tree. See the attached file. The solution draws a decision tree and solves a problem between two gambles.

  • Decision tree Problem

    Failure costs $50k Build tree and solve I need assistance with building a decision tree.

View More Related Solutions