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:
This is the introduction of my thesis, which was laid out using Adobe InDesign. The chapter header and graphs were created in Illustrator and imported into InDesign.
This is a map I created for my thesis on agriculture in Tanzania. The data shows the district variation in the area planted to modern seed varieties. The data is from a 2007-2008 agriculture survey conducted by the Ministry of Agriculture. I used an average of the area planted during the long and short rainy season weighted to account for the fact that most agricultural activity takes place during the long season.
This is a detailed diagram from my thesis showing Tanzania’s formal seed chain.
This is a chart I made for my thesis on agriculture in Tanzania describing the relationship between Tanzania’s three seed chains. The chart was adapted from several sources and, although it looks simple, it took quite a while to come up with this shape that would depict the relationship between the three different seed system.
This is a map I created showing the main countries exporting seed to Tanzania. I wanted to give the map some depth so I used the 3-D features in Illustrator to give a sort of bird’s eye view of the region. I then placed the dotted lines and arrows individually. The subtle shadow effect was made by copying the lines and arrows and using a Gaussian blur. Illustrator has a built-in shadow effect, but it looks very wonky if you try to use it with curved lines. Making the shadows by hand gives much more control and the effect is much more polished.
This is a chart I made using CGIAR data, which shows the improvement in yield for a variety of crops using so-called “modern seeds” (sometimes called “improved seeds”). These are non-GMO seed varieties cultivated by agronomists using traditional breeding techniques, but in a highly-controlled environment. I created this chart as part of my thesis on agriculture in Tanzania.