The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Many companies adopt a philosophy of “it’s better to have it and not need it, then to need it and not have it.” Planning initiatives such as implementing inventory optimization software in order to optimize reorder points, safety stocks, and order quantities are often seen as narrowly focused on reducing inventory and not pursued. Stock-out costs may very well be extremely high. However, resources are finite. The opportunity cost of keeping too much of one product means less space, cash, and resources for another product. Overstocking on one item reduces the ability to provide adequate levels of service on other items. Justifying overstocks by stating it is good for the customer is a poor excuse at best that hurts the customer and ignores what inventory optimization is really about – properly reallocating inventory investments.

Diminishing Returns and Inventory

Each additional unit of inventory that you carry buys proportionally less service. Inventory optimization software can help you understand the exact stock out risk given a certain level of stock. For example, say your stock-out risk with 20 units of inventory is 10%. If you add another 10 units and carry 30 units, the stock out risk might get cut in half to 5%. If you then add an additional 10 for a total of 40 units, the stock-out risk may only drop to 4%. At some point, the additional inventory just isn’t worth the extra service it buys. This is especially so if the cash used to buy that extra 10 units to get a small service level bump on one item could have been spent on another equally important item for a larger increase in service.

Carrying more than you need means you aren’t efficiently managing assets, which costs money, which means you can’t offer the best price to your customer, which hurts your ability to beat the competition. It also means there is less money for investment in other items. This results in the common adage “We have too much of the stuff we don’t need and not enough of the stuff we do.”

Inventory Optimization is about reallocation

The example presented in the blog’s main image highlights the benefits of reallocating inventory.  We used probability forecasting to estimate the service levels and inventory costs that would result from the current stocking policy. We then conducted a “what-if” scenario by modifying the policy. In the benchmark shown in the first column, the current stock levels were forecasted to yield a 84.78% service level and required $1.67 Million in inventory. Nearly 12% of the items numbers had reached their point of diminishing return and were forecasted to achieve a 100% service level. By imposing a maximum service level of 99% and a minimum service level of 80%, we reallocated inventory.  As a result, the inventory investment dropped to $1.5 Million and service level increased by 3%!

The exact point of diminishing returns will differ depending on the item, the customers involved, and the company making the stocking decision. It is important to understand the inherent levels of stock-out risk that result from current inventory policies and how changes to current policies will impact risk and costs. This enables the reshaping of inventory so that service can be maximized at the minimum possible cost.

Download Smart Inventory Optimization product sheet here: https://smartcorp.com/inventory-optimization/

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. […]