UTHM Institutional Repository

Application of spreadsheet and queuing network model to capacity optimization in product development

Marsudi, Muhammad and Abdul Wahab, Dzuraidah and Che Haron, Che Hassan (2009) Application of spreadsheet and queuing network model to capacity optimization in product development. In: World Congress Science, Engineering and Technology, 28-30 October 2009, Venice Italy.


Download (635kB)


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.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: manufacturing system; product design; spreadsheet model; utilization
Subjects: T Technology > TS Manufactures > TS1-154 Manufactures
Depositing User: Khairunnisa Ahmad
Date Deposited: 04 Oct 2011 08:21
Last Modified: 04 Oct 2011 08:21
URI: http://eprints.uthm.edu.my/id/eprint/1917
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item


Downloads per month over past year