Palisade Corporation
Johnson Graduate School of Management Prof Examines FiveThirtyEight Election Predictions using @RISK

Using @RISK for a Drug Development Decision: A Classroom Example
At Illinois State University, Associate Professor of Finance Domingo Joaquin uses @RISK to demonstrate how simulation modeling can be employed to support the R&D decision of a pharmaceutical firm, illustrating countless risk evaluation examples to students. 

Dr. Joaquin uses the example of the fictitious company “Drugco”, which has just successfully completed Phase I and Phase II clinical trials for a new pharmaceutical, “Newdrug”. Drugco must decide if it should proceed with Phase II, which takes two years to complete and requires an investment of $200 million. At completion of Phase III, a filing is made with the FDA, which then takes a year to assess the efficacy of Newdrug in treating the targeted ailment with acceptable levels of side-effects.

If the FDA approves, Drugco can either sell the rights to the drug for a pre-launch exit value of $400 million, or it can launch production by investing $70 million in fixed assets and $30 million in net working capital.

Clearly there is a great deal of uncertainty facing this hypothetical company, making it a perfect problem for @RISK to analyze. Dr. Joaquin has his students include key inputs, including: drug efficacy; market size and growth; initial and subsequent market share; initial and subsequent cost of goods sold to sales ratio, and terminal EBITDA.

After running these inputs through @RISK, students get histograms that depict key outcomes, including the Net Present Value (NPV), Internal Rate of Return (IRR), as well as the most serious risk drivers and influential inputs, as depicted by a tornado chart.

Dr. Joaquin uses @RISK in his classes to teach examples like the one described above, as well as many others, preferring @RISK over other competing products due to its versatility and power.

@RISK[@RISK] makes the process of simulation
     very easy to do, as opposed to having to
     start the simulation using Excel.
Trial Versions

                        Domingo Joaquin, Associate Professor of Finance
                        Illinois State University

 » Read the Case Study
 » Related paper published in Social Science Research Network
 » More about @RISK
 

Licensing Options

There are three easy ways to get the DecisionTools Suite for your students:

 

Course Licenses available from Palisade. These are economical, annually renewing bulk licenses for both
network lab and laptop installation. Palisade offers a complimentary Live Web Training session to all instructors who order a Course License.
» Learn more

Student Versions from Palisade. These are 12-month versions available for purchase individually by students through either the Palisade web site or the school store.
» Learn more

Textbook Editions available bundled with textbooks.
These are time- and model-limited licenses.
» Learn more

Get DecisionTools Suite 6 for your course by contacting:

AddressPalisade Academic Sales    
800-432-7475 / 607-277-8000
academic@palisade.com

Teaching Tips & Examples

The DecisionTools Suite is a great way to present quantitative techniques in a straightforward, easy-to-understand way for students.

Pricing Products to Maximize Profit
Excerpted from Evolver Solutions for Business,
by Roy L. Nersesian, published by Palisade Corp.

A company makes a product with a maximum plant capacity of 2,000 nominal units per operating period. Marketing research has been conducted on how price affects sales. The conclusion of the study is that everything produced can be sold if the price is low enough and nothing can be sold if the price is high enough. Use the downloadable example file below, in conjunction with Evolver, to walk through an example of how a company would determine what pricepoint to set their products at.

» Download example file and step-by-step instructions

Tech Tip of the Month

Scheduling Rework in a Project

Q:
When a certain task, call it Task 3, is finished, there's a 20% probability that the work may not be acceptable, in which case Task 3 will have to be redone. (The rework might include one or more predecessors of Task 3 too.) How do I set this up with probabilistic branching in @RISK?

Probabilistic branching can go only forward, not backward. You could have a rework task, as a successor to Task 3, and branch around that rework task with probability 100%–20% = 80%. However, there's a more straightforward solution: use a RiskProjectAddDelay function in your Risk Register.

» Download an example file and learn how by visiting
   Palisade's Knowledge Base

Featured White Paper

The DecisionTools Suite is part of complex analyses published in white papers.

Using Simulation to Support the R&D Decision of a Pharmaceutical Firm
Domingo C. Joaquin and Han Bin Kang; June 29, 2014,
'Social Science Research Network'

This paper is at the root of the above featured story. It illustrates how simulation modeling can be employed to support the R&D decision of a pharmaceutical firm. The authors use a simplified but realistic example, where a drug company has just successfully completed the second phase of a three-phase process for assessing the effectiveness of a proposed drug in treating a targeted ailment with acceptable levels of side-effects.

Palisade Corporation  Read the full paper here

Palisade Corporation

