Optimizing Inventory around Suppliers´ Minimum Order Quantities

Recently, I had an interesting conversation with an inventory manager and the VP Finance. We were discussing the benefits of being able to automatically optimize both reorder points and order quantities. The VP Finance was concerned that given their large supplier required minimum order quantities, they would not be able to benefit.  He said his suppliers held all the power, forcing him to accept massive minimum order quantities and tying his hands. While he felt bad about this, he saw a silver lining: He didn’t have to do any planning. He would accept a large inventory investment, but his customer service levels would be exceptional.  Perhaps the large inventory investment was assumed to be the cost of doing business.

I pushed back and pointed out that he was not as powerless as he felt. He still had control of the other half of the procurement process: while he couldn’t control how much to order, he could control when to order by adjusting the reorder point. In other words, there is always room for careful quantitative analysis in inventory management, even when you have one hand tied behind your back.

An Example

To put some numbers behind my argument, I created a scenario then analyzed it using our methodology to show how consequential it can be to use inventory optimization software even in constrained situations. In this scenario, item demand averages 2.2 units per day but varies significantly by day of week. Let’s say the imaginary supplier insists on a minimum order quantity of 500 units (way out of proportion to demand) and fills replenishment orders in either three days or ten days in equal proportions (quite inconsistent). To spread the blame around, let’s also suppose that the imaginary supplier’s imaginary customer uses a foolish rule that the reorder point should be 10% of the minimum order quantity. (Why this rule? Too many companies use simple/simplistic rules of thumb in lieu of proper analysis.)

So, we have a base case in which the order quantity is 500 units, and the reorder point is 50 units. In this case, the fill rate is 100%, but the average number of units on hand is a whopping 330. If the customer would simply lower the reorder point from 50 to 15, the fill rate would still be 99.5%, but the average stock on hand would drop by 11% to 295 units. Using the one hand not tied behind his back, the inventory manager could cut his inventory investment by more than 10%, which would be a noticeable win.

Incidentally, if the minimum order quantity were abolished, the customer would be free to arrive at a new and much better solution. Setting the order quantity to 45 and the reorder point to 25 would achieve a 99% fill rate at the cost of a daily on-hand level of only 35 units: nearly a 90% reduction in inventory investment: a major improvement over the status quo.

Postscript

These calculations are possible using our software, which can make visible the otherwise unknown relationships between inventory system design choices (e.g., order quantity and reorder point) and key performance indicators (e.g., average units on hand and fill rate).  Armed with this ability to conduct these calculations, alternative arrangements with the supplier may now be considered. For example, what if, in exchange for paying a higher price per unit, the supplier agreed to a lower MOQ. Using the software to conduct an analysis of the key performance indicators using the “what if” costs and MOQs would reveal the cost per unit and MOQ that would be needed to develop a more profitable deal.   Once identified, all parties stand to benefit.  The supplier now generates a better margin on sales of its products, and the buyer holds considerably less inventory yielding a holding cost reduction that dwarfs the added cost per unit.  Everyone wins.

 

 

Infrequent Updates to Inventory Planning Parameters Costs Time, Money, and Hurts Service

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Inventory planning parameters, such as safety stock levels, reorder points, Min/Max settings, lead times, order quantities, and DDMRP buffers directly impact inventory spending and ability to meet customer demand. Based on these parameter settings, your ERP system makes daily purchase order suggestions.

Ensuring that these inputs are understood and optimized regularly will substantially reduce wasteful inventory spending and dramatically improve customer service levels.

Given the importance of getting these planning parameters right, we spend a lot of time during our consultations asking (1) how these parameter values are calculated and (2) how often they are updated. Most often the methods for calculating the parameter values are rule of thumb. You can read about why using rule of thumb approaches is so problematic here  – Beware of Simple Rules of Thumb for Managing Inventory.

This blog will focus on the frequency of updates. When we interview companies and ask them how often they update planning parameters, the answer we nearly always hear is “every day!” A follow up question or two most often reveals that this just isn’t true. What “every day” actually means in practice is this: Every day, the ERP system suggests dozens to hundreds of purchase orders and/or production jobs. The planner, let’s call him Peter, reviews these orders daily and decides whether to release, modify, or cancel them. If the order suggestion doesn’t “feel right”, Peter reviews the planning inputs and modifies the order if necessary. For example, Peter may feel there is already enough inventory on hand. To “fix” the issue, he will reduce the reorder point and cancel the order. Or if he feels that the order should have been placed weeks ago, Peter may expedite the order and increase the reorder point and order quantity to ensure there will be plenty of stock the next time.

The principal flaws with this approach are that it is reactive and incomplete. Here is why:

Reactive

It only assesses the handful of items marked for replenishment on any given day but not others. The trigger for reviewing an item is when the ERP suggests an order, and that will only happen when the reorder point or Min is breached. If the Min is too high and breaches earlier than it should have, an unneeded order will be placed unless caught by the planner. If the Min is too low, well, it is too late to fix the error. No matter how large the order suggestion is, you still have to wait to be resupplied and since the order was suggested late, a stockout during the replenishment period is highly probable. Where is the “planning” in such a process? As one customer put it, “Our former process was, in hindsight, spent managing the outputs and not the inputs.”

 

Incomplete

