The SPcapPlan01.lng Model

-

View the model
Download the model

 Capacity Planning with Random Demand 
 Get input from, and send results to an open spreadsheet,
  see for example, spreadsheet, SPCapPlan.xlx.
Stage 0:  We decide what capacities to install 
          at four places(technologies, e.g. coal,
          gas, wind, nuclear).						
Stage 1, Beginning:
           Demands at three locations are revealed,						
Stage 1, End: 
           We satisfy demand at minimum cost 
          (by solving a transportation problem).

Optimal Obj = 381.8533;

Keywords:

Stochastic Programming | Transportation Model | Uncertainty | Capacity Planning | Scenario Planning | LINGO | Excel | @OLE | EVPI | Recourse | Spreadsheet interface | Sequential decisions |