CT Global was tasked with designing and implementing a demand driven planning and service parts optimization solution using SAS Demand and Supply Planning. The solution has three core analytical capabilities: Demand Planning and Forecasting; Inventory Optimization; and Order Generation and Order Management. The solution provided the ability to visualize global stock levels, rebalance inventory and optimize inventories for each item at each location.
The Solution Included:
Statistical forecasting using an automated method to select the best statistical model to generate the most accurate forecast with the following features: Provides multi-echelon forecasting for product families, SKUs and all location combinations. Provides flexible hierarchical capabilities, to view and create forecasts at any level of region, country, distribution center, SKU etc. Selects champion model from 64 possible models. Conducts seasonality and trend analysis, by location and region. Built-in models detect seasonal patterns by product/groups by location/groups. Accounts for substitutes, super cessions, replacements, phase in/out and lost sales. Allows users to create “what if” demand scenarios and update forecasts. Consensus planning using a collaborative method that integrates statistical baselines with business judgment and input to finalize the forecast. Service Parts inventory optimization module that provides fact based analytical answers to the following questions: What is the optimal inventory range by SKU by location to achieve a specific service level based on current inventory policies? Which items have crossed policy thresholds and therefore should be reordered to restock inventory? How much should be ordered and when, based on current inventory, demand, service levels, network, etc. Reports & key performance indicators for key users at most levels within the spare parts service organization.