Customer Attributes
Demand
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means there is no demand)
- How it affects the model
The amount of demand for each customer, location, product and period combination. This amount should be fulfilled at least in the given Minimum Fulfillment Rate.
Lead Time
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
Lead time is maximal amount of driving time between your last resource and your customer. It is basically the time taken to complete your last mile and it does not consider the times in the rest of your network.
Selling Price
- Sheets on which it appears
- Possible inputs
Any number greater than 0 (0 means not defined)
- How it affects the model
Selling Price for a customer, location, product, period combination. It is considered as a revenue.
Customer
Product
Demand
Selling Price
Inbound Volume
Revenue
Customer
product_1
3
5
3
3*5=15
Minimum Fulfillment Rate
This attribute is only available in the Network Design Advanced and in the Tactical Planning Modules.
- Sheets on which it appears
- Possible inputs
Any number between 0 and 1 (0.5 means 50%)
- How it affects the model
This amount should be fulfilled at least in the given Minimum Fulfillment Rate. When you want the model to take into account, the Allow Unfulfilled Demand on Control Panel.
Minimum Lead Time Adherence
- Sheets on which it appears
- Possible inputs
Any number between 0 and 1 (0.5 means 50%)
- How it affects the model
This attribute determines what percentage of demand for a given customer, location, product, period combination must be fulfilled within the lead time. For Infeasibility Analysis it can happen that you need to relax both “Lead Time” and “Minimum Lead Time adherence” to get the model feasible.
Customer
Product
Demand
Minimum Lead Time Adherence
Volume within lead time
Volume outside the lead time
Customer
product_1
10
0.6
6
4