Overview
The Supply Overview Grid provides planners with a consolidated view of supply and demand data at the SKU-location level. It presents inventory movements in a ledger-style layout: opening inventory, inflows (deliveries), outflows (usage), and closing inventory — giving planners a clear period-by-period balance of how inventory moves.
Rows are organized in collapsible groups. Expanding a parent row reveals its breakdown. For example, expanding Deliveries shows Firm and Suggested, and expanding Suggested shows On Time and Late.
The grid reflects the chart visualization in the Supply Overview, allowing planners to see trends and patterns across time periods. Planners can click on legend items to show or hide specific data series, making it easier to focus on particular aspects of the supply picture.
Net Inventory (Opening)
Description: The net inventory position at the start of each period, accounting for any outstanding backorders carried forward from the previous period.
Calculation / Logic: Net Inventory (Opening) = Physical Inventory (Opening) − Backorder Balance (from prior period)
Example: Physical opening inventory of 200 and 30 outstanding backorders from last period. Net Inventory (Opening) = 170
Physical
Description: The physical quantity on hand at the start of each period, before any period activity.
Calculation / Logic: Equal to the Physical Inventory (Closing) of the previous period. For the first period, this is the starting inventory uploaded into PLAIO.
Example: Last period ended with 200 units in physical inventory. Physical Inventory (Opening) this period = 200
Deliveries
Description: Total quantity of goods received during the period from both firm and suggested orders.
Calculation / Logic: Deliveries = Firm + Suggested
Example: 80 firm delivery units and 120 suggested delivery units. Deliveries = 200
Firm
Description: Deliveries from firm orders — orders already committed with suppliers.
Calculation / Logic: Quantity delivered based on the Expected Delivery Date uploaded in the Inventory worksheet.
Example: A Firm Order for 80 units with Expected Delivery Date of Feb 1st. 80 units appear as Firm deliveries in Feb.
Suggested
Description: Deliveries from system-generated order suggestions.
Calculation / Logic: Suggested = On Time + Late. Delivery Date = Order Date + Lead Time (from Supplier Constraints).
Example: 100 suggested on time and 20 suggested late. Suggested = 120
On Time
Description: Suggested deliveries fulfilled on the first attempt.
Calculation / Logic: Delivery arrived as originally scheduled without requiring a retry.
Example: An order suggestion for 100 units scheduled for Feb 1st arrives on Feb 1st. On Time = 100
Late
Description: Suggested deliveries fulfilled on a retry attempt — the original delivery could not be completed on time.
Calculation / Logic: Delivery required a retry due to component shortages or other constraints on the original date.
Example: 20 units could not be delivered on Feb 1st due to a component shortage. They were retried and delivered in Mar. Late = 20
Usage
Description: Total quantity of goods that left inventory during the period, including goods sold, goods consumed in production, and goods that became unsellable.
Calculation / Logic: Usage = Sold + Consumed + Unsellable
Example: 60 units sold, 30 consumed, 10 unsellable. Usage = 100
Sold
Description: Goods fulfilled against direct demand (customer sales).
Calculation / Logic: Sold = On Time + Late
Example: 50 units sold on time and 10 sold late (from backorder recovery). Sold = 60
On Time
Description: Direct demand fulfilled immediately from available inventory.
Calculation / Logic: Demand met in the period it was due without delay.
Example: 50 units of customer demand due in Feb fulfilled from Feb inventory. On Time = 50
Late
Description: Direct demand fulfilled from backorder recovery — the demand could not be met when originally due.
Calculation / Logic: Previously backordered sales demand now fulfilled from newly available inventory.
Example: 10 units backordered from Jan fulfilled in Feb when new stock arrived. Late = 10
Consumed
Description: Goods used as components in production (derived demand from BOM).
Calculation / Logic: Consumed = On Time + Late
Example: 25 consumed on time and 5 consumed late. Consumed = 30
On Time
Description: Component demand fulfilled immediately during production allocation.
Calculation / Logic: Components allocated to parent item production without delay.
Example: 25 units of Component B allocated to produce Item A in Feb. On Time = 25
Late
Description: Component demand fulfilled from shortage recovery — the components were not available when originally needed.
Calculation / Logic: Previously short components now allocated from newly available inventory.
Example: 5 units of Component B were short in Jan, recovered and consumed in Feb. Late = 5
Unsellable
Description: Quantity of items that became unsellable during the period due to shelf life expiry.
Calculation / Logic: Items become unsellable when Simulation Date ≥ Sellable Until Date. Sellable Until Date = Expiry Date − Minimum Remaining Shelf Life.
Example: A batch expiring Jan 1st with 1-month minimum remaining shelf life becomes unsellable on Dec 1st. Unsellable = the quantity in that batch.
Net Inventory (Closing)
Description: The net inventory position at the end of each period, accounting for outstanding backorders.
Calculation / Logic: Net Inventory (Closing) = Physical Inventory (Closing) − Backorder Balance
Example: 150 units physical closing inventory and 20 outstanding backorders. Net Inventory (Closing) = 130
Physical
Description: The physical quantity on hand at the end of the period after all transactions.
Calculation / Logic: Physical Inventory (Closing) = Physical Inventory (Opening) + Deliveries − Sold − Consumed − Unsellable
Example: Opening 200, Deliveries 100, Sold 60, Consumed 30, Unsellable 10. Physical (Closing) = 200
Backorders
Description: Total outstanding backorder balance at the end of the period.
Calculation / Logic: Backorders = Sales Backorder Balance + Consumption Backorder Balance
Example: 12 sales backorders and 8 consumption backorders outstanding. Backorders = 20
Sales
Description: Cumulative unfulfilled direct demand (customer orders not yet delivered).
Calculation / Logic: Sales Backorder Balance = prior balance + Created − Fulfilled (cannot go below zero)
Example: Prior balance 10, 5 new backorders created, 3 fulfilled. Sales Backorder Balance = 12
Created
Description: New sales backorders generated during the period when direct demand exceeded available inventory.
Calculation / Logic: Quantity of direct demand that could not be fulfilled from inventory in the current period.
Example: 50 units of customer demand but only 45 units available. Created = 5
Fulfilled
Description: Previously backordered sales demand fulfilled during the period.
Calculation / Logic: Backorders recovered when new inventory becomes available. Backorders are fulfilled before new demand.
Example: 3 units of prior backorders fulfilled from newly arrived inventory. Fulfilled = 3
Consumption
Description: Cumulative unfulfilled derived demand (component shortages in production).
Calculation / Logic: Consumption Backorder Balance = prior balance + Created − Fulfilled (cannot go below zero)
Example: Prior balance 5, 6 created, 3 fulfilled. Consumption Backorder Balance = 8
Created
Description: New consumption backorders generated when component demand exceeded available inventory.
Calculation / Logic: Quantity of derived demand that could not be allocated during production.
Example: Parent item needs 20 units of a component but only 14 available. Created = 6
Fulfilled
Description: Previously backordered component demand fulfilled during the period.
Calculation / Logic: Component backorders recovered when new inventory becomes available.
Example: 3 units of prior component backorders fulfilled. Fulfilled = 3
Shortage
Description: Component quantity that could not be fulfilled and remains unrecoverable in the current period.
Calculation / Logic: Shortage quantity within the consumption backorder that has not been recovered.
Example: 2 units of a component remain short after all available inventory has been allocated. Shortage = 2
Safety Stock
Description: The target safety stock quantity for the given period.
Calculation / Logic: Based on Safety Stock Policy (Fixed or Dynamic). Dynamic = Sum of the next X periods of Demand.
Example:
Demand: Feb = 10, Mar = 20, Apr = 30
Dynamic Safety Stock (2-month coverage):
Jan 1st: 10 + 20 = 30
Feb 1st: 20 + 30 = 50
Mar 1st: 30 + 0 = 30
Months of Inventory
Description: Projected inventory coverage expressed in months, based on rolling forward demand. The number of months (X) used in the calculation can be configured per SKU for more granular coverage targets.
Calculation / Logic: Months of Inventory = Physical Inventory (Closing) ÷ Average(next X months of demand). Returns zero if inventory is negative. Not calculated if demand is zero.
Example: 300 units in closing inventory and average monthly demand of 100 over the next 3 months. Months of Inventory = 3.0
Demand
Description: Total demand for the SKU-location in the period.
Calculation / Logic: Demand = Sales + Consumption
Example: 80 units of sales demand and 40 units of consumption demand. Demand = 120
Sales
Description: Demand for items sold directly to customers, sourced from forecasts or external customer orders. Previously called Direct Demand.
Calculation / Logic: Demand from forecasts and firm customer orders.
Example: Forecasted demand of 80 units. Sales = 80
Consumption
Description: Component demand created when parent items are planned for production. Previously called Derived Demand. This demand is passed down through the bill of materials (BOM) structure.
Calculation / Logic: Parent item order quantity × component quantity per unit, summed across all parent items.
Example: Item A requires 2 units of Item B. An order for 20 units of A creates Consumption demand of 40 for B.
Orders
Description: Total quantity of supply orders for the SKU-location.
Calculation / Logic: Orders = Order Suggestions + Firm Orders
Example: 500 suggested and 250 firm. Orders = 750
Order Suggestions
Description: System-generated orders to meet demand and maintain safety stock levels.
Calculation / Logic: Generated by PLAIO based on demand, inventory projections, and safety stock targets.
Example: PLAIO suggests ordering 500 units to cover projected demand and maintain safety stock.
Unfulfillable Suggestions
Description: Order suggestions that cannot be fully sourced because required components are not available.
Calculation / Logic: Unfulfillable Suggestions = Order Suggestions − Fulfillable Order Suggestions
Example: 500 units suggested but only 400 worth of components available. Unfulfillable Suggestions = 100
Firm Orders
Description: Orders already committed with suppliers, imported into PLAIO to track expected incoming inventory.
Calculation / Logic: Uploaded from ERP or firmed within PLAIO. Requires PO number assignment.
Example: A Firm Order for 250 units placed with a supplier last month.
Unfulfillable Firm Orders
Description: Firm orders that cannot be fully sourced because required components are not available.
Calculation / Logic: Depends on Firm Order Allocation Timing setting. At Simulation Start: based on component inventory at simulation start. At Order Date: all Firm Orders are considered fulfillable.
Example: Firm order for 250 units but only 200 worth of components available at simulation start. Unfulfillable Firm Orders = 50
COGS Orders
Description: Cost of goods sold for all supply orders.
Calculation / Logic: COGS Orders = COGS Order Suggestions + COGS Firm Orders
Example: $2,500 COGS Order Suggestions + $1,250 COGS Firm Orders = $3,750
COGS Order Suggestions
Description: COGS for order suggestions, based on item-level unit COGS.
Calculation / Logic: COGS Order Suggestions = Order Suggestions Quantity × Item Unit COGS
Example: 500 units × $5 = $2,500
COGS Firm Orders
Description: COGS for firm orders, based on item-level unit COGS.
Calculation / Logic: COGS Firm Orders = Firm Orders Quantity × Item Unit COGS
Example: 250 units × $5 = $1,250
COGS Unsellable
Description: COGS for inventory that became unsellable due to shelf life expiry.
Calculation / Logic: COGS Unsellable = Unsellable Quantity × Item Unit COGS
Example: 20 unsellable units × $5 = $100