Operations Research topics: SAS/OR,
SAS Optimization, and SAS Simulation Studio

Resource Constraints using Proc CLP

Reply
SAS Employee
Posts: 1

Resource Constraints using Proc CLP

I need some advice.   I am using 14.2

 

I have a scheduling problem which is solved using Proc CLP.  It utilises the ACTDATA,  RESDATA data sets.  I need to add a number of constraints to when resources are available as described below.

 Scenario 1

Resource A is not available on day  2 and therefore Resource A cannot be assigned  to any activity that is scheduled over that period.

Scenario 2.

The resources assigned for use on Activity A must also be assigned to Activity B.  Using the data below, if the resource VANCOVER is assigned to Activity AA2, then resource VANCOVER must also be assigned to activity AB2.

 

ACTIVITY DATA

ACTIVITY             SUCCESSOR        DURATION          RESOURCE          QTY

AA1                        AA3                        12                           CANADA              1

AA2                        AA3                        20                           UK                        1

AA3                        AB2                        30                           CANADA              1

AA4                        AB3                        30                           CANADA              1

AB2                        AB3                        20                           CANADA              1

AB3                                                      10                           UK                        1

 

RESOURCE DATA

RESOURCE          CAPACITY            POOL                     SUBQTY

LONDON              1                              UK                          1

EDINBURGH         1                              UK                          1

VANCOVER          1                              CANADA                1

CALGARY             1                              CANADA                1

 

How can I add these constraints to the problem using Proc CLP or should the model be reworked  using Proc OPTMODEL.

SAS Employee
Posts: 7

Re: Resource Constraints using Proc CLP

Hi!

 

The first scenario can be addressed by introducing an activity "X" with the sole purpose of using up resource "LONDON" on day 2:

 

proc clp schedtime=schedtime schedres=schedres;
activity X = (dur=1 SGE=2 FLE=3);
RESOURCE (LONDON);
REQUIRES X = (LONDON);
run;

 

This scenario can also be handled by proc. CPM, using resource calendars, activity calendars, or the resource input data set to specify the resource level.

 

The second scenario is what we have called a "REQUIRESSAME" constraint. Adding this constraint to CLP is a requirement that is under review for implementation in a future release.

 

Thanks!

Lindsey

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 69 views
  • 0 likes
  • 2 in conversation