Graphics for inventory gets excess and shortage for all locations of a bill of distributionWhat about the thousands of other items that have a Min/Max, safety Stock, Reorder Point, or other parameters that isn’t being reassessed given the updated demand and supply data. The planner isn’t reviewing any of these items which means problems aren’t being identified in advance. Compounding the problem is that when Peter does make a change he doesn’t have any tools to assess the quality of his changes. If he modifies the min/max settings he doesn’t know the specific impact this will have on inventory value, ordering costs, holding costs, stock outs, and service levels. He only knows that an increase in inventory will likely improve service and increase costs. He doesn’t know for example whether his inventory has reached a point of diminishing returns. When inventory decisions are made with only a very rough understanding of the trade offs it creates more problems downstream. You wouldn’t want your carpenter making rough estimates of their measurements yet it’s commonplace for inventory planning professionals to do so with millions of dollars in inventory spend at stake.

How Often Do Most Companies Update Parameters?

So how often do most companies make system-wide updates to their planning parameters such as reorder points, safety stocks, Min/Max settings, lead times, and order quantities? Typically, mass updates occur quarterly, annually, and in some cases never – the only times changes are made are when an order is triggered by ERP. Not exactly agile.

The biggest reason given for not intervening more often is that it takes too much time. Most companies set these key parameters using very unwieldy Excel programs or ERP applications that simply aren’t designed to conduct systemic inventory planning. This is where inventory optimization software can help.

Using inventory optimization software and probability forecasting to update key planning parameters frequently, say every week or month instead of quarterly or annually, enables you quickly respond to changes in your business. You can seize on cost saving opportunities, as when demand turns down and you can reduce reorder points and/or order quantities and possibly cancel outstanding orders. Or you can respond to problems, as when demand increases threaten your service level commitments to customers, or supplier lead times increase and require re-computation of reorder points.

How to do it Right

The key is establishing an agreed upon set of performance and inventory value metrics and letting the software monitor the state of play in the background and alert you to exceptional situations. This is simply one more way of saying that, once systems have been established, you want to go forward using management by exception. You can set ranges within which things can bubble along as they normally do, but once a critical parameter like “stock out risk exceeds a pre-defined level” or “inventory value or costs exceeds a pre-defined level,” the software can provide a daily alert and can also recommend a response, such as raising a reorder point. With this level of automated assistance, it becomes possible to keep your finger on the pulse of the inventory without being overwhelmed by the sheer volume of data.

For example, you may choose an initial set of inventory parameters as the policy because you could see from the software that it meets your service level goals within your inventory budget. You may let the system prescribe service level targets for you and be comfortable with the settings because inventory value is within the budget. However, if demand gets less predictable than historically, you won’t be able to achieve the same level of service without an increase in inventory. An exception report will identify this and enable you to make an informed decision on what to do. You can decide to modify the policy or keep it the same. If you keep it the same, you now know the additional risks and change in inventory costs. This can be communicated to all stake holders so that there aren’t any surprises.

Plan Don’t React

Rather than being constantly in reactive mode, you can handle what really needs to be handled and still have some time to do forward thinking. For instance, you can do “what if” analyses on such issues as which supplier lead times would yield the biggest payoff if reduced, or whether service level targets should be adjusted to account for shifts in customer criticality, or similar policy issues. After all, it’s not as if you are not going to end up with a full daily agenda, it’s just a question of whether you can elevate that agenda to a more strategic level. So if you are spending all of your “planning” time managing the outputs of your ERP instead of constructively reviewing and optimizing the inputs, it is time to reassess your inventory planning process.

 

 

Leave a Comment

Related Posts

Goldilocks Inventory Levels

Goldilocks Inventory Levels

You may remember the story of Goldilocks from your long-ago youth. Sometimes the porridge was too hot, sometimes it was too cold, but just once it was just right. Now that we are adults, we can translate that fairy tale into a professional principle for inventory planning: There can be too little or too much inventory, and there is some Goldilocks level that is “just right.” This blog is about finding that sweet spot.

Call an Audible to Proactively Counter Supply Chain Noise

Call an Audible to Proactively Counter Supply Chain Noise

You know the situation: You work out the best way to manage each inventory item by computing the proper reorder points and replenishment targets, then average demand increases or decreases, or demand volatility changes, or suppliers’ lead times change, or your own costs change.

An Example of Simulation-Based Multiechelon Inventory Optimization

An Example of Simulation-Based Multiechelon Inventory Optimization

Managing the inventory across multiple facilities arrayed in multiple echelons can be a huge challenge for any company. The complexity arises from the interactions among the echelons, with demands at the lower levels bubbling up and any shortages at the higher levels cascading down.

Recent Posts

  • Smart Software CEO to present at Epicor Insights 2022Smart Software to Present at Epicor Insights 2022
    Smart Software CEO will present at this year's Epicor Insights event in Nashville. If you plan to attend this year, please join us at booth #9 and #705, and learn more about Epicor Smart Inventory Planning and Optimization. […]
  • Smart Software and Arizona Public Service to Present at WERC 2022
    Smart Software CEO and APS Inventory Manager to present WERC 2022 Studio Session on implementing Smart IP&O in 90 Days and achieve significant savings by optimizing reorder points and order quantities for over 250,000 spare parts. […]