Customer Demand Summary

Supply Chain Guru X 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 Summary

Internal Table Name: OptimizationOutputAggregatedDemand

This output table summarizes demand details per customer and product per period.

Scenario

Table: OptimizationOutputAggregatedDemand

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

The scenario for which the summary data was generated.

Customer Name

Table: OptimizationOutputAggregatedDemand

Internal Name: CustomerName

The name of the customer demanding the product in the period.

Product Name

Table: OptimizationOutputAggregatedDemand

Internal Name: ProductName

The name of the product being demanded.

Period Name

Table: OptimizationOutputAggregatedDemand

Internal Name: PeriodName

The name of the period to which these demand statistics apply.

Organization Name

Table: OptimizationOutputAggregatedDemand

Internal Name: OrganizationName

The Organization to which the aggregated demand is allocated. When there is demand at Customers that belong to the Organization, this demand is attributed to the Organization as required.

Demand Status

Table: OptimizationOutputAggregatedDemand

Internal Name: DemandStatus

This column indicates if the demand is served or unserved in this period.

Total Demand

Table: OptimizationOutputAggregatedDemand

Internal Name: TotalDemand

The total demand by this customer for this product during this period.

Served Demand

Table: OptimizationOutputAggregatedDemand

Internal Name: ServedDemand

The customer demand units that were served for this product during this period.

Unserved Demand

Table: OptimizationOutputAggregatedDemand

Internal Name: UnservedDemand

The customer demand units that were not served for this product during this period. This is the demand that was not filled in this period related to the Total Demand quantity. Assume that you have a total demand of 100 units. In the first period, 20 units of demand are filled and the Unserved Demand is 80. In period 2, another 20 units of demand are filled and the Unserved Demand is 60. Finally, in period 3, 60 units of demand is served. The Unserved Demand is 40, since we are comparing to the Total Demand.

Percentage Total Demand Fulfilled

Table: OptimizationOutputAggregatedDemand

Internal Name: PercentageTotalDemandFulfilled

Of the total customer demand for this product during the period, this is the percentage of that demand that was served. Assume that you have a total demand of 100 units. In the first period, 20 units of demand are filled and the Percentage Total Demand Fulfilled is 20. In period 2, another 20 units of demand are filled. The Percentage Total Demand Fulfilled is 20 once again. Finally, in period 3, 60 units of demand is served. The Remaining Demand Quantity is 60.

Potential Revenue

Table: OptimizationOutputAggregatedDemand

Internal Name: PotentialRevenue

The revenue for the total customer demand quantity of this product during this period. It is based on the Unit Price in the Products table or the Unit Price Override in the Customer Demand or Customer Orders table.

Potential Revenue = Total Demand * (Product Unit Price or Demand/Orders Unit Price Override)

Actual Revenue

Table: OptimizationOutputAggregatedDemand

Internal Name: ActualRevenue

The revenue for the customer demand quantity of this product served during this period. It is based on the Unit Price in the Products table or the Unit Price Override in the Customer Demand or Customer Orders table.

Actual Revenue = Served Demand * (Product Unit Price or Demand/Orders Unit Price Override)

Lost Revenue

Table: OptimizationOutputAggregatedDemand

Internal Name: LostRevenue

The revenue that was lost based on the unserved customer demand quantity of this product during this period. It is based on the Unit Price in the Products table or the Unit Price Override in the Customer Demand or Customer Orders table.

Lost Revenue = Unserved Demand * (Product Unit Price or Demand/Orders Unit Price Override)

Fulfillment ID

Table: OptimizationOutputAggregatedDemand

Internal Name: OrderID

The Fulfillment ID as defined in the Customer Demand or Customer Orders table for this demand.

Priority

Table: OptimizationOutputAggregatedDemand

Internal Name: Priority

The Priority as defined in the Customer Demand or Customer Orders table for this demand.

Demanded Period

Table: OptimizationOutputAggregatedDemand

Internal Name: DemandedPeriod

In the Customer Demand or Customer Orders table, this is the period the demand was requested. It is compared to the period in which the order was fulfilled to determine on-time, early or late delivery classification.

Received Period

Table: OptimizationOutputAggregatedDemand

Internal Name: PeriodNo

The number of the period in which this demand is received.

Periods Late

Table: OptimizationOutputAggregatedDemand

Internal Name: PeriodsLate

If demand was filled after the requested period, this is the number of periods after the Demanded Period the order was filled. Demand can only be served late if the Periods Allowed Late in Customer Demand or Time Allowed Late in Customer Orders is populated.

Periods Early

Table: OptimizationOutputAggregatedDemand

Internal Name: PeriodsEarly

If demand was filled before the requested period, this is the number of periods prior to the Demanded Period the order was filled. Demand can only be served early if the Periods Allowed Early in Customer Demand or Time Allowed Early in Customer Orders is populated.

Remaining Demand Quantity

Table: OptimizationOutputAggregatedDemand

Internal Name: RemainingDemandQuantity

This is the total demand fulfilled to date by Customer/Period(Fulfilled)/Product/OrderID/Priority/DemandedPeriod. This is supported when the demand can be split across periods by allowing early or late demand. Assume that you have a total demand of 100 units. In the first period, 20 units of demand are filled and the Remaining Demand Quantity is 80. In period 2, another 20 units of demand are filled. Now the Remaining Demand Quantity is 60. Finally, in period 3, 60 units of demand is served. The Remaining Demand Quantity is now 0.

Late Demand Penalty Cost

Table: OptimizationOutputAggregatedDemand

Internal Name: LateDemandPenaltyCost

This is the total penalty cost for being late if the delivery occurred after the requested date. You define the Late Delivery Penalty Cost in the Customer Demand/Customer Orders tables. It is calculated as number of units late * (Late Delivery Penalty Cost * (Late Delivery Cost Inflation Factor ^ (Periods Late-1)))

Early Demand Penalty Cost

Table: OptimizationOutputAggregatedDemand

Internal Name: EarlyDemandPenaltyCost

This is the total penalty cost for being early if the delivery occurred before the requested date. You define the Early Delivery Penalty Cost in the Customer Demand/Customer Orders tables. It is calculated as number of units early * (Early Delivery Penalty Cost * (Early Delivery Cost Inflation Factor ^ (Periods Early-1)))

Total Unserved Demand Penalty Cost

Table: OptimizationOutputAggregatedDemand

Internal Name: TotalUnservedDemandPenaltyCost

This is the total penalty cost for missed demand when the full requested quantity is unmet. It is reported only in final acceptable demand period. If no demand is served in the final allowed period and remaining demand is present, the record displays 0 fulfilled quantity with the relative penalty calculated as Unserved Demand * Unit Penalty Cost. You define the Unit Penalty Cost in the Customer Demand/Customer Orders tables. This is incurred in the last period when the demand is allowed to be served; that is the demand date plus the number of late periods allowed (based on Periods Allowed Late in Customer Demand or Time Allowed Late in Customer Orders).

Total Demand Penalty Cost

Table: OptimizationOutputAggregatedDemand

Internal Name: TotalDemandPenalty

The penalty incurred for demand for the customer demand that is fulfilled late, fulfilled early, or unfulfilled. It is calculated as the sum of Total Late Demand Penalty Cost + Total Early Demand Penalty Cost + Total Unserved Demand Penalty Cost..

Scenario ID

Table: OptimizationOutputAggregatedDemand

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputAggregatedDemand

Internal Name: StepNumber

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

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No