User Defined Site Forecast Profile

Internal Table Name: FacilityForecastProfileUserIO3

Use the User Defined Site Forecast Profile as an override to the calculated statistics and Demand Class. The use case for the user-defined site demand is to do overrides at a single echelon only and has no effect on upstream propagation.

For additional information, refer to User Defined Forecast Profile.

For User Defined Site Forecast Profile records that are included, if the Sites or Products referenced in the profile records are excluded (Status = Exclude in the Sites or Products tables), Demand Analysis will generate an error.

Period

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: PeriodName

Type: Short Text (100)

Specifies the period at which the demand occurs.

Site

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: SiteName

Type: Short Text (100)

Specifies the name of the site or site group at which demand occurs.

Product

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: ProductName

Type: Short Text (100)

Specifies the product or product group demanded at the given site.

Non-zero Forecast Mean

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: NonZeroForecastMean

Type: Number (Double)

Average forecast demand size during the period at the given site. This does not include aggregation levels with zero demand. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Non-zero Forecast Std Dev

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: NonZeroForecastStdDev

Type: Number (Double)

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

Inter-Demand Interval Mean

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: DemandIntervalMean

Type: Number (Double)

Average number of aggregation levels between two adjacent aggregated forecast demand records in a time series. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Forecast Mean

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: ForecastMean

Type: Number (Double)

Specifies the mean forecast demand during the period at the given site. The mean is calculated as per a normal distribution of forecast demand. Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used.

Forecast Error

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: ForecastStdDev

Type: Number (Double)

Specifies the standard deviation of the forecast demand during the period at the given site. The standard deviation is calculated as per a normal distribution of forecast demand.

Demand Class

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: DemandClassDetails

Type: Short Text (50)

One of Smooth, Erratic, Slow-LowVariable, Slow-HighlyVariable, Lumpy.

Specifies the classification of forecast demand for the product at the site in a multi-echelon model.

Status

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

The status field defines whether this profile record will be included or excluded during Demand Analysis and Safety Stock Optimization runs.

Default: Include

Notes

Technology: IO

Table: FacilityForecastProfileUserIO3

Internal Name: DemandProfileNotes

Type: Memo

Enter optional descriptive notes about the demand profile.

Last modified: Wednesday May 15, 2024

Is this useful?