Material Requirements Planning (MRP): A Comprehensive Guide for CSCP Exam Success
Introduction to Material Requirements Planning (MRP)
Material Requirements Planning (MRP) is one of the most foundational and critical concepts in supply chain management. It serves as the backbone of manufacturing planning and inventory control systems, enabling organizations to determine what materials are needed, how much is needed, and when they are needed to meet production schedules. For CSCP candidates, a thorough understanding of MRP is essential, as it connects upstream supply planning with downstream demand fulfillment.
Why is Material Requirements Planning Important?
MRP is important for several compelling reasons:
1. Inventory Optimization: MRP helps organizations maintain the right amount of inventory — not too much (which ties up capital and increases holding costs) and not too little (which risks stockouts and production delays). By calculating precise material needs based on actual demand, MRP minimizes excess and obsolete inventory.
2. Production Efficiency: By ensuring that all required materials and components are available at the right time, MRP prevents production stoppages and bottlenecks. This leads to smoother manufacturing operations and improved throughput.
3. Customer Service Improvement: When production runs on schedule because materials are available as needed, organizations can meet delivery commitments more reliably, improving customer satisfaction and loyalty.
4. Cost Reduction: MRP reduces costs associated with emergency purchases, expediting fees, excess inventory carrying costs, and production downtime. It enables better negotiations with suppliers through planned and consolidated purchasing.
5. Coordination Across Functions: MRP integrates information from sales, production, purchasing, and inventory management, creating a unified plan that aligns all departments toward common objectives.
6. Dependent Demand Management: Unlike independent demand items (finished goods), dependent demand items (components, raw materials, subassemblies) can be calculated precisely. MRP excels at managing this dependent demand by breaking down finished goods requirements into their component parts.
What is Material Requirements Planning?
Material Requirements Planning (MRP) is a computer-based production planning and inventory control system that calculates the material requirements for manufacturing. It translates a master production schedule (MPS) into a detailed plan for the raw materials, components, and subassemblies needed to produce the finished products.
Key definitions:
- MRP (Material Requirements Planning): A system that uses bill of material data, inventory data, and the master production schedule to calculate requirements for materials. It generates planned orders and recommends rescheduling open orders when due dates and need dates are not aligned.
- Dependent Demand: Demand that is directly derived from the demand for another item. For example, the demand for wheels is dependent on the demand for bicycles.
- Independent Demand: Demand for an item that is unrelated to the demand for other items. Finished goods typically have independent demand driven by customer orders or forecasts.
MRP operates on the principle that if we know what we need to produce (from the MPS), what goes into each product (from the Bill of Materials), and what we already have (from inventory records), we can calculate exactly what we need to procure or produce and when.
How Does MRP Work?
MRP follows a systematic process that involves three primary inputs, a core processing logic, and several outputs.
The Three Primary Inputs:
1. Master Production Schedule (MPS): The MPS is the driving force behind MRP. It specifies what finished products are to be produced, in what quantities, and when. The MPS is derived from customer orders, demand forecasts, and inventory policies. It represents the company's production plan stated in specific configurations, quantities, and dates.
2. Bill of Materials (BOM): The BOM is a structured list of all the materials, components, subassemblies, and raw materials required to manufacture one unit of a finished product. It defines the parent-child relationships between items and specifies the quantity of each component needed. The BOM is organized in levels:
- Level 0: Finished product
- Level 1: Major subassemblies or components
- Level 2: Components of Level 1 items
- And so on...
3. Inventory Status Records (Inventory Records File): These records contain the current status of every item in inventory, including:
- Quantity on hand
- Quantity on order (scheduled receipts)
- Lead times
- Lot sizing rules
- Safety stock requirements
- Allocated quantities
The MRP Processing Logic (MRP Explosion):
The MRP system processes information through the following steps:
Step 1 — Gross Requirements Calculation:
The system starts with the MPS and explodes the BOM to determine the gross requirements for each component at each level. If the MPS calls for 100 bicycles and each bicycle requires 2 wheels, the gross requirement for wheels is 200.
Step 2 — Netting:
The system subtracts available inventory (on-hand plus scheduled receipts) from gross requirements to determine net requirements. This prevents ordering materials that are already available.
Net Requirements = Gross Requirements - Scheduled Receipts - On-Hand Inventory + Safety Stock
Step 3 — Lot Sizing:
Net requirements are adjusted based on lot-sizing rules. Common lot-sizing techniques include:
- Lot-for-Lot (L4L): Order exactly what is needed — minimizes inventory but may increase ordering costs
- Fixed Order Quantity (FOQ): Order a predetermined fixed quantity
- Economic Order Quantity (EOQ): Order the quantity that minimizes total ordering and holding costs
- Period Order Quantity (POQ): Order enough to cover demand for a fixed number of periods
- Least Unit Cost: Choose the lot size that minimizes cost per unit
- Least Total Cost: Choose the lot size where carrying costs most closely equal ordering costs
Step 4 — Time Phasing (Lead Time Offsetting):
The system offsets the planned order receipt by the lead time to determine when the planned order must be released. If a component has a 2-week lead time and is needed in Week 8, the planned order release occurs in Week 6.
Step 5 — BOM Explosion:
Planned order releases at one BOM level become gross requirements for the next lower level. This process continues level by level until all components and raw materials have been planned.
MRP Outputs:
MRP generates two types of outputs:
Primary Outputs:
- Planned Order Releases: Orders that MRP recommends releasing in future periods to meet net requirements
- Order Rescheduling Notices: Recommendations to expedite, de-expedite, or cancel existing open orders
- Cancellation Notices: Recommendations to cancel orders that are no longer needed
Secondary Outputs:
- Exception Reports: Highlight items requiring management attention (e.g., late orders, errors)
- Performance Reports: Measure system performance such as inventory turns, fill rates
- Planning Reports: Assist in future planning activities
Key MRP Concepts and Terminology:
- Gross Requirements: Total demand for an item before accounting for available inventory or scheduled receipts
- Scheduled Receipts: Open orders (purchase orders or production orders) that have already been released and are expected to arrive
- Projected Available Balance: The expected inventory at the end of each period after accounting for gross requirements, scheduled receipts, and planned orders
- Planned Order Receipts: Orders planned by MRP to arrive in a specific period
- Planned Order Releases: Orders planned by MRP to be released, offset by lead time from the planned receipt date
- Safety Stock: Extra inventory held as a buffer against uncertainty in demand or supply
- Lead Time: The total time from order release to order receipt, including processing, transit, and inspection time
- Low-Level Code: The lowest level in any BOM at which a particular component appears. MRP processes items level by level using low-level codes to ensure all gross requirements are captured before netting
- Pegging: The ability to trace a requirement back to its source (which parent item or customer order created the demand)
- Firm Planned Orders: Planned orders that have been frozen by the planner and will not be changed automatically by the MRP system during regeneration
MRP Regeneration vs. Net Change:
- Regenerative MRP: The entire MRP plan is recalculated from scratch, typically on a periodic basis (e.g., weekly). This approach is thorough but computationally intensive.
- Net Change MRP: Only items affected by changes since the last MRP run are recalculated. This is faster and can be run more frequently, even daily, but may accumulate errors over time.
Evolution: From MRP to MRP II to ERP
Understanding the evolution of MRP is important for the CSCP exam:
- MRP (1960s-1970s): Focused primarily on material planning and inventory control
- Closed-Loop MRP: Added capacity planning (CRP) and feedback loops from shop floor execution back to the planning system. This allowed planners to verify that plans were feasible.
- MRP II — Manufacturing Resource Planning (1980s): Expanded beyond materials to include all manufacturing resources — capacity, labor, tooling, and financial planning. MRP II integrates business planning, sales and operations planning (S&OP), master production scheduling, material requirements planning, capacity requirements planning, and shop floor execution.
- ERP — Enterprise Resource Planning (1990s-present): Extended MRP II across the entire enterprise, integrating finance, human resources, supply chain management, customer relationship management, and more into a single unified system.
Limitations and Challenges of MRP:
- Data Accuracy Dependency: MRP is only as good as its inputs. Inaccurate BOMs, inventory records, or lead times will produce unreliable plans. Inventory record accuracy of 95%+ and BOM accuracy of 98%+ are generally considered prerequisites.
- Assumes Infinite Capacity: Basic MRP does not consider capacity constraints. It assumes that all planned orders can be executed, which may not be realistic. Capacity Requirements Planning (CRP) is needed to validate MRP plans.
- Fixed Lead Times: MRP uses fixed, predetermined lead times, but actual lead times can vary based on shop load, supplier performance, and other factors.
- Nervousness: Small changes in the MPS or demand can cause significant changes in planned orders throughout the BOM structure, leading to excessive rescheduling (system nervousness). Techniques to reduce nervousness include time fences, firm planned orders, and lot sizing.
- Does Not Optimize: MRP calculates what is needed and when, but it does not optimize across competing objectives.
Prerequisites for Successful MRP Implementation:
- Accurate and up-to-date Bills of Materials (98%+ accuracy)
- Accurate inventory records (95%+ accuracy, often achieved through cycle counting)
- Realistic and stable Master Production Schedule
- Accurate lead time data
- Management commitment and trained personnel
- Reliable data processing infrastructure
Relationship Between MRP and Other Planning Systems:
MRP sits within a hierarchy of planning processes:
1. Strategic Business Plan → long-term direction
2. Sales and Operations Planning (S&OP) → balances demand and supply at an aggregate level
3. Master Production Scheduling (MPS) → specific product-level production plan
4. Material Requirements Planning (MRP) → detailed component and material plans
5. Capacity Requirements Planning (CRP) → validates that MRP plans are feasible given available capacity
6. Shop Floor Control / Production Activity Control (PAC) → executes the plan
7. Purchasing → executes procurement of bought-out items
Time Fences in MRP:
Time fences are used to stabilize the MRP plan and reduce nervousness:
- Demand Time Fence (DTF): Within this fence, only actual customer orders (not forecasts) drive the MPS. Changes require management approval.
- Planning Time Fence (PTF): Within this fence, the system will not automatically make changes. Changes to firm planned orders require planner intervention.
- Beyond the planning time fence, MRP can automatically create and change planned orders.
Exam Tips: Answering Questions on Material Requirements Planning
1. Master the MRP Grid/Table:
Practice working through MRP tables manually. You should be comfortable calculating gross requirements, netting, lot sizing, and lead time offsetting. Many exam questions test your ability to compute planned order releases or projected available balances.
2. Know the Three Inputs Cold:
If a question asks about MRP inputs, always remember: Master Production Schedule, Bill of Materials, and Inventory Records. These are the three pillars. Don't confuse MRP inputs with MRP II inputs (which include capacity and financial data).
3. Understand Dependent vs. Independent Demand:
MRP is specifically designed for dependent demand items. Questions may try to trick you by asking whether MRP is appropriate for finished goods (independent demand — use forecasting and MPS) versus components (dependent demand — use MRP).
4. Differentiate Between Planned and Firm Planned Orders:
Planned orders are automatically generated and can be changed by the system. Firm planned orders are locked by the planner and won't change during MRP regeneration. Know why planners use firm planned orders (to reduce nervousness, manage constraints, etc.).
5. Remember the Netting Formula:
Net Requirements = Gross Requirements - Scheduled Receipts - Projected Available Balance (from prior period)
If net requirements are positive, an order is needed. If negative or zero, no action is required.
6. Know Lot-Sizing Techniques:
Be able to identify the characteristics of each lot-sizing method. Lot-for-lot minimizes inventory but increases order frequency. EOQ balances ordering and holding costs. FOQ is simple but may create excess inventory. POQ covers a fixed number of periods.
7. Understand the Impact of Lead Time:
Always offset planned order receipts by the lead time to get planned order releases. If a question gives you a need date and a lead time, calculate backward to find the release date.
8. Watch for BOM Level Processing:
MRP processes the BOM level by level, starting at Level 0 and moving down. Planned order releases at one level become gross requirements at the next level. Understand the concept of low-level codes — if a component appears at multiple BOM levels, it is processed at its lowest level to capture all demand.
9. Be Clear on MRP vs. MRP II vs. ERP:
MRP = material planning. MRP II = manufacturing resource planning (includes capacity and financial). ERP = enterprise-wide integration. Questions often test whether you can distinguish these evolutionary stages.
10. Data Accuracy is Critical:
If a question asks about prerequisites for MRP success or reasons for MRP failure, data accuracy is almost always the answer. Remember the benchmarks: BOM accuracy ≥ 98%, inventory record accuracy ≥ 95%.
11. Capacity Awareness:
Basic MRP assumes infinite capacity. If a question asks about MRP's limitations, this is a key point. Closed-loop MRP and CRP address this limitation.
12. Pegging and Where-Used:
Pegging traces demand from a component back to its parent or end item. Where-used reports show all parent items that use a particular component. These are useful tools for planners when making rescheduling decisions.
13. Read Questions Carefully:
Exam questions on MRP can be tricky. Pay close attention to whether the question asks for planned order releases (when to place the order) versus planned order receipts (when the order arrives). Also note whether the question includes safety stock in the calculation.
14. Think About System Nervousness:
If a scenario describes frequent changes cascading through the plan, think about system nervousness and the tools to manage it: time fences, firm planned orders, dampening, and lot sizing.
15. Connect MRP to the Broader Supply Chain:
For CSCP-level questions, understand how MRP connects to supplier management (planned purchase orders go to suppliers), distribution planning (DRP feeds the MPS), and capacity planning (CRP validates MRP). MRP does not exist in isolation — it is part of an integrated planning hierarchy.
Summary
Material Requirements Planning is a fundamental tool for managing dependent demand in manufacturing environments. It takes input from the Master Production Schedule, Bill of Materials, and inventory records to calculate what materials are needed, how many, and when. By mastering the MRP logic — gross-to-net calculation, lot sizing, lead time offsetting, and BOM explosion — and understanding its role within the broader planning hierarchy, you will be well-prepared to answer MRP questions confidently on the CSCP exam. Always remember: MRP is data-driven, so data accuracy is paramount, and MRP's outputs are only as reliable as its inputs.
