risk graph logo

RISKOptimizer

Optimization with Monte Carlo Simulation in Excel

Find the Best Resource Allocation under Uncertainty

orange triangle
Two smiling diverse businesspeople using a laptop together at wo

Solve Complex Allocation Problems involving Uncertain Variables

Wouldn’t you like to know the best allocation of your limited resources to maximize your profits? Or the most efficient schedule to minimize costs? But what about the uncertainty inherent in sales projections, returns from individual investments, or production costs?

Traditional optimization methods ignore this uncertainty, a very risky approach. RISKOptimizer tells you not only the best combination of inputs to use, but the risk associated with each strategy. You can seek out strategies that enable you to minimize your risks while achieving your goals.

Overview

RISKOptimizer combines the Monte Carlo simulation technology of @RISK, Palisade’s risk analysis add-in, with the latest solving technology to allow the optimization of Excel spreadsheet models that contain uncertain values. Take any optimization problem and replace uncertain values with @RISK probability distribution functions that represent a range of possible values. For each trial solution RISKOptimizer tries during optimization, it runs a Monte Carlo simulation, finding the combination of adjustable cells that provides the best simulation results.

Works with Microsoft Excel

Optimize Tough Problems under Uncertainty

Compare Different Solutions

Communicate Results and Data with Others

Monitor Optimization Progress with RISKOptimizer Watcher

Industries

Energy & Utilities

Insurance & Reinsurance

Finance & Banking

Manufacturing & Consumer Goods

Construction & Engineering

Aerospace & Defense

Customer Success Stories

Learn how RISKOptimizer has helped analysts and executives improve decision making.

NYC Department of
nyc health logo

Mark Abramovich
Principal, Interdisciplinary Solutions for NYC DOHMH

orange quotes

The key to handling [emergency] events is to acknowledge that our predictive abilities are limited and to study a multitude of possibilities. RISKOptimizer makes it easy to do this, and the results enable organizations to plan for a wide range of scenarios.

Fitness First
fitness first logo

Ross Sharman
Principal, Knowledge Global for Fitness First

orange quotes

Using RISKOptimizer, Fitness First has more confidence in the expected returns of energy efficiency strategies which makes capital sign off easier.

George Washington University
george wachington university

Dr. Emmanuel Donkor
School of Engineering and Applied Sciences (SEAS), George Washington University

orange quotes

RISKOptimizer allows the analyst to incorporate what’s known as probabilistic or chance constraints. This ensures that the risk of defaulting on loan payments, in any given period of the loan tenure is limited.

How RISKOptimizer Is Used

RISKOptimizer has a multitude of applications, including:

man talking with clients

Investment Planning & Portfolio Optimization

Optimize and simulate multiple portfolio assets (such as stocks, bonds, real estate, or projects) to maximize return while minimizing risk. Perform efficient frontier analysis to identify the best portfolio for a given level of risk.
man talking with clients

Supply Chain Management

Optimize multiple suppliers to minimize failure points and maximize probability of deliveries, while simulating uncertain risk factors.

man talking with clients

Inventory & Capacity Planning

Manage inventory more effectively, improve capacity planning, and schedule workforces and equipment use more efficiently - all while simulating risk factors such as customer demand and worker productivity.

man pointing at computer screen

Capital Reserves

Probabilistically forecast and optimize different reserves levels subject to uncertain demands on capital.

man talking with clients

Product and Pricing Mix

Identify the optimal product mix offering and price points to maximize sales subject to uncertainties around demand, production, or other factors.

Investment Planning & Portfolio Optimization

man talking with clients

Investment Planning & Portfolio Optimization

Optimize and simulate multiple portfolio assets (such as stocks, bonds, real estate, or projects) to maximize return while minimizing risk. Perform efficient frontier analysis to identify the best portfolio for a given level of risk.

Supply Chain Management

man talking with clients

Supply Chain Management

Optimize multiple suppliers to minimize failure points and maximize probability of deliveries, while simulating uncertain risk factors.

Inventory & Capacity Planning

man talking with clients

Inventory & Capacity Planning

Manage inventory more effectively, improve capacity planning, and schedule workforces and equipment use more efficiently - all while simulating risk factors such as customer demand and worker productivity.

Capital Reserves

man pointing at computer screen

Capital Reserves

Probabilistically forecast and optimize different reserves levels subject to uncertain demands on capital.

Product and Pricing Mix

man talking with clients

Product and Pricing Mix

Identify the optimal product mix offering and price points to maximize sales subject to uncertainties around demand, production, or other factors.

Key Features

Optimization Under Uncertainty

By running Monte Carlo simulations to account for uncertain conditions, RISKOptimizer provides the best possible solutions to your allocation, budgeting, and scheduling problems.

100% Excel Integration

RISKOptimizer integrates seamlessly with Excel, adding a host of new, native functions that enable you to work in a familiar environment. Furthermore, the Excel integration ensures that the integrity of your modeling logic remains intact, for the most accurate results.

Graphs and Reports

RISKOptimizer analyses are robust, and come with easy-to-understand graphs and reports to enable you to communicate complex results to other stakeholders intuitively. This helps focus discussions on how to make the most of the insights gained.

Follow up from @RISK

Once you have defined uncertain variables and set up Monte Carlo simulation in an @RISK model, you can easily adapt the same model to use RISKOptimizer as a logical next step. Simply tell RISKOptimizer which variables are controllable, and it will optimize your model utilizing the existing @RISK functions already present.

Advanced Solving Engines

RISKOptimizer includes algorithms well-suite for both linear (simpler) and non-linear (more complex) problems. The OptQuest engine integrates a variety of methods into a single composite powerhouse, and the genetic algorithm engine is proven to find the best global solution to more complex, real-life problems.

decision tools logo

Included with The DecisionTools Suite

The complete risk and decision analysis toolkit, including @RISK, PrecisionTree, TopRank, NeuralTools, StatTools, Evolver, RISKOptimizer, and ScheduleRiskAnalysis.

Additional Benefits

Subscription

Your software subscription has you fully covered.

  • Free upgrades when new software versions are released
  • Full access to Technical Support

Support

Technical Support is available to help with installation, operational problems, or errors.

  • Included with subscription
  • Phone, web, or email

Customizable

Leverage the power of RISKOptimize in your own custom application with Palisade Custom Development.

  • Engage Palisade to design your solution
  • Standardize your analyses and reduce learning curves

Join decision-makers around the world who

RELY ON PALISADE.