| Purpose & Benefits |
|---|
| This function enables you to estimate the number of weeks (or months) of Sales your current Stock levels can service. It is of most benefit to users of the Trade option but maybe of use to other users too. The data is populated into the grid and can then be exported to Excel. |
The ‘From’ date of the report is important as it is used to get the first figure in the ‘Stock In Qty Balance B/F’. For accuracy the report should always be started at the beginning of a period/month.
To get full weeks of Sales figures (rather than a part-week for the last week), the ‘To’ date should be a number of days, which is divisible by 7, after the start date, e.g. for 7 weeks analysis enter a date 49 days after the start.
Filters
Decide which filters you want to apply to your report.
| 1 | Date Range | Current – 4 Years PastWeeks or Months | |
| 2 | Product Code | All, Range or Single | For Single or Range, complete the From and To fields as required |
| 3 | Product Group | All, Range or Single | If you select Single or Range, complete the From and To fields as required |
| 4 | Include Discontinued Products | Yes or No | Default is to include discontinued but you may wish to exclude them. |
Once the filters are set appropriately, decide which Warehoues apply by clicking Configure Warehouses and ticking/unticking the box beside each warehouse.
Click Process to produce the report. It can be exported to Excel by clicking the Export button.
The final report shows:
| # | Field | Remarks/Notes |
|---|---|---|
| 1 | Product Code | |
| 2 | Product Name | |
| 3 | Default Stock Qty | Quantity in Stock at default warehouse (normally CENTRAL) |
| 4 | Warehouse A Stock Qty | Quantity in Stock at other warehouse AOther fields after this show quantities at other warehouse(s) |
| 5 | Total In Selective Stock Qty | Total Quantity in Stock for selected warehouse(s) |
| 6 | Estimated Weekly/Monthly Cover on Selective Stock | Is calculated from ‘Total In Selective Stock Qty’ divided by estimated weekly (or monthly) sales |
| 7 | Total Stock Qty | Total Quantity in Stock |
| 8 | Estimated Average Weekly/Monthly Sales | Calculation: Sum of total sales for selected number of weeks (/months) divided by Qualifying number of weeks. A Qualifying week is where the Balance brought forward for that week is greater than zero. |
| 9 | Estimated Average Weekly/Monthly Sales Cover | Calculated by dividing the Total Stock Qty by the ‘Estimated Average Weekly/Monthly Sales’ figure |
An example (to show how the calculations work):
Here, we want to estimate the stock cover for product ‘8670577’. The figure in yellow is calculated based on Product Movements (see image below).
Product Movements: note the Bal B/F drops to 0 twice hence 5 Qualifying Weeks rather than 7..
