Financial Health Dashboard

Overview

Ad Astra’s Financial Health dashboard provides insight into the tuition revenue, instructional cost, and margin of your pathways for any given term(s). This perspective can help you understand the financial sustainability of your pathways.

 

How is Financial Health Calculated? 

Specific calculations for tuition revenue and instructional cost can be customized for your institution. By default, tuition revenue is calculated at $300 per credit hour, and the instructional cost is calculated at $1000 per credit hour. These can be customized by utilizing an importable spreadsheet to map the specific tuition per credit hour for your institution as well as instructor costs based on instructor types, or individual instructors.

Tuition revenue and instructional cost are allotted to specific pathways based on the enrolled students’ assigned pathways. For example, if ENGL 101 is being offered and the enrollment is comprised of 20 students in the English program, and 20 students in the History program, the tuition revenue for that course will be split between the English and History pathways (and the instructional cost will be split in the same manner).

 

The Financial Health Validation dashboard is a supplemental report to the Financial Health dashboard with additional data validation pivot tables.

 

The Financial Health Dashboard

The Financial Health dashboard is in the Ad Astra Report app under the Financial Health folder.

All widgets can be filtered using the filters on the right-hand side of the screen. There are multiple filterable dimensions.

  • Term
  • Pathway
  • Instructor Types
  • Modality
  • Campus
  • College
  • Department
  • Division
  • Subject
 

 

All widgets can be downloaded by clicking on the three-dot menu in the upper right corner of the widget. The type of data in the widget will determine what file type is available to export (.png, .csv, .pdf, .xlsx).

mceclip0.png

 

The top widgets highlight the Tuition Revenue, Instructional Cost, Contribution Margin, and Contribution Margin Percentage.

mceclip2.png

 

Tuition Revenue
The sum of revenue based on the configured tuition per credit hour input, course credit hours, and student enrollment offered in the selected term(s).
Instructional Cost
The sum of instructional cost based on configured cost per instructor credit hour and the courses offered in the selected term(s).
Contribution Margin
Calculated by taking the tuition revenue and subtracting instructional cost.
Contribution Margin Percentage
Calculated by taking the contribution margin and dividing it by tuition revenue.

 

Contribution Margin by Pathway and Contribution Margin % by Pathway Widget 

Contribution Margin by Pathway and Contribution Margin % by Pathway widgets bar graphs show the individual contribution margin and contribution margin percentage broken out by individual pathway.

mceclip4.png

 

Revenue vs Cost by Pathway Widget

Revenue vs Cost by Pathway widget is a scatter chart that shows the pathway-specific tuition revenue on the Y-axis and the pathway-specific instructional cost on the X-axis. This allows you to compare the revenue and costs of each pathway.

mceclip5.png

 

Contribution Margin by Pathway Pivot Table

The Contribution Margin by Pathway pivot table shows the tuition revenue, instructional cost, contribution margin, and contribution margin % by pathway.

mceclip6.png

 

Contribution Margin Interactive Column Chart

The Contribution Margin Interactive column chart shows the contribution margin by various categories. Right-clicking on a bar and choosing "Select Dimension" will allow you to switch the grouping between pathway, subject, college, department, instructor type, and campus.

mceclip10.png

 

Tuition Revenue Pivot Tables

The final three pivot tables on the dashboard will show revenue and cost information grouped by various categories. 

Groups values by Term, Section, Pathway, and Instructor Type

mceclip8.png

Groups values by Term and Course

mceclip0.png

Groups values by Term and Section

mceclip1.png


Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.