Supplier Sheets

These sheets cover all information related to suppliers, including their groupings, settings and their product related data.

Supplier Definition

Purpose: List all suppliers involved.
Instructions: Enter the name of all suppliers you want to use in the model. If you want to use a different name for displays, you can use the Description column.

Supplier Groups

Purpose: For each supplier, you can determine which group it belongs to.
Instructions: Assign suppliers to their respective groups by filling in the Supplier column with the appropriate group and entering the supplier that belongs to that group in the SubSupplier column. Each subsupplier must be in a different row and the Active column must be set to 1.

Supplier

Purpose: Define supplier-related data.
Instructions: Enter data specific to suppliers, like:

  1. Availability (Available)

  2. Capacity data (Capacity Attributes)

  3. Cost data (Cost Attributes)

  4. Opening/Closing data (Open/Close Attributes)

  5. Minimum/Maximum # of Open Suppliers (Count Constraint Attributes)

  6. Custom Objectives data (How to use Custom Objectives?)

If you want to define data for suppliers on this sheet you have to fill in the Supplier, Location, Step, and Period columns for each supplier you want to use in the model.

Supplier Product

Purpose: Define product-related data for suppliers.
Instructions: Enter product details for each supplier, like:

  1. Availability (Available)

  2. Capacity data (Capacity Attributes)

  3. Cost data (Cost Attributes)

  4. Opening/Closing data (Open/Close Attributes)

  5. Supplier Lead Time (End-to-End (E2E) Lead Time Attributes)

  6. Period Offset (Lead Time Offset Attributes)

  7. Custom Objectives data (How to use Custom Objectives?)

You can define data only for suppliers which availability was set on Supplier sheet. If you want to define data on this sheet you have to fill in the Product, Supplier, Location, Step, and Period columns for each supplier you want to use in the model.

Supplier Ratio

Purpose: You can set ratio constraints related to suppliers.
Instructions: Fill in the first 8 columns and define the Minimum/Maximum ratio or both. You can read more about ratio constraints in Ratio Constraints, and see the attribute details at Ratio Constraint Attributes.