Six Steps Up the Learning Curve for New Planners

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

If you are a new professional in the field of inventory management, you face a very steep learning curve. There are many moving parts in the system you manage, and much of the movement is random. You may find it helpful to take a step back from the day-to-day flow to think about what it takes to be successful. Here are six suggestions that you may find useful; they are distilled from working over thirty five years with some very smart practitioners.


1. Know what winning means.

Inventory management is not a squishy area where success can be described in vague language. Success here is a numbers game. There a number of key performance indicators (KPI’s) available to you, including Service Level, Fill Rate, Inventory Turns, Inventory Investment, and Inventory Operating Cost. Companies differ in the importance they assign to each metric such, but you can’t win without using some or all of these to keep score.

But “winning” is not as simple as getting the best possible score on each metric. The metric values that are most important vary across companies. Your company may prioritize customer service over cost control, or vice versa, and next year it might have reason to reverse that preference.

Furthermore, there are linkages among KPI’s that require you to think of them simultaneously rather than as a collection of independent scores. For example, improving Service Level will usually also improve Fill Rate, which is good, but it will also usually increase Operating Cost, which is not good.

These linkages express themselves as tradeoffs. And while the KPI’s themselves are numbers, the management of the bundle of KPI’s requires some wise subjectivity, because what is needed is a reasonable balance among competing forces. The fundamental tradeoff is to balance the cost of having inventory against the value of having the inventory available to those who need it.

If you are relatively junior, these tradeoff judgments may be made higher in the organization, but even then you can play a useful role by insuring that the tradeoffs are exposed and appreciated. This means exposed at a quantitative level, e.g., “We can increase Service Level from 85% to 90%, but it will require $100K more stock in the warehouse.” This kind of specific quantitative knowledge can be provided by advanced supply chain analytics.


2. Keep score.

We’re all a bit squeamish about being measured, but confident professionals insist on keeping score. Enlightened supervisors understand that external forces can ding the performance of your system (e.g., a key supplier disappears), and that always helps. But whether or not you have good top cover, you cannot demonstrate success, nor can you react to problems, without measuring those KPI’s.

Keeping score is important, but so is understanding what influences score. Suppose your Service Level has dropped from last month’s value. Is that just the usual month-to-month fluctuation or is it something out of the ordinary? If it is problematic, then you need to diagnose the problem. Often there are several possible suspects. For example, Service Level can drop because the sales and marketing folks did something great and demand has spiked, or because a supplier did something not so great and replenishment lead time has tanked. Software can help you track these key inputs to help your detective work, and supply chain analytics can estimate the impacts of changes in these inputs and point you to compensating responses.


3. Be sure your decisions are fact-based.

Software can guide you to good decisions, but only if you let it. Inputs such as holding costs, ordering costs, and shortage costs need to be well estimated to get accurate assessment of tradeoffs. Especially important is something as apparently simple as using correct values for item demand, since modeling demand is the starting point for simulating the results of any proposed inventory system design. In fact, if we are willing to stretch the meaning of “fact” a bit to include the results of system simulations, you should not commit to major changes without having reliable predictions of what will happen when you commit to those changes.


4. Realize that yesterday’s answer may not be today’s answer.

Supply chains are collections of parts, all of which are subject to change over time. Demand that is trending up may start to trend down. Replenishment lead times may slip. Supplier order minima may increase. Component prices may increase due to tariffs. Such factors mean that the facts you collected yesterday can be out of date today, making yesterday’s decisions inappropriate for today’s problems. Vigilance. Check out a prior article detailing the adverse financial impact of infrequent updates to planning parameters.


5. Give each item its due.

If you are responsible for hundreds or thousands of inventory items, you will be tempted to simplify your life by adopting a “one size fits all” approach. Don’t. SKU’s aren’t exactly like snowflakes, but some differentiation is required to do your job well. It’s a good idea to form groups of items based on some salient characteristics. Some items are critical and must (almost) always be available; others can run some reasonable risk of being backordered. Some items are quite unpredictable because they are “intermittent” (i.e., have lots of zero values with nonzero values mixed in at random); others have high volume and are reasonably predictable. Some items can be managed with relatively inexpensive inventory methods that make adjustments every month; some items need methods that continuously monitor and adjust the stock on hand. Some items, such as contractual purchases, may be so predictable that you can treat them as “planned demand” and pull them out from the rest.

Once you have formed sensible item groups, you still have decisions to make about each item in each group, such as deciding their reorder points and order quantities. Here advanced analytics can take over and automatically compute the best choices based on what winning means in the context of that group.  


6. Get everybody on the same page.

