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

  • Direct to the Brain of the Boss- Inventory AnalysisDirect to the Brain of the Boss – Inventory Analytics and Reporting
    In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies. […]
  • You need to team up with the algorithms for Inventory ManagementYou Need to Team up with the Algorithms
    This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software. […]
  • Rethinking forecast accuracy, A shift from accuracy to error metricsRethinking forecast accuracy: A shift from accuracy to error metrics
    Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information. […]
  • Using Key Performance Predictions to Plan Stocking Policies
    I can't imagine being an inventory planner in spare parts, distribution, or manufacturing and having to create safety stock levels, reorder points, and order suggestions without using key performance predictions of service levels, fill rates, and inventory costs. […]
  • Every forecasting model is good for what it is designed forEvery Forecasting Model is Good for What it is Designed for
    With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • 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. […]
    • 5 Steps to Improve the Financial Impact of Spare Parts Planning5 Steps to Improve the Financial Impact of Spare Parts Planning
      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. […]
    • Bottom Line strategies for Spare Parts Planning SoftwareBottom Line Strategies for Spare Parts Planning
      Managing spare parts presents numerous challenges, such as unexpected breakdowns, changing schedules, and inconsistent demand patterns. Traditional forecasting methods and manual approaches are ineffective in dealing with these complexities. To overcome these challenges, this blog outlines key strategies that prioritize service levels, utilize probabilistic methods to calculate reorder points, regularly adjust stocking policies, and implement a dedicated planning process to avoid excessive inventory. Explore these strategies to optimize spare parts inventory and improve operational efficiency. […]

    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