Analytical support software for online store sales accounting
DOI:
https://doi.org/10.33216/1998-7927-2021-268-4-128-132Keywords:
information system, online store, database, autoregression, C#Abstract
The paper discusses the design of an information and analytical system for accounting and forecasting sales of an online store in order to improve the efficiency of its management.
Based on the analysis of models and methods of designing an information system, it was decided to use a functional approach to modeling.
On the example of an online store of computer equipment, the analysis and modeling of business processes based on a functional approach in the notations IDEF0 and IDEF3 have been carried out.
A database in MySQL and the necessary software for records of trade transactions of an online store have been developed.
To solve problems of strategic management, the problem of development and implementation of a software module for forecasting sales in the management system of an online store is considered.
Methods and models of sales forecasting are analyzed on the example of an online computer hardware store. There is no seasonal factor in the dynamics of sales of computer equipment. Also, short-term forecasts are relevant for solving considered control problems. Therefore, it is recommended to use the forecasting method based on the autoregressive model. Variants of using autoregressive models of the 1st and 2nd orders are considered. The most adequate was the 1st order autoregressive model.
The software in C# for forecasting sales volumes based on an autoregressive model has been developed.
The developed software can be integrated into the information and analytical system for recording trade operations of an online computer equipment store. The scheme of integration of the developed software into the information-analytical management system of the online store is presented.
The result of the work is a project of an information and analytical system for accounting and forecasting sales of an online store of computer equipment. The project includes a database, software for data processing and a software module for analyzing and predicting the dynamics of changes in sales of an online store.
The implementation of the proposed tools will improve efficiency and quality of decision-making when managing an online store.
References
1. Інформаційний інтернет-портал All Retail // Україна в 2020 р стала лідером по зростанню e-commerce в Східній Європі — Euromonitor International -2020. URL: - https://allretail.ua/news/67700-ukrajina-v-2020-r-stala-liderom-po-zrostannyu-e-commerce-v-shidniy-yevropi-euromonitor-international (дата звернення 02.06.2021).
2. Інформаційний інтернет-портал bakertilly // 7 причин того, чому інтернет-ритейлери відкривають фізичні магазини -2020. URL: - https://bakertilly.ua/news/id45301 (дата звернення 02.06.2021).
3. Гвоздева Т.В. Проектирование информационных систем: технология автоматизированного проектирования. – 2016. – 156 с.
4. Sciore's E.S. Database Design and Implementation // Introduces you to database systems. – 2020. – 466 p.
5. Гайдаржи В.С., Ізварін І.О. База даних в інформаційних системах. - Унів. “Україна”, – 2018. – 418 с.
6. James R. Groff, Paul N. Weinberg, Andrew J. Oppel. SQL: The Complete Reference, 3rd Edition. – 2018. – 960 p.
7. Abraham B., Ledolter J. Statistical methods for forecasting. – New York: Wiley, 2003. – 421 p.
8. Ячменьов А. В. Інформаційно-аналітична система для обліку торгових операцій інтернет-магазину. / А. В. Ячменьов, Л. О. Шумова // Збірник наукових праць за матеріалами ІІІ міжнародної науково-методичної конференції «Комп’ютерні технології і мехатроніка», 27 травня 2021 р. – Харків, ХНАДУ, 2021. – С. 177-179.
