Manufacturing resource planning (MRP II) is a method for the effective planning of all resources of a manufacturing company. Ideally, it addresses operational planning in units, financial planning, and has a simulation capability to answer "what-if" questions and is an extension of closed-loop MRP (Material Requirements Planning).
This is not exclusively a software function, but the management of people skills, requiring a dedication to database accuracy, and sufficient computer resources. It is a total company management concept for using human and company resources more productively.
Key functions and features
MRP II is not a single specific proprietary software system and can thus take many forms. It is almost impossible to visualize an MRP II system that does not use a computer, but an MRP II system can be based on either purchased–licensed or in-house software.
- Master production schedule (MPS)
- Item master data (technical data)
- Bill of materials (BOM) (technical data)
- Production resources data (manufacturing technical data)
- Inventories and orders (inventory control)
- Purchasing management
- Material requirements planning (MRP)
- Shop floor control (SFC)
- Capacity planning or capacity requirements planning (CRP)
- Standard costing (cost control) and frequently also Actual or FIFO costing, and Weighted Average costing.
- Cost reporting / management (cost control)
together with auxiliary systems such as:
and related systems such as:
The MRP II system integrates these modules together so that they use common data and freely exchange information, in a model of how a manufacturing enterprise should and can operate. The MRP II approach is therefore very different from the "point solution" approach, where individual systems are deployed to help a company plan, control or manage a specific activity. MRP II is by definition fully integrated or at least fully interfaced.
MRP and MRPII
History and evolution
Material requirements planning (MRP) and manufacturing resource planning (MRPII) are predecessors of enterprise resource planning (ERP), a business information integration system. The development of these manufacturing coordination and integration methods and tools made today's ERP systems possible. Both MRP and MRPII are still widely used, independently and as modules of more comprehensive ERP systems, but the original vision of integrated information systems as we know them today began with the development of MRP and MRPII in manufacturing.
MRP (and MRPII) evolved from the earliest commercial database management package developed by Gene Thomas at IBM in the 1960s. The original structure was called BOMP (bill-of-materials processor), which evolved in the next generation into a more generalized tool called DBOMP (Database Organization and Maintenance Program). These were run on mainframes, such as IBM/360.
The vision for MRP and MRPII was to centralize and integrate business information in a way that would facilitate decision making for production line managers and increase the efficiency of the production line overall. In the 1980s, manufacturers developed systems for calculating the resource requirements of a production run based on sales forecasts. In order to calculate the raw materials needed to produce products and to schedule the purchase of those materials along with the machine and labor time needed, production managers recognized that they would need to use computer and software technology to manage the information. Originally, manufacturing operations built custom software programs that ran on mainframes.
Material requirements planning (MRP) was an early iteration of the integrated information systems vision. MRP information systems helped managers determine the quantity and timing of raw materials purchases. Information systems that would assist managers with other parts of the manufacturing process, MRPII, followed. While MRP was primarily concerned with materials, MRPII was concerned with the integration of all aspects of the manufacturing process, including materials, finance and human resources.
Like today's ERP systems, MRPII was designed to tell us about a lot of information by way of a centralized database. However, the hardware, software, and relational database technology of the 1980s was not advanced enough to provide the speed and capacity to run these systems in real-time, and the cost of these systems was prohibitive for most businesses. Nonetheless, the vision had been established, and shifts in the underlying business processes along with rapid advances in technology led to the more affordable enterprise and application integration systems that big businesses and many medium and smaller businesses use today.
Material requirements planning (MRP) and manufacturing resource planning (MRPII) are both incremental information integration business process strategies that are implemented using hardware and modular software applications linked to a central database that stores and delivers business data and information.
MRP is concerned primarily with manufacturing materials while MRPII is concerned with the coordination of the entire manufacturing production, including materials, finance, and human resources. The goal of MRPII is to provide consistent data to all members in the manufacturing process as the product moves through the production line.
Paper-based information systems and non-integrated computer systems that provide paper or disk outputs result in many information errors, including missing data, redundant data, numerical errors that result from being incorrectly keyed into the system, incorrect calculations based on numerical errors, and bad decisions based on incorrect or old data. In addition, some data is unreliable in non-integrated systems because the same data is categorized differently in the individual databases used by different functional areas.
MRPII systems begin with MRP, material requirements planning. MRP allows for the input of sales forecasts from sales and marketing, or of actual sales demand in the form of customers orders. These demands determine the raw materials demand. MRP and MRPII systems draw on a master production schedule, the breakdown of specific plans for each product on a line. While MRP allows for the coordination of raw materials purchasing, MRPII facilitates the development of a detailed production schedule that accounts for machine and labor capacity, scheduling the production runs according to the arrival of materials. An MRPII output is a final labor and machine schedule. Data about the cost of production, including machine time, labor time and materials used, as well as final production numbers, is provided from the MRPII system to accounting and finance.
For the companies that want to integrate their other departments with their manufacturing management, ERP software are necessary.
MRP II systems can provide:
- Better control of inventories
- Improved scheduling
- Productive relationships with suppliers
For design / engineering:
- Improved design control
- Better quality and quality control
For financial and costing:
- Reduced working capital for inventory
- Improved cash flow through quicker deliveries
- Accurate inventory records
Authors like Pochet and Wolsey  argue that MRP and MRP II, as well as the planning modules in current APS and ERP systems, are actually sets of heuristics. Better production plans could be obtained by optimization over more powerful mathematical programming models, usually integer programming models. While they acknowledge that the use of heuristics, like those prescribed by MRP and MRP II, were necessary in the past due to lack of computational power to solve complex optimization models, this is mitigated to some extent by recent improvements in computers.
- Bill of materials
- Bill of resources
- Document automation for Supply Chain and Logistics
- Enterprise resource planning (ERP)
- Just-in-time (business)
- Material requirements planning (MRP)
- Scheduling (production processes)
- Supply chain management
- Distribution resource planning
- Warehouse management system
- Warehouse control system
- Product data management
- Chris Kraul (March 22, 1989). "DataWorks of San Diego, a closely held ..." The Los Angeles Times.
- Christopher Gray; Darryl Landvater. "MRP II: The History, The Problems, The Future". Computerworld.
- Third Edition Carol A. Ptak; Chad Smith (2011). Material Requirements Planning. ISBN 978-0-0717-5563-4.
- Shum, Paul (2003). Knowledge and Innovation Culture as Determinants of Financial Performance in New Product Development. Australia: The International Journal of Knowledge, Culture and Change Management. Archived from the original on 2016-03-15. Retrieved 2008-06-27.
- Monk, E. and Wagner, B., Concepts in Enterprise Resource Planning, 2nd Edition, 2006, Editor, Mac Mendelsohn, Canada: Thomson Course Technology.
- "Material Requirements Planning (MRP)" (PDF).
- "Material Requirements Planning (MRP)". Inc.
- Wolsey, Laurence (2006). Production Planning by Mixed Integer Programming. Springer. ISBN 978-0-387-29959-4.