DRP - Point of Sale Alert Method FAQ

Question: What are the different point-of-sale alert methods used by DRP?

Answer: This is the current list. New standard (and custom) point-of-sale alert methods may be developed to handle the needs of specific situations.

Note The parameter names must be entered exactly as listed for the calculations to work properly. These same parameter names can be used for different point-of-sale alert methods.

Point-of-Sale Alert Method / Program Name	Parameter	Type	Default Value	Description
Trend Alert (methpatapc.p)	This point-of-sale alert method analyzes point-of-sale data and creates point-of-sale alert records when alerts are created in Point of Sale Alert Create.
	Alert Group	Character	Both	This parameter controls whether each forecast group is analyzed individually or in total. You can select one of the following values: Forecast Group - Point-of-sale data for each forecast group is analyzed. Total - The sum of the point-of-sale data for all forecast groups is analyzed. Both - Both the comparisons for the Forecast Group and Total values are performed.
	Alert Option	Character	Both	This parameter controls whether point-of-sale alerts are created for point-of-sale data trending up, down, or both up and down.
	Moving Average Periods	Integer	6	This is the number of periods of history to use to calculate a moving average.
	Time Bucket	Character	Week	This determines the time period used to calculate point-of-sale alerts.
	Trending Down %	Decimal	20	An alert is created if point-of-sale data is trending down by both this percentage and the quantity for the Trending Down Qty parameter.
	Trending Down Qty	Integer	100	An alert is created if point-of-sale data is trending down by both this quantity and the percentage for the Trending Down % parameter.
	Trending Up %	Decimal	20	An alert is created if point-of-sale data is trending up by both this percentage and the quantity for the Trending Up Qty parameter.
	Trending Up Qty	Integer	100	An alert is created if point-of-sale data is trending up by both this quantity and the percentage for the Trending Up % parameter.

Example The following is an example of when an alert would be triggered for downward trending if using 5 for the Moving Average Periods parameter, 0 for the Trending Down Qty parameter, and leaving the default Trending Down % parameter value of 20.

	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6	Period 7	Period 8	Period 9
Actual Sales	100	110	95	85	90	80	75	82	65
5-Period Moving Average					96	92	85	82	78
(Actual Sales) - (5-Period Moving Average)					-6	-12	-10	0	-13
Percentage of Actual Sales					-7%	-15%	-13%	0%	-21%

In period 9, a point-of-sale alert is created because the percentage of actual sales is down 21%.

The following is an example of when an alert would be triggered for upward trending if using 5 for the Moving Average Periods parameter value, 0 for the Trending Up Qty parameter, and setting the Trending Up % parameter value to 15.

	Period 1	Period 2	Period 3	Period 4	Period 5	Period 6	Period 7	Period 8	Period 9
Actual Sales	92	95	105	103	110	115	112	121	142
5-Period Moving Average					101	106	109	112	120
(Actual Sales) - (5-Period Moving Average)					9	9	3	9	22
Percentage of Actual Sales					8%	8%	3%	7%	15%

In period 9, a point-of-sale alert is created because the percentage of actual sales is up 15%.