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