}

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.

Deja un comentario

Artículos Relacionados

Mensajes recientes

  • Epicor Prophet 21 with Forecasting Inventory PlanningExtend Epicor Prophet 21 with Smart IP&O’s Forecasting & Dynamic Reorder Point Planning
    Smart Inventory Planning & Optimization (Smart IP&O) can help with inventory ordering functionality in Epicor P21, reduce inventory, minimize stockouts and restore your organization’s trust by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning. […]
  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Mecánico barbudo maduro en uniforme examinando la máquina y reparándola en fábricaService Parts Planning: Planning for consumable parts vs. Repairable Parts
    When deciding on the right stocking parameters for spare and replacement parts, it is important to distinguish between consumable and repairable servoce parts. These differences are often overlooked by inventory planning software and can result in incorrect estimates of what to stock. Different approaches are required when planning for consumables vs. repairable service parts. […]
  • Cuatro errores comunes al planificar los objetivos de reposiciónCuatro errores comunes al planificar los objetivos de reposición
    ¿Con qué frecuencia recalibra sus políticas de almacenamiento? ¿Por qué? Aprenda a evitar errores clave al planificar objetivos de reabastecimiento mediante la automatización del proceso, la recalibración de piezas, el uso de métodos de previsión de objetivos y la revisión de excepciones. […]
  • Smart Software se complace en presentar nuestra serie de seminarios web, ofrecidos exclusivamente para usuarios de Epicor.Amplíe el pronóstico y la planificación mínima/máxima de Epicor Kinetic con Smart IP&O
    Epicor Kinetic puede administrar el reabastecimiento al sugerir qué ordenar y cuándo a través de políticas de inventario basadas en puntos de reorden. El problema es que el sistema ERP requiere que el usuario especifique manualmente estos puntos de pedido o use un enfoque rudimentario de "regla general" basado en promedios diarios. En este artículo, revisaremos la funcionalidad de pedido de inventario en Epicor Kinetic, explicaremos sus limitaciones y resumiremos cómo reducir el inventario y minimizar los desabastecimientos al proporcionar la sólida funcionalidad predictiva que falta en Epicor. […]

    Optimización de inventario para fabricantes, distribuidores y MRO

    • Pedidos generales Software inteligente Demanda y planificación de inventario HDÓrdenes generales
      Nuestros clientes son grandes maestros que siempre nos han ayudado a cerrar la brecha entre la teoría de los libros de texto y la aplicación práctica. Un excelente ejemplo sucedió hace más de veinte años, cuando nos presentaron el fenómeno de la demanda intermitente, que es común entre las piezas de repuesto pero poco común entre los productos terminados administrados por nuestros clientes originales que trabajan en ventas y marketing. Esta revelación pronto llevó a nuestra posición preeminente como proveedores de software para la gestión de inventarios de piezas de repuesto. Nuestra última parte de la educación se refiere a las "órdenes generales". […]
    • Mano colocando piezas para construir una flechaPronóstico Probabilístico para Demanda Intermitente
      La nueva tecnología de pronóstico se deriva del pronóstico probabilístico, un método estadístico que pronostica con precisión tanto la demanda promedio de productos por período como los requisitos de inventario del nivel de servicio al cliente. […]
    • Ingeniería bajo pedido en Kratos Space: hacer que la disponibilidad de piezas sea una ventaja estratégica
      El grupo Kratos Space dentro del innovador en tecnología de seguridad nacional Kratos Defense & Security Solutions, Inc., produce el software COTS y los productos de componentes para las comunicaciones espaciales: hacer de la disponibilidad de piezas una ventaja estratégica […]
    • figuras-de-madera-de-personas-y-un-iman-equipo-gestion-almacen inventarioGestión del inventario de artículos promocionados
      En una publicación anterior, analicé uno de los problemas más espinosos que a veces enfrentan los planificadores de demanda: trabajar con datos de demanda de productos caracterizados por lo que los estadísticos llaman asimetría, una situación que puede requerir costosas inversiones en inventario. Este tipo de datos problemáticos se encuentran en varios escenarios diferentes. En al menos uno, la combinación de demanda intermitente y promociones de ventas muy efectivas, el problema se presta a una solución efectiva. […]