How does your ERP system treat safety stock?

Is safety stock regarded as emergency spares or as a day-to-day buffer against spikes in demand? Knowing the difference and configuring your ERP properly will make a big difference to your bottom line.

The Safety Stock field in your ERP system can mean very different things depending on the configuration. Not understanding these differences and how they impact your bottom line is a common issue we’ve seen arise in implementations of our software.

Implementing inventory optimization software starts with new customers completing the technical implementation to get data flowing.  They then receive user training and spend weeks carefully configuring their initial safety stocks, reorder levels, and consensus demand forecasts with Smart IP&O.  The team becomes comfortable with Smart’s key performance predictions (KPPs) for service levels, ordering costs, and inventory on hand, all of which are forecasted using the new stocking policies.

But when they save the policies and forecasts to their ERP test system, sometimes the orders being suggested are far larger and more frequent than they expected, driving up projected inventory costs.

When this happens, the primary culprit is how the ERP is configured to treat safety stock.  Being aware of these configuration settings will help planning teams better set expectations and achieve the expected outcomes with less effort (and cause for alarm!).

Here are the three common examples of ERP safety stock configurations:

Configuration 1. Safety Stock is treated as emergency stock that can’t be consumed. If a breach of safety stock is predicted, the ERP system will force an expedite no matter the cost so the inventory on hand never falls below safety stock, even if a scheduled receipt is already on order and scheduled to arrive soon.

Configuration 2. Safety Stock is treated as Buffer stock that is designed to be consumed. The ERP system will place an order when a breach of safety stock is predicted but on hand inventory will be allowed to fall below the safety stock. The buffer stock protects against stockout during the resupply period (i.e., the lead time).

Configuration 3. Safety Stock is ignored by the system and treated as a visual planning aid or rule of thumb. It is ignored by supply planning calculations but used by the planner to help make manual assessments of when to order.

Note: We never recommend using the safety stock field as described in Configuration 3. In most cases, these configurations were not intended but result from years of improvisation that have led to using the ERP in a non-standard way.  Generally, these fields were designed to programmatically influence the replenishment calculations.  So, the focus of our conversation will be on Configurations 1 and 2. 

Forecasting and inventory optimization systems are designed to compute forecasts that will anticipate inventory draw down and then calculate safety stocks sufficient to protect against variability in demand and supply. This means that the safety stock is intended to be used as a protective buffer (Configuration 2) and not as emergency sparse (Configuration 3).  It is also important to understand that, by design, the safety stock will be consumed approximately 50% of the time.

Why 50%? Because actual orders will exceed an unbiased forecast half of the time. See the graphic below illustrating this.  A “good” forecast should yield the value that will come closest to the actual most often so actual demand will either be higher or lower without bias in either direction.

 

How does your ERP system treat safety stock 1

 

If you configured your ERP system to properly allow consumption of safety stock, then the on hand inventory might look like the graph below.  Note that some safety stock is consumed but avoided a stockout.  The service level you target when computing safety stock will dictate how often you stockout before the replenishment order arrives.  Average inventory is roughly 60 units over the time horizon in this scenario.

 

How does your ERP system treat safety stock 2

 

If your ERP system is configured to not allow consumption of safety stock and treats the quantity entered in the safety stock field more like emergency spares, then you will have a massive overstock!  Your inventory on hand would look like the graph below with orders being expedited as soon as a breach of safety stock is expected. Average inventory is roughly 90 units, a 50% increase compared to when you allowed safety stock to be consumed.

 

How does your ERP system treat safety stock 3

 

Top 4 Moves When You Suspect Software is Inflating Inventory

We often are asked, “Why is the software driving up the inventory?” The answer is that Smart isn’t driving it in either direction – the inputs are driving it, and those inputs are controlled by the users (or admins). Here are four things you can do to get the results you expect.

1. Confirm that your service level targets are commensurate with what you want for that item or group of items. Setting very high targets (95% or more) will likely drive inventory up if you have been coasting along at a lower level and are OK with being there. It’s possible you’ve never achieved the new higher service level but customers have not complained.  Figure out what service level has worked by evaluating historical reports on performance and set your targets accordingly. But keep in mind that competitors may beat you on item availability if you keep using your father’s service level targets.

2. Make sure your understanding of “service level” aligns with the software system’s definition. You may be measuring performance based on how often you ship within one week from receipt of the customer order, whereas the software is targeting reorder points based on your ability to ship right away, not within a week. Clearly the latter will require more inventory to hit the same “service level.” For instance, a 75% same-day service level may correspond to a 90% same-week service level. In this case, you are really comparing apples to oranges. If this is the reason for the excess stock, then determine what “same day” service level is needed to get you to your desired “same week” service level and enter that into the software. Using the less-stringent same-day target will drop the inventory, sometimes very significantly.

3. Evaluate the lead time inputs. We’ve seen instances in which lead times had been inflated to trick old software into producing desired results. Modern software tracks suppliers’ performance by recording their actual lead times over multiple orders, then it takes account of lead time variability in its simulations of daily operations. Watch out if your lead times are fixed at one value that was decided on in the distant past and isn’t current.

4. Check your demand signal. You have lots of historical transactions in your ERP system that can be used in many ways to determine the demand history. If you are using signals such as transfers, or you are not excluding returns, then you may be overstating demand. Spend a little time on defining “demand” in the way that makes most sense for your situation.

Smart Software Customer, Arizona Public Service to Present at USMA 2023

Belmont, MA, – Smart Software, Inc., provider of industry-leading demand forecasting, planning, and inventory optimization solutions, today announced that its customer, Arizona Public Service (APS) will present at USMA 2023.

