Business Case Solutions - 10 - MRP Filtering


Business Case Solutions
  1. Run MRP by Assembly - Many systems will allow users to run MRP at the specific assembly level.  This allows buyers to refresh MRP after the order is entered into the system and again periodically throughout the purchasing process.  Refreshing MRP at the assembly level will allow buyers to monitor the status of each part and ensure that parts are ordered and scheduled as needed.  However, if MRP is refreshed for only the assembly, then they buyer may not know of other demand for the same parts and would therefore need to place an additional order for the same part once they begin work on that project.

  2. Excel File - Using a separate excel spreadsheet to track the parts is a common method for micro-managing the process for each assembly.  This gives buyers visibility of each part and allows them to respond more proactively to changes or issues.  However, this system will work only if the buyer keeps the spreadsheet up to date.  This means double data-entry and increases the likelihood of human error.  Additionally, if the buyer has too many parts to order and not enough time, they are likely to postpone updating the separate spreadsheet, which completely eliminates the benefit and effectiveness of this option.

  3. Custom and Standard Reports - Depending on system capabilities and specific needs, standard and custom reports may give buyers the information they need to ensure all parts are ordered on-time and according to quoted pricing.  If a project warrants extra monitoring, this can be an excellent method for control inventory flow.