To avoid stock-outs, you want to determine the buffer stock needed to cover future sales?
Use the "Cadencier" app to anticipate your growing inventory needs!
This app keeps track of stocks and volumes of expected inputs and outputs, enabling you to calculate theoretical requirements over a given period, based on a consumption rate.
By installing the cadencier app, you can define your product consumption requirements for a forthcoming period.
1. Criteria selection
The search box on the cadencier home page allows you to select the consumption reference period for your projected needs.
Select :
- Start date: this is the start date of the consumption analysis period.
- End date: this is the end date of the consumption analysis.
- Theoretical availability: this is the number of months over which you wish to make a projection of stocks required if the rate of consumption and supply continues at the same level in the future.
The result displayed by your query then indicates the number of products required in stock to cover the future period of X months, based on the consumption rate over the selected past period.
2. Analysis of results
The app calculates the consumption and replenishment required over this period for each product,
. It indicates the forecast replenishment to be carried out to cover theoretical requirements for the designated number of months.
Each column gives the following information:
- Issue: This is a shortcut column for entering stock issues if necessary.
- Internal balance: This is the expression of the following value: stock + forecasted stock receipts - forecasted stock issues, at date
- Consumption simulation: this is the sum of quantities issued in stock movements for external warehouses and the sum of quantities sold in accepted quotations for own stocks over the selected period.
- Theoretical stock: This is the number of products required in stock to cover the future period of X months, based on the rate of consumption over the selected past period.
Theoretical stock = Quantity in stock to date - (sum of consumptions of the last X months / X) * number Y of future months
1- Quantity in stock to date = stock balance
2- Sum of consumptions of the last X months = value of the "consumptions simulation" indicator defined in column 4 of the schedule.
3- X= number of months considered: count the number of days in the selected period /30
4- Number Y of future months: number of future months used to make a projection.
3. App settings
The app lets you choose the elements used to calculate the "Consumption" and "Simulation" columns.
- Based on accepted quotes (dates subject to change)
- Based on order confirmations sent (dates subject to change)
- Based on delivery notes sent (dates subject to change)
- Based on invoices sent (dates of change)
- Based on accepted quotations (document dates)
- Based on order confirmations sent (document dates)
- Based on delivery notes sent (document dates)
- Based on invoices sent (document dates)
If you select a formula on "Document dates", the documents taken into account are those whose document date (quotes accepted, order confirmations sent, etc.) are within the period concerned.
If you select a formula on "Change dates", the documents taken into account are those whose status change dates to arrive at the required status (quote accepted status, etc.), are within the period concerned.
