The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Summary

Setting a target service level or fill rate is a strategic decision about inventory risk management. Choosing service levels can be difficult. Relevant factors include current service levels, replenishment lead times, cost constraints, the pain inflicted by shortages on you and your customers, and your competitive position. Target setting is often best approached as a collaboration among operations, sales and finance. Inventory optimization software is an essential tool in the process.

Service Level Choices

Service level is the probability that no shortages occur between when you order more stock and when it arrives on the shelf. The reasonable range of service levels is from about 70% to 99%. Levels below 70% may signal that you don’t care about or can’t handle your customers. Levels of 100% are almost never appropriate and usually indicate a hugely bloated inventory.

Factors Influencing Choice of Service Level

Several factors influence the choice of service level for an inventory item. Here are some of the more important.

Current service levels:
A reasonable place to start is to find out what your current service levels are for each item and overall. If you are already in good shape, then the job becomes the easier one of tweaking an already-good solution. If you are in bad shape now, then setting service levels can be more difficult. Surprisingly few companies have data on this important metric across their whole fleet of inventory items. What often happens is that reorder points grow willy-nilly from choices made in corporate pre-history and are rarely, sometimes never, systematically reviewed and updated. Since reorder points are a major determinant of service levels, it follows that service levels “just happen”. Inventory optimization software can convert your current reorder points and lead times into solid estimates of your current service levels. This analysis often reveals subset of items with service levels either too high or too low, in which case you have guidance about which items to adjust down or up, respectively.

Replenishment lead times:
Some companies adjust service levels to match replenishment lead times. If it takes a long time to make or buy an item, then it takes a long time to recover from a shortage. Accordingly, they bump up service levels on long-lead-time items and reduce them on items for which backlogs will be brief.

Cost constraints:
Inventory optimization software can find the lowest-cost ways to hit high service level targets, but aggressive targets inevitably imply higher costs. You may find that costs constrain your choice of service level targets. Costs come in various flavors. “Inventory investment” is the dollar value of inventory. “Operating costs” include both holding costs and ordering costs. Constraints on inventory investment are often imposed on inventory executives and always imply ceilings on service level targets; software can make these relationships explicit but not take away the necessity of choice. It is less common to hear of ceilings on operating costs, but they are always at least a secondary factor arguing for lower service levels.

Shortage costs:
Shortage costs depend on whether your shortage policy calls for backorders or lost sales. In either case, shortage costs work counter to inventory investment and operating costs by arguing for higher service levels. These costs may not always be expressed in dollar terms, as in the case of medical/surgical supplies, where shortage costs are denominated in morbidity and mortality.

Competition:
The closer your company is to dominating its market, the more you can ease back on service levels to save money. However, easing back too far carries risks: It encourages potential customers to look elsewhere, and it encourages competitors. Conversely, high product availability can go far to bolstering the position of a minor player.

Collaborative Targeting

Inventory executives may be the ones tasked with setting service level targets, but it may be best to collaborate with other functions when making these calls. Finance can share any “red lines” early in the process, and they should be tasked with estimating holding and ordering costs. Sales can help with estimating shortage costs by explaining likely customer reactions to backlogs or lost sales.

The Role of Inventory Optimization and Planning Software

Without inventory optimization software, setting service level targets is pure guesswork: It is impossible to know how any given target will play out in terms of inventory investment, operating costs, shortage costs. The software can compute the detailed, quantitative tradeoff curves required to make informed choices or even recommend the target service level that results in the lowest overall cost considering holding costs, ordering costs, and stock out costs. However, not all software solutions are created equal. You might enter a user defined 99% service level into your inventory planning system or the system could recommend a target service – but it doesn’t mean you will actually hit that stated service level. In fact, you might not even come close to hitting it and achieve a much lower service level. We’ve observed situations where a targeted service level of 99% actually achieved a service level of just 82%! Any decisions made as a result of the target will result in unintended misallocation of inventory, very costly consequences, and lots of explaining to do. So be sure to check out our next blog article on how to measure the accuracy of your service level forecast so you don’t make this costly mistake.

Leave a Comment

Related Posts

The Cost of Spreadsheet Planning

The Cost of Spreadsheet Planning

Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies.

Finding Your Spot on the Inventory Tradeoff Curve

Finding Your Spot on the Inventory Tradeoff Curve

This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium.

Why MRO Businesses Need Add-on Service Parts Planning & Inventory Software

Why MRO Businesses Need Add-on Service Parts Planning & Inventory Software

MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning.

Recent Posts

  • Epicor AI Forecasting and Inventory Technology Combined with Planner Knowledge for InsightsSmart Software to Present at Epicor Insights 2024
    Smart Software will present at this year's Epicor Insights event in Nashville. If you plan to attend this year, please join us at booth #13 or #501, and learn more about Epicor Smart Inventory Planning and Optimization. . […]
  • Looking for Trouble in Your Inventory DataLooking for Trouble in Your Inventory Data
    In this video blog, the spotlight is on a critical aspect of inventory management: the analysis and interpretation of inventory data. The focus is specifically on a dataset from a public transit agency detailing spare parts for buses. […]
  • BAF Case Study SIOP planning Distribution CenterBig Ass Fans Turns to Smart Software as Demand Heats Up
    Big Ass Fans is the best-selling big fan manufacturer in the world, delivering comfort to spaces where comfort seems impossible. BAF had a problem: how to reliably plan production to meet demand. BAF was experiencing a gap between bookings forecasts vs. shipments, and this was impacting revenue and customer satisfaction BAF turned to Smart Software for help. […]
  • The Cost of Doing nothing with your inventory Planning SystemsThe Cost of Spreadsheet Planning
    Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]
  • Randomness can be an Ally in the Forecasting BattleCan Randomness be an Ally in the Forecasting Battle?
    When we try to understand the complex world of logistics, randomness plays a pivotal role. This introduces an interesting paradox: In a reality where precision and certainty are prized, could the unpredictable nature of supply and demand actually serve as a strategic ally? The quest for accurate forecasts is not just an academic exercise; it's a critical component of operational success across numerous industries. For demand planners who must anticipate product demand, the ramifications of getting it right—or wrong—are critical. Hence, recognizing and harnessing the power of randomness isn't merely a theoretical exercise; it’s a necessity for resilience and adaptability in an ever-changing environment. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
      MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
    • 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. […]