Formation of Data Array Using the MS EXCEL to Create a Budgeting System for Insurance Company
Journal Title: Бізнес Інформ - Year 2016, Vol 1, Issue
Abstract
The article is aimed at the theoretical substantiation of the need for practical use of MS EXCEL spreadsheets when forming an array of management data in order to create an effective system for budgeting the activities of insurance company. In the working process, issues of automation of budgeting processes of insurance company activities were examined, basis of which constitute MS EXCEL spreadsheets. Advantages and disadvantages of using spreadsheets in the budgeting systems of companies have been allocated. Layouts of major operating budgets have been substantiated and proposed to introducing into practice of insurer. The article considers the main characteristics of budgets that should be considered when modeling budgets in the MS EXCEL environment. The economic effect of the introducing is improved efficiency and operability of managerial decisions in all directions of activity of insurer with minimal expenditure on using a simple effective tool for financial planning. Prospect of further scientific research is developing of a manager's screen for the head of an insurance company with purpose of providing simplicity and availability of building managerial reports.
Authors and Affiliations
Natalya Slobodyanyuk
Ensuring Financial Stability of the Banking Sector of Ukraine under Modern Conditions
The goal of the article lies in the study of various directions of assessment of financial stability of the banking system of Ukraine and on the basis of its consideration - in justification of a necessity of use of the...
Place of the State Support in the System of Formation of Competitiveness of Livestock Production
The article is aimed to define the role and importance of the State support of the livestock industry sector in the system of formation and securing the competitive production. The current status of the State support of...
The Informational-Analytical Support of the Managerial Backing for the Innovative Technologies for Staff Motivation in the System for Ensuring the Polyvector Development of Enterprises
The article is concerned with development of the informational-analytical supporting the managerial backing for the formation and implementation of innovative technologies of staff motivation in the system of polyvector...
Estimating the Status of the Pension Fund of Ukraine: Regional Aspect
This study is aimed to determine the regions of Ukraine, which are posing a significant strain on budget of the Pension Fund, as well as analyze the income volumes of pension contributions and payments to regions, in ord...
Contemporary Trends in Bankruptcy of Enterprises in Ukraine and Measures to Prevent Their Insolvency
The article is aimed at identifying the main trends in bankruptcy of enterprises in Ukraine as well as substantiation of the most appropriate measures to prevent their insolvency at the present stage of development of th...