MRP Report (Material Requirement Planning)
MRP Report (Material Requirement Planning) - User Guide
1. Introduction 🧠
The MRP (Material Requirement Planning) Report is the central planning engine of the manufacturing system. Its primary role is to answer three critical operational questions:
- What finished goods and raw materials must be produced or procured?
- How much quantity is required after factoring in current stock, pending orders, and open purchase indents?
- Are we ready to start production immediately without mid-run component shortages?
By synthesizing sales demand, production schedules, Bill of Materials explosions, and live inventory balances, the MRP engine ensures smooth shop floor execution while preventing unnecessary capital tie-up in excess stock.
ℹ️
Core Objectives:
- Uninterrupted Manufacturing: Ensure 100% component availability prior to committing batches to production lines.
- Precise Procurement: Calculate exact net purchase requirements by offsetting existing stock, quality inspection stock, and open indents.
- Demand Fulfillment: Align planned production output directly against open customer sales order commitments.
Typically, this report is used by PPC Heads, Materials Managers, Production Planners, and Procurement Teams.
2. Accessing the Report 🚀
Navigate to Manufacturing > Reports > MRP Report.
3. Planning Modules & Options ✨
The MRP generation interface supports three distinct planning modalities:
A. Production Plan (“What to Make”)
- Analyzes planned production targets for Finished Goods (FG) and Semi-Finished Assemblies (SA) across a designated Plan No range.
- Calculates Gross Requirements and allows offsetting against Current Finished Goods Stock and adding Pending Customer Sales Orders.
B. Procurement Plan (“What to Buy”)
- Performs recursive Bill of Materials explosion for all planned items down to the lowest raw material components.
- Calculates Net Purchase Requirement: $$\text{Make Indent Qty} = (\text{BOM Requirement} + \text{Safety Stock}) - (\text{Available Stock} + \text{Pending Indents})$$
- Considers open indents and QA inspection stage stock.
C. Full Kit Plan (“Shop Floor Readiness”)
- Single-Plan Diagnostic: When Full Kit Plan is selected, the report evaluates readiness for a single specific plan (only Start Plan No is chosen; End Plan No is hidden).
- Strict Availability Audit: Stock adjustment toggles (Deduct FG Stock, Deduct RM Stock, Add Pending Orders) are automatically disabled. The Full Kit analysis strictly audits physical stock availability against the exact recipe needed for that target plan, providing a clear “Go / No-Go” indicator.
- Inventory Unit Standard: All quantities are evaluated strictly in inventory stock units (“Unit will be considered for Inventory only”).
4. Configuration Toggles & Controls 🛠️
- Add Pending Order Qty: Incorporates unfulfilled customer sales orders (from the last 2 years) into gross production requirements.
- Deduct FG Stock: Offsets current available finished goods warehouse stock against production targets.
- Deduct RM Stock: Offsets current raw material inventory against calculated procurement needs.
- Scan BOM of Sub-Assemblies: Recursively traverses nested sub-assembly BOMs to ensure intermediate components manufactured in-house are included in planning.
5. Generated Report Output (MRP_Report.xlsx) 📊
The system exports a comprehensive multi-tab Excel workbook titled MRP_Report.xlsx:
| Workbook Sheet | Analysis & Strategic Function |
|---|---|
| Production Plan | Summary of planned products, plan dates, target quantities, and current warehouse stock. |
| Product Wise Consumption | Explodes each planned product into its constituent raw materials, showing stages and unit consumption factors. |
| Procurement Plan | Identifies component deficits by comparing total demand against free stock, QA stock, and open indents, recommending exact Make Indent Quantities. |
| Full Kit Plan | A line-by-line shop floor readiness audit displaying required vs available quantities for the selected plan. |
| Item Wise Consumption Summary | Aggregates identical raw materials across all planned products into a consolidated procurement schedule. |
| Unit Wise Consumption Summary | Summarizes material requirements grouped by operating manufacturing unit. |
6. Best Practices / Tips 💡
- Strict Full Kit Discipline: Always generate the Full Kit Plan for a specific plan before issuing work orders. Commencing production without 100% component availability leads to line stoppage and high work-in-progress (WIP) holding costs.
- Clean Open Sales Orders: Periodically review and close obsolete sales orders in the commercial module to avoid inflated procurement suggestions.
- Lead Time Awareness: Combine the Procurement Plan with supplier lead-time buffers to place purchase indents sufficiently in advance of target production dates.