The Projection Report is used to forecast the expected fund balance at the end of the budget or project period for each category or account.
Project Header
Caption |
Type |
Description |
Fund # |
Text |
Displays the PeopleSoft fund number. |
Status |
Text |
Displays the fund status – Active, Inactive, etc. |
PI Name |
Text |
The name of Principal Investigator of the Agreement |
Project Title |
Text |
The name of the Agreement (Project) |
Sponsor Name |
Text |
The name of the Sponsor |
Sponsor # |
Text |
The Sponsor number for the project |
Budget Start/End |
Text |
The Budget start and end dates |
Project Start/End |
Text |
The Project start and end dates |
Projections Totals
Field |
Description |
Current Balance |
Current overall budget balance on the account |
Current Obligations |
Sum of all Estimated expenses through the end of the period (not including User Entered Orders) |
Estimated Ending Balance |
Estimated expense through end of period: Estimated Ending Balance =Current Balance – the Current Obligations |
Projections Details
Field |
Description |
Number of Months in Remaining Budget Year |
Gives the number of months in remaining budget year |
Expense Category |
Lists different budget/expense categories such as Salaries & Wages, Travel and Equipment. . Displays only those categories and accounts where budget, expense or encumbrance data is applicable. |
Type |
Type is visible once you expand the expense category.
Monthly – considered a routine type purchase where expenses will be average to the end of the period (expenses to date / # of months of expenses x the number of months remaining)
One-time – factored only once through the end of the period |
Budget For Current Period |
Current awarded budget amount for the project |
Expenses To Date In Period |
Total cumulative expenses to date as of the last General Ledger close |
Additional Amount |
User defined additional amount to run projection |
Encumbrances |
Calculated as: (Budget – Expenses to Date) |
Balance |
Calculated as: (Budget – Expense to Date + Encumbrances) |
Estimated Expenses Through End Of Project Period |
Case1 – Category type – Linear
(((Expense to date + Encumbrances ) /#of months to date in Project )+User entered amount) * Number of Months left in the Project Period
Case2 - Category type – Non - Linear (Greater of the Budget for the period or Total Expenses to Date for the period + Encumbrances + Additional User entered amount
|
Direct Costs |
Aggregation of category expenses, budget, encumbrances etc, minus overheads. |
Indirect Costs |
Overheads against expenses, budget, encumbrances etc based on F&A basis and rate. |
Total Costs |
Sum of direct costs and indirect costs |
Revenue |
Displays the revenue earned during the period. |
Prior Year Balance |
Displays the aggregate amount of revenue calculated as: (Revenue - Expenses Incurred in the Previous years). |
Cash Balance |
Calculated as: (Revenue - Total Costs + Prior Year Balance) |
Personnel for Current Budget:
Caption |
Type |
Description |
Name |
Text |
Displays the Name of the employee.
|
Project Salary |
Text |
Displays the salary allocated to the employee for the project. |
Monthly Rate |
Text |
Displays the Monthly rate for the employee. |
Months Remaining |
Text |
Displays the Months Remaining for which the salary is to be paid. |
Committed Salary |
Text |
Monthly rate X Months remaining. |
Fringe Rate |
Text |
Displays the Fringe Rate for the employee according to job code. |
Committed Fringe |
Text |
Fringe rate X Months remaining |
Total Committed |
Text |
Sum of Committed Salary + Committed Fringe. |
Total |
Text |
Total line will be displayed on the bottom of the page summing up the financial columns:
|
Reports can be downloaded by clicking on the available download links.
Download to Excel
Download to PDF
The navigation trail keeps track of the path that the user came in from to allow for easy ‘back’ access to where they came from. Example:
Financial Summary > Projections
The Projections page can be accessed from the following pages:
Sub-Modules
By clicking the Projections tab from the following pages:
Project Details
Contract Details
Salary Details
Transaction Details
Budget Details
Expense Details
Links
Clicking ‘Projected Balance Remaining’ in Financial Summary
From the Projections page, the user can navigate to the following pages:
Sub-Modules
Project Details
Contract Details
Salary Details
Transaction Details
Budget Details
Expense Details
Financial Summary
Agreements Summary