Market Basket And Time Series Analysis: Case Study PT XYZ Sales Data

PT. XYZ is a retail company that has been operating since 2015 in New York, which seeks to increase sales through attractive package bidding strategies and ensuring stock availability for the following month's highest-selling items. The project aims to analyze and forecast the items that will have the highest sales as well as provide package recommendations that can increase sales. The analysis was carried out using a machine learning model, with the Market Basket Analysis (MBA) method for package recommendations and the Auto Regressive Integrated Moving Average (ARIMA) for sales predictions. The results of the analysis show that the "USB-C Charging Cable" and "Bose SoundSport Headphones" have a strong association with the "Vareebadd Phone", which indicates the potential for increased sales if offered together. In addition, ARIMA's predictions suggest that the MacBook Pro Laptop will generate the highest revenue, with an average projection of around $788,067.45. Based on these findings, we recommend PT. XYZ is preparing a package offering for the Vareebadd Phone with USB-C Charging Cable and Bose SoundSport Headphones, as well as preparing stock for the MacBook Pro Laptop, to meet market demand and maximize revenue potential.

Authors

Institutions

Publication Details

Journal
Cerdika Jurnal Ilmiah Indonesia
Published
2025-02-22
DOI
https://doi.org/10.59141/cerdika.v5i2.2496
Primary Topic
Management and Optimization Techniques
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Market Basket And Time Series Analysis: Case Study PT XYZ Sales Data

Riyanto Jayadi, Muhammad Wildan, Moh Thaha Rizieq Hentihu
Cerdika Jurnal Ilmiah Indonesia
Management and Optimization Techniques
article

Market Basket And Time Series Analysis: Case Study PT XYZ Sales Data

Riyanto Jayadi, Muhammad Wildan, Moh Thaha Rizieq Hentihu
article en

Abstract

PT. XYZ is a retail company that has been operating since 2015 in New York, which seeks to increase sales through attractive package bidding strategies and ensuring stock availability for the following month's highest-selling items. The project aims to analyze and forecast the items that will have the highest sales as well as provide package recommendations that can increase sales. The analysis was carried out using a machine learning model, with the Market Basket Analysis (MBA) method for package recommendations and the Auto Regressive Integrated Moving Average (ARIMA) for sales predictions. The results of the analysis show that the "USB-C Charging Cable" and "Bose SoundSport Headphones" have a strong association with the "Vareebadd Phone", which indicates the potential for increased sales if offered together. In addition, ARIMA's predictions suggest that the MacBook Pro Laptop will generate the highest revenue, with an average projection of around $788,067.45. Based on these findings, we recommend PT. XYZ is preparing a package offering for the Vareebadd Phone with USB-C Charging Cable and Bose SoundSport Headphones, as well as preparing stock for the MacBook Pro Laptop, to meet market demand and maximize revenue potential.

Cerdika Jurnal Ilmiah IndonesiaVol. 5(2)
Binus University (ID)
Openalex Percentile: Top 66%
Management and Optimization Techniques
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.