In my last blog entry I introduced the notion that optimal decision making wasn’t ‘on the radar’ for many clients in Australasia, and laid out a couple of ideas why. I too once focussed on Monte Carlo simulation rather than decision evaluation, but last year the most obscure event changed that.Call me a nerd of you will, but I like modelling problems in Excel. There is skill involved in setting up a problem such that the model assumptions aren’t too gross, and an art to making the model elegant. This elegance can be very important to optimisation problems, but more on that later. My first homemade optimisation problem was generated by motorcycle racing! MotoGP, to be precise. A friendly tipping competition with friends was formed at the start of the 2009 season with the following structure:
- Entrants played the role of Team Manager.
- Team Managers had a fixed budget to spend on riders.
- Either a few good riders could be purchased, or many lesser riders, or something in between.
- The team that had accumulated the most points at the end of the season was the winner and received kudos!
Although the future results could not be known of course so I set up and ran the optimisation with Evolver after the event to see what the optimal team selection would have been. Historical data could have been used to discover the type of rider mix that tended to be optimal and thus make an informed decision for this competition. The risk in having only a few riders was that any misfortune would have a big negative impact on the points won, whereas a team consisting of many (cheaper) riders was less likely to suffer such a fate. This downside scenario will be modelled into the 2010 MotoGP Team Manager predictive, optimised model (currently in production)!
What has this to do with the corporate world? Replace “team” with portfolio and “riders” with “assets”, “shares” or “projects” and you have a classic portfolio optimisation model. I hadn’t created this model with business applications in mind but I realised that was precisely what I was doing. An instant later I realised just how useful Evolver would be in many decision scenarios even though it doesn’t incorporate uncertainty (RISKOptimizer does).
In the next instalment I will further explore some practical applications for Evolver and you’ll see just how universally appropriate it can be.
» Making Optimal Choices, Part 1
Rishi Prabhakar
Trainer/Consultant

Something has troubled me for some time regarding the choices being made in risk land. I train and work with many clients whom have adopted
Why is it that most of the high profile projects managed by the government in the UK all ultimately become beset by problems? A number of projects jump to mind – the Millennium Dome, Wembley Stadium and currently the NHS IT. All three have been plagued by developmental delays and financial mismanagement. 

In the last two blogs I have challenged the idea that simulation results can be boiled down to a single statistic with any positive benefit. The context of a statistic is incredibly important, which is another reason why many statistics and charts/tables should be reported on, not simply one figure. And here’s a compelling reason why.
The
Where I left off last time was lamenting the use of Monte Carlo simulation to create a single value (statistic etc.) from a model. It might still not be clear why this is anathema to me, so here goes.
Both the Conservative Party and the Labour Government have indicated that they will raise the state pensions age of men and women to help reduce the UK’s national debt. In addition, more and more employers in the private sector are closing good pension schemes. The
I read an interesting article on the causes of the
The latest
projects evolve. The IQPC did an excellent job keeping the quality of the conference at an A+ level despite wrangling with the effects of a down market and near zero travel budgets for many companies. This conference has earned it place as one of the premier Six Sigma events of the year.
Subscribe to the Palisade
Become a fan of the Palisade