Customer Demand Profile

Supply Chain Help

Home >

Submit Search

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Customer Demand Profile

Internal Table Name: CustomerDemandProfileIO3

The Customer Demand Profile contains statistics and demand classes for demand reported by scenario-site-product-period. If you have defined a Start Date and/or End Date in the Products table, this lifetime is not reflected in the Customer Demand Profile.

Scenario

Table: CustomerDemandProfileIO3

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Customer Name

Table: CustomerDemandProfileIO3

Internal Name: SiteName

The name of the Customer at which the demand occurs.

Product Name

Table: CustomerDemandProfileIO3

Internal Name: ProductName

The name of the product demanded at the Customer.

Period Name

Table: CustomerDemandProfileIO3

Internal Name: PeriodName

The period in which the demand occurs.

Intermittency

Table: CustomerDemandProfileIO3

Internal Name: Intermittency

Determines how frequently demand happens using the average time between adjacent demand. One of:

Non-Intermittent – when the average time between demand is less than the Intermittency Threshold
Intermittent – when the average time between demand is at or greater than the Intermittency Threshold

Variability

Table: CustomerDemandProfileIO3

Internal Name: Variability

Shows how much demand is varying based on Non-Zero Demand Variability. One of:

Low-Variable – demand is reasonably constant or fluctuating within a small range
Highly-Variable – demand is significantly different from one demand point to another

This field only applies to Intermittent demand and is blank for Non-Intermittent demand.

Demand Class

Table: CustomerDemandProfileIO3

Internal Name: DemandClass

Defines demand as one of four main categories. Intermittency and demand variability in relation to its mean are used to differentiate demand class:

Smooth – Non-Intermittent demand with low variability compared to its mean.
Erratic – Non-Intermittent demand with higher variability compared to its mean.
Slow – Intermittent demand with low variability compared to its mean.
Lumpy – Intermittent demand with higher variability compared to its mean.

Stats Derived From

Table: CustomerDemandProfileIO3

Internal Name: StatisticSource

Provides the source of the Customer Demand Profile statistics; whether the statistics were calculated from Demand or from Orders.

Clumpiness

Table: CustomerDemandProfileIO3

Internal Name: Clumpiness

Further defines Low-Variable Slow demand. Clumpiness indicates how close demand points are to each other. Clumped demand has reasonably constant demand with variability close to zero. Unit-Sized demand has no variability and demand size is always 1.

Demand Class Details

Table: CustomerDemandProfileIO3

Internal Name: DemandClassDetails

Demand Class Details indicates the demand class based on Intermittency, Variability, Demand Class and Clumpiness. This is the class that Safety Stock Optimization uses to determine Lead-Time Demand Distribution. Refer to Class Descriptions for additional information.

Total Demand Qty

Table: CustomerDemandProfileIO3

Internal Name: TotalDemandQty

Total demand quantity calculated from demand mean and period length. Demand in incomplete aggregation levels is not included.

Non-zero Demand Mean

Table: CustomerDemandProfileIO3

Internal Name: NonZeroDemandQtyMean

Average demand size during the period at the given site. This does not include aggregation levels with zero demand.

Non-zero Demand Std Dev

Table: CustomerDemandProfileIO3

Internal Name: NonZeroDemandQtyStdDev

Standard deviation of demand size during the period at the given site. This does not include aggregation levels with zero demand.

Demand Mean

Table: CustomerDemandProfileIO3

Internal Name: DemandQtyMean

Average demand per aggregation levels during the period at the given site.

Demand Std Dev

Table: CustomerDemandProfileIO3

Internal Name: DemandQtyStdDev

Standard deviation of the aggregated demand during the period at the given site.

Inter-Demand Interval Mean

Table: CustomerDemandProfileIO3

Internal Name: DemandIntervalMean

Average number of aggregation levels between two adjacent aggregated demand records in a time series. The beginning and end of the model horizon are included in the calculation of this mean even if there is no demand at these times.

Non-zero Demand CV2

Table: CustomerDemandProfileIO3

Internal Name: COV

The squared coefficient for the variation in demand size. This is the demand variability in relation to its mean. Non-Zero Demand CV2 is derived as:

(Non-Zero Demand Std Dev/Non-Zero Demand Mean)2

Min Non-zero Demand

Table: CustomerDemandProfileIO3

Internal Name: MinDemand

The minimum aggregated demand for the customer-product during the period. This does not take into account zero demand.

Max Non-zero Demand

Table: CustomerDemandProfileIO3

Internal Name: MaxDemand

The maximum aggregated demand for the customer-product during the period.

Aggregation Period Count

Table: CustomerDemandProfileIO3

Internal Name: AggregationPeriodCount

The number of complete aggregation levels (buckets). A complete weekly bucket is from Sunday-Saturday. A complete monthly bucket is from the first to the last day of a particular calendar month.

Demand Count

Table: CustomerDemandProfileIO3

Internal Name: OrderCount

The number of aggregation levels with non-zero demand.

Outliers Count

Table: CustomerDemandProfileIO3

Internal Name: Outliers

The number of aggregated demand records detected as outliers in the period for the site-product.

Potential Revenue

Table: CustomerDemandProfileIO3

Internal Name: PotentialRevenue

The possible revenue based on Total Demand * (Product) Price.

Total Cost

Table: CustomerDemandProfileIO3

Internal Name: CostOfGoods

The total product cost based on the Total Demand * Unit Cost.

Total Weight

Table: CustomerDemandProfileIO3

Internal Name: TotalWeight

The total product weight based on the Total Demand * Weight.

Total Cubic

Table: CustomerDemandProfileIO3

Internal Name: TotalCubic

The total product cube based on the Total Demand * Volume.

Scenario ID

Table: CustomerDemandProfileIO3

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: CustomerDemandProfileIO3

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Friday May 12, 2023

Is this useful?

Yes No