Projections

 

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.

Projections Screen Shot

Projections Main Screen Elements

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:

  • Project Salary

  • Monthly Rate

  • Committed Salary

  • Committed Fringe

  • Total Committed

 

 

Projections Export Options

Reports can be downloaded by clicking on the available download links.

 

 

 

Projections Navigation

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:

 

By clicking the Projections tab from the following pages:

 

 

From the Projections page, the user can navigate to the following pages: