Knowledge Base

How Can We Help You?

Search here to get answers to your questions

Popular:

Introduction
Setting Up
Basic Setup
Data Import
Users and Permissions
Printing
Workflows
Email
System Configuration
Data Privacy
Configurations
Advanced
Errors and Reports
Tools
Collaboration Tools
Transactions
Automation
Accounts
Journals and Payments
Billing
Taxes
Pricing
Multi Currency
Retail Operations
Accounting Reports
Deferred Accounting
Subscription
Shareholder Management
Asset
Buying
Module Setup
CRM
Marketing
E-commerce
Website
Employee
Attendance
Recruitment
Training
Employee Lifecycle
Payroll
Employee Tax and Benefits
Performance
Travel and Expense Claim
Gratuity
Fleet Management
Loan
Projects
Project Management
Time Tracking
Quality Management
Selling
Customer Portal
Selling Reports
Stock
Item Variants
Stock Transactions
Serial and Batch Number
Return
Stock Reports
HelpDesk
Education
Student
Admission
Fees
Schedule
Assessment
Assessment Reports
Hospitality
Manufacturing
Production and Material Planning
Non Profit
Membership
Volunteer
Donor
Grant application
Customize BizCentric
Records
Navigation
Custom field
Customize Form
Customize Print Format
Fetch Values
Restrictions
Miscellaneous
BizCentric Integrations
Authentication Integration
Backup Integration
Bank Integration
E-commerce Integration
Shipping Integration
Google Integration
Payment Integration
Telephony Integration
Regional
Reports

Projected Quantity

  • 126views
  • February 6, 2024

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.

It represents the total inventory quantity encompassing both supply and demand from previous periods, formed during the planning phase.

The forecasted inventory serves as a reference point for the planning system to oversee the reorder point and ascertain the reorder quantity. The projected quantity aids the planning engine in overseeing safety stock levels, which are upheld to address unforeseen demands.

Maintaining precise oversight of the forecasted inventory is imperative for identifying shortages and accurately calculating the 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 – Reserved Qty for Production Plan

  • 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.
  • Requested Qty: Quantity requested via a Material Request. 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 (Purchase Order), but not received (via a Purchase Receipt or a Purchase Invoice.
  • Reserved Qty: Quantity ordered for sale by your Customer (Sales Order), but not delivered (via a Delivery Note). 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 Work Order and is reduced when raw materials are transferred to Work in Progress warehouse via a Stock Entry.
  • Reserved Qty for Subcontracting: Raw materials reserved when a subcontracting Purchase Order is submitted. When raw materials are transferred to Supplier Warehouse via a Stock Entry, this quantity reduces.
  • Reserved Qty for Production Plan: Raw materials are reserved when a Production Plan is submitted. When materials are reserved for the production against the work order then the system will reduce the “Reserved Qty for Production Plan” in the respective BIN. The system reduces the quantity if the work order was made against the production plan.
  1. Warehouse
  2. Material Request