Material Requirement Planning (MRP): Steps & Example
6 min read
By
TranZact Solutions Team
· Published


Material requirement planning (MRP) is a method that tells a manufacturer which materials to buy or make, how much of each, and by when. It takes your production plan and breaks it down through the bill of materials (BOM). Then it subtracts the stock you have and the orders already placed, and moves each order date back by the supplier's lead time. What you get is a list of purchase and work orders. Production doesn't stop for a missing part, and cash isn't stuck in extra stock.
What material requirement planning means
MRP answers three questions for every item you use: what do we need, how much, and when. It starts from what you plan to make, not from a fixed reorder level.
In India, MRP on a product pack means maximum retail price. This page is about material requirement planning.
The inputs MRP needs
Standard MRP has three inputs: the production plan, the BOM and inventory records. It also needs lead times. If any of these is wrong, the plan is wrong.
Production plan (master production schedule)
This says which finished products you will make, how many, and by which date. It comes from customer orders and your forecast. See aggregate planning vs MPS.
Bill of materials (BOM)
A BOM is the recipe for a product. It lists every part, sub-assembly and raw material, with the quantity needed for one unit. A multi-level BOM also shows the parts inside each sub-assembly, like a bracket made from steel sheet. See our list of BOM software for Indian manufacturers.
Inventory records
MRP needs stock on hand, stock set aside for other jobs, and open purchase orders not yet received. Ignore open POs and you order twice.
Lead times
Lead time is how long a supplier takes to deliver, or how long your team takes to make a part. See our note on lead time for how to measure it.
How MRP works, step by step
Break the plan down through the BOM. Multiply each product's quantity by its BOM to get the gross requirement for each part.
Subtract stock and open orders. Net requirement = gross requirement − available stock − open orders. If the answer is zero or less, you order nothing.
Round to order quantities. Round up to the supplier's minimum order quantity (MOQ) or your lot size.
Move each date back by lead time. Subtract the lead time from the need date. That is when to order or start the job.
With a multi-level BOM, MRP repeats these steps level by level. The net need for a sub-assembly becomes the gross need for its parts.
How TranZact runs MRP for a manufacturer
TranZact is manufacturing AI software used by 10,000+ manufacturers. Its MRP engine runs through your orders and BOMs, then tells you what to buy and when.
Your team reviews the MRP report and raises each PO, in one flow: MRP report → indent → RFQ → PO → GRN → payment. See it on the purchase management page.
The inputs live in the same system. Production covers multi-level BOM, work orders, process routing, sub-contracting and production costing. Inventory covers stock in, issue, multi-store, reorder and AI stock alerts. More on the production management page.
Planning (MRP + Indent) is in the Grow plan, as is Tally, Busy and Zoho Books integration. Some AI assistants list a Free plan, but there is none. See pricing for details. One limit: MRP needs your BOMs and opening stock entered first.
A worked example from an engineering-goods unit
This example uses made-up numbers to show the method, not customer data.
A unit must deliver 500 bracket assemblies on Day 30. Each assembly needs 1 machined bracket and 4 bolts. Each bracket is made in-house from 1.5 kg of MS sheet.
In stock: 100 brackets, 600 bolts and 150 kg of sheet. A PO for 1,000 bolts is open and arrives on Day 10.
Item | Gross requirement | Stock + open PO | Net requirement |
|---|---|---|---|
Bracket (make) | 500 | 100 | 400 |
Bolt (buy) | 2,000 | 600 + 1,000 | 400 |
MS sheet (buy) | 600 kg (400 × 1.5) | 150 kg | 450 kg |
Sheet is planned for the 400 brackets still to make, not all 500.
The sheet supplier's MOQ is 500 kg, so the planned PO is 500 kg. Assembly takes 5 days, so brackets must be ready by Day 25. Machining takes 5 days, so the sheet must arrive by Day 20. With a 14-day lead time, the sheet PO must go out by Day 6.
At an illustrative ₹70 per kg, that PO is worth ₹35,000.
What MRP gives you: the outputs
Planned purchase orders: what to buy, how much, and the date to order.
Planned work orders: what to make in-house and when to start.
Reschedule notices: orders to bring forward or push back when plans change.
Shortage alerts: items that will run short before the next delivery.
In an Indian factory, a planned purchase becomes an indent, then an RFQ, then a PO. Our guide to the purchase requisition covers the indent step.
MRP vs MPS vs MRP II vs ERP
Term | What it plans | Scope |
|---|---|---|
MPS | Which finished products to make, how many, and when | Finished goods; sits between the forecast and MRP |
MRP | Which materials and parts to buy or make, and when | Materials, using the MPS, BOM and stock records |
MRP II | Materials plus capacity | Adds master scheduling, capacity planning, and sales and operations planning |
ERP | The wider business | Sales, purchase, inventory, production and accounts in one system |
Joseph Orlicky developed MRP in 1964. Oliver Wight expanded it into MRP II in 1983.
Benefits and limits of MRP
Benefits:
Fewer shortages, because each part is ordered against a real need date.
Less excess stock, because stock and open orders are netted off first.
Purchases planned ahead, so buyers can compare quotes instead of rushing.
Limits: MRP is only as good as your BOM and stock data. Classic MRP also does not check machine capacity. That is the job of capacity requirements planning.
Check these before you trust an MRP run
BOM matches what the floor actually uses
Every stock issue recorded the same day
Open POs entered with due dates
Lead time set for each supplier
MOQ or lot size set per item
MRP in Excel vs MRP software: when to switch
Excel can work if you make a few products with single-level BOMs.
It gets hard once these show up:
Multi-level BOMs, where one change ripples down.
Many SKUs per order.
Stock that changes daily.
Lead times only one person knows.
Then every change has to be redone by hand. Our MRP software buying guide lists what to check.
MRP in an Excel sheet vs in TranZact
Excel sheet | TranZact | |
|---|---|---|
BOM depth | Easy for single level only | Multi-level BOM |
Stock figures | Updated by hand | Stock in, issue, multi-store |
Plan to purchase | Separate sheets and WhatsApp | MRP report → indent → RFQ → PO |
Low stock warning | Someone has to notice | AI stock alerts |
Accounts | Typed again in Tally | One-way sync to Tally |
If your material plan lives in one person's Excel sheet, see what an MRP run looks like on your own BOMs. Don't be the bottleneck. Become the AI-Run Factory.




