Decision Tree

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:Screen Shot 2014-03-30 at 12.12.00 PM

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

Kendell Lobster Decision Tree

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s