EXPRESS METHOD FOR CALCULATING GROSS MARGIN IN E-COMMERCE: A PRACTICAL APPROACH
##plugins.themes.bootstrap3.article.main##
##plugins.themes.bootstrap3.article.sidebar##
Abstract
The purpose of this study is to present a streamlined approach to calculating the gross margin of online stores, with a particular focus on addressing the specific requirements of small and medium-sized enterprises (SMEs) within the e-commerce sector. This research presents a comparative analysis between the traditional method of gross margin calculation and an express approach that utilises the average order value (AOV) as a central metric. The objective of this study is to evaluate the efficiency and accuracy of the express method, particularly in the context of SMEs that may lack the resources required for more complex financial analyses. Methodology. A quantitative research design is employed, utilising data from three online retailers specialising in the sale of home textiles and linens produced by an in-house sewing studio. The shops in question operate on a number of e-commerce platforms, including Rozetka, Etsy, eBay, and Prom.ua. The study encompasses a period of eight months, during which sales data was collected and analysed in order to evaluate the efficacy of both manual and express methods of gross margin calculation. The express method incorporates statistical analysis, including z-scores and normal distribution, to provide a probabilistic framework for the assessment of the likelihood of achieving target gross margin ranges under different pricing scenarios. Results. The findings of the study indicate that the express method suggests a probability of achieving a gross margin within the 25-30% range, with a 38.11% likelihood. A case study utilising tulle curtains demonstrates the practical application of the aforementioned method. Following the implementation of a 20% discount, the gross margin experienced a notable decline, from 33.9% to 17.36%. Furthermore, the results of the z-score analysis indicate that the probability of exceeding a 30% gross margin is 27.43%, while the likelihood of the margin falling below 25% is 34.46%. This analysis underscores the inherent risks associated with offering discounts and illustrates the potential for significant fluctuations in profitability contingent upon price adjustments. Practical implications. The express method offers invaluable insights that can inform decision-making in a range of retail contexts. To illustrate, an online fashion retailer may utilise the method to evaluate the influence of price increases on gross margin during seasonal promotions. Similarly, a home goods store could employ the method to ascertain the impact of a flash sale discount on profitability, thereby facilitating the balancing of margins with sales volume. Value / Originality. The express method introduces a novel approach by integrating AOV and probabilistic analysis into gross margin calculation. This offers a dynamic framework that accounts for variability in discounts and sales, which is a significant advantage over traditional methods that rely on fixed margin targets or historical averages.
How to Cite
##plugins.themes.bootstrap3.article.details##
express method of calculating gross margin, average order value (AOV), e-commerce profitability, small and medium-sized enterprises (SMEs), pricing strategies in online retail
Alnazer, M. (2013). The Moderating Role of Promotional Benefit Level and Brand Awareness on the Effectiveness of Price Discount and Premium. Advances in Management, Vol. 6(12), p. 40.
Ami, A. S., Syafitri, L., & Meiriasari, V. (2023). The Effect of E-Commerce and the Use of Accounting Information Systems on The Revenue Cycle of Micro, Small and Medium Enterprises. Journal of Humanities, Social Sciences and Business, Vol. 3(1), 68–77. DOI: https://doi.org/10.55047/jhssb.v3i1.818
Anitha, J., Challa, M. R. R. M. S., & Murali, D., S. S. (2024). Analysis and Estimation of Discounts on Product Prices in E-Commerce Sites. In the Proceedings of the 2024 IEEE International Conference on Computing, Power and Communication Technologies (IC2PCT) (pp. 759–762). Greater Noida. DOI: https://doi.org/10.1109/ic2pct60090.2024.10486475
Andrus, O. (2024). Contemporary pricing strategies: shaping competitive products. In book: Traditional and innovative scientific research: domestic and foreign experience (Chapter «ECONOMIC SCIENCES», pp. 558–579). DOI: http://dx.doi.org/10.30525/978-9934-26-436-8-20
Arbelo, A., Arbelo-Pérez, M., & Pérez-Gómez, P. (2021). Profit Efficiency as a Measure of Performance and Frontier Models: A Resource-Based View. BRQ Business Research Quarterly, Vol. 24(2), p. 143–159. DOI: https://doi.org/10.1177/2340944420924336
Bildea, T. S., & Gorin, T. (2017). Towards capturing ancillary revenue via unbundling and cross-selling. Journal of Revenue and Pricing Management, Vol. 17(2), p. 102–114. DOI: https://doi.org/10.1057/S41272-017-0123-Z
Gerpott, T. J., & Berends, J. (2022). Competitive pricing on online markets: a literature review. Journal of Revenue and Pricing Management, Vol. 21, p. 596–622. DOI: https://doi.org/10.1057/s41272-022-00390-x
Gupta, S., Kushwaha, P. S., Badhera, U., Chatterjee, P., & Santibanez Gonzalez, E. D. R. (2023). Identification of benefits, challenges, and pathways in E-commerce industries: An integrated two-phase decision-making model. Sustainable Operations and Computers, Vol. 4, p. 200–218. DOI: https://doi.org/10.1016/j.susoc.2023.08.005
Ijomah, T. I., Idemudia, C., Eyo-Udo, N. L., & Anjorin, K. F. (2024). Harnessing marketing analytics for enhanced decision-making and performance in SMEs. World Journal of Advanced Science and Technology, Vol. 6(1), p. 001–012. DOI: https://doi.org/10.53346/wjast.2024.6.1.0037
IMP Marketing. (2023). E-commerce Profit Margins Mastery: A Comprehensive Guide. IMP Blog. Available at: https://blog.impmarketing.co/e-commerce-profit-margins-mastery-a-comprehensive-guide/
Kashyna, G., Nikolaieva, S., Stenicheva, I. & Artemenko, A. (2022). Pricing strategy in strategic enterprise management. Problems of Innovation and Investment-Driven Development / Problemi ìnnovacìjno-ìnvesticìjnogo rozvitku, Vol. 28. DOI: https://doi.org/10.33813/2224-1213.28.2022.17
Konings, J., Werner, R., & Zhao, L. (2011). Price-Cost Margins and Shares of Fixed Factors. CEPR Discussion Paper No. DP8290. Available at: https://ssrn.com/abstract=1794880
LeBlanc, D. (2023). Gross Margin: The Authoritative Guide [2023]. Daasity. Available at: https://www.daasity.com/post/gross-margin
Li, L. (2021). Customer Value Measurement Under the Background of E-commerce. In Proceedings of the 1st International Symposium on Innovative Management and Economics (ISIME 2021) (pp. 462–467). DOI: https://doi.org/10.2991/aebmr.k.210803.063
Liu, C. H. B., & McCoy, E. J. (2023). Measuring e-Commerce Metric Changes in Online Experiments. arXiv. DOI: https://doi.org/10.48550/arXiv.2210.17187
Matsuoka, K. (2020). Exploring the interface between management accounting and marketing: a literature review of customer accounting. Journal of Management Control, Vol. 31, p. 157–208. DOI: https://doi.org/10.1007/s00187-020-00299-9
Mina, N.-H., & Seyyed-Mahdi, H.-M. (2023). Dynamic discount pricing in online retail systems: Effects of post-discount dynamic forces. Expert systems with applications, 232, Article 120864. DOI: https://doi.org/10.1016/j.eswa.2023.120864
Paragon, R. (2024). Financial Strategies to Optimize Your eCommerce Business in 2024. Linked-In. Available at: https://www.linkedin.com/pulse/financial-strategies-optimize-your-ecommerce-business-2024/
Pavlov, O. (2021). Multi-product firms and increasing marginal costs. Journal of Economic Dynamics and Control, Vol. 133, Article 104239. DOI: https://doi.org/10.1016/j.jedc.2021.104239
Saeede, E., & Hossein, P.-N. (2020). A Framework for Probabilistic Decision-Making Using Change-of-Probability Measures. IEEE Access ((Institute of Electrical and Electronics Engineers (IEEE)), Vol. 8, p. 159331–159350. DOI: https://doi.org/10.1109/ACCESS.2020.3020928
Sinha, S. K., & Verma, P. (2020). Impact of sales Promotion's benefits on perceived value: Does product category moderate the results? Journal of Retailing and Consumer Services, Vol. 52, Article 101887. DOI: https://doi.org/10.1016/j.jretconser.2019.101887
Strong, J. S. (2024). The distribution of retail gross margin: analysis and implications. The International Review of Retail, Distribution and Consumer Research, p. 1–20. DOI: https://doi.org/10.1080/09593969.2024.2309363
Sulewski, P., & Wąs, A. (2018). Index-Based Insurance of Gross Margin in Agriculture – Key Challenges /Wskaźnikowe ubezpieczenie nadwyżki bezpośredniej w rolnictwie – identyfikacja kluczowych wyzwań. Zagadnienia Ekonomiki Rolnej/Problems of Agricultural Economics, Vol. 2(235), p. 3–26. DOI: https://doi.org/10.30858/ZER/92059
van Schaik, S. J. (2014). A framework for processing correlated probabilistic data: [Thesis for the degree of Doctor of Philosophy]. University of Oxford. Available at: https://shorturl.at/82GNG
Wenxiang, D., Qingming, L. H., & Vicky, Z. (2019). Statistical and Machine Learning-based E-commerce Sales Forecasting. In ICCSE’19: Proceedings of the 4th International Conference on Crowd Science and Engineering (110–117). DOI: https://doi.org/10.1145/3371238.3371256
Wu, J., & Zhao, C. (2023). The Online Retailer’s Randomized Pricing Strategy to Compete with an Offline Retailer. International Journal of Electronic Commerce, Vol. 27(2), p. 210–235. DOI: https://doi.org/10.1080/10864415.2023.2184239
Xin, C. (2003). Coordinating Inventory Control and Pricing Strategies with Random Demand and Fixed Ordering Cost. Manufacturing & Service Operations Management, Vol. 5(1), p. 59–62. DOI: https://doi.org/10.1287/MSOM.5.1.59.12763
Zhu, Y. (2022). The Simplicity of Margin in eCommerce: A Comprehensive Guide. Replo. Available at: https://www.replo.app/blog/margin
This work is licensed under a Creative Commons Attribution 4.0 International License.