Claim Missing Document
Check
Articles

Found 3 Documents
Search
Journal : Serambi Engineering

Customer Segmentation Analysis with RFM Model (Recency, Frequency, Monetary) and K-Means Clustering: Case Study of Bottled Water Sales at PT XYZ Sitorus, Ema Rosary; Isna Nugraha
Jurnal Serambi Engineering Vol. 10 No. 2 (2025): April 2025
Publisher : Faculty of Engineering, Universitas Serambi Mekkah

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Customer segmentation is a crucial process in understanding consumer behavior patterns to support strategic decision making in marketing. The main challenge faced by companies is to accurately group customers based on transaction data. The purpose of this study is to find out and segment customers using the algorithm K-Means clustering based on RFM model (Recency, Frequency, Monetary) on Bottled Water sales transaction data at PT XYZ. The research method involves analysis of 111 customer data processed using software Orange Data Mining, with validation of results using Silhouette Score which is useful in determining the amount cluster ideal. This research produced four cluster customers, with Cluster 4 reflects customers with the highest level of loyalty, marked by a value Frequency And Monetary the dominant one, while Cluster 3 describes customers with low loyalty potential. The results of this study provide a scientific basis for the development of more focused and efficient data-based marketing strategies.
Identification of Hazards and Risks of Forklift Activities in Warehouse Areas Using the HIRARC Method in the Green Safety Concept Muhammad Ilham Adi Prayoga; Isna Nugraha
Jurnal Serambi Engineering Vol. 11 No. 1 (2026): Januari 2026
Publisher : Faculty of Engineering, Universitas Serambi Mekkah

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

In warehouse operations PT XYZ, forklift activities represent one of the main sources of hazards due to direct interaction between humans, machines, and the work environment. Common risks include collisions between forklifts and pedestrians, falling loads, vehicle overturning, and impacts with warehouse structures, which may lead to serious injuries and material damage. This study aims to identify hazards and assess the risk level of forklift activities in the PT XYZ warehouse area to reduce the risk of forklift operation and provide risk control through the Green Safety concept. This study uses the Hazard Identification, Risk Assessment, and Risk Control (HIRARC) method and designs a risk control strategy based on the Green Safety concept. The results indicate five main activities that have potential risks, with the highest risk found in forklift operations along pedestrian paths and storage areas, having a risk value of 16 (high category) and a potential for collisions and worker injuries. Risk control efforts were carried out by separating forklift and pedestrian pathways, installing green reflective markings, and implementing IoT-based technologies such as distance sensors, speed limiters, and CCTV monitoring. The Green safety approach was also applied through the use of natural lighting and transparent roofing to improve visibility and energy efficiency.
Optimizing Coil Raw Material Inventory for Pipe Manufacturing Using EOQ, Reorder Point and Safety Stock at PT. XYZ Kemal Darma Nazidan; Isna Nugraha
Jurnal Serambi Engineering Vol. 11 No. 1 (2026): Januari 2026
Publisher : Faculty of Engineering, Universitas Serambi Mekkah

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

Steel coil raw material inventory plays an important role in ensuring the smooth production process. PT XYZ faces inventory instability, both in the form of shortages and excess stock, which causes production constraints and increases storage costs. This study aims to determine the most accurate forecasting method, calculate the economic order quantity, determine the reorder point, and determine the amount of safety stock so that inventory control is more optimal each month. The methods used include forecasting with Economic Order Quantity to predict raw material needs and calculations. Reorder Point and Safety Stock to determine the order quantity, optimal inventory, and the minimum point of raw materials for restocking. Based on the analysis results, the pattern of steel coil usage shows a seasonal trend. The forecasting results using the Weighted Moving Average method provide the smallest error rate with an MSE value of 5,856,347.80 and a MAD of 2,175.80. Through the application of the EOQ method, the optimal order quantity is 3039 tons, a reorder point of 3162 tons, and a safety stock value of 4,572.447 tons. The conclusion obtained from this study is that the forecasting and EOQ methods are able to increase the efficiency of inventory control and minimize the risk of shortages of coil raw materials every month at PT XYZ.