V5 Ultimate
Module · MRP

MRPmulti-level, weekly, FEFO-honest.

V5's MRP explodes multi-level formulas against a Holt/Croston/Naive consensus forecast, walks on-hand lots earliest-expiry-first against weekly demand, pegs every requirement back to the firm sales order or forecast week that drove it, and groups planned buys into vendor-ready PO drafts you approve straight onto the supplier portal.

Start free — no card
One run · the floor wakes up with a plan

MRP that pegs every line back to a firm order.

Watch a real V5 MRP cycle: multi-level explosion across a 6-week horizon, FEFO lot-expiry-aware netting that flags stock you own but won't reach in time, every buy line pegged firm-SO vs forecast, and vendor-grouped auto-POs pushed straight to the supplier portal.

Multi-level explosion
formula → sub-assembly → leaf · 6-week horizon · process & discrete on one engine
FEFO lot walk
released lots only · QC-hold lots excluded · earliest expiry consumed first
EXPIRING flag
lot residual that won't be consumed before its expiry week is flagged at-risk
Peg drill-down
every line traces back to firm sales orders and forecast weeks that drove it
06:00:00
MRP-RUN · horizon 6w
Explode formula
RUN-2026-06-15
FG · TBT-500MG · formula v14
level · componentweekly gross (W1–W6)
TBT-500MG1,200 ea
L-AMB-0921240.0 kg
EXC-MCC-10160.0 kg
SUB-COAT-V3
POLY-HPMC-K4M18.0 kg
EXC-TALC-2006.0 kg
PKG-BLISTER-101,200 ea
explosion complete · 7 lines · 2 levels · weekly buckets ready for netting
Firm vs forecast split
per-week split of demand by firm SO line vs Holt/Croston/Naive forecast
Vendor-grouped auto-PO
buy lines group by preferred vendor · one click approves & opens the PO
Supplier portal push
approved PO drops a notification into the supplier's portal · ack flows back
Save run + Δ vs current
every run snapshots; History lists past runs with a delta-vs-current column
Connected

MRP sits in the middle — demand in, signed supply out.

Open sales orders, the consensus forecast, released-only lot on-hand, QC holds and preferred-vendor lead times all feed the planner. Approved POs flow out to the supplier portal — with the portal-ack timestamp flowing back onto the PO.

Sales orders & forecast
Open SOs feed firm demand; the forecast engine (Holt + Croston + Naive auto-pick, planner overrides) feeds the rest.
Work orders
Released WO component requirements bucket into the WO's scheduled-start week as firm allocations.
Lab QC holds
Only released lots are eligible for the FEFO walk — QC-hold lots disappear from availability automatically.
Planner
MRP
save · approve
Inventory & lots
Lot-level on-hand with expiry dates drives the FEFO walk and the EXPIRING at-risk flag on every buy row.
Supplier portal
Approved auto-POs land in the supplier's portal with a notification; the portal-ack timestamp flows back onto the PO.
Finite capacity
Capacity tab flags weeks where planned WOs exceed line capacity — re-sequence before approving the run.
Deterministic math. Saved runs. Approved plans.
Net = gross − on-hand − scheduled receipts + safety. Every run can be snapshotted, approved, and compared.
When it gets messy

The edge cases a real planner lives in.

Textbook MRP assumes lead-times don't move, lots never hold, and sales never push a rush. Here are four moments where V5 doesn't shrug.

Lot expires before its demand week

FEFO walks lots earliest-expiry-first. Any residual that won't be consumed before its expiry week surfaces as an EXPIRING badge on the buy row — lot, at-risk qty, expiry date.

FEFO walk · L-AMB-0921demand W2 · 40 kg
K221 · exp 2026-06-2218.0 kg ✓
K228 · exp 2026-07-0822.0 kg · EXPIRING
at-risk: 22.0 kg won't be consumed before W6 expiry

Need-by earlier than today + lead time

Planned release week goes negative — MRP flags the line as EXPEDITE (any_expedite). The planner sees every buy line that can't make its required week even if ordered today.

need-by W2today + lead
W1
W2
W3
W4
EXPEDITEplanned release week = −1

QC puts a lot on hold

FEFO netting walks released lots only. A lot moved to hold disappears from MRP availability the next run — no manual exclusion, no double-counting.

K228 · released186.4 kg ✓ in FEFO
K229 · ON HOLD142.0 kg
held lots excluded · next run's net for L-AMB-0921 jumps to 95.6 kg

Rush SO mid-week

Re-run MRP and Save run. The History dialog lists every saved snapshot with headline counts and a Δ-vs-current column — Approve locks the new plan, Archive soft-deletes the old.

history · mrp_runs
RUN-0612 · approved12 buy · 4 WO
RUN-0615 · currentΔ +2 buy · +1 expedite
rush SO drove +2 lines · approve to lock the new plan
Engineered on
21 CFR Part 11 e-signatures
Immutable audit trail
Multi-tenant RLS isolation
GS1-128 license plates
Two-way ERP adapters
Instead of an FAQ

Just ask V5 — it knows the product cold.

Pick a question or type your own. V5 answers grounded in how mrp — multi-level weekly planning with fefo netting & auto-po | v5 ultimate actually behaves on the floor.

Got questions, or want to see it on your shop floor?

Ask V5 — our code-aware assistant — or spin up a workspace. Both are free.