Input Template Sheet |
Attribute |
Mode of Transport |
Product |
Bill of Material |
Supplier |
Production |
Warehouse |
Customer |
Location |
Period |
---|---|---|---|---|---|---|---|---|---|---|
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 |
||||||
Supplier |
Minimum Capacity |
x |
x |
x |
||||||
Supplier |
Maximum Capacity |
x |
x |
x |
||||||
Supplier |
Variable Cost |
x |
x |
x |
||||||
Supplier |
Variable Cost is for all steps |
x |
x |
x |
||||||
Supplier |
Open as Group |
x |
||||||||
Supplier |
Limit Openings |
x |
||||||||
Supplier |
Maximum Openings |
x |
||||||||
Supplier |
Limit Closings |
x |
||||||||
Supplier |
Maximum Closings |
x |
||||||||
Supplier |
Minimum # of Open Suppliers |
x |
x |
x |
||||||
Supplier |
Maximum # of Open Suppliers |
x |
x |
x |
||||||
Supplier Product |
Minimum Capacity |
x |
x |
x |
x |
|||||
Supplier Product |
Maximum Capacity |
x |
x |
x |
x |
|||||
Supplier Product |
Variable Cost |
x |
x |
x |
x |
|||||
Supplier Product |
Variable Cost is for all steps |
x |
x |
x |
x |
|||||
Supplier Product |
Force Open |
x |
x |
x |
x |
|||||
Supplier Product |
Open as Group |
x |
||||||||
Supplier Ratio |
Minimum Ratio |
x |
x |
x |
x |
|||||
Supplier Ratio |
Maximum Ratio |
x |
x |
x |
x |
|||||
Production |
Minimum Capacity |
x |
x |
x |
||||||
Production |
Maximum Capacity |
x |
x |
x |
||||||
Production |
Variable Cost |
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 |
||||||
Production Routing |
Minimum Capacity |
x |
x |
x |
x |
|||||
Production Routing |
Maximum Capacity |
x |
x |
x |
x |
|||||
Production Routing |
BOM Variable Cost |
x |
x |
x |
x |
|||||
Production Routing |
Force Open |
x |
x |
x |
x |
|||||
Production Routing |
Open as Group |
x |
||||||||
Production Routing Ratio |
Minimum Ratio |
x |
x |
x |
x |
|||||
Production Routing Ratio |
Maximum Ratio |
x |
x |
x |
x |
|||||
Warehouse |
Minimum Capacity |
x |
x |
x |
||||||
Warehouse |
Maximum Capacity |
x |
x |
x |
||||||
Warehouse |
Variable Cost |
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 |
||||||
Warehouse Product |
Minimum Capacity |
x |
x |
x |
x |
|||||
Warehouse Product |
Maximum Capacity |
x |
x |
x |
x |
|||||
Warehouse Product |
Variable Cost |
x |
x |
x |
x |
|||||
Warehouse Product |
Variable Cost is for all steps |
x |
x |
x |
x |
|||||
Warehouse Product |
Force Open |
x |
x |
x |
x |
|||||
Warehouse Product |
Open as Group |
x |
||||||||
Warehouse Ratio |
Minimum Ratio |
x |
x |
x |
x |
|||||
Warehouse Ratio |
Maximum Ratio |
x |
x |
x |
x |
|||||
Inventory Product |
Minimum Capacity (Inventory) |
x |
||||||||
Inventory Product |
Maximum Capacity (Inventory) |
x |
||||||||
Inventory Product |
Variable Cost (Inventory) |
x |
||||||||
Inventory Product |
Target (Inventory) |
x |
||||||||
Transport Cost |
Take Or Pay Volume |
x |
x |
x |
x |
|||||
Transport Cost |
Take Or Pay Fixed Cost |
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 |
Minimum Capacity |
x |
x |
x |
x |
|||||
Transport Cost |
Maximum Capacity |
x |
x |
x |
x |
|||||
Transport Cost |
Force Open |
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 |
Cost Per UOM |
x |
x |
x |
x |
|||||
Stepwise Transport Cost |
Variable Cost is for all steps |
x |
x |
x |
x |
|||||
Stepwise Transport Cost |
Force Open |
x |
x |
x |
x |
|||||
Transport Ratio |
Minimum Ratio |
x |
x |
x |
x |
|||||
Transport Ratio |
Maximum Ratio |
x |
x |
x |
x |
|||||
Customer Product Data |
Minimum Lead Time Adherence |
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 |