Budget Spreadsheets - Management Information - University of Illinois at Urbana-Champaign


	Budget Reform Spreadsheets

These files are all in Excel, version 5.0 or Office 97 Excel.

Other budget resources:

Provost's Comunication #1: Budgetary Principles and Practice
Historical documents related to Budget Reform: no longer available electronically
Business Affairs Budget Office

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.
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 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.

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 IUs

 2006-07 IUs   04/22/08
 2005-06 IUs   revised 12/7/07
 2004-05 IUs   1/30/07
 2003-04 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 FY05

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.uiuc.edu/course. This is a secure site open only to UIUC faculty, staff, and students.

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

2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995

SP08 (preliminary)

SP07

SU07
FA07

SP06

SU06
FA06 SP05

SU05
FA05
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://www-s.dmi.uiuc.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.

  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