| Enterprise resource planning system incorporates IT and advanced administration thought into one, provides enterprises with a platform gathering the entire bearing and systematization that the achievement making policy, planning, controlling and managing appraises for an integral whole. And the producing of master production scheduling is one of importance and dificultity within the enterprise resources planning, and is also one of the problems that produce the important and economic performance in the production. The master production scheduling is certain the production scheduling of each concrete product at each concrete time. And it's purpose is to carry on general control to carry out maximum profits under the condition that resources control and need control, namely to carry out lowest costs of total adjustment expenses and the stock expenses.By using the theory of Master Production Schedule (MPS) and Enterprise Resource Planning(ERP), the article analyzes the structure of MPS in medium-small sized enterprise. Studying on the prediction that one of the most important key technologies of MPS and establishing the combinination forecasting model and take an example of that. Also, the article introduces the scheduling plans, functional requirements and related technology of Master Production Schedule. Meanwhile, in the article I develop the Master production Schedule system based on ERP. In the process of design, the method of from-the-above-to-the-below analysis-structured form, the article introduces in detail about the Master Production Schedule (MPS) system of ERP system, which includes Master Production Schedule system analysis, system design, database design, process design and so on.Setting the Adaptive Server Anywhere database as platform, using PB as tool to develop Master Production Schedule system, which includes the basic data, basic business, enquiries, Master Production Schedule and control, data analysis and forecasting and statistics and so on, we achieve the desired functionality. Finally the thesis summarizes the characteristics and limitations of the system and the future outlook.With the assistance of the system, enterprises can management the Master Production Schedule more efficiently, elevate the degree of shared information, complete the control system, reduce the Master Production Schedule cost, shorten the looking plan period and improve the quality of Master Production Schedule.To summarize, the Master Production Schedule system could serve the development of enterprises more efficiently. |