Joseph Neuheisel, Inventory & Logistics Manager at APS, will lead the session at USMA 2023. The presentation will focus on how APS implemented Smart Inventory Planning and Optimization (Smart IP&O) as part of the company’s strategic supply chain optimization initiative. Mr. Neuheisel will detail their prior process, implementation, challenges they faced, results, and lessons learned. Smart IP&O was implemented in just 90 days and now enables APS to optimize its reorder points and order quantities for over 250,000 spare parts helping to reduce inventory and maintain service levels.

 

The Utility Supply Management Alliance  (USMA )
The USMA is a multi-national association of individuals serving the electric, gas, and water utilities. With deregulation and re-regulation of the Electric and Gas Utilities industries, the demands of the customer are also changing, making it necessary for the Electric and Gas Utilities to pay significant attention to cost and competition. The supply chain for material and equipment services has a significant impact on the cost of electricity and gas. Hence there are great opportunities to contribute to the bottom line through reduced cost as a result of improved reorganization and management of the supply chain process. The role of the USMA is to understand the sophisticated workings of the supply chain to provide its customers (utilities, suppliers, manufacturers, etc.) with skills and tools to realize profit opportunities in the supply chain. These skills and tools will be provided to the USMA customer through workshops at its annual conference.

 

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 such as Arizona Public Service, Ameren, and The American Red Cross.  Smart’s Inventory Planning & Optimization Platform, Smart IP&O 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 our website is 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 and Optimum Consulting Announce Strategic Partnership

Belmont, Mass., May 2023 – Smart Software, Inventory optimization, demand planning, and forecasting software leader, and Optimum Consulting, today announced their partnership to address the supply chain planning needs of the Manufacturing, Wholesale, and Retail industries in Australia and New Zealand. Optimum Consulting will sell and deploy Smart’s next-generation cloud platform, Smart Inventory Planning & Optimization (Smart IP&O™), as an integral part of its Sales, Operations, and Inventory Planning (SIOP) practice.

Smart Software is a Microsoft Co-sell-ready partner and, over the years, has created a flawless connector to integrate tools with Microsoft Dynamics. The integration brings the cloud-based Smart IP&O (Inventory Planning and Optimization) into the latest version of Microsoft Dynamic solution. By seamlessly integrating strategic planning in Smart IP&O with operational execution in Dynamics, business users can continuously predict, respond, and plan more effectively in today’s uncertain business environment. Smart’s unique approach to planning intermittent demand is especially impactful for public utilities and transit agencies, given the prevalence of spare parts with highly sporadic, seemingly unforecastable usage.

Optimum Consulting is a Microsoft Dynamics 365 Solutions Partner who is totally committed to the Manufacturing, Wholesale, and Retail industries in Australia and New Zealand. The Team’s experts help clients build agile operating models, drive business process improvements, and turn customers into advocates by delivering end-to-end Microsoft Dynamics 365, Microsoft Power Apps, Business Intelligence & Analytics, and Managed Services Solutions.

“Smart Software helps our customers by delivering insightful business analytics for inventory modeling and forecasting that drive ordering and replenishment in the latest version of Microsoft Dynamics. With Smart IP&O, our customers gain a means to shape inventory strategy to align with the business objectives while empowering their planning teams to reduce inventory and improve service,” says  Matthew Lingard, CEO at  Optimum Consulting

“Maximizing the benefits our solutions can provide requires the expertise and perspective to consider requirements, set goals, and to develop the supporting business process that ensures adoption and benefits. These are the qualities that The New Partner brings to the table and we look forward to our joint success,”…. says Greg Hartunian, President, and CEO at Smart Software

 

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 Disney, Arizona Public Service, and Ameren.  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.

 

About the Partner, Inc.

Optimum Consulting is a Microsoft Dynamics 365 Solutions Partner who is totally committed to the Manufacturing, Wholesale, and Retail industries in Australia and New Zealand. The Team’s experts help clients build agile operating models, drive business process improvements, and turn customers into advocates by delivering end-to-end Microsoft Dynamics 365, Microsoft Power Apps, Business Intelligence & Analytics, and Managed Services Solutions. The Team’s functional expertise covers eCommerce, Retail, Pricing & Promotions, Customer Data Platform, Customer Journey Mapping, Customer Experience, Forecasting & Master Planning, Advanced Warehouse, and Production Planning.  Optimum Consulting’s technical capabilities span across Commerce Design and Development, Commerce Server, Point of Sale (POS) Development, Finance and Supply Chain Management (SCM) Development, Artificial Intelligence (AI) and Machine Learning (ML), Data Warehouse and Data Lake, and related Microsoft Cloud solutions.

 

 


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

 

 

Uncover data facts and improve inventory performance

The best inventory planning processes rely on statistical analysis to uncover relevant facts about the data. For instance:

  1. The range of demand values and supplier lead times to expect.
  2. The most likely values of item demand and supplier lead time.
  3. The full probability distributions of item demand and supplier lead time.

If you reach the third level, you have the facts required to answer important operational questions, additional questions such as:

  1. Exactly how much extra stock is needed to improve service levels by 5%?
  2. What will happen to on-time-delivery if inventory is reduced by 5%?
  3. Will either of the above changes generate a positive financial return?
  4. More generally, what service level target and associated inventory level is most profitable?

When you have the facts and add your business knowledge, you can make more informed stocking decisions that will generate significant returns. You’ll also set proper expectations with internal and external stakeholders, ensuring there are fewer unwelcome surprises.