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.

Overriding global defaults on a tank-by-tank basis

To override the global Sales Model adjustment settings for a specific tank:

  1. Go to Maintenance > Commodity Forecast Setup.
    The Commodity Forecast Setup window opens.

  2. In the Company field at the top left of the window, enter the store’s ID.

  3. Tab out of the field or click image2 Open.

  4. Locate the tank for which you want to override the default settings.

    image3

  5. 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:

      1. You must enter a value for each of the days set in the [InventoryService]TrendAdjustDaysBack setting.

      2. 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.

      3. The total must equal 1.

  6. Click image4 Save.