OPTIMIZATION OF PRODUCTION PLANNING AND CONTROL USING MICROSOFT EXCEL SHEET SOFTWARE

Kamal Kumar

Abstract


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.


Keywords


KALTAN BLACK Machine, AMADA Machine, Cutting tool, Coolant, Energy.

Full Text:

PDF

References


Abumaizar R.J. and Svestka J.A. (1997), “Rescheduling job shops under random disruptions, International Journal of Production Research”, pp. 2065-2082.

Bauer, Bowden, Browne, Duggan and Lyons (1998), “Shop floor control systems” publisher- Chapman and Hall.

Bikfalvi P., Erdelyi F., Toth T. (2005), “Production Triangle Model in Production Planning and Control”.

Chase R.B., Aquilano N.J. and Jacobs F.R. (1999), “Production and Operation Management” , TMH, 8th edition.

Corke D. K. (1997), “Production Control in Engineering”, 4th edition.

Custbdio L., Sentieiro J., Bispo C. (1994), “Production Planning and Scheduling using a Fuzzy Decision System”, pp. 160-167.

Fylstra, Lasdon D. L., Watson J., Waren A. (1998), “Design and use of Microsoft Excel Solver”, pp. 29-55.

Goodwin, Cardillo J. and Bergmann E. (1996), “Implementing ERP in big way” APICS- The performance advantage.

Hasanjadeh A., Moghadardoust O., Fathi M., Khorshiddoost R. (2009), “Developing a Model for Integrating Process Planning and Production Planning and Control in Cellular Manufacturing”, pp. 179-183.

King J. R. (1975), “Production Planning and Control” Pergamom Press Oxford.

Korhonen H., Heikkila J., Tornwall J. (2001), “A Simulation Case Study of Production Planning and Control In Printed Wiring Board Manufacturing”, pp. 844-847.

Lee. C. Y., Liman S. D. (1993), “Capacitated Two Parallel Machines Scheduling to Minimize Sum of Job Completion Times”- Discrete Appl. Math, pp.211-222.

Monch L., Zimmermann J. (2009), “Providing Production Planning and Control Functionally by Web Services” 5th Annual Conference on Automation Science and Engineering, pp. 495-500.

Mula J., Poler R., Garcia-Sabater J. P., Lario F. C. (2006), “Models for Production Planning under uncertainty: A review” Int. J. Production Economics, pp. 271-285.

Pandya K. (1992), “Development of Rules for Production Planning and Control at Cell Level”, pp. 228-233.

Reinhart G., (2008), “Identification of implicit strategies in production control”, pp. 302-306.

Ridgwq K., Ho K. (1995), “A Production Planning and Control System on Cellular Manufacturing”, pp. 14-22.

Sanmarti E., Huercio A., Espuna A., Puigjaner L. (1996), “A Combined Scheduling/Reactive Scheduling Strategy to minimize the effect of Process Operations Uncertainty in Batch Plants”.

Schmidt M., Fronia P., Fisser F., Nyhuis P. (2007), “Decentralized Planning and Control for Assembly Areas driven by Gentelligent Parts”, pp. 1088-1092.

Subash Babu A (2001), “Workshop on production management” IIT Bombay.

Vollmann T. E., Whybark D.C. and Berry W. L. (2005) “Manufacturing Planning and Control System”, 5th Edition. Boston: McGrawHill.

Xue L., Zhu J., Yunlong(2001), “Research on Production Planning and Control System of Enterprises under Virtual Enterprises Environment”, pp. 67-72.


Refbacks

  • There are currently no refbacks.




Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright © 2021 INTERNATIONAL EDUCATION AND RESEARCH JOURNAL