| Results Case Studies

Forecasting + Inventory Optimization: JCI Parts


Johnson Controls Parts NA business unit was experiencing a combination of increased inventory and backlog. They had too much of the wrong inventory and not enough of the right inventory. This problem became exacerbated during the pandemic as a result of the supply chain shortages and increased and highly variable lead times. They were utilizing an excel based forecasting model to manage their inventory decisions.


  • In the assessment of their processes, we identified the limitations of their forecasting and inventory model:
    • Lack of seasonality component
    • Inability to handle variable lead times
    • Limited historical data
    • Challenges with pandemic disruption to forecast
  • Developed a forecast using optimization to minimize forecast error across all 50,000 SKUs
  • With forecast, target customer service levels, and lead times, we calculated the target reorder point (ROP) and reorder quantity (ROQ) by SKU
  • Due to capital limitations on inventory investment, we developed an inventory rebalancing process to support the reduction of the slow-moving inventory and allow for the purchasing of more fast-selling inventory


  • Variability in lead time and demand, as a result of the pandemic, was challenging when calculating reasonable ROPs and ROQs
  • Financial limitations on inventory investment, delayed the company’s ability to get to a strong inventory position. A significant amount of work was required to sell down obsolete inventory to make
  • room (physically and financially) for the new inventory


  • Improved forecast accuracy
  • Streamlined processes for procurement team as purchase recommendations from new forecast were more aligned with buyers’ expectations.
  • Improved ability to service customers with in-stock product