The Application of Spreadsheet Model Based on Queuing Network to Optimize Capacity Utilization in Product Development

Modeling of a manufacturing system enables one to identify the effects of key design parameters on the system performance and as a result make the correct decision. This paper proposes a manufacturing system modeling approach using computer spreadsheet software, in which a static capacity planning model and stochastic queuing model are integrated. The model was used to optimize the existing system utilization in relation to product design. The model incorporates a few parameters such as utilization, cycle time, throughput, and batch size. It is predicted that design changes initiated as a result of analysis using the model reduced subsequent manufacturing costs significantly and also can reduce the launch program by a few years, because confidence in the model justified the commissioning of full-scale manufacturing equipment when the product was still only at the concept stage.

[1]  Pyung-Hoi Koo,et al.  A spreadsheet model approach for integrating static capacity planning and stochastic queueing models , 1995 .

[2]  David D. Yao,et al.  A queueing network model for semiconductor manufacturing , 1996 .

[3]  John W. Fowler,et al.  Grand Challenges in Modeling and Simulation of Complex Manufacturing Systems , 2004, Simul..

[4]  Raid Al-Aomar.  Product-mix analysis with discrete event simulation , 2000, 2000 Winter Simulation Conference Proceedings (Cat. No.00CH37165).

[5]  Jeffrey W. Herrmann,et al.  Estimating manufacturing cycle time and throughput in flow shops with process drift and inspection , 2008 .

[6]  F. Bradley Armstrong,et al.  Simulation of a new product workcell , 1997, WSC '97.

[7]  Stuart Bermon,et al.  Capacity analysis of complex manufacturing facilities , 1995, Proceedings of 1995 34th IEEE Conference on Decision and Control.

[8]  Walid Abdul-Kader,et al.  Capacity improvement of an unreliable production line - an analytical approach , 2006, Comput. Oper. Res..

[9]  Yu-Feng Wei,et al.  Concurrent Design for Optimal Production Performance , 2002 .

[10]  Ben Atkinson,et al.  Queueing theory in manufacturing systems analysis and design , 1993 .

[11]  P. Soundar,et al.  Concurrent design of products for manufacturing system performance , 1994, Proceedings of 1994 IEEE International Engineering Management Conference - IEMC '94.

[12]  John A. Buzacott,et al.  Stochastic models of manufacturing systems , 1993 .

[13]  R. Cooper.  Third‐Generation New Product Processes , 1994 .

[14]  John R. English,et al.  Designing New Products , 1994 .

[15]  Jeffrey W. Herrmann,et al.  DESIGN FOR PRODUCTION: A TOOL FOR REDUCING MANUFACTURING CYCLE TIME , 2000 .

[16]  William L. Berry,et al.  Manufacturing Planning and Control Systems , 1984 .