International Journal of Computer Science & Network Security

International Journal of Computer Science & Network Security (국제컴퓨터통신보호논문지학회)
권호 표지
DOI QR코드

DOI QR Code

Price Monitoring Automation with Marketing Forecasting Methods

  • Oksana Penkova (Department of Marketing, Uman National University of Horticulture) ;
  • Oleksandr Zakharchuk (Department of Investment and Material and Technical Support, National Scientific Centre ) ;
  • Ivan Blahun (Department of Management and Marketing, Vasyl Stefanyk Precarpathian National University) ;
  • Alina Berher (Department of Marketing, National University of Food Technologies) ;
  • Veronika Nechytailo (Department of Investment and Material and Technical Support, National Scientific Centre ) ;
  • Andrii Kharenko (Department of Marketing, Uman National University of Horticulture)
  • Received : 2023.09.05
  • Published : 2023.09.30
Download PDF
⟨ Previous Next ⟩

Abstract

The main aim of the article is to solve the problem of automating price monitoring using marketing forecasting methods and Excel functionality under martial law. The study used the method of algorithms, trend analysis, correlation and regression analysis, ANOVA, extrapolation, index method, etc. The importance of monitoring consumer price developments in market pricing at the macro and micro levels is proved. The introduction of a Dummy variable to account for the influence of martial law in market pricing is proposed, both in linear multiple regression modelling and in forecasting the components of the Consumer Price Index. Experimentally, the high reliability of forecasting based on a five-factor linear regression model with a Dummy variable was proved in comparison with a linear trend equation and a four-factor linear regression model. Pessimistic, realistic and optimistic scenarios were developed for forecasting the Consumer Price Index for the situation of the end of the Russian-Ukrainian war until the end of 2023 and separately until the end of 2024.

Keywords

