| Variable | Data Type | Description | Example | |
|---|---|---|---|---|
| 0 | Month | Object | Nama bulan dari data penjualan | January |
| 1 | Year | int64 | Tahun dari data penjualan | 2017 |
| 2 | Total Orders | int64 | Jumlah total pesanan yang diterima | 73 |
| 3 | Gross Sales | float64 | Total penjualan kotor sebelum potongan | 8861.5 |
| 4 | Discounts | float64 | Jumlah diskon yang diberikan | -129.4 |
| 5 | Returns | float64 | Jumlah pengembalian produk | -448.45 |
| 6 | Net Sales | float64 | Total penjualan bersih setelah diskon dan retur | 8283.65 |
| 7 | Shipping | float64 | Biaya pengiriman yang dikenakan | 1088.3 |
| 8 | Total Sales | float64 | Total penjualan setelah pengiriman | 9371.95 |
Comprehensive Analysis of Annual Sales Performance: Examining Total Orders, Gross Sales, Discounts, Returns, Net Sales, Shipping Costs, and Total Sales from 2022 to 2024
Period 2022 - 2024
Data Source Kaggle
Author Dimas Aditya
I. Introduction
This report provides a comprehensive overview of monthly sales performance from January 2022 to December 2024. The data analyzed covers key metrics such as total orders, gross sales, discounts, returns, net sales, shipping costs, and total sales. These metrics offer valuable insights into the overall sales trends during the three-year period, enabling a thorough understanding of the company’s revenue flow and operational efficiency. The focus on various factors such as discounts, returns, and shipping costs provides a clear view of how these elements impact net sales and the total sales generated after operational costs.
In this analysis, total orders represent the number of transactions received in each month, while gross sales reflect the total revenue before any deductions, including discounts and returns. Discounts represent the price reductions offered to customers, and returns indicate the value of products that were returned, both of which directly affect the company’s net sales. Net sales are calculated after factoring in these deductions, showing the actual revenue generated. The shipping costs, which represent the delivery expenses, are then added to calculate the total sales, giving a complete picture of the company’s financial performance.
Additionally, this report highlights the importance of monitoring trends in customer behavior and market conditions over the three-year period. By analyzing fluctuations in discounts and returns, the company can assess the effectiveness of promotional strategies and product quality, respectively. Shipping costs also play a significant role in shaping profit margins, especially as logistics costs can vary due to external factors such as fuel prices and supply chain disruptions.Understanding these dynamics allows the company to optimize its pricing strategies, reduce operational inefficiencies, and ultimately improve profitability.Moreover, tracking customer feedback and return reasons provides insights into potential areas for product improvement, fostering a culture of continuous enhancement. By aligning product offerings with customer preferences, the company can not only reduce return rates but also build a stronger brand reputation.
Table Description
The table contains sales data with variables like Month and Year indicating the time of sales, along with quantitative variables such as Total Orders, Gross Sales, Discounts, and Returns that reflect sales performance. Net Sales represents net sales after discounts and returns, with shipping costs captured in Shipping, resulting in the final Total Sales. Temporal variables like Date, Years, and Quarter allow for time-based analysis, providing a comprehensive overview of the company’s sales activities.This structured data format facilitates in-depth analysis of sales trends and patterns, enabling the company to make informed decisions. By leveraging this information, management can identify key performance indicators (KPIs) and align their strategies to maximize revenue growth and enhance customer satisfaction.
Furthermore, the analysis of this sales data is crucial for understanding seasonal trends and consumer behavior over time. By examining fluctuations in Total Orders, Gross Sales, and Net Sales across different months and years, the company can identify peak sales periods and potential downturns. This insight enables the management team to optimize inventory levels, tailor marketing strategies, and enhance promotional efforts during high-demand seasons.
In addition to seasonal trends, analyzing the sales data can reveal valuable insights into customer preferences and purchasing patterns. By segmenting the data by demographic factors such as age, location, and purchasing frequency, the company can gain a clearer picture of its target market. This information is instrumental in developing personalized marketing campaigns that resonate with different consumer segments, thereby increasing customer loyalty and retention.
Furthermore, by continuously monitoring sales performance and customer feedback, the company can adapt its product offerings and pricing strategies to better meet consumer demands. Understanding the factors that drive sales during peak periods allows for more effective promotional planning and resource allocation. This proactive approach not only maximizes revenue during high-demand times but also strengthens the company’s position in a competitive market.
II. Overall Sales Metrics Analysis
Annual Orders Metrics In the year 2024, the total transaction figure from the year 2023 is at 1141. This value is higher than the previous year, which is 836 in the year 2022. In addition, growth is also reflected in the quantity, which is continuously increasing. Furthermore, in the last 3 years, the percentage growth rate has decreased from 36.48% to 33.22%.
The sales data for the years 2022 to 2024 reveals a positive trend in total transactions, with a significant increase from 836 in 2022 to 1141 in 2024. This upward trajectory highlights the company’s successful strategies in driving sales and meeting customer demand. Despite a decrease in the percentage growth rate from 36.48% to 33.22% over the last three years, the continuous increase in sales volume indicates a stable and growing business. Overall, these findings suggest that the company is well-positioned to capitalize on market opportunities while maintaining a strong sales performance.
Based on the plot below, it illustrates the growth from 2022 to 2024. The growth from 2022 to 2023 shows a increase of 18.24% or 836 transactions to 1141 transactions. For the year 2023 to 2024, it depicts a further increase of 34.85% or 1141 transactions to 1520 total transactions. By the end of the year 2024, the metrics for orders or transactions as a whole indicate consistent growth.
In summary, the sales data from 2022 to 2024 indicates a robust growth trajectory for the company. The total transactions increased significantly from 0.0% in 2022 to 18.24% in 2023, marking an impressive growth rate of 1141orders. This upward trend continued into 2024, where the total transactions rose to 1520 orders, reflecting a substantial increase of 34.85%. Such consistent growth in transaction volume highlights the effectiveness of the company’s sales strategies and its ability to attract and retain customers over this period.
Annual Gross Sales Metrics In recent years, the company has shown impressive performance with a significant upward sales trend. The data shows that gross sales have experienced consistent growth year-over-year, with the year 2024 being the most productive year to date. This growth is not only reflected in the sales figures but also in the increasing growth percentage, indicating that the company is on the right track to achieve its ambitious targets in the future.
The data analysis shows consistent year-on-year sales growth. In the year 2023, the company recorded a growth of 16.41% compared to the year 2022, and this growth significantly increased to 26.87% in the year 2024. This indicates an acceleration in sales growth, which is also reflected in the highest sales value achieved in the year 2024, followed by the years 2023 and 2022. The largest absolute growth occurred between the years 2023 and 2024, with an increase of 30449.0, showing that the company not only grew in percentage but also in real value.
The graph here shows the trend of average gross sales and its percentage growth from the year 2022 to 2024. There is a significant increase in the average gross sales year by year, with an average gross sales of 97342.05 in the year 2022, increasing to 113313.15 in the year 2023, and reaching its peak in the year 2024 with a value of 143762.15. Although the percentage growth tends to be stable, in the year 2023 the growth was recorded at 8.2%, while in the year 2024 it accelerated to 21.64% compared to the previous year. This reflects the company’s efforts to drive revenue growth.
In this overall analysis, the company has demonstrated impressive performance with a significant upward trend in sales year-over-year, especially in the year 2024, which has been the most productive year to date. The consistent growth in gross sales value, which growth from 97342.05 in the year 2022 to 143762.15 in the year 2024, along with the acceleration in percentage growth from 16.41 to 26.87, indicates that the strategies implemented have been effective and produced tangible results. With this positive momentum, the company is well-positioned to continue achieving its ambitious goals in the future, and it is crucial for management to continually evaluate and optimize existing strategies to maintain sustainable growth.
Annual Discount Metrics This chart shows the discount trends given by the company from the year 2022 to 2024. During this period, the company has implemented a highly aggressive discount strategy to boost sales and attract new customers. The significant increase in the total amount of discounts given each year reflects the company’s efforts to respond to market demand and compete more effectively in the industry.
The data shows that in the year 2022, the total discounts given were 1849.15 units, which drastically increased to 3112.39 units in the year 2023, and peaked in the year 2024 at 6252.24 units. The percentage growth in discounts also recorded a very high increase, rising by 68.31% in the year 2023 and surging to 100.88% in the year 2024. This trend not only shows an increase in the volume of discounts but also reflects that the company is striving to maximize the impact of its discount strategy.
The second chart displays the trend of average discounts and their percentage growth from the year 2022 to 2024. The average discount also experienced a significant increase, with growth recorded at 34.16% in the year 2023 and rising to 84.6% in the year 2024. This shows that not only has the number of discounts increased, but also the average value of the discounts given to customers. This rise indicates a rapid acceleration in discounting, which could be a sign of the company’s strategy to boost sales amid tight market competition.
Overall, this chart shows that the company has adopted a highly aggressive discount strategy in recent years, with a significant increase in both the number and average of discounts given. While this strategy has successfully boosted sales, the company needs to be cautious not to overly rely on discounts as the sole approach. It is important for the company to periodically evaluate the effectiveness of its discount strategy and consider diversifying its marketing strategies to ensure sustainable growth and maintain profit margins in the long term.
Annual Returns Metrics The return trends observed over the three years, namely 2022, 2023, and 2024, show significant development. In 2022, the return value was 3972.4 units, which growth to 5412.58 in 2023, and reached its peak in 2024 with a value of 7713.51. This increase indicates that the company’s investment performance has shown very strong results, with a consistent positive trend in absolute return values year-over-year.
The growth observed in the return trend is also reflected in the analysis of the Average Return and its Growth. Here, the return values not only increased in absolute terms, but also showed strong percentage growth year-over-year. In the year 2023, there was a increase of 36.25% compared to the previous year, and in the year 2024, the growth jumped to 42.51%. This indicates that the investments made were not only profitable but also rapidly growing, creating a sustained positive momentum.
In the analysis of the Average Return and its Growth, there is a similar trend with a significant growth in returns year-over-year. In the year 2023, the average return recorded a increase of 18.13%, jumping to 39.38% in the year 2024. These figures confirm that the investment strategy implemented during this period was very effective in delivering strong results. Moreover, this positive trend suggests potential for achieving even higher returns in the future, provided that the same strategy continues to be applied and optimized.
Overall, both the return trends and the analysis of Average Return and its Growth demonstrate very positive investment performance over the past three years. The significant growth, both in absolute value and percentage, indicates the effectiveness of the investment strategies implemented. However, it is important to remember that past performance does not guarantee future results. Therefore, further analysis is needed to understand the factors contributing to this success and to anticipate potential risks that may arise in the future. Diversification and periodic evaluation of investment strategies are crucial to maintaining sustainable performance.
Annual Net Sales Metrics The Annual Net Sales Metrics illustrate the trend of net sales from the year 2022 to 2024, with results showing very positive development. In the year 2022, the net sales value was recorded at 91520.5 units, which increase significantly to 104788.18 in the year 2023, and peaked in the year 2024 with a value of 129796.4. This increase reflects a very strong sales performance and a consistent positive trend in net sales value year after year.
The increase observed in the Annual Net Sales Metrics can also be seen in the analysis of Average Net Sales and its Growth. The same data indicates that there has been not only an increase in the absolute value of net sales but also a significant percentage growth. In the year 2023, growth reached 14.5% compared to the previous year, and fly to 23.87% in the year 2024. This indicates a significant acceleration in sales growth, demonstrating the effectiveness of the sales strategies implemented.
Analysis of Average Net Sales and Its Growth confirms the same trend as Annual Net Sales Metrics. Sales performance shows very good results, with significant year-on-year increases. The increase in average net sales indicates a consistent positive trend, suggesting that the potential for achieving higher sales in the future remains wide open. This success reflects the effectiveness of the sales strategies implemented and indicates that there is room for further growth.
Overall, both Annual Net Sales Metrics and the analysis of Average Net Sales and Its Growth show very positive sales performance over the past three years. Significant growth in absolute value and percentage reflects the effectiveness of the sales strategies implemented. However, it is important to remember that past success does not always guarantee future performance. Therefore, periodic evaluation of sales strategies and diversification of products or markets are necessary to anticipate challenges and maintain good performance sustainability in the future.
Annual Shipping Metrics The Annual Shipping Metrics indicate the trend of shipping and its percentage growth from the year 2022 to 2024. This data illustrates a very significant increase in the number of shipments each year. In the year 2022, the total shipments reached 11976.77 units, which then increase to 18780.1 in the year 2023, and finally peaked in the year 2024 with 26101.23 units. This substantial growth reflects the success of the shipping strategies implemented by the company.
The correlation between the Annual Shipping Metrics and the Average Shipments and its Growth shows that although there is a very significant increase in the number of shipments, the percentage growth in the Average Shipments and its Growth continues to show a positive trend. The average shipments also recorded encouraging figures, with total shipments increasing from 11976.77 units in the year 2022 to 18780.1 in the year 2023, and 26101.23 units in the year 2024. However, the percentage growth in shipments varies, indicating that although the shipment volume has increased, there are fluctuations in its growth rate.
The Average Shipments and its Growth show a positive and consistent trend during the analyzed period, although the growth rate varies. In the year 2023, there was an increase of 28.4% compared to the previous year, while in the year 2024, the growth increase to 28.4%. This indicates that although there is variation in annual growth, the overall trend remains positive, reflecting strong growth potential for the future.
Overall, the analysis of the Annual Shipping Metrics and the Average Shipments and its Growth indicates that the company has successfully increased shipment volume significantly over the past three years. The consistent increase in the number of shipments and positive growth reflects the effectiveness of the shipping strategies implemented. However, it is important to conduct regular evaluations and consider product diversification as well as capacity enhancement to anticipate challenges and ensure sustainable growth in the future.
Annual Total Sales Metrics The Annual Total Sales Metrics illustrate the trend of total sales and its percentage growth from the year 2022 to 2024. This data shows a significant increase in the total sales value each year. In the year 2022, total sales were recorded at 103497.27 units, which increased to 123568.28 units in the year 2023, and peaked in the year 2024 with a value of 155900.33 units. This increase reflects the effectiveness of the sales strategies implemented by the company.
The correlation between the Annual Total Sales Metrics and the Average Total Sales and its Growth shows that although there is a substantial increase in the total sales value, there are differences in the percentage growth between the two graphs. In the Average Total Sales and its Growth, total sales also show a significant upward trend, with the same figures: from 103497.27 units in the year 2022 to 123568.28 in the year 2023, and 155900.33 units in the year 2024. However, the percentage growth rate is more stable, indicating that although the sales volume has increased, fluctuations in annual growth are more pronounced.
The Average Total Sales and its Growth show a positive and consistent sales performance during the analysis period. Despite a significant increase, the percentage growth exhibits a more stable trend, with an increase of 9.7% in the year 2023 and 22.78% in the year 2024. This reflects that although the sales volume has increased, there is variation in its growth rate, indicating strong growth potential for the future.
Overall, the analysis of the Annual Total Sales Metrics and the Average Total Sales and its Growth indicates that the company has successfully increased its sales volume significantly over the past three years. The consistent increase in the total sales value, along with positive growth, indicates the effectiveness of the sales strategies implemented. However, it is important to continue conducting evaluations and consider product or market diversification to mitigate risks and maintain sustainable growth in the future.
III. Ratio Metrics
Annual Total Transaction Ratio Metrics The Total Orders Ratio per Year chart shows a significant upward trend year over year. In the year 2022, the total order ratio was recorded at 23.91%, marking the starting point of the observation. Then, in the year 2023, the ratio increase by 8.720000000000002%, reaching 32.63%, and peaked in the year 2024 with a significant increase of 10.839999999999996%, bringing the total order ratio to 43.47%. This consistent increase reflects very positive order performance and suggests that the marketing strategies implemented were effective in increasing the number of orders. Additionally, improved product or service quality and customer satisfaction may have contributed to the recorded growth.
Overall, this chart illustrates very positive order performance over the past three years, with the growth in total order ratio showing that the business strategies implemented were quite effective. However, it is important to remember that past performance does not always guarantee the same results in the future. Therefore, further analysis is needed to identify the factors contributing to this success and to anticipate potential challenges in the future.
Annual Total Gross Sales Ratio
The Gross Sales Ratio per Year chart shows a significant downward trend from the year 2022 to 2024. In 2022, the gross sales ratio peaked at 11643.79%, but experienced a sharp drop of 1712.75%% in 2023, falling to 9931.04%. This decline continued in 2024, with the ratio reaching 9458.04% after an additional decrease of 473.0%. This consistent downward trend indicates underlying issues in the business, such as declining market demand or increased competition, that need to be addressed promptly.
Overall, the chart highlights a concerning downward trend in the gross sales ratio, which could negatively impact the company’s financial health. To reverse this situation, the company must conduct a thorough evaluation of the sales strategies being implemented, as well as a deep analysis of the market and products offered. Timely and effective corrective actions are needed to identify the root causes of the decline and develop strategies to improve sales performance in the future.
Annual Total Discount Ratio
The Discount Ratio (%) per Year chart shows a significant upward trend in the discount ratio from the year 2022 to 2024. In 2022, the discount ratio recorded was 1.9%, which then increased to 2.75% in 2023, and peaked at 4.35% in 2024 after a significant increase of 1.5999999999999996%. This increase reflects the company’s aggressive discount strategy to attract more customers, as well as growing competition in the market.
Overall, this chart indicates that the company is increasingly relying on discount strategies to boost sales. While this approach can be effective in drawing customer attention, the company must be cautious of the potential negative impact on profit margins per unit. Therefore, it is important for the company to reassess the pricing and discount strategies being implemented, as well as conduct competitor analysis to ensure that these strategies do not jeopardize long-term financial health.
Annual Total Return Ratio
The Return Ratio (%) per Year chart shows a significant upward trend in the return ratio from the year 2022 to 2024. Starting with an initial return ratio of 4.34% in 2022, the chart reflects steady growth, increasing to 5.17% in 2023 and peaking at 5.94% in 2024. This positive performance reflects the effectiveness of the investment strategies implemented, as well as favorable market conditions and successful portfolio diversification.
Overall, this chart indicates that the company’s investment performance is on a very positive track, with consistent growth in the return ratio over the past three years. While this strong trend suggests optimism for potentially higher returns in the future, it is important to remember that past results do not always guarantee future performance. Therefore, further analysis is needed to identify the factors contributing to this success, as well as to anticipate potential risks that may arise in the future.
Annual Total Shipping Ratio
The Shipping Ratio (%) per Year chart shows a significant upward trend in the shipping ratio from the year 2022 to 2024. Starting with an initial shipping ratio of 13.09% in 2022, there was consistent growth in 2023 to 17.92%, peaking at 20.11% in 2024. This increase reflects very positive shipping performance, as well as improved operational efficiency in meeting market demand. It may also indicate strategic steps taken by the company to enhance production and distribution capacity.
Overall, this chart shows that the company has successfully increased the shipping ratio significantly over the past three years, reflecting strong performance and responsiveness to growing market demand. While these positive results create optimism for future growth, it is important to conduct further analysis to identify the underlying factors behind this success and to anticipate potential challenges that may arise with continued growth. This will help the company to keep adapting and maintaining efficient shipping performance in the future.
Annual Total Sales Ratio
The Total Sales Ratio (%) per Year chart shows a significant upward trend in the total sales ratio from the year 2022 to 2024. Starting with a total sales ratio of 113.09% in 2022, the ratio increased to 117.92% in 2023, peaking at 120.11% in 2024. This consistent increase reflects very positive sales performance and indicates that the sales strategies implemented during this period successfully boosted sales volume. This may also be attributed to improved product or service quality and higher customer satisfaction.
Overall, this chart shows that the company has achieved strong sales performance and has continued to grow over the past three years. While these results create optimism for future growth, it is important not to rely solely on past performance as the only indicator of future success. Therefore, further analysis is needed to evaluate the factors contributing to the sales increase and to anticipate potential challenges that could impact future performance. This will help in formulating more effective strategies to maintain and enhance the company’s sales position in the market.
Annual Total Net Sales Ratio
The Net Sales Ratio (%) per Year chart shows a significant decline in the net sales ratio from the year 2022 to 2024. Starting at 94.02% in 2022, the ratio dropped to 92.48% in 2023 and further declined to 90.29% in 2024. This consistent downward trend reflects an overall decline in sales performance, which may be caused by factors such as reduced market demand, increased competition, or rising production costs. It indicates that the company needs to conduct a thorough evaluation of its sales strategy, as well as consider market conditions and consumer behavior.
Overall, this chart signals a serious issue in the company’s net sales performance. The continuous decline in this ratio should be a major concern for management, who must take corrective actions to reverse this negative trend. By conducting further analysis to identify the root causes of the decline, the company can develop more effective strategies to improve sales performance and ensure that its products or services remain relevant and competitive in the market. Efforts to enhance cost efficiency are also crucial in helping to restore profit margins that may have been squeezed by the declining net sales ratio.
4. Conclusion
Over the past three years, the company has demonstrated excellent performance with significant increases in total transactions, gross sales, and net sales. Despite a decline in the percentage growth rate, the consistent increase in sales volume indicates that the implemented sales strategies have been effective. Additionally, the data analysis also shows that the company has successfully increased the shipping ratio and total sales ratio, reflecting strong performance and responsiveness to growing market demand.
However, there are several areas that need attention, such as the decline in gross sales ratio and the increase in discount ratio. This indicates that the company needs to conduct a more in-depth evaluation of the sales and discount strategies implemented. Furthermore, the decline in net sales ratio also suggests that the company needs to adjust its sales strategy and production costs to maintain profit margins.
In the long term, the company needs to continue analyzing and evaluating its sales performance and implemented strategies. This will help the company identify the factors contributing to its success and anticipate potential challenges that may arise in the future. By doing so, the company can continue to improve its sales performance and maintain a strong position in the market.
Overall, the data provided shows that the company has made significant progress over the past three years. However, the company needs to continue evaluating and adjusting its sales strategy and production costs to maintain strong performance and responsiveness to growing market demand. By doing so, the company can continue to improve its sales performance and maintain a strong position in the market.