FY 2021 Budget Kickoff February 21, 2020
Agenda • Introductions • Budget Update • FAMIS Re-Platform Update • Dates & Reminders • Phase II Update • Resources • Discussion & Questions
BUDGET UPDATE
State Budget Overview Legislative Budget Board
Distribution of Texas General Revenue by Function Source: LBB
GR Funding by University System (Academics Only) $5.3B University of North Independents Texas State University Texas System 7% System 5% 9% University of Houston System 10% Texas A&M University System 28% University of Texas Texas Tech University System System 34% 7% 2020-21 Biennium
GR Funding by University System (Academics + Health Related) $8.4B Independents University of North Texas Texas State University 4% System System 6% 6% University of Houston System Texas A&M University 6% System 21% Texas Tech University System 10% University of Texas System 47% 2020-21 Biennium
Growth in TAMU Enrollment 70,000 65,000 Students 60,000 55,000 2001: 44K 50,000 2019: 63.7K 45,000 40,000 35,000 30,000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Fall Undergraduates
Growth in TAMU Expense Budget $2,000 Millions $1,800 $1,600 $1,400 1995: $500M $1,200 2006: $1B 2016: $1.5B $1,000 2020: $1.9B 2021: ? $800 $600 $400 $200 $0 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 TAMU Board Budgets (Including Debt)
State Funding vs. Tuition & Fees as a % of Total Revenues Tuition Deregulation 40.0% 35.0% Tuition & Fees 30.0% 25.0% Appropriations 20.0% 15.0% 10.0% 5.0% 0.0% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 TAMU Board Budgets
Revenue by Source Total Revenues (in millions) $2,046.9 FY2020 Board Budget
Expenses by Category Total Expenses (in millions) $1,966.1 FY2020 Board Budget
Budget Trivia • 4367 Budgeted expense categories • 1883 Expense budgets by account • 710 Revenue budgets by account • 257 Expense budgets by department • 1693 New FAMIS accounts • Largest Budget: $110.9M • Smallest Budget: $1 2020 Done Budget
FAMIS Re-Platform Update
FAMIS Re-Platform Update • High level of risk with current FAMIS system • Based on code licensed by company in Germany that no longer provides support • Attrition of support staff knowledgeable with source code • Renewed interest in new finance system after Workday HCM was implemented • Evaluated PeopleSoft (Oracle), Banner & Workday • Settled on Workday • Barriers: • High cost • Maturity of Workday Financials • Considered other options: re-platforming FAMIS
FAMIS Re-Platform Update • Advantages • Lower cost than new system • Leverage current and future staff • Easier to hire new staff familiar with new code • Keep current add-on systems • Concur • Aggie Buy • Maestro • Canopy • Keep current integrations with Workday HCM and Data Warehouse
FAMIS Re-Platform Update Convert 4M lines of code to new language • Phase I – Proof of Concept - completed • Phase II – Conversion • Feb 2020 – Conversion begins • Oct 2020 – Data fully converted, testing begins • June 2021 – Integrated testing • Feb 2022 – Go live • Phase III – Modernization • Investment in enhanced reporting • Canopy enhancements • Improve/replace Budget & Annual Financial Report Modules
DATES & REMINDERS
Budget Dates Feb 24 (Mon) Phase 1 Begins Budget Guidelines posted FAMIS Budget Module open for entry Central allocations available in FAMIS Mar 2 (Mon) Distribution of Variance Analysis Reports begins March 6 (Fri) Phase I Ends FAMIS Budget Module closes for departmental entry Variance Analysis due to Budget Office Mar 9-13 Spring Break Mar 18 (Wed) Budget due to System Office of Budgets & Accounting TBD Phase II Begins
What you need to know … • Guidelines posted on our website • President has authorized a 2% merit program • 2088 Working Hours • Estimated Benefit Rate Percentages • Percent of salary dollars Faculty 22.5 Staff 29.8 Grad Student 9.2 Student 1.4 • E&G Benefits paid at colleges/divisions
Reminders-Phase I • No beginning balances on E&G, DT, UAF (many SL’s to one GL accounts) • Budget enough in expense dollars to cover salaries in Phase II • If you need to utilize a beginning balance as a source of funding for salaries in Phase II, you must budget that BB in Phase I • We will reconcile beginning balance, revenue & expenses by fund group
Reminders-Phase I • Budget merit in Unallocated Faculty or Non-Faculty Merit • Re-allocated in Phase II • Budget new planned positions in Unallocated Salaries • Positions not yet created in Workday • Will feed to Budget Pool 1005 in FAMIS • Please … no pennies in budgets or allocations/transfers • Let us know if you have any NO FEED accounts • Contact FMO Access & Security if you have budget access issues in FAMIS
PHASE II UPDATE
Phase II Tentative Dates April 1 Statement of Responsibility Forms Due for PBA and Workday Merit Planner May 11th Snapshot from Workday loaded to PBA May/July (TBD) PBA Access July 6th FAMIS budget module opens and daily salary feeds begin July 31st FAMIS budget module closes to users August 3rd Workday Merit Launched August 12th Workday Merit submitted by units August 15 th One-Time Merit templates due August 17th Merit is finalized in Workday
Enhancements/Changes • Merit Planner role expanded • PBA available earlier • File upload capability to PBA • EIB upload from PBA to Workday Merit • Workday Merit module upgrades • Reporting
RESOURCES
Resources available on website • Budget Module Refresher • Budget Workpaper • Budgeting Business Rules • Budget Screen Information • Budget Module Training Presentation • Merit 2020 Preview Webinar March 25th
Contacts Hotline: 845-8145 E-mail: budget@tamu.edu Website: budget.tamu.edu Mark Herzog 862-2371 herzog@tamu.edu Shelly Janac 458-2882 s-janac@tamu.edu Tracy Foster 862-2364 tfoster211@tamu.edu Katy Pleasant 862-1732 katy.pleasant@tamu.edu Deborah Wright 862-1622 deb-wright@tamu.edu
Don’t panic … everything is fixable
Recommend
More recommend