Budget Summary

Introduction

The purpose of the Budget Summary is to provide a high-level overview of the total TI/TA budget and total salary recovery for your department and faculty in any one given fiscal year. This page requires the completion of the TI Budget Worksheet, TA/TM Budget Worksheet and Salary Recovery Worksheet. After a review and approval of the budget summary, the budget is submitted into Hyperion.

In the following section, you will learn how to do the following:

Understand the components that make up the Budget Summary
Understand how to find important information that you need in order to do your job

How to Navigate the Budget Summary

The Budget Summary consists of three components: filter, quick visuals and results table. The filter allows the user to narrow down information that appears on quick visuals and the results table. Quick visuals uses statistic cards and charts to provide a quick reference on the budget and salary recovery for each faculty and department. The results table expands on the information provided in quick visuals.

Filter

Filter

Description

Fiscal Years

Narrows down the budget to show one fiscal year

Example: 2023-2024

Faculties

Narrows down the budget to show one faculty

Example: Faculty of Applied Sciences

Schools/Departments/Programs

Further narrows down the budget to one or more Schools/Departments/Programs

Example: School of Computing Science (CS)

The fiscal year will be pre-set to the current period. Furthermore, the faculty will be pre-set according to the user. The Schools/Departments/Programs field will reflect the areas under the selected faculty. One or more options can be selected at once from the Schools/Departments/Programs field.

Quick Visuals

Quick visuals includes both statistic cards and charts for quick reference. It appears below the filter on the page.

If changes are made to the worksheets, quick visuals will stay static and only updates after clicking filter.

Statistics Cards

From left to right, the statistic cards show the Grand Total, Total TI/TA Budget and Total Salary Recovery. It provides an overview in total dollar amounts. The Grand Total is calculated by deducting Total Salary Recovery from Total TI/TA Budget.

Charts

From left to right, there is a vertical bar graph that shows the total TI/TA budget for each department and a horizontal bar graph that shows the budgeted to allocated amounts for the faculty and each department. The vertical bar graph shows the colour-coded employment groups (ex: TSSU Instructor, Term Faculty Appointment, etc.) that make up the total TI/TA budget for each department. If you hover over the bar, it will show the budget and number of positions associated with each employment group. For the horizontal bar graph, the bar shows the relationship between budgeted to allocated amounts for the faculty and each department. If budgeted is lower than allocated, the bar will be blue. In contrast, if budgeted is higher than allocated, the bar will be red. Furthermore, if there is no set allocated amount, the bar will be, by default, also red. One or more departments may appear on the charts depending on the selection in the Filter.

Results Table

The results table provides an in-depth breakdown of the budget. It expands on the information provided in the statistic cards and charts of quick visuals.

Tabs

The results table is organized into tabs that cover the Faculty, External Funding Source, Department and Enrollment & AFTE. Click to filter by specific employment groups. Please refer below to see a description of the information contained in each tab:

Tabs	Description
Faculty	Totals at the faculty level. It includes information on the Projected Student AFTE and Projected Budget in each term and the fiscal year for the employment groups.
External Funding Source	Totals by External Funding Source. It displays similar information to the Faculty tab, but categorizes employment groups based on their external funding source.
Department	Totals at the department level. Click / / to see Projected Student AFTE and Projected Budget in percentage form of the faculty total.
Enrollment & AFTE	Projected enrollment and AFTE for each term and the fiscal year. Actual annual enrollment from a prior year is also available as a reference point.

Elements

Please refer below to see terms that are used in the tabs:

Elements	Description
Projected Enrollment	Estimate of the number of students taking courses.
Projected Student AFTE	Measure of the number of full-time equivalent students enrolled based on their course activity. Please refer here for more information.
Projected TI/TA Budget	Estimate of the budget size. This is influenced by the projected enrollment.

How to Find the Budget Summary

Head to the menu drop down under Budget Mgmt > TI/TA Budget Planner
Select Budget Summary

Table of Contents
1 Introduction 2 How to Navigate the Budget Summary 2.1 Filter 2.2 Quick Visuals 2.2.1 Statistics Cards 2.2.2 Charts 2.3 Results Table 2.3.1 Tabs 2.3.2 Elements 3 How to Find the Budget Summary

Module Topics