RESEARCH ARTICLES | RISK + CRYSTAL BALL + ANALYTICS

 Quick overview of the parts of an optimization model in MS Excel.

  • 12 May 2009
  • Author: mckibbinusa
  • Number of views: 848
  • Comments: 0

 Quick overview of the parts of an optimization model in MS Excel.

When using tools such as Excel, Crystal Ball or ModelRisk, it is very important to be able to translate a mental model to a mathematical one. Let me illustrate, when you think about your business, you often will think of abstract notions such as profit or margins. These are mental constructs because their are no physical representations of profit or margins (except a pile of cash) only mathematical ones.

  • 17 February 2009
  • Author: mckibbinusa
  • Number of views: 765
  • Comments: 0

When using tools such as Excel, Crystal Ball or ModelRisk, it is very important to be able to translate a mental model to a mathematical one. Let me illustrate, when you think about your business, you often will think of abstract notions such as profit or margins. These are mental constructs because their are no physical representations of profit or margins (except a pile of cash) only mathematical ones.


RSS
First10111213141516171819