Commenced in January 2007
Paper Count: 30184
Application of Spreadsheet and Queuing Network Model to Capacity Optimization in Product Development
Abstract:Modeling of a manufacturing system enables one to identify the effects of key design parameters on the system performance and as a result to make correct decision. This paper proposes a manufacturing system modeling approach using a spreadsheet model based on queuing network theory, in which a static capacity planning model and stochastic queuing model are integrated. The model was used to improve the existing system utilization in relation to product design. The model incorporates few parameters such as utilization, cycle time, throughput, and batch size. The study also showed that the validity of developed model is good enough to apply and the maximum value of relative error is 10%, far below the limit value 32%. Therefore, the model developed in this study is a valuable alternative model in evaluating a manufacturing system
Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1070809Procedia APA BibTeX Chicago EndNote Harvard JSON MLA RIS XML ISO 690 PDF Downloads 1453
 Fowler, John, W., and Rose, O., "Grand challenges in modeling and simulation of complex manufacturing system", Simulation, Vol. 80, No. 9, pp. 469-476, 2004
 Cooper, R.G., "Third - Generation new product process", Journal of Product Innovation Management, Vol. 11, No. 1, pp. 3-14, 1994
 Koo, P.H., Moodie, C.L., and Talavage, J.J., "A spreadsheet model approach for integrating static capacity planning and stochastic queuing models", International Journal of Production Research, Vol. 33, No. 5, pp. 1369-1385, 1995
 Law, A.M., and McComas, M.G., " Simulation of manufacturing system", Proceedings of the Winter Simulation Conference, pp.56-59,1998
 Taylor, D.G., English, J.R., and Graves, R.J., "Designing new products: Compatibility with existing product facilities and anticipated product mix", Integrated Manufacturing Systems, Vol. 5, No. (4/5), pp. 13-21,1994
 Bermon, S., Feigen, G., and Hood, S., "Capacity analysis of complex manufacturing facilities", Proceedings of 34th Conference on Decision & Control, New Orleans, December 1995.
 Soundar, P., Han, P.B., "Concurrent design of products for manufacturing system performance", Proceedings IEEE International Engineering Management Conference. Ohio, Dayton. 1994
 Shady, R., Spake, G., and Armstrong, B., "Simulation of a new product work cell", Proceedings of Winter Simulation Conference, USA. 1997
 Hopp, W.J., Mark, L.S., "Factory Physics", Irwin/McGraw Hill, Boston. 1996
 Vollmann, T.E., Berry, W.L., and Whybark, D.C., "Manufacturing planning and control systems", 4th edition., Irwin/McGraw-Hill, New York, 1997
 Aomar, R., "Product-mix analysis with discrete event simulation", Proceedings 2000 Winter Simulation Conference, USA. 2000.
 Walid Abdul Kader, "Capacity improvement of an unreliable production line - An analytical approach", Computer & Operations Research, No. 33, pp. 1695-1712, 2008
 Chincholkar, M.M., Burroughs, T., and Herrmann, J.W., "Estimating manufacturing cycle time and throughput in flow shops with process drift and inspection", Institutes of Systems Research and Department of Mechanical Engineering University of Maryland,2004
 Papadopoulos, H.T., Heavey, C., and Browne, J. "Queuing theory in manufacturing systems analysis and design ", Chapman and Hall, London, 1993
 Yu-Feng,W. and Thornton, A.C., "Concurrent design for optimal production performance", Paper DETC2002/DFM-34163 in CD-ROM Proceedings of 2002 ASME Design Engineering Technical Conference, Montreal, Canada. 2002.
 Herrmann, J.W., and Chincholkar, M., "Design for Production: A Tool for reducing manufacturing cycle Time", Paper DETC2000/DFM-14002 in CD-ROM Proceedings of DETC 2000, 2000 ASME Design Engineering Technical Conference. Baltimore, September, 2000