Projected Quantity
Projected Quantity is the level of stock that is predicted for a particular Item based on the current stock levels and other requirements.
Last updated
Was this helpful?
Projected Quantity is the level of stock that is predicted for a particular Item based on the current stock levels and other requirements.
Last updated
Was this helpful?
It is the quantity of gross inventory that includes supply and demand in the past which is done as part of the planning process.
The projected inventory is used by the planning system to monitor the reorder point and to determine the reorder quantity. The projected Quantity is used by the planning engine to monitor the safety stock levels. These levels are maintained to serve unexpected demands.
Having tight control of the projected inventory is crucial to determine shortages and to calculate the right order quantity.
The formula to calculate projected quantity is as follows:
Projected Qty = Actual Qty + Planned Qty + Requested Qty + Ordered Qty - Reserved Qty - Reserved Qty for Production - Reserved Qty for Subcontracting
Actual Qty: Quantity available in the Warehouse. This is the actual physical stock you have.
Planned Qty: Quantity, for which, Work Order has been raised, but is pending to be manufactured.
Reserved Qty for Subcontracting: Raw materials reserved when a subcontracting Purchase Order is submitted. When raw materials are transfered to Supplier Warehouse via a Stock Entry, this quantity reduces.
Requested Qty: Quantity requested via a . It is added on submission of Material Request and subtracted when Purchase Order/Work Order/Stock Entry is created against it based on the Material Request type.
Ordered Qty: Quantity ordered for purchase (), but not received (via a or a .
Reserved Qty: Quantity ordered for sale by your Customer (), but not delivered (via a ). This quantity increases when a Sales Order is submitted and decreases when a Delivery Note or Sales Invoice is created against that Sales Order is submitted.
Reserved Qty for Production: Raw materials are reserved on submission of and is reduced when raw materials are transfered to Work in Progress warehouse via a Stock Entry.