Decision Making Tree
Decision Making Tree
Decision Making Tree
Break-Even Analysis
Make-or-Buy Decision
Decision Tree
In these Active Models we consider models that are useful for decision making. We use break-even analysis
both to analyze profitability and to determine whether to make or buy.
A decision tree, one of the models widely used for OM decisions, contains probabilities. Generally, probabilities
are estimates (forecasts) and there is much uncertainty associated with them. We explore the effects of the
probabilities on our decision.
Decision Making
Break-Even Analysis
1. If the fixed costs increase by 10% to $110,000, does the break-even quantity increase or
decrease? By what percentage?
2. If the charge to patients increases by 10% to $220, does the break-even quantity increase or
decrease? By what percentage?
3. If the total variable costs increase by 10% to $110, does the break-even quantity increase or
decrease? By what percentage?
4. What would the procedure price need to be in order to have a break-even quantity of 800
patients?
Make-or-Buy Decision
1. If the manager can decrease the fixed cost of making by 10% to $10,800, will the break-even
quantity increase or decrease? By what percentage?
2. If the manager can negotiate a 10% (20 cents) reduction in the price of pre-assembled salads,
will the break-even quantity increase or decrease? By what percentage?
3. If the fixed cost of buying could be eliminated, would the decision change based on the expected
sales of 25,000 salads per year?
Decision Tree
1. If the probability of low demand increases, what happens to the total profit?
will go down
2. For what range of probabilities of low demand would the better decision be to build a large
facility?
3. If the probability of a modest response (rather than a sizable response) to advertising increases,
what happens to the total profit?
4. How is the final decision affected by the probability of the response to advertising?
Break-Even Analysis
null
Break-even quantity
units (patients) 1,000
Amount PHP 200,000
Compared to 1,000 0%
Make-or-Buy Decision
Point of Indifference
Make vs. Buy 19,200 salads
Compared to 19,200 0%
Decision Tree
0.40
0.6
2
null High demand (270.00) Expand
2 null
(544.00) Do nothing
(544.00)
0.6
High demand
200
223
270
40
0.30
Modest response
20
0.7
Sizable response
220
800
Breakeven graph
Total
Variable
Volume Fixed Cost Cost TotalTotal
Annual
Annual
Costs
Revenues
Total Profit
0.00 100000.00 0.00 100000.00 0.00 -100000.00 1000.00 0.00
3000.00 100000.00 300000.00 400000.00 600000.00 200000.00 1000.00 200000.00
1000.00 0.00
1000.00 200000.00
0.00 200000.00
1000.00 200000.00
Graph
Volume Make Buy
0.00 12000.00 2400.00 19200.00 0.00
57600.00 98400.00 117600.00 19200.00 40800.00
Compatibility Report for Decision Tree Template for Excel.xls
Run on 7/12/2020 11:24
Some cells or styles in this workbook contain formatting that is not supported 29
by the selected file format. These formats will be converted to the closest
format available.
Version
Excel 97-2003