This article will walk you through the components of running an Item Variance Report.
NOTE: Due to the configurable nature of the FACS Platform, the specific name of some Labels or Field Names may differ from this example and your portal.
The Item Variance Report can be generated by first accessing your project, followed by opening the project Reports Page:
| # | Description |
| 1 | Select your project |
| 2 | Click the Reports button |
| 3 | Once the report Page has opened, select Item Detail |
| # | Description |
| 1 | Click Compile Report |
Once the report compiles, you can view the report within FACS:
| # | Description | Details |
| 1 | Portal Name | Name of the Client Portal |
| 2 | Construction Start Date | Displays the Construction Start Date from Project Information |
| 3 | Project Name | Project Name |
| 4 | Estimated Completion Date | Displays the Estimated Completion Date from Project Information |
| 5 | Project Number | Displays the Project Number from Project Information |
| 6 | Report Name | Name of the Report |
| 7 | Fiscal Share | Displays the Fiscal Share associated with the Item |
| 8 | Item Number | Displays the Item No |
| 9 | Sequence Number | Displays the Seq. Number |
| 10 | Item Description | Displays the Description of the Item |
| 11 | UOM | Unit of Measure |
| 12 | Unit Price | Unit Price of the Item |
| 13 | Authorized Qty | Current Authorized Quantity of the Item |
| 14 | Items Authorized Overrun % | Item Overrun (from Project Items) |
| 15 | Major or Minor | Displays if this item is tagged with Major or Minor |
| 16 | Quantity Variance |
If the value in this field is a negative, then there is no overrun of the item. If the value in this field is positive, then there is an overrun of this qty. Calculation = (total quantity used to date for the item) - (Items "Authorized Qty" * Item Overrun (from Project Items) ) |
| 17 | Amount Variance |
If the value in this field is a negative, then there is no overrun of the item. If the value in this field is positive, then there is an overrun of this $ amount. Calculation = "Quantity Variance" * "Unit Price" |
| 18 | Percent Variance |
If the value in this field is under 100%, then there is no overrun of the item. If the value in this field is over 100%, then there is an overrun by this %. Calculation = ((Items "Authorized Qty" * Item Overrun (from Project Items) ) +"Quantity Variance" )/(Items "Authorized Qty" * Item Overrun (from Project Items) ) |
| 19 | Page Number | Displays page n of n |
| 20 | Date Generated | Displays the date the report was run in FACS |
Once your Item Overrun Report has been displayed, it can be downloaded in the following formats:
- CSV
- Excel
| # | Description |
| 1 | Select Format for download |
| 2 | Select Paginated or not (Paginated is recommended for PDF, but not recommended for csv or Excel) |
| 3 | Click to download the compiled report in the selected format |
To learn more about reports, please see the related support pages on How to Run a Report and How to Export a Report.
If you have any questions, or need additional assistance, please reach out to our support team at support@facsware.com and we will be happy to assist you.