Dynamics Smart IP&O

Next-Gen Cloud Solutions in Inventory Optimization

Available for Dynamics 365 Customers

In the following blog articles, we will learn to reduce stock-outs and inventory costs by leveraging data-driven decisions that identify the financial trade-offs associated with changes in demand, lead times, service level targets, and costs.

Extend Microsoft 365 F&SC and AX with Smart IP&O

Extend Microsoft 365 F&SC and AX with Smart IP&O

Microsoft Dynamics 365 F&SC and AX can manage replenishment by suggesting what to order and when via reorder point-based inventory policies. A challenge that customers face is that efforts to maintain these levels are very detailed oriented and that the ERP system requires that the user manually specify these reorder points and/or forecasts. In this article, we will review the inventory ordering functionality in AX / D365 F&SC, explain its limitations, and summarize how to reduce inventory, minimize and controlle stockouts.

read more
Extend Microsoft 365 BC and NAV with Smart IP&O

Extend Microsoft 365 BC and NAV with Smart IP&O

Microsoft 365 BC and NAV 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 manually specify these reorder points and/or forecasts. In this article, we will review the inventory ordering functionality in Microsoft BC & NAV, explain its limitations, and summarize how to reduce inventory, and minimize stockouts by providing the robust predictive functionality that is missing in Dynamics 365.

read more

