El Blog de Smart
Siguiendo las mejores prácticas en la planificación de la demanda,
previsión y optimización de inventario
Most demand forecasts are partial or incomplete: They provide only one single number: the most likely value of future demand. This is called a point forecast. Usually, the point forecast estimates the average value of future demand.
Much more useful is a forecast of full probability distribution of demand at any future time. This is more commonly referred to as probability forecasting and is much more useful.
The Average is Not the Answer
The one advantage of a point forecast is its simplicity. If your ERP system is also simple, the point forecast fills in the one number needed by the ERP system to do workforce scheduling or raw material purchases.
The disadvantage of a point forecast is that it is too simple. It ignores additional information in an item’s demand history that can give you a more complete picture of how demand might unfold: a probability forecast.
Going Beyond the Average: Probability Forecasting
While the point forecast provides limited information, e.g., “The most likely demand next month is 15 units”, the probability forecast adds crucial information, e.g., “There is a 20% chance that demand will exceed 28 units and a 10% chance that it will be less than 5 units”.
This information lets you do risk assessment and contingency planning. Contingency planning is necessary because the point forecast usually has only a small chance of actually being correct. A probability forecast may also say “The chance of demand being 15 units is only 10%, even though it is the single most likely value.” In other words, there is a 90% chance that the point forecast is wrong. This kind of error is not a mistake in the forecasting calculations: it is the reality of dealing with demand volatility. It might better be called an “uncertainty” than an “error”.
An operations manager can use the extra information in a probability forecast in both informal and formal ways. Informally, even if an ERP system requires a single-number forecast as input, a wise manager will want to have some clue about the risks associated with that point forecast, i.e., its margin of error. So a forecast of 15 ± 1 unit is a lot safer than a forecast of 15 ± 10. The ± part is a compression of a probabilistic forecast. Figure 1 below shows an item’s demand history (red line), point forecasts for the next 12 months (green line) and their margins of error (cyan lines). The lowest forecast of about 3,300 units occurs in June, but the actual demand might be as much as 800 units higher or lower.
Bonus: Application to Inventory Management
Inventory management requires that you balance item availability against the inventory cost. It turns out that knowing the full probability distribution of demand over a replenishment lead time is essential for setting reorder points (also called mins) on a rational, scientific basis. Figure 2 shows a probability forecast of total demand during the 33 week replenishment lead time for a certain spare part. While the average lead time demand is 3 units, the most likely demand is zero, and a reorder point of 14 is needed to insure that the chance of stocking out is only 1%. Once again, the average is not the answer.
Knowing more is always better than knowing less and the probability forecast provides that extra bit of crucial information. Software has been able to supply a point forecast for over 40 years, but modern software can do better and provide the whole picture.
Figure 1: The red line shows the demand history of a finished good. The green line shows the point forecasts for the next 12 months. The blue lines indicate the margins of error in the 12 point forecasts.
Figure 2: A probabilistic forecast of demand for a spare part over a 33 week replenishment lead time. The most likely demand is zero, the average demand is 3, but a reorder point of 14 units is required to have only a 1% chance of stock out.
El director de ventas de canal y el ingeniero de soluciones empresariales de Smart Software presentarán tres sesiones en el evento Microsoft Dynamics Community Summit North America de este año en Orlando, FL.
Smart Software dirigirá un seminario web de 30 minutos como parte del Programa de socios de soluciones WERC. La presentación se centrará en cómo una compañía eléctrica líder implementó la planificación y optimización de inventario inteligente (Smart IP&O) como parte de la iniciativa de optimización estratégica de la cadena de suministro (SCO) de la empresa.
Una llamada a las filas puede ayudar a contrarrestar de forma proactiva el ruido de la cadena de suministro
Usted conoce la situación: normalmente encuentra la mejor manera de administrar cada artículo del inventario calculando los puntos de pedido adecuados y los objetivos de reposición, pero luego aumenta o disminuye la demanda promedio, o cambia la volatilidad de la demanda, o cambian los tiempos de entrega de los proveedores, o cambian sus propios costos .