Materials Resource Planning (MRP)
  1. EBMS Knowledge Base
  2. Manufacturing
  3. Materials Resource Planning (MRP)

MRP Overview

Materials Resource Planning (MRP) is an important process in planning the manufacturing process, plan for the raw materials, parts, or sub-assemblies required to manufacture finished goods such as equipment, mixes, and other kits or assemblies.  

The EBMS software contains many tools to respond to low inventory stock levels or to special order products that need to be manufactured. These tools are used to purchase raw materials, parts, or other product required to manufacture an item or create a mix.   Multiple level batches are created, evaluated, and managed using a Low Inventory Process.  

Millcreek Manufacturing Testimonial

The following set of processes can be used to create multiple level manufacturing batches.  Review the following sections for steps to launch the MRP process from these dialogs.   

  1. Use the Low Inventory Process to manage MRP when the low inventory dialog appears within a sales order or manufacturing batch. 

  2. Use the Inventory Stock level Process to manage MRP based on the inventory stock level parameters.   

  3. The MTO Manufacturing Process allows the user to manage MRP for a specific MTO sales order. 

  4. Use the Special Order Process to create MRP manufacturing batches based on a finished goods item within a sales order. 

Prerequisites

The following steps are important prerequisites before continuing with the MRP step:

  1. Create inventory items within the EBMS product catalog for the finished goods as well as the sub-assemblies or raw material.

    1. The Classification should be Track Count, Serialized, or Lot to manage the counts of each level.

    2. Set the Purchase Method to Associated within each item. 

      Review Product Catalog > Entering New Products for more details on creating product records.

  2. Create a bill-of-materials (BOM), mix, or component list for the finished item. Some finished goods may require a multi-level BOM.  Note that optional components can be configured within a component list. Review Components and Accessories Overview for more details on creating these materials lists.

  3. Enable the Sync MFG/Consumed option.  Review Sync Finished Goods Quantities with Items Consumed for information on this option.  

Low Inventory Process

Open a sales order and select View > Low Inventory to launch the MRP process.

Review Low Inventory Processing for process details to manage MRP for special orders and other low inventory prompts.  

Inventory Stock Level Process 

This method uses the Inventory Purchasing Page to prompt the user to create manufacturing batches to replenish the finished goods stock levels.   Review the following documentation to use this method:

  1. Enter inventory stock level settings for finished goods products:  Review Purchasing > Stock Level Settings to review multiple stock level setting options.

  2. Configure the generic manufacturing vendor:  Review Manufacturing Vendor to setup this required generic vendor settings.  

  3. View and process low inventory based on stock level settings using the Inventory Purchasing Page.  This process can be used to purchase or manufacture product. 

  4. Click Create > Order or Create > Manufacturing Batch to create the manufacturing batches. 

    Review Inventory Purchasing Page for steps to configure and use this dialog to create manufacturing batch for stock product that are manufactured as well as purchased. 

  5. The purchasing page will create manufacturing batches which may prompt a low inventory process.  Review Low Inventory Processing for the steps available to create multiple level manufacturing batches as well as purchase orders for raw materials and parts. 

MTO Manufacturing Process

Complete the following steps to launch the MTO Manufacturing process:

  1.  Enter a MTO item within a sales order:  Review Made-to-Order Kitting > Inserting a MTO Item into a Sales Order for steps to create a MTO manufacturing batch within a sales order.

  2. Select Manufacture Item from the MTO dialog.

  3. The Low Inventory List will appear.  Review Low Inventory Process for the steps to create sub-batches or purchase orders as a result of low stock inventory. 

Managing a multiple step Materials Resource Plan (MRP)

Creating a customized Sankey diagram form using a buisiness intelegence tool such as Microsoft Power BI is a valuable tool to map the enter manufacturing from purchases or stock to the sales order.  SQL Mirror fis required to properly generate an effective Sankey diagram.   Review Sankey Diagram for diagram samples, setup requirements, and the management options available for this MRP mapping solution.