Stock Levels based on Stock Policy
When the production and purchasing requirements for a particular week or month are calculated, one element in the calculation will be the number of units that should be in stock at the beginning of the next week or month. This figure will be calculated using the information in the
Stock Policies setting and the Sales Forecast figures. The Stock Policies setting should contain the required stock level of each Item, expressed as a number of days' sales.
Please refer to the Stock Policy - Average Sales per Day page for details about this calculation.
The Stock Levels based on Stock Policy report lists the results of this calculation for each Item. It therefore displays what the stock levels of each Item should be at the beginning of each week or month in the report period, based on estimated sales figures.
The report will contain separate columns showing the quantity that should be in stock at the beginning of each week or month in the report period. The duration of each column (weekly or monthly) will depend on the Period Type that you have chosen in the Forecast Settings setting. The number of decimal places shown in the report is governed by the Quantity Decimals field in the same setting.
- Period
- Paste Special
Reporting Periods setting, System module
- Specify the period to be covered by the report. The report will contain separate columns for each week or month in the period.
- The beginning of the period should be the first day of a week (i.e. Monday) or month, depending on the Period Type that you have chosen in the Forecast Settings setting.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- Use this field to restrict the report to a particular Item or range of Items. Subject to the Item Type options below, only Items that have been used in Sales Forecasts or in Recipes in Production Plans will be included in the report.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Use this field to restrict the report to Items belonging to a particular Item Group or Item Groups.
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- If you select an Item Classification here, every Item with that Classification that has been used in Sales Forecasts or in Recipes in Production Plans will be included in the report. If you enter a number of Classifications separated by commas, only Items featuring all the Classifications listed will be included. If you enter a number of Classifications separated by plus signs (+), every Item featuring at least one of the Classifications listed will be included. If you enter a Classification preceded by an exclamation mark (!), every Item featuring any Classification except the one listed will be included.
- For example:
- 1,2
- Lists Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Lists Items with Classifications 1 or 2.
- !2
- Lists all Items except those with Classification 2.
- 1,!2
- Lists Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.
- !1,!2
- Lists all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Lists all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be listed).
- !1+2
- Lists Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be listed).
- (1,2)+(3,4)
- Lists Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Lists Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Lists Items with Classifications beginning with 1 but not 1 itself.
- *1
- Lists Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Lists Items with Classifications beginning and ending with 1.
- Forecast Class
- Paste Special
Forecast Classes setting, MRP module
- To calculate estimated stock levels using Sales Forecasts and Stock Policies that belong to a particular Forecast Class, specify that Class here.
- Stock Policy
- Use these options to specify whether the calculation of the estimated stock levels of each Item at the beginning of each week or month should use the minimum or maximum figures for each Item from its Stock Policy, or whether it should not use Stock Policies at all (i.e. each beginning-of-period stock level for an Item should be the full Sales Forecast figure for that period).
- Display
- The Auto Production Items setting allows you to include generic Items in Sales Forecasts and in Recipes, and to connect those generic Items to more specific Items for including in Purchase Orders. For example, you might have a generic Item for "flour" that is connected to two specific Items "Flour - 10 kg bag" and "Flour - 25 kg bag". You would use the generic Item in Recipes, but would use one of the specific Items when ordering from your Suppliers.
- If you are using Auto Production Items, use these options to choose whether generic or specific Items will be shown in the report.
- Normal
- Both generic and specific Items will be included in the report. For example, if you have used "flour" as a component in a Recipe that is used in a Production Plan and you have also included "Flour - 10 kg bag" in a Sales Forecast, they will be shown as separate Items in the report.
- Summarised
- Only generic Items will be included in the report. Continuing the example, the "Flour - 10 kg bag" in the Sales Forecast will be included in the figures for "flour". The quantity of "Flour - 10 kg bag" will be converted to a quantity of "flour" using the Unit Coefficient in the relevant Auto Production Item record.
- De-Summarised
- Only specific Items will be included in the report. In the example, the "flour" in the Recipe will be included in the figures for "Flour - 10 kg bag" or "Flour - 25 kg bag", depending on which Auto Production Item has been marked as the Default. The quantity of "flour" will be converted using the Unit Coefficient in the Default Auto Production Item record.
- Item Type
- Use these options to choose which Items in the specified range will be included in the report, as follows:
- All
- All Items that have been used in Sales Forecasts or in Recipes in Production Plans will be included in the report.
- Purchase
- Only Items that can be purchased (i.e. Items without Recipes) will be included in the report.
- Production
- Only Items that can be produced (i.e. Items with Recipes) will be included in the report.
When printed to screen, the report will include a [See Detailed Calculations Behind] text button. Click or tap this button to produce a second report that shows the calculation in more detail. This detailed report will contain the following sections:
- Figures from Sales Forecasts.
- Figures from Sales Forecasts with figures and components from Production Plan rows added in.
- The required beginning-of-period stock levels, calculated using the Sales Forecast figures or the requirements in Production Plan rows and the Stock Policies.
- Totals.
The two reports are illustrated below:
---
Reports in the MRP module:
Go back to:
Introduction to Reports in the MRP Module
