Implement decision tree for "make vs. buy" decision

[heggej]

I work in purchasing for a manufacturer. My team and I created a process map full of yes or no paths/questions. Ultimately the map leads to whether we should make or buy parts. I want to know if there is a way to use this yes/no criteria and and if through excel magic the tool would be able to tell you whether to make or buy.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Need help understanding where to start" is not a good title. I have updated it for you this time to keep things moving along. --6StringJazzer

[6StringJazzer]

It's not exactly magic--someone still has to figure out how to do it. But showing us your process map might be a good start.

[Logit]

.
Here is one idea :