Materials Planning & Demand Planning - StockTrim Inventory Control

Customer Forecasts Now Available

Written by Dominic Sutton | Sep 13, 2021 3:55:25 AM

Good news, the eagerly awaited Customer Forecasting feature set is now available. Forecast and predict your customers future requirements, and recommend order quantities to them.

  • Ensure that you have enough stock on hand to meet your customers’ future requirements
  • Ensure your customers have enough stock on hand to meet their requirements, without ordering excess
  • Gain your customers respect as a valued supplier by help each of each of them optimize their inventory.

It’s really easy. Once everything’s set up (see below for the guide), just select the customer on the order plan to see their specific forecasts.

Bring up the demand analysis for each product to see and adjust the calculations of:

  • The forecasted demand
  • Their optimal stock levels

What about Current Stock Levels?

We envisage this may not be needed in most cases since many businesses will not have a full visibility of their customers inventory levels.

You can still track your customers inventory levels in StockTrim – simply enter this in the Demand Analysis, to enable the full calculation of the optimal order quantities.

Customer in the sales history view

When viewing any item’s demand analysis on the order plan, you can also see the customer in the sales history view

Getting Started

To get started, take the following steps:

  1. Enable the module, under global settings

  1. Import customers. This can be done either from your API connected system (simply select the option on the load data screen), OR imported via CSV under the “Customers” section – follow the on screen instructions for the template and example.

  1. Select the customers to include in the forecasts. Not all customers will be included by default (since many businesses, especially retailers, would only need forecasts for a few key customers, not every customer).

  1. Reload your entire sales history. Your existing sales data will not have any customers recorded against it, so your entire sales history (up to 24 months) will need to be re-imported into StockTrim so that the forecasts can be calculated by customer. If you use an API connected system that records customers, select the “Refresh sales history” option. If you import via CSV, reload your sales orders in via another CSV file with the “CustomerCode” column populated (which should match the customer codes imported in step 2 above). See the file format under the “Load Data” screen.

  1. Once all the data is uploaded, including your sales history refresh, see the forecasts per customer by selecting the customer filter on the order plan.

If you would like a demo, then please enquire here.