You use this program to identify items on order (or in stock) which exceed the current projected demand.
These oversupplies are usually due to obsolete stocks, safety stock levels, economic batch quantities, and other batching rules.
This report enables you to monitor planned stock holdings and investments, as well as assess ordering policies.
You can print a report listing all stock codes with a positive result (oversupply) in their highest period (i.e. the last period within the date selection for which any demand and/or supply exists, actually has too much stock). Depending on buying rules and stocking preferences this could indicate that the stock code is overstocked.
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Part category | Indicate items for inclusion in he report based on the part category to which they have been assigned (Stock Codes). | ||||||
| Date selection | |||||||
| All | Select this to view the total potential oversupply for each stock item in the demand file up to the current date. | ||||||
| Single | Select this to enter a specific date at which the potential oversupply for each stock item in the demand file must be calculated. | ||||||
| Date | Enter the specific single date to use. | ||||||
| ECC options | If you select neither of these options, then individual
values are printed for each individual revison/release (i.e.
an individual line is printed for each revision/release and
its value).
|
| Field | Description |
|---|---|
| Stock code selection | Indicate the stock code(s) for which to generate the report. |
| Warehouse selection | Indicate the warehouse(s) for which to include stock items in the report. |
| Supplier selection | Indicate the supplier(s) for which to include stock items in the report. |
| Buyer selection | Indicate the buyer(s) for which you want to include stock items in the report. |
| Product class selection | Indicate the product class(es) for which to include stock items in the report. |
| Part category selection | Indicate the part category(ies) for which to include stock items in the report. |
| Planner selection | Indicate the product class(es) for which to include stock items in the report. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
The report produces an extended cost by multiplying the current average cost by the oversupplied quantity. This cost is summarized by warehouse on a separate totals page.
The net cost and the cost unit of measure held against a stock code is printed on this report. The net cost value will be the same as the extended cost value, except where a buying rule is defined that is based on the economic batch quantity or pan size.
Where the net cost is calculated based on a buying rule based on EBQ or Pan size the following apply:
for batching rules B, G, I, K, M and O, the net cost is calculated as: (cost x (oversupply quantity - EBQ quantity)).
for batching rules F, H, J, L and N, the net cost is calculated as: (cost x (oversupply quantity - PAN quantity)).
Order policies are calculated as: (cost x (oversupply quantity - order multiple)).
If the result is negative, then the net cost is printed as zero as it is assumed that the oversupply is the difference between demand and he order quantity you had to place based on the rule. For example: If the buying rule is B and the economic batch quantity (EBQ) of an item is 100 (i.e. the item is purchased in multiples of 100), and there is a demand for 50, then when the item is purchased there will be a potential oversupply of 50. The net cost calculation (50 minus 100) is negative, therefore, the net cost is zero.
For consolidated warehouses the cost is taken from the Warehouse to use (Stock Codes).
If you defined order policies against the warehouse for a stock item (Inventory Warehouse Maintenance for Stock Code) then the order multiples are printed in place of the EBQ or Pan quantities.
If a made-in item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then filtering on part category B returns the item. The supplier and dock to stock days defined against the warehouse is used instead of the values held against the stock code. This is ignored if consolidating warehouses.