---
title: "About Stock Level Management"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28412290/About%20Stock%20Level%20Management"
format: markdown
---
# Overview

> Macro (excerpt)
> 
> The **Stock Level Management (SLM)** feature has been designed to help you better manage your branch stock's minimum and maximum levels. 
> 
> **Important: **The Stock Level Management Module requires version 5.15 or newer. 
> 
> These minimum and maximum stock levels are calculated through the following process and then applied to each product via the [Stock Forecasting Update](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391532) scheduled task:
> 
> 1. Products are ranked based on their sales performance over the past 12 months.
> 2. The ranked products are then assigned to defined percentile groups and given a performance category.
> 3. The system calculates the average daily sales based on product sales over an assigned period.
> 4. The new minimum and maximum stock levels are calculated based on the **Min Days** and **Max Days** respectively assigned to each performance category
> 
> The task can be scheduled to make the changes to your minimum and maximum stock levels as often as you need however this is typically run once a month.
> 
> > ✅ Refer to <u>[Min/Max Stock Calculation](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28412296)</u> for more information.
> 
> Once your product's branch stock minimum and maximum levels have been set, using the [Stock Reordering Scheduled Task](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28384718) you can automate the requisition process to provide you with more accurate recommendations. This ensures you are ordering the right amount of stock, maximising your dollar.

# The Stock Level Management Modules

## 1. Min/Max Forecasting

> Macro (excerpt)
> 
> The **Min/Max Forecasting Maintenance **screen allow you to define the:
> 
> - **Percentile groups** and **performance categories** to be applied to your products based on their sales performance rankings over the last 12 months.
> - **Minimum** and **Maximum Days** used to calculate the new minimum and maximum stock levels. A product's average daily sales figure is multiplied by the number of days defined in these fields
> - **Minimum Quantities **required to make sure that stocked products are always on hand. So, if the calculated value is less than the minimum quantity defined for the stock performance category the stock forecasting algorithm will overwrite a branch product's minimum or maximum quantities.
> 
> The values defined here are then used by the Stock Forecasting Update scheduled task when the method **Days** is selected,  to calculate and updated each products branch stock minimum and maximum levels.

> ✅ Refer to the <u>[Min/Max Forecasting Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409312)</u> User Manual for more information.

---

## 2. Seasonal Weighting

> Macro (excerpt)
> 
> The **Seasonal Weighting Maintenance **screen allows you to set a **weighting percentage** to **product groups or subgroups** from an elected **supplier** over a **specified period**. This can be included to account for any significant changes that may occur during a certain time of the year and applies to the minimum and maximum quantity of a product.
> 
> The values defined here are then used by the Stock Forecasting Update scheduled task when the method **Seasonal** is selected, to calculate and updated each products branch stock minimum and maximum levels.

> ✅ Refer to the <u>[Seasonal Weighting Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391522)</u> User Manual for more information.

---

## 3. Stock Forecasting Update Task

> Macro (excerpt)
> 
> The **Stock Forecasting Update** scheduled task automatically updates the minimum (Min) and maximum (Max) stock levels for each product at each branch. It uses the setup defined in either <u>[Min/Max Forecasting Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28409312)</u> or <u>[Seasonal Weighting Maintenance](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391522)</u>, depending on which forecasting method is selected.

> ✅ Refer to the  <u>[Stock Forecasting Update](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28391532)</u> User Manual for more information.

---

# Additional Information

> ✅ Refer to <u>[Purchase Requisition Stock Reorder Batches via Scheduled Task](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28403414)</u> for more information on applying these changes to your requisitions.