Fabric cutting processes directly affect material costs; however, in many small and medium-sized garment enterprises, cutting plan management remains manual and experience-based, leading to significant material waste. This study proposes a cutting plan optimization solution using Microsoft Excel integrated with Solver to improve fabric roll selection and fabric spreading efficiency. Data collected from 175 fabric rolls across 56 cutting tables over a three-month period show that the proposed approach reduces fabric remnants from 826.2 m to 299.21 m (a reduction of 63.8%), increases the number of fabric layers from 3,180 to 3,447 (an increase of 8.4%), and decreases residual fabric cost from VND 41.31 million to VND 14.96 million. The results demonstrate that a low-cost, easy-to-implement digital solution can effectively optimize material utilization, making it highly suitable for small and medium-sized enterprises while supporting resource efficiency and digital transformation in...
Fabric cutting processes directly affect material costs; however, in many small and medium-sized garment enterprises, cutting plan management remains manual and experience-based, leading to significant material waste. This study proposes a cutting plan optimization solution using Microsoft Excel integrated with Solver to improve fabric roll selection and fabric spreading efficiency. Data collected from 175 fabric rolls across 56 cutting tables over a three-month period show that the proposed approach reduces fabric remnants from 826.2 m to 299.21 m (a reduction of 63.8%), increases the number of fabric layers from 3,180 to 3,447 (an increase of 8.4%), and decreases residual fabric cost from VND 41.31 million to VND 14.96 million. The results demonstrate that a low-cost, easy-to-implement digital solution can effectively optimize material utilization, making it highly suitable for small and medium-sized enterprises while supporting resource efficiency and digital transformation in garment manufacturing.