Study On The Inventory Management System Of Hudraulic Fittings For Engineering Machinery

With the rapid development of China’s economy, China’s construction machineryindustry has also ushered in a golden opportunity for rapid development. Hydraulicengineering construction machinery manufacturing pipe fittings which is the corecomponent of the one, must ensure adequate inventory supply, and the possibility ofestablishing a reasonable inventory management strategies directly affect the production ofeconomic efficiency of enterprises. In this paper, a Shandong hydraulic pipe productioncompany’s management information system development as the background for the currentstatus of the hydraulic housekeeper inventory management company, focused on thedemand for finished goods inventory analysis, process design, inventory forecasting,inventory management, four key aspects of research and analysis.First, based on Shandong hydraulic pipe fittings company research on the system drawup demand analysis report, the contents of the status report includes inventory managementcompany, highlighting the problems of analysis,, and so complete the inventorymanagement module functions design. Secondly, detailing the logical database design andstructural design of information systems, database design and analysis documents for preneeds draw out the inventory management data flow, so the completion of data entry,detailed data structure, data flow, the base table etc; logic design to establish aninformation system using C/S structure, explain the user level, the executive level, thethree logical relational database, presented a detailed network design. Inventory forecastingmainly includes two aspects: qualitative and quantitative analysis. Qualitative analysis alsoreflects the inventory analysis that is functional modules, the function module gives asimple algorithm analysis based on actual demand; quantitative analysis by comparing theexponential smoothing, linear regression method to predict the combination of threemethods, optimal selection of the combination method Act as the optimal method offorecasting for the company, and the algorithms and corporate management informationsystem combined with the application. Inventory forecasting, based on furthercomprehensive set according to ABC inventory classification of inventory warning limit to complete the inventory of early warning capabilities, combined with economic quantitiesEOQ method by analyzing the actual situation, quantitative order model initially selectedfor the enterprise inventory control model.Relying on the above analysis, applied Delphi7.0and SQL server2000preparationof inventory management information system software, combined with the actualproduction system,which helps to standardize the company’s existing managementsystem, improves inventory management efficiency, enhances economic efficiency toensure the company.