This page shows the distribution center disaggregation from customer to location.

You can use this page to view distribution center disaggregation at product and location level. Use the right-hand context selector dropdown to select the customer. 

You can input values for customer to-location DC disaggregation calculations in Edit Parameters. When parameters are changed in Edit Parameters, they're reflected in the Effective Parameters.

Note: 

  • You can override values in the table. If there is no Override (%) but the Effective Override (%) has a value, then that'll be the result of the persistency parameter.
  • Rebalanced Disaggregation (%) should always total 100%.

Customer Level Disaggregation %s chart

This stacked chart shows the disaggregation percentages over time. In this chart, you can track the disaggregation percentage of a customer demand to various distribution centers customer is being served.

Note: Use legends to view information for any specific customer. Select or deselect a legend to show or hide its details in the chart.

For example, when you select History Time Range as the Disaggregation basis:

  • Consider the set of shipments to customer X over the last four periods.
  • Set parameters as: 
    • Disaggregation Basis: History Time Range. 
    • Disaggregation Time Range: 2 Periods.
    • Disaggregation Calculation Level: Customer x Product Level, other than Product B where it's been set to Customer Level. 
    • Minimum Allowable %: 5%.
  • Product A has enough history to calculate the percentages.
  • Product B has enough history to calculate the percentages, but the parameter selection is for it to use the Customer Level values.
  • Product C doesn't have enough history to calculate the percentages, so it falls back to ‌customer level values. 
  • Product D has enough history to calculate the percentages, but for one DC it's below the threshold so is omitted, and its amount rebalanced across the remaining DCs. 

Overrride Customer to DC Disaggregation

Use this table as an option to override the default disaggregation calculations. When one location's disaggregation percentage is changed, the difference of percentages is split across other locations so that the rebalanced disaggregation total is 100%.

An example of a rebalanced disaggregation percentage calculation is:

  • Set override of California Disaggregation percentage to 1%.
  • The system calculates the weightage of the remaining DCs.
  • Rebalanced disaggregation = Weightage (Disaggregation % / Sum of all disaggregation excluding the overrides) * remaining disaggregation percentage (100%-1% = 99%).
  • The rebalanced disaggregation% is calculated to be 100%. 

Parameters

Parameter nameDescription
Disaggregation basis

Default process for establishing the disaggregation percentages.

  • History Time Range: uses historic shipment data to determine which distribution centers have shipped to the customer.
  • Fixed Disaggregation: manual entry of the disaggregation percentages.
  • Even Split: evenly spread across all distribution centers that are available to the customer.
Disaggregation Time rangeNumber of past periods to analyze to determine profile of historic shipments. It's only required when Disaggregation Basis is set to History Time Range.
Disaggregation Calculation Logic

Historic shipment percentages are calculated at the:

  • Customer level: distribution centers that have shipped to the customer.
  • Customer x Product level: distribution centers that have shipped the product to the customer.
Minimum Allowable %

A minimum threshold, below which any calculated percentages are ignored. It prevents any small percentages from being calculated due to one-off past shipment activity.  

This parameter applies to the percentages calculated using the History Time Range disaggregation basis. Percentages below the threshold arising from overrides are allowed.

Override Perpetuation Behavior

Determines whether and how overrides are allowed to perpetuate. 

  • Do Not Perpetuate Overrides: the overrides only apply in the period in which it's input.
  • Perpetuate Until Location Has New Override: the override will continue until the location is next overridden. 
  • Perpetuate Until Any Location Has New Override: the override will continue until any location is next overridden. 
Effective ParametersCurrent parameters based on which the disaggregation is calculated. 

Validation Error shows the number of disaggregation errors. Errors can be checked on the D3120 –Disaggregation Validation Errors page.

Steps

To view customer to location disaggregation details:

  1. Select customer from the customer right-hand context selector dropdown .
  2. In Edit Parameters, choose from the Disaggregation Basis dropdown.
  3. Enter the value in Disaggregation Time Range.
  4. Choose from the Disaggregation Calculation Logic dropdown.
  5. Enter the value in Minimum Allowable %.
  6. Choose from the Override Perpetuation Behavior dropdown.
  7. Disaggregation based on the input values is calculated in Effective Parameters.
  8. View the disaggregation percentages over time in the Customer Level Disaggregation %s chart.
  9. View options to override the default disaggregation calculations in the Disaggregation Override table.