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.

 

 

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. Now your old policies (reorder points, safety stocks, Min/Max levels, etc.)  have been obsoleted – just when you think you’d got them right.   Leveraging advanced planning and inventory optimization software gives you the ability to proactively address ever-changing outside influences on your inventory and demand.  To do so, you’ll need to regularly recalibrate stocking parameters based on ever-changing demand and lead times.

Recently, some potential customers have expressed concern that by regularly modifying inventory control parameters they are introducing “noise” and adding complication to their operations. A visitor to our booth at last week’s Microsoft Dynamics User Group Conference commented:

“We don’t want to jerk around the operations by changing the policies too often and introducing noise into the system. That noise makes the system nervous and causes confusion among the buying team.”

This view is grounded in yesterday’s paradigms.  While you should generally not change an immediate production run, ignoring near-term changes to the policies that drive future production planning and order replenishment will wreak havoc on your operations.   Like it or not, the noise is already there in the form of extreme demand and supply chain variability.  Fixing replenishment parameters, updating them infrequently, or only reviewing at the time of order means that your Supply Chain Operations will only be able to react to problems rather than proactively identify them and take corrective action.

Modifying the policies with near-term recalibrations is adapting to a fluid situation rather than being captive to it.  We can look to this past weekend’s NFL games for a simple analogy. Imagine the quarterback of your favorite team consistently refusing to call an audible (change the play just before the ball is snapped) after seeing the defensive formation.  This would result in lots of missed opportunities, inefficiency, and stalled drives that could cost the team a victory.  What would you want your quarterback to do?

Demand, lead times, costs, and business priorities often change, and as these last 18 months have proved they often change considerably.  As a Supply Chain leader, you have a choice:  keep parameters fixed resulting in lots of knee-jerk expedites and order cancellations, or proactively modify inventory control parameters.  Calling the audible by recalibrating your policies as demand and supply signals change is the right move.

Here is an example. Suppose you are managing a critical item by controlling its reorder point (ROP) at 25 units and its order quantity (OQ) at 48. You may feel like a rock of stability by holding on to those two numbers, but by doing so you may be letting other numbers fluctuate dramatically.  Specifically, your future service levels, fill rates, and operating costs could all be resetting out of sight while you fixate on holding onto yesterday’s ROP and OQ.  When the policy was originally determined, demand was stable and lead times were predictable, yielding service levels of 99% on an important item.   But now demand is increasing and lead times are longer.  Are you really going to expect the same outcome (99% service level) using the same sets of inputs now that demand and lead times are so different?  Of course not.  Suppose you knew that given the recent changes in demand and lead time, in order to achieve the same service level target of 99%, you had to increase the ROP to 35 units.  If you were to keep the ROP at 25 units your service level would fall to 92%.  Is it better to know this in advance or to be forced to react when you are facing stockouts?

What inventory optimization and planning software does is make visible the connections between performance metrics like service rate and control parameters like ROP and ROQ. The invisible becomes visible, allowing you to make reasoned adjustments that keep your metrics where you need them to be by adjusting the control levers available for your use.  Using probabilistic forecasting methods will enable you to generate Key Performance Predictions (KPPs) of performance and costs while identifying near-term corrective actions such as targeted stock movements that help avoid problems and take advantage of opportunities. Not doing so puts your supply chain planning in a straightjacket, much like the quarterback who refuses to audible.

Admittedly, a constantly-changing business environment requires constant vigilance and occasional reaction. But the right inventory optimization and demand forecasting software can recompute your control parameters at scale with a few mouse clicks and clue your ERP system how to keep everything on course despite the constant turbulence.  The noise is already in your system in the form of demand and supply variability.  Will you proactively audible or stick to an older plan and cross your fingers that things will work out fine?

 

 

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.

Electric Power Utility Selects Smart Software for Inventory Optimization

Smart IP&O goes live in 90 days and reduces inventory by $9 million in the first six months

