OPTIMIZATION OF PRODUCTION PLANNING AND CONTROL USING MICROSOFT EXCEL SHEET SOFTWARE

Production Planning and Control (PPC) is essential for efficient and economical production. A PPC system plans for the orderly and systematic change of production capacity to meet peaks and valleys of the expected customer demand. Organizations willing to succeed in global competition have to integrate their internal and external processes. This specially includes planning and production control (PPC) processes. Optimized allocation of the production resources and quick response to demand change results in lower cost and improvement of production performance. Designing an efficient PPC system by implementing MS Excel PPC software is of the same importance. In the current work, firstly the latest production planning framework has been reviewed and modified. This framework has been customized to meet requirements and constraints of an industry by using developed PPC software. MS EXCEL spreadsheet has been used for production planning. As MS Office Excel is a widespread and used software system it has the advantage to be well known, thus making sense to use is as a tool for production planning. The application of mathematical model and logic has been considered for production system in an engineering industry.