MRP Planner

Production Plan

Legend:

Requirement

Confirmed Incoming

Planned Order

Inv. Projection

Low Stock

Shortage

nBOM qty/unit

How it works: Download each template, fill in your data, upload. All processing runs locally in your browser — no data is sent to any server.

Production Plan

Weekly production qty per product.
Column 1: Product · Remaining columns: Monday dates (e.g. 6/23/2026) — one column per week, 52 weeks total.

Click to upload .xlsx or .csv

BOM

BOM qty per unit per product (0 = not used).
Columns: MatCode, MatName, Prod-A … Prod-F

Click to upload .xlsx or .csv

Inventory — On-Hand

Current stock on hand only.
Columns: MatCode, OnHand

Click to upload .xlsx or .csv

Material Master

Unit price, lead time, MOQ, logistics cost & type, country of origin, duty %.

Click to upload .xlsx or .csv

Incoming Delivery Schedule

PO-level delivery schedule (Incoming_Delivery sheet from Inventory template).
Columns: MatCode, ETD, ETA, Ordered Qty., PO Number, Payment Term, Unit Price, Total Material Cost

Click to upload

Production Plan: not uploaded

BOM: not uploaded

Inventory: not uploaded

Material Master: not uploaded

Incoming Delivery: not uploaded

Order Action Plan

Production Plan

BOM

Inventory — On-Hand

Material Master

Incoming Delivery Schedule