Mastering BOM and MRP: Core Calculations for Efficient Material Management

What is a BOM?

A Bill of Materials (BOM) is a "recipe" for manufacturing a product, listing every component, raw material, and sub‑assembly required, along with the quantities and the order in which they are needed.

1. Hierarchical Structure

BOMs are not flat lists; they are organized in a top‑down hierarchy. The top level is the finished product (e.g., a smartphone), the middle levels are semi‑finished assemblies (e.g., the motherboard), and the lowest level contains basic parts such as resistors and capacitors.

2. Quantity Calculation

The basic formula is: Child Quantity = Parent Quantity × Quantity per Parent For example, producing 1,000 phones that each require one battery results in a demand for 1,000 batteries.

3. Dynamic Adjustments

When a design change occurs—such as increasing a table leg from four to six—the impact ripples through the entire BOM: screw counts, packaging dimensions, and assembly labor may all need to be recalculated. A robust BOM must automatically propagate these changes.

What is MRP?

Material Requirements Planning (MRP) ensures that the right materials are available at the right time for production. It uses the BOM, inventory data, and customer orders to answer three questions: what to buy, how much to buy, and when to buy.

1. Core Elements

Main Production Schedule (MPS): Planned quantity and timing of the finished product.

Bill of Materials (BOM): Breakdown of the product into components and required quantities.

Inventory Data: Current stock of raw materials, work‑in‑process, and finished goods.

Lead Time (Purchase Cycle): Time required for a supplier to deliver ordered items.

Safety Stock: Buffer inventory to mitigate demand or supply variability.

2. Calculation Steps

Gross Requirement: For each item, calculate Gross = Parent Requirement × Quantity per Parent using the BOM and MPS.

Net Requirement: Net = Gross – On‑hand Inventory – On‑order Quantity.

Plan Generation: Based on net requirements, lead times, and production lead times, schedule purchase orders and production orders. Order Date = Requirement Date – Lead Time.

Monitoring & Adjustment: Track order execution and production progress, adjusting the plan as needed.

Example: To produce 100 phones with a battery inventory of 50 and a 7‑day lead time, the gross battery requirement is 100, net requirement is 50, and the order should be placed 7 days before the production date.

Efficient Material Management with ERP

Integrating BOM and MRP within an ERP system enables real‑time synchronization of material data, automating the analysis and generation of purchase and production orders.

1. Tools and Automation

BOM Import & Management: Upload BOMs via Excel; the system automatically expands the hierarchy and creates material records.

Accurate Material Demand Analysis: After confirming a production plan, a single click generates a detailed material requirement list, showing total demand, current stock, gaps, and suggested replenishment methods (in‑house, purchase, or outsourcing).

Streamlined Work‑order Flow: The generated list allows planners to dispatch purchase, production, and outsourcing orders instantly, while procurement staff can view all material needs on a dashboard for efficient ordering.

By leveraging these ERP capabilities, manufacturers can reduce excess inventory, avoid production stoppages caused by material shortages, and achieve more accurate, demand‑driven production planning.