Treeplan student 179 excel add in

Consulting Report

Instructions

The client company hired you to consult regarding the newly developed product.

Think of any product you have in mind.

The company faces two decisions either to launch the new product at the international market or to evaluate it to test at a national market.

In order to provide the company, the best decision, you will prepare the following:

· Indicate your own estimates of the profit for launching it internationally and nationally with respective probabilities of events.

· Using the TreePlan, construct a decision tree to determine the optimal decision strategy.

· Under options, choose the default: Expected Value and Maximize.

· Assess the risk associated with this decision.

· Summarize your results and present justifications of your chosen decision strategy and provide recommendations to the client company.

· Address your report to the company's executive in charge of making this decision.

The report consists of 2500 words, single space. Follow a typical consulting report format.

Requires the use of EXCEL. See files for TreePlan Excel add-in and instructions.

Empty
&L&F &A&R &T &D
BuildTree
BuildTree (formerly Ctrl + b)
item
x
y
width
height
text
init/result
names
HelpText
TreePlan for Excel 1.79
HelpLineNew
1
Renumber T after editing help.
Edit value of each Boolean Constant, IsTrial and IsStudent
x
y
width
height
x
y
width
height
NewData
ID
Name
Value
Prob
Pred
Kind
NS
S1
S2
S3
S4
S5
Row
Col
Mark
SelectBox
564
160
TreePlan Student - Select
(Arial 10)
2
Locate entry lines in S.
Select cell W7 with text "VersionStrings"
XYWHSelWin
564
160
XYWHSelMac
624
172
0
TreePlan
0
0
0
D
2
1
2
0
0
0
0
2009 03 13 1.73
11
5
ResSelBut
16
(CW 28.33)
Decision Tree Software
3
Select S and T.
In Excel 97, choose Tools | Macro | Macros | W7 | Run
1
Alternative 1
0
0
0
T
0
0
0
0
0
0
0
2009 03 13 1.73
12
15
20
Branch names
17
Add-In for Microsoft Windows Excel 2000-2010
4
Create Names (left column).
These defined names are used by VBA CreateMenuItem
20080414
15
20
15
20
188
2
Alternative 2
0
0
0
T
0
0
0
0
0
0
0
2009 03 13 1.73
12
Partial cash flows
18
and for Macintosh Excel 2011
5
Set protection in VBE, and save as add-in using Excel 97
188
0
2009 03 14 1.73
12
Probabilities
19
6
188
12
Rollback EVs/CEs
20
TreePlan helps you build and modify decision tree diagrams
7
VersionStrings
20000104
188
0
DimSelEU
12
Rollback EUs
21
in Excel worksheets. TreePlan automatically puts formulas
8
0
188
0
12
Terminal values
22
on your worksheet for evaluating these trees.
9
0
188
0
12
208
20
Decision nodes
23
10
0
208
20
228
20
172
0
12
Event nodes
24
To build a new decision tree, first create a new worksheet.
11
0
172
0
12
Terminal nodes
25
Then start TreePlan in one of two ways:
12
0
172
0
12
Branch lines
26
13
0
172
0
12
Diagonal lines
27
Windows Excel 2000-2003
14
0
172
0
''=DoTermForm() 20110608
12
Connectors
28
Tools > Decision Tree, or Ctrl+Shift+T
15
0
172
0
''=DoRollbackForm() 1.78
12
388
20
Nodes
29
16
0
388
20
428
20
173
0
12
Diagonals
30
Windows Excel 2007 & 2010
17
0
173
0
20060416
12
Left branches
31
Add-Ins > Decision Tree, or Ctrl+Shift+T
18
0
173
0
12
Right branches
32
19
0
173
0
12
Terminal values
33
Macintosh Excel 2011
20
0
173
0
14
7
7
178
116
Cells
34
Tools > Decision Tree, or Option+Cmd+T
21
0
7
7
178
116
7
7
198
126
'' =SELECT(!TreeDiagram)
Restrict XL7 recalc fix to tree, 96NOV26
14
200
7
162
116
Objects
35
22
0
200
7
162
116
220
7
182
126
'' =FORMULA.REPLACE("=","=",2,1,FALSE)
Fixes XL7 recalc bug
14
380
7
163
100
Columns
36
When the TreePlan...New dialog box appears, choose
23
0
380
7
163
100
420
7
183
110
0
1
11
130
88
OK
37
New Tree. TreePlan builds a tree diagram with an initial
24
0
11
130
88
11
140
88
0
20080412
3
122
130
88
Options...
38
decision node and two branches. The tree diagram begins
25
0
122
130
88
179
140
88
2
233
130
88
Cancel
39
with the upper left corner of the diagram near the active
26
0
233
130
88
347
140
88
0
2009 03 14 1.73
3
456
130
88
Help
40
cell at the time New... is chosen. TreePlan assigns the
27
0
456
130
88
515
140
88
0
2009 03 13 1.73
41
name TreeDiagram to the range of the tree diagram and