Participant of the conference - Rizvanova Albina.
Place of employment — OOO «TMK CHERMET».
Department of ensuring of steel manufacturing.
Purchase planning office.
Automation of processes of price formation and trade management in commercial organization to enhance the efficiency of purchasing activity.
Enhancing the efficiency of purchasing activity is a guideline for development of TMK CHERMET.
Three areas of improvement:
1)Automation of the price formation process (compiling in «1C-Trade Management» price lists, plans of metal scrap delivery, specifications)
2)Creating the common database, containing a complete picture of actually made shipment (adding the section «Goods in transit» to system «1C-Trade Management»)
3)Accounts payable management — the way to increase the effectiveness of commercial activity. 1.
Automation of the price formation.
Price lists, delivery plans containing the quantity information, specifications. Excel files.
Formation in «1C-Trade Management», automation of generation.
Specification: 1) price component 2) quantity component. 1.
Creation of the price formation algorithm. 2.
List of purchase prices for buying ferrous metal scrap.
Approving by managers in «1C-TM». 3.
The bid from supplier, containing information about planned volumes, types of scrap and regions of delivery. 4.
Scrap metal delivery plan.
Approving by managers in «1C-TM»
Automatic creation of specifications.
Algorithm, price list, bid, delivery plan, specifications.
Approving by managers in «1C-TM»
Price report in «1C-TM» - dynamics of the change in the purchase price of scrap metal. 2.
Goods in transit
Downloading data from ETRAN — information about transport with status «in transit»
Downloading data from weigh station - information about transport with status «arrived at the factory».
Downloading portions of acceptance report - information about transport with status «accepted by the factory».
Report in «1C-TM», reflecting properties of the entire shipment, - Report about goods in transit. 3.
Accounts payable management.
Classification of suppliers.
Calculation of the maximum amount of accounts payable for the end of the analyzed period, rub:
AP = - Pa * T / Dn
Pa — purchase amount, rub
T — turnover, days
Dn - number of days in the analyzed period, days
Calculation of the recommended sum of payment, rub:
P = -(AP1 — Pa — AP)
where AP1 — amount of accounts payable for the beginning of the period, rub
Pa — purchase amount, rub
AP — amount of accounts payable for the end of the period, rub
Calculation of the maximum amount of accounts payable and comparison with the actual debt on 01.07.15.
Result: actual amount of accounts payable exceeded on 01.07.15 the level of calculated debt in 537,5 million rubles that directly influenced the implementation of plans for scopes of supply and the level of the purchase price.
The comparative analysis of the maximum amount of accounts payable calculataion on 01.07.15 at redistribution of shares of delivery according to the project of the development strategy of TMK CHERMET and DO with calculation of the actual structure of shipments.
Conclusion: when using the structure of shipments, corresponding to the project of the development strategy of TMK CHERMET and DO for 2015-2020 years, the purchase price of scrap metal (taking into account transportation costs) decreases by 103 roubles per ton, that leads to cost reduction of products made by factories of TMK group.
But the amount of financing has to be increased by 307 million roubles in comparison with the calculated amount of payments for the delivery, which was actually made.
Result of the offered actions.
Automation of the price formation process provides:
Labor cost reduction.
Creation of a multistage control system, eliminating errors in intermediate steps of document formation.
Arrangement of the common information space, enabling to make a flexible reporting system for adopting management decisions.
Adding the section «Goods in transit» to system «1C-Trade Management».
Most complete database.
Increasing the accuracy of forecasting and planning.
Accounts payable management.
Retaining of strategically important vendors and attracting new partners.
Supplying required quantity of metal scrap to consuming companies + cost reduction of products made by factories of TMK group.
Increasing of profits and competitiveness improvement of TMK group companies.
September 2015
Vote now! 