Recent Posts

  • Businessman and businesswoman reading and analysing spreadsheetThe top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts
    We often encounter Excel-based reorder point planning methods. In this post, we’ve detailed an approach that a customer used prior to proceeding with Smart. We describe how their spreadsheet worked, the statistical approaches it relied on, the steps planners went through each planning cycle, and their stated motivations for using (and really liking) this internally developed spreadsheet. […]
  • Style business group in classic business suits with binoculars and telescopes reproduce different forecasting methodsHow to interpret and manipulate forecast results with different forecast methods
    This blog explains how each forecasting model works using time plots of historical and forecast data. It outlines how to go about choosing which model to use. The examples below show the same history, in red, forecasted with each method, in dark green, compared to the Smart-chosen winning method, in light green. […]
  • Factory worker engineer working in factory using tablet computer to check maintenance boiler water pipe in factory.Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning
    When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
  • What to do when a statistical forecast doesn’t make senseWhat to do when a statistical forecast doesn’t make sense
    Sometimes a statistical forecast just doesn’t make sense. Every forecaster has been there. They may double-check that the data was input correctly or review the model settings but are still left scratching their head over why the forecast looks very unlike the demand history. When the occasional forecast doesn’t make sense, it can erode confidence in the entire statistical forecasting process. […]
  • Portrait of factory worker woman with blue hardhat holds tablet and stand in spare parts workplace area. Concept of confident of working with spare parts planning software.Spare Parts Planning Isn’t as Hard as You Think
    When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Businessman and businesswoman reading and analysing spreadsheetThe top 3 reasons why your spreadsheet won’t work for optimizing reorder points on spare parts
      We often encounter Excel-based reorder point planning methods. In this post, we’ve detailed an approach that a customer used prior to proceeding with Smart. We describe how their spreadsheet worked, the statistical approaches it relied on, the steps planners went through each planning cycle, and their stated motivations for using (and really liking) this internally developed spreadsheet. […]
    • Factory worker engineer working in factory using tablet computer to check maintenance boiler water pipe in factory.Why Spare Parts Tradeoff Curves are Mission-Critical for Parts Planning
      When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
    • Portrait of factory worker woman with blue hardhat holds tablet and stand in spare parts workplace area. Concept of confident of working with spare parts planning software.Spare Parts Planning Isn’t as Hard as You Think
      When managing service parts, you don’t know what will break and when because part failures are random and sudden. As a result, demand patterns are most often extremely intermittent and lack significant trend or seasonal structure. The number of part-by-location combinations is often in the hundreds of thousands, so it’s not feasible to manually review demand for individual parts. Nevertheless, it is much more straightforward to implement a planning and forecasting system to support spare parts planning than you might think. […]
    • Worker on a automotive spare parts warehouse using inventory planning softwareService-Level-Driven Planning for Service Parts Businesses
      Service-Level-Driven Service Parts Planning is a four-step process that extends beyond simplified forecasting and rule-of-thumb safety stocks. It provides service parts planners with data-driven, risk-adjusted decision support. […]

    Challenges: Addressing the Root Causes of Inventory Pain

    Logo for Statistical modeling and optimization

    Intermittent Demand

    Highly variable & intermittent demands make consistently accurate projections all but impossible. Countless hours are spent trying to anticipate what will come next rather than calibrating the organization’s risk tolerance and harnessing that information to determine required levels of supply.  Intermittent demand – also known as lumpy, volatile, variable or unpredictable demand – have many zero or low volume values interspersed with random spikes of demand that are often many times larger than the average.  Intermittent demand makes it difficult to accurately forecast demand and inventory requirements because there aren’t any inherent patterns.  And any patterns that may exist are overwhelmed by the random spikes in demand.  Many companies make the mistake of “chasing the forecast” insisting that sales or technicians provide better estimates of demand or turn to unreliable forecasting techniques in a quest to predict the next spike.  Many resort to forecasting inventory requirements such as Min/Max levels and Reorder Points relying primarily on subjective business knowledge and simple “rule of thumb” estimates.  The result is that millions of dollars are wasted every year because of either excess inventory costs or poor customer service due to stock-outs

    Cone Icon

    Ad Hoc Process

    The failure to establish common metrics makes it difficult to adjudicate conflicting priorities. For example, Finance may prefer to conserve cash, while Sales and Maintenance insist that they never stock out. The result is often a test of wills with forecast and inventory planners caught in the middle. This often results in decision making based on a pain avoidance response. For example, order quantities will often go up immediately following a stockout to ensure the outage never recurs. This tends to be a one-way ratchet until inventory carrying costs become an obvious drain of much needed cash. When inventory is out of balance, finger pointing often results. Operations is often stuck in the middle between sales and finance. Without a clear direction from the executive team on service goals, inventory budgets, and an insistence that sales and finance come to the table knowing that tradeoffs will have to be made, the planning team becomes disempowered and the cycle continues. An objective, quantifiable performance measure such as service level changes the discussion, putting a dollar valued on a negotiable level of service.

    Rule of Thumb ICON

    Rule of Thumb

    Safety stock levels, reorder points, lead times, and order quantity directly influence the service vs. cost relationship. Every day, the ERP system makes purchase order suggestions and manufacturing orders based on these drivers.  Ensuring that these inputs are understood and optimized will generate better returns on inventory assets.  Organizations that are able to do so will see improvements in service and reductions in inventory costs.  Unfortunately, the specific inventory policy being utilized is often unclear to many management teams.  In absence of a clearly defined and communicated policy,  planners are forced to develop their own unique approaches.  These self-developed approaches are most often a combination of simple rules of thumb and institutional knowledge. Inventory executives are simply ill equipped to shape inventory according to the changing needs and priorities of the business.  Inventory costs balloon and service performance suffers when unable to answer questions such as: “What is my current reorder point and reorder quantity policy, what level of service and inventory cost will this policy yield in the future, and how will performance and costs be influenced by specific changes to the policy.”  Rule of thumb approaches don’t answer these questions.  In fact, they ignore the critical role of of demand and supply uncertainty.  This results in excess inventory for predictable items and more frequent stock outs on less predictable items.

    ICON SKU Proliferation

    SKU Proliferation

    Whether ordering a commonly demanded, inexpensive item of an expensive intermittently demanded item, today’s customers expect high customer service levels.  This means 100% of what is ordered must be shipped from stock or within a few days.  Quoting a delivery time of more than few days may result in a cancelled order and/or violation of service level agreement costing thousands and jeopardizing customer relationships. To remain competitive, companies often must maintain a very large catalog of items all with potentially different demand patterns and volumes.  Thousands of parts potentially stocked at dozens of locations means planners don’t have the bandwidth to proactively review inventory drivers.  This results in outdated reorder points, order quantities, min/max levels, and safety stocks that trigger replenishment at the wrong time for the wrong amount ensuring poor allocation of inventory investments and low planner productivity

    Smart Inventory Optimization

    Who is Inventory Optimization for?

    Smart Inventory Optimization is for executives and business savvy planners who seek to:

    • Yield maximum returns from inventory assets.
    • Address the problem of highly variable or intermittent demand.
    • Broker the service vs. cost tradeoffs between different departments.
    • Develop a repeatable and efficient inventory planning process.
    • Empower the team to ensure operational plan is aligned with strategic plan.
    What questions can Inventory Optimization answer?
    • What is the best service level achievable with the inventory budget?
    • What service levels will yield the maximum return?
    • If lead times increased, what would it cost to maintain service?
    • If I reduce inventory, what will the impact on service be?
    • If order quantity increases, what will the impact on service and costs be?
    • What is the order quantity that balances holding and ordering costs?
    Inventory forecasting for the inventory executive

    Smart Inventory Optimization empowers you to:

    • Predict service performance and inventory costs.
    • Assess business impact of “what-if” inventory policies.
    • Align inventory policy with corporate strategy.
    • Establish an operational framework that guides the planning team.
    • Reduce inventory and improve service.

      Get the Product Sheet