The use of spreadsheet and queuing network model to optimize capacityutilization in product development

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Modeling of a manufacturing system enables one to identify the effects ofkey design parameters on the system performance and as a result make correctdecision. This paper proposes a manufacturing system modeling approach using aspreadsheet model based on queuing network theory, in which a static capacityplanning model and stochastic queuing model are integrated. The model was usedto improve the existing system utilization in relation to product design. Themodel incorporates a few parameters such as utilization, cycle time, throughput,and batch size. The study also showed that the validity of developed model isgood enough to apply and the maximum value of relative error is 10%, far belowthe limit value 32%.

Original languageEnglish
Title of host publication2009 International Conference on Computers and Industrial Engineering, CIE 2009
Pages1237-1242
Number of pages6
Publication statusPublished - 2009
Event2009 International Conference on Computers and Industrial Engineering, CIE 2009 - Troyes
Duration: 6 Jul 20099 Jul 2009

Other

Other2009 International Conference on Computers and Industrial Engineering, CIE 2009
CityTroyes
Period6/7/099/7/09

Fingerprint

Spreadsheets
Product development
Circuit theory
Stochastic models
Product design
Throughput

Keywords

  • Manufacturing system
  • Product design
  • Spreadsheet model
  • Utilization

ASJC Scopus subject areas

  • Control and Systems Engineering
  • Computer Science(all)
  • Electrical and Electronic Engineering
  • Industrial and Manufacturing Engineering
  • Safety, Risk, Reliability and Quality

Cite this

Marsudi, M., Abd. Wahab, D., & Che Haron, C. H. (2009). The use of spreadsheet and queuing network model to optimize capacityutilization in product development. In 2009 International Conference on Computers and Industrial Engineering, CIE 2009 (pp. 1237-1242). [5223936]

The use of spreadsheet and queuing network model to optimize capacityutilization in product development. / Marsudi, Muhammad; Abd. Wahab, Dzuraidah; Che Haron, Che Hassan.

2009 International Conference on Computers and Industrial Engineering, CIE 2009. 2009. p. 1237-1242 5223936.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Marsudi, M, Abd. Wahab, D & Che Haron, CH 2009, The use of spreadsheet and queuing network model to optimize capacityutilization in product development. in 2009 International Conference on Computers and Industrial Engineering, CIE 2009., 5223936, pp. 1237-1242, 2009 International Conference on Computers and Industrial Engineering, CIE 2009, Troyes, 6/7/09.
Marsudi M, Abd. Wahab D, Che Haron CH. The use of spreadsheet and queuing network model to optimize capacityutilization in product development. In 2009 International Conference on Computers and Industrial Engineering, CIE 2009. 2009. p. 1237-1242. 5223936
Marsudi, Muhammad ; Abd. Wahab, Dzuraidah ; Che Haron, Che Hassan. / The use of spreadsheet and queuing network model to optimize capacityutilization in product development. 2009 International Conference on Computers and Industrial Engineering, CIE 2009. 2009. pp. 1237-1242
@inproceedings{bfb86a58ba254006933249640c086b88,
title = "The use of spreadsheet and queuing network model to optimize capacityutilization in product development",
abstract = "Modeling of a manufacturing system enables one to identify the effects ofkey design parameters on the system performance and as a result make correctdecision. This paper proposes a manufacturing system modeling approach using aspreadsheet model based on queuing network theory, in which a static capacityplanning model and stochastic queuing model are integrated. The model was usedto improve the existing system utilization in relation to product design. Themodel incorporates a few parameters such as utilization, cycle time, throughput,and batch size. The study also showed that the validity of developed model isgood enough to apply and the maximum value of relative error is 10{\%}, far belowthe limit value 32{\%}.",
keywords = "Manufacturing system, Product design, Spreadsheet model, Utilization",
author = "Muhammad Marsudi and {Abd. Wahab}, Dzuraidah and {Che Haron}, {Che Hassan}",
year = "2009",
language = "English",
isbn = "9781424441365",
pages = "1237--1242",
booktitle = "2009 International Conference on Computers and Industrial Engineering, CIE 2009",

}

TY - GEN

T1 - The use of spreadsheet and queuing network model to optimize capacityutilization in product development

AU - Marsudi, Muhammad

AU - Abd. Wahab, Dzuraidah

AU - Che Haron, Che Hassan

PY - 2009

Y1 - 2009

N2 - Modeling of a manufacturing system enables one to identify the effects ofkey design parameters on the system performance and as a result make correctdecision. This paper proposes a manufacturing system modeling approach using aspreadsheet model based on queuing network theory, in which a static capacityplanning model and stochastic queuing model are integrated. The model was usedto improve the existing system utilization in relation to product design. Themodel incorporates a few parameters such as utilization, cycle time, throughput,and batch size. The study also showed that the validity of developed model isgood enough to apply and the maximum value of relative error is 10%, far belowthe limit value 32%.

AB - Modeling of a manufacturing system enables one to identify the effects ofkey design parameters on the system performance and as a result make correctdecision. This paper proposes a manufacturing system modeling approach using aspreadsheet model based on queuing network theory, in which a static capacityplanning model and stochastic queuing model are integrated. The model was usedto improve the existing system utilization in relation to product design. Themodel incorporates a few parameters such as utilization, cycle time, throughput,and batch size. The study also showed that the validity of developed model isgood enough to apply and the maximum value of relative error is 10%, far belowthe limit value 32%.

KW - Manufacturing system

KW - Product design

KW - Spreadsheet model

KW - Utilization

UR - http://www.scopus.com/inward/record.url?scp=77956130486&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=77956130486&partnerID=8YFLogxK

M3 - Conference contribution

SN - 9781424441365

SP - 1237

EP - 1242

BT - 2009 International Conference on Computers and Industrial Engineering, CIE 2009

ER -