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

Authors

  • Muhammad Marsudi
  • Dzuraidah Abdul Wahab
  • Che Hasan Che Haron

Keywords:

Manufacturing system, product design, spreadsheet model, utilization.

Abstract

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.

Downloads

Download data is not yet available.

Downloads

Issue

Section

Issue on Mechanical, Materials and Manufacturing Engineering

How to Cite

Marsudi, M., Abdul Wahab, D., & Che Haron, C. H. (2009). The Application of Spreadsheet Model Based on Queuing Network to Optimize Capacity Utilization in Product Development. International Journal of Integrated Engineering, 1(1). https://publisher.uthm.edu.my/ojs/index.php/ijie/article/view/75