The Smart Forecaster
Pursuing best practices in demand planning, forecasting and inventory optimization
The Min/Max inventory policy is one of three available in SIO. When the inventory level drops to or below the Min, a replenishment order is generated. The reorder quantity is the number of units needed to raise the stock up to the Max.
To make the right decision, you’ll need to know how demand forecasting supports inventory management, choice of which policy to use, and calculation of the inputs that drive these policies.The process of ordering replenishment stock is sufficiently expensive and cumbersome that you also want to minimize the number of purchase orders you must generate.
When setting a target service level, make sure to take into account factors like current service levels, replenishment lead times, cost constraints, the pain inflicted by shortages on you and your customers, and your competitive position.
Continuously update your inventory control parameters: reorder points, order quantities, safety stocks, mins, maxes, lead times. Beyond that, you should be updating your inventory strategies.
Once a customer is ready to implement software for demand planning and/or inventory optimization, they need to connect the analytics software to their corporate data stream.This provides information on item demand and supplier lead times, among other things. We extract the rest of the data from the ERP system itself, which provides metadata such as each item’s location, unit cost, and product group.
In this blog, we review 10 specific questions you can ask to uncover what’s really happening with the inventory planning and demand forecasting policy at your company. We detail the typical answers provided when a forecasting/inventory planning policy doesn’t really exist, explain how to interpret these answers, and offer some clear advice on what to do about it.
In the supply chain planning world, the most fundamental decision is how to balance item availability against the cost of maintaining that availability (service levels and fill rates). At one extreme, you can grossly overstock and never run out until you go broke and have to close up shop from sinking all your cash into inventory that doesn’t sell.
Physics at the quantum level is quite weird – not at all like what we experience in our usual macroscopic life. Among the oddities are “superposition”, “entanglement”, and “quantum foam.” Weird as these phenomena are, I cannot help seeing analogs in the supposedly different world of supply chain management.
An inventory professional who is responsible for 10,000 items has 10,000 things to stress over every day. Double that for someone responsible for 20,000 items. In the crush of business, routine decisions often take second place to fire-fighting: dealing with supplier hiccups, straightening out paperwork mistakes, recovering from that collision between a truck and the loading dock.
Consider what is meant by “demand management”, “demand planning”, and “forecasting”. These terms imply certain standard functionality for collaboration, statistical analysis, and reporting to support a professional demand planning process. However, in most ERP systems, “demand management” running MRP and reconciling demand and supply for the purpose of placing orders
The three types of supply chain analytics are “descriptive”, “predictive”, and “prescriptive.” Each plays a different role in helping you manage your inventory. Modern supply chain software lets you exploit all three helping you to reduce inventory costs, improve on time delivery and service levels, while running a more efficient supply chain.
We just need to feed our demand histories into our new statistical methods, and we can start planning more effectively. Not quite: it’s about the technology and the process. You are investing in a new business process to develop forecasts for driving business strategy and inventory planning decisions.
Testing software solutions via a series of empirical competition can be an attractive option. In the case of forecasting and demand planning, a traditional “hold out” test is a good way to assess monthly or weekly forecast accuracy, but it is minimally useful if you have a different objective: Optimizing inventory.
No, not that kind of regime change: Nothing here about cruise missiles and stealth bombers. And no, we’re not talking about the other kind of regime change that hits closer to home: Shuffling the C-Suite at your company. In this blog, we discuss the relevance of regime change on time series data used for demand planning and forecasting.
Generally, the supply chain field has lagged behind finance in terms of the use of statistical models. My university colleagues and I are chipping away at that, but we have a long way to go. Some supply chains are quite technically sophisticated, but many, perhaps more, are essentially managed as much by gut instinct as by the numbers. Is this avoidance of analytics safer than relying on models?