Simulation modeling of a garment production system using a spreadsheet to minimize production cost

A methodology of structuring a garment production simulation model using a spreadsheet is described to minimize the average daily production cost through the investigation of various man‐machine combinations. The capability and usability of an easily available modern spreadsheet Excel 7.0 to simulate a simple garment production system is accessed with an attempt to demonstrate the simulation model building in a user friendly environment rather than learning and using costly simulation programming languages or simulation software packages. Simulation has evaluated the resource utilization and measured the system performance and developed strategies for taking operational decisions in a logical and better way to minimize the garment production cost. It may also assist and benefit the garment production managers to plan, design and operate their systems in an efficient manner in a competitive environment.