Belmont, MA., 2021Smart Software, Inc. provider of industry-leading demand forecasting, planning, and inventory optimization solutions, today announced its selection, purchase, and implementation of its flagship product, Smart IP&O, by a major US electric utility.  The platform is now utilized to plan over 250,000 spare parts valued at over $500,000,000 across the Utility’s multi-echelon distribution network.  Smart IP&O was implemented in just 90 days and has been credited for reducing inventory by $9 million while maintaining service levels within its first six months of operation.

The implementation of Smart IP&O is part of the Utility’s Strategic Supply Chain Optimization (SCO) initiative to replace twenty-year-old legacy software. Subsequent phases of the Smart Software implementation will integrate Smart IP&O to their IBM Maximo Asset Management system.

Key to the selection and success of the project to-date is Smart Software’s proven track record planning intermittent demand that is prevalent on spare and service parts.  Intermittent or lumpy demand is characterized by frequent periods of zero demand interspersed with large spikes of non-zero demand that seemingly occur at random.  The Utility estimates that over 80% of its parts have intermittent demand.  Smart Software leverages probabilistic forecasting that creates thousands of possible future outcomes of demand and lead times. The technology’s proven ability to accurately forecast the required inventory to achieve the high levels of service the Utility requires and to do so at scale were critical differentiators.

Implementation was accomplished within 90 days of project start.  Over the ensuing six months, Smart IP&O enabled the adjustment of stocking parameters for several thousand items, resulting in inventory reductions of $9.0 million while sustaining target service levels.  Significant additional savings – and improvement in service levels for critical spares – are anticipated in the coming year as stocks for additional facilities are brought into the system.

“We have had many very strong successes helping customers in asset-intensive industries optimize their parts inventory,” said Greg Hartunian, CEO of Smart Software.  “Combined with the Utility’s support from the top-down, hands-on involvement from IT, and user enthusiasm to embrace a new approach, we had a great recipe for success.  We look forward to building on our early success to deliver even more value together.”

About Smart Software, Inc.
Founded in 1981, Smart Software, Inc. is a leader in providing businesses with enterprise-wide demand forecasting, planning, and inventory optimization solutions.  Smart Inventory Planning & Optimization is a multi-tenant web platform that gives demand planners the tools to handle sales seasonality, promotions, new and aging products, multi-dimensional hierarchies, and intermittently demanded service parts and capital goods items.  The solution provides inventory managers with accurate estimates of the optimal inventory and safety stock required to meet future orders and achieve desired service levels.  Smart Software is headquartered in Belmont, Massachusetts, and can be found at www.smartcorp.com.

 

SmartForecasts and Smart IP&O are registered trademarks of Smart Software, Inc.  All other trademarks are the property of their respective owners.


For more information, please contact Smart Software,Inc., Four Hill Road, Belmont, MA 02478.
Phone: 1-800-SMART-99 (800-762-7899); E-mail: info@smartcorp.com

 

Smart Software Completes SOC 2 Type II Audit. Secure cloud platform

Smart Software Completes SOC 2 Type II Security Audit

Belmont, Mass., June 1, 2020 – Smart Software, Inc. announced  today that the company completed its Service Organization Control for Service Organizations (SOC) Audit, delivering the highest level of data security and reliability.

“All of Smart Software’s services depend on a foundation of safe, secure, and private storage and transfer of information” said Chief Technology Officer, Sreekumar Menon.  “Trust and data security are table stakes now for any solution offering cloud based analytics, forecasting, demand modeling, and inventory planning. Since day 1 of our cloud journey, we’ve made considerable investments in order to ensure a secure and reliable environment for our customers.  The completion of this audit validates these efforts.”

Companies completing the SOC 2 Type II audit have the option to be judged on one or more categories; Smart Software met or exceeded the industry-leading standard in all four categories listed below:

  • Security – Verifying the system is protected against unauthorized access, use, or modification to meet the entity’s commitments and system requirements.
  • Availability – Verifying the system is available for operation and use to meet the entity’s commitments and system requirements.
  • Processing Integrity – Verifying the system processing is complete, valid, accurate, timely, and authorized to meet the entity’s commitments and system requirements.
  • Confidentiality – Verifying that information designated as confidential is protected to meet the entity’s commitments and system requirements.

