Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

Excess Stock Report - Stock Control

Datafile Software

Excess Stock Report - Stock Control

Many companies have not had the capacity in the past to examine their stock-holding in sufficient detail to check whether their stock levels are right or not. A computer is in the position that it can do all the detailed calculations in a flash. Here the computer looks for stock items where you could have money tied up because your stock-holding is too high for the demand you are experiencing.

In some industries (like the retail book trade, for example) you are allowed to return stock for full credit within a reasonable time period. If your stock holding is too high, then you could benefit from returning it, or having a special offer to reduce stocks. Either way you can release money that could finance other stock items you might prefer to stock.

In the stock System Profiles you can specify two parameters: a definition of a time period to be used for special stock calculations (weeks, for example) and an "Excess stock number of periods”. A typical number to use as the excess stock period criterion might be "8” (weeks, in this example).

The computer works out if your stock holding for each item would satisfy current demand for more than eight weeks. If so, it reports it to you, showing the requested details.

You can now decide what to do. If the lead-time for this product is very long, you might decide to leave it be.If the estimated demand is much lower than you thought, this might alert you to a change in market conditions, to which you should respond. On the other hand, it may be that stock has been bought to meet a special order — this may reflect in a low free stock quantity — so it is a false alarm.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Ideal Buying Quantity
Viewed 679 times since Mon, Jun 18, 2012
Component Items - Stock Control
Viewed 15115 times since Tue, Jun 19, 2012
Units of Issue, Pack Sizes and Price Per
Viewed 944 times since Mon, Jun 18, 2012
Document Design Manager - Moving, Deleting and Amending Items - Stock Control
Viewed 789 times since Tue, Jun 19, 2012
Period End - Stock Control
Viewed 1287 times since Mon, Jun 18, 2012
Multiple Locations
Viewed 857 times since Mon, Jun 18, 2012
Additional Options for the Print & Value Assemblies Report
Viewed 730 times since Fri, Oct 26, 2012
Expand Data Files - Stock Control
Viewed 700 times since Tue, Jun 19, 2012
Period / Year End Facilities - Stock Control
Viewed 869 times since Tue, Jun 19, 2012
Default Batch Type for New Stock Items
Viewed 760 times since Fri, Jun 8, 2012