chemical s&op
Decision Support System for Sales & Operations Planning in the Chemical Process Industry

An optimization-based application was developed to automate the sales & operations planning (S&OP) process of a polymer manufacturer with multiple sites supplying global markets. The application generates a global plan that takes into account local manufacturing and supply constraints. Decisions on plant closures/expansions, production, warehousing, and distribution of intermediates and products are now based on a rigorous supply chain model. Savings on the order of US $4 Million/yr are being seen as a result of deploying these models. Cycle time for plan creation has gone down from several weeks to a few hours allowing management personnel to focus on analysis instead of plan creation.

       pdf        


business description & background

A polymer business with global manufacturing assets, and serving customers globally, is interested in streamlining and automating their sales and operations planning (S&OP) process. The following business aspects are relevant to this project:

  • Multiple and global locations of manufacturing and distribution facilities
  • Large number of products
  • Volatile demand
  • High sensitivity to cost (both operating and capital)
  • An environment that swings quickly between over-capacity & sold-out situations

The existing S&OP plan creation process is carried out individually by each product line and manufacturing site using homegrown spreadsheets and rules of thumb. The current S&OP model does not depict the complexities of the business realistically, and so is unable to generate a globally optimal plan. The high dimensionality of the problem arising from the number of products, plants, and destinations involved make it impossible to manually create a financially optimal and executable plan. In the current process, the planners spend a majority of their time in plan creation and thus have very little time to do business scenario analysis and take strategic decisions.

the challenge

Applied Optimization, was charged with the task of implementing a realistic S&OP plan creation application that:

  • Generated cost-optimal and implement-able plans
  • Honored all business constraints
  • Provided easy over-ride capabilities
  • Provided a user-friendly interface
  • Fit in the business workflow of the overall S&OP process in the business
the solution

After analyzing the problem thoroughly, Applied Optimization determined that their Sales & Operations Planning application, which is based on a mixed integer linear programming model, would provide the most efficient means of generating optimal sales & operation plans. The application implemented by Applied Optimization was validated with the planners, and the results were verified for feasibility and optimality. A notable achievement was that, during this process, at a very early stage in the project, several new and highly beneficial business rules were discovered which had significant financial impact. These findings kept the project team engaged and supportive for the duration of the project. Applied Optimization also took an interactive approach to developing the user interface, resulting in rich features for the user.

the benefits

By installing Applied Optimization's sales & operations planning application, for the first time a method was available to the client to make rigorously optimal decisions intimately tied to the financial goals of the business. Among the benefits realized were:

  • Internal S&OP business process improved and institutionalized plan creation cycle time went from weeks to hours
  • Significant financial benefits were realized by making globally optimal production and distribution decisions
  • Planners were freed up from the drudgery of plan creation, and now focus on analysis of plan results and strategic decision-making
how applied optimization added value

The S&OP solution implemented by Applied Optimization won high marks for enabling easy creation of optimal sales & operations plans. The powerful features of the package enabled our clients to benefit to the tune of $ 4 million annually. Some specific features of particular value were:

  • Powerful GUI capabilities and ability to generate customized graphics and reports
  • Plan generation with the goal of attaining specific pre-determined objectives
  • The ability of the application to deal with different time granularities
  • Flexible menus, ability to easily change key inputs and objectives
  • Data inputs from all ODBC-capable legacy systems
  • Extensive analytical capabilities to generate what-if scenarios and simulate impact of various decisions
  • Ability to use high-powered solvers, ensuring that feasible and optimal plans are generated in minutes
about the client

Our client is a leading plastics manufacturer producing hundreds of different grades of plastic. Manufacturing facilities are spread over locations on three continents, raw materials are sourced globally and customers are dispersed throughout the world in many different industries.

       pdf        
copyright © 2008 applied optimization, llc.    info@applied-optimization.com