RSS
Логотип
Баннер в шапке 1
Баннер в шапке 2
Project

System for planning, collecting the fact and generating reports on the shipment of finished products to TMK Group of Companies

Customers: Pipe Metallurgical Company (TMK)

Moscow; Metallurgical industry

Product: SAP NetWeaver Business Warehouse (SAP BW/4HANA)
Second product: Qlik Sense

Project date: 2016/03  - 2017/01

SAP BW Corporate Reporting System


Implemented planning functionalityData [1]

  • Data entry forms with input acceleration and validation functions
  • Automate the tasks of processing entered plans for a number of reports
  • departmental volume distribution by quarter/month
  • filling segments
  • filling sales markets

Automated Volume Allocation

Distribution requirements

  • Volumes should be rounded to tens of tons
  • Volumes shall be distributed in the maximum proportion to the total annual quarterly/monthly volumes

Implementation of the task

  • Splitting a Problem into Multiple Linear Programming Problems
  • Implementation of distribution algorithms as planning functions
  • Implementation of Simplex as FM on ABAP

Organization of work before system development

Features of planning and accounting of shipment execution in MS Excel

  • 27 Excel files linked to each other, distributed in 8 folders, totaling up to 70 MB
  • in each Excel file 10-15 sheets
  • files are divided into files for information input and results output
  • individual files for plan/actual report output

Shortcomings

  • rigid row and column structure in files, adding a new row on average takes 1 working day
  • the addition of a new sales department during the year is not carried out due to too much work
  • preparing a new set of files for the new working year takes about three working weeks
  • labor-intensive process of allocating departmental volumes by quarter/month (about 3 days initial breakdown, about 2 days allocation adjustment)

Effects of system implementation

  • Improved user experience: complete elimination or significant reduction in the time required to perform certain activities
  • Increase system flexibility
  • Achieving Time Savings for Production Management Employees
  • Increase the availability of reports to a wide range of users

Notes

  1. from the presentation "System for planning, collecting fact and generating reports on the shipment of finished products by TMK Group" Alexander Shumkov, Head of the Corporate Reporting Development Department of DKIS PJSC "TMK," CNews FORUM 2017