Hello, Please excuse me for requesting help with what is likely a very simple linear programming problem. Attached is an example SAS data set with the number of staff needed each hour. What I would like to do is optimize the staff schedule with certain constraints (that could be changed in the future) primary with respect to shift length. For example shifts should be a minimum of 4 hours long (increasing in increments of 2 hours), and a maximum shift length of 12 hours. Shift start times should either be at the top of the hour or the bottom of the hour. My goal is to set up a macro that will generate a schedule for each day uniquely, 365 days per year based on the calculated workload for each hour. Does anyone have any suggestions? If this problem would be better solved using an approach other than linear programming please make recommendations. In case you are wondering this data represents the nurse staffing needs in a emergency department for a given day. Any thoughts or suggestions appreciated. Thanks, Kevin
... View more