MRP study plan
MRP · Give each week a clear focus.
8 weeks · About 7 hours per week
MRP Fundamentals and the Manufacturing Planning Hierarchy
Map the full manufacturing planning hierarchy from strategic business plan through sales and operations planning, master production scheduling, material requirements planning, and production activity control, and state the time horizon and decision owner at each level
Distinguish independent demand from dependent demand and explain why MRP applies only to the dependent-demand portion of the product structure
Define the core MRP inputs and outputs and explain how gross requirements, scheduled receipts, projected on-hand, and net requirements flow through the planning engine
Work through five closed-book calculations converting a gross requirement into a net requirement using on-hand inventory and scheduled receipts
Write a one-paragraph explanation of MRP II versus ERP scope that a non-planner could follow
Your checkpoint
A one-page hierarchy diagram plus a 20-term glossary written from memory, self-scored at 90% or better
Master Production Schedule and Demand Management
Construct a time-phased master production schedule for a make-to-stock item across a 12-period horizon, respecting the planning time fence and demand time fence
Classify products into make-to-stock, make-to-order, assemble-to-order, and engineer-to-order and explain how each changes MPS granularity and freezing rules
Aggregate and disaggregate demand between the S&OP family level and the end-item MPS level
Calculate available-to-promise for the first period and for a later period given a set of customer orders
Explain the consequences of nervous MPS behavior and describe two techniques that reduce schedule instability
Your checkpoint
A completed 12-period MPS grid with ATP rows and a 150-word memo justifying the frozen-zone length chosen
Bill of Materials Structure and Explosion
Build a multi-level bill of materials for a product with at least three levels and assign correct level codes and low-level codes to every component
Explode a BOM to derive gross requirements at levels 0, 1, and 2 by hand and reconcile the totals against a parent-by-parent calculation
Differentiate single-level, indented, summarized, modular, and planning BOMs and identify which structure suits phantom assemblies and configurable products
Explain the role of phantom items, effectivity dates, and reference designators in BOM accuracy
Diagnose five common BOM errors such as wrong quantity per, missing scrap factor, and circular structure
Your checkpoint
A hand-worked three-level explosion with all gross requirements shown per level and per period, checked against a summarized BOM
Inventory Records, Lead Times, and Item Master Data & Lot Sizing and Netting Logic
Define every item master field that affects MRP: planning policy code, lot sizing rule, lead time, safety stock, scrap percentage, and ABC class
Calculate net requirements and planned order receipts and releases using lot-for-lot, fixed order quantity, and fixed period requirements on the same data set
Compare the inventory investment and order frequency produced by each lot sizing method and explain when each is appropriate
Distinguish manufacturing, cumulative, and purchased lead times and describe how queue and move time enter the offsetting calculation
Compute safety stock implications and explain the difference between safety stock and safety lead time
Your checkpoint
A side-by-side lot sizing comparison table for one item under three methods with total cost and order count, plus a 100-word recommendation
Lot Sizing and Netting Logic & MRP Outputs, Action Messages, and Exception Management
Run a full multi-period MRP record for at least three items and three periods, producing gross requirements, scheduled receipts, projected on-hand, net requirements, planned receipts, and planned releases
Interpret each standard action message type, including release, reschedule in, reschedule out, cancel, and expedite, and state the correct planner response
Explain exception messages and how pegging and where-used inquiries support root-cause analysis of a shortage
Design a weekly exception review routine that prioritizes messages by dollar impact and days of coverage
Identify when firm planned orders should be used instead of automatically generated planned orders
Your checkpoint
A completed MRP record for three items covering five periods with all action messages annotated by the response a planner would take
Capacity Requirements Planning and Rough-Cut Capacity Planning
Distinguish rough-cut capacity planning from capacity requirements planning by inputs, time horizon, and level of detail
Calculate load, available capacity, and utilization for a work center across four periods and identify the overloaded period
Apply capacity smoothing options such as overtime, rerouting, splitting lots, and shifting the MPS, and state the trade-offs of each
Interpret a load profile and explain how a capacity bill and routing feed CRP
Explain the feedback loop from CRP back to the MPS and to the MRP plan
Your checkpoint
A four-period work center load table with utilization percentages and a written capacity resolution plan for the overloaded period
MRP Outputs, Action Messages, and Exception Management & ERP Integration, System Implementation, and Performance Metrics
Identify the performance metrics that measure MRP health, including schedule adherence, planning bill accuracy, inventory record accuracy, fill rate, and MRP nervousness
Explain how inventory record accuracy above 95% is a precondition for trustworthy MRP output and describe one cycle counting method that achieves it
Describe how MRP data flows between modules in an ERP system, from order entry through purchasing, production, and costing
Outline the phases of an MRP or ERP implementation and the data migration and cutover risks specific to item master and BOM records
Diagnose why an MRP system produces bad recommendations even when the software is working correctly
Your checkpoint
A one-page metrics dashboard definition with target values and the data source for each metric, plus a 150-word root-cause analysis of a failed MRP run
MRP Fundamentals and the Manufacturing Planning Hierarchy & Master Production Schedule and Demand Management & Bill of Materials Structure and Explosion & Inventory Records, Lead Times, and Item Master Data & Lot Sizing and Netting Logic & Capacity Requirements Planning and Rough-Cut Capacity Planning & MRP Outputs, Action Messages, and Exception Management & ERP Integration, System Implementation, and Performance Metrics
Complete two full-length timed practice exams under exam conditions and score them by domain
Rework every missed question to the underlying concept and record the rule that was misapplied
Re-derive the ten most error-prone calculations from memory without notes, including ATP, netting, lot sizing, and load utilization
State the definition and one worked example for each of the 30 highest-frequency terms across all domains
Build a final one-page formula and definition sheet for last-day review
Your checkpoint
Two scored practice exams with a domain-level error log and a one-page formula sheet, with every domain scoring 75% or better
Milestones
Week 2: Can build a time-phased MPS with ATP from a blank grid in under 20 minutes and explain every freezing decision made
Week 4: Can explode a three-level BOM and carry the result through netting and three lot sizing methods without reference material
Week 6: Can convert an MPS into a work center load profile, compute utilization, and propose a defensible resolution for an overload
Week 8: Practice exam scores of 75% or higher in every domain, with a completed error log showing no repeated mistake type