Supply Overview Grid

The Supply Overview Grid gives planners a consolidated view of supply and demand at SKU-location level. It presents inventory movements as a ledger: opening inventory, inflows (deliveries), outflows (usage), and closing inventory — a clear period-by-period balance of how inventory moves.

Rows are organised in collapsible groups. Expanding a parent row reveals its breakdown: expanding Deliveries shows Firm and Suggested; expanding Suggested shows On Time and Late.

The grid reflects the chart visualisation in the Supply Overview, so trends and patterns line up across time periods. Click legend items to show or hide series and focus on one aspect of the supply picture.

Inventory rows

Net Inventory (Opening)

The net inventory position at the start of each period, accounting for backorders carried forward.

• Calculation: Physical Inventory (Opening) − Backorder Balance (from prior period)
• Example: Physical opening inventory of 200 and 30 outstanding backorders → Net Inventory (Opening) = 170

Physical (Opening)

The physical quantity on hand at the start of each period, before any period activity.

• Calculation: Equal to the Physical Inventory (Closing) of the previous period. For the first period, the starting inventory uploaded into PLAIO.
• Example: Last period ended with 200 units → Physical Inventory (Opening) = 200

Net Inventory (Closing)

The net inventory position at the end of each period, accounting for outstanding backorders.

• Calculation: Physical Inventory (Closing) − Backorder Balance
• Example: 150 units physical closing and 20 outstanding backorders → Net Inventory (Closing) = 130

Physical (Closing)

The physical quantity on hand at the end of the period after all transactions.

• Calculation: Physical (Opening) + Deliveries − Sold − Consumed − Unsellable
• Example: Opening 200, Deliveries 100, Sold 60, Consumed 30, Unsellable 10 → Physical (Closing) = 200

Deliveries

Total quantity received during the period from both firm and suggested orders.

• Calculation: Firm + Suggested
• Example: 80 firm and 120 suggested → Deliveries = 200

Firm — deliveries from orders already committed with suppliers. Quantity delivered based on the Expected Delivery Date uploaded in the Inventory worksheet. A firm order for 80 units with Expected Delivery Date of 1 Feb appears as 80 Firm deliveries in Feb.

Suggested — deliveries from system-generated suggestions. Suggested = On Time + Late, where Delivery Date = Order Date + Lead Time (from Supplier Constraints).

On Time (Deliveries) — suggested deliveries fulfilled on the first attempt, as originally scheduled.

Late (Deliveries) — suggested deliveries fulfilled on a retry, because the original delivery could not complete on time. 20 units that could not be delivered on 1 Feb due to a component shortage, retried and delivered in Mar → Late = 20.

Usage

Total quantity that left inventory during the period — goods sold, goods consumed in production, and goods that became unsellable.

• Calculation: Sold + Consumed + Unsellable
• Example: 60 sold, 30 consumed, 10 unsellable → Usage = 100

Sold — goods fulfilled against direct demand (customer sales). Sold = On Time + Late.

On Time (Sold) — direct demand fulfilled immediately from available inventory.

Late (Sold) — direct demand fulfilled from backorder recovery. 10 units backordered from Jan, fulfilled in Feb when new stock arrived → Late = 10.

Consumed — goods used as components in production (derived demand from BOM). Consumed = On Time + Late.

On Time (Consumed) — component demand fulfilled immediately during production allocation.

Late (Consumed) — component demand fulfilled from shortage recovery.

Unsellable — quantity that became unsellable during the period due to shelf-life expiry. Items become unsellable when Simulation Date ≥ Sellable Until Date, where Sellable Until Date = Expiry Date − Minimum Remaining Shelf Life. A batch expiring 1 Jan with a 1-month minimum remaining shelf life becomes unsellable on 1 Dec.

Backorders

Total outstanding backorder balance at the end of the period.

• Calculation: Sales Backorder Balance + Consumption Backorder Balance
• Example: 12 sales and 8 consumption backorders outstanding → Backorders = 20

Sales (Backorders) — cumulative unfulfilled direct demand. Balance = prior balance + Created − Fulfilled, floored at zero.

Created (Sales) — new sales backorders generated when direct demand exceeded available inventory. 50 units of demand with only 45 available → Created = 5.

Fulfilled (Sales) — previously backordered sales demand fulfilled during the period. Backorders are fulfilled before new demand.

Consumption (Backorders) — cumulative unfulfilled derived demand (component shortages in production). Same balance formula.

Created (Consumption) — new consumption backorders when component demand exceeded available inventory. Parent needs 20 units of a component with only 14 available → Created = 6.

Fulfilled (Consumption) — previously backordered component demand fulfilled during the period.

Shortage — component quantity that could not be fulfilled and remains unrecoverable in the current period.

Targets and coverage

Safety Stock

The target safety stock quantity for the period, based on the Safety Stock Policy (Fixed or Dynamic). Dynamic = sum of the next X periods of demand.

• Example: Demand of Feb 10, Mar 20, Apr 30 with 2-month coverage → 1 Jan: 30; 1 Feb: 50; 1 Mar: 30

Months of Inventory

Projected inventory coverage in months, based on rolling forward demand. The number of months (X) is configurable per SKU.

Returns zero if inventory is negative; not calculated if demand is zero. 300 units closing with average monthly demand of 100 over the next 3 months → 3.0.

Demand

Total demand for the SKU-location in the period. Demand = Sales + Consumption.

Sales (Demand) — demand for items sold directly to customers, from forecasts and firm customer orders. Previously called Direct Demand.

Consumption (Demand) — component demand created when parent items are planned for production, passed down through the BOM. Previously called Derived Demand. Calculation: parent order quantity × component quantity per unit, summed across all parents. Item A requires 2 units of Item B; an order for 20 of A creates Consumption demand of 40 for B.

Orders

Total supply orders for the SKU-location. Orders = Order Suggestions + Firm Orders.

Order Suggestions — system-generated orders to meet demand and maintain safety stock.

Unfulfillable Suggestions — suggestions that cannot be fully sourced because components are unavailable. Calculation: Order Suggestions − Fulfillable Order Suggestions.

Firm Orders — orders already committed with suppliers, imported to track expected incoming inventory. Requires a PO number.

Unfulfillable Firm Orders — firm orders that cannot be fully sourced. Depends on the Firm Order Allocation Timing setting on the location: At Simulation Start evaluates against component inventory at simulation start; At Order Date treats all firm orders as fulfillable.

COGS

COGS Orders — COGS Order Suggestions + COGS Firm Orders.

COGS Order Suggestions — Order Suggestions Quantity × Item Unit COGS. 500 units × $5 = $2,500.

COGS Firm Orders — Firm Orders Quantity × Item Unit COGS. 250 units × $5 = $1,250.

COGS Unsellable — Unsellable Quantity × Item Unit COGS. 20 units × $5 = $100.

See COGS and Supply Value.