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.
Smart Software 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
Service-Level-Driven Service Parts Planning for Microsoft Dynamics 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.
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.
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.
Smart Software is pleased to announce that it has been named a Microsoft Co-sell-ready partner as a leading demand planning and inventory optimization solutions provider.
Please join our webinar at Dynamics Communities, featuring Greg Hartunian, CEO of Smart Software, who will identify the main problems of inventory planning processes and show in a live Demo how to solve them.
Challenges: Addressing the Root Causes of Inventory Pain
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
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
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.
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.