300 likes | 429 Views
Student Number Planning. Adam Whittick Business Analytics Consultant. The Task…. “Create a Planning System to enable the University to accurately and reliably produce a 3 year student number forecast, with relevant FTE and Income values.”. The Task…. 10. The Existing Process….
E N D
Student Number Planning Adam Whittick Business Analytics Consultant
The Task… “Create a Planning System to enable the University to accurately and reliably produce a 3 year student number forecast, with relevant FTE and Income values.”
The Task… 10
The Existing Process… • Students – 19,500 • Registration Departments – 100+ • Programmes – 2,500 • Modules – 5,800 • Full Time / Part Time • Start Year • Fee Regime • Residence • Level of Study • Campus • Year of Programme
The Existing Process… Departments
Solution Functionality • Approval Hierarchy • Entry of intake figures • Personal Workspace/Sandbox • Submit/Approve/Reject • Commentary
New Process… Departments
Key Benefits • View effect on revenue real-time • Ease of reporting / analysis • Version snapshots & comparison • ‘What-if’ modelling via sandboxing • Visibility / transparency for users • Reduced reliance on single Excel model • Workflow for plan submission