Customer Sheets

These sheets include details about customers and their associated data, including customer groups and product-specific details.

Customers

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

Customer Groups

Purpose: For each customer, you can determine which group it belongs to.
Instructions: Assign customers to their respective groups by filling in the Customer column with the appropriate group and entering the customer that belongs to that group in the SubCustomer column. Each subcustomer must be in a different row and the Active column must be set to 1.

Customer Product Data

Purpose: Specify product data related to customers.
Instructions: Enter details for each customer, including:

  1. Demand (Customer Attributes)

  2. Lead Time (Customer Attributes)

  3. Variable Cost (Cost Attributes)

  4. Selling Price (Customer Attributes)

  5. Rate Card Drop Size (Rate Card Attributes)

  6. Minimum Fulfillment Rate (Customer Attributes)

  7. Maximum # of Source Locations (Optimization Parameters and Constraints)

  8. Custom Objective data (How to use Custom Objectives?)

You can read more about the different types of attributes in Customer Attributes.