Fabricante do software líder mundial em análise de risco e de decisão
Complex Business Modeling Made Easy
By Charles Seiter
May 1999
Reviewed in

May 1999

If you're trying to model complex business situations, Excel's Solver function will get you only so far; traditional risk-optimization products like @RISK and Evolver (see New Products, November 1998) take you a bit further. RISKOptimizer, from the maker of @RISK and Evolver, handles scheduling, equipment usage, and financial and other problems that cannot readily be crunched with conventional risk-optimization software. For instance, it could allow a shop to use staffing costs and its sales records to determine the best business hours. Scheduling studies in RISKOptimizer could also use time-based estimates of traffic jams, rather than simple distance, to plan optimal routes.

In a plain Excel model, you use single numbers for all variables to come up with a simple result--for example, Profit = Income ­ Expense. Classic tools like Solver let you plug in a range of values for variables to optimize the result. RISKOptimizer incorporates probability data, so you get not only a range of results but also an assessment of the most likely outcomes. The ability to optimize using actual data from business records as well as most-likely values of inputs (while adjusting statistically for other possible values) makes RISKOptimizer a better tool than its predecessors

The product demands hefty processing power: In my tests with a shipping copy, small problems with ten adjustable cells took a minute or so to process at 300 MHz. But this beats the weeks you'd need using simple spreadsheets to calculate scheduling, portfolio, distribution, or other problems. This Excel add-in costs more than Excel itself, and it's serious, MBA-level software. But it's easy to learn, and for many business problems, it's the most practical power tool around.

PRO: Uniquely versatile business problem­solver that is surprisingly easy to learn.
CON: Puts serious number-crunching demands on hardware
VALUE: Easily pays for itself on complex problems.

Para obter mais informações, entre em contato com:

Randy Heffernan
Tel: +1 607-277-8000
Fax: +1 607-277-8001

Palisade Brasil
Praia de Botafogo,
nº 501 Sala 101, Botafogo
22250-000 Rio de Janeiro-RJ
+55 (21) 3958 1443
+1 607 277 8000 x318 tel
800 432 7475 x318 E.U.A.
800 432 RISK (US/Can)
+1 607 277 8000
Palisade EMEA & India
+44 1895 425050
Palisade Asia-Pacific
+61 2 8249 8239
Palisade アジア・
+81 3 5456 5287 tel
Palisade Latinoamérica
+1 607 277 8000 x318
800 432 RISK (EEUU/Canadá)
+1 607 277 8001 fax
+54 (11) 5252-8795 Argentina
+56 2581-3492        Chile
+507 836-5675        Panamá
+52 55 5350 2852   México
+51 1 708-6781       Perú
+57 1 508-5187       Colombia