The Application of Spreadsheet Model Based on Queuing Network to Optimize Capacity Utilization in Product Development
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
Downloads
How to Cite
Issue
Section
License
Open access licenses
Open Access is by licensing the content with a Creative Commons (CC) license.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.