1 / 19

Quick Guide to Divisional Budget Planning Tool – Undergraduate (DBPT-UG)

Quick Guide to Divisional Budget Planning Tool – Undergraduate (DBPT-UG). Purpose of the DBPT-UG. To assist divisions with preliminary multi-year enrolment and budget planning To enable divisions to explore different scenarios before narrowing down to 1 or 2 options

karlyn
Download Presentation

Quick Guide to Divisional Budget Planning Tool – Undergraduate (DBPT-UG)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Quick Guide to Divisional Budget Planning Tool – Undergraduate (DBPT-UG)

  2. Purpose of the DBPT-UG • To assist divisions with preliminary multi-year enrolment and budget planning • To enable divisions to explore different scenarios before narrowing down to 1 or 2 options • To integrate different components of overall planning: enrolments, tuition, revenues, University Fund contribution, student aid, staffing changes, space changes, and other university-wide costs.

  3. Starting the Model • Before starting the tool please refer to the following website for instructions http://individual.utoronto.ca/hsiangan/dbpt/

  4. Main User Sections Within the Model • Inputs_and_ResultsSection where divisions input their incremental plans and receive resulting projections • Other_Automatic_AssumptionsThis section provides a summary of the various additional assumptions used to generate the projections. Based on historical data.

  5. 1 2 3 4 Incremental Input Section [1] Faculty/Program [2] Full-time fall new intake [3] Domestic international percentage mix and mix calculator [4] 2008 Intake variance adjustment and resulting domestic/international headcount

  6. 5 6 7 8 Incremental Input Section [5,6,8] Domestic/International tuition fee rate increase factor and the resulting first year tuition fee [7] University-wide cost drivers

  7. Other Automatic Assumptions • This section automatically updates assumptions depending on the faculty/program selected • Most of these factors are derived from the P&B models used to project the annual budget numbers

  8. Other Automatic Assumptions – List of Variables Built into Tool • Tuition fee methodology (course, program) • Tuition increases for continuing students • The institutional fees write-off factor • Student aid provisions

  9. Other Automatic Assumptions – List of Variables Built into Tool • Fall year-to-year retention rates • Average course loading: conversion from headcounts to FTEs • Winter over fall retention

  10. Other Automatic Assumptions – List of Variables Built into Tool • Eligible FTE (EFTE) over Total FTE ratio • Formula fee rate (as per Ministry) • BIU Weight – Either Ministry value or blended average • BIU Value (as per Ministry)

  11. Other Automatic Assumptions – List of Variables Built into Tool • University-wide per unit costs • Undergraduate FTEs • Operating Revenue • Faculty FTEs • Administrative FTEs • Space: Net Assignable Square Meters (NASMs)

  12. 6 1 2 3 4 5 Results

  13. Results (Legend) [1] Starting Tuition Level: For most, tuition to be charged to year 1 students. For some programs with delayed entry, fee will be the year 2 rate. [2] Enrolment Results: The enrolment measures used to project revenues and costs [3] Net Revenue Available to the Division [4] Total Revenue, with domestic/international details [5] Cost Deductions [6] Rounding option checkbox, determine whether to round the values in the result section.

  14. Future Developments • Graduate: • To develop a similar tool

  15. Appendix: Supplementary Background Materials

  16. Supplementary Sections • Enrol_workingThis section contains the detailed steps translating the divisional inputs and automatic assumptions into the resulting enrolment, revenue, and cost projections. • Univ-wide CostsThis section displays the steps translating a per-unit cost for each driver into incremental University-wide cost allocations. Changes in enrolment and budget planning will have a material impact on cost allocations driven by NASMs, Student FTEs, and Staff FTEs. • PriceVarianceOnBase This section contains the detailed calculations for determining the revenue change related to existing enrolments as one modifies the tuition/price assumption.

  17. Main Differences Between Divisional Budget Planning Tool Undergraduate and the detailed P&B Budget Report Model

  18. Main Differences Between Divisional Budget Planning Tool Undergraduate and the detailed P&B Budget Report Model

  19. Main Differences Between Divisional Budget Planning Tool Undergraduate and the detailed P&B Budget Report Model

More Related