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.
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).
The top widgets highlight the Tuition Revenue, Instructional Cost, Contribution Margin, and Contribution Margin Percentage.
- 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.
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.
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.
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.
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
Groups values by Term and Course
Groups values by Term and Section