Use of Capacity in Service Scheduling in Microsoft Dynamics CRM

Colin Maitland, 04 November 2015

In this article I will demonstrate the use of Capacity when using the Service Scheduling Engine in Microsoft Dynamics CRM. I will demonstrate this using the example of a Service for the delivery of a one day “Service Scheduling Training” course. This example is similar to a scenario demonstrated in the Microsoft IT Academy hosted 80710 Customer Service in Microsoft Dynamics CRM 2015 Update 1 training course.

In my example the following resources are required:

  • 1 Trainer and 1 Training Room must be selected from the same Site.
  • The selected Trainer must have a Skill Level of at least 7. [1]
  • The selected Training Room must have at least 8 seats. [2]

[1] The Skill Level of each Trainer is a value between 1 and 10 defined by the business.
[2] The Service Scheduling Course is only delivered to classes of 8 or more students.

Also in my example:

  • Service Scheduling Training may be provided in two locations; i.e. Auckland and Brisbane. These are configured as Sites.
  • There are a several Trainers with various skill levels located in Auckland and Brisbane. These are configured as Users.
  • There are several Training Rooms with either 6 seats or 12 seats located in Auckland and Brisbane. These are configured as Resources/Equipment.

The following images show the configuration for one of the Trainers. The Site field defines their location, e.g. Auckland Office; and the Capacity field under Work Hours defines their Skill Level, e.g. 10.

image

image

image

The following images show the configuration for a one of the Training Rooms. The Site field defines the location, e.g. Auckland Office; and the Capacity field under Work Hours defines the Number of Seats, e.g. 12.

image

 

image

image

There are five trainers of which four have the business defined skill level required to deliver the Service Scheduling Training. They have been configured as shown in the following table and have been added to a Resource Group named Trainers.

image

There are four training rooms of which three have the minimum number of seats required to deliver the Service Scheduling Training. These been added to a Resource Group named Training Rooms.

image

The following table and images show the configuration of the Service and related Selection Rules used to select Trainers and Training Rooms for the delivery of the Service Scheduling Training. The Selection Rules are configured to ensure the following business rules are observed.

image

image

When defining the Training Rooms Selection Rule it is important to configure both the Quantity and the Capacity Required; i.e. Number of Seats as shown in the following image.

image

When defining the Trainers Selection Rule it is important to configure both the Quantity and the Capacity Required; i.e. Skill Level as shown in the following image.

image

As a result of this configuration, when the Scheduling Engine is used we should expect to see only the combinations of Trainers and Training Rooms shown in the following table. Notice that Judith Walker is not selected because her Skill Level (Capacity) is below 7 and Training Room A1 is not selected because its Number of Seats (Capacity) is below 8. In addition Trainers located in Auckland are not selected along with Training Rooms located in Brisbane and vice versa because they are located at different Sites.

image

The following image shows some of the available times and resources that have been selected by the Scheduling Engine for training at the Auckland Office on the Morning of 21/08/2015 for selected Customers. As desired, only Trainers and Training Rooms from the Auckland Office, Trainers with a skill level of 7 or higher and Training Rooms with 8 or more seats are selected.

image

In summary, for this configuration to work it was important to configure the Capacity in the following locations:

  • Trainers (Users): Work Hours, Capacity
  • Training Rooms (Resources/Equipment): Work Hours, Capacity
  • Service: Selection Rules, Capacity Required

The meaning of Capacity is defined by the business. In this example the meaning of the Capacity for Trainers was their Skill Level and for Training Rooms was Number of Seats.

Finally, an alternative to using Capacity to define the Skill Level of the Trainers is to instead add the Trainers into Skill Level specific Resource Groups and configure the Selection Rules to select Trainers based on Resource Group rather than Capacity.