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.

The easiest way to assign a working hour calendar, is to assign calendar to all operations and resources in that location. 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.

When resources or operations with different working hours exist within the same location, you can use the operation.avaialble or resource.location fields to define the working hours on a more detailed level.

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 manufacturing operations are running on weekdays (Monday through Friday) from 8am till 5pm with a lunch break of an hour. The manufacturing site is also not working on Christmas, December 25th.

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

The manufacturing operation takes also 48 hours, but due to the working hours it lasts much longer. The manufacturing 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.