The Force Need Not Be With You

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

With the world once again in the grip of Jedi-mania, we can take a moment to think about what special powers are needed to turn an ordinary inventory professional into an Inventory Optimizer.

There’s a lot to know

Proficiency in the inventory arts requires mastery of a great deal of knowledge: Product knowledge, knowledge of suppliers and customers, teamwork skills, and a visceral understanding of the stochastic dynamics of inventory demand. One of the most fundamental types of knowledge is corporate self-knowledge, especially knowing where you want your organization to go.

How to know it

So much of that knowledge rests on an understanding of operational information: How to gather it, interpret it, and discern its implications. Most of that information is in the form of hard numbers, usually too many to absorb without computer help. Some of it comes from conversations with customers and suppliers, which let you know where they want their organizations to go and how you figure into their plans. Blending large quantities of numbers with knowledge of everybody’s goals and intentions provides situational awareness.

How to use the knowledge

Situational awareness must be translated into detailed operational decisions for every inventory item. For each item, you must decide on an inventory policy: As inventory decreases, at what point should we order more? How much more? How do we respond to stockouts?

In the good old days, these decisions were usually made based on gut instinct. You might say, or hope, that these decisions were guided by The Force. Unfortunately, what the good old days often bequeathed the present day was nothing more than a mish-mash of incoherent and dysfunctional policies. If there is “no try, only do or not do”, then the history of inventory management has seen a lot of not do.

Rather than hoping for mystical inspiration, the way forward is to systematically organize all that information into accurate, comprehensive probability models of inventory dynamics. Such models can relate all the key levers of performance to key performance indicators (KPI’s).

How software analytics can help

Software analytics can relate key drivers of performance to performance metrics. Key drivers include reorder points or min’s, order quantities or max’s, replenishment lead times, and the level and variability of demand. Also important are the costs of holding, ordering and running out of inventory. Using numerical values for these key inputs, inventory software can estimate the corresponding values of service level, fill rate, inventory operating costs and total inventory capital investment. In other words, the software can convert design decisions into consequences.

Now, some decisions might be a bit misguided, with consequences that are not appealing. Then the software becomes not just an analysis tool but a design tool. That is, it lets you play around a bit, exploring different decisions and hunting for system designs that yield better results.

This is where reliance on The Force reappears in practice, because you are left using the software to help you intuit your way to good system designs. We call this “hunt and peck optimization”. It amounts to a guessing game in which you try changing one or more of the drivers to see whether the KPI’s get better or worse.

The most advanced inventory software can take you to the next level. It is inventory optimization software. It eliminates the guesswork by automating the search through the very large “design space” to find desirable system designs for all your items.

For instance, you might ask the software to find that combination of reorder point and order quantity that minimizes the total cost of managing an item (i.e., the sum of holding, ordering and shortage costs) while insuring that the chance of a stockout is tolerably low. Even if your Jedi powers would eventually lead you to the same design, do you really want to whack your way through all 20,000 items you are managing? Let R2D2 figure it all out: That’s what droids are for.

Why we still need our light sabers

Despite all the productivity gains by inventory optimization software, you may still feel the need to take light saber in hand and finish off the design of inventory policy for selected items. You may want to do this for several reasons.

One is to see how sensitive the optimal design is to slight changes. For example, the most efficient designs might require more orders than your purchasing department can comfortably handle in one year. So you might want to see how much performance deteriorates if you make a practical concession and specify a larger order quantity.

There are key differences between this kind of “post-optimality” analysis and the old-fashioned hand-crafting of individual inventory policies. For one, the starting point is a very smart design, not a guess. For another, you can pick and choose the items that get your personal attention, assured that all the rest are well provided for.

ondemandwebinar

Leave a Comment

Related Posts

Head to Head: Which Service Parts Inventory Policy is Best?

Head to Head: Which Service Parts Inventory Policy is Best?

Our customers have usually settled into one way to manage their service parts inventory. The professor in me would like to think that the chosen inventory policy was a reasoned choice among considered alternatives, but more likely it just sort of happened. Maybe the inventory honcho from long ago had a favorite and that choice stuck. Maybe somebody used an EAM or ERP system that offered only one choice. Perhaps there were some guesses made, based on the conditions at the time.

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.

Finding Your Spot on the Tradeoff Curve

Finding Your Spot on the Tradeoff Curve

Managing inventory, like managing anything, involves balancing competing priorities. Do you want a lean inventory? Yes! Do you want to be able to say “It’s in stock” when a customer wants to buy something? Yes!
But can you have it both ways? Only to a degree. If you lean into leaning your inventory too aggressively, you risk stockouts. If you stamp out stockouts, you create inventory bloat. You are forced to find a satisfactory balance between the two competing goals of lean inventory and high item availability.

Recent Posts

  • Smart Software Partnership with Sage for Inventory Optimization and Demand ForecastingSmart Software Announces Strategic Partnership with Sage for Inventory Optimization and Demand Forecasting
    Smart Software announces today their strategic partnership with Sage. This collaboration brings Smart IP&O (Inventory Planning and Optimization) into the latest cloud and on-premises versions of Sage X3, Sage 300, and Sage 100. […]
  • Head to Head Which Service Parts Inventory Policy is Best SoftwareHead to Head: Which Service Parts Inventory Policy is Best?
    Our customers have usually settled into one way to manage their service parts inventory. The professor in me would like to think that the chosen inventory policy was a reasoned choice among considered alternatives, but more likely it just sort of happened. Maybe the inventory honcho from long ago had a favorite and that choice stuck. Maybe somebody used an EAM or ERP system that offered only one choice. Perhaps there were some guesses made, based on the conditions at the time. […]
  • The Forecasting Process For Decision-MakersThe Forecasting Process for Decision-Makers
    In almost every business and industry, decision-makers need reliable forecasts of critical variables, such as sales, revenues, product demand, inventory levels, market share, expenses, and industry trends.Many kinds of people make these forecasts. Some are sophisticated technical analysts such as business economists and statisticians. Many others regard forecasting as an important part of their overall work: general managers, production planners, inventory control specialists, financial analysts, strategic planners, market researchers, and product and sales managers. Still, others seldom think of themselves as forecasters but often have to make forecasts on an intuitive, judgmental basis. […]
  • Success Story: Procon Pumps Uses Smart Demand Planner to Keep Business FlowingProcon Pumps Uses Smart Demand Planner to Keep Business Flowing
    Smart platform’s advanced analytics, and smooth integration with Procon’s ERP system led to accurate forecasts, and optimal inventory levels. […]
  • Weathering a Demand ForecastWeathering a Demand Forecast
    For some of our customers, weather has a significant influence on demand. Extreme short-term weather events like fires, droughts, hot spells, and so forth can have a significant near-term influence on demand. There are two ways to factor weather into a demand forecast: indirectly and directly. The indirect route is easier using the scenario-based approach of Smart Demand Planner. The direct approach requires a tailored special project requiring additional data and hand-crafted modeling. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
      True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
    • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
      Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory. […]
    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]
    • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
      In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]