These files are all in Excel, version 5.0 or Office 97-2003 Excel.
Other budget resources:
Budget Reform Modification for FY05
(Notes from Bill Adams, 5/13/04, subject to change.)
- Prorated Shares (15% of General Revenue) will be frozen and will stay the same as last year.
Faculty FTE
Graduate IUs
Grants & Contracts
Administrative assessment will be frozen and will stay the same as last year.
On-campus Tuition distribution will continue to be determined by formula
ICR distribution will continue to be determined by formula
Spreadsheets used to calculate undergraduate tuition revenue
based on enrollment by residency and Part Time/Full Time status
and IUs by Lower Division/Upper Division
Notes on these spreadsheets
Spreadsheets used in the calculation of administrative overheads
These spreadsheets were used to create the system of simultaneous equations
used to prorate administrative expenses to all revenue-generating units.
Many of the data items used in these spreadsheets are available at the
UIUC Campus Profile website.
To see a presentation on the calculation of administrative overheads, click here.
| Budget Year: |
FY04 | FY03 | FY02 | FY01 | FY00 | FY99 | FY98 | Who Pays |
|---|
Step 1
Changes due to usage |
Step 1 |
Step 1
(Note: ACES Library NASF
is omitted.)
Updated 6/29/02 with
revisions to Eng & ACES NASF |
Step 1 |
Step 1 |
Step 1
| n/a |
College |
Step 2
Changes due to DBC projects |
- |
Step 2
After admin reductions |
Step 2 |
Step 2 |
Step 2 |
Step 3
(final)
Other increases |
- |
Final
Other adjustments
(ACES Library,
midyear revisions of
last year's budgets.) |
Final |
Final |
Final |
Final |
Final |
Campus |
| Summary |
|
Summary |
|
|
|
|
|
| Cost per unit usage |
Cost per unit usage FY99-FY03 |
|
|
Starting in FY00, we calculated the overheads in three steps. The first two steps represent
changes that will be funded by colleges. The final step is funded by the campus.
Each workbook has three worksheets noted by the tabs at the bottom of the screen.
If you look at the sheet titled "Changes from previous run" in the "final" version of a year
and scroll down to ~row 65, you will see the total assessments from each step in the calculation
as well as the changes due to each step and the amounts to be funded by the colleges and by the campus.
|
New methodology: calculate undergraduate tuition revenue based on weighted Calendar Year IUs
 2007,2008 IUs 07/23/09
2006,2007 IUs 04/22/08
2005,2006 IUs revised 12/7/07
2004,2005 IUs 1/30/07
2003,2004 IUs 1/30/07
Previous methodology: calculate tuition revenue based on IUs
The IUs generated by each college and department are shown by term.
For 95-96 and 96-97, the "cost recovery" IUs were not subtracted, so they are
shown in the sheet costrec.xls.
For 97-98 and later years, the cost recovery
IUs are subtracted. For 99-00, the spreadsheet has the same format as the
final spreadsheets used by OBA, with two years of data and percentages computed.
Starting in 2000-01, the terms used were shifted back from a year that ended in Spring to a
year that ended in Fall.
Revenue per IU taught, FY00 to FY09
Spreadsheets used to calculate tuition revenue based on graduate and undergraduate enrollment.
Tuition assessment and waiver information by college and department is shown for each term listed below.
Notes on these spreadsheets
|
|
For detailed listings of graduate and professional tuition assessed and waived
by student, check out our web site at
https://www-s.dmi.illinois.edu/tw/. This is a secure
site; persons with a UIUC logon can see summary reports, but detail reports are open only to department heads,
college deans, and college business managers.
Data are available at that site from Fall, 1997 on. |
Spreadsheets with tenure-system faculty counts for revenues generated by faculty counts
College totals for October 1996 and 1997 are included in the '98 spreadsheet; ten years, ending on October 1998 are in the '99 spreadsheet.
bdgref/default.asp
Last Updated 1/27/07
|
|
