Budget Resources

 

Integrated and Value-Centered Budgeting (IVCB)

Integrated and Value-Centered Budgeting (IVCB) is the framework for the guiding principles for colleges to define their direction and allowing the campus to strategically invest. These principles will be integrated with the campus strategic priorities and support all mission areas. The framework provides flexibility and transparency to allow for investments at both college and university levels to support our values and the University-wide excellence. For more information, please see the Provost site here.

IVCB Budget Statement (Authorized Users Only)

IVCB Budget Statement includes college-level budget and supporting statements, unit-level budget calculation, along with the parameters used to calculate the annual budget. Restricted to authorized users only. Contact the Office of Budget and Resource Planning with questions or to request access. Please follow the link below for the Statement, which will open in a new window and have filters to interact with.

IVCB Supporting Dashboards(Requires Login)

The IVCB supporting dashboards provide a detailed structure of underlining data elements used to calculate the annual budget. Please select a dashboard from the options below. The dashboard will open in a new window and have filters to interact with.

More IVCB information can be found on the IVCB information page.
Feedback may be submitted via the IVCB Dashboard Suggestion Form.


 

Below are Excel spreadsheets used to calculate undergraduate tuition revenue based on
   Enrollment by Residency & Full-time/Part-time Status and IUs by Course Level

      Notes on these spreadsheets

Fall-Spring 10-Day Enrollment by Residency & FT/PT (PN2009/018) Summer, Fall, Winter, Spring IUs by Course Level (PN2009/019)
2023-24
2022-23
2021-22
2020-21
2019-20
2018-19
2017-18
2016-17
2015-16
2014-15
2013-14
2012-13
2011-12
2010-11
2009-10
2008-09
2007-08
2006-07
2005-06
2004-05
2023-24 Preliminary
2022-23
2021-22
2020-21
2019-20
2018-19
2017-18
2016-17
2015-16
2014-15
2013-14
2012-13
2011-12
2010-11
2009-10
2008-09
2007-08
2006-07
2005-06

 

Below are spreadsheets used to calculate tuition revenue based on graduate & undergraduate enrollment.

Tuition assessment and waiver information by college and department is shown for each term listed below. Notes on these spreadsheets

2023 2022 2021 2020 2019 2018 2017 2016 2015
WI23
SP23
SU23
WI22
SP22
SU22
FA22
WI21
SP21
SU21
FA21
WI20
SP20
SU20
FA20
WI19
SP19

FA19
WI18
SP18
SU18
FA18
WI17
SP17
SU17
FA17
WI16
SP16
SU16
FA16
WI15
SP15
SU15
FA15
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

  • 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

(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 2008,2009 IUs 04/27/10
2007,2008 IUs 2007,2008 IUs 07/23/09
2006,2007 IUs 2006,2007 IUs 04/22/08
Excel Icon 2005,2006 IUs revised 12/7/07
Excel Icon 2004,2005 IUs 1/30/07
Excel Icon 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.

Excel IconRevenue per IU taught, FY00 to FY09

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

Excel Icon TENFAC03.XLS 48 Kb May 17 22:44 2003
Excel Icon TENFAC02.XLS 39 Kb Mar 28 15:55 2002
Excel Icon TENFAC01.XLS 40 Kb Mar 07 03:23 2001
Excel Icon TENFAC00.XLS 42 Kb Mar 15 02:48 2000
Excel Icon TENFAC99.XLS 21 Kb May 28 02:06 1999
Excel Icon 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 2022-09-09