New to SAS - Staffing Optimization - max work hours per day and max work hours per week

smithge — Fri, 26 Oct 2018 16:50:03 GMT

Hello,

I am new to writing optimization models in SAS Enterprise Guide, but have experience in other software.

I am trying to achieve the following:

Objective Function: Minimize the number of full time employees (FTE)

Constraints:

FTE hours worked per day b/w 4-7 hours

FTE hours worked per week <= 37.5 hours

FTE days worked per week <= 5 days

The FTE need data we have:

FTE needed by hour by day

Special note:

The number of hours needed to cover differ by day. Example, need to cover more hours on Friday than Tuesday.

The hours per day needed to cover are greater than 7.

Thanks for any help in getting this started or getting me pointed in the right direction!

Re: New to SAS - Staffing Optimization - max work hours per day and max work hours per week

RobPratt — Mon, 29 Oct 2018 23:47:52 GMT

See this other post for an example.