SOC 2 examinations may only be performed by a licensed CPA firm. Kahn, Litwin, Renza & Co., Ltd (“KLR”), a leading provider of SOC services, performed the service audit of Smart Software. ”By regularly attaining a SOC 2 certification, Smart Software continues to demonstrate its commitment to its Smart IP&O customers by building trust and confidence in the services that it provides relevant to Security, Availability, Processing Integrity and Confidentiality.” said Daniel M. Andrea, Partner and SOC Services Practice Leader of KLR.

About Smart Software, Inc.

Smart Software, a leading innovator in demand planning, statistical forecasting, and inventory optimization software, offers Smart IP&O, an integrated suite of cloud demand planning, inventory optimization and supply chain analytics applications.  Founded in 1981, Smart serves a wide range of manufacturing, distribution, and transportation organizations including The Home Depot, FedEx,  DisneyLand Resorts, MARS, BC Transit, Metro-North Railroad and many, many more.

 

Learn more at:  www.smartcorp.com


For more information, please contact Smart Software, Inc., Four Hill Road, Belmont, MA 02478.
Phone: 1-800-SMART-99 (800-762-7899); FAX: 1-617-489-2748; E-mail: info@smartcorp.com

 

 

Smart Software Senior VP/Research to present at Military Operations Research Society (MORS) Emerging Techniques Forum

Smart Software announced today that its co-founder and Senior VP of Research, Dr. Thomas Willemain, has been selected to present at the prestigious MORS Emerging Techniques Forum December 4 – 5, 2019 in Alexandria, VA.

MORS is the Military Operations Research Society, funded by the Navy, Army, Air Force, Marine Corps, Office of the Secretary of the Defense and the Department of Homeland Security. Its mission is to enhance the quality of analysis that informs national and homeland security decisions.

The Emerging Techniques Forum provides the defense analytic community with extensive content on emerging analytic topics and techniques. Willemain will be one of a small number of experts speaking in the Computational Advances in Analytics track. This track addresses new tools and techniques that leverage increased computing power and data availability.

Willemain’s topic will be “Validating Demand Scenario Generators for Inventory Optimization.” This research is part of Smart Software’s continuing work to push the state of the art in managing fleets of spare parts and hard to forecast items.  These advancements will be incorporated into Smart IP&O, the company’s multi-tenant web based platform for forecasting, inventory planning and optimization.  The research began with Dr. Willemain’s doctoral students at Rensselaer Polytechnic Institute, where he remains active as Professor Emeritus of Industrial and Systems Engineering.

 

About Smart Software, Inc.

Founded in 1981, Smart Software, Inc. is a leader in providing businesses with enterprise-wide demand forecasting, planning and inventory optimization solutions.  Smart Software’s demand forecasting and inventory optimization solutions have helped thousands of users worldwide, including customers at mid-market enterprises and Fortune 500 companies, such as Otis Elevator, Mitsubishi, Siemens, Disney, FedEx, MARS, and The Home Depot.  Smart Inventory Planning & Optimization gives demand planners the tools to handle sales seasonality, promotions, new and aging products, multi-dimensional hierarchies, and intermittently demanded service parts and capital goods items.  It also provides inventory managers with accurate estimates of the optimal inventory and safety stock required to meet future orders and achieve desired service levels.  Smart Software is headquartered in Belmont, Massachusetts and can be found on the World Wide Web at www.smartcorp.com.

SmartForecasts and Smart IP&O are registered trademarks of Smart Software, Inc.  All other trademarks are the property of their respective owners.


For more information, please contact Smart Software, Inc., Four Hill Road, Belmont, MA 02478.
Phone: 1-800-SMART-99 (800-762-7899); FAX: 1-617-489-2748; E-mail: info@smartcorp.com