The Academic Global Leader in
Risk and Decision Analysis
Palisade Corporation is the world’s leading provider of risk and decision analysis software and solutions. Founded in 1984, its products @RISK and the DecisionTools Suite are used by over 95% of the Fortune 100, in nearly every industry around the world. Palisade is headquartered in New York State, and has offices in London, Sydney, Rio de Janeiro, and Tokyo.

What is The DecisionTools Suite?
The DecisionTools Suite is the world’s only integrated set of risk and decision analysis programs. The Suite includes @RISK for Monte Carlo simulation, PrecisionTree for decision trees, and TopRank for “what if” sensitivity analysis. In addition, DecisionTools Suite comes with StatTools for statistical analysis and forecasting, NeuralTools for predictive neural networks, and Evolver and RISKOptimizer for optimization. All programs work together seamlessly, and all integrate completely with Microsoft Excel for ease of use and maximum flexibility.

The Suite is offered in three affordable and flexible licensing options for those in academia: Student Versions, Course Licenses and Full Academic Versions.

» Schools using Palisade software
»
Textbooks using Palisade software


In This Issue

» Using @RISK for a Drug
   Development Decision:
   A Classroom Example

» Licensing Options

» Teaching Tips &
   Examples

   Pricing Products to
   Maximize Profit

» Tech Tip
   Scheduling Rework in
   a Project

» Featured White Paper
   Using Simulation to Support
   the R&D Decision of a
   Pharmaceutical Firm

» About Palisade and the
   DecisionTools Suite

Keep in Touch
Palisade CorporationPalisade CorporationPalisade CorporationPalisade CorporationPalisade Corporation

Palisade CorporationClick to chat live with
a sales representative

 
Events

2014 Palisade Risk Conferences
An intensive day of networking, software training presented by Palisade trainers and consultants, and real-world case studies presented by industry experts. Join us at an event near you. More dates to come for 2015.
 
» Mumbai:
   13 January

» Johannesburg:
   12 May

» Training Seminars
Asia-Pacific
Brisbane: 28-29 January
Auckland: 10-11 February
Sydney: 24-25 February
Perth: 21-22 April

EMEA
Moscow: 27-29 January
London: 3-5 February
Frankfurt: 9-11 February
Rome: 10-11 February
Dubai: 17-19 February
London: 17-19 March

India
Bangalore: 15-16 Jan

Latin America
Medellín, Colombia:
  28 al 30 de enero
México, DF:
  11 al 13 de febrero
Santiago, Chile:
  24 al 26 de marzo

North America
Houston: 13-15 January
Toronto: 20-22 January
Ottawa: 10-12 February
Atlanta: 17-19 February
Washington DC: 3-5 March
Los Angeles: 10-12 March
Chicago: 14-16 April

» Trade Shows
North America
Society of Petroleum Engineers / ATCE 2015
Houston, TX
28-30 September


EMEA & India
MEOS
Bahrain
9-11 March

PMI Global Congress 2015—EMEA
London
11-13 May

Trial Versions

Palisade software is available in fully functional trial versions. Try @RISK or any of our software today!

The DecisionTools Suite
The complete risk and
decision analysis toolkit

» English
» Español
» Português
» Deutsch
» Français
» 日本語版
» 中文版
» русский

@RISK
The world's most widely
used risk analysis tool
@RISK» @RISK for Excel
@RISK» For Project Management
@RISK» For Six Sigma

PrecisionTree
Visual decision analysis
for spreadsheets

NeuralTools
Sophisticated neural networks for spreadsheets

StatTools
Advanced statistical analysis for spreadsheets

Evolver
The Innovative Optimizer
for Windows


Intel and the Intel logo are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.


Palisade Corporation
©2014 Palisade Corporation, visit www.palisade.com

Palisade Corporation
798 Cascadilla Street, Ithaca, NY 14850 USA, +1 607 277 8000 sales@palisade.com
Palisade Brasil
Av. Presidente Vargas 435, Sala 501, Centro, Rio de Janeiro CEP 20071-001, +55 (21) 2586-6334 vendas@palisade.com
Palisade Europe UK Ltd
31 The Green, West Drayton, Middlesex, UB7 7PN, UK, +44 1895 425050 sales@palisade-europe.com
Palisade Asia-Pacific Pty Limited
Suite 404, L4, 20 Loftus Street, Sydney NSW 2000 Australia, +61 2 9252 5922 sales@palisade.com.au

Palisade Asia-Pacific, Tokyo Office
〒 150-8512 東京都渋谷区桜丘町 26-1 セルリアンタワー15F 電話 03-5456-5287 sales.jp@palisade.com