Working hours

Each location is associated with a working hour calendar through the field location.available.

A value 0 of the calendar buckets indicates unavailable time. Other values (typically 1) indicate available time.

To apply the right working hour calendar, it is important to assign a location to each operation and resource. Use the field operation.location to stretch the duration of an operation to consider the non-working hours. Use the field resource.location to represent the off-shift hours on the resources.

It is fine to leave theses fields empty, which indicates 24 by 7 availability. If the fields are populated, you should populate them consistently. You’ll run into strange situations when planning an operation in location A that loads a resource in location B using another calendar.


Excel spreadsheet calendar-working-hours

The attached example models a warehouse where the replenishment operations are running on weekdays (Monday through Friday) from 8am till 5pm with a lunch break of an hour. The warehouse is not working on Christmas, December 25th.

In the resulting plan, the shipping operation is available 24-by-7: it takes 48 hours, and is planned to last exactly 48 hours.

The replenishment operation takes also 48 hours, but due to the working hours it lasts much longer. The replenishment ends right before the Christmas break starts at 24/12/2014 17:00:00 and uses 8 hours available time on the following days: 24/12/2014, 23/12/2014, 22/12/2014, 19/12/2014, 18/12/2014 and 17/12/2014. The replenishment thus starts on 17/12/2014 08:00:00.