Stock Quantities & Calculations

Top 

Terms

Description of terms used.

In Stock (On Hand)

Number of items in the shop.

Reorder Level

When the stock item reaches this level you must reorder it. Set in the Stock Main Form.

You can set the Reorder Level to the Average Sales values in the Purchase Planing form. Select the More button on the Menu Bar

Additional Order Quantity

The quantity that you specified must be ordered. This value will be displayed in the Purchase Planning Form. and is set in the Stock Main Form > General Tab

On Order

Items that are on order from the suppliers.



Reserved

= Allocated item quantities on Sales Orders and Job Cards

Confirmed Demand

= Total item quantities on Sales Orders and Job Cards

   This is the quantity you need to fulfill all sales orders and job card requirements

Available

= In Stock - Reserved

  Quantity available to sell.

Stock Shortfall

= Confirmed Demand - (In Stock + On Order)

A positive quantity means that you can't fulfill your current orders.

 

Suggested quantity: This is the quantity that SI+ predicts you must order, taking maximum levels, minimum levels, lead time, and days until the end of the month into account.

See also Purchase Planning.

Quantity to order

Use either of these two, depending on your trust in the figures.

SQty.NoR

(using your own values)

If the In-Stock - Sales Orders - Reorder Level is less than or equal to 0, then the quantity will be calculated as follows:

SQty.NoR = Reorder Level - In Stock - On Order + Confirmed Demand

Otherwise, the calculation will be as follows:

SQty.NoR= Reorder Level - In Stock + Additional Order Quantity - On Order + Confirmed Demand

 

SQty.R

(as predicted by SI+)

Quantity to order using linear regression techniques.

Suggestion Regression (SQty.R) = Next Sales + Confirmed Demand - On Hand - On Order

 

 

Keywords: Stock Quantity Calculations