Site Demand Profile

Internal Table Name: FacilityDemandProfileIO3

The Site Demand Profile table contains statistics and the demand class at all facilities including upstream sites. The profile of customer-facing sites includes both customer demand and the portion of demand from other facilities. This information is reported by scenario-site-product-period.

The Site Demand Profile table displays the Demand Class based on the currently selected Aggregation Level. However, the Inventory Policy Summary shows Demand Class based on daily aggregation.

Scenario

Table: FacilityDemandProfileIO3

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

The scenario for which the output data was generated.

Site Name

Table: FacilityDemandProfileIO3

Internal Name: SiteName

The name of the site at which the demand was handled.

Product Name

Table: FacilityDemandProfileIO3

Internal Name: ProductName

The name of the demanded product at the site.

Period Name

Table: FacilityDemandProfileIO3

Internal Name: PeriodName

The period in which the demand occurs.

Stats Derived From

Table: FacilityDemandProfileIO3

Internal Name: StatisticSource

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

Intermittency

Table: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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.
The Site Demand Profile table displays the Demand Class based on the currently selected Aggregation Level. However, the Inventory Policy Summary shows Demand Class based on daily aggregation.

Clumpiness

Table: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

Internal Name: DemandQtyMean

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

Demand Std Dev

Table: FacilityDemandProfileIO3

Internal Name: DemandQtyStdDev

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

Inter-Demand Interval Mean

Table: FacilityDemandProfileIO3

Internal Name: DemandIntervalMean

Average number of aggregation levels between two adjacent aggregated demand records in a time series.

Non-zero Demand CV2

Table: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

Internal Name: MinDemand

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

Max Non-zero Demand

Table: FacilityDemandProfileIO3

Internal Name: MaxDemand

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

Aggregation Period Count

Table: FacilityDemandProfileIO3

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: FacilityDemandProfileIO3

Internal Name: OrderCount

The number of aggregation levels with non-zero demand.

Outliers Count

Table: FacilityDemandProfileIO3

Internal Name: Outliers

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

Potential Revenue

Table: FacilityDemandProfileIO3

Internal Name: PotentialRevenue

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

Total Cost

Table: FacilityDemandProfileIO3

Internal Name: TotalCost

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

Total Weight

Table: FacilityDemandProfileIO3

Internal Name: TotalWeight

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

Total Cubic

Table: FacilityDemandProfileIO3

Internal Name: TotalCubic

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

Scenario ID

Table: FacilityDemandProfileIO3

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: FacilityDemandProfileIO3

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?