Free MRP (Material Requirements Planning) Excel Template
A working MRP spreadsheet: time-phased gross-to-net requirements, lot sizing, and planned order releases offset by lead time, with a worked example you can follow week by week.
What you get
A free .xlsx MRP template with no email and no macros: item master, BOM, MPS, an 8-week MRP grid and a planned orders sheet, already filled with a two-level example so you can watch every formula work before you type in your own parts.
mrp-excel-template.xlsx · 6 sheets · No email required · No macros
Sheets: Instructions, Items, BOM, MPS, MRP, Planned Orders
Why manufacturers still use Excel for this
Material Requirements Planning (MRP) turns a master production schedule into a purchasing and production plan for every component. It answers the question every planner faces: given what we are going to build, what do we need to buy or make, how many, and when do we need to order it? Done well, MRP prevents stockouts and cuts inventory at the same time. Done badly, it is one of the biggest sources of shortages and expediting in a plant.
For small manufacturers without a full ERP, MRP often lives in Excel. That works better than people expect, because MRP is a tabular calculation and Excel was built for tabular calculations. The limits show up when the part count grows past a couple of hundred items, bills of materials go several levels deep, or demand changes every day. At that point the manual updates take longer than the MRP run saves.
This template does the core MRP logic correctly: netting against on hand and scheduled receipts, safety stock, lot-for-lot and fixed lot sizing, and planned order release offset by lead time. The worked example below is the same data that ships in the file, so you can check each number against the spreadsheet.
What's inside the template
Items: the item master
Lead time in weeks, lot rule (lot-for-lot or fixed), lot size, safety stock, on hand, and make or buy for every part.
BOM: quantity per parent
Each component and how many go into its parent. The component's gross requirements are the parent's planned order releases times this quantity.
MPS: finished-good demand
Demand for the end item by week. The top-level MRP grid reads its gross requirements from here.
MRP: the time-phased grid
Per item, per week: gross requirements, scheduled receipts, projected on hand, net requirements, planned order receipts and planned order releases.
Past-due check
Flags any item that needs a receipt inside its lead time, which means the order should already have been placed.
Planned Orders: what to release
Planned order releases for every item by week. Week 1 is the list of orders to place or start now.
How to use this template
A practical walkthrough, from the sample data to a plan built on your own numbers.
- 1
Study the worked example
Open the MRP sheet and follow the table leg (L10) through its 8 weeks. Each row is one formula copied across, and the Instructions sheet spells out every formula in words.
- 2
Set up your item master
On the Items sheet, list each part with its lead time, lot rule, lot size, safety stock and current on hand. Lead times must be in weeks to match the weekly buckets.
- 3
Enter quantities per parent and demand
On the BOM sheet, enter how many of each component go into its parent. On the MPS sheet, enter finished-good demand by week from firm orders and forecast.
- 4
Add scheduled receipts
On the MRP sheet, type orders already placed into the shaded Scheduled receipts rows in the week they will arrive. Everything else recalculates.
- 5
Release orders and clear exceptions
Read the Planned Orders sheet: week 1 is what to order or start now. If an Exception row says PAST DUE, expedite the supplier or move the demand.
Worked example: 4 legs per table, fixed lot of 250
The finished good is a table, T100, needed 50, 60 and 40 in weeks 3, 5 and 7. It has a one-week lead time and a lot-for-lot rule, so T100 orders are released in weeks 2, 4 and 6.
Each table uses 4 legs (L10). L10 starts with 150 on hand, has 100 already arriving in week 1, a two-week lead time and a fixed lot size of 250. This is the L10 grid from the MRP sheet:
| L10 table leg | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 |
|---|---|---|---|---|---|---|---|---|
| Gross requirements | 0 | 200 | 0 | 240 | 0 | 160 | 0 | 0 |
| Scheduled receipts | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Projected on hand (start 150) | 250 | 50 | 50 | 60 | 60 | 150 | 150 | 150 |
| Net requirements | 0 | 0 | 0 | 190 | 0 | 100 | 0 | 0 |
| Planned order receipts | 0 | 0 | 0 | 250 | 0 | 250 | 0 | 0 |
| Planned order releases | 0 | 250 | 0 | 250 | 0 | 0 | 0 | 0 |
Week 4 needs 240 legs but only 50 are left, so the net requirement is 190. The fixed lot rounds that up to 250, which must arrive in week 4 and therefore be ordered in week 2. Week 6 is short by 100, so a second lot of 250 is ordered in week 4. The extra stock from rounding up is why on hand ends at 150 instead of zero.
The MRP formula behind every column: net requirement = MAX(0, gross requirement + safety stock - (projected on hand last week + scheduled receipt)). Projected on hand = last week + scheduled receipt + planned receipt - gross requirement. The planned release is the planned receipt moved earlier by the lead time.
When you outgrow this template
Excel is the right answer for early-stage planning, until it isn't. These are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown spreadsheet planning. EDGEBIC, the current generation of RMDB, is User Solutions' finite capacity scheduling and production planning software. It imports the same orders, routings, work centers and stock from Excel, CSV or your ERP, schedules them against real machine, labor and material limits, and shows the result on a drag-and-drop Gantt chart. It is a one-time license: EDGEBIC APS is $25,000, and EDGEBIC Complete, which adds MRP, inventory and purchasing, is $35,000.
See EDGEBICFrequently asked questions
Is this MRP template really free?+
Yes. Download the .xlsx directly from this page: no email, no sign-up and no macros. It works in Excel 2016 or later, including Microsoft 365.
What is the MRP formula?+
For each item and week: net requirement = MAX(0, gross requirement + safety stock - (projected on hand from last week + scheduled receipt)). The planned order receipt is the net requirement, rounded up to the lot size if the item uses a fixed lot. Projected on hand = last week + scheduled receipt + planned receipt - gross requirement. The planned order release is the planned receipt moved earlier by the lead time.
What is the difference between MRP and MPS?+
The MPS (master production schedule) plans which finished goods to complete and when. MRP (material requirements planning) works out the components and raw materials needed to support that MPS, by exploding it through the bill of materials and offsetting by lead time. The MPS comes first; MRP runs from it.
Which lot sizing rules does the template support?+
Lot-for-lot (order exactly the net requirement) and fixed lot size (round the net requirement up to a multiple of the lot size). Set the rule per item on the Items sheet. Rules such as period order quantity or economic order quantity are not built in.
How many BOM levels does the template handle?+
The file shows two levels: a finished good and one component. To add a component or another level, copy an item block on the MRP sheet and point its gross requirements at its parent's planned order releases times the quantity per. That works for a few dozen parts; beyond that, dedicated MRP software such as RMDB, now EDGEBIC Complete, handles 10+ BOM levels natively.
What happens when demand changes after I run MRP?+
Change the MPS, on hand or scheduled receipts and the whole grid recalculates. What the spreadsheet cannot do is tell you which open orders to reschedule or check that the planned orders fit your machine capacity; that is the job of MRP combined with finite capacity scheduling.
Start with the spreadsheet. Move to EDGEBIC when it breaks.
The template handles the math for a small plan. EDGEBIC is what manufacturers move to when orders, routings and capacity change faster than a spreadsheet can follow: published one-time pricing, and implementation measured in days.