Development of a computerized tool for production scheduling and resource planning

• Main Author: Dev, Yadav
• Other Authors: Rajesh Piplani
• Format: Final Year Project
• Language: English
• Published: Nanyang Technological University 2022
• Subjects: Engineering::Mechanical engineering
• Online Access: https://hdl.handle.net/10356/159068
• Institution: Nanyang Technological University

Many companies nowadays rely on ERP (Enterprise Resource Planning) systems, which allows them to centralize many business functions such as Human Resources, Accounting , Production and Inventory into a single software. This allows for seamless sharing of information within a company. Embedded within the ERP System lies the Manufacturing Planning Control (MPC) system that is not usually available as a standalone system. MPC is a system which helps companies with planning and managing materials/components, people as wells as equipment in response to customer needs and demands. ERP systems are very expensive and, hence many SMEs (Small to Medium Enterprises) and even students looking to learn are not able to purchase them and take advantage of the embedded MPC system. Even though there are standalone Excel based solutions available, they lack the integrating capabilities and seamlessness of the embedded MPC systems. Thus the proposed solution in this report is a Python based MPC System, that Integrates Demand Forecasting & Management, Master Production Scheduling, and Materials Resource Planning into an effective standalone System. The System is developed around a real company (Zurn Wilkins) and its products as well as tested with raw data available on their website.