Decision analysis is an important part of modern revenue management strategies for many businesses. One solution for analysis of decisions of smaller complexity is TreePlan, a plugin for Excel. I was required to use TreePlan in an Excel modeling class I took earlier this year to solved the “Kendell Lobster Case” in Bertsimas & Freund’s popular Data, Models, and Decisions. 

After solving the case TreePlan’s output looks like this:

It’s usable, but doesn’t look great. So I took the output and designed a better looking solution using Adobe Illustrator: