Minimalisasi Pengembalian Produk Pada Perusahaan Rokok

Abstract

Companies always strive to manage their operations efficiently to ensure
business continuity. One area identified as inefficient by a tobacco company was the return rate of unsellable or expired products. In 2023, the return rate was 83% higher than the company's target. Therefore, this study aims to reduce the return rate of tobacco products. In this research, the researcher uses a fishbone diagram as the method which is also supported by depletion week calculations. The application of the fishbone diagram analysis produced four proposals; which are depletion plan alerts, stock transfer recommendations between warehouses and markets, and the creation of a notification system using VBA macros in Microsoft Excel, which have been implemented by the company. The implementation of these proposals resulted in a reduction of old excise stock before massive withdrawals and successfully transferred at least 31.25
units of tobacco products. The notification system successfully helped the sales team manage stock levels, check store inventories, and guide store owners to sell products. As a result, product returns decreased by 60% compared to the previous year and were 50% lower than the maximum return target for 2024.