Quick guide to divisional budget planning tool undergraduate dbpt ug
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

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


  • 74 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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

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.


Starting the model

Starting the Model

  • Before starting the tool please refer to the following website for instructions

    http://individual.utoronto.ca/hsiangan/dbpt/


Main user sections within the model

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.


Incremental input section

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


Incremental input section1

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


Other automatic assumptions

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


Other automatic assumptions list of variables built into tool

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


Other automatic assumptions list of variables built into tool1

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


Other automatic assumptions list of variables built into tool2

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)


Other automatic assumptions list of variables built into tool3

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)


Results

6

1

2

3

4

5

Results


Results legend

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.


Future developments

Future Developments

  • Graduate:

    • To develop a similar tool


Appendix supplementary background materials

Appendix: Supplementary Background Materials


Supplementary sections

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.


Quick guide to divisional budget planning tool undergraduate dbpt ug

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


Quick guide to divisional budget planning tool undergraduate dbpt ug

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


Quick guide to divisional budget planning tool undergraduate dbpt ug

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


  • Login