MR_button_depletion.bmp Depletion Calculation

MR_dice_icon.jpg Download a complete copy of this risk analysis resource for free here.

See also: ModelRisk functions and windows, Vose Ruin

image1100.gif

 

Introduction

MR_window_Depletion_1.jpg
The Depletion Calculation window
from ModelRisk

With the Depletion Calculation window you can model the depletion of resources by a given time horizon.

This is modeled with costs of variable amount (Claim size distribution) occurring randomly in time (Claim interval distribution).

If the resources are depleted before the set time horizon, the shortfall (i.e. additional sources needed to pay the last incoming payment event) is calculated as well.

The output of this calculation consists of three parts:

To see the output functions of this window, click here.

Window elements

MR_window_Depletion_3.jpgIn the Source data region, four parameters can be specified.

In the ClaimInterval field, the Distribution Object to model the time interval between payment events can be specified. Typically (and by default), this is an exponential distribution.

In the ClaimSize field, the Distribution Object to model the size of payments can be specified. By default this is a lognormal distribution.

three outputs are shown, as they are under this generated scenario:

These outputs will be inserted as a 3x2 array in the spreadsheet, upon pressing OK.

MR_window_Depletion_4.jpg

For explanations about other fields, buttons, graphs and summary statistics tables in this window, see Common elements of ModelRisk windows.

Useful tips and tricks

See also: Graphics, workflow and error handling in ModelRisk

Using View Function to return to a window

The output of ModelRisk windows always corresponds to VoseFunctions (the functions ModelRisk adds to Excel) being entered into one or more spreadsheet cells.

You can always re-open the window for a ModelRisk function that is in a spreadsheet cell by using View Function. Select the spreadsheet cell and then select View Function from the ModelRisk menu/toolbar/ribbon.