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