skip to Main Content

MRP & Inventory Management

Inventory Optimization & Management  
05/25/2018

Most companies use Material Requirement Planning (MRP) software, or an MRP module of an ERP, to plan and manage the purchase, production, and transfer orders of finished goods and components based on a demand plan or forecast. It is time-phased and can manage large numbers of materials—and bill of materials—to ensure the right components are ordered and on hand to support production-scheduling software.

Yet, MRP systems cannot do everything. Materials Managers have to ensure that data is accurate, and supply attributes are set optimally, which can be non-trivial and can make or break the effectiveness of an MRP:

  • The Bill of Materials has to be up to date. These are not static documents. Specifications change resulting in changes of suppliers, this information must be accurate.
  • The lead times for all component and supplier locations must be up to date including the transit times. Shipping times and suppliers are changing, and sometimes location change as well.
  • Forecasts and/or demand plans must be constantly updated, and every effort should be taken to make them as accurate as possible. This is critical in MTS environments and MTO scenarios because you need to ensure components and capacities are available to meet those future requirements.

 

All of the above data is crucial in their own right, but they also contribute to the calculations of re-order points and buffer inventories for all finished goods and materials. MRP systems generally do not calculate or evaluate re-order points and inventory buffers. In the rare occasions that they do, they might not be using the calculations best suited for your particular business.

How often should you recalculate the inventory parameters?

This depends on the growth or decay of the business in general. It also depends on the volatility of the business environments. According to ISM in the "The Next Challenge for Global Growth: Keeping Up With Demand" article published in the April 24th edition of the Wall Street Journal:

Economic data are also showing a constrained supply side. The Institute for Supply Management’s index measuring backlogs of orders in manufacturing has reached its highest level since May 2004. Set against robust demand, supply chains are “struggling to keep up,” the ISM says.

Regardless, if the issue is demand or supply related, MRP systems are not suited for analyzing and resetting demand and supply attributes on a continuous basis. Most companies do these calculations and evaluations themselves in home-grown software or spreadsheets. Others use third-party software specifically designed to size and calculate the inventory parameters on a rolling basis, while populating the MRP with re-orders points and buffers over the next 6-12 months.

MRP's Bottom Line

The bottom line is that MRP systems are very good and may be the central engine for managing inventory and ensuring customer service. However, MRP systems require good data and the setting of optimal parameters to run effectively. This includes the periodic recalculation of re-order points and buffers often best done by specialty software such as DemandCaster.

It is interesting to also note, when we first built DemandCaster it was done so with the inclusion of a robust MRP engine in order to properly visualize the impact of demand and supply on both a short- and long-term basis. By better visualizing your reality, we help you move from reactive responses to more proactive decisions.

Today, many of our customers prefer to use DemandCaster in place of their ERP systems since it moves all the MRP-related parameters out of your ERP's black box, making it easier to modify settings and view the impact before taking action. These orders can then be pushed back to your ERP for execution.

Related Articles

Calculating Safety Stock: Simpler Might Not be Better

What is safety stock? Safety stock is the extra stock you maintain to mitigate the risk of running out of raw materials or finished goods due to uncertainties in supply or demand. The purpose of safety stock is to ensure [...]

Nine Factors That Influence Inventory Planning and Optimization

Inventory planning is hard to do. As supply chain complexity continues to expand, it’s getting more and more difficult to reach and sustain optimal inventory levels. Regardless of the level of difficulty, however, inventory must be managed, and the rewards [...]

Make the Transition to Inventory Forecasting Software

Maintaining the right amount of inventory is key to keeping up with the ebb and flow of customer orders. But what level is the “right” level? If a company doesn’t have enough product on hand, it may miss too many [...]

The Importance of Effectively Managing Raw Materials Inventory

In today’s world, the system of vendors, activity, and data required to source, produce, and deliver products to customers is increasingly complex. And the supply chain represents the steps required to make this happen. But as product companies extend their [...]

Improving warehouse inventory management

Warehouse inventory management is one thing that can have a big impact on productivity. All Things Supply Chain put together a list of 9 ways you can better manage your inventory. First things first, plan your space. As they said, [...]

The Future of Inventory Management: Five Predictions

For many companies, inventory management is where all the elements of the supply chain converge. Inventory may be seen as the bloodstream of any competitive business. Its unobstructed flow is critical to the well being of any organization that trades [...]

Is Poor Inventory Management Creating Chaos in Your House?

Planning for changes in demand for product is a situation everyone deals with. It’s not just a corporate issue either! At work, at home, in almost every space, there is a need for products, and those needs (demand) change due [...]

Excess & Obsolete Inventory Management

Inventory is an ongoing challenge for companies -- especially inventory that's considered outdated and over-stocked. The issue is caused by a series of unfortunate events, including lack of communication, not applying the true cost of inventory, poor end-of-life planning, lack [...]

What CFOs Don’t Know About the Cost of Inventory

Whether based in retail, distribution or manufacturing, supply chain processes are the backbone of the company. If you can’t provision orders, your bottom line will suffer. Perhaps this seems like an obvious statement but many an organization has brought process [...]

Critical Facts CFOs Need to Know Before Reducing Inventory

In an effort to free up cash, many financial managers are all too eager to reduce inventory. However, taking steps to reduce inventory without being fully aware of the context can lead to disastrous outcomes.   CFOs need to be [...]
Subscribe to our Blog
Back To Top