eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
                            AMDG
MCj03888760000[1]
AutoBudget Budget Performance Tool
We all have to live on a budget.  AXIOM provides us with a utility to make them.  SMART's AutoBudget Budget Performance Tools provides an easy and intuitive way of measuring your performance and allows you to "drill in" to determine the root cause of any variances.  This Excel-based document updates itself overnight using direct ODBC calls into the AXIOM/Progress tables.  Since AXIOM can support multiple budgets, the first step is to select the desired budget:
 
       
                             
                             
                             
Once the desired budget is selected, AutoBudget updates itself nightly and CARt provides a quick link to the latest results.  The main budget screen looks like:
 
                           
                             
                             
Note the $10,191 expenditure on Row 390 for Period 3.  Double clicking on the number will jump you to a summary of all of the transactions that comprise this number:
 
                           
                             
                             
In this fashion, it is easy to control your budget and maximize profits!
                               
                             
                             
                             
                             
                             
                             
                             
                               
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 
This web page was last updated at 02/21/2014 07:44 AM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach