PT Sukanda Djaya is one of the companies, which distributes various types of food and beverages. The company was founded in 1974 by W.T. Chen, and is now based in Bekasi, Indonesia. Until now, PT Sukanda Djaya has 17 distribution offices spread across Java, Sumatra, Bali, Kalimantan and Sulawesi.

PT Sukanda Djaya is a company that imports food and beverage products in the frozen, chilled and dry categories. The distribution is obtained from Japan, Italy, the United States, France, Australia, New Zealand and Norway which are then distributed throughout Indonesia with the products of its parent company, Diamond Cold Storage. There are various product categories, which are produced by PT Sukanda Djaya including frozen food and beverages, milk, snacks, food ingredients, and machine tools.

CUSTOMER CHALLENGE:

PT Sukanda Djaya is Indonesia’s largest refrigerated food and beverage distribution company. It plays a crucial role in the food service, retail, wholesale, QSR (quick-service restaurant), catering, and healthcare industries within Indonesia.

And as part of their digital transformation journey, they need a Demand Forecasting solution to be a way out of several challenges related to their business processes which still have a lot of manual processes, resulting in high error proneness, takes long time to get the results, and they also need to reduce supply chain cost (such as : over stock, out of stock, unable to meet customer demand), so they require an accuracy of the forecast.

METRODATA SOLUTION:

With internal collaboration between PT Mitra Integrasi Informatika, PT Metrodata Electronics Tbk., and AWS, our aim is to deliver the full spectrum of IT services and solutions and to help Sukanda to build the new Demand Forecast Solution with AI/ML based and include Dashboard/Data Visualization, as soon as possible since it’s very crucial for their overall Business operational.

Demand forecasting is a field of predictive analytics and, it is the process of estimating the forecast of customer demand by analyzing historical data. Organizations use demand forecasting methods to avoid inefficiencies caused by the misalignment of supply and demand across the business operations. With demand forecasting methods, companies can improve their decision making processes. AWS provides a lot of services that support customer’s requirement.

For demand forecast AWS Services will be used to build, train and testing Forecast Model. For this case, we use AWS Glue to do data ingestion process and transform data then stored the data to AWS S3, and for further process by AI/ML will be process using AWS Sagemaker then Data will be stored again in AWS S3.

RESULT AND BENEFITS:

By automating the forecasting process through machine learning, human errors such as missing or incorrect inputs are greatly minimized. The system automatically calculates all relevant data series, such as by branch, SKU, condition group, and month. This automation ensures accuracy by eliminating issues like missing or incorrect inputs. Machine learning also significantly improves forecast accuracy by analyzing historical patterns, seasonal and external trends, and promotional activities, leading to more complete and reliable predictions. Additionally, the time required to generate forecasts is drastically reduced from around 20 days to just 1-2 days, allowing for more frequent forecasting, whether daily, weekly, or monthly. This efficiency enables business users to shift their focus from the labor-intensive tasks of data collection and model creation to more strategic decision-making, leveraging the precise results produced by ML-based demand forecasting.

ABOUT METRODATA:

Currently PT Metrodata Electronics Tbk. is a proud Advance Consulting Partner of AWS in Indonesia with Partnership history since 2013. Many satisfied customers, across Retail, Manufacturing, FMCG, Logistic, Pharmacy, Insurance & Fintech. Equipped with Full Cycle Team: Product Specialist, Solution Architect, Technical Implementor, SME (subject matter experts) in apps, DBs, network, devops, big data and cloud operation/managed services.

PT Metrodata Electronics Tbk.  as the trusted IT partner, are committed to give the best services, as well as the best solution and support to our clients. We have a very long outstanding proven services with some of our major clients in various Industries like in Telecommunications, Oil and Gas company, Mining, Manufacturing, Financial services and Banks, and also Distributions.

Since October 2021 Metrodata has signed a strategic collaboration agreement (SCA) with Amazon Web Services (AWS) to provide innovative and comprehensive cloud solutions to organizations in Indonesia. As part of the collaboration, Metrodata will establish a Cloud Center of Excellence (CCOE) team, working with AWS professionals to provide unified and proven services to AWS users in Indonesia. These services will concentrate on workload migration/modernization, Windows on AWS, SAP on AWS, VMware Cloud on AWS, Database Migration, Data Analytics, and Cloud Managed Services/day 2 operations. This is the first SCA in Indonesia.