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

Keywords

Related Articles

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...

Download PDF file
  • EP ID EP164429
  • DOI -
  • Views 101
  • Downloads 0

How To Cite

Natalya Slobodyanyuk (2016). Formation of Data Array Using the MS EXCEL to Create a Budgeting System for Insurance Company. Бізнес Інформ, 1(), 293-298. https://europub.co.uk/articles/-A-164429