Input Template Sheet |
Attribute |
Period |
Product |
Resource |
Customer |
Location |
Supplier |
Transportation Mode |
Bill Of Material |
|---|---|---|---|---|---|---|---|---|---|
Location Product |
Maximum # of Source Locations |
x |
x |
x |
|||||
Location Product |
Maximum # of Destination Locations |
x |
x |
x |
|||||
Location Product |
Minimum # of Open Locations |
x |
x |
x |
|||||
Location Product |
Maximum # of Open Locations |
x |
x |
x |
|||||
Production Routing |
Minimum Capacity |
x |
x |
x |
x |
||||
Production Routing |
Maximum Capacity |
x |
x |
x |
x |
||||
Production Routing |
Force Open |
x |
x |
x |
x |
||||
Production Routing |
BOM Variable Cost |
x |
x |
x |
x |
||||
Production Routing |
Open as Group |
x |
|||||||
Production BOM |
Minimum Capacity |
x |
x |
x |
x |
||||
Production BOM |
Maximum Capacity |
x |
x |
x |
x |
||||
Production BOM |
Force Open |
x |
x |
x |
x |
||||
Production BOM |
BOM Variable Cost |
x |
x |
x |
x |
||||
Production BOM |
Open as Group |
x |
|||||||
Transport Cost |
Cost Per Distance |
x |
x |
||||||
Transport Cost |
Cost Per Trip |
x |
x |
||||||
Transport Cost |
Minimum Load Size |
x |
x |
||||||
Transport Cost |
Maximum Load Size |
x |
x |
||||||
Transport Cost |
Minimum # of Trips |
x |
x |
||||||
Transport Cost |
Maximum # of Trips |
x |
x |
||||||
Transport Cost |
Minimum Capacity |
x |
x |
x |
x |
||||
Transport Cost |
Maximum Capacity |
x |
x |
x |
x |
||||
Transport Cost |
Base Case Volume |
x |
x |
x |
x |
||||
Transport Cost |
Base Case Minimum Capacity |
x |
x |
x |
x |
||||
Transport Cost |
Base Case Maximum Capacity |
x |
x |
x |
x |
||||
Transport Cost |
Force Open |
x |
x |
x |
x |
||||
Transport Cost |
Take Or Pay Volume |
x |
x |
x |
x |
||||
Transport Cost |
Take Or Pay Fixed Cost |
x |
|||||||
Supplier Product |
Variable Cost |
x |
x |
x |
x |
||||
Supplier Product |
Minimum Capacity |
x |
x |
x |
x |
||||
Supplier Product |
Maximum Capacity |
x |
x |
x |
x |
||||
Supplier Product |
Force Open |
x |
x |
x |
x |
||||
Supplier Product |
Variable Cost is for all steps |
x |
x |
x |
x |
||||
Supplier Product |
Open as Group |
x |
|||||||
Warehouse Product |
Variable Cost |
x |
x |
x |
x |
||||
Warehouse Product |
Minimum Capacity |
x |
x |
x |
x |
||||
Warehouse Product |
Maximum Capacity |
x |
x |
x |
x |
||||
Warehouse Product |
Force Open |
x |
x |
x |
x |
||||
Warehouse Product |
Variable Cost is for all steps |
x |
x |
x |
x |
||||
Warehouse Product |
Open as Group |
x |
|||||||
Warehouse Product |
Maximum Inventory Cover |
x |
x |
x |
|||||
Warehouse Product |
Minimum Inventory Cover |
x |
x |
x |
|||||
Inventory Product |
Minimum Capacity (Inventory) |
x |
x |
x |
x |
||||
Inventory Product |
Maximum Capacity (Inventory) |
x |
x |
x |
x |
||||
Inventory Product |
Target (Inventory) |
x |
x |
x |
x |
||||
Inventory Product |
Target Violation Cost (Inventory) |
x |
x |
x |
x |
||||
Inventory Product |
Variable Cost (Inventory) |
x |
|||||||
Stepwise Transport Cost |
Cost Per UOM |
x |
x |
x |
x |
||||
Stepwise Transport Cost |
Minimum Capacity |
x |
x |
x |
x |
||||
Stepwise Transport Cost |
Maximum Capacity |
x |
x |
x |
x |
||||
Stepwise Transport Cost |
Force Open |
x |
x |
x |
x |
||||
Stepwise Transport Cost |
Variable Cost is for all steps |
x |
x |
x |
x |
||||
Supplier |
Variable Cost |
x |
x |
x |
|||||
Supplier |
Minimum Capacity |
x |
x |
x |
|||||
Supplier |
Maximum Capacity |
x |
x |
x |
|||||
Supplier |
Variable Cost is for all steps |
x |
x |
x |
|||||
Supplier |
Open as Group |
x |
|||||||
Supplier |
Minimum # of Open Suppliers |
x |
x |
x |
|||||
Supplier |
Maximum # of Open Suppliers |
x |
x |
x |
|||||
Supplier |
Limit Openings |
x |
|||||||
Supplier |
Maximum Openings |
x |
|||||||
Supplier |
Limit Closings |
x |
|||||||
Supplier |
Maximum Closings |
x |
|||||||
Production |
Variable Cost |
x |
x |
x |
|||||
Production |
Minimum Capacity |
x |
x |
x |
|||||
Production |
Maximum Capacity |
x |
x |
x |
|||||
Production |
Variable Cost is for all steps |
x |
x |
x |
|||||
Production |
Open as Group |
x |
|||||||
Production |
Limit Openings |
x |
x |
||||||
Production |
Maximum Openings |
x |
x |
||||||
Production |
Limit Closings |
x |
x |
||||||
Production |
Maximum Closings |
x |
x |
||||||
Production |
Minimum # of Open Productions |
x |
x |
x |
|||||
Production |
Maximum # of Open Productions |
x |
x |
x |
|||||
Warehouse |
Variable Cost |
x |
x |
x |
|||||
Warehouse |
Minimum Capacity |
x |
x |
x |
|||||
Warehouse |
Maximum Capacity |
x |
x |
x |
|||||
Warehouse |
Variable Cost is for all steps |
x |
x |
x |
|||||
Warehouse |
Open as Group |
x |
|||||||
Warehouse |
Limit Openings |
x |
x |
||||||
Warehouse |
Maximum Openings |
x |
x |
||||||
Warehouse |
Limit Closings |
x |
x |
||||||
Warehouse |
Maximum Closings |
x |
x |
||||||
Warehouse |
Minimum # of Open Warehouses |
x |
x |
x |
|||||
Warehouse |
Maximum # of Open Warehouses |
x |
x |
x |
|||||
Supplier Ratio |
Minimum Ratio |
x |
x |
x |
x |
||||
Supplier Ratio |
Maximum Ratio |
x |
x |
x |
x |
||||
Warehouse Ratio |
Minimum Ratio |
x |
x |
x |
x |
||||
Warehouse Ratio |
Maximum Ratio |
x |
x |
x |
x |
||||
Production Routing Ratio |
Minimum Ratio |
x |
x |
x |
x |
||||
Production Routing Ratio |
Maximum Ratio |
x |
x |
x |
x |
||||
Transport Ratio |
Minimum Ratio |
x |
x |
x |
x |
||||
Transport Ratio |
Maximum Ratio |
x |
x |
x |
x |
||||
Customer Product Data |
Minimum Fulfillment Rate |
x |
x |
x |
x |
||||
Customer Product Data |
Maximum # of Source Locations |
x |
x |
x |
x |
||||
Customer Product Data |
Minimum Lead Time Adherence |
x |
x |
x |
x |