Export (0) Print
Expand All

Walkthrough: Adding a Random Parameter to Create a Stochastic Model

Solver Foundation 3.0

You can use the simulation framework in Solver Foundation to convert a model to a stochastic model. By adding a random parameter, you can create a more realistic model.

To add data to an Excel spreadsheet

  1. In the Solver Foundation ribbon, click Model to display the Modeling Pane.

  2. In the Excel worksheet, enter the following data. The following table lists the carrying capacity per month for each type of plane for each route (in thousands).

    Route

    ID

    Miles

    Demand

    Std.Dev

    Price

    NY-LA

    0

    2475

    250

    5

    520

    NY-SF

    1

    2300

    120

    5

    520

    NY-Dallas

    2

    1381

    180

    5

    280

    NY-Houston

    3

    1439

    90

    2

    280

    NY-Boston

    4

    185

    600

    5

    40

To add a random parameter to a model

  1. Select the five rightmost columns, including the column name.

  2. In the Sets tab, click New.

  3. For the Name, type Route.

  4. In the Parameters tab, click New, and then click Random Parameter, and then Distribution Parameter.

  5. For the Name, type DemandRandom.

  6. In the Distribution drop-down menu, select Normal.

  7. Next to Binding, click the […] ellipsis button.

    The Binding Editor appears.

  8. Verify that the range in the Table/Range text box is correct.

  9. In the Mean drop-down menu, select Demand.

  10. In the Standard Deviation drop-down menu, select Std.Dev.

  11. In the Set column, select Route.

  12. In the Columns column, select ID.

  13. Click OK.

Show:
© 2014 Microsoft