Your client is Hogwarts University. Their President, Dr. Albus Dumbledore, is concerned with the university’s profitability and needs your help in determining the best course of action.
Case Prompt:
Sample Structure
Q2.) Given the five year enrollment information in Exhibit 1, what do you believe to be the cause?
Provide Exhibit 1 to the candidate. Once the candidate identifies the decline, ask them to brainstorm possible reasons for the drop. Then, push them to determine what additional information they would require to calculate the breakeven goal by year 3 as requested by President Dumbledore?
The candidate should immediately notice that enrollment is declining and determine the drop in student enrollment between 2018-2022 is ~12% decline ([10.7-9.4]/9.4).
Brainstorms reasons for the drop in enrollment should include reasons such as:
- Lack of in-demand course offerings
- No online or hybrid courses for remote students
- Few notable or famous professors
- Poor student facility upkeep
- Low athletic offerings or performance
- Tuition too high
- Low ROI on degree
Additional information to determine the breakeven point of students will require revenue and cost per student.
Q3.) Given the current financial situation, Dr. Albus Dumbledore wants to know how many more students need to be admitted to breakeven?
Provide Exhibit 2 to the candidate. Once the candidate has calculated correctly, push them towards ideas on how to prevent the ongoing enrollment drop.
Calculate the current total expenses of Hogwarts University. You may assume all costs are fixed and will not grow with enrollment.
Following the calculation of total expenses, you require this number to calculate the enrollment gap to breakeven.
Upon calculating, push towards ideas as to how to prevent the ongoing drop in enrollment and begin to grow toward the target enrollment number to achieve breakeven.
Total Expenses: $6,000 cost per student * 9,400 student enrollment = $56,400,000
Revenue per Student: $6,000 * 80% = $4,800
Total Revenue: $4,800 tuition * 9,400 students enrolled = $45,120,000
Financial Deficit: 56,400,000 total expense – 45,120,000 total revenue = -$11,280,000
Number of Students to Breakeven: $11,280,000 deficit / $4,800 revenue per student = 2,350
Q4.) Given the interests of U.K. students seen in Exhibit 3, which program(s) should Hogwarts University pursue?
Provide Exhibit 3 to the candidate.
There are several attractive programs based on the 3-year CAGR: Data Analytics (105k at 17%) has high growth, but a low number of students, Health Care (333k at 2%) has a high number of students, but low growth and Computer Science (266k at 9%) has high growth with a high number of students. Ensure the selection aligns with Hogwarts’ 3-year emphasis on breakeven.
Each of these 3 programs works and calculate the exact projections of each program by the 3-year mark (use a simple growth calculation vice a compound, year over year growth).
To achieve Hogwarts’ breakeven goal, can calculate what % of the market they should obtain.
After determining the specific program, recognize that offering an online/hybrid option would be most appropriate given level of interest (and today's climate).
3 year projections including growth rate
- Data Science: 105,000 * 1.17 = 122,850 or 120,000
- Health Care: 333,000 * 1.02 = 339,660 or 340,000
- Computer Science: 266,000 * 1.09 = 289,940 or 290,000
Market share obtainment to reach breakeven goal
- Knowing the target for breakeven requires an increase in revenue of $11,280,000 will require an additional 2,350 students
- Data Science: 2,350 / 120,000 = ~2% market share
- Health Care: 2,350 / 340,000 = ~1%
- Computer Science: 2,350 / 340,000 = ~1%.
Q5). What factors should Hogwarts University consider in pursuing a new program?
Understanding that initiating a new program is inherently risky, so make sure to be leaning into ideas for how Hogwarts can proactively hedge against the cons of opening a new program (i.e. starting out only online to minimize the costs and extract the best methods for teaching the course through competitive universities).
Push the candidate to structure their ideas if they do not do so automatically.
Q6.) Dr. Albus Dumbledore is ready for your final recommendation, what do you conclude Hogwarts should do?
Recommendation:
•Hogwarts University should create a Computer Science program that offers an online/hybrid option because of the 9% project CAGR for the program that is already substantial in size. For Hogwarts to reach its breakeven goal, the university will need to obtain 1% market share of the Computer Science market.
Risks:
•Hogwarts may lack the existing IP to create the program forcing them to raise costs by hiring more professors
•The projected growth for Computer Science is not guaranteed to last and might be surpassed by Data Analytics 5-10 years out
Next Steps:
•Assess Hogwarts’ current IP capabilities to determine if more professors are necessary and how much the program will cost to implement
ProfitWizardry: Maximizing Hogwarts University's Magical Margins
i