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

Muhammad Marsudi, Dzuraidah Abdul Wahab, Che Hasan Che Haron


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.


Manufacturing system; product design; spreadsheet model; utilization.

Full Text:


Copyright (c)

Copyright International Journal of Integrated Engineering (IJIE) 2013.

ISSN : 2229-838X

e-ISSN : 2600-7916

Creative Commons License
This OJS site and its metadata are licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.