Skip to main content

Supply Planner features & definitions

Updated over a week ago

Overview

Supply Planner enables planning and forecasting of future supply needs. It balances demand and customer orders against safety stock levels while respecting internal production and supplier constraints.

The planning logic combines top-down and bottom-up approaches. Top-down planning generates suggested orders based on unconstrained demand. Bottom-up planning evaluates actual availability of intermediates and materials across the Bill of Materials (BOM).

Inventory positions, demand, and supply movements are calculated across the planning horizon. Exceptions are flagged when inventory becomes insufficient or when backorders remain unresolved.

The module is organized by SKU and location in a time-phased grid. The same SKU can have different inventory, safety stock, and order suggestions per location. Detailed breakdowns of inventory, demand, deliveries, usage, and backorders are available within the Supply Overview Grid for each SKU-location combination.

Main Features

Order Suggestions

Supply Planner generates order suggestions to resolve demand–supply gaps and maintain Safety Stock levels.

The main grid displays the total suggested quantities required for each item. In the Plan View drop-down, planners can choose to display order suggestions on order date by choosing Orders or on Delivery date by choosing Delivery.

Planners can generate order suggestions for all visible lines through a top-level Action or target specific items via right-click context menus.

Order suggestions are calculated based on:

  1. Demand (Sales and Consumption)

  2. Review Period (currently, only 1 month is supported)

  3. Safety Stock Policy

  4. Ordering Policy

  5. Supplier lead times

  6. Minimum Order Quantity (MOQ)

  7. Incremental Order Quantity (IOQ)

  8. Bill of Materials (BOM) structure and component quantity requirements

Converting a Suggested Order to a Firm Order

To convert a suggested order into a Firm Order:

  1. Open the Supply Orders view.

  2. Locate the order with Status = Suggested.

  3. (Optional) Double-click the Status field and change it to Approved — use this step if your organization reviews orders in PLAIO before firming.

  4. Right-click and select Convert to Firm Order.

A PO number must be available at the time of conversion.

Demand Types

The Supply Planner propagates Forecast from Demand Planner module through the layers of the BOM. The Forecast Type used in calculations is determined by the selection in the Forecast Type dropdown menu:

<a href="https://downloads.intercomcdn.com/i/o/slihwz21/2032097968/af7b5b46a6b818d961ced70bf074/image.png?expires=1774764000&amp;signature=222520797db68b5690b3f6afcdaa7dd5b520b990d420298307f64baedb3f8d95&amp;req=diAkFMl3mohZUfMW3Hu4gd%2BE585T%2BImtCLVrBIH0ITv9%2FroJszN4b77qxuj0%0Aiw%3D%3D%0A" target="_blank" rel="nofollow noopener noreferrer">https://downloads.intercomcdn.com/i/o/slihwz21/2032097968/af7b5b46a6b818d961ced70bf074/image.png?expires=1772604000&amp;signature=8c06057a4e87bdc076c1cf0a8a5a6d1101ded5b1a42419dcdbf5fcd6d0986162&amp;req=diAkFMl3mohZUfMW3nq%2BgdPuL4%2FKEF0QmpUuAI%2BemzvbtEnQGVpNUJuylvbW%0ACnUu%2Bv7pLD99BKoPK%2BXrylOgdS0%3D%0A</a>

In Supply Overview Grid Demand is split into Sales and Consumption demand:

  • Sales Demand refers to items that are sold directly, typically Finished Goods. This demand originates from forecast inputs and drives replenishment planning for those items.

  • Consumption Demand is generated for components when parent items are planned for order/production. It represents the full component quantity required to fulfill the planned supply of the parent item, based on the Bill of Materials (BOM).

If an item is sold directly and is also sourceable, it will have both Sales Demand and Consumption Demand. Sales Demand is fulfilled first.

Instant Feasibility Check

Supply Planner continuously updates calculations of feasible orders and inventory levels based on the current state of all orders in the planning grid.

If the planner manually overrides the order suggestions, the inventory reflects the changes and displays a visual feedback on the corresponding item’s chart. Should any of the new orders be unfulfillable, i.e. not possible to fulfill within the planning horizon due to a component shortage, the bar will appear red. On the Supply Overview Grid, a planner will be able to see unfulfillable firm orders and order suggestions.

Planner can then generate order suggestions on the lower levels to try to fulfill the new derived demand and fix the exception, or accept this issue and try to solve it outside of PLAIO’s system (example: request a rush order from a CMO and increase the inventory by changing Firm Order delivery dates).

Supply Overview Chart

The Supply Overview Chart visualizes the time-phased supply position of a selected item. It includes the following elements:

  • Net Inventory (Closing) is displayed as the primary area series. The area appears green when inventory is positive and red when Net Inventory becomes negative.

  • Deliveries (inflow) are shown as columns based on planned and firm orders.

  • Usage (outflow) is shown as columns representing Sales and Consumption demand.

  • Safety Stock is displayed as a red dashed line for reference.

Unfulfillable Orders are shown as red bars.

The Supply Overview Grid reflects the numbers shown in the Supply Overview chart. For more information on the Supply Overview Grid, click here.

Inventory Simulation

Inventory Simulation calculates projected inventory levels across the planning horizon based on demand, deliveries, backorders, and supply constraints.

Inventory is displayed as both Physical Inventory and Net Inventory. Physical Inventory represents the on-hand quantity after all transactions within a period. Net Inventory reflects Physical Inventory adjusted for outstanding backorders and may become negative if backorder debt exceeds available stock.

Only fulfillable orders contribute to projected inventory. If component shortages prevent fulfillment, projected inventory does not assume ideal supply and reflects the constrained outcome.

