PROFITABILITY BASED NETWORK OPTIMIZATION AT SAP SYSTEM: A CASE STUDY IN CEMENT INDUSTRY

Öz

In this paper, a Network Optimization solution is proposed to find the optimal demand point:plant assignments at product replenishment that maximize the profitability with respect to sales, transportation and production planning data and potential constraints. As stated in the case study, Network Optimization solution has increased contribution margin by an average value of 2.35% that resulted in relatively high return-on-investment. Proposed solution ensures a lean optimization experience over a wide solution architecture that covers SAP, optimization logic and Microsoft Power BI components. Additionally, organizations will 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 by the help of this solution.

Anahtar Kelimeler

• Business Planning
• Integer Programming
• Profitability Based Network Optimization
• SAP
• Variance Analysis
• What-if Scenario Evaluation

SAP SİSTEMİNDE KARLILIK TABANLI AĞ OPTİMİZASYONU: ÇİMENTO SEKTÖRÜNDE BİR DURUM ÇALIŞMASI

Öz

Bu makalede satış, nakliye ve üretim planlama verileri ve olası kısıtlar açısından karlılığı maksimize eden talep noktası:üretim yeri cinsinden optimum ürün ikmal tayinlerini bulmak için bir Ağ Optimizasyonu çözümü önerilmiştir. Durum çalışmasında belirtildiği gibi, Ağ Optimizasyonu çözümü katkı marjını ortalama %2.35 oranında artırarak görece yüksek yatırım getirisi sağlamıştır. Önerilen çözüm SAP, optimizasyon mantığı ve Microsoft Power BI bileşenlerini kapsayan geniş bir çözüm mimarisinde yalın bir optimizasyon deneyimi sunar. Ayrıca, işletmeler bu çözüm yardımıyla manuel, zaman alıcı ve hataya açık veri hazırlama operasyonları yerine varyans analizi ve varsayımsal senaryo değerlendirmesi gibi katma değerli işlere odaklanabileceklerdir.

Anahtar Kelimeler

• İş Planlaması
• Tamsayılı Programlama
• Karlılık Tabanlı Ağ Optimizasyonu
• SAP
• Varyans Analizi
• Varsayımsal Senaryo Değerlendirmesi

Kaynakça

1. Billal, M. M., Islam, M. M., Alam, M. S., ve Hossain, M. M. (2015). Optimal supply chain network opportunities: the case of Bangladesh. World Journal of Social Sciences, 5(3), 197-210.
2. Chukwuma, N. K., ve Chukwuma, E. (2015). Optimizing cement distribution in the Nigerian cement manufacturing industry: the case of cement distribution from selected firms to markets in Ebonyi state. International Journal of Research in Business Management, 3(2), 35-64.
3. Das, A., Adnan, T. M., Hassan, M. S., ve Rahman, K. M. (2017). Analysing logistics cost factors and developing cost optimization tools and techniques for a cement industry (Case study: Lafarge Surma Cement Ltd). International Research Journal of Engineering and Technology (IRJET), 4(04), 1504.
4. Dikos, G., ve Spyropoulou, S. (2013). Supply chain optimization and planning in Heracles General Cement Company. Interfaces, 43(4), 297-312. doi:10.1287/inte.2013.0689
5. Kostin, A., Macowski, D. H., Pietrobelli, J. M. T. A., Guillen-Gonsalbez, G., Jimenez, L., ve Ravagnani, M. A. S. S. (2018). Optimization-based approach for maximizing profitability of bioethanol supply chain in Brazil. Computers & Chemical Engineering, 115, 121-132. doi:10.1016/j.compchemeng.2018.04.001.
6. Oladejo, N. K., Abolarinwa, A., Salawu, S.O., ve Lukman, A. F. (2019). Optimization principle and its’application in optimizing landmark university bakery production using linear programming. International Journal of Civil Engineering and Technology (IJCIET), 10(2), 183-190.
7. Samani, H. M. V., ve Mottaghi, A. (2006). Optimization of water distribution networks using integer linear programming. Journal of Hydraulic Engineering, 132(5), 501-509. doi:10.1061/(ASCE)0733-9429(2006)132:5(501).
8. Sulistyo, D. E., Herryandie, A., ve Jonrinaldi (2019). Inventory and transportation model for decision making in cement industry (case study at pt semen padang). IOP Conference Series: Materials Science and Engineering, 505. doi:10.1088/1757-899X/505/1/012084.

9. Togo, D. F. (2005). Integrating operations management into cost systems: an accounting approach to linear programming. Journal of Business Case Studies (JBCS), 1(4), 27-32. doi:10.19030/jbcs.v1i4.4931.
10. Vidal, C. J., ve Goetschalckx, M. (2001). A global supply chain model with transfer pricing and transportation cost allocation. European Journal of Operational Research, 129(1), 134-158. doi:10.1016/S0377-2217(99)00431-2.
11. Vimal, K. E. K., Rajak, S., ve Kandasamy, J. (2019). Analysis of network design for a circular production system using multi-objective mixed integer linear programming model. Journal of Manufacturing Technology Management, 30(3), 628-646. doi:10.1108/JMTM-02-2018-0058.