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.

[img]
Preview
PDF
620Kb

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.

Item Type:Conference or Workshop Item (Paper)
Uncontrolled Keywords:manufacturing system; product design; spreadsheet model; utilization
Subjects:T Technology > TS Manufactures > TS1-154 Manufactures
ID Code:1917
Deposited By:Khairunnisa Ahmad
Deposited On:04 Oct 2011 16:21
Last Modified:04 Oct 2011 16:21

Repository Staff Only: item control page