Enabling Automatic Trend Calculations

For seasonal products, use an automatic trend calculation to regulate the demand forecast. The system calculates and applies a trend based on recent demand compared to the previous year's demand. Trend is represented as a percentage increase or decrease to the calculated demand.

Define the automatic trend parameters on the Auto Trend Percentage Maintenance screen.

In addition to setting automatic trend parameters at the product level, you can also set these parameters at the branch or buy line level. Parameters set at the product level override those set at the buy line and system level.

Note: The following procedure is a manual process for a single product. Use the Mass Load program to enter inventory parameters to groups of products.

To enable the automatic trend calculation for a product:

From the Files menu, select Product to display the Product Maintenance screen.
Select a product.
Use the Inven hot key to display the Primary Inventory Maintenance screen.
Use the Forecast Params hot key to display the Forecast Parameters Maintenance screen.
Use the Forecast hot key to display the Forecast Parameters screen.
Use the Hierarchy hot key to select a branch.

Note: Use the Find hot key as necessary to locate a branch that is in the list, but not in the viewable area. Use Alt-Insert to add a branch or territory to the list. The new branch or territory inherits the settings of the previous entry. Use Alt-Delete to remove a branch or territory from the list.

In the Auto Trnd column corresponding to the branch or territory where you want to calculate trend for seasonal products, type Y.
Use the Auto Trend hot key to display the Auto Trend Percentage Maintenance screen.
Complete the following fields for the branch or territory where you want to calculate trend:

Field	Value
Max Decrease%	The maximum negative trend to apply to the demand forecast for the product. This parameter only applies to seasonal products with the Auto Trend flag enabled.
Max Increase%	The maximum positive trend to apply to the demand forecast for the product. This parameter only applies to seasonal products with the Auto Trend flag enabled.

Press Esc to save changes and return to the previous screen.
Exit Product Maintenance for changes to take effect.