Decision Trees

Decision Trees - Decision Trees.doc Page 1 of 7 Decision...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Decision Trees.doc Page 1 of 7 Decision Trees The Decision Tree module in Excel OM (and in POM for Windows) acts differently than all other modules because rather than creating a table of data it creates a graphical tree. We will use Example 3 in Chapter A5 from Heizer & Renders Operations Management textbook for our example. After selecting the Decision Tree Module the screen will appear as in Figure 1 below. Figure 1: The Initial Decision Tree Screen Notice the Decision Tree Creation Window on the right. This is used to perform all of the work of constructing the tree. The initial screen has 1 starting node (Node 1) which can be seen in cell A6. The first step is to add branches from this node. The default setting is to Add 2 Decision branches. The type of branch is selected by the choice of Add buttons that is selected and the number of branches is selected by the textbox/scrollbar combination. For this example, there are three options Purchase CAD, Hire Engineers or Do Nothing. Therefore we will change the number of branches to 3 and click on the Add Decisions button. This yields the screen as displayed in Figure 2. Decision Trees.doc Page 2 of 7 Figure 2: The First Three Branches At this point the data can be entered into the shaded green cells. For decision branches, the data consists of the name of the branch and possibly a profit or cost. If the branch is at the end of the tree then the profit gets entered. If the branch is not at the end then any intermediate profits or costs can be entered. Costs are entered as negative numbers. We will display the data in the next screen....
View Full Document

Page1 / 7

Decision Trees - Decision Trees.doc Page 1 of 7 Decision...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online