Setting up the system to perform ongoing Sales Model adjustments
First available in Inventory Services 16.40
A sales model is available for each of a store’s forecasted products. It compares the actual product sales from the previous week with the projected sales for the current week. The sales model is based on the product’s commodity forecast setup, its daily tank readings, and completed orders. The model provides information that the Inventory Services Forecaster uses as it generates orders.
An important characteristic of an Inventory Services Sales Model is that by default, it is a static model.
In addition to updating sales models automatically from time to time with recent sales data, or updating them manually, you can track daily sales increases/decreases. This makes the forecaster responsive to rapid changes in sales, improving its accuracy.
Globally, you can:
-
Activate the adjustment feature for all tanks
-
Set the change percentage for all tanks
-
Set the number of days back the system looks for changes for all tanks
-
Set a weighted average for all tanks
You can override these global defaults on a tank-by-tank basis for each store.
Setting up the Sales Model adjustment global defaults
By default, the system does not automatically adjust the Sales Model. However, you can set up the system to adjust it automatically. These TTS50 settings control the default global functionality.
-
[InventoryService]EnableTrendAdjust
This setting activates sales model trend adjustments. -
[InventoryService]TrendAdjustPercent
This setting specifies the allowable difference between the current sales numbers and the sales model. If there is an increase or decrease more than this amount, the system will adjust the sales model to reflect the current trends. -
[InventoryService]TrendAdjustDaysBack
This setting determines the number of days back the system looks for changes for all tanks. -
[InventoryService]TrendAdjustweightedAvgSection
This setting determines the weighted average given to the sales amounts for the number of look back days you have specified. -
[InventoryService]UseDefaultTrendAdjustValues
By default, when trend adjustments are enabled, the system applies global settings to all tanks. If you want, you can use this setting to ignore the global values. This allows you to monitor some tanks but not all.
Overriding global defaults on a tank-by-tank basis
To override the global Sales Model adjustment settings for a specific tank:
-
Go to Maintenance > Commodity Forecast Setup.
The Commodity Forecast Setup window opens. -
In the Company field at the top left of the window, enter the store’s ID.
-
Tab out of the field or click Open.
-
Locate the tank for which you want to override the default settings.
-
Make changes to these columns as needed:
-
TrendPercent
Enter the new change percentage value. -
DaysBack
Enter the number of days in the past that you want the system to look for changes to tanks. -
DaysBackDistribution
Enter the new weighted average for the number of days listed in the DaysBack column.Notes:
-
You must enter a value for each of the days set in the
[InventoryService]TrendAdjustDaysBack
setting. -
If you are tracking on a tank-by-tank basis, the number of days is specified in the DaysBack field. The field is found in the Commodity Forecast Setup window.
-
The total must equal 1.
-
-
-
Click Save.