Being organized is not only pleasing, it’s efficient. If you have a system for inventory management, then everybody on your team shares the same objectives and follows the same processes. If you don’t have a system, then every planner has his or her own way of thinking about the problem and making decisions. Some of those are bound to be better than others. It’s desirable to standardize on the best practices and ban the rest. Besides being more efficient, having a standardized process makes it easier to diagnose problems when things go wrong and to implement fixes.


Volume and color boxes in a warehouese


Leave a Comment

Related Posts

The Supply Chain Blame Game:  Top 3 Excuses for Inventory Shortage and Excess

The Supply Chain Blame Game: Top 3 Excuses for Inventory Shortage and Excess

The supply chain has become the blame game for almost any industrial or retail problem. Shortages on lead time variability, bad forecasts, and problems with bad data are facts of life, yet inventory-carrying organizations are often caught by surprise when any of these difficulties arise. So, again, who is to blame for the supply chain chaos? Keep reading this blog and we will try to show you how to prevent product shortages and overstocking.

Recent Posts

  • Epicor Prophet 21 with Forecasting Inventory PlanningExtend Epicor Prophet 21 with Smart IP&O’s Forecasting & Dynamic Reorder Point Planning
    Smart Inventory Planning & Optimization (Smart IP&O) can help with inventory ordering functionality in Epicor P21, reduce inventory, minimize stockouts and restore your organization’s trust by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning. […]
  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Mature bearded mechanic in uniform examining the machine and repairing it in factoryService Parts Planning: Planning for consumable parts vs. Repairable Parts
    When deciding on the right stocking parameters for spare and replacement parts, it is important to distinguish between consumable and repairable servoce parts. These differences are often overlooked by inventory planning software and can result in incorrect estimates of what to stock. Different approaches are required when planning for consumables vs. repairable service parts. […]
  • Four Common Mistakes when Planning Replenishment TargetsFour Common Mistakes when Planning Replenishment Targets
    How often do you recalibrate your stocking policies? Why? Learn how to avoid key mistakes when planning replenishment targets by automating the process, recalibrating parts, using targeting forecasting methods, and reviewing exceptions. […]
  • Smart Software is pleased to introduce our series of webinars, offered exclusively for Epicor Users.Extend Epicor Kinetic’s Forecasting & Min/Max Planning with Smart IP&O
    Epicor Kinetic can manage replenishment by suggesting what to order and when via reorder point-based inventory policies. The problem is that the ERP system requires that the user either manually specify these reorder points, or use a rudimentary “rule of thumb” approach based on daily averages. In this article, we will review the inventory ordering functionality in Epicor Kinetic, explain its limitations, and summarize how to reduce inventory, and minimize stockouts by providing the robust predictive functionality that is missing in Epicor. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Blanket Orders Smart Software Demand and Inventory Planning HDBlanket Orders
      Our customers are great teachers who have always helped us bridge the gap between textbook theory and practical application. A prime example happened over twenty years ago, when we were introduced to the phenomenon of intermittent demand, which is common among spare parts but rare among the finished goods managed by our original customers working in sales and marketing. This revelation soon led to our preeminent position as vendors of software for managing inventories of spare parts. Our latest bit of schooling concerns “blanket orders.” […]
    • Hand placing pieces to build an arrowProbabilistic Forecasting for Intermittent Demand
      The New Forecasting Technology derives from Probabilistic Forecasting, a statistical method that accurately forecasts both average product demand per period and customer service level inventory requirements. […]
    • Engineering to Order at Kratos Space – Making Parts Availability a Strategic Advantage
      The Kratos Space group within National Security technology innovator Kratos Defense & Security Solutions, Inc., produces COTS s software and component products for space communications - Making Parts Availability a Strategic Advantage […]
    • wooden-figures-of-people-and-a-magnet-team-management-warehouse inventoryManaging the Inventory of Promoted Items
      In a previous post, I discussed one of the thornier problems demand planners sometimes face: working with product demand data characterized by what statisticians call skewness—a situation that can necessitate costly inventory investments. This sort of problematic data is found in several different scenarios. In at least one, the combination of intermittent demand and very effective sales promotions, the problem lends itself to an effective solution. […]

        Here are six suggestions that you may find useful; they are distilled from working over thirty five years with some very smart practitioners. Cloud computing companies with unique server and hardware parts, e-commerce, online retailers, home and office supply companies, onsite furniture, power utilities, intensive assets maintenance or warehousing for water supply companies have increased their activity during the pandemic. Garages selling car parts and truck parts, pharmaceuticals, healthcare or medical supply manufacturers and safety product suppliers are dealing with increasing demand. Delivery service companies, cleaning services, liquor stores and canned or jarred goods warehouses, home improvement stores, gardening suppliers, yard care companies, hardware, kitchen and baking supplies stores, home furniture suppliers with high demand are facing stockouts, long lead times, inventory shortage costs, higher operating costs and ordering costs.