Budget Analysis (Item Level) Report

Top  Previous  Next

The Budget Analysis (Item Level) Report is accessed from the Reports Window, Project Management folder.  Budgets can be configured for individual Items as well as for particular Sales Categories and/or Locations within an entire Project.  The Budget Analysis (Item Level) Report is designed to compared the Item Budgets against the Estimated and Actual Prices currently recorded for the Item.  To learn more about entering Budgets for individual Items, see the Item Window - Pricing Information Tab.

 

budg analysis item report window

 

Ranges for Clients, Projects, Sales Categories, and Locations are available to narrow the scope of the Budget Analysis Report.  The Format Selection determines the versus of the Budget Analysis Report that will be displayed and has the following options:

 

Simple by Sales Category:  Only the Item Reference Number, Description, Quantity, and Budget will be displayed.  The Items will be grouped and subtotaled by Sales Category.
Simple by Location:  Only the Item Reference Number, Description, Quantity, and Budget will be displayed.  The Items will be grouped and subtotaled by Location.
Sales Category Summary:  The Budget, Estimated, and Actual Prices totals, and appropriate Variances, for each Sales Category used within the Project will be displayed.  Each Sales Category will be divided into Budget and Non-budget representing the total of Items with a non-zero Budget and those without, respectively.
Location Summary:  The Budget, Estimated, and Actual Prices totals, and appropriate Variances, for each Location used within the Project will be displayed.  Each Location will be divided into Budget and Non-budget representing the total of Items with a non-zero Budget and those without, respectively.
Sales Category Detail:  The Reference Number, Description, Budget, Estimate, and Actual Prices for each Item will be displayed.  Items will be grouped and subtotaled by Sales Category.   Each Sales Category will be divided into Budget and Non-budget representing the total of Items with a non-zero Budget and those without, respectively.
Location Detail:  The Reference Number, Description, Budget, Estimate, and Actual Prices for each Item will be displayed.  Items will be grouped and subtotaled by Location.   Each Location will be divided into Budget and Non-budget representing the total of Items with a non-zero Budget and those without, respectively.

 

The Variance is defined as the Estimate or Actual Price less the Budget.  Therefore, a negative Variance indicates that the particular Item, Sales Category, or Location is under Budget.  A positive Variance, which will be displayed in red, indicates that the Component Type is currently over Budget.

 

An option to show the full Item Description on the Detail versions is also available.