In addition to demand consumption and deliveries, inventory levels may change due to shelf-life rules.

Sellable Until Dates

Each inventory batch is available for sale until its Sellable Until Date. After that date, the batch becomes unsellable and is removed from available inventory. Expiry Date and Minimum Remaining Shelf-Life are defined in the Item Master data.

A Sellable Until Date Override allows a batch to be designated as sellable for a longer or shorter period than its calculated default. This can be used when inventory is allocated to specific markets with different shelf-life acceptance rules.

💡The system determines the “Sellable Until Date” for each inventory batch using the following priority:

  1. Sellable Until Date Override (if provided)

  2. Expiry Date - Minimum Remaining Shelf-Life (calculated)

  3. Expiry Date (if no Minimum Remaining Shelf-Life is specified)

Backorders

Backorders are created when demand cannot be fulfilled due to insufficient available inventory.

There are two distinct types:

  • Sales Backorders — unmet Sales Demand for items sold directly.

  • Consumption Backorders — unmet Consumption Demand caused by component shortages delaying parent production.

Backorders are maintained as cumulative balances across periods. When inventory becomes available, existing backorders are fulfilled before new demand is consumed.

Backorder activity is reflected in the Supply Overview Grid, including newly created backorders and fulfillment of prior backorders. If backorder balances remain unresolved at the end of the planning horizon, the item is flagged with a red exception alert.

Exceptions

Exceptions are evaluated continuously as the supply plan is edited. The Supply Overview Grid distinguishes between two severity levels: Warning (yellow) and Danger (red). Indicators appear at both the individual period level and at the row level for the item.

  • Yellow (warning) means there is unfulfillable demand in this period, but the simulation fully resolves all backorders before the end of the planning horizon. The plan catches up - components arrive late, but nothing is permanently lost. The planner should be aware but may not need to act.

  • Red (danger) means unfulfillable demand exists and backorder debt remains unresolved at the end of the planning horizon. The plan does not recover. This requires action - adjusting orders, finding alternative suppliers, or escalating.

In addition, the exception details are also visible in the sub-grid for any given item.

Allocations and Consumption

The Supply Planning Grid includes two allocation tabs: Allocated To and Consumed From.

Allocated To shows where an item’s inventory is used. Consumed From shows the source of components required to fulfill planned supply. Both views present the same allocation data from different perspectives and are structured hierarchically across three levels:

  • A date level aggregating all allocations on a given date

  • An allocation level representing each parent–component relationship

  • A batch level showing the specific inventory batches used and the allocated quantities

If a shortage occurs on a given date, the corresponding date row is highlighted.

Each allocation record includes additional traceability fields:

  • Priority - shows the defined priority order in which items compete for limited component inventory.

  • Allocation Type - indicates whether the allocation is:

    • Normal (fulfilled on the originally scheduled date), or

    • Backorder Recovery (fulfilled later due to prior shortage).

  • Supply Type - indicates whether supply occurs via:

    • Production (same location), or

    • Transfer (inter-location movement).

  • Status - shows whether the allocation is Fulfilled or Unfulfilled.

Definitions

Type

Description

Allocation Type

Indicates whether an allocation was fulfilled on the originally scheduled date (Normal) or fulfilled later due to prior shortage (Backorder Recovery).

Backorder Created

A backorder generated when demand cannot be fulfilled in the current period.

Backorder Fulfillment

The fulfillment of previously created backorders once inventory becomes available.

Backorder Balance

The total outstanding backorders at a given period.

Consumption Backorders

Cumulative unmet component demand resulting from insufficient inventory to support parent item production.

Consumption Demand

Component demand generated when parent items are planned for production. Represents required component quantities based on the Bill of Materials (BOM).

COGS Firm Orders

COGS for Firm Orders.

COGS Order Suggestions

COGS for Order Suggestions.

COGS Orders

The aggregate COGS of Orders Suggestions and Firm Orders.

COGS Unsellable

COGS for inventory that becomes unsellable.

Deliveries

Aggregated delivery quantities from Order Suggestions and Firm Orders. Delivery dates are determined by supplier lead times.

Firm Deliveries

Deliveries from the Firm Orders (the portion from Deliveries that are Firm).

Firm Orders

Confirmed supply orders uploaded or created to represent committed incoming inventory.

Inventory Below Safety Stock

When inventory goes below Safety Stock. The level and what it should be is displayed.

Late Delivery

A delivery fulfilled after its originally scheduled date due to component shortages or prior infeasibility.

Late Usage

Demand fulfilled after its originally scheduled date due to prior shortage.

Months of Inventory

Projected inventory coverage based on the rolling average demand of the next X months.

Net Inventory

Physical Inventory adjusted for outstanding backorders. May become negative if backorder balances exceed available stock.

Order Suggestions

System-generated supply quantities calculated to meet demand and maintain Safety Stock levels.

Physical Inventory

The on-hand stock quantity after all transactions within a period.

Safety Stock

The calculated safety stock quantity for the given date.

Sales Backorders

Cumulative unmet Sales Demand carried forward across periods.

Sales Demand

Demand for items that are sold directly.

Shortage

Insufficient component availability preventing fulfillment of Consumption Demand.

Total Demand

The sum of Sales Demand and Consumption Demand for an item in a given period.

Total Orders

The aggregate quantity of Order Suggestions and Firm Orders.

Unfulfillable Demand

Demand that cannot be fulfilled in the current period due to insufficient inventory or component availability.

Unfulfillable Orders

Orders that cannot be fulfilled.

Unsellable Inventory

Inventory that is no longer available for sale due to expiration or Sellable Until date restrictions.

Did this answer your question?