How to Best Use The Brightwork Research MRP Calculator

Executive Summary

  • We cover MRP and how it works, as well as material requirements planning in production systems.
  • We have an MRP calculation form and calculate an MRP example.
  • This article is for anyone who wants to validate their assumptions around MRP calculation.

Introduction to the MRP Requirements Calculator

MRP stands for “materials requirements planning.”

“Material requirements planning software (MRP) is used to describe the process of planning manufacturing inventory – what products to make and what items to buy, when, how much, and from who – all based on supply and demand.”What is MRP Software

What is MRP?

MRP is one of the most important methods in supply chain planning. In performing research for this book, I found that MRP is the most commonly used term in supply chain planning, the next closest one being inventory management. This is true even though MRP is an old planning method, and more advanced methods of creating the initial supply and production plan have been created. However, MRP, and its cousin DRP (MRP used for bringing material into the supply network, while DRP pushes material through the supply network), while old, are still the most common methods of performing supply, production and deployment planning. Interestingly, MRP is a much more commonly used term than DRP, or distribution resource planning, which is almost always used in conjunction with MRP and is the other topic covered in this book. In most instances, when a company talks about their MRP system, they actually mean their MRP/DRP system. But while both methods are used, I will be focusing on MRP for this book.

How Does MRP Work

MRP is a procedure for calculating dependent requirements based upon a bill of materials working backwards from the demand (also called “independent requirements”) of a forecasted item (MRP is emphatically a forecast-based planning method) along with sales orders which, when combined with lead times, creates a series of planned production orders and purchase requisitions which are all timed to allow the demand to be met with the planned supply. MRP has these frequently unstated prerequisites:

  1. “Every inventory item moves into and out of stock.
  2. All components of an assembly are required at the time the assembly order is released.
  3. Components are disbursed and used in discrete lots.
  4. Each manufacturing item can be processed independently of any other.” – Orlicky’s Material Requirements Planning.

Material Requirements Planning MRP does some things in one procedure. It is a great time saver because of this ability, and of all the supply planning methods, it is the easiest to understand.

  • It explodes the bill of material.
  • It then assigns production and procurement quantities to the appropriate time buckets.

However, one of its main calculations is the creation of gross requirements and net requirements, which is the topic of this calculator.

Using MRP Calculation in Supply and Production Planning Systems

Material Requirements Planning MRP is still the most common method used in supply and production planning. It does both supply planning because it creates the planned purchase orders (called purchase requisitions).

It also does production planning, because it creates planned production orders.

How the MRP Calculation Form Works as an MRP Example

It is almost always combined with DRP with Material Requirements Planning creating the production and procurement plan and with DRP creating the deployment plan.

  • This is because Material Requirements Planning only brings material into the supply network.
  • It does not move the material through the supply network. This is another method also uses the same calculation approach to gross and net requirements and is often called DRP, but is broadly known as the deployment planning thread.
  • In SAP it also tends to show the same rows as Material Requirements Planning with forecast consumption. That is how sales orders consume the forecast, by working the same way.

How the MRP Calculation Form Works as an MRP Example

This MRP calculation form requires input to provide output. However, it also has default values. You can change any input value and the rest of the formula — the output will change immediately. You can continue making changes, and the form will always update without having to press any button or refresh. You can use the MRP calculation form as an MRP example to explain how the calculation in an MRP system works.

For the dynamic safety, stock calculator see this article.

Learn about the history of MRP at this article.

Search Our Supply Planning Articles

Supply Planning Research Contact

  • Interested in Our Supply Planning Research?

    The software space is controlled by vendors, consulting firms and IT analysts who often provide self-serving and incorrect advice at the top rates.

    • We have a better track record of being correct than any of the well-known brands.
    • If this type of accuracy interests you, contact us and we will be in touch.

Brightwork MRP & S&OP Explorer

Improving Your Supply Planning, MRP & S&OP Software

Brightwork Research & Analysis offers the following supply planning tuning software, which is free to use in the beginning. See by clicking the image below:

References

Repairing the MRP System Book

MRP System

Repairing your MRP System

What is the State of MRP?

MRP is in a sorry state in many companies. The author routinely goes into companies where many of the important master data parameters are simply not populated. This was not supposed to be the way it is over 40 years into the introduction of MRP systems.

Getting Serious About MRP Improvement

Improving MRP means both looking to systematic ways to manage the values that MRP needs, regardless of the MRP system used. It can also suggest evaluating what system is being used for MRP and how much it is or is not enabling MRP to be efficiently used. Most consulting companies are interested in implementing MRP systems but have shown little interest in tuning MRP systems to work to meet their potential.

The Most Common Procedure for Supply and Production Planning?

While there are many alternatives to MRP, MRP, along with its outbound sister method DRP, is still the most popular method of performing supply, production planning, and deployment planning. In the experience of the author, almost every company can benefit from an MRP “tune up.” Many of the techniques that the author uses on real projects are explained in this book.

Chapters

  • Chapter 1: Introduction
  • Chapter 2: The Opportunities to Improve MRP
  • Chapter 3: Where Supply Planning Fits Within the Supply Chain
  • Chapter 4: MRP Versus MRP II
  • Chapter 5: MRP Explained
  • Chapter 6: Net Requirements and Pegging in MRP
  • Chapter 7: Where MRP is Applicable
  • Chapter 8: Specific Steps for Improving MRP
  • Chapter 9: Conclusion
  • Appendix A: Calculating MRP

Software Ratings: Supply Planning

Software Ratings

Brightwork Research & Analysis offers the following free supply planning software analysis and ratings. See by clicking the image below:

software_ratings