This drupal page explains the following sections of the Budget and Financial Forecasting Report:
The Current Account Info section lists general information about the account, including program title, funding source, contract number, etc.
The columns in this section are labeled as follows:
- IFAS Budget = Budget in UCAR Accounting System for FY14
- (Uncommitted + Committed Carryover + New Funds + Transfers; this is similar to what we have called Working Budget)
- EXPECTED FUNDS = Funds expected, but not yet received in FY14 (NEW)
- TOTAL EXPECTED FUNDS = IFAS Budget column plus Expected Funds column (NEW)
- IR INCURRED ACTUAL EOM YTD
- IR = Interim Rate (The Interim Rate refers to the NCAR benefits and overhead rates which may change during the Fiscal Year)
- EOM = End of Month
- YTD = Year-to-Date
This section referees to the Year-to-Date actual expenses as of the current month-end using the current NCAR Interim Rate
- IR WORKING PLAN REMAINING = salary and non-salary planned costs for the balance of the fiscal year
- IR FORECAST = total of IR Incurred Actual EOM YTD column plus IR Working Plan Remaining column
- IFAS Budget vs IR Forecast = Total Expected Funds column minus IR Forecast column (similar to what we used to call Available Funds )
NOTE: Non-salary encumbrances are NOT included in the FY Account Forecast Summary section – they are included in the YTD Forecast section and should be subtracted from the IFAS Budget vs IR Forecast column bottom line. This will result in a true funds available amount (this will become more clear when you open an actual report).
Numerical information for the data points can be viewed by hovering your cursor over the data points; a pop-up box will appear.
YTD Forecast provides monthly information about non-salary encumbrances, expenses charged to date, and forecast information for the remaining months. This includes information from the salary matrix and other other non-salary information. You can click on non-salary encumbrances and past year-to-date actual data for additional detailed information.
Click on any blue underlined amount, and it will give you year-to-date information on the expenses charged.
Please note that we are still working on keeping the forecast information updated and what this report shows as planned may not always be accurate.
Monthly Actuals - lists actual expenses for the month. Click on the blue underlined amount to see hours and salary expenses.
This shows information about hours and salary charged, hours and salary planned, and hours and salary remaining for all employees who have charged or been allocated to this account.
- Working Plan Remaining/Pct on Key Current Pay Period = the percent on the key planned for the current pay period. We hope to have this shown in an hourly value in the future
- Incurred Actual EOM YTD = actual hours and salary expense year-to-date
- IR Forecast = hours and salary remaining to be spent for remaining months in the current fiscal year
- Working Plan = shows original hours and salary dollars for the fiscal year (from our matrix)
- Working Plan vs IR Forecast = shows a variance between Working Plan and the IR Forecast hours and salary. Again, we are still working on keeping the forecast inforamtion updated and what this report shows as planned may not always be accurate.
Clicking on any employee underlined in blue will supply the same information for all accounts that individual has charged or is allocated to.
To export detailed reports, from the Tool Bar, choose the box containing the small blue circle to expand the selection.
