The Project Financial Plan displays programmed and obligated costs for selected projects, combining scheduled and obligation perspectives into a single view.
Filters
Once the user selects the Project Financial Plan in the "Select Report" list, these filters will appear:
| Filter | Description |
| FMIS/STIP Split Year | A picklist of available years; required. This will show STIP programmed values in or after the selected year and FMIS obligations before the selected year in the report. |
| Group Type | A picklist with three options: Program, Fund Source, and Appropriation Code; required |
| Run By | A picklist with two options: Project Tag and Key Numbers; required. The selection in this field determines the title/content of the fourth field. |
| Project Tag/Key Number(s) | This field will either display Project Tag or Key Number(s), depending on the selection in the "Run By" field; required
|
Generate the Report
To generate this report, the user can follow these steps:
- Click "Project Financial Plan" in the "Select Report" list (left side).
- Select a value in the FMIS/STIP Split Year, Group Type, Run By, and Project Tag/Key Number(s) fields.
- Click the "Submit" button.
If the user wishes to change the STIP/TIP before running the report, they can navigate to the STIP/TIP Selection picklist on the Main Menu. To export the report, the user can click the export icon (), then choose the export type (PDF, XLSX, DOCX).
Output
The resulting report will display the selected Key Number(s), Project Property, and FMIS/STIP Split Year at the top of the report, with groupings of Corridor and Key Numbers below. Each grouping is specified by these columns:
| Column | Description |
| Type | The type will be either Obligation or Scheduled based on if the line item is showing actual obligations (Obligation) or scheduled costs (Scheduled). |
| Federal Aid Number | This is the Federal Project Number of the FMIS Project. |
| Work Authority Number | This is the Work Authority Number for the FMIS Project. This column will be blank for scheduled lines. |
| Fiscal Year | This is the Federal/State Fiscal Year. |
| Improvement Type | This is the Improvement Type for the FMIS Project. This column will be blank for scheduled lines. |
| Fund Source | This is the Fund Source for the FMIS Project. |
| Program Code | This is the Program Code for the FMIS Project. This column will be blank for scheduled lines. |
| Federal Aid | This is the Variance between Prior Approved Federal Funds and New Federal Funds (i.e. the same calculation used for FMIS Accounts). |
| Total Cost | This is the Total Cost of the GIS and Non-GIS Locations. |
| Cost by Phase | This is the Actual Obligations or Programmed Amounts by Parent Work Phase. This column will also be calculated as a percent of construction funds at the Key Number and Corridor level. |
Comments
0 comments
Please sign in to leave a comment.