Example Models

@RISK Features

This simple model illustrates how the RiskSimtable function can be used for a quick sensitivity analysis on an input. The year 1 price in cell C3 drives future prices, as well as current and future sales, and hence revenues. The RiskSimtable function lets you see how the outputs, the yearly revenues, vary for different initial prices.

This simple model illustrates one way to model a cost that might occur in any of the next 12 months. There are three inputs: (1) a Bernoulli random variable that indicates whether an event will occur in the next year; (2) a discrete random variable that indicates the month when the event occurs (if it occurs at all); and (3) a Pert random variable that indicates the cost if the event occurs. The outputs include monthly costs and the NPV of these costs.

This model extends the previous model so that an event is possible in each of the 12 months. Now the inputs include (1) a Bernoulli random variable for each month that indicates whether an event occurs that month; and (2) a Pert random variable that specifies the cost in that month if an event occurs. In addition, the model includes correlations between event occurrences and between monthly costs.

This model is another variation of the two previous models. Now any number of events (up to a maximum) can occur during the year, and a discrete distribution over the months indicates when each of the events occurs. Then for each of these events, a discrete distribution generates the month of occurrence. Finally, the costs for all events are generated from a Pert distribution, and the model builds in weak correlations (0.25) between these costs.

This model illustrates the RiskResultsGraph function for creating (non-interactive) graphs of specified inputs or outputs when a simulation is run.

This model simulates the daily expenses of a business traveler who faces uncertainty each day on whether he makes a trip, and if so, the miles, miles per hour, miles per gallon, and price per gallon for the trip. Its outputs are total cost and total hours driven for a month, and it uses the RiskCollect function to enable sensitivity analysis of these outputs to "inputs" of interest, such as the average miles per gallon per trip.

130 East Seneca Street
Suite 505
Ithaca, NY 14850
800 432 RISK (US/Can)
+1 607 277 8000
+1 607 277 8001 fax
+61 2 8249 8239
パシフィック東京事務所
+81 3 5456 5287 tel
+1 607 277 8000 x318
+54-1152528795  Argentina
+56-25813492 Chile
+507-8365675 Panamá
+52 55 5350 2852 México
+511-7086781 Perú
+57-15085187 Colombia