User Defined Customer Forecast Profile

Internal Table Name: CustomerForecastProfileUserIO3

You can use the User Defined Customer Forecast Profile table along with the Customer Demand table to override statistics and the Demand Class or use it as the primary set of data without using the Customer Demand table.

For additional information, refer to User Defined Forecast Profile.

Period

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: PeriodName

Type: Short Text (100)

Specifies the period at which the forecast demand occurs.

Customer

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: SiteName

Type: Short Text (100)

Specifies the name of the customer or customer group at which forecast demand occurs.

Product

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: ProductName

Type: Short Text (100)

Specifies the product or product group forecast at the given customer.

Non-zero Forecast Mean

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: NonZeroForecastMean

Type: Number (Double)

Average forecast demand size during the period at the given site. 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. This does not include aggregation levels with zero demand.

Non-zero Forecast Std Dev

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: NonZeroForecastStdDev

Type: Number (Double)

Standard deviation of 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: CustomerForecastProfileUserIO3

Internal Name: DemandIntervalMean

Type: Number (Double)

Average number of aggregation levels between two adjacent aggregated 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: CustomerForecastProfileUserIO3

Internal Name: ForecastMean

Type: Number (Double)

Specifies the mean forecast demand during the period at the given customer. 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: CustomerForecastProfileUserIO3

Internal Name: ForecastStdDev

Type: Number (Double)

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

Status

Technology: IO

Table: CustomerForecastProfileUserIO3

Internal Name: Status

Type: Special

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

Internal Name: DemandProfileNotes

Type: Memo

Enter optional descriptive notes about the demand profile.