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.
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.
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.
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