Burlakov O. S., Candidate of Economic Sciences, Associate Professor of the Information Technologies Department, Podolsk State University, Kamyanets-Podilsky, Ukraine

ORCID ID: 0000-0003-2753-3600
e-mail: alexburl1982@gmail.com

Mushenyk I. M., Candidate of Economic Sciences, Associate Professor of Mathematical Disciplines, Informatics and Modeling, Podolsk State University, Kamyanets-Podilsky, Ukraine

ORCID ID: 0000-0003-4379-7358
e-mail: mushenik77@ukr.net

Design of Planning Systems in the Environment of Modern Spreadsheets

Abstract. Introduction. The article considers the theoretical and methodological foundations of effective use and implementation of modern information systems and design technologies in the context of flexible enterprise planning systems. It has been proven that the use of information technology to automate calculations (spreadsheets) plays a key role in ensuring effective computerization of the planning process.

Purpose. Presentation of the main provisions of the alternative approach to the design of modern planning systems, relevant primarily for small and medium-sized businesses.

The methodological and theoretical basis of the article were the works of leading foreign and domestic scientists on the algorithmization of the budgeting process and the theoretical foundations of planning systems. Achieving this goal was carried out using the following scientific techniques and research methods: monographic (in reviewing and studying the literature on the evaluation of ICT), analysis and synthesis (for research and generalization of research results); logical-theoretical and dialectical (to form the conclusions of the study). In the process of research, the substantiation of theoretical calculations and conclusions was carried out on the basis of system-functional and structural approaches to the process of designing planning systems. The information base of the study is articles and monographs, including those posted on web pages.

Results. Theoretical bases of computerization of process of designing of flexible planning systems in the conditions of information economy are systematized, and also questions of providing the enterprise with resources by means of system of information and communication technologies which integrates information of the basic business processes are analyzed.

Scientific novelty of research results. Is to develop a model of the relationship of information blocks of the designed planning systems for business structures in the electronic environment of the spreadsheet, based on which you can make quality management decisions. The organizational and methodical scheme of the process of designing and implementing flexible planning systems in business structures using the capabilities of the electronic environment of the spreadsheet processor is proposed.

Conclusions. The obtained results can be used for further prospective research of information systems and technologies of planning systems design, as well as for the implementation of computerization tools for analytical and synthetic data processing of information systems in the enterprise.

Keywords: information system; planning; design; spreadsheet; electronic environment.

References:

1. Burlakov, O. S. (2013). E-commerce as a means of improving sales activity agroformations. Innovatsiina ekonomika. 1(39), 306-308 [in Ukrainian].
2. Burlakov, O. S. (2013). IT outsourcing as a tool for optimization of enterprises. Stalyi rozvytok ekonomiky. 4(42), 90-93 [in Ukrainian].
3. Burlakov, O. S. (2013). Risk management of IT outsourcing in the current economic conditions. Innovatsiina ekonomika. Retrieved from : http://nbuv.gov.ua/j-pdf/inek_2013_8_76.pdf [in Ukrainian].
4. Denysenko,P., & Kolossia, I. V. (2010). Information support effective management. Ekonomika ta derzhava. 7. 19-25 [in Ukrainian].
5. Kinash, A. (2012). Farm management of information technology. Stalyi rozvytok ekonomiky. 2(12). 50-53 [in Ukrainian].
6. Korzachenko, O. V. (2010). Technologies of management of business processes as a tool for improving business efficiency. Modeljuvannja ta inform. systemy v ekonomici. 7. 228-239 [in Ukrainian].
7. Ostaletskyi, V. B. (2015). Theoretical approaches to the classification of information management systems. Ekonomichnyi visnyk Natsionalnoho tekhnichnoho universytetu Ukrainy «Kyivskyi politekhnichnyi instytut». 294-299 [in Ukrainian].
8. Chuprina, O., & Ghoghot, M. M. (2017). Use of information systems in human resources management. Aktualjni problemy ekonomiky ta upravlinnja. 11. 236-238 [in Ukrainian].
9. Chuprina, M. O., & Shekhovtsova, I. A. (2016). Use of IT tools to optimize the management of business processes in Ukrainian enterprises. Ekonomichnyi visnyk Natsionalnoho tekhnichnoho universytetu Ukrainy «Kyivskyi politekhnichnyi instytut». 13. 324-329 [in Ukrainian].