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.
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.
Adding new holiday can be done using the fields below the list.
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.
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.
It is possible to add an entirely new method.
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.
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.
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.
Periodical ordering settings - suppliers¶
Suppliers can be assigned frequency of ordering (period), ordering limits ans specific delivery days.
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.
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.
New group can be named and assigned relevant suppliers.
Groups of products¶
Product groups can be created and defined for easier settings of periodical ordering parameters.
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.
Groups of warehouses¶
Groups of warehouses (stores) can be defined for easier settings of periodical ordering parameters.
Name the new group and assign relevant warehouses.
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.
User Settings¶
The user can change their name, surname and login (username) and password for STOCK directly in the app.
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.
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.
Predecessor/Successor settings¶
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.