Budget Reform

These files are all in Excel.

Other budget resources:


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
Fall-Spring 10-Day Enrollment by Residency & FT/PT (PN2009/018) Summer, Fall, Spring IUs by Course Level (PN2009/019)
Fall 2016 (preliminary) Spring 2017 (preliminary)
2015-16
2014-15
2013-14
2012-13
2011-12
2010-11
2009-10
2008-09
2007-08
2006-07
2005-06
2004-05
Fall 2016 (preliminary) Spring 2017 (preliminary)
2015-16
2014-15
2013-14
2012-13
2011-12
2010-11
2009-10
2008-09
2007-08
2006-07
2005-06

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
2015 2016 2017
WI15
SP15
SU15
FA15
WI16
SP16
SU16
FA16
WI17
2014 2013 2012 2011 2010 2009 2008 2007 2006 2005
SP14
SU14
FA14
SP13
SU13
FA13
SP12
SU12
FA12
SP11
SU11
FA11
SP10
SU10
FA10
SP09
SU09
FA09
SP08
SU08
FA08
SP07
SU07
FA07
SP06
SU06
FA06
SP05
SU05
FA05
2004 2003 2002 2001 2000 1999 1998 1997 1996 1995
SP04
S104
S204
FA04
SP03
S103
S203
FA03
SP02
S102
S202
FA02
SP01
S101
S201
FA01
SP00
S100
S200
FA00
SP99
S199
S299
FA99
SP98
S198
S298
FA98
SP97
S197
S297
FA97
SP96
S196
S296
FA96

S195
S295
FA95

For detailed listings of graduate and professional tuition assessed and waived by student, check out our web site at https://secure.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.



Budget Reform Modification for FY05

(Notes from Bill Adams, 5/13/04, subject to change.)


New methodology: calculate undergraduate tuition revenue based on weighted Calendar Year IUs

2008,2009 IUs 04/27/10
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

2005-06 IUs 345 Kb Mar 24 16:09 2006
2004-05 IUs 350 Kb May 7 22:15 2005
2003-04 IUs 322 Kb May 6 15:01 2004
2002-03 IUs 315 Kb May 17 22:33 2003
2001-02 IUs 308 Kb Mar 27 16:36 2002
2000-01 IUs 302 Kb Mar 08 23:25 2001
1999-00 IUs 298 Kb Apr 28 16:18 2000
1998-99 IUs 53 Kb Jun 07 14:57 1999
1997-98 IUs 53 Kb May 14 14:12 1998
1996-97 IUs 49 Kb Oct 28 00:00 1997
1995-96 IUs 49 Kb Oct 16 00:00 1997

For detailed listings of course sections paid for by your unit, check out our Course Reporting System web site at http://www.dmi.illinois.edu/course. This is a secure site open only to UIUC faculty, staff, and students.

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.

TENFAC03.XLS 48 Kb May 17 22:44 2003
TENFAC02.XLS 39 Kb Mar 28 15:55 2002
TENFAC01.XLS 40 Kb Mar 07 03:23 2001
TENFAC00.XLS 42 Kb Mar 15 02:48 2000
TENFAC99.XLS 21 Kb May 28 02:06 1999
TENFAC98.XLS 21 Kb Jun 10 16:33 1998

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.

Last Updated 9/11/14