Material Requirement Planning (MRP): Steps & Example

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

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

  1. Break the plan down through the BOM. Multiply each product's quantity by its BOM to get the gross requirement for each part.

  2. Subtract stock and open orders. Net requirement = gross requirement − available stock − open orders. If the answer is zero or less, you order nothing.

  3. Round to order quantities. Round up to the supplier's minimum order quantity (MOQ) or your lot size.

  4. 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.

Book a demo →

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.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders