Last-time-buy (LTB) quantity optimization · D01 Product & Asset Lifecycle · SCRA

01What it isQué es

Last-time-buy (LTB) quantity optimization is the structured analytical process of determining the optimal purchase quantity for the final order of a product or component before it goes EOL — balancing the risk of stocking out (lost revenue, customer impact, brand damage) against the risk of overbuying (write-off, carrying cost, working capital). It is the analytical discipline that converts the LTB decision from gut feel to defensible economics.

La optimización de cantidad de last-time-buy (LTB) es el proceso analítico estructurado de determinar la cantidad óptima de compra para la orden final de un producto o componente antes de que vaya EOL — balanceando el riesgo de stockout (ingresos perdidos, impacto al cliente, daño a marca) contra el riesgo de sobrecomprar (write-off, costo de carrying, capital de trabajo). Es la disciplina analítica que convierte la decisión LTB de gut feel a economía defendible.

02Why it mattersPor qué importa

LTB decisions are made under high uncertainty (future demand for an EOL product is hard to forecast) and high stakes (the wrong quantity has structural cost in either direction). The typical approach: gut feel by the buyer with no structured analysis, producing either chronic stockouts that erode customer relationships or large write-offs that erode margins. The semiconductor and electronics industries have decades of operational experience here (Cattani & Souza, 2003 — "Inventory Rationing and Order Cycle Optimization for an Item Approaching End-of-Life," European Journal of Operational Research): structured LTB optimization using demand profile modeling, customer concentration analysis, and economic trade-off calculation produces 30-60% lower total LTB cost vs. unstructured decision-making.

Las decisiones LTB se toman bajo alta incertidumbre (la demanda futura para un producto EOL es difícil de pronosticar) y alta apuesta (la cantidad equivocada tiene costo estructural en cualquier dirección). El enfoque típico: gut feel del comprador sin análisis estructurado, produciendo o stockouts crónicos que erosionan relaciones con clientes o grandes write-offs que erosionan márgenes. (Cattani y Souza, 2003 — "Inventory Rationing and Order Cycle Optimization for an Item Approaching End-of-Life," European Journal of Operational Research): la optimización LTB estructurada usando modelado de perfil de demanda, análisis de concentración de clientes y cálculo de trade-off económico produce 30-60% menor costo total LTB.

03How it is doneCómo se hace

Build the demand decline forecast — what does demand look like over the next 24-60 months? Historical demand pattern, customer concentration, substitution availability, technology transition rate, regulatory or competitive drivers. The forecast is the foundation; without it, LTB is guesswork.

Quantify the economics — unit cost, holding cost rate, stockout cost (lost margin + customer impact), write-off cost. Each variable has its own structure. Stockout cost includes lost current revenue plus the value of preserving customer relationships. Write-off cost is the unit cost minus salvage value.

Run the newsvendor calculation — optimal quantity balances marginal stockout cost vs. marginal write-off cost. Classic operations research: optimal quantity at the percentile where stockout cost per unit equals write-off cost per unit, applied to the demand distribution. The math is straightforward; the inputs require analysis.

Sensitivity-test on demand assumptions — how robust is the LTB quantity? The LTB optimum is sensitive to demand assumptions. Sensitivity analysis surfaces whether the recommended quantity holds under reasonable variation in demand forecast.

Coordinate with customers — pre-commit quantities, allocate residual. Customer-specific commitments lock in demand certainty for that portion of the LTB; the rest is the speculative portion. The pre-commitment approach converts uncertainty to certainty for the committed portion and focuses optimization on the rest.

Execute and monitor consumption — adjust customer allocation rules as the EOL period progresses. Consumption rarely matches forecast exactly. Monitoring allows mid-course adjustments: tightening allocation if consumption is faster than expected, loosening if slower.

Worked example — illustrativeAn industrial component manufacturer faces EOL on a critical control module — annual demand $4.2M (declining 18%/year), supplier discontinuing in 9 months, 14 active OEM customers with 12-18 month product lifecycles depending on this module, switching cost to alternative module estimated 16-24 months per customer. Structured LTB analysis: (1) demand forecast modeling 36-month decline from $4.2M to ~$0.4M with 80%+ confidence; (2) economics: unit cost $340, holding rate 18%/year, stockout cost estimated $1,800/unit (lost margin + customer relationship damage), write-off cost $230 (net of salvage); (3) newsvendor calculation: optimal quantity at 88th percentile of demand distribution = ~9,200 units; (4) sensitivity: range 7,800-11,400 across reasonable demand scenarios; (5) customer pre-commitment: 5 of 14 customers committed to 4,800 units; (6) final LTB: 9,000 units (pre-committed 4,800 + speculative 4,200), executed with quarterly consumption monitoring. Outcome 24 months later: ~8,300 units consumed, ~700 units written off (vs. predicted 1,200), zero customer stockouts; comparable industry LTBs without structured analysis had reported 35-60% write-offs or critical stockouts.

Construye el forecast de declive de demanda — ¿cómo se ve la demanda los próximos 24-60 meses? Patrón histórico de demanda, concentración de clientes, disponibilidad de sustitución, tasa de transición tecnológica, drivers regulatorios o competitivos.

Cuantifica la economía — costo unitario, tasa de holding, costo de stockout (margen perdido + impacto al cliente), costo de write-off. Cada variable tiene su propia estructura. El costo de stockout incluye ingreso actual perdido más el valor de preservar relaciones.

Corre el cálculo de newsvendor — cantidad óptima balancea costo marginal de stockout vs. costo marginal de write-off. Operations research clásico: cantidad óptima en el percentil donde costo de stockout por unidad iguala costo de write-off por unidad.

Sensibiliza en asunciones de demanda — ¿qué tan robusta es la cantidad LTB? El óptimo LTB es sensible a asunciones. El análisis de sensibilidad expone si la cantidad recomendada se mantiene bajo variación razonable.

Coordina con clientes — pre-compromete cantidades, asigna residual. Compromisos específicos a cliente fijan certeza de demanda para esa porción del LTB; el resto es la porción especulativa.

Ejecuta y monitorea consumo — ajusta reglas de asignación a clientes a medida que el período EOL avanza. El consumo rara vez coincide exactamente con el forecast. El monitoreo permite ajustes a media-curso.

Ejemplo trabajado — ilustrativoUn fabricante de componentes industriales enfrenta EOL en un módulo de control crítico — demanda anual $4.2M (declinando 18%/año), proveedor descontinuando en 9 meses, 14 clientes OEM activos con ciclos de vida de producto 12-18 meses dependiendo de este módulo, costo de switching a módulo alternativo estimado 16-24 meses. Análisis LTB estructurado: (1) forecast de demanda modelando declive 36-meses de $4.2M a ~$0.4M; (2) economía: costo unitario $340, tasa holding 18%/año, costo stockout estimado $1,800/unidad, costo write-off $230; (3) cálculo newsvendor: cantidad óptima al percentil 88 = ~9,200 unidades; (4) sensibilidad: rango 7,800-11,400; (5) pre-compromiso de cliente: 5 de 14 clientes comprometidos a 4,800 unidades; (6) LTB final: 9,000 unidades, ejecutado con monitoreo trimestral. Resultado 24 meses después: ~8,300 unidades consumidas, ~700 escritas (vs. predichas 1,200), cero stockouts de cliente; LTBs comparables sin análisis estructurado habían reportado 35-60% write-offs o stockouts críticos.

04The concept in depthEl concepto a fondo

⚖️Newsvendor problem is the analytical structure›

LTB is structurally a newsvendor problem — single-period decision balancing overstock cost vs. understock cost against a demand distribution. The optimal quantity is at the critical fractile where marginal stockout cost equals marginal overstock cost. Established operations research.

📈Demand forecast is the dominant uncertainty›

The economics are deterministic once demand is known; the demand is what's uncertain. Structured forecasting (decline curves, customer concentration, technology substitution rate) compresses the uncertainty.

🤝Customer pre-commitment converts speculation to certainty›

Customers with strong dependency on the EOL product will often pre-commit quantities. The pre-commitment portion is deterministic; only the residual is speculative. Reduces the LTB risk substantially.

⚖️El problema newsvendor es la estructura analítica›

El LTB es estructuralmente un problema newsvendor — decisión single-period balanceando costo de overstock vs. understock contra una distribución de demanda. La cantidad óptima está en el fractil crítico donde costo marginal stockout iguala costo marginal overstock.

📈El forecast de demanda es la incertidumbre dominante›

La economía es determinística una vez que la demanda se conoce; la demanda es lo incierto. Forecasting estructurado (curvas de declive, concentración de clientes, tasa de sustitución tecnológica) comprime la incertidumbre.

🤝El pre-compromiso del cliente convierte especulación en certeza›

Los clientes con fuerte dependencia del producto EOL frecuentemente pre-comprometen cantidades. La porción pre-comprometida es determinística; solo el residual es especulativo.

05In practiceEn la práctica

📐Structured demand decline forecasting›

Demand forecast model specific to EOL products using decline curves, customer concentration, substitution availability. Reviewed by demand planning and sales.

🧮Documented LTB economics template›

Standardized economics: unit cost, holding rate, stockout cost (margin + relationship value), write-off cost (cost - salvage). Updated assumptions per LTB.

🤝Customer pre-commitment process for major LTBs›

Structured customer engagement for major LTBs: notification, opportunity to pre-commit, allocation rules. Locks in certainty for the committed portion.

📊Quarterly consumption monitoring vs. forecast›

Mid-course tracking allows allocation rule adjustments — tightening if consumption is fast, loosening if slow. Reduces both stockout and write-off risk.

📐Forecast estructurado de declive de demanda›

Modelo de forecast de demanda específico a productos EOL usando curvas de declive, concentración de clientes, disponibilidad de sustitución.

🧮Template documentado de economía LTB›

Economía estandarizada: costo unitario, tasa de holding, costo de stockout (margen + valor de relación), costo de write-off (costo - salvage).

🤝Proceso de pre-compromiso de cliente para LTBs mayores›

Engagement estructurado del cliente para LTBs mayores: notificación, oportunidad de pre-compromiso, reglas de asignación. Fija certeza para la porción comprometida.

📊Monitoreo trimestral de consumo vs. forecast›

Tracking a media-curso permite ajustes de regla de asignación. Reduce ambos riesgos de stockout y write-off.

06What you would useQué se usa

📌 Inventory optimization with EOL modules

🟦Blue Yonder Demand / Kinaxis / o9 (advanced planning)›

Advanced planning platforms with EOL modeling, demand decline forecasting, and LTB optimization workflows (Blue Yonder — vendor; Kinaxis — vendor; o9 — vendor).

🟩SAP IBP / Logility (integrated planning with EOL)›

Integrated business planning platforms with EOL product lifecycle support (SAP — vendor; Logility — vendor).

📌 Specialized EOL optimization

🟥PartsBase / SmartTurn (electronics LTB management)›

Specialized platforms for electronics component LTB and obsolescence management (PartsBase — vendor).

⬜Newsvendor calculation template + structured LTB review›

For most operations — newsvendor calculation template in Excel with documented economic assumptions, cross-functional review process for major LTBs.

📌 Optimización de inventario con módulos EOL

🟦Blue Yonder Demand / Kinaxis / o9 (planeación avanzada)›

Plataformas de planeación avanzada con modelado EOL, forecasting de declive y workflows de optimización LTB (Blue Yonder — vendor; Kinaxis — vendor; o9 — vendor).

🟩SAP IBP / Logility (planeación integrada con EOL)›

Plataformas de planeación de negocio integrada con soporte de ciclo de vida EOL (SAP — vendor; Logility — vendor).

📌 Optimización EOL especializada

🟥PartsBase / SmartTurn (gestión LTB de electrónica)›

Plataformas especializadas para LTB de componentes electrónicos y gestión de obsolescencia (PartsBase — vendor).

⬜Template de cálculo newsvendor + revisión estructurada de LTB›

Para la mayoría de operaciones — template Excel de newsvendor con asunciones documentadas, proceso cross-funcional de revisión.

The bottom lineEn corto

The LTB by gut feel is the LTB that costs orders of magnitude more than the LTB by analysis. Build the demand decline forecast, quantify the economics including stockout and write-off costs, run the newsvendor calculation, sensitivity-test the assumptions, coordinate with customers for pre-commitment, and monitor consumption with mid-course adjustment. Structured LTB optimization produces 30-60% lower total LTB cost than the buyer's intuition.

El LTB por gut feel es el LTB que cuesta órdenes de magnitud más que el LTB por análisis. Construye el forecast de declive, cuantifica la economía incluyendo costos de stockout y write-off, corre el cálculo de newsvendor, sensibiliza, coordina con clientes para pre-compromiso y monitorea consumo con ajuste a media-curso.

← PreviousAnteriorEOL trigger & timeline definitionDefinición de trigger y timeline de EOL NextSiguiente →Phase-out inventory managementGestión de inventario de phase-out

All D01 componentsTodos los componentes de D01 D01 artifactsArtifacts de D01 SCRA