Development of an Automated and Integrated Budgeting System

Abstract

Alpine Health currently uses Microsoft Excel to produce consolidated budget statements each year. These Excel templates have become extremely cumbersome to the accounting department since they must cut and paste all of the templates (over 20) into a master schedule that consolidates the reports into a view that the executives make decisions from. Often times these templates are too large to email back and forth. They are hard to track since several versions of the same budget are sent during the process. Each time a new entity or hospital is added, the accounting department must update several different tabs on the master schedule to make sure it consolidates correctly. The company needs a seamless budget system that would put into place a budget process/workflow as well as a software package to incorporate the consolidation easily

    Similar works