How Scotch College Balanced Staffing Costs and Confidence with Solver


Company: Scotch College
Industry: Education, Nonprofit
ERP: N/A
Use Case: Planning (Budgeting & Forecasting), Reporting


Scotch College_Case Study

“We now have confidence in our financial and workforce planning reports. Just as importantly, our users now have the flexibility to modify reports quickly to suit their purposes, without waiting for help from IT.”

Ian Anthony, CFO, Scotch College

From Manual Reporting to Self-Service Planning

The Problem

Scotch College needed a way to build realistic budgets and staffing schedules that gave every school activity proper coverage. Its existing HR and payroll data made staffing costs and schedules difficult to manage accurately.

The Solution

After evaluating several planning solutions, Scotch College chose Solver for its intuitive interface and its ability to let administration manage templates and reports without relying on finance or IT. Implementation partner Access Analytic supported the rollout.

The Result

Scotch College now manages workforce, enrolment, and financial reporting directly, with users building and adjusting reports on their own. Adoption has expanded beyond the original CEO and CFO users, and the school is exploring Power BI dashboards next.