Model Feature Overview

This section contains a list of constraints and limits that you can enforce in the model. It also includes instructions on how you can activate a particular constraints/limitation and what data you need to provide to use this.

Note

This list is under construction, so existing model features will be added to this list from time to time. Please check with support if you have any questions about certain model features that are not yet documented.

Customers

You limit the number of resources that can serve a group of products and locations. This allows you to indicate, for instance, that the demand for all “Slow Moving Products” in the “State of New York” must be served by at most 2 resources. If you want to use this functionality, you need to check the wizard question “Include maximum number of resources that can serve demand by product and location group” and provide data for the attribute “Maximum # of Resources” on sheet “Product Location Data”.

Resources

You can indicate that all resources at one location need to open and close simultaneously. This allows you to indicate, for instance, that all five resources in a certain location must either be all open or all closed. You cannot have that some resources are open, and some are closed. If you want to use this functionality, you need to check wizard question “Include ability to make open and close decision by location” and provide data for the attribute “Location Open/Close” on sheet “Location Period Data”.

You can indicate which mode of transportation each resource can use. This allows you to specify that resource X can ship using “LTL” and “Parcel Carrier”, while resource Y can only ship using “LTL”. If you want to use this functionality, you need to check wizard question “Include which mode of transportation can be handled by which resource” and provide data for the attribute “Mode Allowed In” and/or “Mode Allowed Out” on sheet “Trans Type Resource Data”.

You can indicate that you want to restrict DC capability by product. This allows you to indicate that resource X can only handle product group “A” and “B”. If you want to use this functionality, you need to check the wizard option “Define DC Capability by Resource & Product”. If you also want to include capacity limits by product, you need to check the options “Define maximum DC Throughput capacity by DC Facility & Product” and “Define minimum DC Throughput capacity by DC Facility & Product”. The new attributes “Available (DC)”, “Minimum Capacity (DC)” and “Maximum Capacity (DC)” will appear on sheet “DC Product Data”.

It is also possible to define DC capacity for a group of products. To use this functionality, you need to check wizard options “Define DC Capability by Resource & Product” and “Enable Product Grouping”, after which you can check the option “Enable option to consider DC capacity by Product for Product Groups”. The new attribute “Capacity for Product Group (DC)” will appear on sheet “DC Product Data”.

Transportation Cost Using Drop Size and Distance Based Rate Cards

There are various ways to provide transportation cost based on the lanes. The model currently supports these types:

  • Cost Per Distance

  • Cost Per THU

  • Fixed Cost Per Trip

  • Minimum Cost Per Trip

  • Take or Pay Fixed Cost

  • Take or Pay Volume

  • Take or Pay Volume for Product Group

  • Cost functions generated using the secondary transportation app

There is another method, which uses rate cards which specify cost per THU for different distance/drop size bands. The model uses that information to determine the transportation cost that is needed for a particular lane.

Note

Transportation Cost via Rate Cards only works for secondary and direct transportation (last-mile). It will be ignored for all other transportation lanes such as primary and inter-resource transport.

If you want to use Rate Cards, you need to set the switch for the Data Navigator wizard statement “Include rate cards to describe part of the transportation costs” to true. In that case, data navigator tells you that you need to provide the following attributes:

  • Drop Size Lower: The lower bound of the drop size for this band in specified unit

  • Drop Size Upper: The upper bound of the drop size for this band in specified unit, 0 means unlimited

  • Distance Lower: The lower bound of the distance for this band in the given distance UOM”

  • Distance Upper: The upper bound of the distance for this band in the given distance UOM”, 0 means unlimited

  • Cost Per THU: The cost per unit of this lane in currency (e.g. $) per specified unit”

In addition, the demand needs to be specified differently. You need to include the average drop size for the demand as well. You can specify demand for the same customer/product combination for as many weight breaks as you need. The model will now figure out, for every potential secondary transportation lane, the appropriate transportation cost to incur given the distance / drop size band that the demand falls into.