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

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

A&F Executive Dashboard

2

A&F Roadmap: Underlying Principles

Independent and objective assurance that analyzes data, processes, policies and controls Reliable, timely information that is accessible and understandable Standard processes designed to provide reasonable assurance regarding the achievement of objectives Systematic approach to identifying, assessing and managing risks across the

• rganization

3



5-Year Forecast



Historic Trend Analysis



Enrollment Tracking



Performance Indicators



Peer Benchmarking



Credit Rating Stabilization



Cost and Margin Analytics – per student and FTE; by commodity



New Budget & Forecasting Application



Enhance Quarterly Reporting



A&F Executive Dashboard 1.0



We Are Better Together Business Process Redesign (BPR)



Efficiency & Effectiveness 2.0



Enterprise Risk Management



Talent assessment/acquisition



Policies and procedures development



Agreed Upon Procedures/Operational Review – 3rd party audit firm

A&F Roadmap: The Plan

Operational Improvements Strategic Analysis

4

5-Year Forecast:



More details on revenue & expenses



Program Area view of revenue & expenses



Trend Analysis



Enhanced Enrollment Tracking Performance Indicators:



Debt Service Coverage



Operating Cash Flow Margin Peer Benchmarking:



Comparing peer ratios



Researching best practices for policies New Budget & Forecasting Application



RFP Released Enhance Quarterly Reporting:



FY17 Q1-Q4 reports completed



Consistent formatting developed



Analysis of variances from Q3 to year end completed A&F Executive Dashboard 1.0:



Revenue & Expenses targeted for use in Q2 reporting



Employee and student data being developed



Integrating capital costs from UMBA Enterprise Risk Management:



Convened first annual summit



Confirmed key risks; Documented mitigation strategies

A&F Roadmap: Miles Traveled

Operational Improvements Strategic Analysis

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

A&F Roadmap: Upcoming Intersections

Getting Started

 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 6

A&F Executive Dashboard Working Group Members

 Shahriar Panahi, UITS  John Munroe, UITS  Amy Cummings, UITS  Val Zicko, UITS  Bill Manteiga, UITS  Laura Prudden, UITS  Pam Theodore, UITS 7  LeeAnn Pasquini, A&F

President’s Office (Budget)

 Vicky Berg, A&F President’s

Office (Budget)

 Eric Gregoire, A&F President’s

Office (Budget)

 Carol Dugard, A&F President’s

Office (HR)

 Barbara Cevallos, A&F

President’s Office (Controller)

Project Work-Streams

 Build Wireframe

• Develop inventory of

metrics

• Identify data

sources; PeopleSoft

• Create a sketch of

graphs and charts

8

 Dashboard Design

• Finalize graphics

and layout

• Develop designs for

detail tabs

• Test and validate

 Finance Reconciliation

• Internal reconciliation

for FY16 actuals

• Examine Financial

reporting trees

• Meet with campuses

to identify issues

• Load FY18 BOT budget

10

Revenue & Expense Details

11

Non-Personnel Expenses

12

Future Project Work-Streams

 Trending

• Loading board

reviewed 5-year financial forecast

• Improving graphic

displays & testing

13

 Student Enrollment

• Identifying key

student metrics

• Student demand

data; new vs continuing students

• Cost per student

analytics to be developed

 Employee FTE

• Using BPR EE FTE

reporting team

• Draft wireframe

developed

• Final

recommendations due this winter

Next Steps

 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 14