Open PO balance by due month
balance still to receive vs. already received
Open balance
Received
Past due
Coverage status by month
product-months, current demand basis
Short
Below target
OK
Excess
Purchase agreement progress to minimum
tons applied Aug–Oct vs. annual minimumAction queue
what needs a buyer todayCommitted spend by vendor
open PO value at PO costIndex price curve — 2026
source: Invex Index Pricing screen| Agreement | Vendor | Deal / discount | Forms | Term | Base $/ton | Min tons | Max tons | Applied | Projected | Progress to min | To min | Available now | Committed $ | Index 3-mo | Status |
|---|
Click a row for PO-level detail
Tons applied by month
PO tons landing against each agreement
August
September
October
Contract price vs. index
base price against the deal's index curve
source: Open_Purchase_Orders + PO_Detail
| PO / item | Vendor | Product | PPS part | Dest WH | Due | Ordered | Received | Balance | % | Receipt route | $/cwt | Open value | Flag |
|---|
Click a row for the full order trace
Close-out candidates
small open balances worth releasingReceipt pipeline coverage
where the live feed exists today
Goes short — projected stock below zero
Below minimum — above zero but under the MRP minimum
OK
Excess — more than 3× the minimum
No demand
cell value = projected end-of-month stock · click a row for the full month-by-month arithmetic
Replicates the Invex MRP calculation — see the source note above
Earliest shortfalls
when each PPS first drops below its minimumLargest projected shortfalls
worst end-of-month position across the horizonEvery score shows its inputs — no black box
How the recommendation score is built
port these four terms straight to the backend
source: PPS Replenishment Calculations
| Flag | Order by | Deficit | PPS | Product | Vendor | Lead | Min PO | Incr | Min wks | On hand | Finished | Value | Wks cover | Wkly demand | Required buy | Reorder qty |
|---|
Click a row for weekly demand, stock projection and customers
Inventory value by form
on-hand PPS stock at costWeekly demand horizon
aggregate across PPS with demand loadedWeeks of cover distribution
on-hand + finished ÷ average weekly demandWhere the queue sits
every CPS record by approval, PPS link and sales categoryWaiting by customer
who is blockedAge since CPS created
how long the request has been sitting
source: CPS_with_Linked_PPS__Customer
| Age | CPS part | Customer | Description | Grade | Thickness | Category | Part status | Created | Last changed | Suggested PPS | Blocker |
|---|
Rule: cps_approved = 0 AND pps_part = NONE AND sales_category ≠ TP
Control gap — approved without a PPS
non-toll-processing CPS that cleared approval with no PPS attachedTons purchased by mill
ordered tons, current yearAverage purchase price by month placed
weighted $/ton on POs placedVendor scorecard
volume, price, on-time and acknowledgement performance| Vendor | Mill | POs | Ordered tons | Spend $ | Avg $/ton | Open tons | Past-due lines | On-time | Ack rate | Under PA |
|---|
Past-due open lines
due date has passed, balance still open| PO | Vendor | Product | Due | Days late | Balance | Open value |
|---|
Acknowledgements outstanding
ack required, none received| PO | Vendor | Placed | Due | Ordered | Buyer |
|---|
Cancelled purchase orders
last 30 days| PO | Vendor | Buyer | Tons | Cancelled | By | Remark |
|---|
Buys with no purchase agreement
open POs not linked to a PA| PO | Vendor | Product | Ordered | $/cwt | Buyer |
|---|