Module: Settings

Executive summary

To run STOCK efficiently and correctly, a user has to setup several parameters.The Settings section enables the user to set everything up and get the most reliable and relevant outputs possible.

It is possible to set up:

  • Cart Settings - adding and modifying Carts for buyers
  • Holidays Settings - setup of working days and holidays
  • ABC Methods Settings - criteria for ABC segmentation
  • Multi-method ABC Settings – setting and modifying combined methods
  • Overstock Identification Settings – identifying overstock in specific ABC segments
  • Container Settings – adding or modyfying container types
  • Adjustment of Extremes Settings – parameters for automated cleanup of outlying values
  • Periodical Ordering Settings – ordering parameters of suppliers, redistribution, supplier groups, products or warehouses
  • Safety Stock Settings - parameters for calculation of safety stock
  • User Settings – change of name, username, password
  • Postponed demant after stockout settings
  • Service Level settings
  • Forecast Adjustment – manual adjustment of demand forecast
  • Predecessor/Successor settings
  • WACC - settings of costs of storing and cost of capital

Functional description

Note: the settings are not generally bound to the level of aggregation (hierarchy – Tree module)

Cart Settings

A new Cart needs a title and settings of visibility and editability for other users. A Cart is always editable by the user who created it.

image0

You can edit title, viewability and editability of a Cart.

Holidays Settings

All holidays when stores are closed (no sales, no ordering, no deliveries) are arranged from top to bottom. A user can change date, type of holiday and add a comment.

There is a separate list for each year. The year can be selected from a drop down.

image1

Adding new holiday can be done using the fields below the list.

image2

ABC Methods Settings

Methods and combinations of methods (multi methods) for ABC segmentation can be set here.

Marking a method as default means that STOCK will use it for decision in all calculations where ABC segments are taken into account.

Some methods can be parametrized by length and type of period for which it is relevant.

image3

Multi-method ABC Settings

A multi-method is a combination of more simple methods into one. Partial methods need to be assigned a weight.

Existing methods can be modified, new methods can be added.

image4

It is possible to add an entirely new method.

image5

Overstock Identification Settings

The overstock must be identified (multiple Module: Overstock identification). For clarity of overstocks that are significant for the enterprise, it is necessary to specify from what level of surplus stock will be referred to as overstock. For example, 5 pieces of goods with a price of CZK 10 from A segment have almost no effect on the efficiency for the enterprise. Therefore, the user can set so that such insignificant overstocks are not displayed and thus increase usability of STOCK.

image6

Container Settings

The user can add a new container. Existing containers can be edited or deleted.

Ticking the Active box allows STOCK to use this container for its calculations. Without the Active box selected, the container serves only as a template.

image7

Adjustment of Extremes Settings

STOCK uses historical data to calculate the forecast. These may contain extremes that would negatively affect the accuracy of the forecast. For example, a large one-time purchase from a customer who will probably never arrive again.

Extreme values are adjusted according to the size of the deviation from the mean value (purchase size).

The larger the quantile is set, the greater the percentage of values that will be preserved.

image8

Periodical ordering settings - suppliers

Suppliers can be assigned frequency of ordering (period), ordering limits ans specific delivery days.

image9

There can also be a set of exceptions under which conditions will periodical ordering not take place. For each you can set a period, ordering days and a supplier, product and warehouse combination for which the exception is set.

image10

Periodical ordering settings - redistribution

Periodical ordering settings for redistribution is functionally identical to settings for suppliers. Same form is used.

Groups of suppliers

Supplier groups cen be set up for easier bulk settings of parameters for periodical ordering.

image11

New group can be named and assigned relevant suppliers.

image12

Groups of products

Product groups can be created and defined for easier settings of periodical ordering parameters.

image13

A new group needs to get a name and selected product that are grouped.

A group can be defined either by listing individual products or using categories (which makes finding specific product easier.

image14

Groups of warehouses

Groups of warehouses (stores) can be defined for easier settings of periodical ordering parameters.

image15

Name the new group and assign relevant warehouses.

image16

Safety Stock Settings

The safety stock is kept to balance delayed supply, daily variability of sales and forecast inaccuracies. If the user wishes to ommit some risks from the calculation of safety stock, this settings are the place to do it.

image17

image18

User Settings

The user can change their name, surname and login (username) and password for STOCK directly in the app.

image19

Note: Using this form, new password will be saved into the database as a hash.

Postponed demant after stockout settings

We can set up how much will stock be ordered/bought after a stockout. In other words, the chance that the demand will rise when items are replenished after a stockout.

image20

Forecast adjustment

The user can manually adjust the forecast based on the internal knowledge of influencing factors. They can for example delete extremes caused by planned stockout or unexpected sales.

image21

Predecessor/Successor settings

image23

Optional setting of a relation for a product that will replace another product in the assortment/inventory. This can also be set up using import data interface (SIDI). In such case, these settings are not available in STOCK GUI.

WACC

For correct evaluation of const connected with keeping stock and other investments it is necessary that STOCK knows the cost of storing and the cost of company’s capital.

image22