Machinery Manufacturing Enterprises, Inventory Forecasting System

Manufacturing is a long-established and traditional industry in our country, it is the pillar of the national economy. Especially, machinery manufacturing is the industry leadership which has always been to promote economic development. But, how to maintain a reasonable stock, and how to increase the utilization rate of capital is always a puzzle to enterprises.Machinery manufacturing enterprises are in the rising market demand stage, in order to pursue greater economic profits, they increase the Product output according to the'previous sales experience. At the same time, the inventory of raw materials, semi-finished products, components, parts, spare parts, etc are also corresponding increase, caused a lot of liquidity has been occupied by a variety of stocks. When the market demand mutation, the companies will face high financial risks. In addition, as a result of future product sales estimate is higher or lower than the actual product sales in production. Create the necessary of raw materials, products, components and spare parts inventory overgrown or out of stock, impact on the progress of production. How to maintain a reasonable stock, and how much inventory is appropriate for different forms of Stock, these are highlight problems in management and inventory control of machinery manufacturing enterprises. This shows that, making scientific and accurate forecasting for machinery manufacturing enterprises stock is necessary. This subject base on part of products'historical data in machinery manufacturing enterprises, forecasting product sales in a period or several of future. Use a forecast of future product sales, back reckon the holdings of raw materials inventory, components and parts inventory, spare parts inventory, etc. Thus make plans to purchasing, production and other activities. The purpose is to increase the utilization rate of capital, reduce the risk of stock investment, help enterprises organize a scientific and reasonable production.This article is based on a lifting equipment company in jiang su province to study. Overview the concept of inventory and classification, inventory control, forecasting, and other theories; Analysis the problems in inventory control, the reason of the inventory and the stock status; Point out one of the ways to solution the problem of inventory control is to establish business inventory forecasting system; Expounded the basic principles of forecast; Analysis the target and functional module of inventory forecasting system, according to a large number of literatures; Combine the characteristics of enterprises and modern electronic information technology, research and development the inventory forecasting system to machinery manufacturing enterprises; On this basis, the database concept design, the database logic design and the database physical design of inventory forecast system has been finished; Using the moving-average model and exponential smoothing model, using the moving-average method and exponential smoothing method, in the Microsoft Windows XP operating system and SQL Server database, using C# development tools of Visual Studio. NET 2003 integrated development environment to research and development inventory forecasting system of machinery manufacturing enterprises. And has achieved the system login, the data maintenance and management, forecast management, forecast results analyze,save and so on.