PLANNING Association of Business Administrators October 17, 2005 AGENDA Hyperion Planning Overview Project Organization Basic Design Considerations Status Update Outstanding Issues Health System Interface Users Training Timetable Communication Hyperion 86 of the Fortune 100 are customers 300 of the Fortune 500 are customers Hyperion in business over 23 years Products in use by over 9,000 companies 5,000+ using Essbase or Planning application for planning and forecasting #1 in Financial and Business Performance Management Applications #1 in Budgeting & Planning #1 Business Performance Mgt (03/2004) “Visionary” in Corporate Performance Management (10/2004) Hyperion’s Higher Ed Experience Why Hyperion Planning? • Market-leading product • Superior reporting and analytical capabilities • Packaged application • Scaleable • Customer support • Consistency of tools/learning curve • Capacity for future expandability Hyperion Planning Will Increase Capabilities Budgeting Current: Multiple budgeting files, time consuming New: One integrated system with Web or Excel input options. Long-term vision to have organizational metrics inform the plan Consolidation Current: Slow, inefficient New: Immediate consolidation available, users stay in system Analysis/Reporting Current: No real analytical or reporting tools in Pillar New: Real-time, powerful reporting and analytical tools Submission Current: Disconnected and redundant New: Integrated system eliminates manual redundant entry, improves workflow management, improves data integrity and lowers maintenance Forecasting Current: Can’t be done within plan New: integrated with plan: prior year actuals, current year budget and actuals Moving From Transaction Processing to Decision Support 100% Decision Support 80% 60% Reporting Consolidation 40% Transaction Processing 20% 0% Current To-Be Planning and Analysis On-Line Analysis Excel Briefing/Budget Books Line Item Detail Hyperion Essbase Web Forms Notes, Text and other Documentation Planning Data Warehouse •Drill-down to transaction detail Project Organization Sponsors/Owners Robin Beck Scott Douglass Bonnie Gibson ) Health System Sponsors/Owners Keith Kasper, Kathy Bramwell John Kilroy Project Organization Sponsors/Owners Robin Beck Scott Douglass Bonnie Gibson Advisory Board Bonnie Gibson, Chair Kathy Bramwell, SOM John Horn, Finance John Keane, Library Trevor Lewis , Wharton Eileen Mayko, Anbg. Ctr Janet Plantan, GSE Lisa Prasad, FRES Ramin Sedehi, SAS Peter Sepe, Business Srvs. Tom Stump, SEAS Greg Tausz, Finance Mary Lee Brown, Audit Bill Turner, VPUL Jeanne Curtis, ISC TBD, Provost Office Mike Harris, EVP Health System Sponsors/Owners Keith Kasper, Kathy Bramwell John Kilroy Project Organization Sponsors/Owners Robin Beck Scott Douglass Bonnie Gibson Health System Sponsors/Owners Keith Kasper, Kathy Bramwell John Kilroy Advisory Board Bonnie Gibson, Chair Kathy Bramwell, SOM John Horn, Finance John Keane, Library Trevor Lewis , Wharton Eileen Mayko, Anbg. Ctr Janet Plantan, GSE Lisa Prasad, FRES Ramin Sedehi, SAS Peter Sepe, Business Srvs. Tom Stump, SEAS Greg Tausz, Finance Mary Lee Brown, Audit Bill Turner, VPUL Jeanne Curtis, ISC TBD, Provost Office Mike Harris, EVP Project Management/Core Team Fran Seidita: Budget Office Amy Miller: ISC Roxanne Bataitis: Financial Systems Consultants ISC Staff Budget Office Staff Finance Staff (Comptroller, Training, Systems) School and Center Staff Health System Mgmt/Core Team (Liaison TBD) Basic Design Considerations Implementation of Penn’s Chart of Accounts Nomenclature: Scenarios and Versions Time Periods Methodology for Pre-populating Forecasts Detailed Salary Planning Implementation of Penn’s Chart of Accounts ORG-Program-CREF Funds and Groups RCM Rows Potential Budget Entry Form 0 Budget Expense in General Purpose Funds ORG FUND Actual FY05 Expand Expand Expand Expand Expand Expand EXPENSES Academic Salaries Non-Academic Salaries Total Salaries & Wages Employee Benefits Total Compensation Current Expense Travel & Entertainment 5200 Faculty Domestic Travel Supplies and Minor Expense Non-Capitalized Equipment Rentals & Leasues Debt Service Capital Funding Other Capital Transactions Student Expense Total Direct Expenditures Expense Credits Total Direct Exp. After Expense Credits Budget FY06 PROG Forecast Budget FY06 FY07 CREF Budget FY08 Budget FY09 GO Potential Budget Entry Form 0 Budget Expense in General Purpose Funds ORG FUND Actual FY05 Expand Expand Expand Expand Expand Expand EXPENSES Academic Salaries Non-Academic Salaries Total Salaries & Wages Employee Benefits Total Compensation Current Expense Travel & Entertainment 5200 Faculty Domestic Travel Supplies and Minor Expense Non-Capitalized Equipment Rentals & Leasues Debt Service Capital Funding Other Capital Transactions Student Expense Total Direct Expenditures Expense Credits Total Direct Exp. After Expense Credits Budget FY06 PROG Forecast Budget FY06 FY07 CREF Budget FY08 Budget FY09 GO Potential Budget Entry Form 1 Budget Expense in General Purpose Funds ORG-PROG-CREF FUND Actual FY05 8300-7000-1234 Expand Expand Expand Expand Expand Expand EXPENSES Academic Salaries Non-Academic Salaries Total Salaries & Wages Employee Benefits Total Compensation Current Expense Travel & Entertainment 5200 Faculty Domestic Travel Supplies and Minor Expense Non-Capitalized Equipment Rentals & Leasues Debt Service Capital Funding Other Capital Transactions Student Expense Total Direct Expenditures Expense Credits Total Direct Exp. After Expense Credits Budget FY06 FUND 000000 GO Forecast FY06 Budget FY07 Budget FY08 Budget FY09 Potential Budget Entry Form 2 Budget Revenue in General Purpose Funds OBJECT FUND Actual FY05 OBJECT 4920 MISC INCOME ORG-PROG-CREF 8300-7000-1234 8300-7000-5678 8300-7000-9012 8300-7000 Total 8300-7110-1234 8300-7000-5432 8300-7110-9012 8300-7110 Total 8300 Total 8310-7000-1234 8310-7000-5678 8310-7000-9012 8310-7000 Total 8310-7688-6543 8310-7668-3456 8300-7668-9012 8300-7668 Total 8310 Total PROV TOTAL Budget FY06 FUND 000000 GO Forecast FY06 Budget FY07 Budget FY08 Budget FY09 Potential Budget Entry Form 3 Budgeted Revenue and Expense in Designated Funds ORG-PROG-CREF FUND Actual FY05 8300-7000-1234 Expand Expand Expand Expand Expand Expand Budget FY06 FUND 412345 REVENUE TOTAL EXPENSES Academic Salaries Non-Academic Salaries Total Salaries & Wages Employee Benefits Total Compensation Current Expense Travel & Entertainment 5200 Faculty Domestic Travel Supplies and Minor Expense Non-Capitalized Equipment Rentals & Leasues Debt Service Capital Funding Other Capital Transactions Student Expense Total Direct Expenditures Expense Credits Total Direct Exp. After Expense Credits 8300-7000-5678 FUND 412345 REVENUE TOTAL EXPENSES Academic Salaries Non-Academic Salaries CONTINUED for each ORG-PROG-CREF combination in selected fund… GO Forecast FY06 Budget FY07 Budget FY08 Budget FY09 Single Page Format FY 2007-FY 2011 Budget Planning Process All Funds Overview (a) ($000s) REVENUES Undergraduate Regular Tuition Guarantee Undergraduate Fin. Aid Guarantee UG Fin. Aid Incentive & Inv. Income Transfer Net Undergraduate Guarantee Undergraduate Special & Summer Tuition Undergraduate Special Fin. Aid Graduate & Professional Tuition Graduate & Professional Fin. Aid Special Programs Tuition General Fee Other Fees Total Net Tuition & Fees Investment Income Overhead--Investment Funds Total Investment Income Gift Income Overhead--Gift Funds Total Gift Income Grant & Contract Revenue Indirect Cost Recovery--Grant & Contract Total Sponsored Program Revenue Other Income (including Sales & Services) Total Direct Revenues Subvention Commonwealth Appropriation Total Subvention & PA Appropriation General Resource Transfers Bank & Other Transfers Funding from Allocated Costs Total Resource Transfers TOTAL REVENUES & TRANSFERS EXPENSES Academic Salaries Non-Academic Salaries Total Salaries & Wages Employee Benefits Total Compensation Current Expense Debt Service Capital Funding Other Capital Transactions Total Capital Transactions Student Aid Expense Total Direct Expenditures (less: Expense Credits) Total Dir. Exp. After Expense Credits Library Charges Facilities Maintenance Charges University Services & Development Charges Total Allocated Cost Charges TOTAL EXPENDITURES CURRENT-YEAR OPERATING (SUR)/DEF Final Year-End Adjustments Current Year Cash Effect--Other Activity CURRENT-YEAR CASH POSITION (SUR)/DEF Prior-Year Cash Position (Sur)/Def CUMULATIVE CASH POSITION (SUR)/DEF CENTER NAME (b) Actual FY02 (c) Actual FY03 (d) Actual FY04 (e) Orig. Bgt. FY05 (f) Actual FY05 (g) Orig. Bgt. FY06 Budget Schedule Page 1 (h) Y-E Proj. FY06 (i) Proposed FY07 (j) Proposed FY08 (k) Proposed FY09 (l) Proposed FY10 (m) Proposed FY11 Treatment of Student Aid Current (Ben Signs) Proposed (natural signs) Revenue (Tuition Income) (4100 - 4118) UG Aid (4181-4194) UG Aid Incentive (4195) UG Aid Endowment Trans (4196) Grad & Prof Aid (4180,82,84,85,86,90) Revenue Tuition Income Expense Compensation Teaching Assistant (5040) Research Assistant (5041) Research Fellow (5044) Teaching Fellow (5048) Teaching Assistant Summer (5049) Research Assistant Summer (5070) Expense Compensation Teaching Assistant (5040) Research Assistant (5041) Research Fellow (5044) Teaching Fellow (5048) Teaching Asst Summer (5049) Research Assistant Summer (5070) Predoc and Ed Fellow Student Aid Predoc Trainee and Ed Fellowship (5045-46) Tuition TA/RA/TF/RF (4187-89,4191,5360) Endowment Income UG Aid Endowment Trans Transfers UG Aid Incentive Student Aid UG Aid Grad & Prof Aid Tuition TA/RA/TF/RF Treatment of Student Aid Current (Ben Signs) Proposed (natural signs) Revenue (Tuition Income) (4100 - 4118) UG Aid (4181-4194) UG Aid Incentive (4195) UG Aid Endowment Trans (4196) Grad & Prof Aid (4180,82,84,85,86,90) Revenue Tuition Income Expense Compensation Teaching Assistant (5040) Research Assistant (5041) Research Fellow (5044) Teaching Fellow (5048) Teaching Assistant Summer (5049) Research Assistant Summer (5070) Expense Compensation Teaching Assistant (5040) Research Assistant (5041) Research Fellow (5044) Teaching Fellow (5048) Teaching Asst Summer (5049) Research Assistant Summer (5070) Predoc and Ed Fellow Student Aid Predoc Trainee and Ed Fellowship (5045-46) Tuition TA/RA/TF/RF (4187-89,4191,5360) Endowment Income UG Aid Endowment Trans Transfers UG Aid Incentive Student Aid UG Aid Grad & Prof Aid Tuition TA/RA/TF/RF Nomenclature and Time Periods Nomenclature Scenarios: Budget, Actual, Forecast Versions: Winter, Spring, Summer Actuals for current and prior year Budget for next and 4 future years ADJ incorporated into June Separate reporting cube Ability to report on more prior years and in more detail than we display in Planning Pre-Populating the Forecast Keep Original Budget intact for comparative purposes Start with Original Budget broken down by month Replace individual months with actuals at month end Each quarter responsibility centers review and revise forecast based on YTD actuals and expectations Subsequent quarters start with prior forecast updated for new actuals Detailed Salary Planning As in Pillar, Responsibility Centers can elect to build up salary plans person by person, or can budget in a lump sum Payments to Faculty and Staff will be pre-populated by person Planning for Graduate Students, PostDocs, Student workers and temps will not be done by person This initial implementation will not replace SALINC feed to payroll. That would be a future project Status Update Prototype Developed Revenue and Expense Salaries History Reporting Data Entry Forms Interfaces To Do and To Solve Still Pending EB Calculation Input Assumptions GAAP Reporting Prototype Evaluation Report/Data Entry Form missing link Data Entry Issue: Pillar wasn’t so bad Performance Progress, but still some issues Testing throughout University/Health System UNIVERSITY REVENUE AND EXPENSE PLAN HEALTH SYSTEM REVENUE AND EXPENSE PLAN (Ben 26 digits) (Lawson Accounts) School of Medicine Clinical Dept User UNIVERSITY SALARY PLAN University Paid Employees (Ben 26 digits) HEALTH SYSTEM SALARY PLAN Health System Paid Employees (Lawson Accounts) Users Types Planners (231) Interactive (20) View Only (36) Numbers: Responsibility Centers need to evaluate deployment Security Designed and Tested using Prudence IDs LDAP server under development Will facilitate single sign on (transitioning to PennKey) Need to identify users for initial rollout Revenue and Expense security modeled on BEN security Salary security Based on the paying org: if you pay a person you see that component of their salary Training Training Outline Advanced Chart of Accounts (Quiz: pass to move on) Org-Program-CREF Fund Groups Org Parents RCM Rows Budget Guidelines: University and School specific (Quiz) Hyperion Web-based (includes multiple exercises and quiz) Individual and Proctored Group format Penn Specific Examples available via Help College of Philadelphia graded exercise School based follow-up: school specific issues, additional coaching as needed Timetable December rollout for some senior BAs for possible use in January (Winter). How many will depend on performance and training Forecasts Budget Likely that most departmental users will still be on Pillar in January (Winter). Some departmental users will use Planning this Spring, but probably some will still be on Pillar. In those cases, Pillar plans will be loaded into Planning after submission. Input assumptions will still be in Excel for January (Winter) GAAP reporting coming later Communication Thursdays at 4:00: The Planning Open House. Anyone can come and see what has been accomplished during the previous week (but call first if you’re coming!) Web site: Budget Office web site will have a Planning Update link Periodic e-mail updates to participants and Responsibility Center senior BAs We value your feedback: [email protected] or any of the Budget Office staff
© Copyright 2024