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

Ideal Buying Quantity

Datafile Software

Ideal Buying Quantity

The next judgement is — how much to buy? Your supplier may have minimum quantities and pricing breaks to encourage you to buy more at one drop. If you do not buy enough, you may have to re-order quickly, and not get the best price break; if you order too much, it may fill your warehouse and take months to sell.

This is another area on which much has been written. Small orders attract higher prices and cost you in administration every time you place an order. Large orders attract better prices, but take up warehouse space (you may have to take on more space), may attract higher insurance premiums, and risk obsolescence and potential wastage. In other words, the real cost of an item to you is not just its cost price from the supplier, but also should include all the other costs associated with stocking it, expressed per unit.

The diagram on the right illustrates the issue. One line shows the cost per unit of buying in larger quantities, falling as the quantity gets larger to the limiting point. Another line shows the other costs of stocking the item, expressed as a cost per unit for quantities purchased, and starting to increase as the quantity goes up. The third line shows the overall cost per unit, combining the two lines.

The theories say there is a point somewhere in the cost curve where the cost per unit, taking everything into consideration, is at its least. This is the ideal buying quantity, as illustrated in the drawing above.

We do not attempt to do these calculations for you, but provide a field for each stock item in which you can record the figure which you deem to be the ideal buying quantity.This may owe more to practical realities and your suppliers’ terms than to abstruse calculation. We print this value on the appropriate stock reports.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Revise Cost / Selling Prices on Generated Stock Transactions
Viewed 1754 times since Fri, Jun 8, 2012
Recalculate Cost of Assemblies
Viewed 86 times since Tue, Oct 15, 2024
Assemblies – New ‘Time’ Component Type
Viewed 22 times since Wed, Oct 16, 2024
Set Application Code Formats - Batch Tracking
Viewed 1414 times since Tue, Jun 19, 2012
Document Design Manager - Document Watermark - Stock Control
Viewed 1543 times since Tue, Jun 19, 2012
Update Last Sale / Purchase Dates with Assembly Build
Viewed 90 times since Wed, Oct 16, 2024
System Profiles - Batch Tracking
Viewed 3488 times since Tue, Jun 19, 2012
Copy Item Facilities - Batch Tracking
Viewed 1870 times since Wed, Jun 20, 2012
Application Screen Layouts - Stock Control
Viewed 1523 times since Tue, Jun 19, 2012
View a Stock Record - Stock Control
Viewed 1513 times since Mon, Jun 18, 2012