Profit maximized network optimization at SAP system: A real-life implementation in cement industry


Esgin E., Ozay V., Ozkan G.

18th International Conference on Informatics in Control, Automation and Robotics, ICINCO 2021, Virtual, Online, 6 - 08 July 2021, pp.752-760 identifier identifier

  • Publication Type: Conference Paper / Full Text
  • Doi Number: 10.5220/0010618507520760
  • City: Virtual, Online
  • Page Numbers: pp.752-760
  • Keywords: Business Planning, Integer Programming, Network Optimization, Profit Maximization, SAP, Variance Analysis, What-if Scenario Evaluation, SUPPLY CHAIN

Abstract

© 2021 by SCITEPRESS - Science and Technology Publications, Lda. All rights reservedWhat if we told you that “you already have 27% of net profit trapped in your misleading business”? As common de facto state in production planning, subjective human judgments play a significant role on demand point:plant assignments at product replenishment and this is mostly driven by myopic transportation minimization paradigm, disregarding production and profitability determinants. In this paper, we propose an integer programming characterized Network Optimization solution to find global optimal assignments that maximize the profitability in terms of contribution margin or net profit by taking sales, transportation and production planning perspectives into account and concerning potential capacity constraints. According to the experimental results obtained at a real-life implementation in cement industry, Network Optimization solution increases contribution margin by an average value of 6.33% and net profit by 26.3%. Moreover, proposed solution architecture promises a seamless network optimization experience over a large canvas that wholistically integrates SAP system, optimization logic and Microsoft Power BI tiers. As a result, our clients can concentrate on more value adding operations such as variance analysis and what-if scenario evaluation rather than manual, time consuming and error-prone data preparation.