Grids Overview

 Below is a list of data entry and reporting grids and the purpose they serve:

Menu / Function

 

Grid Name: Purpose

 

Salary Planning / Data Entry
  • Plan Employee Salaries:  Plan future salary changes related to expected salary increases ad/or reclassifications.
  • Employee Assumptions: Define employee worktime % and CSC division
  • Employee Assignment Grids (Data Entry)
  • Employee Account Allocation %: Plan employee account key assignments based on % in key, begin date, and end date
  • Employee Account Allocation – Hours by Quarter:  Plan employee account key assignments by hours and quarter
Non Salary Planning / Data Entry
  • Plan NonSal Expenses – Sep: Plan non-salary expenditures for the year and put them into the last month of the year for ease of maintenance
  • Plan NonSal Expenses – Spread: Plan non-salary expenditures for the year and spread them across months – assumes use of Monthly grid for maintenance
  • Plan NonSal Expenses – Monthly: Plan non-salary expenditures by month – option that can be added if desired
  • Plan SubAward MTDC Exclusions: Plan sub-awards that will be over $25k and ensure MTDC is calculated for just the first $25k
Reports / References and Analysis
  • Scenario Assumptions: View business drivers such as overhead rates, benefit rates, global salary increase, etc. by fiscal year.
  • Division CSC Rates:  View division CSC rates by fiscal year
  • Forecasting/Reporting Grids (Analysis)
  • Employee Projections Annual: Total employee projections (hours, person year, salaries, benefits, overhead, CSC, loaded salary) for a year.
  • Employee Projections Quarterly:  Employee hours by quarter and year by account. Person year, salaries benefits, overhead, CSC, loaded salary for the year.
  • Employee Actual vs Forecast: Employee hours by quarter – actual vs. forecast. Person year, salaries benefits, overhead, CSC, loaded salary for the year.
  • Budget Forecast Analysis: IFAS Budget, Incurred Actual, IFAS Encumbrance, IFAS Funds Available, Forecast, IFAS Budget vs, Forecast by account and expense class.