Error
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering
  • Error loading Modules:Can't create/write to file '/var/lib/mysql/tmp/#sql_bd4_0.MYI' (Errcode: 30) SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND ( mm.menuid = 8 OR mm.menuid = 0 ) ORDER BY position, ordering

INFORMATION SYSTEMS AND LOGISTICS IN CIVIL ENGINEERING

Operational management system for warehouse logistics of metal trading companies

Vestnik MGSU 6/2014
  • Khayrullin Rustam Zinnatullovich - Moscow State University of Civil Engineering (MGSU) Doctor of Physical and Mathematical Sciences, senior scientific worker, Professor, Department of Higher Mathematics, Moscow State University of Civil Engineering (MGSU), 26 Yaroslavskoe shosse, Moscow, 129337, Russian Federation; This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Pages 172-178

Logistics is an effective tool in business management. Metal trading business is a part of metal promotion chain from producer to consumer. It's designed to serve as a link connecting the interests of steel producers and end users. We should account for the specifics warehousing trading. The specificity of warehouse metal trading consists primarily in the fact that the purchase is made in large lots, and the sale - in medium and small parties. Loading and unloading of cars and trucks is produced by overhead cranes. Some part of the purchased goods are shipped in relatively large lots without presales preparation. Another part of the goods undergoes presale preparation. Indoor and outdoor warehouses are used with the address storage system. In the process of prolonged storage the metal rusts. Some part of the goods is subjected to final completion (cutting, welding, coloration) in service centers and small factories, usually located at the warehouse. The quantity of simultaneously shipped cars, and the quantity of the loader workers brigade can reach few dozens. So it is necessary to control the loading workers, to coordinate and monitor the performance of loading and unloading operations, to make the daily analysis of their work, to evaluate the warehouse operations as a whole. There is a need to manage and control movement of cars and trucks on the warehouse territory to reduce storage and transport costs and improve customer service. ERP-systems and WMS-systems, which are widely used, do not cover fully the functions and processes of the warehouse trading, and do not effectively manage all logistics processes. In this paper the specialized software is proposed. The software is intended for operational logistics management in warehouse metal products trading. The basic functions and processes of metal warehouse trading are described. The effectiveness indices for logistics processes and key effective indicators of warehouse trading are proposed. The developed software permit taking into account the described above specifics of metal products warehouse trading. The software can be easily integrated with ERP-systems and WMS-systems. The software contains the module of consolidation, which allows evaluating and comparing the quality of the logistics operations in a group of companies. The software was implemented and effectively used in a large metal trading company, which has few dozens of warehouses. Some results of mathematical simulation are presented.

DOI: 10.22227/1997-0935.2014.6.172-178

References
  1. Sergeev V.I. Logistika v biznese [Logistics in Business]. Moscow, Infra-M Publ., 2007, 608 p.
  2. Shol' E.I. Informatsionnoe obespechenie logisticheskikh tekhnologiy [Information Support of Logistic Technologies]. RISK: resursy, informatsiya, snabzhenie, konkurentsiya [RISK: Resources, Information, Supply, Competition]. 2006, no. 1, pp. 12—18.
  3. Kaplan R., Norton D. The Balanced Scorecard: Translating Strategy into Action. Harvard Business Review Press, 1 edition, 1996, 336 p.
  4. Vetluzhskih I.S. Strategicheskaya karta, sistemnyy podkhod i KPI: Instrumenty dlya rukovoditeley [Strategic Map, System Approach and KPI. Tools for Managers]. Moscow, Alpina Business Books, Alpina Publishers, 2008, 208 p.
  5. Mashchenko V.E. Sistemnoe korporativnoe upravlenie [System Corporate Management]. Moscow, Sirin Publ., 2003, 251 p.
  6. Abdikeev N.M., Dan'ko T.P., Il'demenov S.V., Kiselev A.D. Reinzhiniring biznesprotsessov [Reengineering of Business Processes]. Moscow, Eksmo Publ., 2007, 592 p.
  7. Kharitonova N.A., Kharitonova E.N., Sarana E.Yu. K voprosu o formirovanii kompleksnoy sistemy sbytovogo logisticheskogo kontrollinga na promyshlennom predpriyatii [On the Question of a Complex System Formation for Logistics Controlling Distribution of Industrial Company]. Nauchno-tekhnicheskie vedomosti SPbGPU: Ekonomicheskie nauki [Scientific and Technical News of St.Petersburg State Polytechnical University]. 2009, no. 1, pp. 190—194.
  8. Oleynik P.P. Osnovnye standarty korporativnykh informatsionnykh sistem: MPS, MRP, MRP-II, ERP, CSRP, ERP-II [Basic Standards of Corporate Information Systems: MPS, MRP, MRP-II, ERP, CSRP, ERP-II ]. Moscow, LAMBERT Publ., 2011, 88 p.
  9. O'Leary D. ERP-sistemy: vybor, vnedrenie, ekspluataciya. Sovremennoe planirovanie i upravlenie resursami predpriyatiya [ERP-systems: Selection, Implementation, Operation. Modern Enterprise Resource Planning]. Moscow, Vershina Publ., 2004, 272 p.
  10. Gayfulin B.N., Obukhov I.A. Avtomatizirovannye sistemy upravleniya predpriyatiyami standarta ERP/MRP-II [Automated Enterprise Management Systems of the Standard ERP / MRP-II]. Moscow, Bogorodskiy pechatnik, 2001, 104 p.
  11. Pаyterkin S.V., Oladov N.A., Isaev D.V. Tochno vovremja dlja Rossii. Praktika primenenija ERP-sistem [Just in time for Russia. Practice of application of ERP-systems]. Moscow, Alpina publisher, 2003, 368 p.
  12. Trapulenis R. Struktura i osobennosti sistemy SOLVO.WMS [Structure and Features of the System SOLVO.WMS]. Korporativnye sistemy [Corporate Systems]. 2006, no. 6, pp. 55—58.
  13. Trapulenis R. Sistema SOLVO.WMS [SOLVO.WMS System]. Uslugi i tseny [Prices and services]. 2008, no. 18, pp. 40—42.
  14. Filipenko I.A. Vybor PO dlya avtomatizatsii upravleniya [Choosing Software for Management Automation]. Korporativnye sistemy [Corporate Systems]. 2001, no. 3, pp. 21—22 .
  15. Khayrullin R.Z. Tekhnologiya issledovaniya upravlyaemykh sistem [Research Technology for Controlled Systems]. Gornyy informatsionno-analiticheskiy byulleten' [Mining Information and Analytical Bulletin]. 1999, no. 4, pp. 111—113.

Download

Results 1 - 1 of 1