Transcript Budget Calendar and Mid-Year Review

Budget Calendar and
Mid-Year review
Mary Simon, Senior Budget Director
March 23, 2016
AGENDA
• 2017 Budget Planning Calendar
• Trend - Paying Semester Credit Hours (SCH)
• Tuition and Student Fee Revenue Projections
• Revenue Projections and Assumptions
• Budget Planning – Revenue & Expense
• Hyperion Public Sector Planning & Budgeting (PSPB)
• Q&A
20172017
Budget
Planning
Calendar Calendar
Budget
Planning
March 15
Mid-Year 2016 Revenue Adjustments Coordinated with Fee Administrators
March 23
Planning Calendar to Financial Area Reps (FAR)
April 1
Draft 2017 Revenue Projections provided to Fee Administrators
April 4
Hyperion PSPB – OPENS to “Area Budget Coordinators” - Budget 2017
April 4
Benefits Template posted to website and Non-E&G Longevity Report information
Apr 4 –Apr 7
Hyperion PSPB Budget Training to Area Budget Coordinators (**closed enrollment**)
TBA - Areas
Internal Department Deadlines coordinated by VP Areas for Hyperion Data Review
April 8
Draft Debt Service Budgets provided to Financial Area reps
April 8-12
Hyperion PSPB Hands on training to Area Budget Coordinators (**closed enrollment**)
TBD
CMO meeting to review FY17 Revenue projections; Resources & Requirements
April 15 - 22
Preparation for UT System Budget Goals & Priorities Hearing
April 22
UT System / UTSA Budget Goals & Priorities Hearing
April 25
Hyperion PSPB – CLOSES to “Area Budget Coordinators” - Budget 2017
April 21-27
Hyperion PSPB – Reconciliation by Primary Area Reps – Budget 2017
April 25 - 29
Hyperion PSPB – Reconciliation by Central Budget Office – Budget 2017
TBD
Hyperion Smartview Training for reporting (**closed enrollment**)
May 20
Draft FY17 Operating Budget due to UT System
June 10
Final FY17 Operating Budget due to UT System
Aug 25
FY17 Operating Budgets approved by Board of Regents
Trend - Paying Semester Credit Hours
(SCH in thousands)
800
728.0
700
4.8
65.3
25.4
600
713.6
4.9
61.8
32.0
669.9
669.9
672.3
4.1
59.6
4.4
59.3
28
4.1
57.5
20.5
31
500
Grad Non-Res
Grad Resident
400
300
632.5
UG Non-Res
614.9
575.2
578.2
590.2
FY 2014
FY 2015
FRCST FY 2016
200
100
0
FY 2012
FY 2013
UG Resident
FALL and SPRING comparison - Paying SCH
FALL 15
BUDGET
UG - Resident
FALL 15
Forecast (Cert.)
FALL 14
Certified
FALL over FALL
Incr. (Decr.)
% Change
284,291
283,577
281,710
1,867
0.7%
UG - Non-Resident
12,687
9,983
12,809
(2,826)
(22.1%)
G - Resident
20,281
20,736
20,153
583
2.9%
G - Non-Resident
2,074
1,931
2,040
(109)
(5.3%)
Doctoral - Resident
5,200
4,755
5,182
(427)
(8.2%)
149
174
134
40
29.9%
324,682
321,156
322,028
(872)
(0.3%)
Doctoral - Non-Resident
Total – Paying SCH
SPRING 16
SPRING 16
SPRING 15
BUDGET
Forecast (Prelim.)
Certified
SPRING over SPRING
Incr. (Decr.)
% Change
254,740
255,846
251,802
4,044
1.6%
UG - Non-Resident
12,194
8,141
11,826
(3,685)
(31.2%)
G - Resident
19,546
19,047
19,622
(575)
(2.9%)
G - Non-Resident
1,685
1,450
1,728
(278)
(16.1%)
Doctoral - Resident
4,688
4,277
4,688
(411)
(8.8%)
124
189
144
45
31.3%
292,977
288,950
289,810
(860)
(0.3%)
UG - Resident
Doctoral - Non-Resident
Total – Paying SCH
Tuition and Student Fee Revenue Projections
($000)
Budget
FY2016
Forecast
FY2016
$
Change
%
Change
$154,475
51,742
102,733
$149,361
47,900
101,461
($ 5,114)
(3,842)
(1,272)
(3.3%)
(7.4%)
(1.2%)
294
290
(4)
(1.3%)
$71,817
44,504
27,313
$71,800
44,500
27,300
($17)
(4)
(13)
(.02%)
(.01%)
(.05%)
TOTAL Incidental Student Fees
Designated Program, Course Fees
Auxiliary Student Parking
Tuition and Student Fees
LESS: Tuition Set Asides
$20,104
16,073
4,031
$246,690
(15,412)
$21,700
17,700
4,000
$243,151
(15,317)
$1,596
1,627
(31)
(3,539)
95
7.9%
10.1%
(0.8%)
(1.4%)
0.6%
NET Tuition and Student Fees
$231,278
$227,834
(3,444)
(1.5%)
TOTAL Tuition
Statutory Tuition
Designated Tuition
Lab & Supplemental Fees
TOTAL Mandatory Student Fees
Designated - Mandatory Fees
Auxiliary - Mandatory Fees
Note: Forecast based on PAYING SCH Certified FALL, Prelim. SPRING and Estimated SUMMER
Revenue Projections & Assumptions
Mid Year FY 2016 and Budget 2017
Methodology:
•
Revenue projections are based on Paying SCH and/or student headcount (i.e.
Mandatory fee projections).
•
Paying SCH Total 672,358 based on Certified FALL 15, Preliminary SPRING 16 and
SUMMER 16 (estimated higher than 2015; at 2014 SUMMER Levels)
•
Incidental Fee projections are under review and will be based on trend analyses
Full Year Forecast FY 2016
• Budget adjustments will be recorded for Mandatory and Incidental Fees based on
current projections recorded in March 2016
• Fee Administrators & Area Reps will be notified in early April following latest file
for Paying SCH pre-certified data
Operating Budget 2017
• Tuition and Mandatory Fee Budgets will be based on current forecasted projections
• Incidental Fee Budgets will be reviewed and recommendations as provided
• Any deviations to projections will need to be discussed and approved by AVP-FA
Expense Budgets - Status Quo Budgets
Departmental accounts funded with Designated TUITION
• Status Quo Base Budgets
– Departmental Operating budget preparation assumes no new money,
i.e. ‘same base budgets’
– Budget Development process begins before budget planning is
complete
– CMO will review recommendations for tuition, fees and semester
credit hour projections
• Budget Office will update Hyperion Annual Operating budget
for impacts based on final CMO allocations
Exception: Budgets funded by fees will be coordinated with areas should
estimates be further modified.
Hyperion for Budget 2017 (1 of 2)
Public Sector Planning & Budgeting (PSPB)
– UT Share Hyperion-Public Sector Planning & Budgeting (PSPB)
used for developing Budget 2017 (2nd Year)
– Budget Development will be semi-centralized with Area Budget
Coordinators identified by VP Areas
•
•
•
•
Approximately 75 Budget Area Coordinators
UTSA is only campus with update access to Department Area Budget Coordinators
Area Budget Coordinators will review, reconcile and update final budgeted amounts
Final Budget reports will be provided using SmartView reporting capabilities by Area
Budget Coordinators working with the Budget Office
– Hyperion PSPB planning tool is a flexible web based application
• Base Line Budget will be established using Budget 2016 + Permanent Transfers
• System is loaded with PeopleSoft FMS and HCM budgetary funded position data, reflecting
the latest salaries upon data load
• Position attributes (i.e. FTE, % funding distribution, etc.) are used to calculate budgets
• Non-transactional based system and will reflect ending balances by cost center
• Subsequent permanent position updates in HCM require updates in Hyperion system to
reflect changes processed in PeopleSoft HCM.
Hyperion for Budget 2016 (2 of 2)
Public Sector Planning & Budgeting (PSPB)
– Training will be provided by Central Budget to Area Budget Coordinators
• Hyperion training materials will be provided and posted to Budget Website
• Central Budget will send announcements to Area Budget Coordinators
– Budget Office will provide preliminary reports to Area Budget
Coordinators
• Report data will assist in the review of Hyperion data following training
• Reports to include Original Budgets, Permanent Positions and Permanent transfer
data by cost center
– Reporting will be downloadable to MS Excel by Area Budget Coordinators
using Hyperion Smartview
• Hierarchical reporting capabilities (department hierarchy; roll up by VP)
• MS Excel spreadsheets will display positions and comparative Budgets
• Decentralized reporting with flexible report formats (i.e. groupings by Fund,
Department and Cost Center)
• Area Budget Coordinators will coordinate and distribute final budget reports using
Hyperion Smartview to Department Administrators