Net Requirements: Time-Phased Material Planning
A practical guide to calculating dated material shortages while keeping stock eligibility, demand, order quantities and release timing distinct.

On this page · 11 sections
- 1What net requirements are—and what they are not
- 2Calculate each period from opening stock to closing balance
- 3Define eligible stock and its product-specific legal context
- 4Count each receipt once, on its usable date
- 5Choose one consistent treatment for allocations
- 6Treat safety stock as an ending target
- 7Size planned receipts, then offset their releases
- 8Three worked cases with reconciled material balances
- 9Connect planning inputs to traceable decisions
- 10Recover from planning exceptions without hiding shortages
- 11Implement and review a proportionate netting process
How does Net Requirements apply to your shop floor?
Pick your industry and scale — Ask V5 rewrites the definition in your context, gives a worked example, and shows what V5 does on day one.
01What net requirements are—and what they are not
Net requirements are the nonnegative, time-phased quantities of additional material needed to cover gross demand and a chosen ending safety-stock target after eligible projected opening stock and scheduled receipts are deducted in each period.
In MRP, net requirements describe a shortage before order-quantity rules are applied. They are not necessarily the quantities ultimately ordered: lot sizing can increase a planned receipt above the calculated shortage.
| Term | Planning question | Output |
|---|---|---|
| Gross requirements | What demand falls in each period before supply deductions? | Time-phased demand |
| BOM explosion | What components do parent requirements generate? | Component demand |
| Net requirements | What additional material is needed after netting? | Nonnegative shortages |
| Planned order receipts | What quantities should become available, and when? | Lot-sized receipt proposals |
| Planned order releases | When should those proposed orders start? | Release quantities and dates |
| Projected available balance | What eligible quantity remains after period activity? | Projected closing balance |
| Backward scheduling | When should an order start to meet receipt timing? | Lead-time-offset release timing |
Planning practice: The equations, hypothetical quantities and operating controls describe planning methods, not legal definitions or regulatory MRP mandates. Binding law, official guidance and software support are labelled separately from this planning practice.
02Calculate each period from opening stock to closing balance
Use a planning key comprising material, location, base unit and dated bucket. Express every quantity in that base unit. The following recurrence is a conventional discrete-period MRP calculation, not a regulatory algorithm.
- t identifies the current dated bucket; t−1 identifies the preceding bucket.
- G_t is gross demand assigned to the bucket under the chosen demand-consumption policy, excluding the safety-stock target. That policy determines how forecasts and actual orders contribute without duplicating demand.
- O_t is projected opening balance: the preceding bucket’s projected closing balance, adjusted for separately recorded eligibility changes before the current bucket. The initial opening balance comes from eligible on-hand stock at the planning snapshot.
- S_t is scheduled receipts: outstanding firm supply expected to become eligible within the bucket by the relevant need time.
- P_t is planned receipts: supply proposals generated by the calculation, kept separate from firm supply.
- T_t is the desired ending safety-stock balance, not additional consumption.
- E_t is a signed, traceable eligibility adjustment between buckets.
Calculate in sequence: O_t = C_(t−1) + E_t N_t = max(0, G_t + T_t − O_t − S_t) P_t = L(N_t) C_t = O_t + S_t + P_t − G_t
N_t is the uncovered requirement before lot sizing; max selects the greater of zero and the calculated shortage. L is the lot-sizing function: it converts that shortage into a proposed receipt quantity using the applicable order-size policy. Apply it after netting, not to gross demand. C_t is the projected closing balance carried forward into the next bucket.
Use E_t only for eligibility changes not already represented elsewhere. It is not another place to record demand or receipts. Keep each movement in a single category so the net-versus-gross reconciliation remains reproducible.
Bucket totals assume receipts become eligible before the demands they cover. If within-bucket event order changes the answer, use event-dated calculations or smaller buckets. C_t describes the proposed plan; it does not prove that a new order is feasible or authorized. Preserve a timing exception when proposed supply cannot actually arrive and become eligible when needed.
03Define eligible stock and its product-specific legal context
For netting, eligible stock is the quantity a site's planning policy treats as usable at the intended issue time—not simply everything physically present. Evaluate material identity, location, quality status, expiry or retest policy, ownership and any applicable storage restriction. A lot eligible today may not remain eligible for a later requirement.
| Jurisdiction and product | Authority type | Provision or policy | Planning relevance |
|---|---|---|---|
| US human drugs | Binding regulation | 21 CFR 211.80(a) | Written procedures are required for receipt, identification, storage, handling, sampling, testing, and approval or rejection of components and drug product containers and closures. |
| US human drugs | Binding regulation | 21 CFR 211.80(d) | Each lot must be appropriately identified as to its status. |
| Site-specific products and markets | Planning practice | Dated eligibility policy | Define which quantities enter netting using lot status and intended-use conditions; retain the reason for exclusion. |
The legal controls above and the site's calculation policy are separate. As planning practice, preserve status at lot level and apply an explicit eligibility policy. A quarantine bin can help distinguish physical location from usable stock, but location alone is not an eligibility decision. An expected future approval is a planning assumption, not an approval already granted.
Keep reservation accounting in the allocation section: do not subtract reserved quantities here without the corresponding demand treatment described there.
For US human drugs, check the current text of 21 CFR 211.84 for its scope. For US dietary supplements, check the current text of 21 CFR 111.80 for its scope; the broader 21 CFR 111 overview provides context. Establish separate applicability for food, devices, chemicals and other markets rather than extending the US human-drug mapping. Record those applicability decisions alongside the eligibility policy so planners can distinguish legal controls from site assumptions.
04Count each receipt once, on its usable date
In planning practice, distinguish the supplier promise date, physical arrival, receipt posting and expected material-eligibility time. These represent a commitment, delivery, inventory transaction and forecast availability for consumption—not interchangeable dates. Bucket supply by expected usability for the planned consumption, with assumptions for inbound receiving and quality-processing time visible.
Apply a single accounting transition: outstanding quantity contributes to scheduled receipts; once received and included in the opening-stock snapshot as eligible stock, that same quantity no longer contributes as an outstanding receipt. Track received-but-ineligible material separately, so its expected availability does not duplicate either open-order supply or eligible opening stock.
For partial deliveries, use the remaining open quantity, not the original order quantity. Keep cancellations, rejected quantities, returns and revised dates linked to the originating supply event and any receiving discrepancy. A return does not itself establish replacement supply; record any replacement commitment separately.
Distinguish firm purchase or production orders from tentative planned orders. When a proposal becomes firm, reconcile its identity and replace its planning representation rather than retaining both as additive supply.
Enough total supply across the horizon does not establish coverage at every need date. Move late receipts into their revised usable-date buckets and surface the earlier shortage; do not leave supply in an obsolete bucket to preserve apparent coverage.
05Choose one consistent treatment for allocations
An allocation or reservation associates supply with demand; it is not an additional consumption event. Common planning practice uses either of the following accounting methods, with consistent boundaries.
- Pooled accounting: include eligible stock in the common supply pool and include the corresponding allocated demand in gross requirements. Preserve allocation references for pegging and dispatch; a pooled calculation does not make committed stock freely dispatchable.
- Separated accounting: remove reserved stock from the free-stock pool and remove the exact corresponding covered demand from that pool’s gross requirements. Keep the reserved supply-demand pair in a separate reconciliation, alongside the free-stock calculation.
Subtracting reserved stock while retaining its already represented demand in gross requirements creates a duplicate shortage.
For paired exclusion, match quantities, dates, material, location and units. Confirm that reserved supply is usable by the covered demand’s date. A reservation that covers only part of an order supports excluding only that covered quantity—not the entire order. Leave the uncovered remainder in gross requirements. Use a net-vs-gross reconciliation to compare both accounting views.
Cancellation, reallocation or changes in lot eligibility can break a previously balanced pair. Review both sides together, restore any uncovered demand to the free-stock calculation, and resolve competing reservations through allocation arbitration. The worked examples below show the numerical reconciliation between pooled and separated accounting.
06Treat safety stock as an ending target
In conventional planning, safety stock is the desired projected balance after a period’s demand, not recurring consumption. The shortage test compares opening stock plus eligible receipts, less gross demand, with that period’s target. Any shortfall contributes to net requirements.
The target appears in each period’s test, but the previous closing balance carries into the next opening balance. Stock retained to meet the target therefore remains available in the calculation; the target is not added again as cumulative demand.
A constant target preserves the same desired ending balance across periods. A deliberately time-varying target changes that balance: an increase can create additional net requirements; a decrease can reduce replenishment, but does not automatically instruct disposal of existing stock.
Keep the target separate from forecast demand, yield allowances and expected scrap. Forecasts estimate consumption; yield and scrap allowances account for anticipated process losses. Safety stock commonly buffers demand or supply uncertainty. Identify each policy’s purpose before combining them to avoid overlapping protection. Assign target approval and review ownership, balancing service protection against expiry exposure. These are planning decisions, not universal coverage rules.
07Size planned receipts, then offset their releases
In standard MRP practice, calculate the raw net requirement first, apply the chosen lot-sizing rule to obtain a planned receipt, then calculate its planned release date. Keep these operations separate: an order rule changes the proposed supply quantity, not the underlying shortage.
For a positive shortage with a minimum order quantity and a positive order multiple, use: planned receipt = multiple × ceiling(max(net requirement, minimum order quantity) ÷ multiple). Express all quantities in the same unit; ceiling rounds upward to the next integer. When the net requirement is zero, set the planned receipt to zero. Lot sizing can leave projected closing stock above the safety target. That excess follows from the order rule; it is not an arithmetic discrepancy.
A planned receipt is the proposed quantity available on its need date. Its planned release is the proposed authorization or start date, calculated by backward scheduling using the applicable lead time and working calendar. Here, lead time includes receiving and quality-processing time; document that convention so neither interval is omitted or added twice. Flag releases before the planning date as timing exceptions.
For multi-level planning, net and size the parent, offset its release, then derive component gross demand through BOM explosion, using the effective BOM and documented yield or scrap assumptions. Apply component timing offsets where the model uses them, rather than assigning every component to the parent's receipt date. Then repeat netting and sizing at the component level.
- Freeze InputsVersion demand, stock, order status and planning policies.
- Time Gross DemandUse independent requirements or parent releases and effective BOMs.
- Filter SupplyApply dated eligibility and consistent allocation treatment.
- Net each periodCalculate shortage using opening stock, receipts and target.
- Size ReceiptsApply order rules; update projected closing balances.
- Offset ReleasesUse lead time and the working calendar.
- Review exceptionsResolve blockers before a planner authorizes changes.
08Three worked cases with reconciled material balances
All quantities, timing assumptions and order rules below are hypothetical planning inputs or calculated results, not regulatory requirements. Material quantities are in kilograms (kg), with no unit conversions or yield losses. Each weekly bucket opens before its receipts are added; eligible receipts enter at the start boundary, then that bucket’s gross demand is consumed. Closing stock carries into the next opening balance. There are no unlisted movements.
Case A: Carry the ending target through three weeks
Assume initial eligible stock of 80 kg, a constant ending target of 20 kg and lot-for-lot ordering. There are no eligibility adjustments. For this arithmetic example, release-to-eligibility lead time is zero buckets: proposed receipts are feasible at each week’s start, with releases at that same boundary before consumption.
| Period | Opening kg | Gross demand kg | Scheduled receipts kg | Target kg | Net requirement kg | Planned receipt kg | Closing kg |
|---|---|---|---|---|---|---|---|
| Week 1 | 80 | 70 | 0 | 20 | 10 | 10 | 20 |
| Week 2 | 20 | 50 | 40 | 20 | 10 | 10 | 20 |
| Week 3 | 20 | 60 | 0 | 20 | 60 | 60 | 20 |
The first net requirement is max(0, 70 + 20 − 80 − 0) = 10 kg. Its closing balance is 80 + 0 + 10 − 70 = 20 kg. That carried stock contributes to the next week’s coverage, illustrating the ending-target treatment above rather than accumulating a separate safety-stock demand.
Across the horizon, scheduled receipts total 40 kg, planned receipts total 80 kg and gross demand totals 180 kg. The reconciliation is 80 + 40 + 80 − 180 = 20 kg.
Case B: Reconcile both allocation treatments
For one bucket, assume eligible stock of 100 kg and total gross demand of 90 kg, including demand covered by a 30 kg reservation. The ending target is 10 kg; scheduled receipts are 0 kg. Assume lot-for-lot ordering and zero-bucket lead time, although neither treatment generates an order. Apply the allocation treatments described above:
- Pooled: retain all stock and demand. Net requirement = max(0, 90 + 10 − 100) = 0 kg. Closing stock = 100 − 90 = 10 kg.
- Separated: remove the matched reservation from both sides. Free stock = 100 − 30 = 70 kg; remaining demand = 90 − 30 = 60 kg. Net requirement = max(0, 60 + 10 − 70) = 0 kg.
In the separated view, the reserved pair leaves 30 − 30 = 0 kg and the free pool leaves 70 − 60 = 10 kg. Both treatments therefore reconcile to 10 kg after all demand is consumed.
Case C: Resize the shortage after a receipt slips
Assume Week 4 physical stock of 100 kg comprises 70 kg eligible stock and 30 kg in quarantine status, excluded by site planning policy. Gross demand is 125 kg, the ending target is 10 kg, and a firm 20 kg receipt becomes eligible at the Week 4 start boundary before consumption.
Raw net requirement = max(0, 125 + 10 − 70 − 20) = 45 kg. Applying the lot-sizing sequence above, a minimum order of 60 kg and order multiple of 25 kg give a planned receipt of 75 kg. Projected eligible closing stock = 70 + 20 + 75 − 125 = 40 kg.
Assume two complete weekly buckets from release to eligibility, including relevant receiving and quality-processing time. The Week 4 planned receipt therefore has a Week 2 planned release, assumed feasible.
Now move the firm 20 kg receipt to the Week 5 start boundary. Week 4 net requirement becomes max(0, 125 + 10 − 70 − 0) = 65 kg. The sized receipt remains 75 kg, leaving 70 + 0 + 75 − 125 = 20 kg. Both shortages round to the same permitted order quantity. Count the displaced 20 kg only in Week 5, not in Week 4 as well.
09Connect planning inputs to traceable decisions
A reproducible netting recommendation connects inputs, policies and decisions. The fields below are a proposed implementation schema, not a software-product specification. Assign authoritative ownership at field level:
| Record | Proposed fields | Authoritative owner |
|---|---|---|
| Material policy | material_id, policy_version, effective_from | Planning |
| Dated demand | demand_id, quantity, need_date, version | Production for production demand; planning for other demand |
| Lot inventory | lot_id, location_id, quantity, quality_status | Inventory for quantity/location; quality for status |
| Supply events | event_id, order_id, remaining_quantity, available_at | Purchasing for purchase orders; production for manufacturing orders; inventory for posted receipts |
| Planning results | run_id, planned_quantity, planned_date, exception_id | Planning |
At MES–ERP integration boundaries, specify units and conversions, identifier mappings, timestamp meanings, time zones and effective versions. Distinguish transaction time—when an update was recorded—from effective material-availability time—when its quantity becomes usable for planning.
Use stable transaction identifiers and version checks for replay-safe processing. Reconcile remaining order quantities against receipts, cancellations and corrections. Repeated messages should have no additional quantity effect; delayed older versions should not replace newer states or create extra stock or receipts.
Retain the planning snapshot or reconstructable input versions, policy version, calculation run identifier, demand-to-supply references and exception decisions. Choose retention according to operational risk here, rather than treating this recommendation as a statutory retention period.
A late receipt or quality-status update can trigger controlled recalculation under a new run identifier, preserving the previous decision and linking its replacement for exception review. Record each manual override’s affected quantity or date, rationale, owner, authorization and subsequent review. Keep planning-change approval separate from authorization to use or release material.
Material Policy
Versioned planning rules.
- item_id
- base_uom
- lead_time
- safety_stock
- moq
- order_multiple
- policy_version
Demand Event
Quantity needed at a defined time.
- demand_id
- item_id
- need_at
- quantity
- source_id
- allocation_id
Inventory Lot
Stock and its eligibility attributes.
- lot_id
- item_id
- quantity
- quality_status
- expiry_at
- location_id
Supply Event
Outstanding supply and expected usability.
- supply_id
- item_id
- open_quantity
- available_at
- status
Planning Result
Reproducible balance and proposed supply.
- run_id
- item_id
- bucket_start
- opening_qty
- gross_qty
- scheduled_qty
- net_qty
- planned_receipt_qty
- release_at
- closing_qty
10Recover from planning exceptions without hiding shortages
These are planning-practice diagnostics, not regulatory algorithms. Investigate the signal before changing supply. Use the earlier allocation treatment and receipt-accounting rules to resolve discrepancies.
| Symptom | Likely cause | Detection | Recovery owner |
|---|---|---|---|
| False shortage | Allocation mismatch | Reserved stock excluded but corresponding demand retained | Planner: reconcile allocation treatment |
| Supply jumps after posting | Duplicate receipt supply | Posted quantity still appears as open supply | Receiving/buyer: reconcile receipt balance |
| Apparent coverage | Late receipt counted early | Usable date follows consumption | Planner/buyer: restore timing exception |
| Unavailable lot covers demand | Unusable stock eligible | Eligibility conflicts with lot status | Quality/inventory: correct eligibility |
| Excess planned supply | Minimum order applied without shortage | Positive recommendation despite zero net requirement | Planner: correct sizing logic |
| Quantity scales unexpectedly | Unit-conversion error | Mismatch follows pack or mass conversion | Master-data owner: correct conversion |
| Wrong component demand | Stale BOM effectivity | Explosion uses superseded revision | Engineering: correct effective BOM |
| Demand spikes with orders | Forecast/order overlap | Orders added without forecast consumption | Demand planner: reconcile overlap |
| Repeated unrealistic dates | Missing lead-time components | Transit, inspection or queue time absent | Planner/process owner: correct timing inputs |
| Immediate availability assumed | Receipt/release dates confused | Supply appears on order-start date | Planner: correct date mapping |
For posting discrepancies, reconcile the raw material receipt transaction with remaining open supply. Preserve the affected run; identify the incorrect input or assumption; correct its owning record; recalculate dependent items; compare changed recommendations; obtain the relevant human decision. Use exception-based review to retain unresolved cases with named owners.
Expediting seeks earlier supply; rescheduling changes timing; cancellation removes an unnecessary commitment; approved substitution changes the material used. These are distinct decisions, not interchangeable automated fixes. Proposed substitutions remain dependent on site material and product controls. Keep infeasible timing and uncovered demand visible: never convert a past-due planned release into an apparently on-time receipt merely to erase a negative projection.
11Implement and review a proportionate netting process
Use the following implementation checklist as planning practice, not as a regulatory specification for an MRP algorithm.
- Bound the pilot. Select a material family and declare the planning horizon, bucket calendar, location scope and base-unit policy. Assign owners for demand, material status, receipts, planning parameters and exception decisions.
- Establish the baseline. Reconcile opening stock and outstanding supply with warehouse and purchasing records before comparing recommendation quantities. Ask quality personnel to confirm what each status means and whether the eligibility assumptions are appropriate.
- Test independently. Use the worked cases above as hand-calculated acceptance tests, with expected balances and recommendations established independently of the software. Add partial receipts, status changes, allocation cancellation, changing safety targets and infeasible release dates.
- Compare methods. Run the proposed process alongside the existing planning method. Investigate differences by input, timing rule and order policy; agree locally when unresolved differences permit adoption rather than imposing a universal trial duration or performance threshold.
- Review controls. Check balance reconciliation, receipt uniqueness, reservation pairing, valid units, BOM effectivity, reproducible run versions and documented overrides, using the earlier sections for the underlying rules.
- Evaluate software. Can reviewers explain inputs and outputs, distinguish firm from tentative supply, inspect dated lot eligibility, see exceptions and reproduce recalculation? Treat these as evaluation questions, not assumed capabilities.
- Retain decision ownership. Keep purchasing or production authorization and quality disposition with responsible people. Define review triggers for significant changes to demand, supply dates, eligibility or planning parameters; connect exception review and change control to named decision owners.
Frequently asked questions
Q.Can a material have zero net requirements and still be unavailable for a particular production batch?+
Yes. An item-level balance can show sufficient supply while the batch needs a particular grade, approved source, location or lot status that the available quantity does not satisfy. Batch-level allocation arbitration therefore commonly checks eligibility as well as quantity, including quarantine status. Apply the reservation convention described under allocation. For a particular batch, compare the approved grade and source constraints before interpreting an item-level zero-shortage result as usable coverage.
Q.Should forecasts and firm customer orders both contribute to gross requirements?+
They can, but typically only after forecast consumption distinguishes overlapping demand from genuinely additional demand. A firm order commonly replaces the forecast quantity it fulfils within a defined product, market and time window; unmatched forecast remains demand. Adding the entire forecast to all orders can inflate gross requirements. The MRP policy should identify matching rules, treatment of orders outside the window and whether overdue forecasts expire or move forward. Align those choices with sales and operations planning.
Q.How should an expiring lot be treated when it can cover an early requirement but not a later one?+
Treat its usable quantity as date-dependent supply rather than removing the whole lot immediately or carrying it indefinitely. Allocate eligible quantity to the early requirement, then exclude any remaining quantity once it no longer meets the applicable use-date or remaining-shelf-life rule. Material aging monitoring helps identify that transition; expiry-driven FEFO supports selecting eligible earlier-expiring lots. Record the exclusion separately from production consumption so planners can distinguish expiry loss from actual material demand.
Q.What changes when the same ingredient appears at several levels of a bill of materials?+
Each genuine usage path can generate dependent demand, but a shared ingredient is typically netted against a common eligible supply pool rather than receiving the full stock balance separately on every branch. BOM explosion establishes quantities and requirement dates from the relevant parent orders. If an intermediate is supplied from stock, avoid also exploding its already-satisfied quantity into new ingredient demand. Preserve parent-order pegging and apply recipe effective dating so repeated appearances remain explainable rather than becoming duplicate demand.
Q.Can a negative projected balance be carried into the next period, and what does it represent?+
Yes, in a shortage-visible planning view. A negative closing balance represents cumulative uncovered demand, not physically negative inventory, and becomes the next period's projected opening balance. Do not also add that same backlog as fresh gross demand unless the carried deficit is removed. A replenishment proposal may eliminate the projected deficit, but its feasibility remains a separate question: backward scheduling can reveal that the corresponding release date is already past, requiring a planner to resolve the timing exception.
Q.What should happen to existing planned orders when a new planning run changes the shortage?+
Typically, unfirmed proposals are recalculated, resized, moved or deleted, while firmed proposals receive review rather than silent replacement. An existing proposal retained as supply should not also be recreated as a new receipt. Apply lot-sizing rules after calculating the revised shortage, then offset the planned receipt date to obtain the release date. Exception-based review can focus attention on cancellations, excess supply and infeasible dates. Changes to committed purchase or production orders remain controlled decisions, not merely revised planning suggestions.
Q.When is a smaller planning bucket worth the additional data and maintenance effort?+
A smaller bucket is useful when events inside the current bucket change whether production can actually proceed: a receipt arrives after consumption, several batches compete for stock, or eligibility changes before use. Coarse buckets can conceal these sequencing shortages even when the closing balance is positive. Finer buckets are worthwhile only when receipt times, consumption dates and calendars are maintained accurately enough to support decisions. Where equipment or labour availability drives the sequence, connect material planning with constraint-based scheduling.
Q.Which software outputs allow a planner to reproduce a net requirement independently?+
A reproducible export typically shows the inventory snapshot, eligibility exclusions, reservation convention, demand pegging, receipt identifiers, bucket dates and planning parameters. The initial opening balance comes from eligible inventory at the snapshot; later opening balances use the preceding closing balance plus separately recorded eligibility adjustments, as defined under Calculate each period. Export each adjustment with its lot reference, effective bucket and reason, so a reviewer can distinguish an expiry exclusion from a consumption entry. Reconcile starting quantities to perpetual inventory and show lot-sizing adjustments separately.
Primary sources
Explore this topic
Net Requirements sits inside this topic cluster in our glossary. Every neighbour is one click away.
Material requirements planning, BOM explosion, net requirements, scheduling and demand signals that drive what the floor makes next.
Want to see how Net Requirements could fit into your own records and workflows? Explore the related V5 pages or talk to our team about what applies to your operation.
