A&F Executive Dashboard Presented: Summit Summit: December 7, - PowerPoint PPT Presentation

A&F Executive Dashboard Presented: Summit Summit: December 7, 2018 A&F Vice Chancellors: December 8, 2017

A&F Roadmap: Underlying Principles 2 Independent and objective Standard processes designed assurance that analyzes to provide reasonable data, processes, policies assurance regarding the and controls achievement of objectives Reliable, timely Systematic approach to information that is identifying, assessing and accessible and managing risks across the understandable organization

A&F Roadmap: The Plan 3 Operational Improvements Strategic Analysis Enhance Quarterly Reporting 5-Year Forecast   A&F Executive Dashboard 1.0 Historic Trend Analysis   We Are Better Together Business Enrollment Tracking   Process Redesign (BPR) Performance Indicators  Efficiency & Effectiveness 2.0  Peer Benchmarking  Enterprise Risk Management  Credit Rating Stabilization  Talent assessment/acquisition  Cost and Margin Analytics – per  Policies and procedures development student and FTE; by commodity  Agreed Upon Procedures/Operational New Budget & Forecasting   Review – 3rd party audit firm Application

A&F Roadmap: Miles Traveled 4 Operational Improvements Strategic Analysis Enhance Quarterly Reporting: 5-Year Forecast:  FY17 Q1-Q4 reports completed  More details on revenue & expenses  Consistent formatting developed  Program Area view of revenue & expenses  Analysis of variances from Q3 to year end completed  Trend Analysis A&F Executive Dashboard 1.0:  Enhanced Enrollment Tracking  Revenue & Expenses targeted for use in Q2 Performance Indicators: reporting  Debt Service Coverage  Employee and student data being developed  Operating Cash Flow Margin  Integrating capital costs from UMBA Peer Benchmarking: Enterprise Risk Management:  Comparing peer ratios  Convened first annual summit  Researching best practices for policies  Confirmed key risks; Documented mitigation New Budget & Forecasting Application strategies  RFP Released

A&F Roadmap: Upcoming Intersections 5 Employee FTE Reporting:  Consistent campus reporting by funding source and type of employee  Cost and margin analytics Student FTE Reporting:  Developing methodology to identify online student FTEs Efficiency & Effectiveness 2.0:  Improved process for sustained E&E effort including shared services opportunities  Developed dashboards;  Reviewing methodology for capturing and reporting data Reserve Planning:  Developed approach and guiding principles to support more consistent and transparent reporting

Getting Started 6  Why an Executive Dashboard?  Using PeopleSoft system for live reporting  Avoids pushing & pulling spreadsheets  Analysis anytime, not just for quarterly reports  Previous efforts on developing an Executive Dashboard at UMass  Launched project in April 2017 as part of A&F Roadmap

A&F Executive Dashboard Working Group Members 7  LeeAnn Pasquini, A&F  Shahriar Panahi, UITS President’s Office (Budget)  John Munroe, UITS  Vicky Berg, A&F President’s  Amy Cummings, UITS Office (Budget)  Val Zicko, UITS  Eric Gregoire, A&F President’s  Bill Manteiga, UITS Office (Budget)  Laura Prudden, UITS  Carol Dugard, A&F President’s  Pam Theodore, UITS Office (HR)  Barbara Cevallos, A&F President’s Office (Controller)

Project Work-Streams 8  Build Wireframe  Finance Reconciliation  Dashboard Design Develop inventory of Internal reconciliation Finalize graphics • • • metrics for FY16 actuals and layout Identify data Examine Financial Develop designs for • • • sources; PeopleSoft reporting trees detail tabs Create a sketch of Meet with campuses Test and validate • • • graphs and charts to identify issues Load FY18 BOT budget •

10

Revenue & Expense Details 11

Non-Personnel Expenses 12

Future Project Work-Streams 13  Trending  Employee FTE  Student Enrollment Loading board Using BPR EE FTE Identifying key • • • reviewed 5-year reporting team student metrics financial forecast Draft wireframe Student demand • • Improving graphic developed data; new vs • displays & testing continuing students Final • recommendations due Cost per student • this winter analytics to be developed

Next Steps 14  Brief demo to VC’s on 12/8 as part of the month AFC meeting  Access provided in the test environment campus key stakeholders by the end of December  Official launch of the revenue and expenses at the January in person Budget Director meeting  Use of the YTD revenue & expenses for Q2 reporting