References

  1. N. Spanoudakis, and P. Moraitis, "Automated product pricing using argumentation," Artificial Intelligence Applications and Innovations III. IFIP International Federation for Information Processing, vol. 296, pp. 321-330, 2009, doi: 10.1109/WI-IAT.2010.136.
  2. A. Haji, and M. Assadi, "Fuzzy expert systems and challenge of new product pricing," Computers & Industrial Engineering, vol. 56, no. 2, pp. 616-630, Mar. 2009, doi: 10.1016/j.cie.2007.03.005.
  3. N. V. Biloshkurska, "Adaptive behavior models and their role in formation of enterprise economic security," (in Ukrainian), Actual Problems of Economics, vol. 114, pp. 101-105, 2010.
  4. M. Capinski, and E. Kopp, "Derivative pricing methodology in continuous-time models," Applied Mathematics Letters, vol. 25, no. 12, pp. 2137-2139, Dec. 2012, doi: 10.1016/j.aml.2012.05.011.
  5. S. Liozu, and A. Hinterhuber, "Industrial product pricing: a value-based approach," Journal of Business Strategy, vol. 33, no. 4, pp. 28-39, July 2012, doi: 10.1108/02756661211242681.
  6. Ch. Lo, and K. Skindilias, "An improved Markov chain approximation methodology: Derivatives pricing and model calibration," International Journal of Theoretical and Applied Finance, vol. 17, no. 7, 1450047, 2014, doi: 10.1142/S0219024914500472.
  7. A. Calabrese, and F. Francesco, "A pricing approach for service companies: service blueprint as a tool of demand-based pricing," Business Process Management Journal, vol. 20, no. 6, pp. 906-921, 2014, doi: 10.1108/BPMJ-07-2013-0087.
  8. E. Pergler, D. Weitlaner, X. Liu, A. Hober, and T. Loidolt, "Connecting value assessment and dynamic pricing of services to the Performance Journey Mapping framework," Central European Conference on Information and Intelligent Systems, pp. 57-64, Sep. 23-25, 2015.
  9. Y. Braouezec, "How fundamental is the one-period trinomial model to European option pricing bounds. A new methodological approach," Finance Research Letters, vol. 21, pp. 92-99, May 2017, doi: 10.1016/j.frl.2016.11.001.
  10. V. V. Martynenko, "Macroeconomic factors of market pricing under perfect competition," (in Ukrainian), Scientific bulletin of Polissia, vol. 2, part. 1, pp. 105-112, June 2017, doi: 10.25140/2410-9576-2017-1-2(10)-105-112.
  11. N. V. Biloshkurska, M. V. Biloshkurskyi, and L. A. Chvertko, "Influence of the security market condition on the collective investment development," Scientific bulletin of Polissia, vol. 3, part. 2, pp. 138-142, Sept. 2017, doi: 10.25140/2410-9576-2017-2-3(11)-138-142.
  12. B. Denkena, M.-A. Dittrich, and S, Stamm, "Dynamic bid pricing for an optimized resource utilization in small and medium sized enterprises," Procedia CIRP, vol. 67, pp. 516-521, 2018, doi: 10.1016/j.procir.2017.12.254.
  13. J. Januardi, and E. Widodo, "Response surface methodology of dual-channel green supply-chain pricing model by considering uncertainty," Supply Chain Forum: An International Journal, vol. 22, no. 1, pp. 16-27, July 2020, doi: 10.1080/16258312.2020.1788904.
  14. E. Widodo, and J. Januardi, "Noncooperative game theory in response surface methodology decision of pricing strategy in dual-channel supply chain," Journal of Industrial and Production Engineering, vol. 38, no. 2, pp. 89-97, Nov. 2020, doi: 10.1080/21681015.2020.1848932.
  15. V. Tang, "Service-value and Nash-equilibrium pricing: An axiomatic methodology," Preprints, 2021, no. 2021040455. [Online]. Available: preprints.org/manuscript/202104.0455/v1/download.
  16. M. Kholod, Y. Lyandau, E. Popova, A. Semenov, and K. Sadykova, "Value measurement and taxation metrics in the Model-Building Foundations for intelligent pricing methodology," Smart Innovation, Systems and Technologies, vol. 238, pp. 659-667, July 2021, doi: 10.1007/978-981-16-2765-1_55.
  17. V. Kozyk, O. Mrykhina, L. Lisovska, O. Yurynets, and H. Rachynska, "Econometric pricing model for R&D products in transfer agreements," Advances in Intelligent Systems and Computing, vol. 1293, pp. 779-797, Dec. 2021, doi: 10.1007/978-3-030-63270-0_54.
  18. N. V. Biloshkurska, "Marketing research of pricing factors in a competitive market," (in Ukrainian), Marketing and Management of Innovations, vol. 1, pp. 24-31, Mar. 2015.
  19. O. Dragan, A. Berher, and J. Pustovit, "Estimation of marketing price policy efficiency of the enterprise of meat-processing industry," Management Theory and Studies for Rural Business and Infrastructure Development, vol. 40, no. 2, pp. 175-186, July 2018, doi: 10.15544/mts.2018.17.
  20. O. Dragan, A. Berher, I. Plets, N. Biloshkurska, N. Lysenko, and O. Bovkun, "Modelling and factor analysis of pricing determinants in the state-regulated competitive market: The case of Ukrainian flour market," International Journal of Computer Science and Network Security, vol. 21, no. 7, pp. 211-220, July 2021, doi: 10.22937/IJCSNS.2021.21.7.25.
  21. State Statistics Service of Ukraine. (2022). Consumer price indices for goods and services (to previous month) [Online]. Available: http://surl.li/cvole.
  22. O. V. Braslavska, O. H. Penkova, I. I. Plets, T. Y. Sus, N. V. Biloshkurska, and M. V. Biloshkurskyi, "Management of the higher education institutions innovative potential: Formalization and evaluation," Revista Inclusiones, vol. 7, no. 4, pp. 624-645, July 2020. [Online]. Available: revistainclusiones.org/index.php/inclu/article/view/1575.
  23. R. E. Park, "Estimation with heteroscedastic error term," Econometrica, vol. 34, no. 4, pp. 888, 1966, doi: 10.2307/1910108.
  24. H. Glejser, "A new test for heteroskedasticity," Journal of the American Statistical Association, vol. 64. no. 325. pp. 316-323, 1969, doi: 410.1080/01621459.1969.10500976.